Ticket #1583 (new enhancement)

Opened 16 months ago

Last modified 4 months ago

[raster] Optimize ST_Intersection(raster, geometry) with ST_Clip()

Reported by: pracine Owned by: pracine
Priority: medium Milestone: PostGIS 2.0.4
Component: raster Version: trunk
Keywords: Cc:

Description

Now that we can ST_Clip() a raster we can optimize the vector space ST_Intersection(raster, geometry) so that it vectorize only the required extent (the intersection of the geometry extent and the raster extent) instead of all the tile.

Change History

  Changed 16 months ago by pracine

There should be a threshold were it is worth doing so, like when the intersecting extent is XX% smaller than the raster extent. Some test needed...

  Changed 16 months ago by pracine

  • milestone changed from PostGIS Raster 2.0.1 to PostGIS 2.0.1

follow-up: ↓ 4   Changed 14 months ago by pramsey

Note that patch releases should not be changing functionality. There seem to be a number of raster enhancement tickets on the 2.0.1 milestone, which should properly be 2.1.x

in reply to: ↑ 3   Changed 14 months ago by pracine

Replying to pramsey:

Note that patch releases should not be changing functionality. There seem to be a number of raster enhancement tickets on the 2.0.1 milestone, which should properly be 2.1.x

Not this one since the change is inside ST_Intersection and totally transparent to the user.

  Changed 12 months ago by dustymugs

  • milestone changed from PostGIS 2.0.1 to PostGIS 2.0.2

  Changed 7 months ago by robe

  • milestone changed from PostGIS 2.0.2 to PostGIS 2.0.3

  Changed 4 months ago by dustymugs

  • milestone changed from PostGIS 2.0.3 to PostGIS 2.0.x
Note: See TracTickets for help on using tickets.