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

learn more… | top users | synonyms

3
votes
0answers
118 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 ...
3
votes
0answers
95 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
3answers
456 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
3answers
991 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 ...
2
votes
2answers
750 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, ...
2
votes
1answer
156 views

How can I get the ellipsoidal values for length and area using spatialite?

I have spatialite geometry data stored in a spatialite database in WGS 84 (EPSG 4328) format: SELECT Srid(geometry) FROM shape_layer; > 4326 When geometry is being returned as text, it is ...
2
votes
1answer
130 views

Problem while Reprojecting

When I try to transform geometries from SRID 2321 to 4326, the transformed coordinates are swapping. Why is this happening? Below are the details Source SRID - EPSG:2321 Source Data Projection ...
2
votes
1answer
559 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 < ...
2
votes
2answers
67 views

Merge single points to multi point geometry

Is it possible to transform a point shape file in single part geometryy to a shape file with multi point geometry based on a attribute. e.g. in the shape are 50.000 records in 700 categories, now i ...
2
votes
1answer
126 views

Connecting QGIS, SpatiaLite and Python?

I am trying to connect with python code, QGIS and Spatialite, to do SQL query. I have read some tips and I tried with this code, but no add anything. Any Idea? uri=QgsDataSourceURI() ...
2
votes
1answer
69 views

How to calculate focal range on XYZ DEM in QGIS or Spatialite

I have a XYZ DEM of a fairly mountainous terrain and would like to identify flat areas using QGIS. How can calculate focal range in QGIS? Or would there be a way to do this in Spatialite? Ideally, ...
2
votes
1answer
367 views

How to Set SRID in Spatialite

How do you update the SRID in a SpatiaLite table? I am using the QspatiaLite plugin or the SpatiaLite_Gui program to send this SQL to the table: UPDATE myTable SET geom = SETSRID(geom,26910) ...but ...
2
votes
2answers
262 views

spatialite - azimuth function not available

I am working with last spatialite versions on both Windows (7) and Ubuntu (13.10). I installed these from reference spatialite website. For both, version that I downloaded is 4.1.1 (nevertheless in ...
2
votes
1answer
1k views

Queries on virtual network in Spatialite only make errors

I've installed Spatialite 2.4 in Ubuntu. I try to convert an osm file into a roads network using this tutorial and make searches on it, but the queries only produce "no column" errors. $ ...
2
votes
1answer
56 views

Creating SpatiaLite View in QGIS?

Using these instructions (there are several other examples to find, all look the same and all of them seem to work) http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/sp-view.html "Hand-writing ...
2
votes
1answer
121 views

How to rename ogr2ogr tables on export to Spatialite?

I'm exporting data from PostGIS to Spatialite using ogr2ogr. The export is working properly, except I need to be able to rename the tables that are being exported. Here's the command I'm using: ...
2
votes
1answer
189 views

OSM import: some features are missing

After importing OSM-Data to my qgis-project (as SpatiaLite database and/or shapefile-extract from planet.osm), some features are missing or have no attribute values. For example that lake: ...
2
votes
1answer
537 views

How to use makeline() function for more than 2 points in spatialite?

Is it possible to use makeline() function to make linestring geometries in spatialite for connecting more than 2 sequence points? Suppose I have four sequence points P1, P2, P3, P4. Or are there any ...
2
votes
1answer
859 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 ...
2
votes
1answer
177 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 ...
2
votes
1answer
282 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 ...
2
votes
1answer
246 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
2answers
413 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 ...
2
votes
1answer
164 views

Loading mod_spatialite using sqlite3 for Python in Windows

I have been successfully using the mod_spatialite extension for sqlite in Linux for a while now, but a client wants an application that relies on mod_spatialite to work in Windows. I have extracted ...
2
votes
1answer
86 views

Merge 2 SpatiaLite layers into one

I pretty new to database, so the question could sound simple. I have a SpatiaLite database with some multipolygon layers loaded. What I would like to do is to merge (not dissolve) 2 layers into 1. ...
2
votes
2answers
61 views

Is a multi-database select possible with DB Manager?

I have data in two locations: geometry data (with attributes) on a PostGIS server (read only) a geometryless table on a local SpatiaLite DB (read+write) I need to select features based on data ...
2
votes
1answer
412 views

How to delete a column from the attribute table of a SpatiaLite layer?

I want to delete a column from Attribute table but the function "Delete columns" isn't highlighted. (When I am adding new layers I use New SpatiaLite layer, not Shapefile layer). So I have installed ...
2
votes
1answer
68 views

Loading multiple SpatiaLite layers into a single database

I have many SpatiaLite layers, each in a separate database. I want to load all these SpatiaLite layers into a single database. How can this be done?
2
votes
2answers
103 views

In QGIS how do I edit/save data which has no geometries?

In QGIS I can import data tables (CSV in particular) which have no inherent geometry (and no lat/lon columns) into QGIS. There doesn't seem to be any obvious way to manipulate that data (edit/save). ...
2
votes
3answers
94 views

Need to extract OSM data for my area from 2 neighbor countries

I need to prepare offline background data for my area of interest which is located around border between Czech Republic and Germany. I need to convert the OSM data to spatialite and then to use in ...
2
votes
1answer
58 views

Is there an equivalent to ST_Rotate in spatialite?

I'd like to do some arbitrary rotation of spatial objects in spatialite (accessed through QGIS). In PostGIS I'd use something like: ... SELECT geom AS ST_Rotate(geom, radians, originX, originY) Is ...
2
votes
2answers
80 views

How can I display a spatialLite view in a custom data sheet with print composer

I created a spatiaLite Database with a point layer (every point is a tree). Additional I created several tables to fill the columns of the spatial layer with attributes using the editing widget “value ...
2
votes
2answers
147 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

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: ...
2
votes
2answers
155 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 ...
2
votes
2answers
754 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 ...
2
votes
1answer
670 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 ...
2
votes
2answers
311 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 ...
2
votes
3answers
3k 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 ...
2
votes
2answers
1k 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
592 views

How to import SpatiaLite data into GRASS?

How can I import SpatiaLite tables into GRASS? Are there any restrictions I should be aware of? How does GRASS cope with columns that don't have a specific type (Sqlite tends to create such columns ...
2
votes
1answer
48 views

Spatialite not loaded in PHP5 on Ubuntu

I'm trying to install Spatialite (4.3.0a) on Ubuntu (14.94.2 LTS) ..... I'd like to use it with PHP (5.5.9-1) .... Following this post ...
2
votes
1answer
52 views

Spatialite, NULL when using Distance

When using Spatialite, I cannot run a Distance query. I've tried investigating the data stored in the database, however it doesn't appear to be related to my database. If I run a Distance query on two ...
2
votes
1answer
256 views

Layer with custom UI not working properly

I have a problem with QGIS 2.4 when introducing layers with a custom UI. More precisely, widgets such as CheckBoxes are not recognised as such (appear as Text Edit in Attributes) and the corresponding ...
2
votes
1answer
193 views

SetFeature creates infinite loop when updating sqlite feature using OGR

when using the SQLite driver in python - setting a feature after changing an attribute field value creates an infinite loop on the first record. the same code works fine if i substitute the sqlite ...
2
votes
1answer
379 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 | ...
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 ...
2
votes
1answer
578 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 ...
2
votes
1answer
532 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 ...
2
votes
1answer
941 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 ...