Latest Contributions by BlakeTerhune

I got this code as a solution to the post import arcpy import openpyxl as px def main(): wb = px.load_workbook(r"C:\Users\Hp\Desktop\Ejemplo\VINCULACION_S.xlsm", read_only=False, keep_vba=True) ws = wb['VINCULACION_SH_NUE'] in_features = r"C:\Users\Hp\Desktop\Ejemplo\VH_Dissolve.shp" row_num = 3 with arcpy.da.SearchCursor( in_features, ["COLOR", "INTERNO_DE", "CLASE_DEMA", "COUNT_AREA", "SUM_AREA", "SUM_LENGTH"], ) as cursor: for row in cursor: ws.cell(row=row_num, column=2).value = row[0] ws.cell(row=row_num, column=3).value = row[1] ws.cell(row=row_num, column=4).value = row[2] ws.cell(row=row_num, column=6).value = row[3] ws.cell(row=row_num, column=7).value = row[4] ws.cell(row=row_num, column=8).value = row[5] row_num += 1 wb.save(r"C:\Users\Hp\Desktop\Ejemplo\VINCULACION_S.xlsm") ... View more

OK I posted my solution on another post... I think you all for your thoughts....it got me through this one.... I used a Select instead and then used those results to update the polygon with counts https://community.esri.com/t5/arcgis-api-for-javascript/count-points-in-polygon-and-symbolize-on-number-of-occurrences/td-p/1059845/page/2#M73258   ... View more

First off THANK YOU ALL FOR YOUR THOUGHTS AND COMMENTS They really helped steer me in the path and direction I took... OK this is what I did and its working.... Create a List of Unique types in the point Feature Class Call Function that reads this List by looping though that created unique list Each loop takes those unique value and calls another function that gets the correct field name and for that TYPE It then passes the (expression, type name and field name) to the last function which processes the data In the last function I am selecting the point records that match that TYPE value, I then create a new Point  Layer that has only those records.  I use that New Layer to Spatial Join, Statistics Analysis, Join Field Management, Calculate Field Management to Update the Polygon Layer with the number of occurrences for that TYPE in the Correct Field name that was set in the If Then Else I used the If Then to change the TYPE value in the Data to a value that would work as a field name...so I can update the Polygon Layer as some of the TYPE values were really long     import arcpy arcpy.env.workspace = r"E:/xxxxx/xxxx/Projects/xxx/xxx.sde" Points = r"E:/xxxxx/xxxx/Projects/xxx/xxx.sde/Locations" Grids = r"E:/xxxxx/xxxx/Projects/xxx/xxx.sde/Grids" print "Started" bList = [] expression = "" expressionValue = "" type= "" rowCount = 0 uniquetypeList = [] countList = [] txt_list = "" # COUNT NUMBER OF RECORDS FOR EACH TYPE def getFieldName(type): if type == "Needs Repair": return "NeedsRepair" elif type == "Broken": return "Broken" elif type == "Needs Replacement": return "NeedsReplacement" elif type == "Schedule Fix": return "ScheduleFix" else: return "nothing" def processTypeUpdate(expressionValue, typeValues, fieldName): expressionValue2 = expressionValue typeName = typeValues fieldUpdateName = fieldName rowCount = 0 arcpy.Delete_management('in_memory/PointsInPolys') arcpy.Delete_management('in_memory/SS_PointsInPolys') arcpy.Delete_management('points_lyr') arcpy.Delete_management('points_lyr2') arcpy.MakeFeatureLayer_management(r'E:/xxxxx/xxxx/Projects/xxx/xxx.sde/Locations_Test', 'points_lyr') results = arcpy.SelectLayerByAttribute_management ('points_lyr', 'NEW_SELECTION', expressionValue2) arcpy.MakeFeatureLayer_management(results, 'points_lyr2') polygonID = "ID" ## unique polygon field name countField = fieldUpdateName # The field name in the Grids FC to update expression = "recalc(!FREQUENCY!)" codeblock = """def recalc(freq): if freq > -1: return freq else: return 0""" arcpy.SpatialJoin_analysis('points_lyr2', Grids, "in_memory/PointsInPolys") ### case field returns count per unique UID arcpy.Statistics_analysis ("in_memory/PointsInPolys", "in_memory/SS_PointsInPolys", [[polygonID, "Count"]], polygonID) arcpy.JoinField_management(Grids, polygonID, "in_memory/SS_PointsInPolys", polygonID, "FREQUENCY") arcpy.CalculateField_management(Grids, countField, expression, "PYTHON", codeblock) arcpy.DeleteField_management(Grids, "FREQUENCY") # GET THE CODES FROM THE RESULTS OF THE SELECTION rows = arcpy.SearchCursor('points_lyr2',"","","type_name") for row in rows: rowCount = rowCount + 1 typeVal = str(row.type_name) countList.append(typeVal) txt_list = ','.join(countList) print "number of " + typeVal + " : " + str(rowCount) arcpy.Delete_management('in_memory/PointsInPolys') arcpy.Delete_management('in_memory/SS_PointsInPolys') arcpy.Delete_management('points_lyr') arcpy.Delete_management('points_lyr2') # TAKE TYPE NAME AND GET THE CORRECT FIELD NAME def processtypeNames(expressionValue, typeValues): type= str(typeValues) expressionValue2 = "type_name = '{}'".format(type) # GET THE CORRECT FIELD NAME fieldName = getFieldName(type) if fieldName == "nothing": print "No Value" else: # Call the function to actually update the Field Values uniques2 = processtypeUpdate(expressionValue2, type, fieldName) print "corrected field name is: " + fieldName def uniquetypeList(uniquetypeValues): typeList = uniquetypeValues #print typeList for type in typeList: #print type expressionValue = "type_name = '{}'".format(type) uniques = processtypeNames(expressionValue, type) # GET UNIQUE TYPS FROM FC CREATE LIST for feature in arcpy.ListFeatureClasses(): #print feature with arcpy.da.SearchCursor(Points,"type_name", sql_clause=(None,'ORDER BY type_name ASC')) as SCur: for row in SCur: if not row[0] in bList: # if not in list then add to list bList.append(row[0]) type = row[0] del SCur uniquetype = uniquetypeList(bList)       ... View more

Ok, so according to this question Why would a python script run fine from within ArcMap but not as a geoprocessing service?  I need to do the following: arcpy.env.workspace = os.path.dirname(r"//[servername]/connections/dbconnection.sde") This call cuts off the dbconnection.sde part of the path. Not sure why this fixes the problem, but I'm now onto a different error in a different part of the code, so that's one step further than I was before. ... View more