I have a map - Sacramento County, with block group detail. I have a huge list (almost 200,000) of addresses (street name, city, state, zip format) in a database, which I have geocoded and want, if possible, to correspond to block groups. Is there any way I can correspond those addresses (or their longitude/latitude) to block groups - perhaps by join/relate through an FIPS code? I want to set up a dot density map - # of addresses (which are outpatient clinic visits) by block group. I know this would work using a zip code map, but I wanted the finer detail census tracts/block groups provide. Thanks for any help you can provide.
