SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.
1
vote
1answer
78 views
Mapnik - Weird tiles rendering when used with spatialite
I use Mapnik in an GeoDjango App with Spatialite 4.0 as backend. There is something weird with the tiles that I suspect might be related with a bad handling of mbr with spatialite.
If you look at ...
0
votes
1answer
23 views
Mapnik - Error on rendering linestring
I am using Mapnik 2.0.1rc0 on a Windows 7 with python 2.7 32bits inside a GeoDjango App using xml. The datasource come from spatialite 4.0. My tiling script can render polygon and point features ...
3
votes
0answers
42 views
Can layers from Spatialite db be used as input for a Sextante model?
I'm trying to build my first models in SEXTANTE and already fail at the start. It seems not to be possible to add a vector layer which derives from a database. Orginally, the layers are from a .mdb. I ...
3
votes
0answers
47 views
QGIS Workflow Problem
I have 3 SpatiaLite layers (one without geometry but with fields that need to be filtered, one with points and one with polygons, both without any non-geometry fields) that need to be combined to a ...
3
votes
0answers
71 views
ST_Touches function in Spatialite
I'm a newbie to Spatialite so forgive me if the answer to my question is obvious...(I tried looking online but couldn't find the answer to this question).
I am trying to use the function ST_touches in ...
2
votes
0answers
55 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 ...
2
votes
0answers
243 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 ...
1
vote
0answers
30 views
QSpatiaLite: Cannot create table
I am running QGIS 1.8 (SpatiaLite 3.0.1) and QSpatiaLite 6.0.1.
I have a spatial table EventPrecise (with geometry column p in EPSG:4326). I want to join this table with another, non-spatial table ...
1
vote
0answers
32 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 ...
1
vote
0answers
126 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:
...
1
vote
0answers
45 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: ...
1
vote
0answers
104 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
28 views
Spatialite, to speed performance, when should I create Views, Indexes or additional spatial tables?
I’ve got a large Spatialite database with a table of lines (roads, rail and water). I created a spatial index of the geometry to speed things up.
This works amazingly well when I’m zoomed in ...
0
votes
0answers
33 views
mapnik error - fatal flex scanner internal error--end of buffer missed
I am using Mapnik 2.0.1rc0 on a Windows 7 with python 2.7 32bits inside a GeoDjango App. I often got this error: fatal flex scanner internal error--end of buffer missed that makes python to crash ...
0
votes
0answers
44 views
About spatialite views and Attribute table
I try to use views with spatial column in spatialite. I can connect to spatialite database and load the layer without problems but when I try to view data in Attribute Table I can't get eny data; all ...
0
votes
0answers
133 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
...
0
votes
0answers
94 views
How to migrate data from PowerBuilder Sybase to Spatialite
I want to send data for points and lines from Sybase to DotSpatial project using SpatiaLite.
ODBC connection between PowerBulder 11.5 Sybase SQL and SpatiaLite SQL works OK except for inserting or ...
