Union Tool Output Clean Up

[ChrisSpadi]

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.

[JakeSkinner · Accepted solution]

@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

[ChrisSpadi]

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

[DanPatterson]

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

[ChrisSpadi]

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.

[DanPatterson]

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