Skip to content

Instantly share code, notes, and snippets.

View ajzeigert's full-sized avatar
💀
Literally dead

Andy Zeigert ajzeigert

💀
Literally dead
20 followers · 55 following
View GitHub Profile
@ajzeigert
ajzeigert / overpass_query
Last active August 29, 2015 14:13
Overpass query for QGIS demo
<osm-script output="json" timeout="25">
<!-- bike routes -->
<query type="way">
<has-kv k="bicycle" regv="^(yes)$"/>
<has-kv k="highway" regv="^(path)$"/>
<bbox-query {{bbox}}/>
</query>
@ajzeigert
ajzeigert / CPI_Historical_Data_1974-2014.csv
Created August 22, 2015 00:00
Consumer Price Index for food, 1974-2014; Source: USDA
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 42 columns, instead of 17 in line 5.
Item,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014
All food,14.3,8.5,3,6.3,9.9,11,8.6,7.8,4.1,2.1,3.8,2.3,3.2,4.1,4.1,5.8,5.8,2.9,1.2,2.2,2.4,2.8,3.3,2.6,2.2,2.1,2.3,3.2,1.8,2.2,3.4,2.4,2.4,4,5.5,1.8,0.8,3.7,2.6,1.4,2.4
Food away from home,12.7,9.4,6.8,7.6,9.1,11.1,9.9,9,5.4,4.4,4.2,3.9,3.9,4,4.1,4.6,4.7,3.4,2,1.8,1.7,2.3,2.5,2.8,2.6,2.5,2.4,2.9,2.5,2.1,3,3.1,3.1,3.6,4.4,3.5,1.3,2.3,2.8,2.1,2.4
Food at home,14.9,8.2,2.1,5.9,10.5,10.8,8.1,7.2,3.5,1,3.7,1.5,2.9,4.3,4.2,6.5,6.5,2.6,0.7,2.4,2.9,3.3,3.7,2.5,1.9,1.9,2.3,3.3,1.3,2.2,3.8,1.9,1.7,4.2,6.4,0.5051562521,0.3,4.8,2.5,0.9,2.4
"Meats, poultry, and fish",2.2,8.5,0.9,-0.6,16.7,14.9,3.7,4.1,4.1,-0.7,1.7,-0.4,4.4,6.5,3.5,5,7.3,2.3,-0.8,3.3,1.5,0.9,3.5,2.9,-0.8,0.7,4.5,4.4,0.5,4,7.4,2.4,0.8,3.8,4.2,0.5177692529,1.922184867,7.4,3.6,2.1,7.2
Meats,1.8,8.5,0.2,-2.3,18.6,17,2.9,3.6,4.9,-1.2,0.3,-0.9,3.1,7.5,2.4,
@ajzeigert
ajzeigert / CPI_Historical_Data_1974-2014.csv
Created August 26, 2015 00:33
Module 2 exercise, SVG drawing and load CSV file
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 42 columns, instead of 17 in line 5.
Item,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014
All food,14.3,8.5,3,6.3,9.9,11,8.6,7.8,4.1,2.1,3.8,2.3,3.2,4.1,4.1,5.8,5.8,2.9,1.2,2.2,2.4,2.8,3.3,2.6,2.2,2.1,2.3,3.2,1.8,2.2,3.4,2.4,2.4,4,5.5,1.8,0.8,3.7,2.6,1.4,2.4
Food away from home,12.7,9.4,6.8,7.6,9.1,11.1,9.9,9,5.4,4.4,4.2,3.9,3.9,4,4.1,4.6,4.7,3.4,2,1.8,1.7,2.3,2.5,2.8,2.6,2.5,2.4,2.9,2.5,2.1,3,3.1,3.1,3.6,4.4,3.5,1.3,2.3,2.8,2.1,2.4
Food at home,14.9,8.2,2.1,5.9,10.5,10.8,8.1,7.2,3.5,1,3.7,1.5,2.9,4.3,4.2,6.5,6.5,2.6,0.7,2.4,2.9,3.3,3.7,2.5,1.9,1.9,2.3,3.3,1.3,2.2,3.8,1.9,1.7,4.2,6.4,0.5051562521,0.3,4.8,2.5,0.9,2.4
"Meats, poultry, and fish",2.2,8.5,0.9,-0.6,16.7,14.9,3.7,4.1,4.1,-0.7,1.7,-0.4,4.4,6.5,3.5,5,7.3,2.3,-0.8,3.3,1.5,0.9,3.5,2.9,-0.8,0.7,4.5,4.4,0.5,4,7.4,2.4,0.8,3.8,4.2,0.5177692529,1.922184867,7.4,3.6,2.1,7.2
Meats,1.8,8.5,0.2,-2.3,18.6,17,2.9,3.6,4.9,-1.2,0.3,-0.9,3.1,7.5,2.4,
@ajzeigert
ajzeigert / cpi.csv
Created September 3, 2015 20:26
Chart comparing CPI change from 1974-2014
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 24 columns, instead of 21 in line 6.
Year,All food,Food away from home,Food at home,"Meats, poultry, and fish",Meats,Beef and veal,Pork,Other meats,Poultry,Fish and seafood,Eggs,Dairy products,Fats and oils,Fruits and vegetables,Fresh fruits & vegetables,Fresh fruits,Fresh vegetables,Processed fruits & vegetables,Sugar and sweets,Cereals and bakery products,Nonalcoholic beverages,Other foods,
1974,14.3,12.7,14.9,2.2,1.8,2.9,-0.5,3.1,-5.1,15.3,0.4,18.6,41.9,16.5,7.8,8.7,7.3,N/A,52.4,29.9,19.3,21.4,All food
1975,8.5,9.4,8.2,8.5,8.5,1,22.4,5.9,10.5,8.5,-1.8,3.1,10.7,3.1,2.3,6.8,-1.1,N/A,26.1,11.3,15,12.8,Food away from home
1976,3,6.8,2.1,0.9,0.2,-3.2,1.3,5.9,-4.1,11.7,9.2,8.1,-12.5,2.6,2.4,-0.2,4.3,N/A,-11.3,-2.2,19.6,4.1,Food at home
1977,6.3,7.6,5.9,-0.6,-2.3,-0.7,-5.4,-0.6,0.7,10.8,-3.2,2.7,10.1,9.2,13.6,14.9,12.6,N/A,5,1.6,50.6,3.4,"Meats, poultry, and fish"
1978,9.9,9.1,10.5,16.7,18.6,22.9,12.9,17.7,10.4,9.4,-5.4,6.8,9.6,11.1,12.9,19.5,8,N/A,12.3,9,5.8,8,Meats
1979,11,11.1,10.8,14.9,17,27.4,1.6,14.7,4.9,9.7,9.5,11.6,7.9,8,7.6,12.4,3,N/A,7.8,1
@ajzeigert
ajzeigert / income.csv
Created September 11, 2015 22:23
Median household income by Oregon county
county income
Oregon 50229
Baker County 41500
Benton County 48604
Clackamas County 64352
Clatsop County 44683
Columbia County 54968
Coos County 37940
Crook County 38795
Curry County 39516
@ajzeigert
ajzeigert / income.csv
Created September 12, 2015 00:09
Chart of median household income by Oregon county, 2013
Oregon 50229
Baker County 41500
Benton County 48604
Clackamas County 64352
Clatsop County 44683
Columbia County 54968
Coos County 37940
Crook County 38795
Curry County 39516
@ajzeigert
ajzeigert / index.html
Last active September 19, 2015 00:11
Median household income vs. overall population by Oregon county, 2013
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>CPI change</title>
<script type="text/javascript" src="http://d3js.org/d3.v3.js"></script>
</head>
<style>
body {
font-family: 'Helvetica', Arial, sans-serif;
@ajzeigert
ajzeigert / index.html
Created September 26, 2015 23:36
Cigarette taxes by state, 1970-2015
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Cigarette taxes by state, 1970-2014</title>
<script type="text/javascript" src="http://d3js.org/d3.v3.js"></script>
<style type="text/css">
body {
background-color: white;
@ajzeigert
ajzeigert / index.html
Created October 23, 2015 21:56
Simple demo of d3 ability to display geojson
<!DOCTYPE html>
<html>
<head>
<title>Pipeline test</title>
<meta charset="UTF-8">
<meta name="description" content="" />
<meta name="keywords" content="" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js" charset="utf-8"></script>
<style>
.pipes {
@ajzeigert
ajzeigert / index.html
Created October 23, 2015 22:52
Experimenting with d3.geo layer on a leaflet map
<!DOCTYPE html>
<html>
<head>
<title>Pipeline test</title>
<meta charset="UTF-8">
<meta name="description" content="" />
<meta name="keywords" content="" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.min.js" charset="utf-8"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/topojson/1.6.19/topojson.min.js"></script>
<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.5/leaflet.css" />