Convert GPI to PARQUET

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

Garmin POIs as a GeoParquet table.One row for each feature, with its shape, its attributes and its coordinate system.

  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 it with its geometry types, bounding box and coordinate system. Every attribute becomes a column. Lists and nested values stay as Parquet lists and structs.

    The coordinate system of the source is kept. Columns that no feature fills are left out.

  2. How shapes map

    Waypoints become points. Routes become lines. Tracks become multilines with a part for each segment.

    Every route point and track point also becomes a point of its own. Each one carries its time in UTC and 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. In points they are also in the ele column.

  3. Telling features apart

    A layer column names the layer each feature comes from: waypoints, routes, tracks, route_points or track_points. Filter on it to pull out one kind of feature.

    The track_fid and route_fid columns tie each point to its track or route. Use them to group points back into the line they belong to.

GPI and PARQUET.What each format is.

The formats

From · GPI

Garmin POI

Points of interest that Garmin car and handheld navigators load as custom POI files.

Extensions
.gpi
MIME type
application/x-garmin-gpi
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 GPI to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.gpi report.parquet
$ cv convert report.gpi report.parquet

Questions.What people ask about GPI to PARQUET.

01OF 04

Yes. The coordinate system of the source is kept and described in the GeoParquet metadata.

Filter the layer column to waypoints. Each feature has its layer named there.

Yes. Heights stay in the shapes as Z, and points also have them in the ele column.

Yes. The track_fid column ties each track point to its track, and route_fid does the same for routes. To combine several outputs, you can merge PARQUET.

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