Convert OV2 to PARQUET

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

A GeoParquet file with one row per feature.Shapes are stored as WKB, and every attribute becomes a column.

  1. What you get

    One GeoParquet file with a row for each feature. The shape sits as WKB in a geom column. GeoParquet metadata describes that column with its geometry types, bounding box and coordinate system.

    Every attribute becomes its own column. Lists and nested values stay as Parquet lists and structs. The source's coordinate system is kept.

  2. Shapes and points

    Waypoints become points, routes become lines, and tracks become multilines with one part for each segment.

    Every route point and track point also becomes a point of its own. These 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 the points.

  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 columns that have values.

OV2 and PARQUET.What each format is.

The formats

From · OV2

TomTom POI

TomTom OV2 files of points of interest, such as speed cameras or favorite places.

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

terminal
$ cv convert report.ov2 report.parquet
$ cv convert report.ov2 report.parquet

Questions.What people ask about OV2 to PARQUET.

01OF 04

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

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

Read the layer column. It names the layer of each feature: waypoints, routes, tracks, route_points or track_points.

Columns that no feature fills are left out of the file.

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