Swisstrains.ch: Present, past and future
0 likes1,285 views
- Today: A demonstration of a real-time vehicle tracking system from 2011 using data from 2007-2011. - Past: The system has evolved from using text files in the 90s to relational databases in 2007-2008 and Fusion Tables in 2010. Graphics and data integration tools have also improved. - Future: Potential next steps include expanding to more cities, using open data, improving the website swisstrains.ch, integrating newer APIs, and developing more complex simulations.
Swisstrains.ch: Present, past and future
- 1. Swisstrains.ch Present, past and future Vasile Cotovanu Z端rich, webtuesday.ch Jan 10, 2012
- 2. Agenda Today Past Next Q &A 90s 2007 2008 2009 2010 2011 2012+
- 3. Today 2011 DEMO
- 4. Layers 2011
- 5. Layers 2011
- 6. Layers 2011
- 7. Layers 2011 DEMO
- 8. Make them move ! 2007 - 2011 Live positions ? map.local.ch vehicle simpleservice JS Vehicle Tram2 A S1 S2 13:26 S3 B 13:10 13:14 13:22 13:30 13:35 74% 55% Polylines S2 - S3 S3 S2
- 9. 2007-2011 Got data ? Components (Relational) database (SBB timetables) Graphics database (stations and lines)
- 10. Text: vehicle-link-station(2007)-2011 stations station vehicle vehicles station_id stops link vehicle_id name many-many name vehicle_id station_id departure DEMO
- 11. Text: vehicle-link-station (2007)-2011 stations station vehicle vehicles station_id stops link vehicle_id name many-many name vehicle_id station_id departure SBBCFR 18171485 150470 20822 13232 1312 DEMO
- 12. Text: populate link, vehicle 2008 stations vehicles vehicle vehicle_id name stops link many-many vehicle_id station_id departure DEMO
- 13. All stations 2008
- 14. All stations 2008
- 15. All stations 2008
- 16. All stations 2008
- 17. All stations 2008 boat bus cablecar train tram stations 265 18,797 549 1,810 477 21,898 vehicles 2,534 144,150 220,669 16,498 18,461 402,312 stops 8,013 2,433,815 447,806 177,520 417,510 3,484,664
- 18. Vectors database 2007-2011 DEMO
- 19. Fusion Tables 2010 DEMO
- 20. Integrate DBs 2007 2011
- 21. Changes roundup 2007 2011 Textual DB crawler PHP, MySQL, Ruby, SQLite Map Engine GMaps API v2, custom (messy) map helpers v3 API, geometry library Map layers Own generated polylines, points Fusion Tables JS Engine Mess :) No 3rd party library More structured, ordered + jQuery UX, page speed, looknfeel OK-ish (in the beginning) IT ROCKS BIG TIME ! Graphics DB tools Geomedia + swisstopo layers QGIS, OpenLayers, GMaps, GEarth, etc DBs integration tools FME, ODBC, MS Access :) Ruby, GDAL Versioning Power of CTRL-Z Git - master/dev/sbb/cfr
- 22. Build yourself ! DEMO git clone git@github.com:vasile/vehicle-simulator.git
- 23. One more feature ! 2011 Backlinking: follow vehicle by name Inject a custom vehicle (i.e. MySuperTrain) DEMO
- 27. Next steps Lausanne, watch out :) #opendata swisstrains.ch GeoAdmin API (Swisstopo) Simcity-like ? (Remember local.ch Live Trams ?)
- 28. Thanks ! http://www.vasile.ch http://twitter.com/vasile23 https://github.com/vasile