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.

jskinner

@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