forked from torstehu/py-gtfs-postgres
-
Notifications
You must be signed in to change notification settings - Fork 0
Converts GTFS text files into postgres format, modified from https://github.com/sbma44/py-gtfs-mysql
sensix/py-gtfs-postgres
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
Uses sample data from Chicago Transit Authority (CTA), downloaded on 1-30-2011. Code should be modified for other database, sets of data. Make sure pg is installed for python cccta=# create schema gtfs; CREATE SCHEMA cccta=# create user gtfs superuser; CREATE ROLE cccta=# Update load-gtfs.py to agency name that matches the folder with the GTFS files in it - this will also be used as the agency ID Mapnik: select distinct _agency_id||coalesce(agency.agency_name,'')||b.description from routes join route_types b using (route_type) join agency using (_agency_id,agency_id);
About
Converts GTFS text files into postgres format, modified from https://github.com/sbma44/py-gtfs-mysql
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published