Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sqlite
Search options answers only
not deleted
user 30184
A self-contained SQL database engine.
2
votes
Accepted
How to create temporary tables in spatialite?
I do not believe that the AddGeometryColumn part is possible at all. This thread tells that it is not possible to use it for attached databases https://groups.google.com/forum/#!topic/spatialite-users …
- 69k
1
vote
Accepted
Inserting XY POINT (EPSG 4326) fails in sqlite3 shell
It seems that some distributions have started to compile SQLite with this more safe compile-time option. …
- 69k
0
votes
Accepted
Is it possible to replace the SQLite library in QGIS?
The safe way would be to compile the whole stack SQLite-GDAL-QGIS from the scratch which is not trivial on Windows. … Consider writing mail to osgeo4w-dev mailing list https://lists.osgeo.org/mailman/listinfo/osgeo4w-dev and suggest to compile SQLite with JSON1 enabled. …
- 69k
1
vote
Accepted
Unique constraint for SpatialLite geometry column
EDIT
The better way than to rely in plain SQLite and UNIQUE constraint would be to write a trigger that uses the SpatiaLite fucntion ST_Equal http://www.gaia-gis.it/gaia-sins/spatialite-sql-latest.html …
- 69k
4
votes
Accepted
ogr2ogr missing geometry when selecting from one sqlite db into another
There are different ways to store spatial data into SQLite database and your command
ogr2ogr -f SQLite bar.sqlite foo.geojson
creates a FDO style database. … SQL dialect that is used against SQLite databases supports basic SQLite functions and SpatiaLite functions https://www.gaia-gis.it/gaia-sins/spatialite-sql-latest.html. …
- 69k
1
vote
Accepted
ogrinfo st_area for geopackage returns invalid target SRID
GDAL supports SQLite dialect through a virtual table mechanism of SQLite https://gdal.org/user/sql_sqlite_dialect.html. … You can force the SQL query to use external SQLite engine even with GeoPackage by using another version of SQLite dialect -dialect indirect_sqlite. …
- 69k
0
votes
How to use ogr2ogr and sql in Python?
Works for me when I run the script from OSGeo4W shell
c:\temp\ogrinfo.py -dialect sqlite -sql "select sqlite_version()"
dummy.shp
INFO: Open of `dummy.shp'
using driver `ESRI Shapefile' successful … The error suggests that you do not but Python finds some GDAL version that is compiled without SQLite. …
- 69k
5
votes
Accepted
within polygon: why SpatialIndex slow down query
Think about what your sub-query is really doing:
WHERE tbl1.ROWID IN
(select ROWID from SpatialIndex where f_table_name= 'tbl1'
AND f_geometry_column='geom'
AND search_frame = tbl1.geom);
The qu …
- 69k
3
votes
Return integer in QGIS Spatilite query
Feature Count: 49
Extent: (-124.731422, 24.955967) - (-66.969849, 49.371735)
Geometry Column = geom
len: String (0.0)
OGRFeature(SELECT):0
len (String) = 8
I believe that this test proves that the SQLite …
- 69k
2
votes
Accepted
Can a Geopackage style be deleted through SQL window in DB Manager?
The limitation is not in SQLite but obviously in the way how QGIS is making the connection to SQLite database. … I guess that QGIS could be safely made not to do the same-thread check because SQLite has had the support for 12 years now. …
- 69k
5
votes
Accepted
GeoPackage, SQLite: features count but don't exist (QGIS)
I guess anyway that the SQL tool that you used edits the SQLite table directly in the same way than DB Browser for SQLite without going through the GDAL driver and therefore does not update the feature_count …
- 69k
1
vote
No ST_* spatial functions are available in SQLite3
The ubuntu-small dockerfile is built without SpatiaLite. Use ubuntu-full instead
https://github.com/OSGeo/gdal/blob/master/gdal/docker/ubuntu-full/Dockerfile
It seems to download libspatialite-dev and …
- 69k
0
votes
Rebuild spatial index after massive changes
In SQLite it is expensive to begin and end a transaction. …
- 69k
5
votes
Accepted
Can't query GeoPackage geometry via SQLite client
Geometries in SpatiaLite are not encoded in the same way than geometries in GeoPackage. The AsText/ST_AsText function needs a SpatiaLite geometry as an input. The function returns NULL for GeoPackage …
- 69k
1
vote
Importing NAS Data into SQLite database?
Actually you do not create a SpatiaLite database but a "regular" SQLite database where geometries are stored as FDO geometries. … Unfortunately with SQLite databases it is quite slow to make a transaction. Try first without -skipfailures. If there are no errors you will get the job done much faster. …
- 69k