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

[ASAHI Kosuke]

Hi Richard,

I can use "ST_Line_Interpolate_Point" function on spatialite with geos 
3.3.1.
Your problem related to following ticket?
  http://trac.osgeo.org/osgeo4w/ticket/232

(2012/07/10 21:38), richard burcher wrote:
> 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.
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>


-- 
ASAHI Kosuke