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

learn more… | top users | synonyms

1
vote
0answers
162 views

Qgis 1.8.0 throws error “Can not find the entry point sqlite3_rtree_geometry_callback”

Loading QGIS on Window 8 causes this problem: Can not find the entry point sqlite3_rtree_geometry_callback in the procedure of dynamic loading C:\....\Quantum GIS Lisboa \ bin \ spatialite.dll ...
0
votes
1answer
85 views

SpatiaLite: dumpkml with name and description

How does one get the optional arguments in .dumpkml working? According to the .help .dumpkml should work like this: .dumpkml table_name geom_column kml_path [precision] [name_column] [desc_column] ...
3
votes
1answer
498 views

osm2pgsql loses connection at end of import for large PBF, north-america-latest.osm.pbf

I just wanted to check and see if anybody else out there encountered this issue before I started diving into the code. I'm using osm2pgsql to import OSM data into my Postgres database. I encounter the ...
0
votes
0answers
55 views

Uploading transmission line shapefile into spatialite.

I merged around 70 different transmission lines shapefiles of a state into one. Then, with a grid I divided the state into many features and got the centroids in QGIS. I'm trying to calculate in ...
20
votes
5answers
1k views

What are advantages of using spatialite over shapefile?

I found spatialite more useful than shapefiles as it does not have the limitations of shapefile and it is also portable. Many people here use shapefiles to exchange data and even the experts do not ...
3
votes
2answers
311 views

Is it possible to embed QGIS layer styles in a Spatialite database?

Spatialite is a great alternative to shapefiles - but how could I store the QGIS layer style together with the data so that it has a default style? For a shapefile I would just save a [name].qml with ...
8
votes
1answer
606 views

Is Read Only nature of SQLite support in ArcGIS for Desktop 10.2 documented?

I've recently started creating SQLite geodatabases using ArcGIS for Desktop 10.2 with both ST_GEOMETRY and SPATIALITE storage data types and was impressed by how easy this was to do. I then tried to ...
6
votes
0answers
162 views

How does Spatialite handle concurrent access?

I understand that Spatialite is meant to be used by a single user/machine at a time. However if the data is stored on server, there is no guarantee that someone on another machine will not also open ...
2
votes
2answers
95 views

How to hand over polygon attribute to new point while digitizing?

My task is to work with bird observation data in an area, that is divided into zones as different polygons (A1, A2, etc.). I have the hand-written lists of observations and want to bring all entries ...
2
votes
1answer
325 views

SQL to get points within certain distance

I got about 2 million points in a spatialite database would like to get which points are withina radius of 30 km from another point. All data is in WGS84 but I need distance in km. Also it would be ...
1
vote
1answer
264 views

QGIS - adding timestamps to spatialite data during data collection

I am trying to do field data collection using QGIS. One of the features that I regard as necessary for data management is timestamps. For example, a timestamp can indicate that an inspection record ...
6
votes
1answer
598 views

Is SpatiaLite or SQLite Spatial an Accepted Standard?

The reason why I ask this is because I have been undertaking some testing and have found that there seems to be many implementation and not all of them are interchangeable. For example: FME can read ...
0
votes
1answer
198 views

Linked point geometries to linestrings in Spatialite

I have been parsing Canada's radio system frequency open data. It's a single large table per province, containing point geometries for each station callsign. Where a point-to-point link is defined, ...
1
vote
2answers
250 views

How to speed up spatialite-query using spatialindex?

I have got 2 tables, one of type LineLayer called strlayer, the other one is a PolygonLayer called blayer. The LineLayer contains two rows called fromBland and toBland that should be filled with an ...
0
votes
0answers
132 views

Point in polygon analysis fails with “TypeError: arguments did not match any overloaded call”

I am using QGIS 1.8 on Windows 7 I want to perform a point in polygon analysis using the Vector > Analysis Tools menu. My point layer is the result of a SpatiaLite query which returns 10'000 points. ...
2
votes
2answers
201 views

How can I create a multipoint geometry in QGIS?

I've got a Spatialite layer in QGIS with geometry type MULTIPOINT. Now I'd like to add some data in this table in the 'usual' way, so by doing multiple clicks in the map (e.g. left-click, left-click, ...
1
vote
1answer
62 views

Spatialite equivalent of ST_MakeBox2D?

I'm a GIS newbie. I'm porting an app that uses PostGIS to SpatiaLite and wonder what the SpatiaLite equivalent of ST_MakeBox2D might be. Can someone point me to an example?
1
vote
1answer
140 views

Failed connection with .sqlite file in QGIS converted from osm by spatialite

I have converted a *.osm file to a *.sqlite file using the spatialite_tool i.e sspatialite_osm_map.. Now I want to view the map using QGIS. However, at the time of using the add spatialite table ...
1
vote
1answer
85 views

Integrating shapefile in spatialite DB with spatialite gui

For a project, i need a to display datas of a shapefile in an Android app (Geopaparazzi). I'm doing it by integrating the shapefile into a spatialite DB with spatialite gui 1.5 (1.6 having issues with ...
2
votes
1answer
117 views

QGIS and SpatiaLite database: Setting user access permissions

SpatiaLite databases seems to match all my desires to store GIS layers and table. But an important question is: is it possible to limit writing to only one user ? If yes, what is the way to do it? I ...
1
vote
1answer
415 views

Why doesn't SQL sum(dollar) work in SQLITE?

I've got a sqlite table with real numbers, two decimal place precision, in a mydollar_column. (There are no null values, but some of the values are negative numbers) For some reason, using sql on ...
3
votes
1answer
247 views

Why is Spatialite showing dates in MM-DD-YYYY format?

I have a table with a dates column that is formatted in MM-DD-YYYY format, as shown in SQL SELECT statements. I'm using Qspatilite (QGIS 1.8) and Spatialite GUI. When I ORDER BY the date column it ...
2
votes
1answer
148 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
165 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 ...
1
vote
1answer
329 views

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
242 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
243 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 ...
0
votes
1answer
90 views

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
0answers
187 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
1answer
202 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 ...
2
votes
1answer
496 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: ...
1
vote
0answers
87 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 ...
4
votes
4answers
2k 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
140 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
298 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
110 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
95 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 ...
1
vote
3answers
160 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 ...
1
vote
2answers
60 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 ...
2
votes
0answers
55 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
90 views

QGIS Workflow Problem [closed]

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 ...
2
votes
2answers
838 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 ...
3
votes
1answer
207 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, ...
2
votes
3answers
574 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
175 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 ...
2
votes
1answer
346 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 ...
4
votes
2answers
311 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 ...
1
vote
1answer
225 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 ...
2
votes
1answer
347 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
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 ...