Even,
oh I didn't realize about the duplicate column name. Since I have been
successfully able to query that shapefile with OGR SQL dialect I though
it was something related to the SQLite dialect.
Thanks for catching this issue!
Pierluigi
Il 10/02/2015 19:19, Even Rouault ha scritto:
Le mardi 10 février 2015 19:05:58, Pierluigi Guasqui a écrit :
Even,
here is the complete output:
Shape: DBF Codepage = LDID/87 for
That was useful. Pasting the SQL into SQLite3 console shows :
Error: duplicate column name: MET
Indeed there's a "met" and "MET" columns in the shapefile. OGR drivers and core
rarely handle that properly, and it seems that SQLite3 doesn't like it too. So
you should rename one of the column, or use for example create a VRT with
http://svn.osgeo.org/gdal/branches/1.11/gdal/swig/python/samples/ogr2vrt.py
and hand-edit to do the renaming.
Even
--
Pierluigi Guasqui
Software Engineer
Applied Coherent Technology Corporation (ACT)
www.actgate.com
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
