I have to plot current active hurricane, typhons, storms for Florida. I have used living atlas for layer and I had Florida county shape file. But I also need to create a bubble or a heat map based on distinct count of user id that our agency has by county. The goal is to check the affected employees during a disaster and send help. I have a SQL table with employee details. Now I need to pull that SQL table to ArcGIS and aggregate distinct count of user id by county for the heat map. I need be connected to the SQL database as the number of employee will increase or decrease over time. Can I pull the table and do a SQL like group by in ArcGIS and then join that aggregated table with county layer?
I am new to ArcGIS and do not know how to achieve this.
Please help me.
I would check out Query Layers, which would let you pull in that SQL table and group by, etc. From there you could join the aggregated table with other layers pretty easily.