I have an existing Excel spreadsheet developed to track specific fire hydrant data, this is periodically updated and joined to the spatial hydrant data in ArcGIS. In the spreadsheet there is a number of columns to enter data related to Static Pressure, Residual Pressure, and Flow Rate.
Utilizing the Rated Capacity at 20 PSI in a Fire Flow Test formula to calculate fire flow, the spreadsheet automatically calculates. The calculation is as follows.
Fire Flow = Flow * ((Static - 20)/(Static - Residual))^0.54
I am not sure the best way to attack this and am looking for suggestions. Based upon the results of the calculation, I have an additional column with an IF statement that indicates the appropriate fire flow color the hydrant should be painted. For those that do not know, the hydrant color is an indicator to fire personnel in an emergency the fire flow conditions. I hav e done some research and developed the following python script:
def Reclass !Bon_Color!: if ( !Fire_Flow! <= 0): return Black elif ( !Fire_Flow! >= 1 and !Fire_Flow! <= 499): return Red elif ([Fire_Flow] > 499 and [Fire_Flow] <= 999): return Orange elif ( !Fire_Flow! > 999 and !Fire_Flow! <= 1499): return Green elif ( !Fire_Flow! > 1499): return Blue end if
I would like to know if the calculations mentioned above, used in the Excel spreadsheet could be replicated in the database attribute table utilizing the field calculator and the python-parser? Rather than relying on the Excel spreadsheet and the need to rejoin the data.