topic Re: How can I calculate area when I have multiple equations for many feature types? in ArcGIS Survey123 Questions

How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Mon, 11 Mar 2019 21:51:52 GMT

Hi All,

I have another formula to create, but I am new to Survey123 and am not sure how to get what I need on the survey. The project I am working on is sign inventory and the question I am having trouble with is with the area of each sign (200 different sign types). I will have the width and height of each of the sign, but the signs, being all different shapes, have different area formulas.

These are all the different formulas:

(Width * Height)/144 (The majority of the signs have this equation)

(SQUARE(Height/12)) * .76

((1 + (SQRT(2))) * 2) * (SQUARE((Width / 12)/2.4))

(Height * Height /333)

(Width * Width * .0052083)

(Width)/12

(Width * Height)/182.5

(Height * Height * .0042918)

I have this for an equation (${SignWidth}*(${SignHeight})div144) for the majority of the signs, but the more advanced equations I am clueless on. If you know how to write out some of these, that would be very helpful. I am not even sure which survey column I should be writing these in either (calculation, relevent, etc.?)

I think I am in need of a very intense, nested if statement, but maybe it needs to be broken up in some way. I've included what my data looks like for reference. Please help!

Re: How can I calculate area when I have multiple equations for many feature types?

Jim-Moore — Wed, 13 Mar 2019 01:47:48 GMT

Hi Kaitlyn

Your calculation for the majority of the signs is good, however you could drop the brackets around height, e.g. (${width} * ${height}) div 144.

You should be able to specify a different equation for each sign type with a nested if statement in the calculation column. Please see this handy information on using formulas in calculations, which lists the functions and operators you can use (including if statements): Formulas—Survey123 for ArcGIS | ArcGIS

For example:

(SQUARE(Height/12)) * .76 would be something like: pow((${height} div 12), 2) * 0.76
((1 + (SQRT(2))) * 2) * (SQUARE((Width / 12)/2.4)) would look something like: ((1 + sqrt(2)) * 2) * (pow((${width} div 12), 2) div 2.4)

Hope this helps.

Best regards,

Jim

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Mon, 25 Mar 2019 21:13:37 GMT

Thank you for your help! I ended up trying to use the pulldata function, but am having little luck. My data is not showing up and I am not sure what is wrong.

Re: How can I calculate area when I have multiple equations for many feature types?

Jim-Moore — Mon, 25 Mar 2019 22:51:05 GMT

Hi Kaitlyn, how are you using the pulldata function? Would it be possible to share your XLSForm and CSV so I can see how your survey is structured? Thanks, Jim

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Thu, 18 Apr 2019 18:02:47 GMT

Hi Jim,

I have ended up restructuring my survey so many times. I am using the pulldata function to pull what I can for width and height so I can calculate area. It's working well, but now I have run into needing a nested if statement will all my formulas. The syntax is killing me when I try to put them all together.

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Thu, 18 Apr 2019 18:07:15 GMT

On top of that, when I try to do a calculation with even one of my formulas, the area does not change if I alter the width and height in the survey. I'm not sure Survey123 is that dynamic.

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Mon, 22 Apr 2019 15:21:58 GMT

Would a nested if statement with two of your equations look something like this?

if(selected(${signtype},'R1-1 - Stop'),((1 + sqrt(2)) * 2) * (pow((${width} div 12), 2) div 2.4)), (${width} * ${height}) div 144

This equation is not working for me. I have never done any calculation this intense and have a lot of questions.

Re: How can I calculate area when I have multiple equations for many feature types?

DougBrowning — Mon, 22 Apr 2019 16:10:32 GMT

Missing the last )

if(selected(${signtype},'R1-1 - Stop'),((1 + sqrt(2)) * 2) * (pow((${width} div 12), 2) div 2.4)), (${width} * ${height}) div 144)

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Mon, 22 Apr 2019 16:17:38 GMT

Here is what I get without that last 😞

