View Geocoding Apps Script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
View Kickstarter_Geocoding.R
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Load desired packages | |
library(lubridate) | |
library(stringr) | |
library(ggplot2) | |
library(scales) | |
# Set the working directory | |
getwd() | |
setwd("~/Desktop/Patreon/") |
View Response
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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, |
View Response
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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, |
View streetscore_cartodb.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## 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) ) |
View Citibike.R
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
View citibike.rb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## 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": { |
View geocode_appscript
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
View Style.css
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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; } | |
} |
View yelp.rb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
require 'oauth' | |
require 'json' | |
require 'pp' | |
require 'csv' | |
consumer_key = '#YOURS' | |
consumer_secret = '#YOURS' | |
token = '#YOURS' | |
token_secret = '#YOURS' |
OlderNewer