topic Re: Arcade 'When' statement and empty fields in ArcGIS Online Questions

Arcade 'When' statement and empty fields

JayHodny — Tue, 18 Feb 2020 22:22:27 GMT

Hi. I am working with the January 22, 2020 FEMA data release for my area. I am using the Flood Inquiry web map and app solution. I am new to Arcade. I am trying to create an expression using the 'When' function to provide some descriptive text in the web map and application pop-up. All works well except when I have no value in a record in the ZONE_SUBTY field. How do I have the text written in the pop-up for empty fields? Below is the current Arcade expression. The string in italics is the troublemaker. Thanks in advance, Jay

var zonesubtype = $feature.ZONE_SUBTY;
When (zonesubtype == 'FLOODWAY','Floodway designation of AE',zonesubtype == '','AE - An area inundated by 1% annual chance flooding for which BFEs have been determined',zonesubtype == '0.2 PCT ANNUAL CHANCE FLOOD HAZARD','X - An area determined be 0.2% annual chance flood hazard',zonesubtype == 'AREA OF MINIMAL FLOOD HAZARD','X - An area of minimal flood hazard','')

Re: Arcade 'When' statement and empty fields

XanderBakker — Sun, 12 Dec 2021 07:23:29 GMT

Hi jhodny@Newark.de.us_CityOfNewarkDE ,

Perhaps this would work:

var zonesubtype = $feature.ZONE_SUBTY;
When (IsEmpty(zonesubtype), 'Specify what to return here...',
      zonesubtype == 'FLOODWAY','Floodway designation of AE',
      zonesubtype == '','AE - An area inundated by 1% annual chance flooding for which BFEs have been determined',
      zonesubtype == '0.2 PCT ANNUAL CHANCE FLOOD HAZARD','X - An area determined be 0.2% annual chance flood hazard',
      zonesubtype == 'AREA OF MINIMAL FLOOD HAZARD','X - An area of minimal flood hazard',
      '')‍‍‍‍‍‍‍

Re: Arcade 'When' statement and empty fields

JayHodny — Wed, 19 Feb 2020 02:16:26 GMT

Hi Xander,

I was close, as I was trying to use the ‘IsEmpty” function before my initial GeoNet post. Here is what I am using now, but still no luck. The ‘AE’ text string is still not showing in the pop-up. Thank you for your help.

var zonesubtype = $feature.ZONE_SUBTY;

When (IsEmpty(zonesubtype), 'AE - An area inundated by 1% annual chance flooding for which BFEs have been determined',

zonesubtype == 'FLOODWAY','Floodway designation of AE',

zonesubtype == '0.2 PCT ANNUAL CHANCE FLOOD HAZARD','X - An area determined be 0.2% annual chance flood hazard',

zonesubtype == 'AREA OF MINIMAL FLOOD HAZARD','X - An area of minimal flood hazard', '')

Re: Arcade 'When' statement and empty fields

XanderBakker — Wed, 19 Feb 2020 14:57:23 GMT

Hi Jay Hodny ,

Are you sure the field is null (empty) or does the field perhaps contains an single space or something not easy to detect? IsEmpty will correctly detect null values and empty strings, but not cases where you have a single string.

Re: Arcade 'When' statement and empty fields

JayHodny — Wed, 19 Feb 2020 16:11:04 GMT

Hi Xander,

I was beginning to suspect this may be a cause. I tried replacing the empty field records with (calculate field) but accidently messed up my feature class field. I have no restored the feature class and will proceed with more caution!

Thanks for your help,

Jay