I believe title is all clear.I'm using Ogr2ogr utilities & binaries to read geometry. I used something like this:
ogr2ogr -f "SQLite" test2.sqlite test.sqlite -sql "SELECT ST_X(GEOMETRY),ST_Y(GEOMETRY),COL1,COL2 FROM TABLE"
Error says that there is no function ST_X,where I also tried X(..) that doesnt work either. What am I missing ?
I checked the documentation for SpatialLite.There is no other inline function that export X,Y portions of geometry to double.I also need to create geometry from LAT,LONG columns from selection.
How can i do these ?