housing-metrics's People
Forkers
ddixon35housing-metrics's Issues
Suggest CHAS dataset structure in Elmer
Rewrite ACS download into python
PUMS documentation
Add a wiki page for PUMS documentation (or add some to the Census wiki page).
Make sure the data dictionary is up-to-date vis-a-vis PUMS data.
figure out how to document Elmer import scripts for data science staff
when finished with prototype housing data show to Mary and Brian to review
Write code to wrangle Apr 1 OFM data
ETL ACS to Elmer
clean up PUMS code
script download of CHAS data
coordinate with Brian and Mary on equity dashboard or housing dashboard idea
just communicate with them through the process
CHAS documentation
Write up a wiki page describing the organization of the CHAS tables.
Add data to the Elmer data dictionary (in the meta
schema)
Munge postcensal housing file
Investigate CHAS data structure, how to download
Figure out schema reconciling the block level OFM; Apr OFM 1
make a functions python library for commonly used functions
then make sure everyone uses it
PUMS 2019 housing data: add column descriptions to metadata tables
Add tract to subarea crosswalk to Elmer
for Chas data summarization
Ensure all PUMS columns have appropriate decimal places.
Some columns in the PUMS housing and persons tables (ADJINC, to name one) are defined as having implied decimal places. Thus a value encoded as 1002033 is to be read as 1.002033. These columns need to have the decimal explicitly placed in Elmer.
PUMS 2019 persons file: add column descriptions to metadata tables
The PUMS data has several hundred columns, most of which have titles that are defined by the Census Dept. and have non-obvious meanings. Adding descriptive information to the meta.columns
table should help users decode their meanings.
OFM documentation
Write up wiki page for OFM April 1 data in Elmer
Make sure the data dictionary is up-to-date for OFM data.
Script PUMS download
PUMS 2019 persons file: import to Elmer
Import the PUMS data for the region, with any coded values resolved to their English-language meanings.
PUMS 2019 housing file: import to Elmer
make tables for Apr 1 OFM data and moving data from stg to ofm schema
make view for PUMS housing cost by race, income and cost burden
Create view replicating the Annual Housing Production By County spreadsheet
The OFM housing data used by Growth staff reflects the annual increase in housing, not the raw housing counts as stored in the OFM April 1 dataset. This task is to produce a view to replicate the spreadsheet 09_13_ofm_april1_housing_2010-19.xlsx
aggregate CHAS data in Elmer to make tables the by subarea
do sums and calculate moes
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.