[postgis-devel] [PostGIS] #502: [wktraster] Optimize ST_Intersection

PostGIS trac at osgeo.org
Mon Jun 7 13:51:42 PDT 2010


#502: [wktraster] Optimize ST_Intersection
------------------------+---------------------------------------------------
  Reporter:  pracine    |       Owner:  jorgearevalo   
      Type:  defect     |      Status:  reopened       
  Priority:  medium     |   Milestone:  WKTRaster 0.1.6
 Component:  wktraster  |     Version:  trunk          
Resolution:             |    Keywords:                 
------------------------+---------------------------------------------------
Changes (by pracine):

  * summary:  [wktraster] Optimize ST_Intersection when the geometry is a
              point => [wktraster] Optimize ST_Intersection

Old description:

> 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. This, obviously, do not work when the intersecting geometry is a
> polygon. In this case we have to vectorize the complete raster tile.

New description:

 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.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/502#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list