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.

  1. 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.

  2. 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.

  3. 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

From · GTFS

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
To · PARQUET

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.

terminal
$ cv convert report.gtfs.zip report.parquet
$ cv convert report.gtfs.zip report.parquet

Questions.What people ask about GTFS to PARQUET.

01OF 04

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.

More conversions.Other ways in and out of GTFS and PARQUET.