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

learn more… | top users | synonyms

2
votes
1answer
258 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
511 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
365 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
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 ...
1
vote
1answer
83 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
161 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
586 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
145 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
126 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
98 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
784 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
153 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
68 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
76 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
1k 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
105 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
228 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
664 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
62 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
163 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
77 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 ...
0
votes
1answer
61 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
160 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 ...
7
votes
2answers
557 views

How do I use the Natural Earth SQLite DB with QGIS?

I just downloaded the Natural Earth data in SQLite format from http://www.naturalearthdata.com/downloads/. I had assumed that this would be a SpatiaLite database, but it appears not to be! QGIS is ...
0
votes
1answer
748 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 ...
3
votes
1answer
116 views

How to combine Spatialite Databases

I'm trying to combine a few Spatialite Databases into a single database, so that I can properly reference them, etc. I don't care about referencing them to one another (No foreign keys, etc), but I ...
0
votes
0answers
83 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 ...
3
votes
1answer
271 views

pyspatialite: Connot insert geometry

I'd like to insert a row with a point geometry with pyspatialite. The sql looks like this: insert into eqdata(origin_time, url, mag, lat, lon, depth, m_a, region, mt, the_geom) ...
2
votes
0answers
500 views

Building java based desktop map application using embedded database such as spatialite

I am relatively very new to building GIS based applications and have a very limited understanding in this area. So I need some help in building a java based desktop application which would generate ...
2
votes
1answer
516 views

special python library needed for spatialite?

It appears that pyspatialite is very outdated. Do I need a special library like pyspatialite in order to use the spatial functions of spatialite? Or can I just connect to the database via the normal ...
0
votes
1answer
66 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 ...
1
vote
0answers
116 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 ...
3
votes
0answers
144 views

Handling non-spatial data for QGIS projects with Camelot

Most of my projects include data which is non-spatial or which is point data and can be managed by a regular relational database. Previously I found Manifold and ms-access were a good combination ...
1
vote
1answer
250 views

Multiple input shapefiles for ogr2ogr sqlite spatial operations

I'm running up against an issue doing a spatial operation requiring multiple input shapefiles using ogr2ogr and sqlite. I have: ogr2ogr -f "ESRI Shapefile" output.shp input.shp -dialect sqlite -sql ...
0
votes
0answers
99 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 ...
4
votes
2answers
190 views

can Well Known Text tables be used effectively, stored in Access or Base?

My question is: How do I import WKT text data back into QGIS, and how useful could Base or Access be in storing the data using WKT rather than spatially enabling it within a proper GIS database, like ...
4
votes
1answer
431 views

Can Spatialite SQL statements be issued with a python script in QGIS?

In my previous scripting environments (ms-access and Manifold GIS), it was possible to create and execute SQL queries from withing VBA or VB Script procedures. This is really useful for things such ...
0
votes
0answers
163 views

Using distance and transform from geomfromtext from postgis in spatialite

I have the following query which I want to apply on my from postgis to spatialite imported database. The problem is that the result of the distance is always null, while the other selected coloumns ...
1
vote
1answer
137 views

Can SQLite and SpatialLite files be linked

Coming from a ms-access background, it is common to split up larger applications into several database files. An ms-access database can then access data that is in another database via a linked ...
5
votes
4answers
701 views

How to merge close points into polygon?

I have a set of coordinates (points & no overlaps) in a single table,each containing attribute number fields,like in the following image. I want to merge these points into smallest polygons by ...
0
votes
2answers
118 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 ...
2
votes
1answer
239 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 | ...
1
vote
0answers
249 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 ...
0
votes
1answer
116 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] ...
3
votes
1answer
680 views

osm2pgsql loses connection at end of import for large PBF, north-america-latest.osm.pbf

I just wanted to check and see if anybody else out there encountered this issue before I started diving into the code. I'm using osm2pgsql to import OSM data into my Postgres database. I encounter the ...
21
votes
5answers
1k views

What are advantages of using spatialite over shapefile?

I found spatialite more useful than shapefiles as it does not have the limitations of shapefile and it is also portable. Many people here use shapefiles to exchange data and even the experts do not ...
3
votes
2answers
442 views

Is it possible to embed QGIS layer styles in a Spatialite database?

Spatialite is a great alternative to shapefiles - but how could I store the QGIS layer style together with the data so that it has a default style? For a shapefile I would just save a [name].qml with ...
8
votes
1answer
836 views

Is Read Only nature of SQLite support in ArcGIS for Desktop 10.2 documented?

I've recently started creating SQLite geodatabases using ArcGIS for Desktop 10.2 with both ST_GEOMETRY and SPATIALITE storage data types and was impressed by how easy this was to do. I then tried to ...
8
votes
1answer
257 views

How does Spatialite handle concurrent access?

I understand that Spatialite is meant to be used by a single user/machine at a time. However if the data is stored on server, there is no guarantee that someone on another machine will not also open ...
2
votes
2answers
113 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 ...