Alter Mosaic Dataset Schema (Data Management)

Summary

Defines which editing operations non-owners have when editing an ArcSDE mosaic dataset.

This tool prevents schema-locking issues that can arise when a mosaic dataset is stored in ArcSDE. The ArcSDE owner runs 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 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 allowed for this mosaic dataset. If a nonowner tries to perform an operation that is not allowed, the operation will fail.

• Choose the raster types allowed for this mosaic dataset. This creates 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

AlterMosaicDatasetSchema_management (in_mosaic_dataset, {side_tables}, {raster_type_names}, {editor_tracking})

Parameter	Explanation	Data Type
in_mosaic_dataset	The mosaic dataset where you will change permitted operations.	Mosaic Layer
side_tables [operation,...] (Optional)	Choose the operations you want to make permissible for this mosaic dataset. ANALYSIS — Allow a non-owner to run the Analyze Mosaic Dataset tool on the mosaic dataset. BOUNDARY — Allow a non-owner to create or edit the boundary of the mosaic dataset. This is required if a non-owner will add raster datasets outside of the existing boundary. CACHE — Allow a non-owner to create cache for the mosaic dataset. COLOR_CORRECTION — Allow a non-owner to color-correct the mosaic dataset. LEVELS — Allows a non-owner to calculate cell size ranges for the mosaic dataset. LOG — Allow a non-owner to create a log table for the mosaic dataset. OVERVIEW — Allow a non-owner to create overviews for the mosaic dataset. SEAMLINE — Allow a non-owner to create seam lines for the mosaic dataset. STEREO — Allow a non-owner to define stereo pairs for the mosaic dataset. VIEW —Allow a non-owner to edit the image service. When selected, Enable Editor Tracking will automatically turn on.	String
raster_type_names [raster_type,...] (Optional)	Choose all the raster types allowable for this mosaic dataset. CADRG/ECRG —CADRG/ECRG raster type CIB —CIB raster type DTED —DTED raster type FORMOSAT-2 —FORMOSAT-2 raster type GeoEye-1 —GeoEye-1 raster type HRE —HRE raster type IKONOS —IKONOS raster type KOMPSAT-2 —KOMPSAT-2 raster type LAS — LAS raster type Landsat 1-5 MSS —Landsat 1-5 MSS raster type Landsat 4-5 TM —Landsat 4-5 TM raster type Landsat 7 ETM+ —Landsat 7 ETM+ raster type NITF —NITF raster type Quickbird —Quickbird raster type RADARSAT-2 —RADARSAT-2 raster type RapidEye — RapidEye raster type Raster Process Definition —Raster Process Definition raster type SPOT 5 —SPOT 5 raster type WorldView-1 —WorldView-1 raster type WorldView-2 — WorldView-2 raster type If you wish to use a custom raster type, then enter the path of the custom raster type file.	String
editor_tracking (Optional)	Editor tracking can help you maintain accountability and enforce quality-control standards. For more information about Editor Tracking, see About tracking an editor's changes to data. NO_EDITOR_TRACKING —Do not turn on editor tracking. This is the default. EDITOR_TRACKING —Enables editor tracking for your mosaic dataset. If the VIEW keyword is used in the side_tables parameter, then Editor Tracking will automatically be enabled.	Boolean

Code Sample

AlterMosaicDatasetSchema example 1 (Python window)

This is a Python sample for the AlterMosaicDatasetSchema tool.

import arcpy
arcpy.AlterMosaicDatasetSchema_management(
    "C:/folder/mySDEcon.sde/md_01", 
    "ANALYSIS;BOUNDARY;LEVELS;OVERVIEW;VIEW",
    "QuickBird;IKONOS", "EDITOR_TRACKING")

AlterMosaicDatasetSchema example 2 (stand-alone script)

This is a Python script sample for the AlterMosaicDatasetSchema tool.

#Alter Mosaic Dataset Schema mainly works on SDE mosaic datasets. The 
#selected side tables of mosaic dataset will be created. If there are
#raster type settings, metadata fields will be create for that raster type.

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)

Environments

This tool does not use any geoprocessing environments

Licensing Information

ArcGIS for Desktop Basic: No

ArcGIS for Desktop Standard: Yes

ArcGIS for Desktop Advanced: Yes