The purpose of this script/tool would be that i can select one or two or 50 points at once and update just those selected points with the info in the rows = arcpy.UpdateCursor(APT). Then take those selected points and copy them to a different personal/filedatabase but with the info that was updated in the rows = arcpy.UpdateCursor(APT) and other fields. I have tried to implementing your suggestion on insert cursor and i have been able to create a point with insertcursor but it seems as the arcpy.da.UpdateCursor is still very slow. takes about 2-4 minutes to add one point to the backup data base. sometimes after testing and testing it takes 20 mins... weird The insertcursor is superfast it's the and arcpy.update cursor and arcpy.da.UpdateCursor that are super slow. Maybe i am not doing it the most efficient way...
apologies my code is a little mangled
import arcpy
from datetime import datetime as d
startTime = d.now()
#set to folder where features are located
arcpy.env.workspace = r"C:\CCAP_Copy_NEW.gdb" #on windows use \ instead of /
arcpy.env.overwriteOutput = True
FC = "test"
#---------------------------
#define variables for cursor
#---------------------------
rows = arcpy.SearchCursor(FC)
for row in rows:
geom = row.Shape
X = geom.centroid.X
Y = geom.centroid.Y
del rows
incidentsFC = "CCAP"
# Create point
inPoint = arcpy.PointGeometry(arcpy.Point(X,Y))
#Check to make sure user had at least one point is selected.
parcelsCount = int(arcpy.GetCount_management(FC).getOutput(0))
"""SEARCHCURSOR"""
stable = "test"
sfield = ["ACCOUNT","SiteNum","OwnerName","SiteAddres","SiteNumSfx","SiteStreet","Predir"]
#where clause will be written in SQL and not assigned to variable
"""UPDATECURSOR"""
utable = "CCAP"
ufield = ["ACCOUNT","SiteNum","OwnerName","SiteAddres","SiteNumSfx","SiteStreet","Predir"]
#where clause will be written in SQL and not assigned to variable
#Check to make sure user had at least one point is selected.
dsc = arcpy.Describe(FC)
dsc = arcpy.Describe(stable)
selection_set = dsc.FIDSet
if len(selection_set) == 0:
print "There are no features selected"
#--------------------------
#start the loop
#--------------------------
elif parcelsCount >= 1:
rows = arcpy.UpdateCursor(FC)
for row in rows:
row.FacltyType = ("Single Family Home")
row.StructType = ("Primary, Private")
row.Verified = ("Yes, GRM, TA")
row.Status = ("Active")
row.StructCat = ("Residential")
row.APA_CODE = ("1110")
rows.updateRow(row)
del row, rows
#arcpy.Append_management(APT, fc1, "NO_TEST")
# Create the insert cursor and a new empty row
rowInserter = arcpy.InsertCursor(incidentsFC)
newIncident = rowInserter.newRow()
# Populate attributes of new row
newIncident.SHAPE = inPoint
#newIncident.setValue(descriptionField, inDescription)
# Insert the new row into the shapefile
rowInserter.insertRow(newIncident)# Handle Exception
del rowInserter
with arcpy.da.SearchCursor(stable, sfield) as scursor:
for srow in scursor:
print srow
with arcpy.da.UpdateCursor(utable, ufield) as ucursor:
for urow in ucursor:
ucursor.updateRow(srow)
arcpy.RefreshActiveView()
try:
print '(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')'
except Exception, e:
# If an error occurred, print line number and error message
import traceback, sys
tb = sys.exc_info()[2]
print "Line %i" % tb.tb_lineno
print e.message
arcpy.da.UpdateCursor
rows = arcpy.SearchCursor(FC)
for row in rows:
geom = row.Shape
X = geom.centroid.X
Y = geom.centroid.Y
del rows
incidentsFC = "CCAP"
# Create point
inPoint = arcpy.PointGeometry(arcpy.Point(X,Y))
#Check to make sure user had at least one point is selected.
parcelsCount = int(arcpy.GetCount_management(FC).getOutput(0))
dsc = arcpy.Describe(FC)
selection_set = dsc.FIDSet
if len(selection_set) == 0:
print "There are no features selected"
elif parcelsCount >= 1:
rows = arcpy.UpdateCursor(FC)
for row in rows:
row.FacltyType = ("Single Family Home")
row.StructType = ("Primary, Private")
row.Verified = ("Yes, GRM, TA")
row.Status = ("Active")
row.StructCat = ("Residential")
row.APA_CODE = ("1110")
rows.updateRow(row)
#arcpy.Append_management(APT, fc1, "NO_TEST")
# Create the insert cursor and a new empty row
rowInserter = arcpy.InsertCursor(incidentsFC)
newIncident = rowInserter.newRow()
# Populate attributes of new row
newIncident.SHAPE = inPoint
#newIncident.setValue(descriptionField, inDescription)
# Insert the new row into the shapefile
rowInserter.insertRow(newIncident)# Handle Exception
#print "No features selected."
del rowInserter
with arcpy.da.SearchCursor(FC, ['ACCOUNT', 'SiteStreet']) as parcelCursor:
for parcelRow in parcelCursor:
ACCOUNT = parcelRow[0]
SiteStreet = parcelRow[1]
with arcpy.da.UpdateCursor(incidentsFC, ['Account', 'SiteStreet']) as addressCursor:
for addressRow in addressCursor:
addressRow[0] = ACCOUNT
addressRow[1] = SiteStreet
addressCursor.updateRow(addressRow)
