Mosaic datasets in a geodatabase in Oracle

Mosaic datasets contain a raster catalog and a set of properties and rules that define an on-the-fly mosaic view of the raster catalog. See What is a mosaic dataset? for more information.

Mosaic datasets in ArcGIS Desktop

In the Catalog tree, mosaic datasets have the following icon:

Mosaic dataset icon

The name of the mosaic dataset in a geodatabase in Oracle contains the name of the dataset owner and the name of the mosaic dataset itself.

Mosaic datasets in an Oracle database

Information about mosaic datasets is stored in the GDB_ITEMS and GDB_ITEMTYPES system tables. There can be nine additional tables stored in the schema of the user who creates the mosaic dataset. Four of them—the ART, BND, CAT, and LOG tables—are created when you use the mosaic dataset is created; the other tables are generated the first time you perform an operation that requires the table's existence. Referenced mosaic datasets only have two tables: the BND and LOG tables.

The name portion of the table names is the name of the mosaic dataset. Be sure the name you give the mosaic dataset is 22 characters or fewer.

AMD_<NAME>_ART

This table stores a history of all the raster types used in this mosaic dataset.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The unique identifier of the raster

NOT NULL

TYPENAME

NVARCHAR2(50)

The name of the raster type or product

RASTERTYPE

BLOB

A serialized object that stores all the properties of a particular raster type

DESCRIPTION

NVARCHAR2(250)

A user-defined description of the raster that helps to identify a particular add raster operation

FIRSTUSED

DATE

Records the date and time rasters were added to the mosaic dataset using the corresponding raster type object

This time stamp never changes since it indicates the first time the raster type was used in the mosaic.

LASTUSED

DATE

Records the date and time one or more rasters were synchronized using this raster type

The value in this field changes whenever the corresponding raster type is used.

LASTSYNC

DATE

The date and time the raster type was last synchronized

AMD_<NAME>_BND

The boundary for a mosaic dataset is a feature class. This table defines the boundary (extent) of the mosaic dataset.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The unique identifier of the raster

NOT NULL

SHAPE

ST_GEOMETRY

NUMBER(38)

SDO_GEOMETRY

The shape of the boundary of the raster

NOT NULL

AMD_<NAME>_CAT

This is the raster catalog behind the mosaic dataset. It stores raster datasets that participate in mosaicking.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The unique identifier for the dataset

NOT NULL

NAME

NVARCHAR2(50)

Display name for the catalog item

MINPS

NUMBER(20,9)

Minimum pixel size

MAXPS

NUMBER(20,9)

Maximum pixel size

LOWPS

NUMBER(20,9)

Low pixel size

HIGHPS

NUMBER(20,9)

High pixel size

CATEGORY

NUMBER(10)

Identifies the dataset type; 0 = Unknown, 1 = Primary, 2 = ServiceOverview, 3 = DerivedRaster, 255 = Custom

TAG

NVARCHAR2(20)

Identifies a dataset in a function template and indicates if the dataset is panchromatic, multispectral, or pan sharpened

GROUPNAME

NVARCHAR2(50)

The name of the groups used to link together datasets belonging to a particular project (For example, for a QuickBird scene, the panchromatic and multispectral rasters that need to participate in pan sharpening will have the same group name.)

PRODUCTNAME

NVARCHAR2(50)

The name of the product of the raster data provided by the data source

CENTERX

NUMBER(20,9)

X-coordinate of the center of the raster's minimum bounding rectangle

CENTERY

NUMBER(20,9)

Y-coordinate of the center of the raster's minimum bounding rectangle

ZORDER

NUMBER(20)

Controls the drawing order of rasters in a mosaic dataset

SORDER

NUMBER(20)

Indicates the order of the rasters

Used in seamline mosaic method

TYPEID

NUMBER(10)

ObjectID of the record in the amd_art table that contains details about the raster type object

STEREOID

NVARCHAR2(50)

ObjectID of the record in the AMD_<NAME>_STR table that holds details of the participating stereo pairs

ITEMTS

NUMBER(20,14)

Time stamp of the modified raster

Used to track which overviews need to be rebuilt when underlying rasters are changed

Used by the Build Overview geoprocessing tool

URIHASH

NVARCHAR2(50)

Uniquely identifies the sources of the raster

