{"id":127327,"date":"2022-08-17T06:34:31","date_gmt":"2022-08-17T06:34:31","guid":{"rendered":"https:\/\/blog.finxter.com\/?p=583523"},"modified":"2022-08-17T06:34:31","modified_gmt":"2022-08-17T06:34:31","slug":"python-convert-geojson-to-csv","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2022\/08\/17\/python-convert-geojson-to-csv\/","title":{"rendered":"Python Convert GeoJSON to CSV"},"content":{"rendered":"\n
\n
\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n
5\/5 – (1 vote) <\/div>\n<\/div>\n

What is GeoJSON?<\/h2>\n

\"\ud83d\udca1\" GeoJSON<\/a> is an RFC standardized data format to encode geographic data structures such as Point, LineString, Polygon, MultiPoint, MultiLineString, and MultiPolygon. GeoJSON is based on the JavaScript Object Notation (JSON<\/a>). <\/p>\n

Example GeoJSON to CSV<\/h2>\n

Say, you have the following GeoJSON snippet:<\/p>\n

{ \"type\": \"FeatureCollection\", \"features\": [ { \"type\": \"Feature\", \"geometry\": {\"type\": \"Point\", \"coordinates\": [-75.343, 39.984]}, \"properties\": { \"name\": \"Location A\", \"category\": \"Store\" } }, { \"type\": \"Feature\", \"geometry\": {\"type\": \"Point\", \"coordinates\": [-80.24, 40.12]}, \"properties\": { \"name\": \"Location B\", \"category\": \"House\" } }, { \"type\": \"Feature\", \"geometry\": {\"type\": \"Point\", \"coordinates\": [ -77.2, 41.427]}, \"properties\": { \"name\": \"Location C\", \"category\": \"Office\" } } ] }<\/pre>\n
You want to convert it to the following CSV format:<\/p>\n
latitude,longitude,altitude,geometry,name,category\n39.984,-75.343,,Point,Location A,Store\n40.12,-80.24,,Point,Location B,House\n41.427,-77.2,,Point,Location C,Office<\/pre>\n
Python GeoJSON to CSV Conversion<\/h2>\n
The Python code to convert a GeoJSON to a CSV in Python uses a combination of the json<\/code> and csv<\/code> packages.<\/p>\n
import json\nimport csv geo_filename = 'my_file.json'\ncsv_filename = 'my_file.csv' def feature_to_row(feature, header): l = [] for k in header: l.append(feature['properties'][k]) coords = feature['geometry']['coordinates'] assert(len(coords)==2) l.extend(coords) return l with open(geo_filename, 'r') as geo_file: with open(csv_filename, 'w', newline='') as csv_file: geojson_data = json.load(geo_file) features = geojson_data['features'] csv_writer = csv.writer(csv_file) is_header = True header = [] for feature in features: if is_header: is_header = False header = list(feature['properties'].keys()) header.extend(['px','py']) csv_writer.writerow(header) csv_writer.writerow(feature_to_row(feature, feature['properties'].keys())) <\/pre>\n
You can either copy&paste this code and run it in the same folder as your GeoJSON (of course, after renaming the input and output filenames. <\/p>\n
Or you can check out this excellent GitHub<\/a> to get a more “scriptable” variant to be used in the command line. This code is inspired by the GitHub but simplified significantly.<\/p>\n
Example input:<\/strong><\/p>\n
{ \"type\": \"FeatureCollection\", \"features\": [ { \"type\": \"Feature\", \"geometry\": {\"type\": \"Point\", \"coordinates\": [-75.343, 39.984]}, \"properties\": { \"name\": \"Location A\", \"category\": \"Store\" } }, { \"type\": \"Feature\", \"geometry\": {\"type\": \"Point\", \"coordinates\": [-80.24, 40.12]}, \"properties\": { \"name\": \"Location B\", \"category\": \"House\" } }, { \"type\": \"Feature\", \"geometry\": {\"type\": \"Point\", \"coordinates\": [ -77.2, 41.427]}, \"properties\": { \"name\": \"Location C\", \"category\": \"Office\" } } ] }<\/pre>\n
Example output:<\/strong><\/p>\n
\n
\"\"<\/figure>\n<\/div>\n
GeoJSON to CSV in QGIS<\/h2>\n
In QGIS, if you have a map like this one (source<\/a>):<\/p>\n
\"\"<\/figure>\n
You can convert GEOJSON to CSV right within QGIS by clicking Export<\/code>, then Save Feature As<\/code> and select the Comma Separated Value [CSV] selector in the first dropdown menu.<\/p>\n
\n
\"enter<\/a>
(source<\/a>)<\/figcaption><\/figure>\n<\/div>\n
\n
\"enter<\/a>
(source<\/a>)<\/figcaption><\/figure>\n<\/div>\n
GeoJSON to CSV Online Converter<\/h2>\n
You can easily convert specific GeoJSON snippets to CSV using the following online converter:<\/p>\n
\n
\"\"<\/a><\/figure>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
5\/5 – (1 vote) What is GeoJSON? GeoJSON is an RFC standardized data format to encode geographic data structures such as Point, LineString, Polygon, MultiPoint, MultiLineString, and MultiPolygon. GeoJSON is based on the JavaScript Object Notation (JSON). Example GeoJSON to CSV Say, you have the following GeoJSON snippet: { “type”: “FeatureCollection”, “features”: [ { “type”: […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[857],"tags":[73,468,528],"class_list":["post-127327","post","type-post","status-publish","format-standard","hentry","category-python-tut","tag-programming","tag-python","tag-tutorial"],"_links":{"self":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/127327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/comments?post=127327"}],"version-history":[{"count":0,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/127327\/revisions"}],"wp:attachment":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media?parent=127327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/categories?post=127327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/tags?post=127327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}