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

learn more… | top users | synonyms

1
vote
1answer
237 views

Can SQLite and SpatialLite files be linked

Coming from a ms-access background, it is common to split up larger applications into several database files. An ms-access database can then access data that is in another database via a linked table....
5
votes
4answers
2k views

How to merge close points into polygon?

I have a set of coordinates (points & no overlaps) in a single table,each containing attribute number fields,like in the following image. I want to merge these points into smallest polygons by ...
0
votes
2answers
177 views

SpatiaLite: Creating to, from nodes from a normal road layer (LINE)

Following this tutorial but using my own data. How do I create the from_node and to_node columns? I am using Spatialite and Sqlite3. I'd prefer to not use a gui as I'm working remotely via ssh on a ...
2
votes
1answer
456 views

Spatialite: Convert polygon to multi-polygons based on common field

I have a list of polygons which should be multipolygons: PK_UID | PolygonID | Geometry ------------------------------ 1 | 1 | polygon 2 | 2 | polygon 3 | 1 | ...
1
vote
0answers
371 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
201 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
1k 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 ...
24
votes
5answers
3k views

What are advantages of using spatialite over shapefile? [on hold]

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
852 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 ...
10
votes
2answers
1k views

Documenting inability to Start Editing SQLite geodatabase layers in ArcMap?

I've recently started creating SQLite geodatabases using ArcGIS 10.2 for Desktop with both ST_GEOMETRY and SPATIALITE storage data types and was impressed by how easy this was to do. I then tried to ...
9
votes
1answer
418 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
156 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
1k 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
691 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 ...
8
votes
1answer
2k 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
354 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
915 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
644 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
989 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
107 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
267 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
169 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
197 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
936 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
840 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
320 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
415 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 close....
1
vote
1answer
635 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
474 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
604 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
109 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
338 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
452 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
1k 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: https://code.google.com/p/...
2
votes
1answer
207 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 ...
5
votes
4answers
7k 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
286 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
710 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
161 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
109 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
282 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
65 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
114 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
126 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
1k 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
293 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, ...
3
votes
3answers
2k views

Why are ogr2ogr SQLite geometry functions not available in command line?

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 ST_X(GEOMETRY),ST_Y(...
2
votes
1answer
309 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
636 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
666 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 ...