Convert KML to PARQUET

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

KML placemarks as a GeoParquet table.One row for each feature, with its shape and attributes in columns.

  1. What you get

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

    Every attribute becomes its own column. Lists and nested values are kept as Parquet lists and structs, so they stay structured instead of being flattened into text.

  2. What stays the same

    The coordinate system of the KML is kept. The GeoParquet metadata records it, so tools that read the file know where the shapes sit.

  3. Several layers

    If the KML holds several layers, they are joined into one table. A layer column names the layer each feature came from, so you can still tell them apart. The result is one file.

    To combine the result with other Parquet files, you can merge PARQUET. For more routes, see every KML conversion.

KML and PARQUET.What each format is.

The formats

From · KML

KML

Placemarks, paths and polygons for Google Earth.

Extensions
.kml
MIME type
application/vnd.google-earth.kml+xml
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 KML to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.kml report.parquet
$ cv convert report.kml report.parquet

Questions.What people ask about KML to PARQUET.

01OF 04

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

The layers are joined into one table. A layer column names where each feature came from.

In the geom column, stored as WKB. The metadata describes it with its geometry types, bounding box and coordinate system.

No. Lists and nested values are kept as Parquet lists and structs.

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