Union Tool Output Clean Up

282
5
Jump to solution
12-22-2021 10:38 AM
Labels (2)
ChrisSpadi
New Contributor III

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:

 

image001.png

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.

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor

@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

 

 

View solution in original post

5 Replies
JakeSkinner
Esri Esteemed Contributor

@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
New Contributor III

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

0 Kudos
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos
ChrisSpadi
New Contributor III

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.

0 Kudos
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos