I have a table of 6900+ attributes within a feature class. I want to use the values of these attributes, specifically the fields 'DIST_Port' and 'Num_trips'. I want to run through these and provide a 'Transit Time' for all the attributes in the table.
As you can see, in the code below I have tried using the 'SearchCursor' to read the values of these fields, but I'm not sure how to use this to cycle through and complete the calculation for each attribute.
The output of this will be used in another tool, how can I create an output from the script, to be seen as an output in the model builder?
I would use CalculateField to complete this, but as this same formula is used multiple times throughout my model, but with different 'Lspeed' and 'ULspeed', I feel creating multiple fields would cram up the attribute table.
Here is my code so far:
import arcpy import math # Collect 'Loaded_Speed' and 'Unloaded_Speed' Lspeed = arcpy.GetParameterAsText(0) ULspeed = arcpy.GetParameterAsText(1) # Set Workspace arcpy.env.workspace = 'C:/Users/bnd75769/Documents/ArcGIS/Projects'/MyProject/MyProject.gdb # Set Model Input Layer modelInput = "LCOE_Output" # Search Model Input for (Distance_to_Port and Number_Trips) Dist_Port = arcpy.SearchCursor(modelInput, ["Dist_Port"]) Num_Trips = arcpy.SearchCursor(modelInput, ["Num_Trips"]) # Transit Time Formula # rounded_up((DISTANCE_TO_PORT / LOADED_SPEED + DISTANCE_TO_PORT / UNLOADED_SPEED) * NUMBER_TRIPS / 24.0) TransitTime = math.ceil((Dist_Port / Lspeed) + (Dist_Port / ULspeed) * Num_Trips / 24.0) print(TransitTime)
I'm relatively new to arcpy and python so any help would be great.