[postgis-tickets] [PostGIS] #2143: [raster] Width and Height column of raster_columns view may need changing

[PostGIS]

#2143: [raster] Width and Height column of raster_columns view may need changing
-------------------------+--------------------------------------------------
 Reporter:  dustymugs    |       Owner:  dustymugs    
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.0
Component:  raster       |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------
 With tiles no longer being padded, right and bottom edge tiles of a
 coverage may be of different width and/or height.  The constraints
 (blocksize x and blocksize y) themselves need to be changed to constrain
 as a set (width AND height = X AND Y).

 Constraint testing would be something like the following, just in a
 function:

 {{{
 SELECT
         dim
 FROM (
 SELECT ROW(4,4) AS dim
 UNION ALL
 SELECT ROW(2,4) AS dim
 UNION ALL
 SELECT ROW(4,2) AS dim
 UNION ALL
 SELECT ROW(2,2) AS dim
 ) foo
 INTERSECT
 SELECT ROW(2,3) AS dim
 }}}


 So what should be the value(s) in the width/height columns of
 raster_columns?  The "desired" tile size (the one specified with -t in
 raster2psql or tilewidth/tileheight in ST_Tile()), which would be a
 singular value.  Or should the columns be an array of the permitted widths
 or heights?  Or is having two seperate columns no longer appropriate and
 there should just be one column (say "tile_size") with an array of sets
 (each set indicating a width/height).

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2143>
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.