Raster datasets and raster catalogs in a geodatabase in DB2

Raster datasets and raster catalogs in a geodatabase in DB2
Release 9.3

Rasters in ArcCatalog

Raster tables in a DB2 DBMS

• The business table
The business table is a DBMS table that stores attributes and is spatially enabled by adding a raster column. It stores the footprint (delineates the area) of the raster. In the example above, the business table is the WORLD_TIF table.
A business table with a raster column is a raster dataset or a raster catalog. A raster dataset can have only one business table row, while a raster catalog can have more than one. Information about the raster column is maintained in the RASTER_COLUMNS system table.
Information about all business tables, regardless of whether or not they have a spatial column or raster column, is maintained in the TABLE_REGISTRY system table.
• Raster image tables
The actual raster images are stored in the following tables:
SDE_AUX_<raster_column_ID>—The raster auxiliary table, which stores the color map, statistics, and bit mask of the image
SDE_BLK_<raster_column_ID>—The raster blocks table, which stores the actual image data for each band of the image
SDE_ BND_<raster_column_ID>—The raster band table, which stores metadata about the bands of the image
SDE_RAS_<raster_column_ID>—The raster description table, which stores the description of the images within a raster column
ArcSDE geodatabases store raster bands in the raster band's table. ArcSDE joins the raster band's table to the raster table on the RASTER_ID column. The raster band table's RASTER_ID column is a foreign key reference to the raster table's RASTER_ID primary key.
ArcSDE automatically stores any existing image metadata such as image statistics, color maps, or bit masks in the raster auxiliary table. The rasterband_id column of the raster auxiliary table is a foreign key reference to the primary key of the raster band's table. ArcSDE joins the two tables on this primary/foreign key reference when accessing a raster band's metadata.
The raster block's table stores the pixels of each raster band. ArcSDE tiles the pixels into blocks according to a user-defined dimension. ArcSDE does not have a default dimension; however, applications that store raster data in ArcSDE geodatabases do. ArcToolbox and ArcCatalog, for example, use default raster block dimensions of 128 by 128 pixels per block. The dimensions of the raster block, along with the compression method if one is specified, determine the storage size of each raster block. You should select raster block dimensions that, combined with the compression method, allow each row of the raster block table to fit within DB2.
The raster block's table contains the RASTERBAND_ID column, which is a foreign key reference to the raster band table's RASTERBAND_ID primary key. These tables are joined together on the primary/foreign key reference when accessing the blocks of the raster bands.
The raster blocks table is populated according to a declining resolution pyramid. The height of the pyramid is determined by the number of levels, specified by application. The application, such as ArcToolbox or ArcCatalog, may allow you to define the levels, may request that ArcSDE calculate them, or may offer both choices.
The pyramid begins at the base, or Level 0, which contains the original pixels of the image. The pyramid proceeds toward the apex by coalescing four pixels from the previous level into a single pixel at the current level. This process continues until ArcSDE reaches the apex, which may be automatically defined or user defined.
The additional levels of the pyramid increase the number of raster blocks by as much as one-third. However, since you can specify the number of levels, the size of the pyramid can be less. The first level of the pyramid will be 25 percent of the base. It should also be noted that the first level of the pyramid can be skipped, a factor that can greatly reduce the size of the pyramid.

When you build a pyramid, more rasters are created by progressively downsampling the previous level by a factor of two until the apex. As the application zooms out and the raster cells grow smaller than the resolution threshold, ArcSDE selects a higher level of the pyramid. The purpose of the pyramid is to optimize display performance.
The following are the table definitions for the raster tables:

NOTE: You will only have the raster tables in your geodatabase if you have raster data in the geodatabase.

SDE_AUX_<raster_column_ID>
The raster auxiliary table stores the image color map; image statistics; and the optional bit mask, which is used for image overlays and mosaicking.



Field name	Field type	Description
RASTERBAND_ID	INTEGER	A number that represents a raster band; for example, a raster dataset with two raster bands would have two different values in this field—1 and 2 NOT NULL
TYPE	INTEGER	Values include 2 = raster statistics 3 = color map 4 = coordinate transformation 5 = reserved for geodatabase 6 = miscellaneous NOT NULL
OBJECT	BLOB	Contains the actual data, either a color map index, raster statistics, or coordinate transformation NOT NULL

SDE_BLK_<raster_column_ID>
The raster blocks table stores the image tiles.



Field name	Field type	Description
RASTERBAND_ID	INTEGER	A number that represents a raster band; for example, a raster dataset with two raster bands would have two different values in this field—1 and 2 NOT NULL
RRD_FACTOR	INTEGER	Pyramid level; pyramid levels begin at 0 and can increase from there NOT NULL
ROW_NBR	INTEGER	Tile row number position NOT NULL
COL_NBR	INTEGER	Column row number position NOT NULL
BLOCK_DATA	BLOB	Pixel data stored in the tile NOT NULL

SDE_BND_<raster_column_id>
The raster band table stores information about the bands of the images. There is one record for each raster band.



