Convert TCX to PARQUET

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

Training logs as a GeoParquet table.One row for each feature, with its shape and every attribute in columns.

  1. What you get

    One GeoParquet file. Each row is one feature. Its shape is stored as WKB in a geom column, and GeoParquet metadata describes the geometry types, the bounding box and the coordinate system. The source's coordinate system is kept.

    Every attribute becomes a column. Lists and nested values stay Parquet lists and structs. Columns that no feature fills are left out.

  2. How activities become rows

    Each activity becomes a track named after its start time. Each course becomes a track under its own name. Times, heights, heart rate and cadence are kept. Lap starts and course points become waypoints.

    Waypoints become points, routes become lines, and tracks become multilines with a part for each segment. Every route and track point also becomes a point of its own. It carries its time in UTC and the values the device logged with it, such as satellites, heart rate as hr and cadence as cad.

  3. Telling the rows apart

    A layer column names the GPX layer each feature comes from: waypoints, routes, tracks, route_points or track_points. Filter on it to pull out only the track points, for example.

    track_fid and route_fid tie each point to its track or route. Heights stay in the shapes as Z and in the ele column of points.

  4. What is dropped

    Speed, calories, notes and device details are not carried over.

TCX and PARQUET.What each format is.

The formats

From · TCX

TCX

Garmin training logs with laps, heart rate and GPS.

Extensions
.tcx
MIME type
application/vnd.garmin.tcx+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 TCX to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.tcx report.parquet
$ cv convert report.tcx report.parquet

Questions.What people ask about TCX to PARQUET.

01OF 04

Yes. The conversion produces one file, with all features in it.

Yes. Each track point carries heart rate as hr and cadence as cad, along with its time in UTC.

No. Speed, calories, notes and device details are dropped.

Use track_fid for track points and route_fid for route points. The layer column tells you which kind each row is. To combine several outputs, you can merge PARQUET.

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