Convert IGC to PARQUET

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

A flight log as a GeoParquet table.Each feature becomes a row, with its shape and its attributes as columns.

  1. What you get

    One GeoParquet file with a row for each feature. The shape is stored as WKB in a geom column. GeoParquet metadata describes it with the geometry types, the bounding box and the coordinate system, and 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 flight maps

    A flight that records both heights becomes two tracks with the same fixes, one with the pressure altitude and one with the GPS altitude. The pilot and glider header goes into the track description. A declared task becomes a route.

    Waypoints become points, routes become lines and tracks become multilines with a part for each segment. Heights stay in the shapes as Z.

  3. Points and layers

    Every route and track point also becomes a point of its own. It carries its time in UTC and the values the device logged with it, such as satellites, heart rate as hr and cadence as cad. Heights are also in the ele column of these points.

    A layer column names the GPX 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.

    For other conversions, see every IGC conversion or every PARQUET conversion.

IGC and PARQUET.What each format is.

The formats

From · IGC

IGC Flight Log

Glider and paraglider flight logs.

Extensions
.igc
MIME type
text/x-igc
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 IGC to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.igc report.parquet
$ cv convert report.igc report.parquet

Questions.What people ask about IGC to PARQUET.

01OF 04

Yes, when the flight records both. You get two tracks with the same fixes, one with the pressure altitude and one with the GPS altitude.

They go into the track description.

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

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

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