Skip to content

Instantly share code, notes, and snippets.

View nygeog's full-sized avatar

Danny S. nygeog

View GitHub Profile
create table result as (
with one as (
SELECT nyc_pluto_15v1_resonly.the_geom,
white_noth,
asian_noth,
black_noth,
hl,
lt_12_race.cartodb_id,
resarea,
@andrewxhill
andrewxhill / Small Multiples.ipynb
Last active June 25, 2016 13:57
Create small multiples through the Static Maps API
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@toddwschneider
toddwschneider / nyc_taxi_uniquely_identifiable.md
Created December 1, 2015 12:28
How many NYC taxi trips are uniquely identifiable by census tracts and the hour of pickup time

40% of NYC Taxi Trips are Uniquely Identified by Pickup/Drop Off Census Tracts and Hour

In my recent post analyzing 1.1 billion NYC taxi and Uber trips, I included a section about privacy concerns which showed how precise latitude/longitude coordinates of taxi pickups and drop offs could potentially be used to reveal personal information about where people live, work, socialize, etc.

I wrote that if the Taxi & Limousine Commission wanted to avoid disclosing personal information, they would have to remove latitude/longitude from the dataset, perhaps replacing them with coarser census tract location data. Now it seems like maybe census tracts are still too precise.

I hadn't previously investigated how well census tracts uniquely identify pickups and drop offs, but **it turns out that if you

@danicarrion
danicarrion / index.html
Created May 20, 2015 18:33
createLayer with torque category layer
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=Edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1, user-scalable=no">
<title>Torque category selector</title>
<link rel="stylesheet" href="http://libs.cartocdn.com/cartodb.js/v3/3.14/themes/css/cartodb.css" />
<style type="cartocss/text" id="cartocss">
Map {
@javisantana
javisantana / cartodb_yosemite.md
Created December 9, 2014 14:08
installing cartodb on OSX yosemite

cartodb installation on yosemite

if you get the following when you are running bundle on OSX Yosemite:

An error occurred while installing nokogiri (1.6.0), and Bundler cannot continue.
Make sure that `gem install nokogiri -v '1.6.0'` succeeds before bundling.
@clhenrick
clhenrick / readme.md
Last active August 29, 2015 14:05
cartodb-dorkshop.md

CartoDB Dorkshop Tutorial

Parsons, The New School For Design
August 9, 2014

About Me

I (Chris Henrick) have a professional background in Cartography and Geographic Information Systems. In undergrad I studied human geography, urban studies and fine art. Recently I have gotten more into web development, data visualization and interactive web-mapping.

What is this Dorkshop about?

@dwtkns
dwtkns / index.html
Created August 7, 2014 11:33
Simple D3 US Map
<!DOCTYPE html>
<meta charset="utf-8">
<style>
.counties {
fill: none;
stroke: black;
opacity:0.2;
}
@e-n-f
e-n-f / taxi.sh
Last active July 7, 2017 10:45
NYC taxi with datamaps
#!/bin/sh
for i in trip_data_*.csv.zip
do
unzip -c $i
done |
tr -d '\015' |
awk -F, '{print $12 "," $11 " 1:0"; print $14 "," $13 " 1:1"}' |
/data2/data/github/datamaps/encode -z19 -m1 -o nyc-taxi-all
@octocat
octocat / .gitignore
Created February 27, 2014 19:38
Some common .gitignore configurations
# Compiled source #
###################
*.com
*.class
*.dll
*.exe
*.o
*.so
# Packages #
@bertspaan
bertspaan / README.md
Created January 2, 2014 15:28
Python script to convert DBF database file to CSV