Convert USR to PARQUET

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

Waypoints, routes and trails as one table.One GeoParquet file with a row for each feature and a column for each attribute.

  1. What you get

    A single GeoParquet file. Each row is one feature. Its shape is stored as WKB in a geom column, and the 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 its own column. Lists and nested values stay as Parquet lists and structs.

  2. How features are shaped

    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 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.

  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.

    Columns that no feature fills are left out, so the file holds only the columns your data uses. To combine several results, you can merge PARQUET files.

USR and PARQUET.What each format is.

The formats

From · USR

Lowrance USR

Waypoints, routes and trails saved by Lowrance fish finders and chart plotters.

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

terminal
$ cv convert report.usr report.parquet
$ cv convert report.usr report.parquet

Questions.What people ask about USR to PARQUET.

01OF 04

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

A track becomes a multiline with a part for each segment. Each of its points is also stored as a point of its own, with its time in UTC.

The layer column tells them apart. Its values are waypoints, routes, tracks, route_points and track_points.

Yes, when the device logged it. It appears as hr on the points, and cadence appears as cad. Columns that no feature fills are left out.

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