| | 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. |
