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

learn more… | top users | synonyms

1
vote
1answer
203 views

ogr2ogr from personal geodatabase to spatialite produces “non-spatial” tables

I have around 4 GB of data in 10 separate Personal Geodatabases, each of which contains multiple feature classes. I'm trying to convert the smallest one to SpatiaLite via ogr2ogr, in preparation for ...
1
vote
1answer
181 views

How can I dissolve adjacent polygons based on minimum attribute value? [duplicate]

I'm trying to merge the polygons (administrative boundaries) in a dataset untill they reach a minimum value. Lets say that the polygon dataset consists of the number of people per polygon and I need ...
1
vote
0answers
47 views

QGIS attribute form editor crashes on Spatialite source

I have collected an attribute table (no geometry) together with other stuff in a Spatialite DB for easy portability. The idea was to hand off just one file and DB for field work. The Problem: The ...
1
vote
0answers
65 views

Something changed in QgsVectorDataProvider().changeAttributeValues() in QGIS 2.8? [duplicate]

I have a plugin that works with QGIS 2.2 but does not work with 2.8. Only deleteFeatures() works fine, but changeAttributeValues(), changeGeometryValues() and addFeatures() not. I receive r == False ...
1
vote
1answer
146 views

Map Positioning and Routing on Android

I have been instructed to create an small offline application in Android that have to: a) Use our own map in JPEG format as the basemap (Google Map / OpenStreet Map is not applicable) b) Show the ...
1
vote
0answers
29 views

SpatiaLite / QspatiaLite: get subgroup row ids

I'm using QspatiaLite plugin to join polygon ids to points that are within those polygons. Now I' d like to get subgroup rownumbers for each subgroup of points with same polygon id! Like so.. grp_ID ...
1
vote
1answer
88 views

Splitting multiline into several same-length multilines

Is there a method to convert a multiline geometry into several multiline geometries having the same length? For example break this: MULTILINESTRING((1 1, 3 1, 3 1.5, 2.5 1.5)) Into [approximately] ...
1
vote
0answers
187 views

Simplifying geometries and calculating non-spatial averages

