AnsweredAssumed Answered

Calculating a field in a versioned geodatabase.  What is the best method?

Question asked by PrillLake on Apr 5, 2015
Latest reply on Apr 6, 2015 by jskinner-esristaff

I need to update one field, AnnotationClassID, for all annotation in our versioned SDE.  There are close to a million records in a half dozen feature classes.  What are the ramifications of using the arcpy.da module to do this task? Curious to know how others have handled this task.  Below is a basic sketch of what I had in mind.  Many Thanks!

 

import arcpy
import os

fc = r'X:\Database connection to vm-sql3.sde\Anno0100scale'
workspace = os.path.dirname(fc)

edit = arcpy.da.Editor(workspace)
edit.startEditing(False, True)
edit.startOperation()

cursor = arcpy.UpdateCursor(fc, ["AnnotationClassID","SymbolID"])
for row in cursor:
  row.AnnotationClassID = row.SymbolID
  cursor.updateRow(row)

edit.stopOperation()
edit.stopEditing(True)

Outcomes