Count of addresses within a dissemination block

[Anonymous User]

Hello all,

Newbie here. I have a table of addresses that I have geo-coded on a World Street Map. I've also included 2 StatsCan boundary files, Dissemination Subdivision and Dissemination Blocks. I am trying to use Graduated colours get a display based the count of addresses within a Dissemination Block. I've used a spatial join on Dissemination Subdivision and Join_Count for Primary symbology - Graduated Colors, and this seems to return reasonable results, but when I try the same methodology for the Block level, I get 0 for a Join_Count. Any assistance would be greatly appreciated.

[Anonymous User]

Added X, Y, Display X, Display Y. Please let me know if that does the trick.

[DavidPike · Accepted solution]

Oh I had fun with this one...

My best guess is that the huge number of 0 join_count values in the dataset basically overmatches the small number of other join_counts, maybe a skip factor or something like that is hidden in there. Definitely something for esri to look into.

If you get rid of the 0 values either via deletion (select by attribute where "Join_Count" = 0 or with a  definition query "Join_Count" <> 0, then overlay that layer on top it should work as expected.

[Anonymous User]

I'm glad you had fun with it, lol! I'll try your recommendations this morning and get back to you.

[Anonymous User]

What you suspected (too many 0 join_counts overwhelming the Graduated Colors symbology) is what was happening. Esri is now aware of the issue. 

David Pike‌ thank you very much for your patience and help. I have learned so much in just a few days. Not all heroes wear capes