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

# Last Updated: 2014.06.05

# Gems to include
require	'Nokogiri'
require "open-uri"
require 'pp'
require 'json'
require 'csv'

# def get_default_data( default_stats, default_pricing, date_range )

milesgrimshaw

Below are a set of resources I find to be informative

Intro to Tech

• Peter Thiel Class Notes
• MBA Mondays
• Stratechery

Personal Blogs

• Fred Wilson USV
• Bill Gurly

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

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

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

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 packages
library(ggplot2)
library(lubridate)
library(stringr)
library(scales)

# Set the working directory
getwd()
setwd("~/Dropbox/Personal/Projects/Evernote_Analysis/files/")

milesgrimshaw

## Code for subsetting and formatting open paths data for Mapbox
## Miles Grimshaw 
## December 26th 2013

##  Set working directory and load required packages
getwd()
setwd("~/Dropbox/Personal/Mapbox/OpenPaths/")
library(stringr)
library(lubridate)
# library(ggplot2)

milesgrimshaw

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

i = 0
features = []
start_line = []
end_line = []

## Loop through each row of the data