Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Geocontainment issue with CBSAs #87

Open
JoeGermuska opened this issue Nov 9, 2020 · 0 comments
Open

Geocontainment issue with CBSAs #87

JoeGermuska opened this issue Nov 9, 2020 · 0 comments

Comments

@JoeGermuska
Copy link
Member

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant