Skip to content

Instantly share code, notes, and snippets.

View mroswell's full-sized avatar

Marjorie Roswell mroswell

View GitHub Profile
@mroswell
mroswell / index.html
Last active August 27, 2015 14:59
Pesticide applications on spinach
<!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>
// 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';
@mroswell
mroswell / commented-out-content-in-routes.rb.txt
Created May 16, 2014 17:39
commented-out-content-in-routes.rb
# 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
@mroswell
mroswell / timeline-trace-cm.json
Created January 24, 2015 22:18
timeline-trace
This file has been truncated, but you can view the full file.
[{"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
@mroswell
mroswell / SPINACH-Insecticides-2015-08-24_filtered1.csv
Created August 24, 2015 13:13
insecticides applied to spinach in four states, filtered to remove totals rows, and empty values
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 11 columns, instead of 4. in line 8.
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
@mroswell
mroswell / index.html
Last active September 1, 2015 16:32
Pesticide Use on Spinach
<!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</p>
@mroswell
mroswell / index.html
Last active September 2, 2015 20:07
Average pesticide use on spinach per acre per year
<!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> Average pesticide use on spinach per acre per year</p>
apps | zero | account | blog | documents | wiki | team-wiki
-----|---|--- |--- |--- |--- | ---
django | 1.8.4| 1.8.4 | 1.8.4 | 1.8.4 | 1.8.4 | 1.8.4
django-announcements | | | | | |
django-bookmarks | | | | | |
django-email-confirmation (deprecated) | | | | | |
django-flag | | | | | |
django-forms-bootstrap (deprecated?) | | | | | |
django-friends | | | | | |