topic Re: Concatenate Attributes While Exporting Table - Model Builder in ArcGIS Pro Questions

Concatenate Attributes While Exporting Table - Model Builder

JessicaJThompson — Wed, 28 Apr 2021 16:38:29 GMT

Hello All, (ArcGIS Pro 10.7.2)

I am trying to automate a process that is a fairly simple, but always a last minute request.

The Request is for the Zoning department that has to send notifications to property owners of properties within 300ft of a parcel requesting a zoning amendment (so they in theory have time for input on the amendment). They want a table with the resulting parcels, and all of the mailing address fields concatenated. These fields are currently:

Steps Taken Which I have built in Model Builder

-Select by attributes

-Select by location (add to current selection)

-Summarize Data (exporting selected fields to table)

This provides me with a table of only the fields they want, but the mailing address fields are not concatenated.

This process gets repeated for several parcels. I am hoping to simplify this so it that someone who doesn't use Pro or really know how to use excel, can input 1 parcel # and receive the formatted spreadsheet as they need. (Also, was thinking of building this process in WebApp Builder but couldn't see a streamlined way - any ideas on that would be even better! Then they don't even need to open Pro)

Thank you for your kind assistance!

Re: Concatenate Attributes While Exporting Table - Model Builder

DavidPike — Wed, 28 Apr 2021 16:49:08 GMT

My first thought would be just creating a new field to contain the concatenated values (don't get caught out by max field length). Then a field calculator e.g.

I guess you could export the features to a in_memory feature class or scratch and then add the field, or build the field into your data model.

!Mailing_Adress! + ', ' + !Mailing_City! + ', ' + ...

Re: Concatenate Attributes While Exporting Table - Model Builder

DavidPike — Wed, 28 Apr 2021 16:51:05 GMT

Also in WAB this would be something like a geoprocessing service (or JS widget but that's beyond me), which is easily accomplished (if you have the right infrastructure).

Re: Concatenate Attributes While Exporting Table - Model Builder

JessicaJThompson — Wed, 28 Apr 2021 17:18:18 GMT

Hello!

I will look into the in-memory feature class/scratch. I haven't used model builder in almost 5+ years, and didn't use it much then either (time to change that I think). I did look into using field calculator, though I am trying to not have an intermediate feature layer created - but I am assuming by that terminology (in-memory/scratch), it will may not be something permanently saved.

Additionally, I have never thought of a geoprocessing service. And after a quick search I found a tutorial that will walk me through what seems like the exact process I am in need of. As long as this wouldn't use credits, the "higher-ups" would love this solution built into an app.

Geoprocessing service example: Selecting data—ArcGIS Server | Documentation for ArcGIS Enterprise

Thank you very much! @DavidPike

Re: Concatenate Attributes While Exporting Table - Model Builder

DavidPike — Wed, 28 Apr 2021 17:27:05 GMT

sure - this might be a good read for the memory workspace (I keep using in_memory which is an older implementation...) Write geoprocessing output to memory—ArcGIS Pro | Documentation

essentially just 'memory\nameofyourmemoryFC'

Sorry but not too sure about GP services on ArcGIS Online and not entirely sure you can, only done it on my Enterprise Portal.

Re: Concatenate Attributes While Exporting Table - Model Builder

JessicaJThompson — Fri, 30 Apr 2021 13:57:23 GMT

Hello,

Before I can get to the field calculator/create new field step, I have to export the selected features into a new feature layer (I cannot edit the current feature layer). I have been having a challenge with exporting the selected features in model builder - knowing which tool to use. Feature Class to Feature Class is failing- saying that table is not found. I have tried a number of others as well. This is easily done under the Data tab with Export Features. I am not finding that mechanism in Model Builder. Any Ideas...? Thanks!

Re: Concatenate Attributes While Exporting Table - Model Builder

DavidPike — Fri, 30 Apr 2021 14:08:27 GMT

possibly Copy Features (Data Management)—ArcGIS Pro | Documentation I think that will allow a layer to go to a feature class.