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.