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 SELECT
statement?
Command:
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
ogrinfo -al -so 'SELECT way, "building" as type FROM planet_osm_polygon ORDER BY ST_YMin(ST_Envelope(way)) DESC'
, I get a failure to open datasource. Is that syntax right?