No description, website, or topics provided.
Ruby JavaScript HTML CSS ApacheConf
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
inc
map
resources/sql
.gitignore
README.md
Rakefile

README.md

Swiss Public Transport Stations

This script extracts the list of the public transport stations of Switzerland from the dataset offered by www.fahrplanfelder.ch. The main output of the script is a SQLite DB defined using the schema defined in resources/sql/01-schema.sql

Steps:

  • clone this repo
  • download and unzip the latest data from http://www.fahrplanfelder.ch
  • update the FPLAN_PATH in the Rakefile
  • run
    • rake import_sqlite:all

Screenshot

  • yes, the whole parsing takes 30" on my ordinary MacBook Air machine :o)

  • check the output in tmp/sbb-pois.db

Screenshot

The simplest way to visualize the data is to export the SQLite content in a GeoJSON file using rake export:geojson task which generates a GeoJSON file in map/stops.geojson and that can be visualized if you access the map/ in a browser.

DEMO example: maps.vasile.ch

Screenshot

Feedback

Contact me via this form or Twitter.