census-api icon indicating copy to clipboard operation
census-api copied to clipboard

Geocontainment issue with CBSAs

Open JoeGermuska opened this issue 5 years ago • 0 comments

In answering a Zendesk question about "how can I know the counties in the Minneapolis-St. Paul metro area", I have found a discrepancy in how Census Reporter "answers that question".

I thought the root of the answer was in this SQL query:

select * from tiger2019.census_geo_containment where parent_geoid ='31000US33460' and child_geoid like '05000%';

which returns 15 rows, the same as the number in the Sep 2018 Delineation file and the SQL script which sets this up

However, the results generated by searching for a table, then specifying "counties" (in) "Minneapolis-St. Paul-Bloomington, MN-WI Metro Area" has 35 counties, both in the web and download fiew.

JoeGermuska avatar Nov 09 '20 20:11 JoeGermuska