I'm trying to create a geojson file data based on data from my local postgis database using
ogr2ogr. I'm trying to clip to a specific area and when I start to run the command, everything starts fine, but I then get an
ERROR 6: GeoJSON driver doesn't support creating more than one layer and I'm not quite sure how to solve it.
Do I need to select only one column in the
ogr2ogr -f GeoJSON ./test-buildings.geojson PG:"host=localhost dbname=gis user=*USERNAME* port=5432" -clipdst -84.419932, 33.992761, -84.371342, 34.018029 -clipdstsql 'SELECT way, "building" as type FROM planet_osm_polygon ORDER BY ST_YMin(ST_Envelope(way)) DESC' -progress