sfbrigade/datasci-cpuc

Name: datasci-cpuc

Owner: SFBrigade

Description: null

Created: 2016-11-08 04:42:23.0

Updated: 2016-11-11 21:44:59.0

Pushed: 2016-12-04 19:46:34.0

Homepage: null

Size: 4458

Language: CSS

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

California Public Utilities Commission Project

TBD

This project is part of Data Science Working Group at Code for San Francisco

Project Description

TBD

Live links

map (alpha)

Working Plan

1. Bubble map/cartogram:
2. CA baselayer
3. bubbles for each tract:
   • radius encodes data from CPUC (upload/download speed)
   • color encodes census tract data (income levels)
4. more info on chart to the side

Contributing DSWG Members

| Name | Slack Handle | Contribution | | —| — | — | | Dylan Sather| @dylburger | Analysis | | Sanat Moningi | @sanat | Visualization | | Tyler Field | @tyler | Visualization | | Geoffrey Pay | @gpay | Visualization |

Tech

• TBD

Contributing

At the moment, we have just started this project. If there's something you want to help out with, here's how to get started:

Fork this repo, then clone your repo locally

t clone <your-repo>
 <this-repo's-name>
t remote add upstream <this-repo>

Launch a local server. If you're on a Mac, you already have SimpleHTTPServer installed:

 path/to/local/clone
thon -m SimpleHTTPServer

You could also use http-server if you wanted
Create a feature branch:

t checkout -b <feature-branch>

Do some work:

m <some-files>

When you're ready, commit, merge any upstream changes, deal with conflicts, and push your branch (aka, forking workflow)

t commit -am 'my awesome feature'
t pull upstream master
solve conflicts
t push

Create a Pull Request from your pushed branch (compare branch) to this repo (base branch)
…
Profit!

Sources

census shapefile shapefiles

data steps:

1. download shapefile (direct link 439MB) of California census tract blocks
   
2. scrape properties of shapefiles into csv ogr2ogr -f CSV caCensusBlocks.csv tl_2010_06_tabblock10.shp
3. income estimates only available for blockgroup level. scrape from census API, posted at numeracy
4. test results from cpuc pulled out of looker
5. join data using node script data/join.js
6. join lon/lat from caCensusBlocks.csv to CPUC data
7. join income from ca-income-by-blockgroup.csv to CPUC data
8. new data file is “output.csv”