Convert WPT to PARQUET

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

Waypoints, routes and tracks as GeoParquet.One row for each feature, with its shape and every attribute in a column.

  1. What you get

    A single GeoParquet file with one 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 source's coordinate system is kept.

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

  2. How features map

    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. Each 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 GPX layer each feature comes from: waypoints, routes, tracks, route_points or track_points. Filter on it to pull out one kind of feature.

    track_fid and route_fid tie each point to its track or route, so you can group points back into the line they belong to.

WPT and PARQUET.What each format is.

The formats

From · WPT

OziExplorer Waypoints

Waypoints saved by OziExplorer, a mapping program for GPS receivers and paper maps.

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

terminal
$ cv convert report.wpt report.parquet
$ cv convert report.wpt report.parquet

Questions.What people ask about WPT to PARQUET.

01OF 04

Yes. The source's coordinate system is kept, and the GeoParquet metadata describes it.

Filter the layer column for waypoints. Routes, tracks, route_points and track_points each have their own value in the same column.

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

No. The conversion produces one file that holds every layer.

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