Here is the error with the extra 😞

Re: How can I calculate area when I have multiple equations for many feature types?

DougBrowning — Mon, 22 Apr 2019 16:30:52 GMT

Opps see an extra try

if(selected(${signtype},'R1-1 - Stop'),((1 + sqrt(2)) * 2) * (pow((${width} div 12), 2) div 2.4), (${width} * ${height}) div 144)

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Mon, 22 Apr 2019 16:48:31 GMT

Thanks Doug! That worked! How many of questions am I able to add into a nested if statement?

These are all the 8 formulas I have:

(Width * Height)/144 (The majority of the signs have this equation)

(SQUARE(Height/12)) * .76

((1 + (SQRT(2))) * 2) * (SQUARE((Width / 12)/2.4))

(Height * Height /333)

(Width * Width * .0052083)

(Width)/12

(Width * Height)/182.5

(Height * Height * .0042918)

What if I have multiple sign types for each equation (can I go by category in the same equation)? Should I put the equation with the most signs at the end of the equation?

Re: How can I calculate area when I have multiple equations for many feature types?

DougBrowning — Mon, 22 Apr 2019 17:14:21 GMT

As many as your brain can keep straight I think.

You could also maybe do one if per field then another field that just takes the value that is not 0.

So'

If (case 1, value, 0)

If (case 2, value, 0)

Then

Max(case 1, case 2)

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Mon, 22 Apr 2019 19:20:09 GMT

I'm not sure I know what you mean. Do you mean I should expand my survey by adding more notes with subsequent signArea labels?

Like this?

note signArea Sign Area: if(selected(${signtype},'R1-1 - Stop'),((1 + sqrt(2)) * 2) * (pow((${widthnote} div 12), 2) div 2.4), 0)

note signArea Sign Area: if(selected(${signtype},'M1-7 - NFS ROUTE MARKER' or 'M1-6 - County Route Sign (1 - 3 digits)'),pow((${heightnote} div 12), 2) * 0.76, 0)

note signArea Sign Area: if(selected(${signtype},'R1-2 - Yield 36x36' or 'R1-2 - Yield (Low Volume Roads)'),${heightnote} * ${heightnote} div 333, 0)

note signArea Sign Area: if(selected(${signtype},'S1-1 - School' or 'SS4-5 - School Speed 15 MPH Ahead (Symbol)'),${widthnote} * ${widthnote} * 0.0052083, 0)

note signArea Sign Area: if(selected(${signtype},'T3B - Type 3 Barricade'),${widthnote} div 12, 0)

note signArea Sign Area: if(selected(${signtype},'W10-1 - Grade Crossing Advance Warning'),(${widthnote} * ${heightnote}) div 182.5, 0)

note signArea Sign Area: if(selected(${signtype},'W14-3 - No Passing Zone (Pennant)'),${heightnote} * ${heightnote} * 0.0042918, 0)

note signArea Sign Area: Max((${widthnote} * ${heightnote}) div 144)

Is that anything close to what you are suggesting? Thanks for all your help.

Re: How can I calculate area when I have multiple equations for many feature types?

DougBrowning — Mon, 22 Apr 2019 19:27:41 GMT

Yea that is what I was thinking. Just makes it easier to write. Note if it is a select_one question you can do a = instead of selected(). Selected is more for select_multiple.

You could make them all Calculate fields so they are hidden to the user. (or use hidden). Can also bind to null then they will not show in the Feature Service.

