| 44 | ---- |
| 45 | == '''Objective B02e - Being able to create on the fly and get data from registered (out-db) raster.''' == |
| 46 | |
| 47 | |
| 48 | '''Mostly change to Core API functions rt_band_get_data using GDAL to read from external raster.'''[[BR]] |
| 49 | '''Add a ST_AddBand() SQL function '''[[BR]] |
| 50 | Allow then to create, in SQL, a new out-db raster and to load it into the database: |
| 51 | |
| 52 | CREATE TABLE newIndbRastTable AS SELECT ST_AddBand(ST_NewRasterFromFile("c:/temp/myraster.tif"), "c:/temp/myraster.tif"); |
| 53 | |
| 54 | and to tile it in a new table using a new easy to implement pl/PgSQL function using ST_Clip. |