Can't connect to SpatiaLite view

Description

When I open the SpatiaLite file https://gisdata.svn.codeplex.com/svn/SpatiaLite/Sample2015_West.sqlite in QGis I can see 3 layers:

In MW5 only 2 layers are shown because the 3rd is a view not a table.

Activity

Show:
Sergei Leschinsky
December 1, 2015, 4:50 PM

I have this 2 messages for this database:

7 Debug GDAL FAILURE: SpatiaLite v4 DB found, but updating tables disabled because runtime spatialite library is v3.0 ! 07:44:33.983
8 Debug GDAL FAILURE: Unable to query table poligoni_esito for column definitions : no such function: st_unaryunion. 07:44:33.998

It's most likely related to the version of SQLite binaries. I also checked st_unaryunion function - it's GEOS function. Our spatialite.dll has GEOS as dependency, no problem here. So probably just need to update to v4.

Assignee

Unassigned

Reporter

Paul Meems

Labels