block groups and address correspondence - dot density

702
1
11-05-2010 09:16 AM
LesaHavert
New Contributor
I have a map - Sacramento County, with block group detail. I have a huge list of Sacramento County addresses (street name, city, state, zip format) (almost 200,000 - many of them intentional duplicates) in a database, which I have geocoded and want, if possible, to correspond to block groups. Is there a way I can correspond those addresses (or their longitude/latitude) to block groups - perhaps by join/relate through an Object ID or FIPS code? I want to set up a dot density map - # of addresses per block group. I know I could using a zip code map, but I wanted the finer detail census tracts/block groups provide. Thanks for any help you can provide.
Tags (2)
0 Kudos
1 Reply
JoeBorgione
MVP Emeritus
Why not perform a spatial join of your points into the block group polygons.  Then you could summarize the resulting feature class attribute table by block group name; after that, join or relate the summary table back to the original block group via the block group value and colorize or dot density on the count value from the summary table.
That should just about do it....
0 Kudos