Mosaic datasets in a geodatabase in SQL Server
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 for Desktop
In the Catalog tree, mosaic datasets have the following icon:
The name of the mosaic dataset in a geodatabase in SQL Server contains the database name, the name of the dataset owner, and the name of the mosaic dataset itself.
Mosaic datasets in a Microsoft SQL Server 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 that's 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.
This table stores the analysis results generated by the Analyze Mosaic Dataset geoprocessing tool.
Field name | Field type | Description | Null? |
|---|---|---|---|
ObjectID | integer | The row ID | NOT NULL |
ResultID | integer | The identifier of the analysis result message | |
ResultType | integer | The type of analysis result message | |
MsgText | nvarchar(250) | The analysis result message | |
ItemCount | integer | The count of mosaic dataset items that have the corresponding analysis result | |
Severity | integer | The severity of the message: 0 = high, 1 = medium, 2 = low | |
ItemTS | numeric(38,8) | Timestamp of the analyzed raster | |
Shape | integer geometry geography | The spatial field associated with the analysis result |
This table stores a history of all the raster types used in this mosaic dataset.
|
Field name |
Field type |
Description |
Null? |
|---|---|---|---|
|
ObjectID |
integer |
The unique identifier of the raster |
NOT NULL |
|
TypeName |
nvarchar(50) |
The name of the raster type or product |
|
|
RasterType |
varbinary(max) |
A serialized object that stores all the properties of a particular raster type |
|
|
Description |
nvarchar(250) |
A user-defined description of the raster that helps to identify a particular add raster operation |
|
|
FirstAdd |
datetime2 |
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. |
|
|
LastAddd |
datetime2 |
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. |
|
LastSynch | datetime2 | The date and time the raster type was last synchronized |
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 |
integer |
The unique identifier of the raster |
NOT NULL |
|
Shape |
integer geometry geography |
The shape of the boundary of the raster |
This is the raster catalog behind the mosaic dataset. It stores raster datasets that participate in mosaicking.
|
Field name |
Field type |
Description |
Null? |
|---|---|---|---|
|
ObjectID |
integer |
The unique identifier for the dataset |
NOT NULL |
|
Name |
nvarchar(50) |
Display name for the catalog item |
|
|
Minps |
numeric(38,8) |
Minimum pixel size |
|
|
Maxps |
numeric(38,8) |
Maximum pixel size |
|
|
Lowps |
numeric(38,8) |
Low pixel size |
|
|
Highps |
numeric(38,8) |
High pixel size |
|
|
Category |
integer |
Identifies the dataset type: 0 = Unknown, 1 = Primary, 2 = ServiceOverview, 3 = DerivedRaster, 255 = Custom |
|
|
Tag |
nvarchar(20) |
Identifies a dataset in a function template and indicates if the dataset is panchromatic, multispectral, or pan sharpened |
|
|
GroupName |
nvarchar(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 |
nvarchar(50) |
The name of the product of the raster data provided by the data source |
|
|
CenterX |
numeric(38,8) |
X-coordinate of the center of the raster's minimum bounding rectangle |
|
|
CenterY |
numeric(38,8) |
Y-coordinate of the center of the raster's minimum bounding rectangle |
|
|
ZOrder |
numeric(38,8) |
Controls the drawing order of rasters in a mosaic dataset |
|
|
SOrder |
integer |
Indicates the order of the rasters Used in seamline mosaic method |
|
|
TypeID |
integer |
ObjectID of the record in the amd_art table that contains details about the raster type object |
|
|
StereoID |
nvarchar(50) |
ObjectID of the record in the AMD_<NAME>_STR table that holds details of the participating stereo pairs |
|
|
ItemTS |
numeric(38,8) |
Time stamp of the modified raster Used to track which overviews need to be rebuilt when underlying rasters are changed Used by the Build Overviews geoprocessing tool |
|
|
UriHash |
nvarchar(50) |
Uniquely identifies the sources of the raster Used by the Synchronize Mosaic Dataset geoprocessing tool |
|
|
Uri |
varbinary(max) |
A serialized Uniform Resource Identifier (URI) that is used to re-create the raster dataset |
|
Thumbnail | varbinary(max) | A thumbnail representation of the raster | |
SLevelPS | numeric(38,8) | The cell size corresponding to the cell size level associated with each mosiac dataset This is populated when seamlines are built for the mosaic dataset. | |
|
Shape |
integer geometry geography |
The minimum bounding rectangle of the raster dataset |
|
|
Raster |
integer st_raster |
A reference to a raster dataset along with its functions |
This table stores information about color correction.
Field name | Field type | Description | Null? |
|---|---|---|---|
ObjectID | integer | The row ID | NOT NULL |
AssocObjectID | integer | The row ID of the mosaic dataset catalog | NOT NULL |
Name | nvarchar(256) | Name of the raster item | |
PreStOrGammaTableBlob | varbinary(max) | Binary large object of color correction prestretch color map or Gamma map | |
Raster | integer st_raster | Raster of local mean and local standard deviation |
This table stores a managed item cache generated by the Build Item Cache geoprocessing tool or Cached Raster function in ArcGIS for Desktop.
Field name | Field type | Description | Null? |
|---|---|---|---|
ObjectID | integer | The unique identifier for the dataset | NOT NULL |
Name | nvarchar(50) | The name of the managed item cache or cache raster function | |
Raster | integer | Managed item cache dataset or cache raster function |
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 | integer | The unique identifier for the dataset | NOT NULL |
InstanceID | integer | The ObjectID of the raster type instance stored in the raster type table associated with the corresponding cell size level | |
LevelID | integer | The identifier associated with the cell size level | |
CellSize | numeric(38,8) | The cell size value associated with the cell size level | |
Minps | numeric(38,8) | Minimum pixel size | |
Maxps | numeric(38,8) | Maximum pixel size | |
Category | integer | Identifies the dataset type: 0 = Unknown, 1 = Primary, 2 = ServiceOverview, 3 = DerivedRaster, 255 = Custom | |
Shape | integer geometry geography | The minimum bounding polygon of all items belonging to the corresponding cell size level |
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 |
integer |
The unique identifier of each row in this table |
NOT NULL |
|
MsgCode |
integer |
Error or warning code that uniquely identifies the message |
|
|
MsgSrc |
nvarchar(100) |
The source; usually the name of the operation that generated this message |
|
|
MsgText |
nvarchar(250) |
The text description of the message |
|
MsgElapsed | numeric(38,8) | The elapsed time for processes associated with the message to complete | |
|
MsgType |
integer |
Differentiates between error, warning, and information messages: 1 = Error, 2 = Warning, 3 = Info1, 4 = Info2, 5= Info3, 100 = Debug |
|
|
RasterId |
integer |
ObjectID of the record in the AMD_<NAME>_CAT table that corresponds to this message |
|
|
MsgTime |
nvvarchar(30) |
The date and time the error or warning message occurred |
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 | integer | The unique identifier of the overview record | NOT NULL |
Name | nvarchar(50) | System-generated name of the raster dataset value that identifies the row and column position of the overview record | |
Raster | integer st_raster | The raster dataset |
This table defines the seamline shapes that are used for mosaicking when the MosaicMethod used is seamline.
|
Field name |
Field type |
Description |
Null? |
|---|---|---|---|
|
ObjectID |
integer |
The unique identifier of the seamline |
NOT NULL |
|
RasterID |
integer |
The ObjectID of the record in the amd_cat table that corresponds to this seamline shape |
|
BlendWidth | integer | The width of pixel blending along the seamline | |
BlendType | integer | The type of pixel blending: 1 = Both (Pixel blending happens on both sides of the seamline.), 2 = Inside (Pixel blending is towards the center of the image from the seamline.), 3 = Outside (Pixel blending is outwards from the seamline.) | |
|
Shape |
integer geometry geography |
The shape of the seamline |
NOT NULL |
This table stores stereo IDs of the pairs that participate in a stereo image.
|
Field name |
Field type |
Description |
Null? |
|---|---|---|---|
|
ObjectID |
integer |
The unique identifier for each record in this table |
NOT NULL |
|
StereoID1 |
nvarchar(50) |
ID of one of the participating stereo pairs |
|
|
StereoID2 |
nvarchar(50) |
ID of the other of the participating stereo pair |
This table maintains a one-to-many relationship between each analyzed mosaic dataset item and the set of corresponding analysis results.
Field name | Field type | Description | Null? |
|---|---|---|---|
ObjectID | integer | The row ID | NOT NULL |
RasterID | integer | Corresponds to the ObjectID field in the amd_cat table | |
ResultID | integer | The identifier of the analysis result message |
Dashed lines indicate implicit relationships between columns.
Mosaic datasets in an XML document
Mosaic datasets are not currently supported in XML documents.