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 specified by this tool control which 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

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

  • AnalysisA nonowner will be allowed to run the Analyze Mosaic Dataset tool on the mosaic dataset.
  • BoundaryA 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.
  • CacheA nonowner will be allowed to create a cache for the mosaic dataset.
  • Color correctionA nonowner will be allowed to color correct the mosaic dataset.
  • DefinitionA 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.
  • LogA 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.
  • SeamlineA 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.
  • ViewA nonowner will be allowed to edit the image service. When selected, Enable Editor Tracking will automatically turn on.
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 Leica ADS raster type
  • AltumAltum raster type
  • ASTERASTER raster type
  • CADRG/ECRGCADRG/ECRG raster type
  • CIBCIB raster type
  • Deimos-2 Deimos-2 raster type
  • DTEDDTED raster type
  • DMCiiDMCii raster type
  • DubaiSat-2DubaiSat-2 raster type
  • FORMOSAT-2FORMOSAT-2 raster type
  • Frame CameraFrame Camera raster type
  • GeoEyeGeoEye-1 raster type
  • GF-1 PMSGF-1 PMS raster type
  • GF-1 WFVGF-1 WFV raster type
  • GF-2 PMSGF-2 PMS raster type
  • GF-4 PMIGF-4 PMI raster type
  • GRIBGRIB raster type
  • HDFHDF raster type
  • HJ 1A/HJ 1B CCDHJ 1A/HJ 1B CCD raster type
  • HREHRE raster type
  • IKONOSIKONOS raster type
  • Jilin-1Jilin-1 raster type
  • KOMPSAT-2KOMPSAT-2 raster type
  • KOMPSAT-3KOMPSAT-3 raster type
  • LAS LAS raster type
  • Landsat MSSLandsat 1-5 MSS raster type
  • Landsat TMLandsat 4-5 TM raster type
  • Landsat ETM+Landsat 7 ETM+ raster type
  • Landsat 8Landsat 8 raster type
  • Landsat 9Landsat 9 raster type
  • MaxarMaxar
  • NITFNITF raster type
  • NetCDFNetCDF raster type
  • NCDRDNCDRD raster type
  • PlanetScopePlanetScope raster type
  • Pleiades NeoPleiades Neo raster type
  • Pleiades-1Pleiades-1 raster type
  • QuickBirdQuickbird raster type
  • RADARSAT-2RADARSAT-2 raster type
  • RapidEye RapidEye raster type
  • Raster Process DefinitionRaster Process Definition raster type
  • RedEdgeRedEdge raster type
  • Scanned aerial imageryScanned Aerial Imagery raster type
  • Sentinel-1Sentinel-1 raster type
  • Sentinel-2Sentinel-2 raster type
  • Sentinel-3Sentinel-3 raster type
  • SkySat-CSkySat-C raster type
  • Spot 5SPOT 5 raster type
  • Spot 6SPOT 6 raster type
  • Spot 7SPOT 7 raster type
  • SuperView-1SuperView-1 raster type
  • TeLEOS-1TelEOS-1 raster type
  • TH-01TH-01 raster type
  • UAV/UASUAV/UAS raster type
  • WorldView-1WorldView-1 raster type
  • WorldView-2 WorldView-2 raster type
  • WorldView-3WorldView-3 raster type
  • WorldView-4WorldView-4 raster type
  • ZY1-02C HRCZY1-02C HRC raster type
  • ZY1-02C PMSZY1-02C PMS raster type
  • ZY3-CRESDAZY3-CRESDA raster type
  • ZY3-SASMACZY3-SASMAC raster type
String
Enable Editor Tracking
(Optional)

Specifies whether enable 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 used for the Operations parameter, editor tracking will automatically be activated.

Boolean

Derived Output

LabelExplanationData Type
Updated Mosaic Dataset

The updated mosaic dataset.

Mosaic Layer

