Ticket #502 (closed enhancement: wontfix)
[raster] Optimize ST_Intersection to return ST_Value when intersecting with points
|Reported by:||pracine||Owned by:||pracine|
Description (last modified by pracine) (diff)
It might be much quicker to provide the value associated with a pixel intersecting with a point geometry when using ST_Intersection() by accessing the pixel value with ST_Value instead of vectorizing the whole tile. We have first to fix st_value(rast, geom) so it behave exactly as st_intersect on edge of raster and pixels.
This, obviously, do not work when the intersecting geometry is a line or a polygon. In this case we should try to vectorize only the intersecting part of the raster tile.