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?