We are trying to create tables showing the percent of income spent on housing costs( e.g. Table B25101) for unincorporated areas in Colorado. I was wondering if anyone has tried to do this.
One approach we thought of was a "top-down" method of taking the difference between the county estimates and the estimates derived from the incorporated area (taking municipalities that are in more than one county into account through the use of the "Place/Remainder" geography from data.census.gov)
Another approach would be to use a "bottom-up" method that classified block groups according to their incorporated or unincorporated status. The issue here is developing the criteria for classifying "partially incorporated" block groups.
I would appreciate any ideas about how one might approach this problem.
TIA
AB
Please discuss the data processing you would use to do this.
One other thing that might help if you haven’t already tried it, is the CDP designation on places (state-place sumlev) that means it’s a named but unincorporated area — usually a post office name or something like that for unincorporated areas. Places I’ve worked, they generally named all the unincorporated areas of a county but I honestly don’t know if that’s true everywhere.