Stack Overflow
Stack Overflow

Questions tagged [spatialite]

Spatialite is a library extending the basic SQLite core in order to get a full fledged Spatial DBMS.

Spatialite is a library extending the basic SQLite core in order to get a full fledged Spatial DBMS.

236 questions
0
votes
0 answers

Join geometries to update in SpatiaLite

I am working on a project in SpatiaLite and I would like to join together two geometries to create one final geometry that contains both original polygons (Ex. Putting together two Legos). The tricky part is how to make this work in SpatiaLite with…
Julia
  • 1
  • 1
0
votes
1 answer

SQL apply a function to all data in a column

I am new to SQL. I am working on Spatialite which is a spatial database build on top of SQLite. I want to apply the function LineStringFromText() to all data in a column called "geometry". I tried the SQL statement below, but I get synax erors:…
kevin
  • 309
  • 2
  • 12
0
votes
1 answer

Using Spatialite in Android

I want to develop an Android app with offline routing. I want to use Spatialite as the database in the client side. I am confused after reading their web. Since it is running on the Android side(cell phone), why the installation requirs to install…
kevin
  • 309
  • 2
  • 12
0
votes
2 answers

libxml2 linking error for iOS library

Make process on a C library causing the linking errors related to architecure.I am trying to build library for iOS but it has got dependancy on libxml2 which in this case I guess is Mac only library lipo -info confirms the same admin$lipo -info…
addcolor
  • 455
  • 8
  • 23
0
votes
0 answers

MakePoint return empty result

I have a spatialite database with longitutade and latitude colums as text: SELECT latitude, longitude FROM mytable1 LIMIT 3; 54.475|9.0422222222222 52.398055555556|13.733888888889 49.940277777778|11.576388888889 When I try to create a geometry from…
Marten Bauer
  • 3,099
  • 5
  • 22
  • 18
0
votes
1 answer

Cordova spatialite database for android not working

I am am trying to use spatialite plugin from https://github.com/DisyInformationssysteme/Cordova-spatialite-storage for my cordova application, but the problem is that when i try to create database it shows me Database open failed, aborting any…
Hemal Gondaliya
  • 47
  • 8
0
votes
0 answers

Can't compile SpatiaLite sample.c

I am using Clion IDE which uses MinGW. I am following these instructions, from the far bottom of the page: "Simplest approach: no libs at all..." to compile sample.c. I also had to download libspatialite-amalgamation-3.0.1.zip…
dimitris93
  • 4,155
  • 11
  • 50
  • 86
0
votes
0 answers

Spatialite: no such function st_geomfromtext

I am using the latest Spatialite and encountered this error "no such function st_geomfromtext" while running my query. It might be a library not running. Is there a fix for this?
munchies
  • 1
  • 1
0
votes
0 answers

error of loading geometry data from csv file to Spatialite

I have a database in SQL server 2008 R2. The database has a table with 5 columns and one column is "geometry", like : 0xE610000001042C1C00000000004033DF60C000000080 ... I have exported it to a csv file and would like to import it to a database…
user3448011
  • 1,469
  • 1
  • 17
  • 39
0
votes
1 answer

Spatialite not loaded in PHP5 on Ubuntu

I'm trying to install Spatialite (4.3.0a) on Ubuntu (14.94.2 LTS) ..... I'd like to use it with PHP (5.5.9-1) .... Following this post https://faimsproject.atlassian.net/wiki/display/FAIMS/Installing+Spatialite+4+on+Ubuntu (obviously using the…
Cesare
  • 1,629
  • 9
  • 30
  • 72
0
votes
1 answer

Using spatialite with 64 bit python's sqlite3 module on 64 bit Windows 7

I've installed the spatialite DLL files from this page. I've alternately tried putting the 32 bit DLLs (mod_spatialite-4.2.0-win-x86.7z) into Windows' system32 folder, and the 64 bit files (mod_spatialite-4.3.0a-win-amd64.7z) into the SysWOW64…
Boa
  • 2,609
  • 1
  • 23
  • 38
0
votes
1 answer

How to get SpatiaLite to work with Cordova/Ionic Framework

A am building a hybrid mobile app using the Ionic Framework and I was able to successful get SQLite to work using ngCordova SQLite plugin: Now I need to know how to get SpatiaLite DBMS library to work in this Ionic application. Does anyone know how…
Kenan Tufekci
  • 35
  • 7
0
votes
1 answer

Using SpatiaLite with web2py?

As explained in this post, I've been attempting to use the web2py database abstraction layer's SpatiaLite adapter, and I'm receiving a "RuntimeError: Failure to connect, tried 5 times" message. I've installed the SpatiaLite DLLs into Windows'…
Boa
  • 2,609
  • 1
  • 23
  • 38
0
votes
1 answer

Nutiteq issue with spatialite on iOS, init exception - sqlite3_auto_extension EXEC_BAD_ACCESS address 0x300

I create swift project. add SpatialDBKit pod and some other lib. When i try to open database with let db = SpatialDatabase(path: NSBundle.mainBundle().pathForResource("myfile", ofType: "spatialite") ) I get EXC_BAD_ACCESS (code=1,address=0x300)…
Hamid
  • 1,099
  • 3
  • 22
  • 37
0
votes
1 answer

"Adapter does not support geometry" exception when declaring geometry field

In my application, an "Adapter does not support geometry" exception is being thrown when attempting to create a field of type, "geometry()". For my test application, I'm using an sqlite DB (production will use postgres): db =…
Boa
  • 2,609
  • 1
  • 23
  • 38
1 2 3
…
15 16