SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.

learn more… | top users | synonyms

2
votes
3answers
557 views

Ogr2Ogr SQLite Geometry Functions

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 ...
2
votes
1answer
328 views

Open source software for car navigation on iOS platform

I'm trying to make a car offline navigation app for iOS. Now I analyze OpenStreetMap features what to use. I would like to know if there is open source solution for the following parts of app: best ...
3
votes
1answer
638 views

how to add a custom SRID to Spatialite

I'd like to create a spatialite database and load it with shapefiles using the Mississippi Transverse Mercator (MSTM) projection, but it doesn't have an EPSG definition in the spatialite library of ...
4
votes
2answers
306 views

How do I reduce the number of drawn polygons on an Android Map?

We're using spatialite-android and Nutiteq to render Archaeological datasets. One of our sample data sets has 7000 polygons that turn into 400,000 objects in our renderer. Is there a common GIS ...
2
votes
1answer
333 views

In what situations would SpatiaLite be selected over PostGIS, and vice versa?

I know that SpatiaLite is a lightweight solution. Would it be a problem if I put it on a 5K pageview/day site? Is PostGIS too resources-consuming for such usage? The dataset is something like < ...
1
vote
1answer
223 views

How to compile liblwgeom independently?

For using liblwgeom function in spatialite, I need to compile the library. I found that it is included in the PostGIS code. My question is, how to compile the library without compiling the whole ...
0
votes
1answer
291 views

Problem in Spatialite database creation

When I try create a new DataBase, Spatialite plugin return the dialog error box: The SQL query seems to be invalid. no suck table: views_goemetry_columns When I click in OK button, a second dialog ...
0
votes
1answer
65 views

QSpatiaLite query syntax

Using the QSpatiaLite plugin in QGIS I composed the following query SELECT 'AddressPoint_2'.'buildingNu', 'AddressPoint_2'.'postCode' WHERE 'AddressPoint_2'.'postCode' = 'NR13 3AA' FROM ...
1
vote
1answer
90 views

Python error when running SpatiaLite with OSGB(27700)

I have a project open in QGIS and am trying to import an Ordnance Survey Address Point layer into SpatiaLite. I have recently installed the Qspatialite plugin. I open SpatiaLite in the DB Manager ...
3
votes
2answers
518 views

Can I import a .gml file into Spatialite in QGIS?

I have some Ordnance Survey Address Base data files which have a .gml extension. I have imported them to GGIS as vector layers along with some mapping data but would like to explore them with ...
4
votes
1answer
288 views

How to add a geometry to an existing feature that was created with NULL geometry?

I have a simple SpatiaLite geodb loaded in QGIS with one table. There is a POINT geometry field and some alphanumeric data. In some cases I can record data about a specific site, but the coordinates ...
3
votes
1answer
316 views

How to open a Spatialite non-spatial view in QGIS

I'm using Qgis 1.8.0, and spatialite 2.3 in a Windows Vista machine. I have a database in Spatialite, and I have created a view from one of its tables. When I open it in QGIS, using add Spatialite ...
5
votes
1answer
167 views

Where is the Spatial reference ID stored in SpatiaLite?

I have loaded a shapefile into a SpatiaLite Database using the spatialite-gui. In which table is the Spatial reference ID or EPSG code (of the stored data)stored in SpatiaLite?
6
votes
1answer
173 views

Finding all neighbors for all polygons in Spatialite

Excuse me if this is a basic question but I'm new to Spatialite... I have a dataset with zip code polygons and I would like to create a list where for each zip code we have listed all the neighboring ...
4
votes
1answer
767 views

How to store raster data in spatialite?

I want to cache my raster data(large geotiff files) on local database. I thought to use spatialite. I found librasterlite which provide functionality to do that. Can anybody point to some tutorial on ...
1
vote
0answers
42 views

spatialite sql and possibly using case

i have a database that has got tables with images and some of the tiles for the images is repeated and i want to eliminate the duplicates based on which imagery is oldest so as to remain with the ...
11
votes
6answers
3k views

How to run Spatialite on Android?

Does anyone know if it is possible to get Spatialite running on Android? Specifically for either Android 2.1 or 2.2. I've been browsing the web, and although it seems technically possible, I haven't ...
2
votes
1answer
394 views

