topic Re: Calculate Fields for Text values in ArcGIS Pro Questions

Calculate Fields for Text values

EuropaxEarth — Thu, 31 Aug 2023 13:49:50 GMT

Hello,

I'm curious to know if there is a workaround to using the 'Calculate Fields' tool for text values.

So far, I haven't been able to find any documentation confirming that this is possible in ArcGISPro.

Re: Calculate Fields for Text values

SarahRijneke — Thu, 31 Aug 2023 14:50:27 GMT

What exactly are you trying to do? attribute rules are handy if you're looking to automatically populate values when features are updated or created.

Re: Calculate Fields for Text values

AyanPalit — Thu, 31 Aug 2023 15:20:48 GMT

@EuropaxEarth Refer to:

Calculate Field using Python

Fundamentals of field calculations

Re: Calculate Fields for Text values

LakeCountyCOGIS — Thu, 31 Aug 2023 15:56:30 GMT

What's the text you're trying to populate?

Re: Calculate Fields for Text values

EuropaxEarth — Thu, 31 Aug 2023 18:42:47 GMT

I am trying to discern what parcels do and do not contain brownfields. There are two brownfield datasets that I am referencing.

There can be three outcomes:

* A parcel contains Brownfield Dataset A

*A Parcel contains Brownfield Dataset B

* A parcel contains BOTH Datasets.

For example, I use select by location to see what parcels contain Brownfield A. With that selection, I use calculate fields to say "Brownfields = A".

Then I go in and do select by location to see what parcels contain Brownfield B. Half of the parcels in that selection happen to also contain Brownfield A.

However, when I use calculate fields to have "Brownfields = B", it OVERWRITES, my previous calculations making me unable to display parcels that contain BOTH parcels A and B in my attribute table.

I attempted to use the code below to fill in all the "NULL" values with B, and then replace all the "A" parcels that also contain Brownfield B with "A and B".

if (Brownfields == NULL):
return ' "B" '
else:
return '"A and B"'

However, because my "Brownfields" field is a text data type, this script was unsuccessful.

Essentially, I would like to know how to overwrite previous calculations to display multiple values in within one cell.

Re: Calculate Fields for Text values

EuropaxEarth — Thu, 31 Aug 2023 18:50:25 GMT

Posted this above, but I'll recopy it here!

I am trying to discern what parcels do and do not contain brownfields. There are two brownfield datasets that I am referencing.

There can be three outcomes:

* A parcel contains Brownfield Dataset A

*A Parcel contains Brownfield Dataset B

* A parcel contains BOTH Datasets.

For example, I use select by location to see what parcels contain Brownfield A. With that selection, I use calculate fields to say "Brownfields = A".

Then I go in and do select by location to see what parcels contain Brownfield B. Half of the parcels in that selection happen to also contain Brownfield A.

However, when I use calculate fields to have "Brownfields = B", it OVERWRITES, my previous calculations making me unable to display parcels that contain BOTH parcels A and B in my attribute table.

I attempted to use the code below to fill in all the "NULL" values with B, and then replace all the "A" parcels that also contain Brownfield B with "A and B".

if (Brownfields == NULL):
return ' "B" '
else:
return '"A and B"'

However, because my "Brownfields" field is a text data type, this script was unsuccessful.

Essentially, I would like to know how to overwrite previous calculations to display multiple values in within one cell.

Re: Calculate Fields for Text values

SarahRijneke — Fri, 01 Sep 2023 13:57:04 GMT

I haven't tested it, but this might work assuming all of your data is in the same geodatabase. Open field calculator and switch the expression type to Arcade & copy/paste the following code. Make sure to change 'Brownfield A' and 'Brownfield B' to the names of the parcel feature layers in your map.