I am trying to run a GDAL 300 command line command to convert a file to GeoJSONSeq, projecting output using ESRI:102008 (Albers North America), using a SQL query to choose and rename some columns, and applying the following Layer Creation Options:


(I'm not sure if this is necessary - I added it because ID_FIELD wasn't working)

It just seems to be ignoring all of the -lco settings. Here's the full command:

ogr2ogr -a_srs ESRI:102008 -f GeoJSONseq -sql "SELECT ZCTA5CE10 as zip, INTPTLAT10 as lat, INTPTLON10 as lon FROM tl_2018_us_zcta510" -lco "COORDINATE_PRECISION=4" -lco "ID_FIELD=ZCTA5CE10" -lco "ID_TYPE=String" albers_gjs4.geojson albers.shp

What is the correct syntax?

I've tried it with and without the double-quotes (single-quotes definitely don't work in my environment - Windows), I've moved the -lco statements from before the -sql to after. I've poured over all the documentation (https://gdal.org/programs/ogr2ogr.html) for both ogr2ogr and the GeoJSONSeq driver and I haven't been able to figure out what is the right way to specify these options.

Edit - And to clarify the Coordinate Precision option, I am hoping to limit the number of decimals it outputs for the coordinates in order to try to reduce the file size somewhat. Is there any other way to do that? The other utilities I'm trying to use to manipulate this down the line are choking because some string length exceeds the max that node.js will handle.

  • Hi, have u tried using ID_FIELD=zip ? – vagvaf Jul 10 at 4:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.