Symbolize a layer based on it's related table (1:M relationship class)

5216
2
Jump to solution
05-05-2016 12:32 PM
NickAlexandrou1
New Contributor III

I have a layer of polygons joined by a relationship class to a table by Field  = DistrictIDNumber

The Table has multiple entries for each polygon so it is a one to many relationship.

Is there any way to symbolize the polygons based on count of related entries?

Lets say they are number of hydrants and the polygons are districts within a county. Can I symbolize the polygons, in graduated colors, based on the number of hydrants reported in that district?

I can't use the actual point data of the table.

I hope this made sense. I'm open to programming solutions if anyone knows of anything. Thanks.

1 Solution

Accepted Solutions
JayantaPoddar
MVP Esteemed Contributor

Check this thread. Joe Borgione​ has the answer

How to calculate number of related records

Create a summary table of the relate-field of Table B.  This will give you a two column table: Relate-Field and Count.

If you want the count value in table A, add a new field called A_Count (or what ever) and then join the summary table to table A via the relate-field; calc A_Count = SummaryTable_Count and you'll be good to go.

Using the count field (after joining), you can symbolize the layer.



Think Location

View solution in original post

2 Replies
JayantaPoddar
MVP Esteemed Contributor

Check this thread. Joe Borgione​ has the answer

How to calculate number of related records

Create a summary table of the relate-field of Table B.  This will give you a two column table: Relate-Field and Count.

If you want the count value in table A, add a new field called A_Count (or what ever) and then join the summary table to table A via the relate-field; calc A_Count = SummaryTable_Count and you'll be good to go.

Using the count field (after joining), you can symbolize the layer.



Think Location
NickAlexandrou1
New Contributor III

Oh that's nice. Thanks!