4

I am trying to create a heat map of doctors per zip code based on zip code. I have a table with the doctors and their zip codes, some of them repeating because there is more than one doctor per zip code. I also have a shapefile with polygon features of zip codes.

I have tried the Get Count tool (which returned the total number of rows) and the Find Duplicate tool, which did nothing for me. Find Duplicate just produced a confusing table with the same amount of records as the original that did not actually have the correct input values in the center column (many were something different) and the counts in the right column did not match the counts I see (via select by attribute: zipcode = thiszipcode, result: x were selected).

My thought is that I could create a table based on the doctors table that lists each unique value (the zipcode) and its count. I would then join that table to the zip code shapefile and create a nice heat map. It seems so simple, but I cannot figure out how to get the count. Do you have any ideas?

Improve this question
1
  • For the record, you're going to end up with a classed (possibly unclassed if each unique value/doctor count gets its own color) choropleth map, not a heatmap. See gis.stackexchange.com/questions/256/… for more information.
    – Chris W
    Oct 10 '14 at 4:19
2

You can summarize the table by zip code. Choose zip code as Statistics Field and the Statistic Type COUNT. Then for Case Field choose zip code. The output table will give you the count of Doctors by zip code.
You can also do this in ArcMap by right clicking on the field you want to summarize and select 'summarize.'

Improve this answer
1
  • 1
    @tiffany Frequency does more directly what you're after, but Summary Statistics (the link in the answer) doesn't require an Advanced license like Frequency does (obviously not an issue for you, but for the sake of others) and is actually more capable. See gis.stackexchange.com/questions/102507/… Note that Summary Statistics is different from and considerably more capable than Summarize - which cannot do case fields.
    – Chris W
    Oct 10 '14 at 4:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.