topic Re: Convert Double to Integer (Arcade) in ArcGIS Pro Questions

Convert Double to Integer (Arcade)

Syvertson — Mon, 28 Sep 2020 16:03:54 GMT

I am trying to do something that is probably simple, but in reviewing the Arcade functions, I didn't find the one that will do this. I created a new field as an integer, and I now want to move contents of another field into it using calculate field. The other field is a double field type (even though all should be whole numbers).

Re: Convert Double to Integer (Arcade)

Robert_LeClair — Mon, 28 Sep 2020 16:16:40 GMT

Matthew - yes, you can do this with a simple Field Calculation using Arcade. In my graphic below, I have two fields Double (populated) and Integer (short integer type). I right clicked on the Int field, selected Calculate Field, and calculated the Integer field using $featue.Double (these are just my field names is all).

Hope this helps!

Re: Convert Double to Integer (Arcade)

Syvertson — Mon, 28 Sep 2020 17:56:24 GMT

OK.; This is exactly what I was trying to do. It must be something else going on. Here are some screen shots:

What I am trying to do:

Table structure:

Error messages:

Re: Convert Double to Integer (Arcade)

XanderBakker — Mon, 28 Sep 2020 19:12:52 GMT

Hi syvertson ,

The error is telling you that you can't write the value "14000002735000" from a double field (storable range -2.2E308 to 1.8E308) to a long field that will only be able to hold values in the range from -2,147,483,648 to 2,147,483,647.

Re: Convert Double to Integer (Arcade)

Syvertson — Mon, 28 Sep 2020 19:25:08 GMT

Thanks Xander. I understand now, but I would then need to find a different way to handle the problem I was trying to solve. For some reason when I am storing 50290115605026 in the double field, ArcGIS Pro is adding extra digits behind the decimal point. See below:

How do I tell the database that I need to store only whole numbers that are larger than a "long" integer?

Re: Convert Double to Integer (Arcade)

JoeBorgione — Mon, 28 Sep 2020 19:26:10 GMT

That's a problem for Parcels; our county uses a 14 character text string for them instead of making them numeric. Is there a specific reason you need them as a numeric? Double, long int, or otherwise?

Re: Convert Double to Integer (Arcade)

Syvertson — Mon, 28 Sep 2020 19:30:27 GMT

Yes. I have to be able to link to a database that uses this format, which is exactly the reason why it is a problem when you start adding digits behind the decimal point.

Re: Convert Double to Integer (Arcade)

XanderBakker — Mon, 28 Sep 2020 19:49:09 GMT

Hi Matthew Syvertson ,

What kind of link are you using to connect to the database? Maybe it is possible to correct the issue on the fly when linking to the other database.

I agree with jborgion that if is common to use text for this type of identifier if you can't store it in a long field and you will not apply any numeric calculations on it.

Re: Convert Double to Integer (Arcade)

Syvertson — Mon, 28 Sep 2020 20:03:38 GMT

The database is a sql database and the format of that filed is numeric 14 characters and no decimal. See below. Every table that is in this database uses the same format for parcel number. I never once had an issue with this in ArcMap. Even though I used double for the field type in the spatial databases, they always respected the format of no decimal point.

A better question that I have is "Why would the parcel dataset EVER need to add digits behind the decimal point?

Thanks for all of this help. I really do like the parcel fabric, and ArcGIS Pro, but I am always running into little "gotchas" like this that just cannot be explained.

Re: Convert Double to Integer (Arcade)

JoeBorgione — Mon, 28 Sep 2020 20:04:41 GMT

Take a look at ArcGIS field data types—ArcGIS Pro | Documentation . You might try adjusting the precision and/or scale for your PIN field, although that's just a WAG (wild a$$ guess) on my part.

Re: Convert Double to Integer (Arcade)

Syvertson — Mon, 28 Sep 2020 20:18:43 GMT

Thanks Joe. Can't find a way to update that in Pro. In ArcMap it is a snap. BUT, I can't alter the new parcel fabric in ArcMap, only in ArcGIS Pro. See what I mean about all the "gotchas."

Re: Convert Double to Integer (Arcade)

JoeBorgione — Mon, 28 Sep 2020 21:20:39 GMT

In ArcGIS Pro, right click on the feature class and choose fields. Find the field that has the PIN, and you'll see the word Numeric in the Number Format column. Click on the three dots and set 0 (zero) decimal places and then save it above. That just changes the display, not the underlying values.

Re: Convert Double to Integer (Arcade)

Syvertson — Mon, 28 Sep 2020 21:40:54 GMT

This doesn't help, because I am already able to display the values correctly, my problem is the storage of extra digits after the decimal.

Re: Convert Double to Integer (Arcade)

JoeBorgione — Mon, 28 Sep 2020 21:54:45 GMT

What's the underlying database?

Re: Convert Double to Integer (Arcade)

Syvertson — Mon, 28 Sep 2020 21:59:35 GMT

For now it is in a file based geodatabase, which is the only format that works for editing the new Parcel Database, aside from moving to enterprise, but when you do that you are forced to use editing through a feature service.

Re: Convert Double to Integer (Arcade)

JoeBorgione — Mon, 28 Sep 2020 22:19:13 GMT

I must be missing something here, so my apologies. I just added a double type field (PIN) to a feature class in a fgdb. I then entered this number:

43430000100000

to one of the records in that field. I'm not seeing any decimal values:

Re: Convert Double to Integer (Arcade)

JoeBorgione — Mon, 28 Sep 2020 22:37:54 GMT

How did the original sql data find it's way to the fgdb?

Re: Convert Double to Integer (Arcade)

Syvertson — Tue, 29 Sep 2020 13:29:10 GMT

It does not happen all the time. And I can't say exactly when it decides to rear it's head. Perhaps it is something that I do that I am unaware of, but the bottom line is that the values normally do work. It is only every so often that the extra decimals show up, and you cant see them when it is displayed normally. When you click on the value, it will show you then the extra decimals.

I am just going to close this out and realize this is just a "feature" that I will learn to deal with. If this ever becomes more problematic than it is, I will pursue further.

Thanks for attempting to help.

Re: Convert Double to Integer (Arcade)

JoshuaBixby — Tue, 29 Sep 2020 20:03:32 GMT

In SQL Server, NUMERIC is an exact numeric data type, i.e., fix precision and scale. ArcGIS doesn't natively implement a proper numeric/decimal data type. The ArcGIS "Double" data type is based on the .NET System.Double data type, which is an approximate numeric data type.

When working in databases or data formats that implement decimal/numeric, bigint, or money/currency data types; you can have an exact 14-digit number like 50290115605026. Unfortunately, that isn't a file geodatabase.

Re: Convert Double to Integer (Arcade)

JoshuaBixby — Wed, 30 Sep 2020 20:36:52 GMT

Matthew Syvertson‌, I do think there is something wrong with either a geoprocessing tool or the Pro application. I was able to insert 50290115605026.0 into a FGDB feature class using an Insert Cursor and it displays correctly in Pro:

How did you copy the data from the EGDB to FGDB?