[postgis-devel] [PostGIS] #1319: [raster] Make raster_columns a view and AddRasterColumn enforce more

[PostGIS]

#1319: [raster] Make raster_columns a view and AddRasterColumn enforce more
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe         
     Type:  task            |      Status:  new          
 Priority:  high            |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by dustymugs):

 The importer will call an update AddRasterColumn which only needs to work
 on the table having the raster column added.

 I'm planning on having the importer run by default in a strict mode (where
 all rasters passed in when the importer is called have the same scale x/y,
 srid and band types.  There will be a set of flags to disable specific
 constraints though.

 I don't know how useful nodatavalue is because there could be different
 nodatavalues between two rasters' bands of the same index because the
 values might be in different ranges.  Say raster 1 band 1 has values
 between 0 - 125 while raster 2 band 1 has values between 126 - 255.
 Though the two rasters are aligned, they have different nodata values.

 Number of bands will be added as the pixtypes array might not be correct
 but the number of bands might be.

 Though extent might be valuable as it would be done using...

 {{{
 SELECT ST_ConvexHull(ST_Collect(tile)) FROM tmax_2010
 }}}

 It isn't fast though.  On my tmax_2010 table with 36712 rows with tile
 size of 100x100, it takes 1 second.  So for every year between 1965 to
 2011, the view would take 47 seconds (assuming 1 second for each table).
 Add my tmin and precip datasets for the same years, we're talking 141
 seconds.

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