1. Log into GitHub
2. Fork this Gist
3. Edit your version to share your team's activity
PDF Liberation Hackpad
IRC: https://webchat.freenode.net/ Channel: #sunlightlabs
GitHub Markdown-Cheatsheet
1. Log into GitHub
2. Fork this Gist
3. Edit your version to share your team's activity
PDF Liberation Hackpad
IRC: https://webchat.freenode.net/ Channel: #sunlightlabs
GitHub Markdown-Cheatsheet
// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible). | |
// Tweak the makePrettyJSON_ function to customize what kind of JSON to export. | |
var FORMAT_ONELINE = 'One-line'; | |
var FORMAT_MULTILINE = 'Multi-line'; | |
var FORMAT_PRETTY = 'Pretty'; | |
var LANGUAGE_JS = 'JavaScript'; | |
var LANGUAGE_PYTHON = 'Python'; |
# The priority is based upon order of creation: first created -> highest priority. | |
# See how all your routes lay out with "rake routes". | |
# You can have the root of your site routed with "root" | |
# root 'welcome#index' | |
# Example of regular route: | |
# get 'products/:id' => 'catalog#view' |
.q0-5{fill:#A09174} | |
.q1-5{fill:#BFB29E} | |
.q2-5{fill:#DCEAD6} | |
.q3-5{fill:#98C58D} | |
.q4-5{fill:#46A847} | |
.q0-6{fill:rgb(255,0,0)} | |
.q1-6{fill:#FC8400;} | |
.q2-6{fill:#FDC300;} | |
.q3-6{fill:#FEF200;} |
--PART 2 | |
-- a. | |
# select all the tornadoes | |
SELECT * FROM tornados | |
# select the cartodb_id for all the tornadoes | |
SELECT cartodb_id FROM tornados | |
-- b. | |
# select the first tornado | |
SELECT * FROM tornados LIMIT 1 | |
# select the second tornado |
/** | |
* Looks up an address' probable ZIP code using the Google | |
* geocoder. | |
* | |
* @param {string} address An address string (May consist of multiple cells, such as street, city, and state). | |
* @return The ZIP of first matched address. | |
* @customfunction | |
*/ | |
function getZip(address) { | |
if (address == '') { |
[{"cat":"__metadata","pid":75192,"tid":0,"ts":0,"ph":"M","name":"num_cpus","args":{"number":8}}, | |
{"cat":"__metadata","pid":75192,"tid":12551,"ts":0,"ph":"M","name":"process_sort_index","args":{"sort_index":-5}}, | |
{"cat":"__metadata","pid":75192,"tid":12551,"ts":0,"ph":"M","name":"process_name","args":{"name":"Renderer"}}, | |
{"cat":"__metadata","pid":75192,"tid":12551,"ts":0,"ph":"M","name":"process_labels","args":{"labels":"Backbone.js • TodoMVC"}}, | |
{"cat":"__metadata","pid":75192,"tid":1287,"ts":0,"ph":"M","name":"thread_sort_index","args":{"sort_index":-1}}, | |
{"cat":"__metadata","pid":75141,"tid":0,"ts":0,"ph":"M","name":"num_cpus","args":{"number":8}}, | |
{"cat":"__metadata","pid":75141,"tid":12551,"ts":0,"ph":"M","name":"process_sort_index","args":{"sort_index":-5}}, | |
{"cat":"__metadata","pid":75141,"tid":12551,"ts":0,"ph":"M","name":"process_name","args":{"name":"Renderer"}}, | |
{"cat":"__metadata","pid":75141,"tid":12551,"ts":0,"ph":"M","name":"process_labels","args":{"labels":"Handlebars.js: Minimal Templating on |
YEAR,LOCATION,STATE ANSI,REFERENCE PERIOD,COMMODITY,DOMAINCAT,APPLICATIONS in LB,"APPLICATIONS in LB / ACRE / APPLICATION, AVG","APPLICATIONS in LB / ACRE / YEAR, AVG","APPLICATIONS in NUMBER, AVG","TREATED in PCT OF AREA PLANTED, AVG" | |
1990,TEXAS,48,YEAR,"SPINACH, FRESH MARKET","CHEMICAL, INSECTICIDE: (PERMETHRIN = 109701)",200,0.1,0.15,1.5,19 | |
1990,TEXAS,48,YEAR,"SPINACH, FRESH MARKET","CHEMICAL, INSECTICIDE: (METHOMYL = 90301)",800,0.25,0.45,1.8,29 | |
1990,TEXAS,48,YEAR,"SPINACH, FRESH MARKET","CHEMICAL, INSECTICIDE: (ENDOSULFAN = 79401)",200,0.7,0.7,1,5 | |
1990,TEXAS,48,YEAR,"SPINACH, FRESH MARKET","CHEMICAL, INSECTICIDE: (DIAZINON = 57801)","1,800",1.63,1.51,0.9,20 | |
1990,ARIZONA,4,YEAR,"SPINACH, FRESH MARKET","CHEMICAL, INSECTICIDE: (PERMETHRIN = 109701)",100,0.14,0.24,1.7,56 | |
1990,ARIZONA,4,YEAR,"SPINACH, FRESH MARKET","CHEMICAL, INSECTICIDE: (MEVINPHOS = 15801)","1,000",0.88,2.23,2.5,58 | |
1990,ARIZONA,4,YEAR,"SPINACH, FRESH MARKET","CHEMICAL, INSECTICIDE: (METHOMYL = 90301)",500,0.62,1.55,2.5,43 | |
1990,ARIZONA,4,YEA |
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="utf-8"> | |
<title>Pesticide Applications on Spinach</title> | |
<script type="text/javascript" src="http://d3js.org/d3.v3.js"></script> | |
</head> | |
<body> | |
<p>Check out how much pesticide is used on spinach, by looking in the console!</p> |