nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

KaitlynAbrahamson

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!

Find more posts tagged with

Accepted answers

All comments

Jim Moore

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

KaitlynAbrahamson

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.

Jim Moore

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

KaitlynAbrahamson

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.

KaitlynAbrahamson

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.

KaitlynAbrahamson

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.

dougbrowning

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)

KaitlynAbrahamson

Here is what I get without that last 😞

Here is the error with the extra 😞

BenjaminHanzen

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.

AbdoAbdelrasoul1

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.