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

demo.geojson

{
  "type": "FeatureCollection",
  "features":
  [
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [ 2, 49 ]
      },
      "properties": {
        "a_property": "foo",
        "some_object": {
          "a_property": 1,
          "another_property": 2,
          "last_prop": [35, 67]
        }
      }
    }
  ]
}