Alter Mosaic Dataset Schema (Data Management)


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

This tool prevents schema-locking issues that can arise when a mosaic dataset is stored in an enterprise geodatabase. The owner of the geodatabase runs this tool to create any 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.


  • This tool is only needed when creating a mosaic dataset within 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 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.


AlterMosaicDatasetSchema(in_mosaic_dataset, {side_tables}, {raster_type_names}, {editor_tracking})
ParameterExplanationData Type

The mosaic dataset on which to change permitted operations.

Mosaic Layer

The operations permissible for this mosaic dataset.

  • ANALYSISChoose this option if a nonowner is allowed to run the Analyze Mosaic Dataset tool on the mosaic dataset.
  • BOUNDARYChoose this option if a nonowner is 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.
  • CACHEChoose this option if a nonowner is allowed to create a cache for the mosaic dataset.
  • COLOR_CORRECTIONChoose this option if a nonowner is allowed to color correct the mosaic dataset.
  • DEFINITIONChoose this option if a nonowner is allowed to add multidimensional data or a processing template to the mosaic dataset.
  • LEVELSChoose this option if a nonowner is allowed to calculate cell size ranges or create seamlines for the mosaic dataset.
  • LOGChoose this option if a nonowner is allowed to create a log table for the mosaic dataset.
  • OVERVIEWChoose this option if a nonowner is allowed to create overviews for the mosaic dataset.
  • SEAMLINEChoose this option if a nonowner is allowed to create seamlines for the mosaic dataset.
  • STEREOChoose this option if a nonowner is allowed to define stereo pairs for the mosaic dataset.
  • VIEWChoose this option if a nonowner is 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.

Specify all of the raster types that nonowners can add to this 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
  • NCDRDNCDRD raster type
  • NITFNITF raster type
  • NetCDFNetCDF 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
  • SkySatSkySat-C raster type
  • SPOT 5SPOT 5 raster type
  • SPOT 6SPOT 6 raster type
  • SPOT 7SPOT 7 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

If you wish to use a custom raster type, enter the path of the custom raster type file.


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

  • NO_EDITOR_TRACKINGDo not turn on editor tracking. This is the default.
  • EDITOR_TRACKINGEnables editor tracking for your mosaic dataset.

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


Derived Output

NameExplanationData Type

The updated mosaic dataset.

Mosaic Layer

Code sample

AlterMosaicDatasetSchema example 1 (Python window)

This is a Python sample for the AlterMosaicDatasetSchema tool.

import arcpy
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"
rastypes = "QuickBird;IKONOS;Match-AT"

arcpy.AlterMosaicDatasetSchema_management(mosaicds, ops, rastypes)


This tool does not use any geoprocessing environments.

Licensing information

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

Related topics