Tagged Questions
0
votes
0answers
25 views
Spatialite, to speed performance, when should I create Views, Indexes or additional spatial tables?
I’ve got a large Spatialite database with a table of lines (roads, rail and water). I created a spatial index of the geometry to speed things up.
This works amazingly well when I’m zoomed in ...
3
votes
2answers
1k views
How can I use R-Tree to find points within a distance in Spatialite?
Create a table with 3D points:
create table points (coords pointz);
select CreateSpatialIndex('points', 'coords');
Insert 13k rows:
insert into points values (geometryfromtext('pointz(...)'))
Do
...
3
votes
1answer
362 views
Shorter Version of this SpatiaLite Query
I've been doing some spatial queries using spatialite, and they're large enough that a spatial index becomes a must. An example of using an index is given in the tutorial
spatialite> SELECT ...
2
votes
2answers
363 views
How to delete a broken index in SpatiaLite?
I managed to screw up an index in my SpatiaLite database. The index was created using spatialite-gui. In the meantime, I deleted the original table and three out of four index files: ...
