search

California-Data-Collaborative / OWRS-Analysis

Analysis of water rates collected in the OWRS format.
3 stars 6 forks source link

Join with census data #7

Closed christophertull closed 6 years ago

christophertull commented 6 years ago

After issue #6 we can then spatial join the utilities with census data. Could do something like average over blockgroups within the utility service area to get an idea of income and then could plot price of water vs. income. Do lower-income folks pay more or less per-unit for water?

christophertull commented 6 years ago

Easiest way to do this might be to grant access to some of the public tables in our database (e.g. our table for ACS 2015 data and the supplier polygon tables). This would allow whoever is analyzing the data to do the spatial joins in SQL using PostGIS rather than having to export everything and then do the spatial joins. We can talk about database access on Wednesday.

patwater commented 6 years ago

Can we close this? Believe this functionality has been integrated