nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Find more posts tagged with

Accepted answers

DavidPike

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.

All comments

DavidPike

can you provide some screenshots please

Anonymous User

Please see below a spatial join on dissemination block using DAUID and First as the parameters. I've selected 1 block and I can see a Join_Count of 7:

Here is a screen shot for another, more heavily populated block with a Join_Count of 85:

So I am getting differing values, per block that look reasonable (need to figure out how to validate that), but I cannot seem to get the graduated colors to display it properly. When I try to a different value for Classes (e.g., 5) it snaps back to 1 class??

DavidPike

What does the histogram look like and also can you show the attribute table including all the columns.

Anonymous User

I cleaned up my spatial join a bit. Below is some sample data from the attribute table:

And the histogram:

Thank you,

--sue

DavidPike

I can't really see why it would do this other than a bug. I'd give creating a new field a try and copying the same join_count values across in field calculator, then perhaps saving a new copy. I can also try and run it for you if you send the data.

Anonymous User

Thanks David. I'll try the field copy. I'm also going to try the same type of mapping with a different data set, some Ontario schools (Ontario public school contact information - May 2020 - Ontario Data Catalogue ). Unfortunately the data I am working with is sensitive and I am not able to share it. The boundary file is the Dissemination Blocks file - Cartographic boundary file found at 2016 Census Boundary files , if you were inclined to mimic the process. I'll report back if I have the same issue. If so, it is a bug or I have a bad install. If not, there is something funky with my data.

Thanks for all of your help so far

--sue

Anonymous User

Using the 2 files above, I am getting the same results. Would you mind giving it a go? It might be an error on my part in how I am using the tool. I edited the schools data to consume fewer credits when geo-coding. How can I share my geo-coded data with you?

DavidPike

are you able to download your data from portal? I never use AGOL tbh. If you want to save some credits take a look at a geocoding API such as OpenCage Geocoder - Easy, Open, Worldwide, Affordable Geocoding , the documentation is really good.

Anonymous User

I will certainly check out that tool! I've uploaded my package and made it openly available (https://niagaracollege.maps.arcgis.com/home/item.html?id=a3b16f850fda45e9bdd26bc4ff38bbf3 )

DavidPike

unfortunately that's just shared within your org. i'll just geocode it quickly, what info do you need to keep on the schools?

Anonymous User

Oh sorry, I selected to share with everyone but that might just mean within my organization. I used the address information to geocode (street, city, province and postal), and kept:

Region

Board Number

Board Name

Board Type

School Name

School Level

School Language

School Type

Suite

PO Box

Street

City

Province

Postal Code

I will want to add filtering on School Level, School Language, School Type at some point.

DavidPike

hmmm, cancel that. it only let me code 500 then cut me off. Also plonked a school in the middle of a marshland lake, I think I'll go off more than postcode next time.

Anonymous User

It would be nice if we could attach files to these posts . I have a CSV of cleaned school data.

OntarioSchools.csv.zip

DavidPike

u go to the cog at the bottom left of your post, go to 'edit' then an attachment option should appear at the bottom.

Anonymous User

Well look at that! CSV attached to my previous post.

DavidPike

not geocoded though, can you copy paste the lat longs from agol?

Anonymous User

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

OntarioSchools.csv.zip

DavidPike

Oh I had fun with this one...

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.

JoshuaBixby

Looking at your screenshots, you are doing a graduated color with one class using natural breaks. What are you expecting from a single-class graduated ramp?

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

Anonymous User

Hi Joshua,

When I tried to select more classes, it would snap back to 1 effectively removing the option

JoshuaBixby

Ah, OK, now I understand. With any histogram, the tool never defaults to sampling the entire set of values. That said, the symbology tool should handle your type of situation better.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.