Convert GTFS to CSV
Turn GTFS files into CSV. A CSV with one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop GTFS files on the dialor turn it to pick what to do
A transit feed as one table of shapes.Every stop and route becomes a row, with its outline as WKT in the first column.
What you get
One CSV file with one row for each feature. The first column is named WKT and holds the feature's shape. Every attribute follows as its own column.
Stops become points and keep all their columns. Each route becomes a line with its columns. Coordinates are written in WGS 84 longitude and latitude.
How routes are drawn
A route follows the shapes its trips use. For trips without a shape, the line runs through their stops in order.
Because stops and routes are different layers, they are joined into one table. A layer column names where each row came from.
What changes
Features without a geometry keep their row, with an empty WKT. If a column is already named WKT, it is renamed WKT_1 so the shape column stays first.
Lists and nested values become JSON text, so they fit in a single cell.
To combine the result with other tables, see merge CSV. For other options, see every CSV conversion.
GTFS and CSV.What each format is.
The formats
GTFS Feed
A transit agency's stops, routes, trips and timetables as the zip of GTFS text files that Google Maps and trip planners read.
- Extensions
- .gtfs.zip
- MIME type
- application
/x -gtfs +zip - Kind
- Text and data
CSV
Rows of comma-separated values. The plainest way to move a table between programs.
- Extensions
- .csv
- MIME type
- text
/csv - Kind
- Text and data
In your code.The same GTFS to CSV conversion through the API, for your app or your agent.
$ cv convert report.gtfs.zip report.csv$ cv convert report.gtfs.zip report.csvQuestions.What people ask about GTFS to CSV.
It holds the shape of each feature as WKT. Stops are points and routes are lines, in WGS 84 longitude and latitude.
One file. The layers are joined, and the layer column shows whether a row came from stops or routes.
They stay in the file with an empty WKT.
It is renamed WKT_1, and the new shape column is named WKT.