Alter Mosaic Dataset Schema (Data Management)

Summary

Defines the editing operations that nonowners have when editing a mosaic dataset in an enterprise geodatabase.

This tool prevents schema-locking issues that can occur when a mosaic dataset is stored in an enterprise geodatabase. The owner of the geodatabase runs this tool to create side tables and fields that may be needed by the user. The owner must also grant the proper permissions to allow users to insert, update, or delete records.

Usage

• This tool is only needed when creating a mosaic dataset in an enterprise geodatabase 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 data if the raster type is allowed by the mosaic dataset.

• If a nonowner attempts to perform an operation that is not allowed, the operation will fail.

• The Raster Types parameter values control the rasters a nonowner can add using the Add Rasters To Mosaic Dataset tool. If the nonowner tries to add a raster type that has not been specified by this tool, the Add Rasters To Mosaic Dataset tool 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.

Parameters

Dialog

Label	Explanation	Data Type
Mosaic Dataset	The mosaic dataset on which the permitted operations will be changed.	Mosaic Layer
Operations (Optional)	Specifies the operations that will be permissible for the mosaic dataset. Analysis—A nonowner will be allowed to run the Analyze Mosaic Dataset tool on the mosaic dataset. Boundary—A nonowner will be allowed to create or edit the boundary of the mosaic dataset. This is required if a nonowner will add raster datasets outside of the existing boundary. Cache—A nonowner will be allowed to create a cache for the mosaic dataset. Color correction—A nonowner will be allowed to color correct the mosaic dataset. Definition—A nonowner will be allowed to add multidimensional data or a processing template to the mosaic dataset. Levels— A nonowner will be allowed to calculate cell size ranges for the mosaic dataset. Log—A nonowner will be allowed to create a log table for the mosaic dataset. Overview— A nonowner will be allowed to create overviews for the mosaic dataset. Seamline—A nonowner will be allowed to create seamlines for the mosaic dataset. Stereo— A nonowner will be allowed to define stereo pairs for the mosaic dataset. View—A nonowner will be allowed to edit the image service. The Enable Editor Tracking parameter will be automatically activated when this option is specified.	String
Raster Types (Optional)	Specifies the raster types that nonowners can add to the mosaic dataset. To select a custom raster type, provide the location of the custom raster type file. Airborne Digital Sensors—The Leica ADS raster type can be added. Altum—The Altum raster type can be added. ASTER—The ASTER raster type can be added. AVIRIS—The AVIRIS raster type can be added. BlackSky—The BlackSky raster type can be added. CADRG/ECRG—The CADRG/ECRG raster type can be added. CIB—The CIB raster type can be added. Capella—The Capella raster type can be added. Deimos-2—The Deimos-2 raster type can be added. DTED—The DTED raster type can be added. DMCii—The DMCii raster type can be added. DubaiSat-2—The DubaiSat-2 raster type can be added. EMIT—The EMIT raster type can be added. FORMOSAT-2—The FORMOSAT-2 raster type can be added. Frame Camera—The Frame Camera raster type can be added. GeoEye—The GeoEye-1 raster type can be added. GF-1 PMS—The GF-1 PMS raster type can be added. GF-1 WFV—The GF-1 WFV raster type can be added. GF-2 PMS—The GF-2 PMS raster type can be added. GF-4 PMI—The GF-4 PMI raster type can be added. GRIB—The GRIB raster type can be added. HDF—The HDF raster type can be added. HJ 1A/HJ 1B CCD—The HJ 1A/HJ 1B CCD raster type can be added. HRE—The HRE raster type can be added. ICEYE—The ICEYE raster type can be added. IKONOS—The IKONOS raster type can be added. Jilin-1—The Jilin-1 raster type can be added. KOMPSAT-2—The KOMPSAT-2 raster type can be added. KOMPSAT-3—The KOMPSAT-3 raster type can be added. LAS—The LAS raster type can be added. Landsat MSS—The Landsat 1-5 MSS raster type can be added. Landsat TM—The Landsat 4-5 TM raster type can be added. Landsat ETM+—The Landsat 7 ETM+ raster type can be added. Landsat 8—The Landsat 8 raster type can be added. Landsat 9—The Landsat 9 raster type can be added. can be added. Maxar—The Maxar raster type can be added. Match-AT—The Match-AT raster type can be added. NITF—The NITF raster type can be added. NetCDF—The NetCDF raster type can be added. NCDRD—The NCDRD raster type can be added. PlanetScope—The PlanetScope raster type can be added. Pleiades Neo—The Pleiades Neo raster type can be added. Pleiades-1—The Pleiades-1 raster type can be added. QuickBird—The Quickbird raster type can be added. RADARSAT-2—The RADARSAT-2 raster type can be added. RCM—The RCM raster type can be added. RapidEye—The RapidEye raster type can be added. Raster Process Definition—The Raster Process Definition raster type can be added. RedEdge—The RedEdge raster type can be added. Satellogic—The Satellogic raster type can be added. SOCET SET—The SOCET SET raster type can be added. Scanned aerial imagery—The Scanned Aerial Imagery raster type can be added. Sentinel-1—The Sentinel-1 raster type can be added. Sentinel-2—The Sentinel-2 raster type can be added. Sentinel-3—The Sentinel-3 raster type can be added. SkySat-C—The SkySat-C raster type can be added. Spot 5—The SPOT 5 raster type can be added. Spot 6—The SPOT 6 raster type can be added. Spot 7—The SPOT 7 raster type can be added. SuperView-1—The SuperView-1 raster type can be added. TeLEOS-1—The TelEOS-1 raster type can be added. TH-01—The TH-01 raster type can be added. UAV/UAS—The UAV/UAS raster type can be added. Vision-1—The Vision-1 raster type can be added. WorldView-1—The WorldView-1 raster type can be added. WorldView-2— The WorldView-2 raster type can be added. WorldView-3—The WorldView-3 raster type can be added. WorldView-4—The WorldView-4 raster type can be added. ZY1-02C HRC—The ZY1-02C HRC raster type can be added. ZY1-02C PMS—The ZY1-02C PMS raster type can be added. ZY3-CRESDA—The ZY3-CRESDA raster type can be added. ZY3-SASMAC—The ZY3-SASMAC raster type can be added.	String
Enable Editor Tracking (Optional)	Specifies whether editor tracking will be activated. Editor tracking can help you maintain accountability and enforce quality-control standards. Unchecked—Editor tracking will not be activated. This is the default. Checked—Editor tracking will be activated. If the View option is specified for the Operations parameter, editor tracking will be automatically activated.	Boolean

