More

ArcGIS Desktop 10.2.1 and one-to-many relationship

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.


Watch the video: ArcGIS - Spatial Join many polygons to one polygon - one to many relationship