A self-contained SQL database engine.

learn more… | top users | synonyms

3
votes
1answer
400 views

Configuring spatialite database access for Python 2.6.6

I'm working on a GIS project, and I would like to implement and test some geo-spatial algorithms in Python. For this purpose, I will not only need sqlite, but also spatialite, in order to store and ...
1
vote
1answer
254 views

Looking for RMaps SQLite format details

Locus Maps and Rmaps Android maps support an offline sqlite Format called Rmaps. I am trying to find the format details and how its organized. I couldn't, is there any dependable documentation online? ...
1
vote
1answer
327 views

SQL Data: How to draw circles with a radius based on lat/long data in DB

I have a . sqlite file with many columns, two of those columns being lat and long. I've been searching around for a bit now (don't think I want to be using BuildCircleMbr from spatialite?) but I'm ...
0
votes
1answer
159 views

Can't build x64 SQLite with spatiaLite

I need a spatial-enabled SQLite solution for a x64 Windows application I am developing. I have examined and downloaded and attempted to compile the SQLite amalgamation package; I've looked at the ...
0
votes
1answer
190 views

How to solve sqlite_rtree_geometry_callback error?

I have just installed qgis 1.8 and it show error message the procedure entry point sqlite3_rtree_geometry_callback could not be located in the dynamic link library sqlite3.dll How to fix ...
3
votes
0answers
143 views

What is a good way to retrieve geographic data along with imgs and mp3 files?

I'm working in the Django backend of an audio guide for tourism with mobile devices. Basically, the client (Phonegap app for Android and iOS) can follow a route over a map (Leaflet client) and see ...
2
votes
0answers
454 views

Sqlite insert java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: SRID)

I'm trying to connect to two DBs and then copy tables by inserting rows from one table to another through java using JDBC. I'm using sqlite-jdbc-3.7.2.jar plugin.The setup is in Eclipse Luna. I'm ...
2
votes
0answers
224 views

Performance issue with SQLite + Spatialite + C#

I am having a performance issue with SQLite database (.db) which extends to SPATIALITE I am trying to update Geometry of 1,00,000 records in database (.db) which taking around 50 minutes. Too much ...
1
vote
0answers
81 views

Loading SQLite extensions in QGIS

I have an extension which can be loaded in SQLite using the load_extension function. It would be useful for me if I could load it in QGIS to use in queries made via Database Manager. The Python ...
1
vote
0answers
89 views

OGR Error : Silly size requested

I'm scripting OGR functionality in order to filter some mapinfo tables and convert them into sqlite files. ogr2ogr -f "SQLITE" newtest.sqlite test.tab -sql "SELECT cols FROM test WHERE .." where ...
1
vote
0answers
219 views

Adding multiple layers to Tilemill from a single sqlite DB

This is a repost of a question I had over at the MapBox support board. Since I wasn't having much luck over there, I'm hoping I would have better success here. I'm having trouble adding more than a ...
1
vote
0answers
186 views

How to retrieve the value of a cell in RasterLite?

Just wanting to know the SQL statement needed to find out the pixel value for a location, when the raster is loaded into SpatialLite as a Raster? I loaded the Raster using rasterlite_load -d ...
0
votes
0answers
14 views

Converting SQLite db file into .kmz?

How to convert SQLite db (map data) into .kmz format. I am unable to connect already downloaded sqlite db file to Global Mapper application. I have downloaded these files on my android mobile.
0
votes
0answers
22 views

Error when loading ST_Geometry into SQLite

I have created a new .sqlite database running the arcpy code in ArcGIS 10.3 (with Python x86): import arcpy sqlite_database_path = 'C:/Data/Counties.sqlite' ...
0
votes
0answers
33 views

What replaces SQLserver SqlGeometryBuilder, for Windows store apps?

Porting Visual Studio 2008 C# application to Visual Studio 2013, Windows 8.1 store\phone app (need to include DB with the application). What DB to use (coding in c#), to replace this code, not sure ...
0
votes
0answers
54 views

QT designer form default text ignored in QGIS when used with sqlite db

I'd like to populate a table with a custom form, for which I'd like some default text to be set when opening the dialog. I have two columns ('Name' and 'Description'), each with text that should be ...
0
votes
0answers
85 views

pyspatialite, cannot update geometry

I'm trying to update geometry column with pyspatialite but it returns error: spatialite.dbapi2.IntegrityError: mypoints.the_geom violates Geometry constraint [geom-type or SRID not allowed] My ...
0
votes
0answers
117 views

Spatialite not available from qgis python console

I have a problem using pyspatialite from within the qgis python console. When I run the following code in ipython from pyspatialite import dbapi2 as sqlite conn=sqlite.connect("MyDB.sqlite") ...
0
votes
0answers
109 views

How to specify the version of output SQLite database in ogr2ogr?

I'm having issues with a .sqlite database that I generate from PostGIS using ogr2ogr. The data appears to export into SQLite properly, and it loads in TileMill fine, but when I try to add any of the ...