[postgis-users] Optimization - point density calculation

[Markus Schaber]

Hi, Paul,

"Paul Ramsey" <pramsey at cleverelephant.ca> wrote:

> (a) The ST_Transform() function is making your spatial index
> un-usable, because your spatial index is against the raw coordinates
> of your data.
> [...]
> So, first transform your data to your working projection.

You could also try to create a functional index on the transformed
geometries. In theory it should work, but I did never test it myself.


Regards,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org