Ioanna

What if you convert every geometry to a **geometry collection** consisting of a single geometry (ST_Collect)? Does is indexing work with **geometry collections**?

@arya-hemanshu did the spatial index on Geometry Collection type work?

When testing spatial intersection between 1,000 features of a table, having a spatial index did not show any major speed performance (1.4 sec. without spatial index, 1.3 sec with spatial...

@arya-hemanshu The queries are different indeed. The difference is that the second one is not only using the `ST_Intersects` but also the `&&` operator. That operator is used to first...

@arya-hemanshu running the second query on the table without the index takes as long as the first query (more than 15 min.) as the `&&` operator has not any effect...

The gps' rating data from PHE can be downloaded as csv [here]( http://fingertips.phe.org.uk/profile/general-practice/data ). The survey data includes: * % who would recommend the practice * % satisfied with phone...