A self-contained SQL database engine.

learn more… | top users | synonyms

1
vote
1answer
34 views

OSM2 VectorTiles lat/long to tile

After a frustrating few days I came to the conclusion that the Slippy Map Wiki only works for raster tiles, not for OSM2VectorTiles data. I can work with the data once I find the correct tile_data ...
1
vote
2answers
38 views

Add a geometry in sqlite in pyqgis

I'm trying to create a geometry column in a table which I created. I found the following code: cur.execute('SELECT addgeometrycolumn(%s, %s, %s, %s, %s)' %(table_name, geometry_column_name, EPSGcode,...
1
vote
1answer
37 views

QGIS Offline Editing Tool

I tried to test the QGIS Offline Editing Plugin but it appears not to work at all. I'm using qgis 2.14.3 running on a Lenovo Yoga 900 and Windows 10 on the client side. For the server I'm running ...
1
vote
2answers
68 views

python gdal - libgdal.so.1: undefined symbol: sqlite3_column_table_name

I just reinstalled my python environment (and my whole Ubuntu). In python (or IPython), when loading geopandas: import geopandas as gpd or when I import fiona: import fiona I get this error ...
2
votes
1answer
44 views

Attribute field name is not case-sensitive anymore after creating new layer

I joined a sqlite layer with a csv table (each attribute field name starts with a capital letter). When I create a new layer out of them ("save as", e.g. as a new sqlite layer with all data combined), ...
1
vote
1answer
42 views

Merge Natural Earth SQLite country polygons using ogr2ogr and ST_Union

I'm trying to create a map with the world continents (with a few modifications). As a source I use a sqlite file from Natural Earth. I already introduced my modification in the definition of the ...
1
vote
2answers
46 views

Find centroids of rows with Multipoint Geometry

I wish to find the centroid of a set of given points. The points will be rows of my SpatiaLite database and have Multipoint geometry. I checked the SpatiaLite manual but the ST_Centroid function I ...
1
vote
1answer
22 views

InitSpatialMetaData errors with Spatialite

This Stackexchange may not be the best place for this question but I will start here. I am trying to create a spatially-enabled, sqlite3 database. The following code is a short example of what I am ...
0
votes
0answers
29 views

GRASS GIS: g.run_command (“db.select”) in Python with sqlite for several timestamps

I am working with GRASS GIS 7.03 and want to extract the coordinates from the vector data of the attribute table "rec_TRACK_RG" by using the maximum and minimum values of the column "time" from the ...
3
votes
1answer
65 views

Are calculated fields available in any database that Qgis can use

I'm trying to find a data storage method that can handle up-datable calculated fields (such as population density=population/area). I want to be able to alter the population as the data changes (like ...
0
votes
1answer
28 views

Spatialite union more than two layers / tables

Is there a way to union or collect any number of layer geometries with Spatialite (or another spatial database)? Two is simple enough, but more than that becomes convoluted. For example, if all I want ...
2
votes
2answers
43 views

Using QGIS, how to save an attribute table as sqlite?

With 2.14.1 under Windows 10, I am trying to save a .dbf attribute-only table as a .sqlite table. However, the response is an error. My procedure: right-click the .dbf in the QGIS table of contents ...
0
votes
0answers
22 views

Using SpatiaLite with Clion

What is the easiest way of importing the SpatiaLite (C++) with the Clion IDE ? I have been trying all sorts of different ways, but nothing seems to work. Does anyone know how ?
1
vote
1answer
61 views

How to get the long/lat information from a NodeID and vice versa

In the SpatiaLite website they explain how to use .osm data to create a SpatiaLite database, that contains a single table, where each row is an arc of the road graph. Then, they explain the procedure ...
1
vote
0answers
40 views

Sqlite layer from Autocad MAP in qgis editing problem

Sqlite files generated with FDO (autocad MAP) have FGF geometry instead of WKB. FGF is an extended version of the Well Known Binary (WKB) format. Qgis can read these layers but they cant be edited, ...
1
vote
1answer
38 views

Truncate a Shapefile field with SQL and ogr2ogr

I want to create a new attribute which is the first 8 characters of another, using ogr2ogr. To my surprise, this didn't work: ogr2ogr -f "ESRI Shapefile" a.shp b.shp -sql "select FID,left(FLOORKEY,8) ...
0
votes
0answers
22 views

Fetching the table data from SQlite db in QGIS throws an error

