Convert FIT to PARQUET
Turn FIT 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 FIT files on the dialor turn it to pick what to do
A GeoParquet file with one row per feature.Waypoints, routes and tracks become shapes, and every track point becomes a point with its logged values.
What you get
One Parquet file with one 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, and the source's coordinate system is kept.
Every attribute becomes its own column. Lists and nested values are kept as Parquet lists and structs. Columns that no feature fills are left out.
Shapes and points
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 layer each feature comes from: waypoints, routes, tracks, route_points or track_points. The columns track_fid and route_fid tie each point to its track or route.
Time, heights and logged values
Each route and track point carries its time in UTC. It also carries the values the device logged with it, 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.
To put several of the resulting files into one, use merge PARQUET.
FIT and PARQUET.What each format is.
The formats
Garmin FIT
The binary activity format of Garmin and most fitness watches.
- Extensions
- .fit
- MIME type
- application
/vnd .ant .fit - 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 FIT to PARQUET conversion through the API, for your app or your agent.
$ cv convert report.fit report.parquet$ cv convert report.fit report.parquetQuestions.What people ask about FIT to PARQUET.
Yes. Each route and track point keeps the values the device logged with it, such as heart rate as hr and cadence as cad.
Use the layer column. It names the layer each feature comes from: waypoints, routes, tracks, route_points or track_points.
Yes. They stay in the shapes as Z and in the ele column of points.
Use track_fid for track points and route_fid for route points. Each ties the point to the track or route it belongs to.