Danny S. nygeog

## query.sql
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,

## Small Multiples.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                andrewxhill
                / Small Multiples.ipynb
            
            
              Last active
              June 25, 2016 13:57
            
              
                Create small multiples through the Static Maps API
              
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## nyc_taxi_uniquely_identifiable.md

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              7 stars
            
          
                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

  
## index.html
<!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 {

## cartodb_yosemite.md

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              1 star
            
          
                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.


## readme.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                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?


## index.html
<!DOCTYPE html>
<meta charset="utf-8">
<style>

.counties {
  fill:   none;
  stroke: black;
  opacity:0.2;
}

## taxi.sh
#!/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

## .gitignore
# Compiled source #
###################
*.com
*.class
*.dll
*.exe
*.o
*.so

# Packages #

## README.md

      
              2 files
            
          
              13 forks
            
          
              25 comments
            
          
              82 stars
            
          
                bertspaan
                / README.md
            
            
              Created
              January 2, 2014 15:28
            
              
                Python script to convert DBF database file to CSV
              
          
    Python script to convert DBF database file to CSV


First download dbfpy: http://sourceforge.net/projects/dbfpy/files/latest/download?source=files
Then install: sudo python setup.py install

To convert DBF file to CSV:
./dbf2csv database.dbf
	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,
	<!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 {
	<!DOCTYPE html>
	<meta charset="utf-8">
	<style>

	.counties {
	fill: none;
	stroke: black;
	opacity:0.2;
	}
	#!/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
	# Compiled source #
	###################
	*.com
	*.class
	*.dll
	*.exe
	*.o
	*.so

	# Packages #