[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:               |  
-------------------------+--------------------------------------------------

Comment(by pracine):

 By "Width" and "Height" I guess you mean "blocksize_x" and "blocksize_y"?

 They should be the identical x and y size of the blocks, except the right-
 most and bottom tiles. There is no need to know about the size of the
 smaller tiles in the metadata.

 So the check should be the same but so not take the right-most and bottom
 tiles in the computation.

 I think the best way to test for the right most and bottom tiles is to
 build a dummy empty raster with the extent with a scale_x = blocksize_x
 and scale_y = -blocksize_y and to check if the upperleft corner of the
 tiles are equal to the upperleft corner of the (width - 1) and (height -
 1) pixels of the dummy raster.

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