Derived Output

Label	Explanation	Data Type
Updated Mosaic Dataset	The updated mosaic dataset.	Mosaic Layer

Python

arcpy.management.AlterMosaicDatasetSchema(in_mosaic_dataset, {side_tables}, {raster_type_names}, {editor_tracking})

Name	Explanation	Data Type
in_mosaic_dataset	The mosaic dataset on which the permitted operations will be changed.	Mosaic Layer
side_tables [operation,...] (Optional)	Specifies the operations that will be permissible for the mosaic dataset. ANALYSIS—A nonowner will be allowed to run the Analyze Mosaic Dataset tool on the mosaic dataset. BOUNDARY—A nonowner will be allowed to create or edit the boundary of the mosaic dataset. This is also required if a nonowner will add rasters outside of the existing boundary. CACHE—A nonowner will be allowed to create a cache for the mosaic dataset. COLOR_CORRECTION—A nonowner will be allowed to color correct the mosaic dataset. DEFINITION—A nonowner will be allowed to add multidimensional data or a processing template to the mosaic dataset. LEVELS—A nonowner will be allowed to calculate cell size ranges or create seamlines for the mosaic dataset. LOG—A nonowner will be allowed to create a log table for the mosaic dataset. OVERVIEW—A nonowner will be allowed to create overviews for the mosaic dataset. SEAMLINE—A nonowner will be allowed to create seamlines for the mosaic dataset. STEREO—A nonowner will be allowed to define stereo pairs for the mosaic dataset. VIEW—A nonowner will be allowed to edit the image service. The editor_tracking parameter will be automatically enabled when this option is specified, since the View table must have editor tracking turned on.	String
raster_type_names [raster_type,...] (Optional)	Specifies the raster types that nonowners can add to the mosaic dataset. To select a custom raster type, provide the location of the custom raster type file. ADS—The Leica ADS raster type can be added. Altum—The Altum raster type can be added. ASTER—The ASTER raster type can be added. AVIRIS—The AVIRIS raster type can be added. BlackSky—The BlackSky raster type can be added. CADRG/ECRG—The CADRG/ECRG raster type can be added. CIB—The CIB raster type can be added. Capella—The Capella raster type can be added. DEIMOS-2—The Deimos-2 raster type can be added. DTED—The DTED raster type can be added. DMCii—The DMCii raster type can be added. DubaiSat-2—The DubaiSat-2 raster type can be added. EMIT—The EMIT raster type can be added. FORMOSAT-2—The FORMOSAT-2 raster type can be added. Frame Camera—The Frame Camera raster type can be added. GeoEye-1—The GeoEye-1 raster type can be added. GF-1 PMS—The GF-1 PMS raster type can be added. GF-1 WFV—The GF-1 WFV raster type can be added. GF-2 PMS—The GF-2 PMS raster type can be added. GF-4 PMI—The GF-4 PMI raster type can be added. GRIB—The GRIB raster type can be added. HDF—The HDF raster type can be added. HJ 1A/1B CCD—The HJ 1A/HJ 1B CCD raster type can be added. HRE—The HRE raster type can be added. ICEYE—The ICEYE raster type can be added. IKONOS—The IKONOS raster type can be added. Jilin-1—The Jilin-1 raster type can be added. KOMPSAT-2—The KOMPSAT-2 raster type can be added. KOMPSAT-3—The KOMPSAT-3 raster type can be added. LAS—The LAS raster type can be added. Landsat 1-5 MSS—The Landsat 1-5 MSS raster type can be added. Landsat 4-5 TM—The Landsat 4-5 TM raster type can be added. Landsat 7 ETM+—The Landsat 7 ETM+ raster type can be added. Landsat 8—The Landsat 8 raster type can be added. Landsat 9—The Landsat 9 raster type can be added. can be added. MAXAR—The Maxar raster type can be added. Match-AT—The Match-AT raster type can be added. NCDRD—The NCDRD raster type can be added. NITF—The NITF raster type can be added. NetCDF—The NetCDF raster type can be added. PlanetScope—The PlanetScope raster type can be added. Pleiades Neo—The Pleiades Neo raster type can be added. Pleiades-1—The Pleiades-1 raster type can be added. QuickBird—The Quickbird raster type can be added. RADARSAT-2—The RADARSAT-2 raster type can be added. RCM—The RCM raster type can be added. RapidEye—The RapidEye raster type can be added. Raster Process Definition—The Raster Process Definition raster type can be added. RedEdge—The RedEdge raster type can be added. Satellogic—The Satellogic raster type can be added. SOCET SET—The SOCET SET raster type can be added. Scanned Aerial Imagery—The Scanned Aerial Imagery raster type can be added. Sentinel-1—The Sentinel-1 raster type can be added. Sentinel-2—The Sentinel-2 raster type can be added. Sentinel-3—The Sentinel-3 raster type can be added. SkySat—The SkySat-C raster type can be added. SPOT 5—The SPOT 5 raster type can be added. SPOT 6—The SPOT 6 raster type can be added. SPOT 7—The SPOT 7 raster type can be added. SuperView-1—The SuperView-1 raster type can be added. TeLEOS-1—The TelEOS-1 raster type can be added. TH-01—The TH-01 raster type can be added. UAV/UAS—The UAV/UAS raster type can be added. Vision-1—The Vision-1 raster type can be added. WorldView-1—The WorldView-1 raster type can be added. WorldView-2— The WorldView-2 raster type can be added. WorldView-3—The WorldView-3 raster type can be added. WorldView-4—The WorldView-4 raster type can be added. ZY1-02C HRC—The ZY1-02C HRC raster type can be added. ZY1-02C PMS—The ZY1-02C PMS raster type can be added. ZY3-CRESDA—The ZY3-CRESDA raster type can be added. ZY3-SASMAC—The ZY3-SASMAC raster type can be added.	String
editor_tracking (Optional)	Specifies whether editor tracking will be enabled. Editor tracking can help you maintain accountability and enforce quality-control standards. NO_EDITOR_TRACKING—Editor tracking will not be enabled. This is the default. EDITOR_TRACKING—Editor tracking will be enabled. If the VIEW keyword is specified for the side_tables parameter, editor tracking will be automatically enabled.	Boolean

Derived Output

Name	Explanation	Data Type
out_mosaic_dataset	The updated mosaic dataset.	Mosaic Layer

Code sample

AlterMosaicDatasetSchema example 1 (Python window)

This is a Python sample for the AlterMosaicDatasetSchema function.

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 function.

#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.