Skip to content

Instantly share code, notes, and snippets.

@ThomasG77

ThomasG77/README.md

Last active April 4, 2021 00:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ThomasG77/c4a8fcc25bf7f635562d8367e2a3a660 to your computer and use it in GitHub Desktop.
Save ThomasG77/c4a8fcc25bf7f635562d8367e2a3a660 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
README.md

Read nested element from GeoJSON and GDAL SQLite dialect

ogrinfo -dialect SQlite -sql "SELECT a_property, json_extract(some_object, '$.another_property') AS another_property, json_extract(some_object, '$.last_prop[1]') AS subarrayelement, geometry FROM demo" /tmp/demo.geojson

We use functions presented at https://www.sqlite.org/json1.html to manipulate JSON in SQLite

Display the source blob
Display the rendered blob
Raw
demo.geojson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment