hackoregon / emergency-response

Simulations, Models, and Visualizations of Portland Fire and Rescue data
11 stars 10 forks source link

Write queries to create demographic rollup tables by FMA #75

Closed hannahkane closed 7 years ago

sky-t commented 7 years ago

Per discussion with @BrianHGrant, I'll put all demographic rollup data into a single table that can be hit by the API. @futurechris will also add the response time rollups to this table.

sky-t commented 7 years ago

@BrianHGrant @futurechris , I created a new table named fma_api_rollup in the db and have started populating it with demographic data by FMA. I have median response time by FMA and will add that as well.

sky-t commented 7 years ago

fma_api_rollup table is now populated with the following demographic data: total population, % owner occ, % renter occ, median hh income, % with health ins, % w/o health ins, % college grad or higher, % rec food snaps, % nonwhite, % below pov line, % hh w/ member 65+, % in diff area last year

BrianHGrant commented 7 years ago

Thanks, was able to inspect the tables and looking good. Will have endpoint created shortly