topic Re: Union Tool Output Clean Up in ArcGIS Pro Questions

Union Tool Output Clean Up

ChrisSpadi — Wed, 22 Dec 2021 18:38:33 GMT

I ran a Union between project locations and sensitive environmental areas. I then filtered out only the project sections from the Union output. The table looks like this:

My goal is to automate this portion of cleaning up the data with either python or model builder within Pro.

Goal:

- remove all fields except Title and FID_'s

- then remove the FID_ from the field name

- then replace all values -1 or below with a blank field

- then generate a report with the table in PDF format

My gut tells me python is the right approach and will have more tools for fine tuning this. I may be wrong.

Any input is much appreciated.

Thanks.

Re: Union Tool Output Clean Up

JakeSkinner — Wed, 22 Dec 2021 19:12:29 GMT

@ChrisSpadi this can be accomplished using arcpy:

- remove all fields except Title and FID_'s --> Delete Field

- then remove the FID_ from the field name --> Alter Field

- then replace all values -1 or below with a blank field --> Calculate Field

- then generate a report with the table in PD --> Report. The report template must first exist in the Pro project

Re: Union Tool Output Clean Up

DanPatterson — Wed, 22 Dec 2021 19:14:40 GMT

are all your Project locations in 1 file? and the sensitive areas in another?

Are you interested in the actual area? or just whether there is overlap

Tabulate Intersection (Analysis)—ArcGIS Pro | Documentation

should not be overlooked either in part of your analysis or in its entirety

Re: Union Tool Output Clean Up

ChrisSpadi — Wed, 22 Dec 2021 19:57:39 GMT

Hi Dan,

Thanks for the response. This tool looks useful for 2 fc's but all my data is multiple fc's within a GDB and map.

Re: Union Tool Output Clean Up

DanPatterson — Wed, 22 Dec 2021 20:36:39 GMT

too bad, I suppose consolidating the disparate bits is out of the question, it seems like a good candidate

I don't suppose your environmentally sensitive areas are in one file? since a batch merge would take care of getting all your "projects" together

Re: Union Tool Output Clean Up

ChrisSpadi — Tue, 28 Dec 2021 15:40:01 GMT

I ended up building a model with some of these tools.