SpatiaLite 4+ Databases are not created

geopaparazzi / geopaparazzi

Because not all paparazzis are evil!

GNU General Public License v3.0

149 stars 75 forks source link

Closed mj10777 closed 10 years ago

mj10777 commented 11 years ago

The present version of Spatialite in the library only creates pre Spatialite 4.0 Databases.

starting with SpatiaLite 4.0.0-RC1 the 'Well Known Text' field of 'spatial_ref_sys' is called 'srtext' based on the ISO SQL/MM standard
SpatialiteUtilities.create_spatialite() creates the older field: ''srs_wkt''

mj10777 commented 11 years ago

This is also the cause of 'RegisterVirtualGeometry' not working since it needs SpatiaLite 4.0.0

moovida commented 11 years ago

I never compiled the spatialite 4 android libs, but I got some from the nutiteq project. They are spatialite > 4, so they could work.

mj10777 commented 11 years ago

Pre-condition for Spatialite >= 4 is zlib and iconv (for shapes)

I have been attempting to get a working version of jsqlite compiled with all the latest versions of iconv,proj4,spatialite and sqlite
at the moment I have undefined references for iconv
there is also a problem with proj4 4.8 - but I believe I know the cause of that and will deal with that after I get a version with iconv running
At the moment a valid spatialite db for 4.1 can be created - it is however very slow

mj10777 commented 10 years ago

When is BLOB is retrieved, stmt.step() always returns false with BLOBS

moovida commented 10 years ago

I think this can be seen as continued in Issue #98