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

learn more… | top users | synonyms

0
votes
1answer
279 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
1answer
33 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
165 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
258 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
15 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
79 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
28 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
101 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
45 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
73 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
157 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
117 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
137 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
14 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
26 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
0answers
29 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
0answers
22 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
18 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
20 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
33 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
33 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
40 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
23 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" ...
0
votes
0answers
28 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 ...
0
votes
0answers
22 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
47 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
0answers
31 views

Spatialite-gui has started crashing

I have been using spatialite-gui for a few months to perform one task in particular: convert csv to dbf. For the last couple of weeks, when I use the Import-CSV function spatialite-gui crashes after ...
0
votes
1answer
259 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
58 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
23 views

The names of all the tables created are forced to be converted into lowercase in Pyspatialite 3.0.1

after the update of PYSPATIALITE from 2.3.1-3 to 3.0.1-1 in QGIS, the names of the all the table created by SQLite3 are forced to be converted into lowercase. After fallback to 2.3.1-3, the issue ...
0
votes
0answers
69 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 ...
0
votes
0answers
92 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 ...
0
votes
0answers
16 views

Does the DB Manager Plugin support running a block of SQL statements?

It have been trying to use blocks of SQL statements in DB Manager that are based on blocks of SQL Statements in the Spatialite manual (v2.3). These blocks start with a 'begin;', end with 'commit;'. ...
0
votes
1answer
58 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
0answers
53 views

Import PostGis osm2po data to spatialite db

I would like to import a table form my postgis SQL database into a spatialite db. I created a new db in spatialite and wanted to create also the used table. But I got an error by using LineString. ...
0
votes
0answers
47 views

Uploading transmission line shapefile into spatialite.

I merged around 70 different transmission lines shapefiles of a state into one. Then, with a grid I divided the state into many features and got the centroids in QGIS. I'm trying to calculate in ...
0
votes
0answers
99 views

Point in polygon analysis fails with “TypeError: arguments did not match any overloaded call”

I am using QGIS 1.8 on Windows 7 I want to perform a point in polygon analysis using the Vector > Analysis Tools menu. My point layer is the result of a SpatiaLite query which returns 10'000 points. ...
0
votes
0answers
67 views

Spatialite datas displaying weird into Geopaparazzi

I have some shapefiles datas that i integrate into a Spatialite DB to display it in the Android app Geopaparazzi. It's displaying, but really weird and not the same way it displays in QGIS. It ...
0
votes
0answers
43 views

.Net wrappers for Spatialite and CF?

I need a spatially enabled DB that runs on Windows CE on .Net CF 2.0. Is anyone aware of a set of wrappers for Spatialite? I've found what looks to be a great set of wrapper from MayaStudios ...
0
votes
0answers
138 views

Spatialite, to speed performance, when should I create Views, Indexes or additional spatial tables?

I’ve got a large Spatialite database with a table of lines (roads, rail and water). I created a spatial index of the geometry to speed things up. This works amazingly well when I’m zoomed in ...
0
votes
1answer
83 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
0answers
148 views

mapnik error - fatal flex scanner internal error--end of buffer missed

I am using Mapnik 2.0.1rc0 on a Windows 7 with python 2.7 32bits inside a GeoDjango App. I often got this error: fatal flex scanner internal error--end of buffer missed that makes python to crash ...
0
votes
0answers
19 views

Storing Image data to spatialite [duplicate]

Possible Duplicate: spatialite storing raster data I want to store geotiff data to spatialite databse. I am using gdal to read metadata and reading tiles convering them to hexwkb format and ...