Convert ESRIJSON to CSV
Turn ESRIJSON files into CSV. A CSV with one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop ESRIJSON files on the dialor turn it to pick what to do
A table of features, one row each.Shapes become WKT in the first column. Attributes follow as columns.
What you get
A CSV with one row for each feature. The first column is named WKT and holds the feature's shape as WKT. Every attribute then becomes its own column.
The result is one file.
What changes
Coordinates are written in WGS 84 longitude and latitude. If the source uses another system, such as Korea's EPSG:5186, the coordinates are converted. If the data names no system, the coordinates stay as they are.
Lists and nested values become JSON text, since a CSV cell holds a single value.
Edge cases
A feature without a geometry keeps its row, and its WKT cell is empty. If an attribute is already named WKT, that column is renamed WKT_1 so the shape column keeps its name.
To combine several results afterward, see merge CSV.
ESRIJSON and CSV.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
CSV
Rows of comma-separated values. The plainest way to move a table between programs.
- Extensions
- .csv
- MIME type
- text
/csv - Kind
- Text and data
In your code.The same ESRIJSON to CSV conversion through the API, for your app or your agent.
$ cv convert report.esrijson report.csv$ cv convert report.esrijson report.csvQuestions.What people ask about ESRIJSON to CSV.
It is in the first column, named WKT, written as WKT text.
Yes, when the source names a system. They are converted to WGS 84 longitude and latitude. If no system is named, they stay as they are.
They keep their row. The WKT cell is empty.
Lists and nested values are written as JSON text in their cell.