Convert PLT to PARQUET

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

A GeoParquet file with one row per feature.Shapes, attributes and the logged GPS values all land in typed columns.

  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. The coordinate system of the source 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 the track becomes rows

    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.

    Those points carry their time in UTC and the values the device logged with them, 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.

  3. Tying rows together

    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.

    To combine several results into one file, use merge PARQUET.

PLT and PARQUET.What each format is.

The formats

From · PLT

OziExplorer Track

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

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

terminal
$ cv convert report.plt report.parquet
$ cv convert report.plt report.parquet

Questions.What people ask about PLT to PARQUET.

01OF 04

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

A track becomes a multiline with a part for each segment. Each track point also becomes a point of its own, tied to its track by track_fid.

Yes. Values the device logged with a point, such as heart rate as hr and cadence as cad, become columns on that point.

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

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