How to configure wampserver for spatialite

I am in windows 7. I installed WAMPServer. Now, I can not load spatialite libraries. It is showing warning.. Warning: SQLite3::loadExtension() [sqlite3.loadextension]: Not supported in ...
2
votes
2answers
536 views

Why is Spatialite delivering “Invalid SRID” error message

Qspatialite in QGIS 1.8 (and also Spatialite-gui) delivers an "Invalid SRID" error message when I try to load shapefiles with a SRID value of 3814 (Mississippi Transverse Mercatur). The SRID is ...
13
votes
6answers
951 views

Is SpatiaLite the only single file/db spatially enabled exchange format?

I am trying to figure out if there are other viable exchange formats for spatially enabled data. So far, it seems SpatiaLite is the only one out there, but it has yet to be adopted by the industry.
2
votes
2answers
277 views

QSpatialite install error in QGIS

I'm installing QGIS 1.7.4 in windows 7 & having problems with QSpatialite. I get 3 messages... Message #1 This DB a valid SQlite DB, but not a valid SpatiaLite DB. QSpatiaLite will now try to ...
8
votes
2answers
623 views

What is an “XYZM” measurement model?

SpatiaLite supports a remarkable number of different dimension models. Interestingly, some of their values support a "measure" coordinate (XYM, XYZM). How would this measure-coordinate be used, and ...
6
votes
2answers
287 views

Why is this spatialite polygon layer not displayed properly?

In QGIS, I have a spatialite multipolygon layer that have full objects in attribute table but do not display random ones as I scroll and pan around: Vietnam map at zoom level 1:16000000 - some ...
8
votes
3answers
1k views

Is Spatialite Really Slow?

I have a couple of thousand polygons in SpatiaLite. I am trying to do a "touches" query: select map1.* from map1,map2 where touches(map1."Geometry",map2."Geometry") and wow, is it SLOW! ...
2
votes
1answer
375 views

How to get spatialite_osm_net from spatialite

I am using windows 7. I downloaded spatialite-tools (precompiled) from the following site. But there is no "spatialite_osm_net" tool available. For one of my project I was trying to convert the OSM ...
4
votes
1answer
126 views

Is it possible to have a single foreign key column referenced to two or more different tables?

In Spatialite (3.0.1), having a normal (non-spatial) table, I would like to relate it to two different spatial tables, with different geometries types (multipolygons and polylines), using the same ...
5
votes
1answer
494 views

What is the efficient way to dissolve polygons using Spatialite 3.0

I have polygon table called "tableA" with 72000 records. It has a geometry column called "geometry", and a text column called "field1". I want to aggregate\dissolve all polygons with the same ...
3
votes
1answer
162 views

storing jpeg in spatialite database

How to store jpeg file in spatialite blob column so that spatialite gui and Qgis can recognise the format and show the image. I have created in memory jpeg from raster bands using jpeglib and stored ...
4
votes
2answers
295 views

Is it possible to add a new line in a non-spatial table using Qgis?

While using QGIS, and having loaded a non spatial table (from a dbf or a Spatialite table), is it possible to add a new row to its table attributes? Normally in a spatial layer you have to use "add ...
4
votes
3answers
1k views

How do I add (and map) a non-spatial table to QGIS from SQLite?

I have an sqlite file from my Wigle Android app (wiglewifi.sqlite). It's not a spatial file, just tables with lat/lon and other data. I can add spatialite layers just fine, but cannot seem to find a ...
4
votes
2answers
880 views

How do I split polygons into line segments?

How can I split my polygon file into "segements"? The lines should be broken up like this picture shows:
0
votes
1answer
266 views

python qgis.core import error caused by spatialite libraries

I have an error when trying to import qgis.core to python: >>> import qgis.core Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: ...
2
votes
1answer
467 views

OSM data, line and polygon confusion

Taking some OSM (*.osm) data downloaded from Geofabrik I have created a Spatialite database using spatialite_osm_map. Now I have problems, because some of the data that is supposed to be in the form ...
18
votes
2answers
5k views

Looking for fastest solution for Point in Polygon analysis of 200 million points

