Display regional values for demographic indicators
Closed this issue · 8 comments
- Add a flag to the histogram indicating the MSA value for the selected indicator
@davidheyman do you have workflows set up for census data that can easily be modified to get values for MSAs? I believe we only have demographics by tract now. MSA data could either be added as columns in the existing msa table or else in a new table.
This is going to take some work on my end before it is ready. I'll need to update the data scripts to download and process the MSA data alongside the tract data.
Are there any SELECT * FROM msa queries on the MSA table that might get messed up if the data goes into that table?
There is a one-time SELECT * FROM msa query to get centroids and names and such, but if this data would just be going into additional columns on that table it shouldn't hurt anything.
This is ready on the msa-data branch. The MSA census data is in the census_msa table on CARTO.
This is done in the no-data branch because it copies some new methods there in case of missing years. The flag label is formatted as "MSA name: value"
These have gone missing. Is it a problem with the data update?
Should be back now, in one of the recent (re)merges