[gdal-dev] Exporting large geojsons to postgis using ogr2ogr

Hemant Bist hemantbist at gmail.com
Thu Nov 2 13:39:56 PDT 2017


Hi,
ogr2ogr is repeatedly failing for me with the following error when I try to
import a large geojson (5gb) to postgres. The geojson itself was created by
ogr2ogr from a ESRI gdb file.
I would appreciate any pointers for workarounds. I only found 1] which
indicates that I may have to manually(using custom script) split the
geojson file.

1]
https://gis.stackexchange.com/questions/16340/alternatives-to-ogr2ogr-for-loading-large-geojson-files-to-postgis
 ogr2ogr  -f "PostgreSQL" -append -update -nlt GEOMETRY -t_srs EPSG:4326
PG:"dbname=mydb  tables=dummy" vol2/myuser/delme/a.json'  -nln tmpx -lco
FID=gid -lco PRECISION=NO

ERROR 1: GeoJSON parsing error: buffer size overflow (at offset 0)
ERROR 4: Failed to read GeoJSON data
FAILURE:
Unable to open datasource `/vol2/myuser/delme/a.json' with the following
drivers.
  -> PCIDSK
  -> JPEG2000
  -> PDF
  -> ESRI Shapefile
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20171102/77dc5b06/attachment-0001.html>


More information about the gdal-dev mailing list