arcpy.management.AlterMosaicDatasetSchema(in_mosaic_dataset, {side_tables}, {raster_type_names}, {editor_tracking})
NameExplanationData 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.

  • ANALYSISA nonowner will be allowed to run the Analyze Mosaic Dataset tool on the mosaic dataset.
  • BOUNDARYA 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.
  • CACHEA nonowner will be allowed to create a cache for the mosaic dataset.
  • COLOR_CORRECTIONA nonowner will be allowed to color correct the mosaic dataset.
  • DEFINITIONA nonowner will be allowed to add multidimensional data or a processing template to the mosaic dataset.
  • LEVELSA nonowner will be allowed to calculate cell size ranges or create seamlines for the mosaic dataset.
  • LOGA nonowner will be allowed to create a log table for the mosaic dataset.
  • OVERVIEWA nonowner will be allowed to create overviews for the mosaic dataset.
  • SEAMLINEA nonowner will be allowed to create seamlines for the mosaic dataset.
  • STEREOA nonowner will be allowed to define stereo pairs for the mosaic dataset.
  • VIEWA nonowner will be allowed to edit the image service. The editor_tracking parameter will be automatically enabled when VIEW is used, 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.

  • ADS Leica ADS raster type
  • AltumAltum raster type
  • ASTERASTER raster type
  • CADRG/ECRGCADRG/ECRG raster type
  • CIBCIB raster type
  • DEIMOS-2 Deimos-2 raster type
  • DTEDDTED raster type
  • DMCiiDMCii raster type
  • DubaiSat-2DubaiSat-2 raster type
  • FORMOSAT-2FORMOSAT-2 raster type
  • Frame CameraFrame Camera raster type
  • GeoEye-1GeoEye-1 raster type
  • GF-1 PMSGF-1 PMS raster type
  • GF-1 WFVGF-1 WFV raster type
  • GF-2 PMSGF-2 PMS raster type
  • GF-4 PMIGF-4 PMI raster type
  • GRIBGRIB raster type
  • HDFHDF raster type
  • HJ 1A/1B CCDHJ 1A/HJ 1B CCD raster type
  • HREHRE raster type
  • IKONOSIKONOS raster type
  • Jilin-1Jilin-1 raster type
  • KOMPSAT-2KOMPSAT-2 raster type
  • KOMPSAT-3KOMPSAT-3 raster type
  • LAS LAS raster type
  • Landsat 1-5 MSSLandsat 1-5 MSS raster type
  • Landsat 4-5 TMLandsat 4-5 TM raster type
  • Landsat 7 ETM+Landsat 7 ETM+ raster type
  • Landsat 8Landsat 8 raster type
  • Landsat 9Landsat 9 raster type
  • MAXARMaxar
  • NCDRDNCDRD raster type
  • NITFNITF raster type
  • NetCDFNetCDF raster type
  • Pleiades NeoPleiades Neo raster type
  • Pleiades-1Pleiades-1 raster type
  • PlanetScopePlanetScope raster type
  • QuickBirdQuickbird raster type
  • RADARSAT-2RADARSAT-2 raster type
  • RapidEye RapidEye raster type
  • Raster Process DefinitionRaster Process Definition raster type
  • RedEdgeRedEdge raster type
  • Scanned Aerial ImageryScanned Aerial Imagery raster type
  • Sentinel-1Sentinel-1 raster type
  • Sentinel-2Sentinel-2 raster type
  • Sentinel-3Sentinel-3 raster type
  • SkySatSkySat-C raster type
  • SPOT 5SPOT 5 raster type
  • SPOT 6SPOT 6 raster type
  • SPOT 7SPOT 7 raster type
  • SuperView-1SuperView-1 raster type
  • TeLEOS-1TeLEOS-1
  • TH-01TH-01 raster type
  • UAV/UASUAV/UAS raster type
  • WorldView-1WorldView-1 raster type
  • WorldView-2 WorldView-2 raster type
  • WorldView-3WorldView-3 raster type
  • WorldView-4WorldView-4 raster type
  • ZY1-02C HRCZY1-02C HRC raster type
  • ZY1-02C PMSZY1-02C PMS raster type
  • ZY3-CRESDAZY3-CRESDA raster type
  • ZY3-SASMACZY3-SASMAC raster type

To use a custom raster type, provide the path of the custom raster type file.

String
editor_tracking
(Optional)

Specifies whether enable editor tracking will be enabled.

Editor tracking can help you maintain accountability and enforce quality-control standards.

  • NO_EDITOR_TRACKINGEditor tracking will not be enabled. This is the default.
  • EDITOR_TRACKINGEditor tracking will be enabled.

If the VIEW keyword is used for the side_tables parameter, editor tracking will automatically be enabled.

Boolean

Derived Output

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

Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes

Related topics