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.
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.
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.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
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
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.
$ cv convert report.esrijson report.parquet$ cv convert report.esrijson report.parquetQuestions.What people ask about ESRIJSON to PARQUET.
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.