topic Re: How do I check an Arcade variable to see if it is numeric? in ArcGIS Pro Questions

How do I check an Arcade variable to see if it is numeric?

Syvertson — Fri, 23 Feb 2018 23:03:47 GMT

I am working on a complex label in ArcGIS Pro, and trying to learn arcade in the process. The process breaks aparttwo address fields and extracts the first part so I can use this as the "House Number." Then I make a label using the two "house numbers." In some cases, they put something other than a standard address in the field, so after parsing, a few would give me a word instead of a number. In other programing languages the "IsNumeric" (or similar) function will give me a boolean result so then I can test it. How do I do that in Arcade? I want all non-numeric to be converted to an empty string.

I will post the code here, but please be kind because I am no professional coder by any stretch of the imagination, especially not in Arcade.

var x = $feature['RC_GIS.dbo.ALL_PARCEL_DATA.Street_Address'];
var y = $feature['RC_GIS.dbo.ALL_PARCEL_DATA.paddress2'];
var x1 = split(x,' ')[0];
var y1 = split(y,' ')[0];
var label;

if(x1 == '0')
{x1 = '';}
if(y1 == '0')
{y1 == '';}
if (x1 == y1)
{
label = x1;
}
else
{
if (x1 == '')
{
label = y1;
}
else
{
if (y1 == '')
{
label = x1;
}
else
{
label = concatenate([x1,y1],"-");
}
}
}
return label;

Thanks in advance for any advise you might have.

Re: How do I check an Arcade variable to see if it is numeric?

DanPatterson_Retired — Fri, 23 Feb 2018 23:18:00 GMT

typeof? https://developers.arcgis.com/arcade/function-reference/data_functions/#typeof

Re: How do I check an Arcade variable to see if it is numeric?

Syvertson — Mon, 26 Feb 2018 16:15:42 GMT

I think I may have asked the problem wrong, because what you gave me is a very good answer for what I asked, but not what I needed.

My first step parses the addresses into an array of the "words" in the string. I take the first item in the array and assign it to a "house number" variable (x1). (of course it is still a string, but hopefully a numeric string) I tried using if(typeof(x1) == 'String') to test for non-numeric and replace with an empty string, and it actually eliminated all the results.

My next idea was to use Numeric(x1), which did actually convert all of the appropriate numeric responses to a number, but the non-numeric ones have a "NaN" value for "not a number." Since I don't want NaN on the label, andI need to find a way to test for "NaN" and replace with the empty string. So far I have not found that one test.

Latest version of this code:

var x = $feature['RC_GIS.dbo.ALL_PARCEL_DATA.Street_Address'];
var y = $feature['RC_GIS.dbo.ALL_PARCEL_DATA.paddress2'];
var x1 = Number(split(x,' ')[0]);
var y1 = Number(split(y,' ')[0]);
var label;

if(ABS(x1) == 0)
{x1 = NULL;}

if(ABS(y1) == 0)
{y1 = NULL;}

if (x1 == y1)
{
label = x1;
}
else
{
if (x1 == NULL)
{
label = y1;
}
else
{
if (y1 == NULL)
{
label = x1;
}
else
{
label = concatenate([x1,y1],"-");
}
}
}

return label;

Result is below: Everything looks fine, except the "NaN".

Re: How do I check an Arcade variable to see if it is numeric?

Syvertson — Mon, 26 Feb 2018 16:54:08 GMT

Solved this! Just so others know if the have same problem, I had to change back to text, and at that point the NaN became a string 'NaN' that I could test for. See below:

var x1 = Number(split(x,' ')[0]);
var y1 = Number(split(y,' ')[0]);

x1 = Text(x1);
if(x1 == '0' || x1 == 'NaN')
{x1 = NULL;}

y1 = Text(y1);
if(y1 == '0' || y1 == 'NaN')
{y1 = NULL;}

Re: How do I check an Arcade variable to see if it is numeric?

Syvertson — Mon, 26 Feb 2018 17:09:41 GMT

Now that this is solved and I have learned a little bit about "Arcade" and how to use it in labeling, I need to ask the follow on question. What are the reasons someone should use Arcade rather than VB Script, Javascript or Python? There must have been a gap that needed to be filled in order for this newer language to be applied here...????

Re: How do I check an Arcade variable to see if it is numeric?

KoryKramer — Thu, 01 Mar 2018 23:32:05 GMT

Arcade works across the ArcGIS platform. So if you're using it in a labeling expression or to control rendering (or in popups, etc. etc.) whatever you see in ArcGIS Pro will be rendered and displayed the same through services in a web browser or app. That's the underlying idea.

Re: How do I check an Arcade variable to see if it is numeric?

Syvertson — Fri, 02 Mar 2018 14:57:30 GMT

Thanks. It seems funny you say this, because I read this right after trying to find a way to use this arcade code in ArcGIS Desktop. And there appears to be no way. But if had been written in javascript I could have ported it over. They seem to be already abandoning that platform, without having the Pro platform ready for "primetime."

Re: How do I check an Arcade variable to see if it is numeric?

XanderBakker — Fri, 02 Mar 2018 18:32:20 GMT

The Arcade page ArcGIS Arcade | ArcGIS for Developers mentions this text, like Kory Kramer already mentioned:

