Convert ESRIJSON to PARQUET

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

Esri JSON as a GeoParquet file.One row per feature, with its shape and every attribute as columns.

  1. What you get

    A GeoParquet file with one row for each feature. The shape is stored 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 are kept as Parquet lists and structs, so they are not flattened into text.

    The conversion gives you one file.

  2. Coordinate system

    The coordinate system of the source is kept. You do not need to reproject the data to read it back with its original system.

    Some Esri JSON names no coordinate system. In that case the data is taken as WGS 84 when its coordinates fit. When they do not fit, the conversion stops with unsupported_elements.

  3. Next steps

    Once the data is in Parquet, you can join several files with merge PARQUET. For other ways to produce this format, see every PARQUET conversion.

ESRIJSON and PARQUET.What each format is.

The formats

From · ESRIJSON

Esri JSON

Features with their attributes, geometry type and spatial reference, as ArcGIS REST services return them for a query with f=json.

Extensions
.esrijson
MIME type
application/x-esri+json
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 ESRIJSON to PARQUET conversion through the API, for your app or your agent.

terminal
$ cv convert report.esrijson report.parquet
$ cv convert report.esrijson report.parquet

Questions.What people ask about ESRIJSON to PARQUET.

01OF 04

Yes. Every attribute becomes a column. Lists and nested values stay as Parquet lists and structs.

In a geom column, as WKB. GeoParquet metadata describes it with its geometry types, bounding box and coordinate system.

The data is taken as WGS 84 if its coordinates fit. If they do not, the conversion stops with unsupported_elements.

No. The coordinate system of the source is kept.

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