topic Re: ArcMap 10.4 Field Calculator Manhole Invert Lelels in Data Management Questions

ArcMap 10.4 Field Calculator Manhole Invert Lelels

MaksymKhovalko — Tue, 25 Apr 2017 23:03:19 GMT

Hi all,

This one should be an easy.

I have a table from Collector with recorded manhole Invert depths.

When I perform simple subtraction [LID_LEVEL] - [INV1_DEPTH] I get Invert Levels replicating Lid Levels if Invert Depth is zero. I want to return zero value in those cases.

Re: ArcMap 10.4 Field Calculator Manhole Invert Lelels

curtvprice — Tue, 25 Apr 2017 23:32:25 GMT

The easiest way to fix this (after the fact) is to take advantage of the fact that the Calculate Field tool only operates on selected records. Open the attribute table, select for all records where your invert depth is zero, and calculate your results field to zero.

You can also get fancier with Calculate Field with a code block (see the help), but it is easier to use selections.

Re: ArcMap 10.4 Field Calculator Manhole Invert Lelels

MaksymKhovalko — Tue, 25 Apr 2017 23:46:12 GMT

thanks, it did the job! I might need to automate this process with some code if I start getting more data.

if anyone can assist with that, it would be great!

Re: ArcMap 10.4 Field Calculator Manhole Invert Lelels

DanPatterson_Retired — Sat, 11 Dec 2021 22:37:21 GMT

You can still use the field calculator if you just have one condition to test.

I have substituted your field names with 'a' and 'b' in the example, then wrapped it up with them

I am sure you can follow along. The condition is on the right, the False, True slice is on the left

... [do this if False, do this if True][condition to check] .... is the syntax

a = 10
b = 11
[a - b, 0][a - b <=0.0]
0 # returns zero

# try a positive
a = 10
b = 9
[a - b, 0][a-b <=0.0]
1  # returns the difference

# now it looks horrible with your field names, but so what
# NOTE  use the Python parser... field names enclosed in !'s
#
[!LID_LEVEL! - !INV1_DEPTH!, 0][!LID_LEVEL! - !INV1_DEPTH! <=0.0]
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: ArcMap 10.4 Field Calculator Manhole Invert Lelels

curtvprice — Sat, 11 Dec 2021 22:37:24 GMT

Oh I get it. You are casting boolean expressions to integer in the context of a slice index, where True and False will cast to 1 and 0.

>>> int(True)
1
>>> int(False)
0
>>> a - b >= 0
False
>>> int(a - b >= 0)
0‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I guess I'd rather create the code block. Readability counts.

Calculate FIeld Expression

f(!LID_LEVEL! - !INV1_DEPTH!)
‍

Calculate Field Code block ("pre-logic script code")

def f(lev, dep):
    if lev > dep:
        val = lev - dep
    else:
        val = 0
    return val‍‍‍‍‍‍

Re: ArcMap 10.4 Field Calculator Manhole Invert Lelels

DanPatterson_Retired — Wed, 26 Apr 2017 04:07:44 GMT

If it is simple like a two case condition check for the field calculator, I like the direct solution.

With a code block you can make a mistake with the expression or the code block. like

f(!LID_LEVEL! - !INV1_DEPTH!) should be

f(!LID_LEVEL!, !INV1_DEPTH!)