The blog organizes my application notes of GTFS as a table of contents for rapid access at any time in the future.
The General Transit Feed Specification (GTFS) defines a common format for public transportation schedules and associated geographic information. GTFS “feeds” allow public transit agencies to publish their transit data and developers to write applications that consume that data in an interoperable way. (excerpt from here)
1. Import GTFS into MySQL
- Install MySQL in Ubuntu: 将GTFS格式的公共交通调度数据导入MySQL
- Connect to MySQL with Python: 用Python操作MySQL数据库
Import GTFS into MySQL: 将GTFS格式的公共交通调度数据导入MySQL