nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Concatenate Attributes While Exporting Table - Model Builder

JessicaJThompson

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!

Najděte více příspěvků označených jako

Analysis

Desktop

Accepted answers

DavidPike

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).

DavidPike

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! + ', ' + ...

All comments

DavidPike

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

JessicaJThompson

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!

DavidPike

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.

JessicaJThompson

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

DavidPike

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).

DavidPike

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! + ', ' + ...

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.