Convert GDB to PARQUET

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

Garmin tracks and waypoints as rows.One GeoParquet file, with a row for each feature and a column for each attribute.

  1. What you get

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

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

  2. How shapes are mapped

    Waypoints become points, routes become lines, and tracks become multilines with a part for each segment. Heights stay in the shapes as Z and in the ele column of points.

    Every route point 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 features apart

    A layer column names the layer each feature 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.

    Filter on layer to pull out only the waypoints, or only the points of the tracks.

GDB and PARQUET.What each format is.

The formats

From · GDB

Garmin MapSource Database

Waypoints, routes and tracks saved by Garmin MapSource and BaseCamp in their GDB database.

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

terminal
$ cv convert report.gdb report.parquet
$ cv convert report.gdb report.parquet

Questions.What people ask about GDB to PARQUET.

01OF 04

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

Filter the layer column for track_points. The track_fid column tells you which track each point belongs to.

Yes, when the device logged them. They appear as the hr and cad columns on the route and track points, along with the time in UTC and values such as satellites.

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

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