New answers tagged spatialite
1
vote
Accepted
Spatialite: insert points, do knn search. how to?
Before you can use KNN or KNN2 the table must be registered into "geometry_columns" with RecoverGeometryColumn, and it must have a spatial index created with CreateSpatialIndex.
The ...
2
votes
SpatiaLite visibility problem in QGIS
I guess it is beacause a broken spatial index or broken geometries. Most of the time i am able to fix it with recovering the spatial index:
SELECT RecoverSpatialIndex(1);
or recreate the geometries ...
1
vote
ogr2ogr PostGIS to SpatiaLite: convert hstore to json
Yes. This can be done in two ways :
Direct export (using ogr2ogr):
ogr2ogr -f SQLite -progress -dsco SPATIALITE=yes ./testmap /psql_tags2.sqlite PG:"host=localhost port=5432 dbname=gis user=...
Top 50 recent answers are included
Related Tags
spatialite × 654qgis × 283
sqlite × 113
python × 56
sql × 49
postgis × 40
ogr2ogr × 36
openstreetmap × 34
shapefile × 26
pyqgis × 25
ogr × 20
geopackage × 19
coordinate-system × 17
qgis-3 × 16
gdal × 15
spatial-database × 15
spatialite-gui × 14
geometry × 13
virtual-layer × 13
qgis-plugins × 12
database × 12
qspatialite × 12
geodjango × 11
editing × 10
android × 10