[Qgis-user] Several Spatialite Functions Not Found: Qgis 1.8

[richard burcher]

Hi Folks,

Problem:
Several spatialite functions not found when accessing spatialite db from
python console.

Setup:
OSGeo4W installer used:
qgis 1.8.0-3
pyspatialite 2.3.1-3

Code:

## output software versions
from pyspatialite import dbapi2 as db
conn=db.connect("C:/../../test2.sqlite")
cur=conn.cursor()

rs=cur.execute("select
sqlite_version(),spatialite_version(),proj4_version(),geos_version()")

for row in rs:
    print ">sqlite v%s, spatialite v%s, proj4 v%s, geos v%s"
%(row[0],row[1],row[2],row[3])
    
>sqlite v3.7.10, spatialite v3.0.1, proj4 vRel. 4.8.0, 6 March 2012, geos
v3.2.2-CAPI-1.6.2


## attempt spatial function -- line_interpolate_point
rs=cur.execute("SELECT line_interpolate_point('db_test'.'geometry') as
Geometry FROM 'db_test'")
---------------------------------------------------------------------------
OperationalError                          Traceback (most recent call last)
<ipython-input-4-ef4fe1ef0123> in <module>()
----> 1 rs=cur.execute("SELECT line_interpolate_point('db_test'.'geometry')
as Geometry FROM 'db_test'")

OperationalError: no such function: line_interpolate_point


Functions not found so far:
line merge
line substring
line interpolate point
line locate point
single sided bufffer

These functions appear to be driven by geos? From the output of software
versions, geos is installed. 

Not sure what the cause is. Thoughts?

Cheers,

Richard






--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Several-Spatialite-Functions-Not-Found-Qgis-1-8-tp4987294.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.