Create spatial index on all geography column

Apr 28, 2014 at 3:46 PM
why there is no spatial index on the geography column ? It would seem logical as speed a lot the geo queries and some software need a spatial index column to work with.
Also an option to use a geometry instead of geography would be useful because some software only handle geometry.

More info here :

Apr 28, 2014 at 3:51 PM

there should be one, because for that there is the "TaskCreateSpatialIndices" which is creating it. Unfortunately i haven´t maintained the to code for a while, possible i will do soon - hopefully.

Apr 28, 2014 at 4:09 PM
I just saw it, but I had to create the indicies, I don't know why it didn't.

Jun 10, 2016 at 4:10 PM
It's because the TaskCreateSpatialIndices function uses the same index name for both indices. Try changing "idx" to "spidx_tWay" and "spidx_tNode" for the two different tables.