topic Re: Calculating a field in a versioned geodatabase. What is the best method? in Python Questions

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

AdamCrateau1 — Sat, 11 Dec 2021 21:37:49 GMT

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)

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

GloriaTshokama — Mon, 06 Apr 2015 06:22:09 GMT

great

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

JakeSkinner — Sat, 11 Dec 2021 21:37:51 GMT

Hi Adam,

Using the arcpy.da module will be much faster. Ex:

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

Before running this script, I would recommend creating a database backup. Also, after the edits are complete, it will be best to perform a reconcile/post, compress, and analyze of the datasets.