AnsweredAssumed Answered

I am hoping to get recommendations for an issue involving combining feature classes (polygons of forest land) to spreadsheets in Excel. 

Question asked by jbrengel on Jan 4, 2017
Latest reply on Jan 9, 2017 by rastrauch

The feature classes are separate polygons I'd like to combine into one feature class (multiple polygons of a forest into one one forest district feature class).  The Excel spreadsheets include all data (things like forest number, polygon ID, forest name, hyperlinks to PDFs for the polygons, etc) associated with the individual polygons for the polygon's corresponding forest district (e.g. many rows for forest polygons saved in a single sheet for the forest district).  Ultimately, I am hoping to combine the forest polygon feature classes into corresponding forest district feature classes and use the "Identify" function on the forest polygon features to bring up the corresponding attribute information. 

 

It seems as if the main issue is that there is no corresponding (besides default fields) attribute data with unique identifiers in the individual polygons as is (we did not input any attribute data when initially creating polygons).  I've tried experimenting with various combination tools (Merge, Spatial Join, Union, etc), and I think Merge is the best way to combine the original state forest polygons into one forest district (opinions on this would be appreciated though!).  But, is there a way to somehow combine the Excel sheet of the data for each district to the merged district feature class without a unique identifier/attribute information in the original forest polygons attribute tables? And, ultimately be able to use Identify on each original polygon to bring up its individual data from the district spreadsheet?

 

If not, are there any ideas on how to automate the process of inputting unique identifiers/attribute information into feature class using Python?

 

Thank you so much for your help!!

Outcomes