A self-contained SQL database engine.

learn more… | top users | synonyms

4
votes
2answers
845 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
2answers
96 views

ogr2ogr unreadable dbf file header

I'm trying to convert Mapinfo tab file to ESRI shapefile using ogr2ogr either with sqlite dialect or without. When using sqlite dialect, ogr2ogr -overwrite -f "ESRI Shapefile" -dialect sqlite -sql ...
1
vote
1answer
539 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
437 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
94 views

DBMS Table Not Found with SQLite and ArcGIS 10.3

I'm trying to set up a spatially enabled SQLite database with ArcGIS 10.3. I've gone through the following steps: Create a database using the sqlite3 utility: sqlite3 mydatabase.sqlite Load the ...
0
votes
1answer
128 views

How to install OSM .pbf support in GDAL on Debian?

I'm trying to use Anita Graser's post on loading OSM data from .PBF files into a SQLite .db file using ogr2ogr but it stopped working. I'm trying to run the following command: ogr2ogr -f "SQLite" ...
3
votes
0answers
104 views

Dissolving polygons in a large dataset

I need to dissolve polygons by the ID attribute in a large dataset (+-1gb shapefile). I have been struggling to find an efficient method to do this. I have tried the following methods: Postgis ...
3
votes
0answers
176 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
30 views

Shapes & categories

I am very new to this so please only smile if a dumb question. I have divided the oceans into 31 regions. Each region has various sub regions, example I have region 08; of which it is further broken ...
2
votes
0answers
1k 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
387 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
137 views

Geoserver MBTiles plugins performance issues

I am using the latest stable 2.7.2 version of GeoServer and I am trying to play with the MBTiles plugin, I have installed also WPS plugin that is needed by the MBTiles one (otherwise I got error when ...
1
vote
0answers
118 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
113 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
267 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
205 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
15 views

Using SpatiaLite with Clion

What is the easiest way of importing the SpatiaLite (C++) with the Clion IDE ? I have been trying all sorts of different ways, but nothing seems to work. Does anyone know how ?
0
votes
0answers
31 views

Sqlite layer from Autocad MAP in qgis editing problem

Sqlite files generated with FDO (autocad MAP) have FGF geometry instead of WKB. FGF is an extended version of the Well Known Binary (WKB) format. Qgis can read these layers but they cant be edited, ...
0
votes
0answers
21 views

Fetching the table data from SQlite db in QGIS throws an error

I have exam.sqlite db and it contains 4 tables as t1,t2,t3,t4. from pyspatialite import dbapi2 as db sqlite_file = r'D:\Folder\exam.sqlite' conn = db.connect(sqlite_file) ...
0
votes
0answers
17 views

Null output from Transform function of Spatialite

I am using Spatialite, an extension of SQlite and I have some problems running the transform function. According to the Spatialite functions page ...
0
votes
0answers
39 views

csvsql SQLite --insert causes ID to change

I have a question that stems from a solution provided in this Question: Join a CSV file to shapefile using gdal/ogr? I've been using this to do joins successfully but for some reason, I have a field ...
0
votes
0answers
150 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
134 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
184 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
137 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 ...