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 ...
- 51.4k
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 ...
- 111
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=...
- 187
Top 50 recent answers are included