SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.
1
vote
2answers
282 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
741 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
226 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 ...
1
vote
0answers
142 views
Why does AddGeometryColumn error using the libspatialite-2 DLL with pysqlite2?
What I'm trying to achieve is to create a geometry column of a point based on the latitude and longitude of that particular row in the already created table.
Given the following code:
...
8
votes
2answers
290 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
203 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 ...
7
votes
3answers
619 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
260 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
65 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 ...
2
votes
1answer
189 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 ...
24
votes
6answers
2k views
Options for ArcGIS Desktop SpatiaLite support?
SpatiaLite is playing an increasing role in my organization. As it stands now, using SpatiaLite alongside ArcGIS Desktop requires an amount of importing and exporting of data that isn't always ...
3
votes
1answer
122 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 ...
0
votes
0answers
150 views
Rasterlite - black tiles [closed]
Im importing some geotiff rgb rasters into spatialite via rasterlite_load utility. During the load i get a warning that some of the tiles are not geotiffs (but they are, they all load normaly if ...
4
votes
2answers
147 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 ...
3
votes
3answers
668 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
507 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
190 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
256 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 ...
0
votes
0answers
138 views
Spatial query with OR in WHERE clause slow, even with spatial index
I am trying to return a list of geometries that satisfy two ST_Intersects conditions, and am running into a performance issue that I hope is remediable. My query looks like this:
SELECT DISTINCT a.id
...
14
votes
2answers
3k 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 ...
3
votes
1answer
367 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
47 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
127 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 ...
2
votes
0answers
58 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
316 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
252 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
815 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
182 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
221 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
168 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 ...
7
votes
2answers
343 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
1k 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
266 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
564 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
239 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 ...
2
votes
2answers
295 views
What's a good way store borehole data in SQLite / SpatiaLite?
I have a bunch of bores / wells with downhole data. The 'header' info for each borehole can easily go into a single table, but I'm wondering how best to store the downhole log data. Typically they are ...
1
vote
2answers
544 views
How to get libspatialite.so file for spatialite
I am creating an application using spatialite database. I checked couple of tutorial from internet. Most of them explains the same. But the problem is I need "libspatialite.so" extension library. I do ...
5
votes
3answers
1k views
How to export shape file to SpatiaLite
I have a shapefile with one layer. I can open it with QGis. Now I want to convert this shapefile or layer to Spatialite database. How can I do it? Is it possible to do with QGis?
1
vote
3answers
1k views
Spatialite in .NET Application - AccessViolationException was unhandled
I am trying to use Spatialite in a .NET application using the System.Data.SQLite provider. Interestingly enough, everything works as expected except an error gets thrown at the very end when the ...
1
vote
1answer
243 views
How to tell SharpMap to display polygons based on z-order?
I have a series of polygons which overlap in spatialite. Each has a an attribute providing it's z-order as well as the output color for that polygon. What do I need to do, processing-wise, to allow ...
4
votes
1answer
636 views
Split line using line/point in PostGIS 1.5
I have a layer that contains a master line (one big polyline) and a another layer that contains "break lines". I need to be able to split the master line at the intersection of each of these break ...
5
votes
1answer
1k views
How to find nearest neighbors between two tables with point locations in SpatiaLite?
I have started playing with SpatiaLite today and already stumbled upon a problem.
For each point location stored in tableOne I would like to select one, nearest (linear distance) point from tableTwo.
...
2
votes
1answer
469 views
integrating spatialite and php (sqlite3) on windows platform
anyone can give me an explanation about how to integrate spatialite with php(sqlite3)-windows platforms.
I have tried to refer from this link ...
2
votes
2answers
377 views
How to delete a broken index in SpatiaLite?
I managed to screw up an index in my SpatiaLite database. The index was created using spatialite-gui. In the meantime, I deleted the original table and three out of four index files: ...
1
vote
0answers
105 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 ...
1
vote
1answer
598 views
How to combine MapInfo tab files into one spatialite DB?
I have many folders, each with a collection of MapInfo tab files (each folder has the same table names). For each folder I want to merge the tab files into one spatialite DB.
My current method is to ...
2
votes
1answer
375 views
How do I query for all polygons within a distance from a point?
Call me stupid, but somehow I couldn't figure out how to do the following.
I've got a testing shapefile with 18 features, which I successfully imported into GeoDjango (1.3, running on Spatialite). As ...
2
votes
2answers
213 views
Specifying a file for VirtualShape in SpatiaLite [closed]
I'm fairly very new to spatialite, and am stuck on something very basic.
I'm creating a virtual table from a shapefile using virtualshape. This works fine when the shapefiles are in the same folder ...
5
votes
2answers
441 views
Access to SpatiaLite .dumpshp via Python?
I'm trying to interact with a SpatiaLite database via Python on my Windows machine.
I've managed to connect to the database and load the SpatiaLite extension, which means that I can pass SQL queries ...