Apologies for asking a question that has been asked before -- I've read through answers, and I'm left wondering how to implement the recommendations. I've never used SQL, Python, C, and have only ...
4
votes
1answer
486 views

Shorter Version of this SpatiaLite Query

I've been doing some spatial queries using spatialite, and they're large enough that a spatial index becomes a must. An example of using an index is given in the tutorial spatialite> SELECT ...
0
votes
0answers
19 views

Storing Image data to spatialite [duplicate]

Possible Duplicate: spatialite storing raster data I want to store geotiff data to spatialite databse. I am using gdal to read metadata and reading tiles convering them to hexwkb format and ...
1
vote
0answers
62 views

rasterlite build issues

i am able to build rasterlite library but when it is building .exe for tools(rasterlite_load) it gives linking error for external symbole SPLite3 like this rasterlite_load.obj : error LNK2019: ...
4
votes
1answer
156 views

Where are the Spatialite settings stored?

after moving a spatialite-database to another directory, qspatialite says "Can't connect to Database" / Error unable to open database file. Even no project is open or I try to create a new project. In ...
3
votes
0answers
86 views

I'm trying to import united_states.osm into Spatialite and spatialite_osm_net just quits with no error

When I try to run spatialite_osm_net using united_states.osm as input, the program simply stops after Windows presents a pop-up saying the program ended with an error. No other information is ...
8
votes
3answers
392 views

Remove duplicates from Spatialite

I have a Spatialite database with points. From time to time now points are added. What would be the easiest way to remove duplicates based on the coordinates? Hints are greatly appreciated.
2
votes
0answers
480 views

Spatialite - get geometry from WKB

I have a table of WKB HexString values, of the form: 01010000000812368FA5D106C01C25B4DAE5AE4A40 in a column called 'Centroid' in spatialite I want to create a geometry from these values. When I ...
4
votes
1answer
1k views

Help importing osm data into spatialite

I am trying to import OSM data into Spatialite. The data is a query from overpass called features.osm I'm using spatialite 3.0, and following examples, I have created a new database with: $ ...
3
votes
1answer
201 views

Create new polygon layer based on areas of varying numbers of stacked polygons

I have several species range maps (as polygons) that overlap/stack. From this, I am trying to identify areas of highest biodiversity. Ideally, I'd like to create a new polygon layer, where 1 part is ...
1
vote
1answer
301 views

How to Make QGIS on Windows use Spatialite 3.0 instead of 2.4?

I spent all afternoon trying to figure out why my complex triggers are working fine in Spatialite-GUI but QGIS refuses to write to the layer. Finally remembered I ran into a similar issue a few ...
1
vote
2answers
225 views

Can GRASS read Spatialite geometry fields?

I've looked at the question: How to import SpatiaLite data into GRASS? already. The links there talk about two separate tasks: Passing SQL to a Spatialite DB from GRASS and connecting to Spatialite ...
8
votes
2answers
619 views

Can QGIS Read Spatialite Views?

I have a spatialite database I created that spans several years of crime data. To facilitate a real-world scenario where I may simplify the interaction for a user by introducing a View that simply ...
3
votes
2answers
2k views

How can I use R-Tree to find points within a distance in Spatialite?

Create a table with 3D points: create table points (coords pointz); select CreateSpatialIndex('points', 'coords'); Insert 13k rows: insert into points values (geometryfromtext('pointz(...)')) Do ...
1
vote
1answer
496 views

Inconsistent Spatialite Update Behavior; SRID not allowed?

I have two tables: crime and (police) stations. The latter has only 4 records with (name, lat, lng) fields. The former has over 500K records with two California Zone 2 (ft) coordinate columns named ...
5
votes
1answer
799 views

SQL Query to Reverse Geocoding in PostGIS

I try to do Reverse Geocode from my shapefile on the database. I'd already try with Spatialite and PostGIS to put shapefile (.shp) into it. But I'm still can't delivered my objection about reverse ...
2
votes
3answers
315 views

How to embed metadata into a spatialite layer in QGIS?

Example usage: I have a spatialite layer which contain my fiber optic cable routes. In that layer there is a column named 'Cable types' with coded integer data: 1 for aerial cable, 2 for underground ...