Raster datasets and raster catalogs in a geodatabase in Informix

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

Rasters in ArcCatalog

Raster tables in an Informix 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; stores the color map, statistics, and bit mask of the image
sde_blk_<raster_column_ID>—The raster blocks table; stores the actual image data for each band of the image
sde_bnd_<raster_column_ID>—The raster band table; stores metadata about the bands of the image
sde_ras_<raster_column_ID>—The raster description table; 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 Informix.
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	Int	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	Int	Values include 2 = raster statistics 3 = color map 4 = coordinate transformation 5 = reserved for geodatabase 6 = miscellaneous NOT NULL
object	Byte	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	Int	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	Int	Pyramid level. Pyramid levels begin at 0 and can increase from there. NOT NULL.
row_nbr	Int	Tile row number position. NOT NULL.
col_nbr	Int	Column row number position. NOT NULL.
block_data	Byte	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	Int	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	Int	Sequence of the raster band within the raster dataset NOT NULL
raster_id	Int	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	Int	A bitmask containing properties about the band NOT NULL
band_width	Int	The pixel width of the band NOT NULL
band_height	Int	The pixel height of the band NOT NULL
band_types	Int	A bit mask containing properties about the band NOT NULL
block_width	Int	The pixel width of a block NOT NULL
block_height	Int	The pixel height of a block NOT NULL
block_origin_x	Float	The x-ordinate of the raster origin NOT NULL
block_origin_y	Float	The y-ordinate of the raster origin NOT NULL
eminx	Float	The minimum x-value of a raster band; with eminy, emaxx, and emaxy, defines the envelope of a raster band NOT NULL
eminy	Float	The minimum y-value of a raster band; with eminx, emaxx, and emaxy, defines the envelope of a raster band NOT NULL
emaxx	Float	The maximum x-value of a raster band; with eminx, eminy, and emaxy, defines the envelope of a raster band NOT NULL
emaxy	Float	The maximum y-value in a raster band; with eminx, eminy, and emaxx, defines the envelope of a raster band NOT NULL
cdate	Int	The creation date of the raster band NOT NULL
mdate	Int	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	Int	The unique identifier of the raster dataset; corresponds to the value in the raster column that of the business table NOT NULL
raster_flags	Int	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>sde92.gdb.world_TIF</Name> 
       <Children xsi:type="esri:ArrayOfDataElement">
          <DataElement xsi:type="esri:DERasterBand">
            <CatalogPath>/V=sde.DEFAULT/RD=sde92.gdb.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>