Field name	Field type	Description
RASTERBAND_ID	INTEGER	A number that represents a raster band; for example, a raster dataset with two raster bands would have two different values in this field—1 and 2 NOT NULL
SEQUENCE_NBR	INTEGER	Sequence of the raster band within the raster dataset NOT NULL
RASTER_ID	INTEGER	The unique identifier of the raster dataset; corresponds to the value in the raster column that of the business table NOT NULL
NAME	VARCHAR(65)	The optional raster band name
BAND_FLAGS	INTEGER	A bitmask containing properties about the band NOT NULL
BAND_WIDTH	INTEGER	The pixel width of the band NOT NULL
BAND_HEIGHT	INTEGER	The pixel height of the band NOT NULL
BAND_TYPES	INTEGER	A bit mask containing properties about the band NOT NULL
BLOCK_WIDTH	INTEGER	The pixel width of a block NOT NULL
BLOCK_HEIGHT	INTEGER	The pixel height of a block NOT NULL
BLOCK_ORIGIN_X	DOUBLE	The x-ordinate of the raster origin NOT NULL
BLOCK_ORIGIN_Y	DOUBLE	The y-ordinate of the raster origin NOT NULL
EMINX	DOUBLE	The minimum x-value of a raster band; with eminy, emaxx, and emaxy, defines the envelope of a raster band NOT NULL
EMINY	DOUBLE	The minimum y-value of a raster band; with eminx, emaxx, and emaxy, defines the envelope of a raster band NOT NULL
EMAXX	DOUBLE	The maximum x-value of a raster band; with eminx, eminy, and emaxy, defines the envelope of a raster band NOT NULL
EMAXY	DOUBLE	The maximum y-value in a raster band; with eminx, eminy, and emaxx, defines the envelope of a raster band NOT NULL
CDATE	INTEGER	The creation date of the raster band NOT NULL
MDATE	INTEGER	The last modification date of the raster band NOT NULL

SDE_RAS_<raster_column_id>
The raster description table stores the description of the images stored in a raster column.



Field name	Field type	Description
RASTER_ID	INTEGER	The unique identifier of the raster dataset; corresponds to the value in the raster column that of the business table NOT NULL
RASTER_FLAGS	INTEGER	Reserved for future use
DESCRIPTION	VARCHAR(65)	The description of the raster dataset

Rasters in an XML document

<esri:Workspace xmlns:esri="http://www.esri.com/schemas/ArcGIS/9.2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <WorkspaceDefinition xsi:type="esri:WorkspaceDefinition">
   <WorkspaceType>esriRemoteDatabaseWorkspace</WorkspaceType> 
   <Version>sde.DEFAULT</Version> 
   <Domains xsi:type="esri:ArrayOfDomain" /> 
   <DatasetDefinitions xsi:type="esri:ArrayOfDataElement">
     <DataElement xsi:type="esri:DERasterDataset">
       <CatalogPath>/V=sde.DEFAULT/RD=sde.RJP.world_TIF</CatalogPath> 
       <Name>sde.RJP.world_TIF</Name> 
       <Children xsi:type="esri:ArrayOfDataElement">
          <DataElement xsi:type="esri:DERasterBand">
            <CatalogPath>/V=sde.DEFAULT/RD=sde.RJP.world_TIF/RB=Band_1</CatalogPath> 
            <Name>Band_1</Name> 
            <DatasetType>esriDTRasterBand</DatasetType> 
            <DSID>-1</DSID> 
            <Versioned>false</Versioned> 
            <CanVersion>false</CanVersion> 
            <HasOID>true</HasOID> 
            <OIDFieldName>ObjectID</OIDFieldName> 
            <Fields xsi:type="esri:Fields">
              <FieldArray xsi:type="esri:ArrayOfField">
                <Field xsi:type="esri:Field">
                    <Name>ObjectID</Name> 
                    <Type>esriFieldTypeOID</Type> 
                    <IsNullable>false</IsNullable> 
                    <Length>4</Length> 
                    <Precision>0</Precision> 
                    <Scale>0</Scale> 
                    <Required>true</Required> 
                    <Editable>false</Editable> 
                </Field>
                <Field xsi:type="esri:Field">
                    <Name>Value</Name> 
                    <Type>esriFieldTypeInteger</Type> 
                    <IsNullable>true</IsNullable> 
                    <Length>0</Length> 
                    <Precision>0</Precision> 
                    <Scale>0</Scale> 
               </Field>
               <Field xsi:type="esri:Field">
                    <Name>Count</Name> 
                    <Type>esriFieldTypeInteger</Type> 
                    <IsNullable>true</IsNullable> 
                    <Length>0</Length> 
                    <Precision>0</Precision> 
                    <Scale>0</Scale> 
               </Field>
             </FieldArray>
         </Fields>
         <Indexes xsi:type="esri:Indexes">
           <IndexArray xsi:type="esri:ArrayOfIndex" /> 
         </Indexes>
         <IsInteger>true</IsInteger> 
         <MeanCellHeight>0.175996089009095</MeanCellHeight> 
         <MeanCellWidth>0.176000337991447</MeanCellWidth> 
         <Height>1024</Height> 
         <Width>2048</Width> 
         <PixelType>U8</PixelType> 
         <PrimaryField>1</PrimaryField> 
         <TableType>esriRasterTableValue</TableType> 
         <Extent xsi:type="esri:EnvelopeN">
            <XMin>-179.906382261841</XMin> 
            <YMin>-90.1303147686327</YMin> 
            <XMax>180.542309944643</XMax> 
            <YMax>90.089680376681</YMax> 
            <SpatialReference xsi:type="esri:GeographicCoordinateSystem">
   <WKT>GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]</WKT> 
          <XOrigin>-400</XOrigin> 
          <YOrigin>-400</YOrigin> 
          <XYScale>11258999068426.2</XYScale> 
          <ZOrigin>0</ZOrigin> 
          <ZScale>1</ZScale> 
          <MOrigin>0</MOrigin> 
          <MScale>1</MScale> 
          <XYTolerance>8.98315284119521E-09</XYTolerance> 
          <ZTolerance>2</ZTolerance> 
          <MTolerance>2</MTolerance> 
          <HighPrecision>true</HighPrecision> 
          <LeftLongitude>-180</LeftLongitude> 
         </SpatialReference>
        </Extent>
      </Data>
    </DatasetData>
   </WorkspaceData>
</esri:Workspace>