OGRInfo On Shapefile = zero length delimited identifier error

Question

I have an ESRI Shapefile that I can open in ArcMap and QGIS and show the attributes fine. However when I try to load to PostGIS using ogr2ogr I get an error saying
ERROR 1: ERROR:  zero-length delimited identifier at or near """"
LINE 1: ALTER TABLE "attribute" ADD COLUMN "" VARCHAR(5)

I used ogrinfo -al File.shp and it lists all 20 records fine but none of the attributes seem to come through.
I have opened the dbf file in Excel and its fine and have even parsed the dbf header using Python and it is exactly the same header output as a previous shapefile which correctly loads.
Why is ogr2ogr having an issue parsing the file?

Mox · Answer

I don' know PostGIS, but if it reads fine in other formats, that suggests the ogr2ogr is the problem. If postGIS can read some other format, or do something like shp2ogr, that seems worth a try.

OGRInfo On Shapefile = zero length delimited identifier error

One Answer

Add your own answers!

Ask a Question