Skip to content

Instantly share code, notes, and snippets.

View techieshark's full-sized avatar

Peter W techieshark

90 followers · 101 following
View GitHub Profile
@techieshark
techieshark / australian-postcodes.sql
Created June 1, 2018 03:32 — forked from randomecho/australian-postcodes.sql
Australian postcodes (with states and suburb names) geocoded with latitude and longitude.
/*
Taken and cribbed from blog.datalicious.com/free-download-all-australian-postcodes-geocod
May contain errors where latitude and longitude are off. Use at own non-validated risk.
*/
SET NAMES utf8;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
DROP TABLE IF EXISTS postcodes_geo;
@techieshark
techieshark / README.md
Last active August 29, 2015 14:05 — forked from mbostock/.block
Contributions by size and day to Scott Wiener's 2010 SF Campaign

Data retrieved Aug 9th, 2014 at the SF Ethics / Campaign Finance hackathon.

I did little to this visualization other than changing the data from that used in the original gist.

Original gist's description: This example demonstrates loading of CSV data, which is then quantized into a diverging color scale. The values are visualized as colored cells per day. Days are arranged into columns by week, then grouped by month and years. Colors by Cynthia Brewer. Layout inspired by Rick Wicklin and Robert Allison.