Smoke alarm data to a building dataset.

Alexander_Thomas

So I have been asked to try to and get some capital projects into a GIS. One such project is exit signs and smoke alarm data. I have excel files of exit and smoke alarms for buildings around campus. I would like to attach this information to its building footprint in our building footprint dataset. I feel like this is something I should know how to do, but I'm blanking out maybe I'll figure it out later. I have each building as its own feature class inside a feature dataset. I'd like to be able to click on a building footprint and have the attribute table show me all the smoke alarm or exit sign attributes inside that building. I hope this picture attached helps explain. 

InkedScreenshot 2021-02-10 154152_LI.jpg

DamienPyne_1-1713475722298.png

LindaWilliams1

Since this is a One building to Many smoke alarm/exit sign relationship, and it seems like you don't need to put points for all smoke alarms and exit signs within each building, a Relate would work better than a Join. You would need a column in each spreadsheet for the building identifier that would match a field in your building feature class (you can also combine all of your spreadsheets into one). Once you've Related your table(s) to your building features, you can configure pop-ups to display summaries (such as count of smoke alarms) of the related data as well as clicking on each related table record to view the details. Once you've selected a building, from the Attribute Table you can also click on "Related Data" from the building's table menu and display all of the smoke alarms/exit signs for that building. The link that David posted to the Joins and Relates describes the process and gives additional links to displaying the related data via attribute tables and pop-ups.

One related recordSummary of related records