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.
Solved! Go to Solution.
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.
If your smoke alarm data can be linked to a field in the building polygons (building name/ID for example), a join or relate will accomplish this Overview of joins and relates—ArcGIS Pro | Documentation
unfortunately your jpeg is still being virus scanned atm.
So I tried that at first, and it worked in a way but not how I would like it. It basically just recopied the polygon (in this case) 231 times. Since I have about 1700 buildings to eventually add to this GIS I've going to end up having 1000s and 1000s of polygons for each smoke alarm/exit sign. (At least that's what I assume)
Also does it really take this long for a virus scan?
I think it's a forum issue. Will take a look when it hopefully loads.
If you are going to get into this "indoor" stuff in a big way.
Get started with ArcGIS Indoors—ArcGIS Pro | Documentation
might be worth your investment
So I actually asked about that w/ an ESRI rep a few weeks ago, and they said that it would be a $50k + investment. My department director doesn't want to make such an investment, unfortunately. They'd be fine w/ massive amounts of spreadsheets instead. I've trying to eliminate spreadsheet printing and paper usage and I was hoping I could get a workaround without pitching a big investment.
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.
I will work on this and let you know how it goes, thanks!
So that accomplished what I was looking to do. Thanks! Just gotta clean up the data now. Thanks!