[postgis-tickets] [PostGIS] #2247: [raster] Create ST_CreateOverviews()

[PostGIS]

#2247: [raster] Create ST_CreateOverviews()
-------------------------------+--------------------------------------------
 Reporter:  dzwarg             |       Owner:  dzwarg        
     Type:  enhancement        |      Status:  new           
 Priority:  medium             |   Milestone:  PostGIS Future
Component:  raster             |     Version:  trunk         
 Keywords:  raster, overviews  |  
-------------------------------+--------------------------------------------

Comment(by strk):

 I can't stop thinking that I'd like a function like this to help me with
 building a regular coverage from an irregular one. For example:

  1. A raster is imported tiled in the database
  2. The raster tiles are reprojected within the database

 In step 2, the rasters stop having the same scale, so the concept of
 "factor" (the proposed argument to the function) becomes impossible to
 enforce.

 On the other hand, if we specified directly an output scale and tile size,
 we could rescale and union all source tiles intersecting each of the
 output tiles no matter regularity of input.

 At that point we'd also need to take an extent, to know when to stop (and
 maybe some flags to decide if we'd want to pad on the right and on the
 bottom if tilesize*scale != extsize.

 What do you think @pracine, @dustymugs, @robe ?
 Maybe what I'm talking about should be a different signature completely...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2247#comment:9>
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.