Convert GPX to PARQUET

Turn GPX 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 GPX files on the dialor turn it to pick what to do

GPX tracks as a GeoParquet table.One row for each waypoint, route, track and logged point.

  1. What you get

    One GeoParquet file with a row for each feature. The shape is stored as WKB in a geom column, and GeoParquet metadata describes its geometry types, bounding box and coordinate system. The coordinate system of the GPX file is kept.

    Every attribute becomes a column. Lists and nested values stay as Parquet lists and structs.

  2. How features map

    Waypoints become points, routes become lines, and tracks become multilines with a part for each segment. Every route point and track point also becomes a point of its own.

    A layer column names the GPX layer each row comes from: waypoints, routes, tracks, route_points or track_points. The track_fid and route_fid columns tie each point to its track or route.

  3. Point details

    Points carry their time in UTC and the values the device logged with them, such as satellites, heart rate as hr and cadence as cad. Heights stay in the shapes as Z and in the ele column of points.

    Columns that no feature fills are left out, so the table only holds columns with data.

GPX and PARQUET.What each format is.

The formats

From · GPX

GPX

GPS tracks, routes and waypoints in XML.

Extensions
.gpx
MIME type
application/gpx+xml
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 GPX to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.gpx report.parquet
$ cv convert report.gpx report.parquet

Questions.What people ask about GPX to PARQUET.

01OF 04

Yes. Heights stay in the shapes as Z and in the ele column of points.

Use the layer column. Its values are waypoints, routes, tracks, route_points and track_points.

Yes, when the device logged it. It appears as hr on the points, and cadence appears as cad.

Yes. The track_fid column ties each point to its track, and route_fid does the same for routes.

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