I have exam.sqlite db and it contains 4 tables as t1,t2,t3,t4. from pyspatialite import dbapi2 as db sqlite_file = r'D:\Folder\exam.sqlite' conn = db.connect(sqlite_file) ...
2
votes
2answers
654 views

Concatenate or group by values using spatial join in QGIS?

I have a layer (SQLlite) of city lots and would like to accomplish the following: For each city lot, concatenate the list of unique lot id's which are bound within a radius of 30m from the given ...
0
votes
0answers
29 views

Null output from Transform function of Spatialite

I am using Spatialite, an extension of SQlite and I have some problems running the transform function. According to the Spatialite functions page (http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2....
0
votes
1answer
73 views

QGIS - what is the core database system? [closed]

What is the core database system used by QGIS? When you launch an existing project that has multiple .shp files (with associated .dbf tables), is the core db system used to convert that data to its ...
2
votes
0answers
32 views

Shapes & categories

I am very new to this so please only smile if a dumb question. I have divided the oceans into 31 regions. Each region has various sub regions, example I have region 08; of which it is further broken ...
2
votes
1answer
71 views

Creating SpatiaLite View in QGIS?

Using these instructions (there are several other examples to find, all look the same and all of them seem to work) http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/sp-view.html "Hand-writing ...
0
votes
1answer
123 views

DBMS Table Not Found with SQLite and ArcGIS 10.3

I'm trying to set up a spatially enabled SQLite database with ArcGIS 10.3. I've gone through the following steps: Create a database using the sqlite3 utility: sqlite3 mydatabase.sqlite Load the ...
2
votes
1answer
168 views

Spatialite not loaded in PHP5 on Ubuntu

I'm trying to install Spatialite (4.3.0a) on Ubuntu (14.94.2 LTS) ..... I'd like to use it with PHP (5.5.9-1) .... Following this post https://faimsproject.atlassian.net/wiki/display/FAIMS/...
4
votes
1answer
151 views

Converting Python script for QGIS?

I am still a novice in python, but I have the long term goal to create a plugin one day. The first step to this plugin is a test with QGIS python scripts to convert an Access mdb into sqlite db and ...
3
votes
0answers
128 views

Dissolving polygons in a large dataset

I need to dissolve polygons by the ID attribute in a large dataset (+-1gb shapefile). I have been struggling to find an efficient method to do this. I have tried the following methods: Postgis ...
1
vote
0answers
34 views

Extract raster values to multipoint shapefile and write to new field using gdal/python [duplicate]

I have a raster with one band and I would like to query a set of overlying points (.shp) to determine how many points as well as which points points fall under a range of certain pixel values ...
1
vote
1answer
49 views

Compare and modify changes amongst GIS and MIS data

import arcpy import sqlite3 # the column names columnNames = ["ASSETNUM", "DESCRIPTIO", "INSERVICE", "ENGINEID"] data = [] with arcpy.da.SearchCursor(r'E:\mypathtoshp\Fire_Hydrants.shp', columnNames)...
1
vote
1answer
134 views

Export/Import Shp file records to sqlite table

I am new to python and ArcPy. I need to transfer all the records of a single shapefile to a table created in sqlite3 without the geometry. So far I was only able to retrieve the records using ...
1
vote
2answers
311 views

Registering a database on Arcgis with operating system authentication

I have a ArcGIS server and ArcMap on the same machine. I have a sql database that I have been using on ArcMap that I would like to register with the server for the purpose of publishing services. ...
3
votes
1answer
61 views

OGR update using case statement

I am looking at updating a number of large shapefiles using ogrinfo and UPDATE. I would like to perform a CASE function to update specific fields with specific values. Is it possible to perform CASE ...
2
votes
1answer
381 views

Loading mod_spatialite using sqlite3 for Python in Windows

I have been successfully using the mod_spatialite extension for sqlite in Linux for a while now, but a client wants an application that relies on mod_spatialite to work in Windows. I have extracted ...
1
vote
2answers
108 views

ogr2ogr unreadable dbf file header

I'm trying to convert Mapinfo tab file to ESRI shapefile using ogr2ogr either with sqlite dialect or without. When using sqlite dialect, ogr2ogr -overwrite -f "ESRI Shapefile" -dialect sqlite -sql "...
0
votes
1answer
160 views

How to install OSM .pbf support in GDAL on Debian?

I'm trying to use Anita Graser's post on loading OSM data from .PBF files into a SQLite .db file using ogr2ogr but it stopped working. I'm trying to run the following command: ogr2ogr -f "SQLite" -...
1
vote
0answers
161 views

Geoserver MBTiles plugins performance issues

I am using the latest stable 2.7.2 version of GeoServer and I am trying to play with the MBTiles plugin, I have installed also WPS plugin that is needed by the MBTiles one (otherwise I got error when ...
0
votes
1answer
131 views

Qgis 2.10 unable to add a new feature in spatialite via sql function “GeomFromText”

Using Python code in my plugin the function in sql language "GeomFromText(POINT(X Y))" gives the following error: "OperationalError: no such function: GeomFromText" Plugin functions in previous ...
3
votes
1answer
110 views

Convert shp 2 sqlite with correct character encoding

I want to convert Shape data with the QGIS browser in the SQLite database . Unfortunately, the umlauts then appear with a mark (see screen shot ) . I do not want to change the UTF-8 encoding for each ...
1
vote
1answer
108 views

Updating static GTFS data android

I have an android application that takes a static GTFS data that I manually turned into a database. How do I update this GTFS data automatically, or is that not possible?
0
votes
1answer
92 views

Problem importing sqlite into Postgres (with PostGis) using ogr2ogr

I am trying to import a very large sqlite file into Postgres SQL 9.3. The first tool I tried to use was OGR2GUI (http://www.ogr2gui.ca/). The 64 Bit version does nothing, whilst the 32 bit version ...
1
vote
1answer
186 views

spatialite : spatial index on geometries

I'm currently learning to use spatial access methods for query optimization. I'm going through the examples in spatialite cookbook and got stuck in here http://www.gaia-gis.it/gaia-sins/spatialite-...
0
votes
0answers
174 views

Converting SQLite db file into .kmz?

How to convert SQLite db (map data) into .kmz format. I am unable to connect already downloaded sqlite db file to Global Mapper application. I have downloaded these files on my android mobile.
0
votes
1answer
368 views

ST_Intersect with ogr2ogr and Spatialite

I am trying to intersect Spatialite datasets with ogr2ogr, the OGR Virtual Format and SQL Syntax. I can't seem to locate whether the error is in my SQL query or my VRT file. Data rice_temperature....
1
vote
1answer
125 views

SQLite db with FDO geometries: how to assign ID of point in layer A to closest point in Layer B with SpatiaLite?

How can I assign ID of point in layer A to closest point in Layer B with SpatiaLite (find nearest neighbors for each point in A)? For each point stored in table fdo_fc1 I would like to select one, ...
0
votes
1answer
37 views

Pycsw Harvest SOS Error Exception

when I used the Harvest operation by the pycsw, and there was a Exception as the following picture: Picture 1: The Response of Harvest Operation Picture 2: The document default.cfg setting so how ...
2
votes
1answer
161 views

QGIS Python SQLite using variable

I have been looking for answers and working on this for many hours. In the spatialite database table nodes, id is an integer. idValToNode = 854 sql = 'UPDATE nodes SET obsolete = 0 WHERE id ...
0
votes
1answer
126 views

How to inverse Y axis

I have a SQLlite database containing cached tiles with X,Y,Z fields and I want to use it in MapCache. My Y field is appearing upside down in Google tile index but I want to inverse it like this: ...
4
votes
1answer
1k views

Can't install QGIS 2.6.0 need SQlite3 on OSX Yosemite

I need to install QGIS on my mac with 10.10 Yosemite, I have already installed: - SQLite3_Framework-3.8.7.3 - GDAL_Framework-1.11.1-2 - GSL_Framework-1.16-1 - NumPy-1.8.0-1 but when I launch QGIS.pkg ...
2
votes
1answer
453 views

ogr2ogr + MapInfo TAB + SQLite (SpatiaLite) = unicode problems

I'm adding MapInfo TAB files to SQLite (SpatiaLite) database using those arguments: ogr2ogr -f "SQLite" dataset.sqlite somelayer.tab -dsco spatialite=yes Source file somelayer.tab have ...
1
vote
1answer
212 views

How to create temporary tables in spatialite?

How do you create a temporary table with geometry column in spatialite? I have tried: CREATE TEMP TABLE rivers (code INTEGER, id INTEGER, name TEXT); Followed by: SELECT AddGeometryColumn('temp....
1
vote
1answer
132 views

SQLite database to Feature class

I am somewhat new to programming and the SQLite world. I am looking for a way to take data from and SQLite DB and populate feature classes. The feature classes are all polygons and the intent is to ...