Alter Mosaic Dataset Schema (Data Management)
Summary
Prepares the schema of a mosaic dataset in ArcSDE by generating any tables or fields that may be required. This allows the nonowner of the mosaic dataset to make modifications, such as adding raster data.
This tool prevents schema-locking issues that can arise when a mosaic dataset is stored in ArcSDE. The ArcSDE owner will run this tool to create any side tables and fields that may be needed by the user. The ArcSDE owner must also grant the proper permissions to allow users to insert, update, or delete records.
Usage
This tool is only necessary when you are creating a mosaic dataset within ArcSDE and a nonowner will be editing the mosaic dataset.
Use this tool to set up a mosaic dataset (in a file or ArcSDE geodatabase) that will be published as an image service allowing users to upload or edit the items. A user can only upload their data if the raster type is allowed by the mosaic dataset.
Choose the operations that are allowed for this mosaic dataset. This will create the necessary tables that will be required. If a nonowner tries to perform an operation that is not allowed, the operation will fail.
Choose the raster types that are allowed for this mosaic dataset. This will create the necessary fields that will be required. If a nonowner uses the Add Rasters To Mosaic Dataset and tries to use a Raster type that has not been specified by this tool, the Add Rasters To Mosaic Dataset will fail.
-
If you run this tool without choosing any raster types, only the additional mosaic dataset tables will be created. These tables include overview, seamline, color correction, stereo, cell size levels, status, error, and permissions.
Syntax
| Parameter | Explanation | Data Type |
in_mosaic_dataset |
The input mosaic dataset schema to alter. | Mosaic Layer |
side_tables [side_table,...] (Optional) | Choose all the operations that are allowable for this mosaic dataset. The proper tables will be created.
| String |
raster_type_names [raster_type_names,...] (Optional) |
Choose all the raster types that are allowable for this mosaic dataset. The proper fields will be created.
If you wish to use a custom raster type, then type the path of the custom raster type file. | String |
Code Sample
This is a Python sample for the AlterMosaicDatasetSchema tool.
import arcpy
arcpy.AlterMosaicDatasetSchema_management(
"\\serv\folder\myFGBD.gdb\md_01", "ANALYSIS;BOUNDARY;LEVELS;OVERVIEW",
"QuickBird;IKONOS;Match-AT")
This is a Python script sample for the AlterMosaicDatasetSchema tool.
#Alter Mosaic Dataset Schema mainly works on SDE mosaic dataset
#The selected side tables of mosaic dataset will be created
#If there is raster type settings, metadata fields for that raster
#types will be created
import arcpy
arcpy.env.workspace = "C:/Workspace"
mosaicds = "sdeserver.sde/mosaicds"
ops = "ANALYSIS;BOUNDARY;LEVELS;LOG;OVERVIEW"
rastypes = "QuickBird;IKONOS;Match-AT"
arcpy.AlterMosaicDatasetSchema_management(mosaicds, ops, rastypes)