New answers tagged

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 ...
user avatar
  • 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 ...
user avatar
  • 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=...
user avatar
  • 187

Top 50 recent answers are included