A self-contained SQL database engine.

learn more… | top users | synonyms

2
votes
1answer
91 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
6 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 ...
0
votes
1answer
54 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
28 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
56 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
70 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
47 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 ...
4
votes
1answer
99 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
85 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
43 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', ...
1
vote
1answer
52 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
106 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
37 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
161 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
64 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
80 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
95 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
82 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
83 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 ...
0
votes
1answer
61 views

Updating static GTFS data android

I have an android application that takes a static GTFS data that I manually turned into a database. My question is how do I update this GTFS data automatically? Or is that not possible? Any ...
0
votes
1answer
61 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 ...
0
votes
0answers
34 views

csvsql SQLite --insert causes ID to change

I have a question that stems from a solution provided in this Question: Join a CSV file to shapefile using gdal/ogr? I've been using this to do joins successfully but for some reason, I have a field ...
1
vote
1answer
119 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 ...
0
votes
0answers
120 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
202 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 ...
1
vote
1answer
94 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
0answers
89 views

Error when loading ST_Geometry into SQLite

I have created a new .sqlite database running the arcpy code in ArcGIS 10.3 (with Python x86): import arcpy sqlite_database_path = 'C:/Data/Counties.sqlite' ...
0
votes
0answers
54 views

What replaces SQLserver SqlGeometryBuilder, for Windows store apps?

Porting Visual Studio 2008 C# application to Visual Studio 2013, Windows 8.1 store\phone app (need to include DB with the application). What DB to use (coding in c#), to replace this code, not sure ...
0
votes
1answer
35 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
115 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
114 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
913 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
322 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
165 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 ...
1
vote
1answer
98 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 ...
1
vote
1answer
253 views

SQLite instead of gdb

I use ArcGIS and Qgis and I want to have common protocol and format of my files. To use a separate file for each program is not the best way, I don’t want to make a mess of data. I would ask if SQLite ...
2
votes
0answers
984 views

Sqlite insert java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: SRID)

I'm trying to connect to two DBs and then copy tables by inserting rows from one table to another through java using JDBC. I'm using sqlite-jdbc-3.7.2.jar plugin.The setup is in Eclipse Luna. I'm ...
0
votes
1answer
107 views

Lost Foreign key during conversion of SQLite to PostgreSQL using ogr2ogr

I want to centralise several small sqlite databases into a single, big, postgresql database. I am using ogr2ogr to convert my sqlite / spatialite (v3.7.17 / v4.1.1) databases, each one consisting of ...
0
votes
1answer
46 views

Any consideration of moving QGIS project file to SQLITE form XML? [closed]

Just curious, has anyone ever proposed storing the ".qgs" project file in SQLITE instead of XML? Seems like it might be faster, easier to parse, and you could hide the changes behind an API. But I ...
2
votes
1answer
120 views

How to rename ogr2ogr tables on export to Spatialite?

I'm exporting data from PostGIS to Spatialite using ogr2ogr. The export is working properly, except I need to be able to rename the tables that are being exported. Here's the command I'm using: ...
1
vote
0answers
113 views

Loading SQLite extensions in QGIS

I have an extension which can be loaded in SQLite using the load_extension function. It would be useful for me if I could load it in QGIS to use in queries made via Database Manager. The Python ...
9
votes
3answers
325 views

A global, grid-like projection for creating heatmaps

I'm putting together an application where I need to create a vector grid which will be used to store and display a heatmap. It has the following requirements: Can cover the entire planet. The vast ...
1
vote
1answer
84 views

Get DE-9IM matrix in spatialite?

Is there a way to get the DE-9IM matrix between two geometries in a Spatialite function, analogous to the st_relate() function in PostGIS? (I find it very helpful to spatially join using intersect() ...
2
votes
1answer
193 views

SetFeature creates infinite loop when updating sqlite feature using OGR

when using the SQLite driver in python - setting a feature after changing an attribute field value creates an infinite loop on the first record. the same code works fine if i substitute the sqlite ...
0
votes
1answer
205 views

How to union polygons and add attribute values of combined output features

I have a layer containing 10 polygons all overlapping at various locations. Each polygon has a value of '1' in a column called "value" How do I Union the polygons (rows) together such that the ...
2
votes
0answers
365 views

Performance issue with SQLite + Spatialite + C#

I am having a performance issue with SQLite database (.db) which extends to SPATIALITE I am trying to update Geometry of 1,00,000 records in database (.db) which taking around 50 minutes. Too much ...
1
vote
1answer
166 views

What is format of Natural Earth SQLite database GEOMETRY column?

I need to extract coordinates of polygon boundary points in order to draw a map in my application. Does anyone know what is format of "GEOMETRY" column in this database? It doesn't look like .SHP ...
0
votes
1answer
192 views

PtDistWithin() with Geometry from query

I'm trying to run two Spatialite queries in Python — the first one picks a single point from a table, and the second tries to find all points that are within a given distance of it. So my queries look ...
1
vote
1answer
466 views

Looking for RMaps SQLite format details

Locus Maps and Rmaps Android maps support an offline sqlite Format called Rmaps. I am trying to find the format details and how its organized. I couldn't, is there any dependable documentation online? ...