Raster datasets and raster catalogs in a geodatabase in PostgreSQL

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

Rasters in ArcCatalog

Raster tables in a PostgreSQL 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 qa_ras_seattle2_xf 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 sde_raster_columns system table.
Information about all business tables in the geodatabase, whether or not they have a spatial column or raster column, is maintained in the sde_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 table stores the description of the images within a raster column.
ArcSDE geodatabases store raster bands in the raster band table. ArcSDE joins the raster band table to the raster table on the raster_id column.
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 references the rasterband_id column of the raster band table. ArcSDE joins the two tables on this column when accessing a raster band's metadata.
The raster blocks 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, when combined with the compression method, allow each row of the raster block table to fit within PostgreSQL. You will find that the default values typically work best.
The raster blocks table contains the rasterband_id column, which references to the raster band table's rasterband_id column. These tables are joined together on this column 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 the application. The application, such as ArcToolbox or ArcCatalog, allows you to define the levels, request that ArcSDE calculate them, or 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 by ArcSDE 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 smaller. 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 is reached. As the application zooms out and the raster cells get 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 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 has 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	bytea	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 has 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	bytea	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 has 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 bit mask containing properties of 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 precision	The x-ordinate of the raster origin NOT NULL
block_origin_y	double precision	The y-ordinate of the raster origin NOT NULL
eminx	double precision	The minimum x-value of a raster band; with eminy, emaxx, and emaxy, defines the envelope of a raster band NOT NULL
eminy	double precision	The minimum y-value of a raster band; with eminx, emaxx, and emaxy, defines the envelope of a raster band NOT NULL
emaxx	double precision	The maximum x-value of a raster band; with eminx, eminy, and emaxy, defines the envelope of a raster band NOT NULL
emaxy	double precision	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 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 workspace document

<esri:Workspace xmlns:esri="http://www.esri.com/schemas/ArcGIS/9.3" 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=m8db.rocket.qa_ras_seattle2_xf</CatalogPath> 
       <Name>m8db.rocket.qa_ras_seattle2_xf</Name> 
       <Children xsi:type="esri:ArrayOfDataElement">
          <DataElement xsi:type="esri:DERasterBand">
            <CatalogPath>/V=sde.DEFAULT/RD=m8db.rocket.qa_ras_seattle2_xf/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>