Skip to content

sfbrigade/datasci-cpuc

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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:
  • CA baselayer
  • bubbles for each tract:
    • radius encodes data from CPUC (upload/download speed)
    • color encodes census tract data (income levels)
  • 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

$ git clone <your-repo>
$ cd <this-repo's-name>
$ git remote add upstream <this-repo>

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

$ cd path/to/local/clone
$ python -m SimpleHTTPServer

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

$ git checkout -b <feature-branch>

Do some work:

$ vim <some-files>

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

$ git commit -am 'my awesome feature'
$ git pull upstream master
  # solve conflicts
$ git 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
  • join lon/lat from caCensusBlocks.csv to CPUC data
  • join income from ca-income-by-blockgroup.csv to CPUC data
  1. new data file is "output.csv"

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published