[gdal-dev] Problem with merging SHAPEs into SpatiaLite

jratike80 jukka.rahkonen at maanmittauslaitos.fi
Thu Oct 5 05:20:02 PDT 2017


Hi,

I have a bit similar problem with making queries with SQLite SQL dialect if
shapefile name has numbers.
For example this succeeds fine with GDAL 2.3dev on Windows:

ogrinfo -sql "select * from test2000" test2000.shp

but this does not


ogrinfo -dialect sqlite -sql "select * from test2000" test2000.shp
INFO: Open of `test2000.shp'
      using driver `ESRI Shapefile' successful.
ERROR 1: Cannot create virtual table for layer 'test2000' : CREATE VIRTUAL:
inva
lid SQL statement : CREATE TABLE "test2000"("KUNTANUMER"
VARCHAR(3),"KUNTANIMI"
VARCHAR(18),"MAAKUNTA" VARCHAR(2),"AVI" VARCHAR(2),"ELY"
VARCHAR(2),"OGR_STYLE"
VARCHAR(37),OGR_STYLE VARCHAR HIDDEN,"GEOMETRY" BLOB_POLYGON_XYZ_0,
OGR_NATIVE_D
ATA VARCHAR, OGR_NATIVE_MEDIA_TYPE VARCHAR)
ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(select * from test2000):
  no such table: test2000

-Jukka Rahkonen-



--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html


More information about the gdal-dev mailing list