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

learn more… | top users | synonyms

0
votes
1answer
34 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
69 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
82 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
108 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
117 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
202 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
311 views

python qgis.core import error caused by spatialite libraries

I have an error when trying to import qgis.core to python: >>> import qgis.core Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: ...
0
votes
1answer
40 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
53 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
302 views

Error Loading spatialite extension in .NET Project using System.Data.SQLite

I am trying to use Spatialite in a .NET application using the System.Data.SQLite provider. I have tried to load 'libspatialite-4.dll' but an error happens when I call function ...
0
votes
1answer
60 views

Can SpatiaLite Indexes be used from views?

I'm working with a large SpatiaLite database and trying to take advantage of some spatial indexes I have on my tables that I'm attempting to access through views. Essentially, I have a number of ...
0
votes
1answer
148 views

Import Shapefile into Existing Spatialite Table

I am working with a Spatialite database and a series of shapefiles. I have an empty spatialite table that has geometry and columns. What I would like to do is to load the shapefiles into the ...
0
votes
1answer
54 views

Create “starburst” table from two point features with 1:N relationship using Spatialite

I have a point feature called site_investigation and another point feature called sample_location which are in a Spatialite database. They have a 1:N relationship and the primary key is report_id. ...
0
votes
2answers
98 views

Robust importing of shapefile into spatialite database?

I am trying to import shapefiles into a spatialite database using spatialite-gui. I am having problems with the types of the variables since spatialite-gui has no obvious way to handle shapes which ...
0
votes
1answer
58 views

Wrong output wth group by and aggregate function in spatialite

I have a grid and for every cell I want to set the column "landuse" according to the largest intersecting polygon. SELECT grid.PKUID, landuse.landuse, ...
0
votes
1answer
158 views

No module named pyspatialite- plugin:Qspatialite, OpenSUSE 13.1

I cannot run the plugin because of module missing. I can't find that module in the OpenSuse repository, and python community repository. I'm using QGIS 2,0 and OpenSuse 13,1 Where can I find ...
0
votes
1answer
62 views

QGIS Save as Spatialite layer from FileGDB does not add OGC_FID

I have previously (yesterday) been able to save a Spatialite layer from a FileGDB feature class using the Right click/Save as... method in QGIS. Today, however, with no changes to any software (tried ...
0
votes
1answer
113 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] ...
0
votes
1answer
244 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, ...
0
votes
1answer
94 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
1answer
186 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: ...
0
votes
1answer
153 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
0answers
17 views

QspatiaLite Snapping fails if multiple target vertices within tolerance distance

I assumed that SpatiaLite's Snapping would snap to the nearest candidate vertex - however, it turned out that the result becomes unpredictable, if there are several target vertices within tolerance ...
0
votes
0answers
17 views

QGIS 2.4 - DB Manager - Spatialite Database - Added columns not shown - How to apply fix by Kuhn?

First: I´m only using the built in menus of QGIS 2.4, not entering code manually. I have a simple Spatialite Database with a Polygon Layer and two columns (Text_ID and Description). I used DB Manager ...
0
votes
1answer
47 views

Spatialite in GeoDjango - “…they do not properly define db_type…”

I've started a new project and choose GeoDjango for it. Because I already developed with Django and sqlite as a DBMS and all worked perfectly fine for me, I found it a great option to use spatialite ...
0
votes
1answer
31 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] ...
0
votes
0answers
44 views

QGIS vector edition corrupts SpatiaLite attribute table

I have a problem with edit SpatiaLite Layer on QGIS. When I make a this set of editions: cut line, delete a part, insert a new line and save it, the attribute table is corrupted. I was thought that ...
0
votes
1answer
8 views

How to drop a table in spatialite that starts with a certain string?

I am using spatialite (v4.2.0) on a Windows 7 (64bit) PC. I need a way to drop a specific table that always begins with "_old" from my database. The file may not be in the database in the first ...
0
votes
1answer
49 views

Explicitly close a OGR result object from a call to ExecuteSQL

How can I explicitly close/release the result of an ExecuteSQL statement when querying a Spatialite database with OGR via Python? I have a simple query to return the SRID of a dataset. This works as ...
0
votes
0answers
28 views

Formula to know if LINE intersects with MBR

I have a table with four columns: SRC_X, SRC_Y, DST_X, DST_Y. (SRC_X,SRCY) have position of the start point of a LINE, (DST_X, DST_Y) have position of the end POINT of a LINE. I know there are ...
0
votes
0answers
50 views

Know if MBR contains any POINT of LINESTRING

