Editor Tracking properties

サマリー

The Describe function returns the following properties for datasets that have editor tracking enabled.

Editor tracking can be supported for Feature Class, Table, Mosaic Dataset, or Raster Catalog property groups. Editor tracking properties are only supported by geodatabase data types. The dataType returned is the dataType of the feature class, table, mosaic dataset, or raster catalog.

プロパティ

プロパティ	説明	データ タイプ
editorTrackingEnabled (読み取り専用)	True if editor tracking is enabled for the dataset.	Boolean
creatorFieldName (読み取り専用)	The name of the field that contains the username of the person who created a feature, row, or raster.	String
createdAtFieldName (読み取り専用)	The name of the field that contains the date and time a feature, row, or raster was created.	String
editorFieldName (読み取り専用)	The name of the field that contains the username of the person who most recently edited a feature, row, or raster.	String
editedAtFieldName (読み取り専用)	The name of the field that contains the date and time a feature, row, or raster was most recently edited.	String
isTimeInUTC (読み取り専用)	True if times stored in the CreatedAt field and EditedAt field are stored in UTC (coordinated universal time). False if they are stored in database time.	Boolean

コードのサンプル

Editor tracking dataset properties example

The following stand-alone script displays how many features in a feature class were most recently edited by each user:

import arcpy

# Create a Describe object from the feature class
#
gdb_fc = "C:/data/ParcelBase.gdb/parcels_enabled"
desc = arcpy.Describe(gdb_fc)

# If the feature class has editor tracking enabled, then
#   list how many features were last edited by each user.
#
if desc.editorTrackingEnabled:
    #
    # Get the editorFieldName from the describe object
    whoField = desc.editorFieldName
    #
    # Use a cursor to search through all the features
    userDictionary = {}
    cur = arcpy.da.SearchCursor(gdb_fc, [whoField])
    for row in cur:
        featureEditedBy = row[0]
        if featureEditedBy in userDictionary:
            userDictionary[featureEditedBy] += 1
        else:
            userDictionary[featureEditedBy] = 1
    #
    # Print the results
    for user in list(userDictionary.keys()):
        if user == None:
            print('Last edited before editor tracking was enabled: '+ \
                   str(userDictionary[user]))
        else:
            print("Last edited by " + user + ": " + str(userDictionary[user]))
else:
    print('Editor tracking not enabled for '+gdb_fc)