ACS Data Users Group

 View Only
  • 1.  ACS low to moderate income joining in ArcGIS

    Posted 08-09-2024 03:26 PM

    Hello,

    My grant manager gave me the raw data from the ACS 5-year estimates for low to moderate-income populations. Since there are no locators in the data, I am having difficulty plotting out the areas on ArcGIS. I have updated layers for both census tracts and block group boundaries. I joined the spreadsheet to each layer but Geoids don't fully match up for the tracts or they match up for the block groups but I can't filter the data only to show certain percentages. Does anyone else work with the ACS data for CDBG programs? Are you also having difficulty? any information would be beneficial.

    thanks in advance.



  • 2.  RE: ACS low to moderate income joining in ArcGIS

    Posted 08-09-2024 04:04 PM

    Are you saying the data do not have a geoid when you say "locators"? What vintage are the ACS data? What vintage are your shapefiles?



  • 3.  RE: ACS low to moderate income joining in ArcGIS

    Posted 08-09-2024 04:08 PM

    the Geoid is just a combination of the state, county, tract and block group identifiers. The ACS data is from the ACS 5 year estimate, 2016-2020 and I downloaded the shapefiles from the HUD website today. Its updated tract and block group boundaries



  • 4.  RE: ACS low to moderate income joining in ArcGIS

    Posted 08-09-2024 04:11 PM

    You're likely using newer, mismatched shapefiles to older data. You'll either need to find newer data or older shapefiles--my best guess. What is vintage of those HUD shapefiles?



  • 5.  RE: ACS low to moderate income joining in ArcGIS

    Posted 08-09-2024 04:15 PM

    the tract and block group boundaries were updated in July. If the last year of the data is 2020, should I find shapefiles from 2020?



  • 6.  RE: ACS low to moderate income joining in ArcGIS

    Posted 08-09-2024 04:18 PM

    2016-2020 ACS would use shapefile created before 2020 to best of knowledge. 2016-2020 ACS was using 2010-based geo boundaries.



  • 7.  RE: ACS low to moderate income joining in ArcGIS

    Posted 08-09-2024 04:49 PM

    I may be wrong about 2016-2020 using 2010-based. Im hoping someone else chimes in. You can test by finding an older shapefile and seeing if your ACS geoids match with older shapefiles geo ids via its attribute table.



  • 8.  RE: ACS low to moderate income joining in ArcGIS

    Posted 08-09-2024 04:58 PM

    The Census Bureau has a nice resource showing the Vintage of Geographic Areas for ACS Estimates that have been released each year:

    https://www.census.gov/programs-surveys/acs/geography-acs/geography-boundaries-by-year.2020.html#list-tab-626530102

    For the 2020 estimates, there are a few geographies that used 2010 boundaries (PUMAs, Urban Areas, ZCTAs), but block groups were based on 2020 boundaries.

    However, I don't work with CDBG program data so I can't speak to the mismatch with the ACS.