I am trying to arrive at the population data at the city level.
I understand that the variable that comes closest to a city is a "place" or msa.
my question is how can I connect the census tract level data with the msa and place within bigquery?
Thanks and regards to all the contributors!!
City level data is available. Place refers to incorporated places or Census Designated Places. I am not familiar with Bigquery but if it uses standard Census summary level codes then it would be summary…
Anything and everything geography converter: https://mcdc.missouri.edu/applications/geocorr.html. This should be the first thing they teach you after explaining what a Census tract is.
Not quite everything, but thanks for the upvote!
By the way, there was a recent Census Academy Data "Gem" video about using Geocorr.
City level data is available. Place refers to incorporated places or Census Designated Places. I am not familiar with Bigquery but if it uses standard Census summary level codes then it would be summary level 160. Refer to the ACS summary file documentation for that. (see the appendices file): www.census.gov/.../summary-file-documentation.html
will check out this file. Thank you!
Understood the structure of the data now - starting from your inputs.
statistical data is under census and acs categories in bigquery public data sets.
geographical data for the localities are available under geo_us_boundaries_ tables.
Additionally here is a good link to bring it all together:
https://towardsdatascience.com/a-beginners-guide-to-google-s-bigquery-gis-46a1193499ef