Arcade is an expression language that can be used across the ArcGIS Platform. Whether writing simple scripts to control how features are rendered, or expressions to control label text, Arcade provides a simple scripting syntax to deliver these capabilities.
Arcade scripts are portable. This means that scripts you author in ArcGIS Pro can be read and executed in a WebMap through a browser, or in a Mobile Application

Every change can be difficult, and with the Web GIS pattern there is the need to adapt the platform to enable it to grow and expand its capabilities. None of the existing scripting languages was able to grow like that. In the mean time we will be in a transition phase where Arcade will grow and will be able to do more each time and where other scripting languages would not be able to grow at the same rate due to restrictions they have.

The same is happening with Desktop. Many innovations will not be implemented in ArcMap and will only be available in ArcGIS Pro, because ArcGIS Pro is the feature. A huge example is the Utility Network Management extension. The capabilities are not available in ArcMap, but they are in Web, Pro and mobile. A new feature introduced are the new attribute rules. Those will be configured using Arcade expressions. Many enhancements will come to Arcade and Arcade serves a different purpose then for instance Python. Give it some time and i will prove its benefits over other language.

Re: How do I check an Arcade variable to see if it is numeric?

KoryKramer — Fri, 02 Mar 2018 19:09:06 GMT

Thoughtful response, Xander! Matthew Syvertson In a nutshell, the transition from ArcMap to ArcGIS Pro is a dial, not a switch. While ArcMap will continue to be supported for many years, new functionality is being developed in ArcGIS Pro. Arcade is new functionality. Depending on specific workflows, some customers will be on the ArcMap side of the dial longer than other customers. Some may be at level 5 (of 10), doing certain things in ArcMap and carrying out different, complete workflows using ArcGIS Pro. And then there are others who are already clamoring for the dial to go to 11, or 12...

Re: How do I check an Arcade variable to see if it is numeric?

Syvertson — Fri, 02 Mar 2018 19:40:37 GMT

I understand all that, but there is KEY functionality that is left out that I keep running into. For instance. The attribute assistant. It worked fantastic in ArcGIS Desktop. Now I have to figure out how to use the new Attribute Rules (which has only a limited subset of capabilities) and when I attempt to make some of the simple rules, it errors. See the screenshot below:

Notice that the green "expression is valid" displays after I validate. But also notice the red failure notification. The reason for the failure is an invalid expression. HUH?

Oh, and also if I add these rules to a feature class they become no longer usable in ArcGIS Desktop. That is just nuts... Why not find a way for "Arcade" to use the dynamic value table that was already created in our databases since they are building the language???

I keep trying to make Pro work, but keep running into road blocks. And I am a very computer savvy person, I can't imagine being the casual GIS user and having to try to navigate these obstacles.

Re: How do I check an Arcade variable to see if it is numeric?

XanderBakker — Sun, 04 Mar 2018 02:58:03 GMT

I'm sorry to hear that you run into problems using the attribute rules. This is the first version in which attribute rules are available and as you pointed out it is currently not capable of replacing all the functionality the attribute assistent is offering for ArcMap. However, in coming versions more and more functionality will be included and it will eventually go further than what the attribute assistent if capable of doing. I would advice you to log the problems you encounter with Esri support, to make sure those get resolved.

Re: How do I check an Arcade variable to see if it is numeric?

MarcoBoeringa — Sun, 04 Mar 2018 10:46:48 GMT

Are you sure the:

Timestamp()

function returns the appropriate data type for the field you are trying to calculate? I can imagine a situation where the actual syntax of the expression is valid, but the returned data type not, and maybe causing issues when adding or truly executing the attribute rule. E.g. if your field to calculate is of type text instead of date, it might cause an issue. Timestamp() returns a true date (Date Functions | ArcGIS for Developers )

This is just a wild guess though, I don't have experience with the new attribute rules functionality.

Re: How do I check an Arcade variable to see if it is numeric?

XanderBakker — Sun, 04 Mar 2018 15:09:46 GMT

There is a related thread here: Can an arcade attribute rule update a date field? My guess is that some functionality related to dates and attribute rules may need some adjustments.

Re: How do I check an Arcade variable to see if it is numeric?

Syvertson — Mon, 05 Mar 2018 14:59:11 GMT

Thanks Marco. I did attempt "Text(Timestamp())" as well. Here is the attribute information:

Re: How do I check an Arcade variable to see if it is numeric?

Syvertson — Mon, 05 Mar 2018 15:04:46 GMT

OK. Thanks again Xander. And that makes the point I am making, that Key functionality is missing.

When every workflow I attempt to replicate in Pro ends up in disappointment over "not quite ready" technology, it is frustrating -- Especially when all I hear is that it is time we should be migrating that way. I wouldn't be frustrated if I just ignored and stayed on ArcMap, but I am usually an early adopter of technology. I keep making these attempts and investing time into a project and then find out I need to just go back for now. I really do want this to work out, because the things that do work are really cool.

Re: How do I check an Arcade variable to see if it is numeric?

KoryKramer — Mon, 05 Mar 2018 15:06:13 GMT

Matthew, I apologize that you're experiencing issues in starting to work with attribute rules. It looks like this specific issue that you've noted has been logged in our technical support system as BUG-000112098 - ERROR 000358: Invalid expression when applying an Arcade date function to a date field thru Attribute Rules

If you are interested in being attached to the bug, please open a case with support and request to be attached.

Thank you.