Building pyramids on a raster value in an ST_Raster column

Pyramids can be constructed on a raster value stored in an ST_Raster column by updating the value with the buildPyramid function.

The buildPyramid function builds reduced-resolution pyramids on the specified ST_Raster value. Reduced-resolution pyramids are necessary to provide a consistent pixel data return rate as the application zooms in and out of a map containing rasters.

Steps:

1. Use a SQL UPDATE statement with the ST_Raster buildPyramid function to create pyramids on ST_Raster values on specific records in a table.

   The following examples for each of the supported database management systems show a bilinear pyramid being built on the rasters in the table urban_area for all records with the name all_cities:

   Oracle	UPDATE URBAN_AREA t SET raster = t.raster.buildPyramid('bilinear') WHERE NAME = 'ALL_CITIES';
   PostgreSQL	UPDATE urban_area SET raster = buildPyramid(raster,'bilinear') WHERE name = 'all_cities';
   SQL Server	UPDATE urban_area SET raster = raster.buildPyramid('bilinear') WHERE name = 'all_cities';