Skip to content

Latest commit

 

History

History
23 lines (18 loc) · 728 Bytes

README.md

File metadata and controls

23 lines (18 loc) · 728 Bytes

GtfsToSql

Parses a GTFS feed into an SQL database

Installation

If you're using Eclipse and willing to rebuild the project, you need to:

  1. File, Import
  2. Select 'Existing projects into workspace'
  3. Select the directory in 'Select root directory'

Usage

java -jar GtfsToSql.jar -s jdbc:sqlite:/path/to/db.sqlite -g /path/to/extracted/gtfs/

Notes

  • Only supports Sqlite and PostgreSQL currently
  • GTFS file must be extracted already, and perimetre-tr-plateforme-stif.txt file moved to the directory where it has been extracted
  • All columns are mapped saved as 'text' (that is, not parsed, modified or typecast)

Table names are the same as filename in the GTFS file (without the .txt)