Latest Contributions by ChrisHolmes

Hello, I have the following script. It works as expected, but it takes around 1.5 seconds to run each time. Doesn't seem to matter if it's running against 20 parcels or 5000. Are there any suggestions as to how I can improve the performance of this script. Thanks import arcpy import numpy as np try:     arcpy.env.overwriteOutput = True     #Create in memory tables:     arcpy.CreateTable_management("in_memory", "tableSelRecs")     arcpy.AddField_management(r'in_memory\tableSelRecs', "USE_CATEGORY", "TEXT", field_length=35)     arcpy.AddField_management(r'in_memory\tableSelRecs', "SHAPE_Area", "Double")     arcpy.CreateTable_management("in_memory", "tableSumRecs")     arcpy.AddField_management(r'in_memory\tableSumRecs', "USE_CATEGORY", "TEXT", field_length=35)     arcpy.AddField_management(r'in_memory\tableSumRecs', "SHAPE_Area", "Double")     mxd = arcpy.mapping.MapDocument('CURRENT')     df = mxd.activeDataFrame     totalArea = 0     totalResArea = 0     totalParcels = 0     totalResParcels = 0     lu_layer = arcpy.mapping.ListLayers(mxd, "LandUse_UseCategory", df)[0]     #use da.SearchCursor to access necessary fields from selected records     with arcpy.da.SearchCursor(lu_layer,['USE_CATEGORY','SHAPE@AREA']) as cursor:         #Setup insert cursor to insert selected polygons into tableSelRecs         insCursor = arcpy.da.InsertCursor(r'in_memory\tableSelRecs', ['USE_CATEGORY','SHAPE_Area'])         #Isert selected rows into insCursor;         #Get total area of selected records;         #Get a count of total parcels         for row in cursor:             if row[0] != 'Invalid':                 insCursor.insertRow((row[0],row[1]))                 totalArea += row[1]                 totalParcels += 1             #If the block is of a 'Residential' USE_CATEGORY type then add that value into the Residential DI calculation variable             if row[0] in('Residential - Low Density','Residential - Medium Density','Residential - High Density'):                 totalResArea += row[1]                 totalResParcels += 1         #use summarystatistics against tableSelRecs to get totals per USE_CATEGORY and write results to tableSumRecs         arcpy.Statistics_analysis(r'in_memory\tableSelRecs', r'in_memory\tableSumRecs', [["SHAPE_Area", "SUM"]], "USE_CATEGORY")     with arcpy.da.SearchCursor(r'in_memory\tableSumRecs',['USE_CATEGORY','SUM_SHAPE_Area']) as selCur:         #list to store calculation for each USE_CATEGORY value used in DI calculation         interimValue = [0]         #list to store calculation for each USE_CATEGORY value used in RDI calculation         interimResValue = [0]         for sRow in selCur:             arcpy.AddMessage('USE_CATEGORY: {}; AREA: {}'.format(sRow[0],sRow[1]))             #divide the USE_CATEGORY area by the total community area then square that number & append it to the list             interimValue.append(np.square(sRow[1]/totalArea))             if sRow[0] in('Residential - Low Density','Residential - Medium Density','Residential - High Density'):                 interimResValue.append(np.square(sRow[1]/totalResArea))         #sum the values in the list then subtract that value from 1 to get the DI for the selected blocks         DI = 1 - sum(interimValue)         #sum the values in the list then subtract that value from 1 to get the RDI for the selected blocks         RDI = 1 - sum(interimResValue)                 arcpy.AddMessage('Diversity Index: ' + str(DI))         arcpy.AddMessage('Residential Diversity Index: ' + str(RDI))         arcpy.AddMessage('Total Blocks Selected: ' + str(totalParcels))         arcpy.AddMessage('Total Blocks Area: ' + str(totalArea))         arcpy.AddMessage('Total Res Blocks Selected: ' + str(totalResParcels))         arcpy.AddMessage('Total Res Blocks Area: ' + str(totalResArea))         arcpy.AddMessage('NOTE: Any blocks with a use category of Invalid are not included in any calculations.')     #Delete in memory tables     arcpy.Delete_management(r'in_memory\tableSelRecs')     arcpy.Delete_management(r'in_memory\tableSumRecs') except arcpy.ExecuteError:     print(arcpy.GetMessages(2)) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Hello everyone, I have some data that looks like the attached pic. There's got to be an easy way to get a total area for each USE_CATEGORY and put the totals into a list or dictionary. Not sure if I need to maintain which total relates to which USE_CATEGORY. I don't need it for the current calculation I want to do, but may be worthwhile if I want to write it out to some external format later. Thanks for any help/pointers. ... View more

Hello, I have some code that I want to execute when an mdx file opens/closes. I'm trying to do it through an application extension because I also have a python addin which will be used with these files, so figure it makes sense to use the extension also. Before even trying to get my code working in the extension I just want to simply present a message via python addin messagebox and/or writing a message to the python window in arcmap. And basically this isn't working. Here is the code I'm trying on open/close: class MXDWatcher(object): """Implementation for PlanningTools_addin.mxdwatcher (Extension)""" def __init__(self):     # For performance considerations, please remove all unused methods in this class.     self.enabled = True def openDocument(self):     #pass     print('open doc')     pythonaddins.MessageBox('open doc','title',0) def closeDocument(self):     #pass     print('close doc')     pythonaddins.MessageBox('close doc','title',0)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ‍‍‍‍‍‍‍‍‍‍‍‍‍ Something else I notice in the Python Add-In Wizard, the "Methods to Implement" do not stay checked after I "Save" and close the Python Add-In Wizard. I'm assuming this is fine and that the methods I check are only referenced once when the wizard saves and creates those code blocks in the .py file. Any ideas on what I've got wrong here appreciated. Thanks, Chris ... View more

Hello everyone, I have a feature class which looks like this: What I need to do is loop through each group of records in the NAME field where the value is the same (these are community names) and perform a calculation which is based on the Area values for each USE_CATEGORY and the Sum of all USE_CATEGORY Area values (which will give us the total area for the community). I think the following excel snapshot outlines the calculation to be done against each community (NAME): The end goal is to create a new table that will show the community along with the calculated diversity index for that community: I'm thinking some sort of loop would be used to select the records for each community, but I'm not sure of the best way to go about that and also how do you move on to select the records for the next community. Looking for some guidance and ideas on how to best get this done. Thanks everyone, Chris ... View more