Latest Contributions by VishalShah2

So I am currently working on a tool that the user needs to apply a query in order to the run the tool for the queried data. I am trying to get around that by creating a blank dictionary in the script and then appending data to it. The data comes from a field in a feature class. I have never done this before but in theory it should work the same as appending to lists correct? hubFeatures = r'hub_locations' hubDict = {}‍‍‍ These are my working variables for this. The field that I want the data from to append to the dictionary is called 'NAME' in the hubFeatures FC. I was thinking of using cursors to achieve this. Unless there is an alternative approach. The idea is to then use the items in the dictionary to apply a query to the necessary layers and complete the functionality of the tool using a for loop. That part I can do. Need some assistance in setting up the dictionary. ... View more

Hello, So I am first running a summary statistics to get the information I need and then the next step of the tool is to modify the table fields so I can get the field alias I want. This is done by creating new fields, doing calculations, etc. Here is my code: import arcpy import os import arcpy.mapping as map from arcpy import env import datetime arcpy.env.overwriteOutput = True fiberFeatures = r'sdm_Fiber Segments' date = datetime.date.today() reportsGDB = r'C:\Users\vshah\Desktop\Test Folder\test_output.gdb' reportsFolder = r'C:\Users\vshah\Desktop\Test Folder' inLayer = fiberFeatures outputName = 'fiber_summary' outLayer = reportsGDB + "/" + outputName statsFields = [["Feet", "SUM"], ["Miles", "SUM"]] caseFields = ["NetworkID", "ProjectID"] arcpy.Statistics_analysis(inLayer, outLayer, statsFields, caseFields) in_table = reportsGDB +"\\" + 'fiber_summary' deleteField = "FREQUENCY" fieldList = arcpy.ListFields(in_table) length = len(fieldList) - 2  ##subtracting 2 to account for the field being deleted when the modification is executed and to not count the Object ID field. arcpy.DeleteField_management(in_table, deleteField) alias_dict = {1: 'Network ID', 2: 'Project ID', 3: 'Total Feet', 4: 'Total Miles'} for i, field in enumerate(fieldList):     if field.type != 'OID' and i <= length:         newfield = '{}new'.format(field.name)         arcpy.AddField_management(in_table, newfield, field.type, field.precision,                                 field.scale, field.length, alias_dict[i], field.isNullable, field.required, field.domain)         arcpy.CalculateField_management(in_table, newfield, '!{}!'.format(field.name), "PYTHON_9.3")         arcpy.DeleteField_management(in_table, field.name)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ After this will be a simple export to excel sheet. However when I get to this portion of the script, I get ERROR 000539: Invalid field FREQUENCY even though it is being deleted before it gets to creating new fields. Any thoughts on how to solve this or any help you can offer? ... View more

Hello, So I am new to working with cursors and need a little help with my code as I am getting an AttributeError: __exit__ when i run my script. Here's what my code looks like: inTable = r'Layer\Fiber' routeMilesField = "RouteMiles" strandsField = "cableSize" milesField = "FiberMiles" fields = [strandsField, milesField, routeMilesField] with arcpy.UpdateCursor(fiberFeatures, fields) as cursor:     for row in cursor:         if None in row[:-1]:             arcpy.AddMessage("Insufficient Strand Data!")             break         else:             row[2] = row[0] * row[1]             cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Any help is greatly appreciated! Edit: Revised script based on this article: cursor - AttributeError: __exit__ when trying to use arcpy.UpdateCursor - Geographic Information Systems Stack Exchange  cursor = arcpy.UpdateCursor(fiberFeatures, fields) for row in cursor:     if None in row[:-1]:         arcpy.AddMessage("Insufficient Strand Data")         break     else:         row[2] = row[0] * row[1]         cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This returns a TypeError: 'Row' object has no attribute '__getitem__' error. I'm new to cursors and what not and definitely need help with this code. Edit 2: Solution based on Joshua's feedback: with arcpy.da.UpdateCursor(fiberFeatures, fields) as cursor:     for row in cursor:         if None in row[:-1]:             arcpy.AddError("Insufficient Strand Data!")             break         else:             row[2] = row[0] * row[1]             cursor.updateRow(row)‍‍‍‍‍‍‍‍ ... View more