Changes between Version 8 and Version 9 of WKTRaster/SpecificationWorking02

Timestamp:

Aug 4, 2010, 9:09:24 AM (14 years ago)

Author:

pracine

Comment:

—

WKTRaster/SpecificationWorking02

@@ -42 +42 @@
 '''ST_Accum(raster set|geometry set, ‘raster’|’geometry’) -> raster/geometry'''
 
+----
+== '''Objective B02e - Being able to create on the fly and get data from registered (out-db) raster.''' ==
+ 
+
+'''Mostly change to Core API functions rt_band_get_data using GDAL to read from external raster.'''[[BR]]
+'''Add a ST_AddBand() SQL function '''[[BR]]
+Allow then to create, in SQL, a new out-db raster and to load it into the database: 
+
+CREATE TABLE newIndbRastTable AS SELECT ST_AddBand(ST_NewRasterFromFile("c:/temp/myraster.tif"), "c:/temp/myraster.tif");
+
+and to tile it in a new table using a new easy to implement pl/PgSQL function using ST_Clip.