Depending on your math that last one may be just Max((${widthnote} * ${heightnote}). Not sure about the div 144 because it will do that on all of them.

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Mon, 22 Apr 2019 20:18:13 GMT

It looks like I am having trouble with the "or" statements in my calculations and the "Max" line for the final calculation. Any idea why?

Also, it tells me I am missing a ")" when I get rid of "selected."

Ideas?

Re: How can I calculate area when I have multiple equations for many feature types?

DougBrowning — Mon, 22 Apr 2019 20:27:16 GMT

If you take out selected you must remove the ( and the ) wherever you used it. See below.

For the Or statements you must not be a programmer .

Cannot do this

if(selected(${signtype},'S1-1 - School' or 'SS4-5 - School Speed 15 MPH Ahead (Symbol)')

Must be a full compare for each Or.

if(selected(${signtype},'S1-1 - School') or selected( ${signtype},'SS4-5 - School Speed 15 MPH Ahead (Symbol)'))

Or if a select one it is cleaner to do

if(${signtype}='S1-1 - School' or ${signtype}='SS4-5 - School Speed 15 MPH Ahead (Symbol)',yes,no)

Also are your Names all of this - 'SS4-5 - School Speed 15 MPH Ahead (Symbol)' or is that just the Label? You need to compare with Name not label. I would not put all those special chars in my data. For sure you cannot have new lines or any commas in your lists!

Re: How can I calculate area when I have multiple equations for many feature types?

BenjaminHanzen — Mon, 22 Apr 2019 21:23:05 GMT

Hey Kaitlyn,

I hope things are going well for you!

I'm not sure I fully understand the question. Is there a criteria that is met in order to determine area calculation? I'm guessing if its octagonal such as your stop sign you use a certain equation correct?

Might I suggest you use the look up function where you define each sign with the equation so that it pulls that equation for that criteria. I wonder how you're setting up your pull data currently that you are still looking to use nested statements.

Survey123 for ArcGIS – XLSForm: Enabling CSV Data into your Survey - YouTube

Let me know if that helps. Nested if functions are exhausting.

Re: How can I calculate area when I have multiple equations for many feature types?

AbdoAbdelrasoul1 — Tue, 23 Apr 2019 13:36:06 GMT

I think first you need to identify scenarios for each equation to use, then come up with code for each scenario/equation e.g. 1, 2,3 for people to enter in the field/office, also you can add another field for exceptions, then query each code (may be with exception) to apply the right equation. Good luck, Abdo

Re: How can I calculate area when I have multiple equations for many feature types?

KaitlynAbrahamson — Tue, 23 Apr 2019 13:54:38 GMT

Hi Doug,

I think I am getting really close now. I am having trouble with the last statement though.

I think it is obvious by now that I have never been and am not now a programmer. Your suggestions really helped. Technically, the sign names are as long and horrible as you say. It is not the label. I could and probably should separate them and make them easier to work with, but I am scared to undo my work and potentially mess something up.

I'm not sure what to do for my last statement. All the sign areas are still 0, even when the sign is specified to use a different equation. I want all signs to use my final equation if they were not previously mentioned in the other sign area equations. This is my last statement:

if(${signtype}='R1-1 - Stop' or ${signtype}='T3B - Type 3 Barricade' or ${signtype}='W10-1 - Grade Crossing Advance Warning' or ${signtype}='W14-3 - No Passing Zone (Pennant)' or ${signtype}='S1-1 - School' or ${signtype}='SS4-5 - School Speed 15 MPH Ahead (Symbol)' or ${signtype}='M1-7 - NFS ROUTE MARKER' or ${signtype}='M1-6 - County Route Sign (1 - 3 digits)' or ${signtype}='R1-2 - Yield 36x36' or ${signtype}='R1-2 - Yield (Low Volume Roads)',0,(${widthnote} * ${heightnote}) div 144)

I basically just reversed the statement and included all the signs that use other equations, but I think that just defaults ALL the signs to use the last equation. I'm thinking I'm not going about it the right way.

Thanks for all your meticulous help.

Re: How can I calculate area when I have multiple equations for many feature types?

DougBrowning2 — Tue, 23 Apr 2019 14:12:12 GMT

Well if all the other options have not been picked then you know all your calcs are 0. So just check that instead.

If(max(calc1, calc2,calc3,calc4) =0, Do default calc,0)