healthyregions / chicago-environment-explorer

ChiVes harmonizes & standardizes environmental data across dozens of sources to make it accessible for full exploration, alongside a growing list of resources on the Chicago Environment, cultivated by a community of curators.
8 stars 1 forks source link

Add additional SDOH concepts #43

Closed Makosak closed 1 year ago

Makosak commented 1 year ago

Per new NASA grant objectives, add the following using ACS 2018 data. Include as rows in pop-up windows, and widgets, and complete metadata integration:

Socio-economic and Demographic Variables: (1) Overcrowding (persons per room and square footage per person); (2) Median rent and median home value; (3) Cost Burdened Renters and Owners (those that spend >30% of the monthly income on housing costs); (4) Percentage of foreign born population; (5) Average household size; (6) Percent family and non-family households; (7) Percent of the population with a four-year college degree.

Makosak commented 1 year ago

Updated list -- all of this needs to be integrated in one, clean Google Spreadsheet per Chives procedures. Note we are using 2018 ACS 5-year aggregate data, and at census tract scale. @ssingh85 Please upload code used for generating queries, as this will help the person generating the metadata document.

ssingh85 commented 1 year ago

Variables have been updated as "SDOH + demographics" excel file in HEROP folder.