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

learn more… | top users | synonyms

0
votes
1answer
233 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 ...
1
vote
1answer
448 views

Problem loading spatialite extension with sqlite3 Python connector

I am trying to load the Spaltialite extension using SQLite3 python module. I am getting the following error when I run my script. EOFError: [Errno 10054] An existing connection was forcibly closed ...
0
votes
0answers
92 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 ...
1
vote
2answers
232 views

TatukGIS SQLite Spatial vs. Spatialite

I must apologize in advance, I'm just getting into GIS and trying to figure things out. I have an SQLite spatial database that I'm pretty sure was created in TatukGIS. I've tried to open it in QGIS ...
0
votes
0answers
66 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 ...
3
votes
2answers
211 views

Combining MS Office with GIS

I would like to incorporate MS Office into my GIS program. I have been using QGIS and was wondering if this would be possible? I am trying to create a one stop shop for my staff to be able to ...
0
votes
1answer
116 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'): ...
4
votes
1answer
458 views

Configuring spatialite database access for Python 2.6.6

I'm working on a GIS project, and I would like to implement and test some geo-spatial algorithms in Python. For this purpose, I will not only need sqlite, but also spatialite, in order to store and ...
0
votes
1answer
136 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
557 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 ...
1
vote
0answers
21 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
2answers
51 views

geos_ts_c.cpp + spatialite Error

select distance(T1.Geom,T2.Geom) as Distance, T1.POI_ID, T2.LINK_ID from temp1 as T1, temp2 as T2 where T1.POI_ID = T2.POI_ID AND Distance < 100 temp1 having point geometry temp2 having line ...
0
votes
0answers
69 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 ...
1
vote
3answers
378 views

How to add columns with x/y data to Spatialite Layer? [closed]

I´m new here and I am also quite new at working with QGIS. My Spatialite Database looks like this (arch_locations.sqlite) Fields: pkuid short_ID name geometry I´d also like to have two additional ...
0
votes
0answers
107 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
1answer
112 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 ...
1
vote
0answers
59 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 ...
0
votes
0answers
128 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 ...
1
vote
1answer
191 views

Spatialite Table Difference in QGIS

I am see differences between tables when I view them in spatialite-gui and in QGIS. I have created a table, added columns, and updated the columns in spatialite-gui. Within spatialite-gui I can view ...
1
vote
1answer
349 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 ...
1
vote
0answers
69 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 ...
0
votes
0answers
62 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
2answers
223 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
1answer
62 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
1answer
88 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 ...
2
votes
0answers
147 views

How to eliminate gaps and overlaps in a layer of SpatiaLite table?

I'm try to snap all polygons in a table to remove gaps and overlaps. I can remove gaps but get new overlaps. I have no idea what doing wrong... sorry, I'm new in SpatiaLite. I tried the following: ...
0
votes
1answer
184 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 ...
3
votes
0answers
364 views

Why does the QgsVectorFileWriter have probelms creating vector files? [closed]

I am using QGis 2.0.1 and have tried to create a new GIS feature file (SQLite, Spatialite, and Shapefile) of a subset of the data. I am then saving a copy of the style of this layer and applying it to ...
1
vote
1answer
46 views

Lost geometry when joining spatial and non-spatial tables

I have two tables I am joining: 1 spatial (Table 1) and one not spatial (Table 2). Table 1 looks like this: | ID | geometry | Table 2: | ID | ... | When I perform the query: CREATE TABLE AS ...
1
vote
0answers
48 views

Differences between PostGis and SpatiaLite [duplicate]

I am working on spatial data where there is quite a lot of data (mainy data from GBIF for people who know it). It is not so complicated analyses (I am not Gis Expert!). I am currently working with ...
0
votes
1answer
103 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 ...
1
vote
1answer
416 views

Create Buffer in meters Spatialite query

I am new to Spatialite. I have following query: select A.* from linka as A, pointa as B where Contains(Buffer(B.Geometry, 100), A.Geometry) Here, A.Geometry = LINESTRING(23.2161 69.95237, ...
1
vote
0answers
107 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, ...
2
votes
2answers
203 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 ...
0
votes
1answer
65 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
129 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") ...
2
votes
1answer
153 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: ...
1
vote
1answer
100 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" ...
2
votes
0answers
143 views

How to build a query tool for spatialite data in QGIS?

I am trying to build some tool for a collegue of mine to query data from a spatialite database while clicking on vector features. My first guess is, that I could do this with an "action" I define for ...
2
votes
1answer
117 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 ...
0
votes
1answer
218 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 ...
5
votes
3answers
1k views

Sqlite, Python 2.7 and Spatialite

I am trying to spatially enable my sqlite database: import sqlite3 db = r'c:\temp\mydata.sqlite' conn = sqlite3.connect(db) conn.enable_load_extension(True) cur = conn.cursor() cur.execute(r"SELECT ...
0
votes
0answers
36 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 ...
2
votes
1answer
235 views

Added columns in SpatiaLite wont appear in QGIS (attribute table)

I have a SpatiaLite Database with OSM-Data from planet osm (imported with the OSM import tool from QGIS2.0) Everything is fine so far. I can create, export, delete tables and draw them in qgis... but ...
2
votes
1answer
387 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 ...
4
votes
1answer
762 views

How to load Spatialite extension via SQLite3 ODBC Driver?

I am having trouble getting the Spatialite extension to load as part of the SQLite3 ODBC driver...[aka the joys of making software somewhat spatial when it tries so hard not to be]. What works ...
4
votes
2answers
536 views

Binding between QGIS custom form (Qt Designer) and date/time field in a SpatiaLite database table

For my attribute table I created a custom form in Qt Designer. The table has a date field and a time field. In Qt Designer there are widgets for entering date and time. But what data type is expected ...
0
votes
2answers
130 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 ...
1
vote
1answer
108 views

draw multipart polygon with one surrounding border

As you can see on the image below, the waterbody is divided by the border line because it consists of several polygons. I could merge the polygon, but I dont want to change the shapefile. Is there ...
0
votes
2answers
184 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 ...