caged

#!/usr/bin/env ruby

require 'pg'
require 'pp'
require 'terminal-table'
require 'csv'

conn = PGconn.open(:dbname => 'nba')

seasons = conn.exec 'select distinct(season) from teams'

caged

#!/usr/bin/env coffee

fs = require 'fs'
csv = require 'csv'

extend = (object, properties) ->
  for key, val of properties
    object[key] = val
  object

caged

#!/bin/sh

for year in $(seq 1996 2013); do
  shortyear=$((year+1))
  season="${year}-${shortyear:2:2}"

  echo "Fetching ${season}..."

  for stat_type in Base Advanced Misc 'Four+Factors' Scoring Opponent; do
    url="http://stats.nba.com/stats/leaguedashteamstats?Season=${season}&SeasonType=Regular+Season&LeagueID=00&MeasureType=${stat_type}&PerMode=Totals&PlusMinus=N&PaceAdjust=N&Rank=N&Outcome=&Location=&Month=0&SeasonSegment=&DateFrom=&DateTo=&OpponentTeamID=0&VsConference=&VsDivision=&GameSegment=&Period=0&LastNGames=0&GameScope=&PlayerExperience=&PlayerPosition=&StarterBench=&sortField=PTS&sortOrder=DES&pageNo=1&rowsPerPage=30"

caged

Bully - How many points better a team is vs. below .500 teams than above .500 teams. A team with a high bully factor regularly beats up on lesser teams. However, that doesn't necissarily mean they win games.

If you were -1 vs. teams above 500, and +1 vs. below 500 teams then you would have a Bully score of 2. Because you're two points better vs below 500 teams when compared to above 500 teams.

ABOVE_500_DIFF - BELOW_500_DIFF = BULLY or 1 - -1 = 2

Why is OKC at the bottom? - This is good news for OKC. They have positive point differentials against both above and below 500 teams and they beat both of those groups equally as well.

caged

(select buildings.*, neighborhoods.wkb_geometry as bounding_area from buildings INNER JOIN neighborhoods ON ST_Intersects(neighborhoods.wkb_geometry, buildings.wkb_geometry) WHERE neighborhoods.name IN('LAURELHURST')) as "active-neighborhood"

--
(select or_blocks.geom, or_places.geom from or_blocks INNER JOIN or_places ON ST_Intersects(or_places.geom, or_blocks.geom) WHERE or_places.name = 'Portland') as blocks

-- gets all blocks in portland joined with race data
(select or_block_data.*, or_blocks.geom, or_places.geom from or_blocks INNER JOIN or_places ON ST_Intersects(or_places.geom, or_blocks.geom) LEFT JOIN or_block_data on or_blocks.gisjoin = or_block_data.gisjoin  WHERE or_places.name = 'Portland') as blocks


-- gets all blocks in portland joined with race data percentages

caged

#!/bin/sh
# usage ./create-psql-database DATABASE
#
DB_NAME=$1
FOLDER_NAME="nhgis0004"


# Drop and recreate database
dropdb --interactive "${DB_NAME}"
createdb --encoding UTF8 $DB_NAME

caged

caged

caged

(select buildings.*, neighborhoods.wkb_geometry as bounding_area from buildings INNER JOIN neighborhoods ON ST_Intersects(neighborhoods.wkb_geometry, buildings.wkb_geometry) WHERE neighborhoods.name IN('LAURELHURST')) as buildings

caged

How to use d3-tip with d3's simple bar chart example.