ShortestLine / ST_ShortestLine not valid SQL

[michealc]

I have managed to compile the sample, download an extract of OSM, converted it using ogr2ogr into sqlite, and I can run queries using indexes. I am trying to find the closet road (line) to current location (point) but I need to use the ClosestLine function. SQL Error complains that function does not exist. The link to spatialite commands is broken so not sure how to debug further. Here is a log on startup 2014-08-15 18:40:41.194 SpatialDBKitIOSTest[10307:60b] sqlite version: 3.8.5 2014-08-15 18:40:41.204 SpatialDBKitIOSTest[10307:60b] spatialite version: 8561968 2014-08-15 18:40:41.205 SpatialDBKitIOSTest[10307:60b] Spatialite initialization SpatiaLite version ..: 4.1.1 Supported Extensions:

• 'VirtualShape' [direct Shapefile access]
• 'VirtualDbf' [direct DBF access]
• 'VirtualText' [direct CSV/TXT access]
• 'VirtualNetwork' [Dijkstra shortest path]
• 'RTree' [Spatial Index - R_Tree]
• 'MbrCache' [Spatial Index - MBR cache]
• 'VirtualSpatialIndex' [R_Tree metahandler]
• 'VirtualFDO' [FDO-OGR interoperability]
• 'SpatiaLite' [Spatial SQL - OGC] PROJ.4 version ......: Rel. 4.8.0, 6 March 2012 GEOS version ........: 3.4.2-CAPI-1.8.2 r0 Thanks Micheal

[andreacremaschi]

Hi, here is a link to the project's homepage: https://www.gaia-gis.it/fossil/libspatialite/index Maybe you would use ClosestPoint with spatialite