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

learn more… | top users | synonyms

0
votes
1answer
50 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
40 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
88 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
97 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 ...
0
votes
1answer
111 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
50 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
49 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
105 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
51 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
62 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
116 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
85 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
130 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
29 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
45 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
44 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
167 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
60 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
1answer
86 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
47 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
80 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
90 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
0answers
58 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
74 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
81 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
79 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
542 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
26 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
0answers
108 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
205 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
398 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
306 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
96 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
74 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
151 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 ...
4
votes
3answers
417 views

Best choice for building static maps: PostGIS, SpatiaLite or Shapefile?

I usually build static topographic maps, which are mostly printed. I'm often using OSM and rasterfiles (mainly different DEMs). The areas I'm mapping seldom exceeds 20.000 km². I'm using exclusively ...
3
votes
1answer
126 views

Convert planar distance to ellipsoid (real) distance

I have the following linestring which approximately marks an airport runway: LINESTRING(-381578.819887 6574044.360475, -378513.534443 6574799.475787) # EPSG 3857 LINESTRING(-3.427781 50.732117, ...
5
votes
2answers
113 views

Can someone give the absolute lowdown on the following list of spatial operators

Ok, I have to admit, I don't really delve too deep into the semantics of the spatial operators list below, I'm more of a user, I write software to drive the SQL most of the time and don't really think ...
2
votes
1answer
84 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 ...
3
votes
1answer
608 views

Multiple geometry columns for points, lines, and polygons in spatialite?

I'm rather new to the GIS world and even newer to Spatialite and trying to create a new DB for our application. I would like to create spatial index(es) on the geometry column(s), but our geometry ...
1
vote
0answers
133 views

How to create a spatial view when allowing multiple selection in qgis’s edit widget “value relation”?

I've a point layer in qgis and serveral non spatial tables in a spatialite database. In qgis the fields were filled using the edit widget "value relation" (multiple selection allowed for some fields). ...
0
votes
0answers
64 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 ...
4
votes
1answer
69 views

SpatialLite BulkLoad and Merge

Via the U.S. Census I have downloaded all of the census group shapefiles. These are approximately 19-20GB across 56 shapefiles. I want to merge these to do some testing. Clearly, shape file ...
7
votes
1answer
753 views

Find Nearest Line Segments to Point

Background From a known Point, I require to establish the nearest surrounding "visible perimeter" against a table of MultiLineStrings, as shown on the diagram. I've searched this site with a number ...
3
votes
1answer
75 views

Rasterlite db with multi table

When working with Spatialite DBs, I can store multiple tables in single DB. But now I want to store multiple raster tables on a single Rasterlite DB. I tried QGIS for conversion but it converts only ...
1
vote
2answers
202 views

QGIS export ESRI Shapefile to SpatiaLite format issue

I am trying to export a shapefile of 3221 mixed POLYGON and MULTIPOLYGON geometry elements and every time, I get this same error: Does anyone have any idea what's going on? And no, this is not an ...
1
vote
1answer
471 views

Trying to install SpatiaLite 4.3 with SQLite 3.8 on Windows 7

I'm new to the open-source GIS database world, and am trying to have SpatiaLite installed on my Windows 7 machine. I downloaded SQLite 3.8.2 and unpacked the 3 files in a newly created folder ...
2
votes
2answers
59 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 ...
1
vote
2answers
136 views

sqlite version error with ogr2ogr

I am trying to randomly select some points from a shape file using ogr2ogr and an SQL query via sqlite but it seems to baulk at the sqlite version: ogr2ogr -sql "SELECT * FROM probe_2004to2012 WHERE ...
3
votes
1answer
71 views

How to create a printable data sheet when using edit widget “value realtion” in QGIS 2.0?

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 ...