I've attached a png of the processing times in the results window. Dissolve takes the most time, averaging 50 seconds. I've also modified the script below, to use in memory workspace, although I'm not sure if this is correct; never used it before and don't find much in Help files about using it.I'm only displaying three layers on my test runs, Parcels (~28k features), Case (0 features to start) and city boundary. Not all parcels are displayed, 28K is the total number of parcels; the map is typically zoomed in to areas of less than 100 parcels. Thanks, really appreciate the help.import arcpy, sys, time #, os
from arcpy import env
env.overwriteOutput = True
env.workspace = "IN-MEMORY"
#temp_lyr_location = r"\Cases_Geodatabase.gdb\temp_parcel_lyr"
parcel = r"Parcel"
try:
#lyr = os.getcwd() + temp_lyr_location
lyr = r"temp_parcel_lyr"
mxd = arcpy.mapping.MapDocument("CURRENT")
except Exception as e:
arcpy.AddError('ERROR initializing: /n' + e.message)
#-------------------------------------------------------------------------------
def MakeCaseFeature():
''' Dissolve selected parcel features into one temporary lyr file.
Append it to the Cases feature class.
Delete the temporary lyr file. '''
clear = "CLEAR_SELECTION"
target = "Cases"
schemaType = "NO_TEST"
fld = "CENTRACT" # no data is stored in this field
selectType = "HAVE_THEIR_CENTER_IN"
try:
# make temporary parcel lyr file from selected parcels, dissolving them
# into one feature
t0 = time.clock()
arcpy.Dissolve_management(parcel, lyr, fld)
arcpy.AddMessage("Elapsed time dissolving: {0} seconds".format(int(time.clock() - t0)))
# add case feature in temporary layer to Cases
t0 = time.clock()
arcpy.Append_management(lyr, target, schemaType, "", "")
arcpy.AddMessage("Elapsed time appending: {0} seconds".format(int(time.clock() - t0)))
# select new case feature
t0 = time.clock()
arcpy.SelectLayerByLocation_management(target, selectType, lyr)
arcpy.AddMessage("Elapsed timeselecting case layer: {0} seconds".format(int(time.clock() - t0)))
# delete temporary layer
#arcpy.Delete_management(lyr)
# clear selection on parcels
t0 = time.clock()
arcpy.SelectLayerByAttribute_management(parcel, clear)
arcpy.AddMessage("Elapsed time clearing parcel selection: {0} seconds".format(int(time.clock() - t0)))
except Exception as e:
arcpy.AddError("ERROR in MakeCaseFeature: \n" + e.message)
#-------------------------------------------------------------------------------
def main():
''' Check how many parcels are selected. Count returns all parcels if none are
selected, or only selected ones if there are any.
'''
try:
t0 = time.clock()
count = int(arcpy.GetCount_management(parcel).getOutput(0))
arcpy.AddMessage(str(count) + " parcels selected")
arcpy.AddMessage("Elapsed time counting parcels: {0} seconds".format(int(time.clock() - t0)))
# make sure parcels are selected before running rest of script, otherwise exit
if count >= 0 and count <= 10:
MakeCaseFeature() # create the case feature
t0 = time.clock()
arcpy.RefreshActiveView()
arcpy.RefreshTOC()
arcpy.AddMessage("Elapsed time refreshing view: {0} seconds".format(int(time.clock() - t0)))
else:
arcpy.AddError("No features selected! \n Please select at least one parcel feature. \n")
arcpy.AddError("Quitting the Create Case tool \n")
except Exception as e:
arcpy.AddError('ERROR in main: /n' + e.message)
