I am trying to find the total population in 2-mile buffers to find the population 2 miles around primary care clinics. So far I have done this:
- Added block group outlines and joined the areas with census data for the population for these areas. Calculated the area in square miles of each area
- Added 2-mile buffers.
- Intercepted buffers and block group areas.
- Calculated area of block groups within the buffers and used this to calculate the new population within each buffer
- Use a summary table to display the population for each clinic.
My issue is that the population values are way too high, and when I look at the data in Excel, many of the block group are listed multiple times per clinic. I wonder if this because the buffers are overlapping, as I do not see this for the buffers that have no other overlapping buffers.
What can I do to fix this?