Used by the Synchronize Mosaic Dataset geoprocessing tool

URI

BLOB

A serialized Uniform Resource Identifier (URI) that is used to re-create the raster dataset

SHAPE

ST_GEOMETRY

NUMBER(38)

SDO_GEOMETRY

The minimum bounding rectangle of the raster dataset

RASTER

NUMBER(38)

ST_RASTER

A reference to a raster dataset along with its functions

AMD_<NAME>_CCA

This table stores information about color correction.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The row ID

NOT NULL

ASSOCOBJECTID

NUMBER(38)

The row ID of the mosaic dataset catalog

NOT NULL

NAME

NVARCHAR2(256)

Name of the raster item

PRESTORGAMMATABLEBLOB

BLOB

Binary large object of color correction prestretch color map or Gamma map

SHAPE

ST_GEOMETRY

NUMBER(38)

SDO_GEOMETRY

Minimum bounding rectangle of the raster

RASTER

NUMBER(38)

ST_RASTER

Raster of local mean and local standard deviation

AMD_<NAME>_CSL

This table stores cell size levels of a mosaic dataset. The table is created when you specify or calculate the cell size for the mosaic dataset. Information in the table is updated when calculating cell size levels or defining overviews and is used while generating overviews.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The unique identifier for the dataset

NOT NULL

INSTANCEID

NUMBER(10)

The ObjectID of the raster type instance stored in the raster type table associated with the corresponding cell size level

LEVELID

NUMBER(10)

The identifier associated with the cell size level

CELLSIZE

NUMBER(20,9)

The cell size value associated with the celll size level

MINPS

NUMBER(20,9)

Minimum pixel size

MAXPS

NUMBER(20,9)

Maximum pixel size

SHAPE

ST_GEOMETRY

NUMBER(38)

SDO_GEOMETRY

The minimum bounding polygon of all items belonging to the corresponding cell size level

AMD_<NAME>_LOG

This table stores errors, warnings, and messages that are generated by various operations performed on a mosaic dataset.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The unique identifier of each row in this table

NOT NULL

MSGCODE

NUMBER(20)

Error or warning code that uniquely identifies the message

NOT NULL

MSGSRC

NVARCHAR2(100)

The source; usually the name of the operation that generated this message

MSGTEXT

NVARCHAR2(250)

The text description of the message

MSGTYPE

NUMBER(14)

Differentiates between error, warning, and information messages: 1 = Error, 2 = Warning, 3 = Info1, 4 = Info2, 5= Info3, 100 = Debug

RASTERID

NUMBER(14)

ObjectID of the record in the AMD_<NAME>_CAT table that corresponds to this message

MSGTIME

NVARCHAR2(30)

The date and time the error or warning message occurred

AMD_<NAME>_OVR

By default, the overview rasters that are created for mosaic datasets are stored in this table. If you change the storage location for the overviews, which can be done using the Define Overviews tool, this table will not be populated. Instead, a pointer to the overview location will be stored in the urihash field of the AMD_<NAME>_CAT table.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The unique identifier of the overview record

NOT NULL

NAME

NVARCHAR2(50)

System-generated name of the raster dataset value that identifies the row and column position of the overview record

RASTER

NUMBER(38)

ST_RASTER

The raster dataset

AMD_<NAME>_SML

This table defines the seamline shapes that are used for mosaicking when the MosaicMethod used is seamline.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The unique identifier of the seamline

NOT NULL

RASTERID

NUMBER(14)

The objectID of the record in the amd_cat table that corresponds to this seamline shape

NOT NULL

SHAPE

ST_GEOMETRY

NUMBER(38)

SDO_GEOMETRY

The shape of the seamline

NOT NULL

AMD_<NAME>_STR

This table stores stereo IDs of the pairs that participate in a stereo image.

Field name

Field type

Description

Null?

OBJECTID

NUMBER(38)

The unique identifier for each record in this table

STEREOID1

NVARCHAR2(50)

ID of one of the participating stereo pairs

STEREOID2

NVARCHAR2(50)

ID of the other of the participating stereo pair

The following shows the tables in a mosaic dataset, basemap, in Oracle.

Mosaic dataset tables in Oracle

Dashed lines indicate implicit relationships between columns.

Mosaic datasets in an XML document

Mosaic datasets are not currently supported in XML documents.


8/19/2013