Questions tagged [sqlite]
A self-contained SQL database engine.
1
vote
0answers
22 views
Losing data when offline editing in QGIS?
I am working with QGIS 2.18.15 and I have a problem. I made an offline project, then a sent to my colleague, also the .sqlite file too. He edited it, made new objects and changed some attributes. Then ...
2
votes
0answers
14 views
Extracting polygons from mbtiles
Currently, one can extract features within a bounding box from an mbtiles file using tilelive-copy. However there is no way to extract features within a polygon from an mbtiles file.
The mbtiles-...
0
votes
1answer
16 views
Mapcache + SQLite
i tried to configure mapcache to use with sqlite database, but i have some problems. I want make cache for four layers, but i dont know, how to do this. When i make more tilesets, i get error: ...
0
votes
0answers
18 views
Cannot open the sqlite database in ArcMap 10.2
I cannot open the SQLite database in ArcMap 10.2, and the warning window shows
Could not add the specified data object to the map. Underlying DBMS
error[unrecognized token: "........"]".
How to ...
7
votes
1answer
72 views
Creating SpatiaLite view (for use in QGIS) from non-spatial SQLite database?
I have a plain SQLite database that contains X, Y coordinates in a table. Data are edited via an MS Access front-end using the ODBC driver and so I want to avoid storing them in a geometry blob that ...
0
votes
0answers
13 views
How to get the identify form to load with SQL query view?
I've loaded an SQL query on a table in a spaitalite database as a view.
The view has loaded fine and the attributes table is showing all the data, but the Identify tool won't bring up a form. Is there ...
0
votes
1answer
48 views
How does QGIS 3.2.3 handle or create spatial indexes within a geopackage?
My frame of reference is:
Does QGIS automatically use spatialite spatial indexes?
This explain that QGIS uses QgsSpatiaLiteFeatureIterator for Spatialite Data Provider
Spatial indexes in GeoPackage ...
0
votes
0answers
21 views
vector .mbtiles merging as grid structure from tilemill export
GIPHY Link for visual troubleshooting
I have been using Tilemill .mbtiles exports as 1 degree bounded grids with uniform 5-17 zoom levels. I'm able to run the following merge tutorials, but each with ...
1
vote
1answer
75 views
Installing Spatialite on Centos7: select mod_extension() doesn't work
I'm trying to install Spatialite on a CentOS 7 server.
Sqlite (version 3.7.17 ...), works fine.
Using the command
yum list | grep spatial
the result is the follow
So I've installed Spatialite ...
1
vote
1answer
63 views
How do I insert rows into a spatial table within a geopackage file via a SQL INSERT statement?
I am attempting to insert rows into a spatial table within a geopackage file using DBeaver 5.1.1.
I receive an error from the triggers, referencing functions that don't exist: ST_IsEmpty. Do I need ...
0
votes
0answers
18 views
Loading format other than shapefile with ArcGIS runtime 100
I know how to load a feature table for ArcGIS runtime 100 in C#
ShapefileFeatureTable myShapefile = await
ShapefileFeatureTable.OpenAsync(Path);
FeatureLayer fl= new FeatureLayer(myShapefile);
But ...
1
vote
2answers
284 views
Importing Survey123 SQLite Database from Device
I need to import an SQLite database generated by ESRI Survey123 to a csv or some other useful format. I modified this script so that I can use arcToolbox to acquire input and output parameters. I am ...
1
vote
0answers
42 views
Adding SpatiaLite to Visual Studio project (already has SQLite)
I am very new to SpatiaLite.
I am working on a large Visual Studio C++ project that already supports SQLite, and I am trying to add SpatiaLite capabilities to it.
After reading the documentation and ...
1
vote
1answer
137 views
ogr2ogr mapFieldType giving an error
I am trying to convert a GeoJSON file into an SQLite database and I want to set to INTEGER a specific field in the SQLite final file.
I use the following command line:
ogr2ogr -f SQLite -...
0
votes
0answers
34 views
Which versions of ArcMap support editing SQLite geodatabase tables and in what capacity?
I am attempting to help a co-worker troubleshoot some issues with using SQLite geodatabase in ArcMap. But I am having a heck of time trying to work out what actually is/isn't supported at which ...
2
votes
0answers
117 views
ogrinfo: Unable to use sqlite dialect with -oo GEOM_POSSIBLE_NAMES open option
I am having problems using the SQLite SQL dialect to read a CSV file using ogrinfo, but only if I also specify a geometry column using the -oo GEOM_POSSIBLE_NAMES open option. Suppose file test.csv ...
0
votes
0answers
35 views
ogr2ogr: extract text elements from PDF into attributes
I have PDF created by the local geodetic authority which is kind of geospatial and contains layers of cadastre underground services (water, sewer, etc) as lines, points, and textual attributes ...
0
votes
0answers
58 views
Storing a Spatial Index in Sqlite
I would like to store an r-tree or quadtree index in a sqlite database using python.
Does anyone know if there is any code to do this?
A bit of background:
The dataset cannot be moved to another ...
1
vote
2answers
212 views
How to connect to a SpatiaLite database using ogr in Python?
I need to connect to a SQLite/SpatiaLite database to copy data there. I have done the same with PostgreSQL/PostGIS like this:
connection_string = "dbname={} user={} password={} host={} port={}"....
1
vote
2answers
111 views
Unique constraint for SpatialLite geometry column
I am creating a SpatiaLite database where I want to ensure that the contents of the geometry column for a table are unique. For normal SQL I would add a UNIQUE constraint to that column but, I don't ...
1
vote
2answers
56 views
How to make an arrow from a polygon centroid to a point
I would like to present in QGIS a graphical information I have in two vector layers, an arrow. One layer has catchemnt areas as polygons and the other has the outlet points. The catchment areas layer ...
1
vote
0answers
40 views
ESRI Runtime Geodatabase Shape storage
Does anyone out there know the geometry storage encoding for ESRI's Runtime Geodatabase (.sqlite) format? aka mobile geodatabase.
There are GDB_ tables, st_ tables, RTREE indexes and other fairly ...
1
vote
0answers
49 views
SQLITE - Buffer 30 m
I have a DB in SQlite with several layers. I would like to perform a spatial analysis, by buffering several water lines with 30m from origin.
I am using DB Manager in QGIS 2.14 and the SQL statement ...
0
votes
1answer
90 views
What is the max amount of connections a GeoPackage can handle in GeoServer?
I'm currently working on a GeoServer deployment and for simplicity, I want to to transition to using GeoPackages rather than Shapefiles (longer column names, less work integrating the data, etc.).
As ...
3
votes
1answer
134 views
Sqlite ERROR: Too many connections: max 64
I would like to use the ST_SingleSidedBuffer SpatiaLite SQL function to create one-sided buffers around all lines in a layer. The following functions works fine, until the 64rd iteration. Then the ...
2
votes
1answer
77 views
How to reference piped input in ogr2ogr SQL statement
I have a geojson data set that I am piping into an an ogr2ogr command using /vsistdin/. However, I am having trouble figuring out how to actually refer to this input in the SQL statement I'm running. ...
2
votes
1answer
111 views
How to use spatialite SQL functions in GDAL/OGR
I would like to create one-sided buffer geometries around linestrings. I found this ST_SingleSidedBuffer SpatialLite function that I would like to use in my Python script.
When I run the function ...
1
vote
0answers
100 views
Converting OSM.PBF to Geopackage in CLI?
I would like to refresh this tutorial for my purposes - background vector map in one file - just to load in QGIS.
My idea is a script doing this:
Import directly downloaded Openstreetmap PBF file (...
0
votes
0answers
185 views
How can I build GDAL/ogr for Android which supports sqlite driver with Android Studio?
I'm working on an Android application with Android Studio. I want to use GDAL/ogr C++ library to convert two vector formats. Here, I want to convert Sqlite/Spatialite database to ESRI Shapefile. I ...
4
votes
1answer
198 views
Spatial indexes in GeoPackage files
I'm working with GeoPackage files built with QGIS3.
I tried to execute some spatial queries but it was really slow, so I'd like to speed it up with indexes.
After some readings I tried
create ...
0
votes
2answers
76 views
TileMap: How to convert MBTiles to RMaps SQLite?
These two map formats look very similar (based on SQLite and Tiled Maps).
I am looking for method to convert maps from mbtiles to RMaps SQLite and vice versa without quality lost.
2
votes
1answer
103 views
Open a Spatialite database in PHP
I need to open a Spatialite database by using php in a php's framework. I've already work on a basic php file to test how it work but it gave me some errors.
I've already try to load extension by ...
0
votes
0answers
85 views
Get tile images directly from sqlite database
I'm trying to get map tile images to display in my application. I created a sqlite database and used WMS Lite server to request map tiles using GetMap syntax.
wmslite?SERVICE=WMS&VERSION&...
1
vote
1answer
188 views
Saving styles for all layers using PyQGIS - SLD, QML, databases
I wrote a script (for QGIS 3) that saves styles for all visible vector layers in QML and SLD files:
import processing
self=qgis.utils
layers = self.iface.mapCanvas().layers()
for layer in layers:
...
1
vote
1answer
192 views
Spatialite 4.3 err: no such function: gpkgAddGeomtryColumn
I'm opening a GeoPackage made by QGIS 2.18.17 then closing it and opening it with:
spatialite_gui (spatialite lib loaded:4.3.0a)
DB Browser (SELECT load_extension('mod_spatialite');)
Spatialite libs ...
2
votes
1answer
62 views
Is it possible to replace the SQLite library in QGIS?
On Linux I was able to use the JSON1 extension by default on a layer from a SpatiaLite database connection, but on Windows (QGIS 3.0 via OSGeo4W) it isn't enabled. Is it possible to replace the SQLite/...
1
vote
1answer
70 views
How to use sqlite symdifference with ogr via command line
I am trying to use the sqlite symdifference function in windows command line with ogr but can't seem to get the syntax right. Here is what I have:
ogr2ogr -dialect sqlite -sql "select symdifference(a....
4
votes
2answers
205 views
Split planet.osm into multiple files based on UTM grid
Starting with the full OSM Planet data, I'm trying to create smaller, individual osm/pbf files, or eventually Spatia/SQLite or GeoJSON files, that are split on each UTM grid zone. I'm using osmfilter ...
1
vote
1answer
104 views
Different performance of counting features in ogr.Layer returned from ExecuteSQL
I am working on a PyQt5 desktop application GDBee which allows executing SQL queries against Esri file geodatabases using GDAL. My development environment is Windows 10 64bit, Python 3.5, and Python ...
4
votes
1answer
506 views
select by location using ogr2ogr sqlite
I have a shapefile containing polygons and a shapefile containing points. Now I would like to select the polygons that contain points.
How can I do this from the command line using ogr2ogr?
2
votes
2answers
141 views
Return integer in QGIS Spatilite query
How can I ensure that the SQL query will return a field containing integers and not text?
I am using a Spatialite DB for my QGIS project (QGIS 2.18). One of the task is to count the occurrences of ...
0
votes
0answers
66 views
Import multiple sqlite databses to QGIS simultaneously
I'm working on a water supply project. The goal of the study is collect datas about the water supply network then map it.
To do so, I'm using QField as a technology of data collection.
Qgis,using ...
1
vote
2answers
193 views
How to export geometry as a table in QGIS
I am trying to use Qgis to produce the input file for SWMM and the first step is to produce the geometry tables. I need to export the geometry of elements as a tables with these format:
(poygons)
;;...
1
vote
1answer
62 views
Host a WMS service from MapProxy SQLite cache?
I'm trying to start a WMS server that would not have access to internet and for a source, I have the SQLite layers cache from MapProxy .
I read the manual and saw that I could probably work with a ...
1
vote
0answers
228 views
SQLite / Geopackage and saving Geometry in ArcGIS
Has anyone successuflly created a layerfile (ArcGIS 10.4) to a dataset/table stored in a SQLite or Geopackage file?
Process of creating Layerfile: ArcMap TOC > Change Symbology > Right click > Create ...
3
votes
1answer
127 views
within polygon: why SpatialIndex slow down query
I create such simple demo table:
CREATE TABLE IF NOT EXISTS tbl1(id INTERNAL PRIMARY KEY UNIQUE, name TEXT NOT NULL);
SELECT AddGeometryColumn('tbl1', 'geom', 4326, 'POINT', 'XY');
SELECT ...
4
votes
1answer
61 views
Why won't ogrinfo write to new column using informaiton from previous columns?
I'm having problems classifying an area of mixed forest using ogrinfo.
I have an .sqlite file which contains the three columns; proportionclass1. proportionclass2, proportionclass3.
I'm trying to ...
0
votes
0answers
146 views
Install gdal in centOS with SQLite option
I want to install gdal on CentOS with sqlite, I downloaded the version 1.11.2 from here, but when I configure it with sqlite I get that is not availabe(see the screenshot 1)
After I compiled it ...
1
vote
0answers
30 views
How can I find “UUID” in “gdb_items” ? In “gdb_items”, “UUID” values are missing
I need to find "UUID" values in "gdb_items", can I find the values via relationship with other tables?
Note: I have other values in "gdb_items", all fields are fine except the "UUID" field. I just ...
4
votes
2answers
126 views
Moving SQLite database without getting 'bad layers' dialogue in QGIS?
I would like to move an SQLite db to a new directory on my computer. The SQLite file is in the same folder as a Qgis project file. I copied the parent folder to a new location. When I try to open ...