I'm quite new to using proper spatial tools, and have a simple question that doesn't immediately show up on google. I have a table that contains multiple rows of empiric data (say, speed of a ...
1
vote
1answer
17 views

Can't understand Return value in gaiaLineLocatePoint_r

I am trying to develop a C application that finds the nearest point on a linestring from another point, in spatialite. I found the two API's gaiaLineLocatePoint_r and gaiaLineLocatePoint , but I am ...
1
vote
0answers
117 views

Loading SQLite extensions in QGIS

I have an extension which can be loaded in SQLite using the load_extension function. It would be useful for me if I could load it in QGIS to use in queries made via Database Manager. The Python ...
1
vote
1answer
63 views

What causes this error when loading plugin

After installing pyspatialite on my Mac two plugins fail to load with this error:: This plugin is broken invalid literal for int() with base 10: '2-spatialite' I am fairly sure that the offending ...
1
vote
0answers
28 views

Count gaps between polygon in spatialite

I have a database (.db) with a table that contains thousands of polygons containing id and geometry. I like a query that can get me the 'number of errors where there are gaps between polygons". How ...
1
vote
0answers
67 views

Spatialite database creation problem (QGIS DB manager)

I am trying to create a Spatialite database in QGIS 1.8.0. Step one of instructions is: Right click on the Spatialite entry in the Browser tree and select Create Database. The Spatialite icon is ...
1
vote
0answers
81 views

joining polylines on geometry and attribute

I have dowloaded an Open street Map shapefile containing streets and their attributes, for my whole country. I have qgis and spatialite_gui and a very basic understanding of SQL The problem I have is ...
1
vote
0answers
131 views

Spatialite android trigger problem

I am developing an android application that uses the database spatialite, I use this project to integrate the database on android https://code.google.com/p/spatialite-android/ It works normally, ...
1
vote
1answer
133 views

Problems with connecting QDateEdit and QTimeEdit widgets to corresponding Field in QGIS Layer (shp/spatialite)

Could anybody give me a hint how to connect the QDateEdit and the QTimeEdit widgets with a field in a QGIS layer (shp or spatialite). The fields in the QGIS layers are from datatype "date" ...
1
vote
0answers
141 views

SQL procedure(s) to convert GPS traces to an ordered set of junctions in a network

I have three datasets that I have loaded into a geodatabase (spatialite or PostGIS): A set of GPS points collected from individual trips through urban areas. Points have a unique point id, a group ...
1
vote
0answers
351 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 ...
1
vote
1answer
457 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
168 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 ...
1
vote
0answers
50 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
83 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
1answer
779 views

Inconsistent Spatialite Update Behavior; SRID not allowed?

I have two tables: crime and (police) stations. The latter has only 4 records with (name, lat, lng) fields. The former has over 500K records with two California Zone 2 (ft) coordinate columns named ...
1
vote
0answers
205 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
2answers
306 views

Have I created a valid Spatialite database?

I didn't manage to find the better way to populate the exisiting Spatialite database with new computed data than just creating new columns and filling them in the Python script. You can see that the ...
0
votes
2answers
214 views

QGIS 2.0, SpatiaLite: labels disappear after setting data defined position (x,y)

I added to my SpatiaLite table (.osm-import with the "standard" QGIS-OSM-Plugin) two empty columns x and y (double) to define manually the position of my labels (data defined labeling). But after ...
0
votes
1answer
415 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 ...
0
votes
1answer
84 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 ...
0
votes
1answer
333 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
2answers
76 views

Not able to load a DEM raster into Spatialite

I am using Spatialite to store a DEM raster with terrain values (GMTED2010 from Nasa). To be more precise, I am using the version: spatialite_gui-1.7.1-win-x86.zip plus rasterlite_load ...
0
votes
1answer
171 views

Check if point is near a linestring Spatialite

I have a LINESTRING made of two points start point and end point in spatialite. UPDATE points SET road_geometry = GeomFromText('LINESTRING(24.889142 67.196188, 24.889673 67.196579)',4326) where ...
0
votes
1answer
135 views

How to define which columns in a Spatialite database are the latitude and longitude?

I have imported a CSV containing points with coordinates specified in columns named Latitude and Longitude. How do tell spatialite that these columns are the coordinates of of my points?
0
votes
1answer
205 views

PtDistWithin() with Geometry from query

I'm trying to run two Spatialite queries in Python — the first one picks a single point from a table, and the second tries to find all points that are within a given distance of it. So my queries look ...
0
votes
1answer
209 views

ST_Within from centroid of geometry

I am looking at doing a spatial query where I can find when the center of one feature falls within another. For example, when the center (centroid) of a building falls within a grid tile. I know I can ...
0
votes
1answer
339 views

Geometry Transformation in Spatialite 4.1.1

I am trying to transform a geometry (geo referenced to Australia) POLYGON((-33.917172 151.110971,-33.916443 151.112495,-33.917637 151.113276,-33.917783 151.111512,-33.917253 ...
0
votes
2answers
170 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 ...
0
votes
2answers
249 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 ...
0
votes
1answer
19 views

Spatialite union more than two layers / tables

Is there a way to union or collect any number of layer geometries with Spatialite (or another spatial database)? Two is simple enough, but more than that becomes convoluted. For example, if all I want ...
0
votes
2answers
30 views

Converting SpatialLite.Core.API.IGeometry to GeoAPI.Geometries.IGeometry

I have an in-house .NET library which processes geometry data in GeoAPI form (https://github.com/NetTopologySuite/GeoAPI). Within this library I have a method which I need to call which is expecting a ...
0
votes
1answer
25 views

Count polygons that intersects polygon in Spatialite

I am trying to do a very simple query, but keep getting an error. I am looking to get the count of polygons that intersect with another polygon. I've used the following query: SELECT feature__1 AS ...
0
votes
1answer
34 views

Geometry column read as Numeric after operation in SpatiaLite (QGIS)

Pretty weird problem with SpatiaLite used within QGIS (2.13) with the DB Manager. I have 2 layers (result of the same algorithm) and I use this function to merge them in a new table: CREATE TABLE ...
0
votes
1answer
51 views

Spatialite function to generate a blob from a geometry

Using QGIS Python API, I want to avoid updating geometry with an UPDATE sql command. Why? I'm using a QSqlRelationalTableModel (see model-view programming if curious) and there are built-in editing ...
0
votes
1answer
109 views

Qgis 2.10 unable to add a new feature in spatialite via sql function “GeomFromText”

Using Python code in my plugin the function in sql language "GeomFromText(POINT(X Y))" gives the following error: "OperationalError: no such function: GeomFromText" Plugin functions in previous ...
0
votes
1answer
97 views

How to export to KML from Spatialite command line

The Spatialite GUI can export a Geometry column to KML file. How would one go about doing that from the Spatialite command line? I am looking for an example code preferably - the .help doesn't mention ...
0
votes
2answers
141 views

Help finding point in polygon via Spatialite with example karst zones data

I'm working on a school project involving Spatialite and point in polygon queries. I've successfully followed this example: http://blog.crazystyle.net/?p=255 I am now trying the same sequence of ...
0
votes
1answer
97 views

Error doing st_union in spatialite

I have a multipolygon layer in which I want to dissolved based on a class column. The steps I'm doing are: create table tc_2010_00567 (gid int primary key, tc_2010 text(32)); select ...
0
votes
1answer
99 views

ogr2ogr Spatialite to csv very slow

I am using ogr2ogr to extract point data from a Spatialite db to a csv file:- ogr2ogr -f "CSV" commandtmp.csv dtm2.sqlite -lco GEOMETRY=AS_XYZ -progress -explodecollections the Spatialite db is 7GB ...
0
votes
1answer
75 views

which spatial server goes better with raster images stored in DB Spatialite?

I would like to serve images from Spatialite as WMS services. As far as I know: Geoserver is compatible with vector features only -if you install the extension-, but not with spatialite BLOBs (in ...
0
votes
1answer
94 views

SpatiaLite - WITH, view or sub-query?

I am running on Windows 8.1 SpatiaLite_gui 1.8.0, SpatiaLite version 4.2.0 and SQLite 3.8.5. I need to interrogate one single spatial table whith those attributes: ID | val | val_1 | val_2 | Geom ...
0
votes
1answer
214 views

BuildCircleMbr with 1km of accuracy - spatialite

I want to create a Circle MBR in spatialite of 1km for example from lat/lon in WGS84 I use BuildCircleMBR but i am not able to generate this well. My query SELECT BuildCircleMbr(40.0,-4.0,1, 1000) ...