topic block groups and address correspondence - dot density in Data Management Questions https://community.esri.com/t5/data-management-questions/block-groups-and-address-correspondence-dot/m-p/621798#M35152 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Fri, 05 Nov 2010 16:16:12 GMT LesaHavert 2010-11-05T16:16:12Z block groups and address correspondence - dot density https://community.esri.com/t5/data-management-questions/block-groups-and-address-correspondence-dot/m-p/621798#M35152 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN></BODY></HTML> Fri, 05 Nov 2010 16:16:12 GMT https://community.esri.com/t5/data-management-questions/block-groups-and-address-correspondence-dot/m-p/621798#M35152 LesaHavert 2010-11-05T16:16:12Z Re: block groups and address correspondence - dot density https://community.esri.com/t5/data-management-questions/block-groups-and-address-correspondence-dot/m-p/621799#M35153 <HTML><HEAD></HEAD><BODY><SPAN>Why not perform a spatial join of your points into the block group polygons.&nbsp; 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.</SPAN></BODY></HTML> Mon, 08 Nov 2010 17:52:40 GMT https://community.esri.com/t5/data-management-questions/block-groups-and-address-correspondence-dot/m-p/621799#M35153 JoeBorgione 2010-11-08T17:52:40Z