topic Re: Edit Versioned Feature Class in python in Developers Questions

Edit Versioned Feature Class in python

BrendanDwyer — Wed, 09 Jul 2014 20:00:09 GMT

I have a versioned feature class in sde that is the source of a map service. I can open the feature class in arc map, start an edit session, make edits and save those edits. However, if I try to start an edit session in an arcpy script I get a schema lock. I'm using the same user and sde connection file. Shouldn't I be able to edit this feature class in arcpy?

Re: Edit Versioned Feature Class in python

JakeSkinner — Thu, 10 Jul 2014 13:13:48 GMT

Hi Brendan,

Can you post the code you are using? Here is an example of editing a versioned feature class:

import arcpy
import os

fc = 'Database Connections/VECTOR@SQLSERVER.sde/AddressPts'
workspace = os.path.dirname(fc)

# Start an edit session. Must provide the worksapce.
edit = arcpy.da.Editor(workspace)

# Edit session is started without an undo/redo stack for versioned data
#  (for second argument, use False for unversioned data)
edit.startEditing(False, True)

# Start an edit operation
edit.startOperation()

# Insert a row into the table.
with arcpy.da.InsertCursor(fc, ('SHAPE@', 'Address')) as icur:
    icur.insertRow([(601181.055124, 762555.994028), '120 Main St'])

# Stop the edit operation.
edit.stopOperation()

# Stop the edit session and save the changes
edit.stopEditing(True)

Re: Edit Versioned Feature Class in python

BrendanDwyer — Fri, 18 Jul 2014 19:28:13 GMT

Jake,

Thanks for responding. I ended up using the append tool instead.

The idea is that another department posts an excel file online and we want to update a feature class with the new data. We want to completely replace the existing records with the new data. So I am using the delete rows tool then the append tool instead of opening an edit session with a data access cursor.