Convert ITN to PARQUET
Turn ITN 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 ITN files on the dialor turn it to pick what to do
A TomTom itinerary as a table of shapes and points.One GeoParquet file with a row for each feature, shapes in a geom column and attributes beside it.
What you get
A single GeoParquet file with one row for each feature. Each shape is stored as WKB in a geom column. GeoParquet metadata describes it with its geometry types, bounding box and coordinate system.
The coordinate system of the source is kept. Every attribute becomes a column, and lists and nested values stay as Parquet lists and structs.
How features are shaped
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. 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.
Layers and links between rows
A layer column names the GPX layer each feature comes from: waypoints, routes, tracks, route_points or track_points. Filter on it to pick out one kind of feature.
The track_fid and route_fid columns tie each point to its track or route. Heights stay in the shapes as Z and in the ele column of points. Columns that no feature fills are left out of the file.
ITN and PARQUET.What each format is.
The formats
TomTom Itinerary
TomTom itineraries, the planned stops a TomTom navigator drives through in order.
- Extensions
- .itn
- MIME type
- application
/x -tomtom -itn - Kind
- Text and data
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 ITN to PARQUET conversion through the API, for your app or your agent.
$ cv convert report.itn report.parquet$ cv convert report.itn report.parquetQuestions.What people ask about ITN to PARQUET.
Use the layer column. Its values are waypoints, routes, tracks, route_points and track_points.
Read track_fid for track points and route_fid for route points. Each one ties the point to its track or route.
Yes. They stay in the shapes as Z and in the ele column of points.
Yes. Route and track points have their time in UTC, along with the values the device logged, such as satellites, hr and cad.