Latest Contributions by AriLukas

I am helping our city Fire Department to conduct fire hydrant inspections. One of the inspection steps is to take several readings (static pressure, residual pressure and pilot pressure) from the hydrant to determine flow gallons per minute (GMP). Typically, they would take these readings and have to put them into a third-party program that then does the calculations to in the background to get GPM. I have an Arcade script that will allow the GPM to be determined in the field once the required numbers are input in the appropriate fields. I have run script in Pro with no problems. I wanted to add an attribute rule with a triggering event of 'Update' and  'Insert' so when they either go to an existing hydrant or add a new one and conduct a flow test the GPM will be calculated on the fly.  It runs as expected on existing hydrants. However, when I try to add a new hydrant I am receiving an error. Any guidance would be greatly appreciated! Please see error message, script and set up of geoprocessing tool below.  ERROR MESSAGE: ARCADE SCRIPT: var P = $feature.pilotpress var S = $feature.staticpress var R = $feature.respress var Q = 167.0625 * Sqrt(P); var RF = Q * Pow(((S - 20) / (S - R)), 0.54); return RF GEOPROCESSING TOOL SETUP:  ... View more

I want to start by saying I am fairly adept at reading Arcade language but not so much at writing it. To date I have only written simple scripts having to do with labels and such. When it comes to using Arcade for mathematical functions I know very little so I'm not sure if what I want to do is even possible.   I have put together a map to be used with Collector for ArcGIS for our city's Fire Department to conduct fire hydrant inspections. They gather 3 readings in the field (Static Pressure, Residual Pressure and Pitot Pressure) which they then add into a third-party software to determine Rated Flow at 20psi. Based on Rated Flow the hydrant is assigned a color: Red 0-499, Yellow 500-999, etc.. The Fire Department then sends me an excel spreadsheet of the hydrant number and its assigned color that I join to an existing hydrant layer in GIS using the hydrant number as the primary key. I then display the hydrants on the Hydrant map on our portal according to their assigned color. This process is time consuming for all parties involved and creates several weeks of lag before data is updated on our portal. I have included the formula and example that was sent to me below. The Fire Department would like, if possible, to have the Rated Flow calculated on the fly in the field and by proxy the appropriate color assigned. I am hoping someone might be able to tell me: a) Is this type of complex math even possible using Arcade language and b) how to go about constructing the formula Thanks for the help! The three things you should have listed are Static Pressure, Residual Pressure, and Pitot Pressure. With these three we will be able to determine what the hydrant will flow at 20psi residual pressure which is what we have to have for the state.   167.0625 x SR(P) = Q  SR( ) is Square Root  P is Pitot pressure Q is the amount of water flowed during the test in gallons per minute     Q x ( S - 20 / S - R ) ^ 0.54 = Rated Flow at 20psi S is the static pressure R is the Residual Pressure   and example a hydrant flow test with a Static pressure of 108psi with a residual pressure of 55psi  and a Pitot pressure of 40   167.0625 x SR(40) = 1,056.2 gallons per minute flowed 1056.2 x (108 - 20 / 108 - 55 ) ^ 0.54 = 1,388.86 round to the nearest whole number 1,389 gallons per minute is what it is rated for at 20psi ... View more