Convert GTFS to PARQUET
Turn GTFS files into PARQUET. A GeoParquet file with one row for each feature: its shape as WKB in a geom column that GeoParquet metadata describes with its geometry types, bounding box and coordinate system, then every attribute as a column, with lists and nested values kept as Parquet lists and structs.
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 GeoParquet file.Stops become points and routes become lines, each with all of its columns.
What you get
One GeoParquet file with a row for each feature. The shape is stored as WKB in a geom column. GeoParquet metadata describes it with its geometry types, bounding box and coordinate system.
Every attribute becomes its own column. Lists and nested values stay as Parquet lists and structs. The coordinate system of the source is kept.
How stops and routes are drawn
Stops become points with all their columns. Each route becomes a line with its columns.
A route is drawn along the shapes its trips follow. For trips without a shape, the line runs through their stops in order.
One file, several layers
Stops and routes are joined into one file. A layer column names where each feature came from, so you can tell the points from the lines.
To combine several PARQUET files afterward, use merge PARQUET.
GTFS and PARQUET.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
Parquet
The columnar data format of analytics. Compressed, typed and fast to scan.
- Extensions
- .parquet .pq
- MIME type
- application
/vnd .apache .parquet - Kind
- Text and data
In your code.The same GTFS to PARQUET conversion through the API, for your app or your agent.
$ cv convert report.gtfs.zip report.parquet$ cv convert report.gtfs.zip report.parquetQuestions.What people ask about GTFS to PARQUET.
One feature. It holds its shape in the geom column and its attributes in the other columns.
Along the shapes their trips follow. If a trip has no shape, the line goes through its stops in order.
No. They are joined into one file. The layer column tells you which layer each feature came from.
Yes. The coordinate system of the source is kept and described in the GeoParquet metadata.