I have a table with a Geometry column. This column only has LINESTRING. This LINESTRING only has two POINTS. If i have a MBR, i need to know which of LINESTRING of my Table has some of its POINTS ...
0
votes
1answer
52 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) ...
0
votes
1answer
77 views

Find position of a character within a string in Spatialite

I have a bunch of data generated as a .dbf by ArcMap that I imported in Spatialite for processing. One of the columns (text data) is of critical importance since it contains the ID of a point and a ...
0
votes
0answers
59 views

pyspatialite, cannot update geometry

I'm trying to update geometry column with pyspatialite but it returns error: spatialite.dbapi2.IntegrityError: mypoints.the_geom violates Geometry constraint [geom-type or SRID not allowed] My ...
0
votes
0answers
49 views

How to overlay polygons that are in the same layer

I need to INTERSECT many polygons that are in the same layer. Actually each polygons from my layer represent an area of influence from one specific bird species. Since I used to use ArcMap, I found ...
0
votes
1answer
84 views

no viewable feature when creating line with ogr in python

the python code below produces the expected line shapefile viewable in QGIS import os from osgeo import ogr drv=ogr.GetDriverByName('ESRI Shapefile') if os.path.exists('test.shp'): ...
0
votes
0answers
42 views

How to move point in Spatialite Layer through manual entry of X/Y coordinates?

My Spatialite Database (Point Layer) looks like this (arch_locations.sqlite) Fields: pkuid short_ID name geometry X Y The field "X" and"Y" I added later (after first creation of DB) using the ...
0
votes
0answers
86 views

How can I get the set of points (cloud) that are a given distance in SpatiaLite?

I have a set of points and need to get the groups of points that are within a distance x. Ie, determining the point clouds that are up to the distance x from each other. Any help would be ...
0
votes
0answers
94 views

QGIS custom form and autocompleted data entering with “validation check”

In Qt-Designer I created a custom form where I can choose serveral species names in two different combo boxes. This combo boxes are linked via "value relation" to the accordant non spatial tables ...
0
votes
0answers
58 views

export shapefile to spatialite hangs qgis

I have a shapefile layer containing 9 points. The attribute table has a string column (max 18 chars) and a real column. The .dbf file is ~4KB, all the other files are 1KB. I right-click on the layer, ...
0
votes
1answer
69 views

Populate Table from Table Spatialite

I am trying to populate a column in a table from another table using Spatialite. My query will not populate the column, and I can't seem to identify what is wrong. I modeled the query from the ...
0
votes
1answer
111 views

Can't build x64 SQLite with spatiaLite

I need a spatial-enabled SQLite solution for a x64 Windows application I am developing. I have examined and downloaded and attempted to compile the SQLite amalgamation package; I've looked at the ...
0
votes
1answer
58 views

Getting wrong value for area of geometry using Spatialite?

I am trying to implement a measuring tool on apple maps for IPAD. As a part of that i collect all the touch points on the map into an array and constructing a geometry object from that and then ...
0
votes
1answer
52 views

Fail to get heatmap from MULTIPOINT column of Spatialite layer in QGIS?

I got a heatmap from a POINT column of spatialite layer. But, when I made another heatmap from MULTIPOINT column, it was blank. What is the possible reason of this problem?
0
votes
0answers
87 views

Spatialite not available from qgis python console

I have a problem using pyspatialite from within the qgis python console. When I run the following code in ipython from pyspatialite import dbapi2 as sqlite conn=sqlite.connect("MyDB.sqlite") ...
0
votes
0answers
29 views

How to discard null coordinate points automatically when we make Multipoint Geometry in Spatialite?

I have a Spatialite table that contains a series of 80 coordinates where each coordinate placed into one column in a table. Then, I want to add all those coordinates into one Multipoint Geometry ...
0
votes
0answers
67 views

Is there a limitation in quantity of joined tables using spatialite views?

I've one point layer in qgis and several non spatial tables in a spatialite database. Now I want to create a view as you can see in the following: CREATE VIEW testansicht10 AS SELECT ...
0
votes
1answer
716 views

How to build a Spatialite road network from OSM data

I'm looking for algorithm which could help me with building my own road network (for routing) from OSM data. I chose Spatialite DB for this, but here I have only one problem: Spatialite provides ...
0
votes
0answers
82 views

QGIS, SpatiaLite and GPS integration

I have QGIS an, access database and a Haicom gps all connected and running on a windows 8 machine. I want to integrate all 3 items so that while in the field i can enter information into the ...
0
votes
0answers
97 views

How to specify the version of output SQLite database in ogr2ogr?

I'm having issues with a .sqlite database that I generate from PostGIS using ogr2ogr. The data appears to export into SQLite properly, and it loads in TileMill fine, but when I try to add any of the ...