We continue to develop resources related to the COVID-19 pandemic. See COVID-19 initiatives on Appropedia for more information.

OSSTIP/Loading GTFS to a GIS database

From Appropedia
Jump to navigation Jump to search

(Notes on attempt so far to load GTFS data into a GIS database as part of OSSTIP project)

Trying the gtfsdb (on Mac Os X):[edit]

1) Install psycopg2 (A Python interface to PostgreSQL):

  • sudo easy_install psycopg2

2) Install GeoAlchemy

  • easy_install -D "SqlAlchemy <= 0.5.8"
  • easy_install GeoAlchemy

3) Check out and install gtfsdb:-

So next step, is probably to install PostgreSQL, with PostGIS enabled. Then see if I can export/load the GTFS data into a PostgreSQL database for proper analysis work.