SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.
1
vote
1answer
67 views
+50
spatialite.dll with Python and QGIS - the specified module could not be found
I'm having a bit of a nightmare getting to the bottom of this DLL loading problem. The stand alone script works absolutely fine but the exact same code does not work within QGIS.
import sys
from ...
1
vote
1answer
74 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 ...
1
vote
1answer
23 views
Why are layers imported into a DB with Spatialite-Gui locked from editing?
I have a Spatialite DB which I have imported some shp files too using Spatialite-Gui.
I have full read-write access to these layers via the Spatialite-Gui, however when I open these layers from QGIS I ...
0
votes
0answers
24 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
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 ...
0
votes
1answer
102 views
qspatialite error compiling Qgis 1.8 (linux debian squeeze)
I tried to compile Qgis 1.8 in linux debian squeeze (following the instructions in INSTALL.txt). During 'make' I get the following error:
[ 40%] Building CXX object ...
0
votes
1answer
69 views
Using the API of QSpatiaLite plugin
I am using the popular QSpatiaLite plugin for QGIS. Since I am creating and modifying SpatiaLite tables directly with Python (using pyspatialite), I wonder whether I can automate tasks such as ...
1
vote
1answer
61 views
How to save a joined spatialite table when each table contains PKUID fields?
QGIS 1.8.0 --
QSpatialite 6.0.7 --
Windows XP
I have spatialite tables joined together that I need to save as a single table, but an error-message says that QGIS can't save the table because there ...
2
votes
3answers
541 views
Accessing GEOS functions in Python
The issue:
I am using Windows 7, 64-bit operating system with Python 3.2. I must continue to use Python 3.2 because of a dependency with another API. I need some functions in GEOS that are not ...
0
votes
0answers
31 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 ...
1
vote
2answers
40 views
Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)
I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
0
votes
1answer
75 views
How to build Android spatialite?
I have been trying to build spatialite for Android for a few days now without success. I have even tried the recent documentation from the Google project page here: ...
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 ...
2
votes
4answers
119 views
How to convert multipoint layer to point
I have a Spatialite layer which is multipoint (following a QGIS Save As from shapefile). I need it to be PostGIS and POINT. I have tried ogr2ogr -nlt POINT and got 'new row for relation "xxx" violates ...
0
votes
1answer
44 views
GeoDjango - DatabaseError: no such table: spatial_ref_sys with Spatialite
Im going through the GeoDjango Tutorial. I have loaded the WorldBorders shapefile into Spatialite. I can do spatial queries such contains, intersects, but I have a DatabaseError: no such table: ...
1
vote
1answer
64 views
How can a HTML table be stored within a database field as a BLOB, text or other value?
My Spatialite database has several thousand spatial polygon records In QGIS, each with a couple dozen field values. I also have many thousands more of additional tabular data relevant to those ...
2
votes
2answers
51 views
Spatialite as a DBMS-server with GeoDjango?
I would like to add a spatial component to my Django application. I turned out to GeoDjango immediatly. I am wondering now if spatialite could be used as DBMS-server for an application in Prod. Grosso ...
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 ...
6
votes
3answers
912 views
How to create a new Spatialite database in QGIS
I've been trying to create a new spatialite database within QGIS 1.8 (SpatiaLite Version 3.0.1; QSpatialite 6.0.3) and keep getting this error: "The SQL query seems to be invalid.
no such table: ...
1
vote
3answers
78 views
Copying schema of Postgis or Spatialite DB to blank one
I want to copy a Postgis or Spatialite DB sctructure (features, tables) to a blank DB. In ArcGIS i can easily handle it by using XML Workspace Document. Fisrtly extact it from a Geodatabase and than ...
0
votes
2answers
75 views
Can I incorporate an existing DBF file with coordinates for Tiff tiles into geodatabase like spatialite?
I have 285 Tiff files that make up the 1:10000 OS map of Norhtern Ireland. I am having problems running QGIS when I try to load all 285 tiff files in for base maps (I think the memory on computer is ...
8
votes
4answers
453 views
How to build a geographic database of GPS logs?
On our aerial wildlife surveys we typically generate dozens of GPX files, and usually convert most of them into shapefiles for display in a GIS application. GPX files are a terrific way of keeping all ...
1
vote
0answers
29 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 ...
3
votes
0answers
46 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 ...
1
vote
2answers
161 views
Can't open Spatialite db from openstreetmap in Quantum GIS
I am new to QGIS, OpenStreetmap and Spatialite. I'm trying to get the (OSM) map data into a (SQLite) compact form I can eventually use for realtime reverse geocoding in a vehicle. Quantum is just for ...
1
vote
1answer
64 views
How to compile QGIS from source with custom pyspatialite 4.0.0?
I have turned WITH_PYSPATIALITE ON, but I have a custom build of SpatiaLite (4.0.0), not the packaged version, so I set WITH_INTERNAL_SPATIALITE to OFF. How do I tell QGIS to configure PYSPATIALITE ...
3
votes
1answer
113 views
Why is my Polygon (WGS84) in SpatiaLite 4 not displayed by QGIS? [closed]
I made a polygon in a SpatiaLite 4 database as follows:
INSERT INTO test_pg (id, name, geom) VALUES (3, 'test', ST_PolyFromText('POLYGON((8.556824 47.185269, 8.611009 47.185269, 8.611009 47.218568, ...
1
vote
3answers
180 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
96 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
218 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
134 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
102 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 < ...
0
votes
1answer
81 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
199 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
47 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
65 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 ...
2
votes
2answers
131 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
154 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
194 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
76 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
85 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 ...
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 ...
4
votes
1answer
377 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
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 ...
11
votes
6answers
2k 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
264 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 ...
1
vote
2answers
254 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
724 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
224 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
125 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:
...
