ArcGIS Desktop 10.2.1 and one-to-many relationship
I've been struggling to link a feature of 450 municipalities and approximately 60,000 fires that have occurred over the last 15 years. I've attempted to make a relationship class. I can see the individual events when I query a municipality but I cannot symbolize based on, perhaps, graduated symbols to represent the number of fire events normalized by size. I've attached a pic of the tables and the Identify.
Not sure if I could summarize the number of instances of fires and append them as an attribute to the municipal boundaries instead… ? I'm in an FGDB, no DB backend.
I would recommend using the "Summary Statistics" tool on Filtered_Fires with Muni_Code as your case field and COUNT of OBJECTID (and anything else you're interested in symbolizing on) as your statistics field(s). This will create a table that you can then join back to your municipalities.