| #!/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 |
| <!DOCTYPE html> | |
| <meta charset="utf-8"> | |
| <style> | |
| .counties { | |
| fill: none; | |
| stroke: black; | |
| opacity:0.2; | |
| } |
Parsons, The New School For Design
August 9, 2014
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.
| <!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 { |
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
| 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, |
