milesgrimshaw

function addMahZipCodez() {
  
  // grab basic sheet data
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();
  var values = rows.getValues();
  
  // init some locals for looping over each row
  var row;

milesgrimshaw

# Load desired packages
library(lubridate)
library(stringr)
library(ggplot2)
library(scales)

# Set the working directory
getwd()
setwd("~/Desktop/Patreon/")

milesgrimshaw

Dear Miles,

We heard you discovered a security issue with *Kluck*. We take security and privacy very seriously, and our team has worked today to address the concern.

The coordinates you discovered are not exact coordinates; they reflect a radius for a *user* who has given *Kluck* permission to show *the user's* profile, including location. However, to avoid any confusion, we have now disabled that feature. [Redacted]

We sincerely appreciate you bringing this to our attention...[redacted]

Sincerely,

milesgrimshaw

Dear Miles,
 
We heard you discovered a security issue with *Kluck*. We take security and privacy very seriously, and our team has worked today to address the concern.
 
The coordinates you discovered are not exact coordinates; they reflect a radius for a *user* who has given *Kluck* permission to show *the user's* profile, including location. However, to avoid any confusion, we have now disabled that feature. [Redacted]
 
We sincerely appreciate you bringing this to our attention...[redacted]
 
Sincerely,

milesgrimshaw

## Instersection Commands For StreetScore and TreeCount

UPDATE cb_newyork_streetscore_compiled SET streetscore = (SELECT AVG(q_score) FROM streetscore_newyorkcity WHERE ST_Intersects(the_geom, cb_newyork_streetscore_compiled.the_geom) )

UPDATE cb_newyork_streetscore_compiled SET trees = (SELECT COUNT(*) FROM tree_census_simple WHERE ST_Intersects(the_geom, cb_newyork_streetscore_compiled.the_geom) )

## Collect PLUTO Data

UPDATE nyc_blocks_2010 SET assesstot = (SELECT sum(assesstot) FROM pluto WHERE ST_Intersects(the_geom, nyc_blocks_2010.the_geom) ) 

milesgrimshaw

## API Structure
# {
#   "name": "citibike_bay",
#   "count": 8,
#   "frequency": "realtime",
#   "version": 1,
#   "newdata": true,
#   "lastrunstatus": "success",
#   "lastsuccess": "Tue Jul 22 2014 21:50:19 GMT+0000 (UTC)",
#   "results": {

milesgrimshaw

library(ggplot2)
library(lubridate)

## Set the working directory
setwd("~/Dropbox (Personal)/Personal/Github/Citibike")

## Organize restaurant data
r <- read.csv('trips.csv', header=TRUE, as.is=TRUE)
head(r)

milesgrimshaw

function geocode_all() {
  
  // grab basic sheet data
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();
  var values = rows.getValues();
  
  // init some locals for looping over each row
  var row;

milesgrimshaw

#ubergeojson, #original {
    line-color: @road;
    line-width: 0.5;
      [zoom>=11] { line-width: 0.5; }
      [zoom>=12] { line-width: 0.7; }
      [zoom>=13] { line-width: 1; }
      [zoom>=14] { line-width: 1.2; }
      [zoom>=15] { line-width: 1.4; }
      [zoom>=16] { line-width: 1.6; }
}

milesgrimshaw

require 'oauth'
require 'json'
require 'pp'
require 'csv'

consumer_key = '#YOURS'
consumer_secret = '#YOURS'
token = '#YOURS'
token_secret = '#YOURS'