Derek Swingley swingley

Merlin's Wisdom Project

Or: “Everybody likes being given a glass of water.”

By Merlin Mann.

It's only advice for you because it had to be advice for me.

Fitting 2016 FEC campaign donor data into your humble spreadsheet

The 2016 U.S. Election is so hot and rich that even with a month to go, the Federal Election Commission has recorded 12.6 million individual campaign donations.

For comparison's sake, the 2014 cycle had just 2.1 million donors. And the last presidential cycle, 2012, had 3.3 million donors.

The bottom line is that we can't import all the data directly into Excel (nevermind Google Sheets). But we can at least import the subset of data that we need (under a million rows) without having to crack out a database.

The Ultimate Unit Testing Cheat-sheet

Sinon Chai
Chai
Sinon

Remove MySQL completely

Open the Terminal
Use mysqldump to backup your databases
Check for MySQL processes with: ps -ax | grep mysql
Stop and kill any MySQL processes
Analyze MySQL on HomeBrew:
```
brew remove mysql
```

Whole Earth Guide

I'm not sure about this; GIS really got burned from being both a 'science' and a 'product' from the beginning, and there are blurry lines between what I think is essential and what I don't know because I never do it and am not a GIS person. Anyway.

A No-Bullshit Intro to Maps and GIS

What Maps Are
Data
Information
Transformation

	on run
	set imessage_id to "" -- leave blank to skip sending periodic iMessage progress updates, put your iMessage ID here to get updates as the script runs
	set delay_seconds to 5 -- Don't set to 0, it runs too fast. 0.75 is a good setting for "go fast".

	set computer_name to do shell script "scutil --get ComputerName"
	set os_version to do shell script "sw_vers -productVersion"
	set os_build to do shell script "sw_vers -buildVersion"
	set _uptime to do shell script "uptime"

	set url_list to {"http://techmeme.com", "http://www.consumerreports.org/laptops/macbook-pros-fail-to-earn-consumer-reports-recommendation/", "https://twitter.com/panzer/status/812367550734401536", "http://www.politico.com/story/2016/12/foreign-travelers-social-media-232930", "http://www.macworld.com/article/3153384/gaming/nintendo-plans-to-release-2-or-3-mobile-games-a-year-after-super-mario-runs-success.html", "http://www.wsj.com/articles/cyber-experts-cite-link-between-dnc-hacks-and-aggression-against-uk

	on run
	set imessage_id to "" -- leave blank to skip sending periodic iMessage progress updates, put your iMessage ID here to get updates as the script runs
	set delay_seconds to 5 -- Don't set to 0, it runs too fast. 0.75 is a good setting for "go fast".

	set computer_name to do shell script "scutil --get ComputerName"
	set os_version to do shell script "sw_vers -productVersion"
	set os_build to do shell script "sw_vers -buildVersion"
	set _uptime to do shell script "uptime"

	set url_list to {"http://techmeme.com", "http://www.consumerreports.org/laptops/macbook-pros-fail-to-earn-consumer-reports-recommendation/", "https://twitter.com/panzer/status/812367550734401536", "http://www.politico.com/story/2016/12/foreign-travelers-social-media-232930", "http://www.macworld.com/article/3153384/gaming/nintendo-plans-to-release-2-or-3-mobile-games-a-year-after-super-mario-runs-success.html", "http://www.wsj.com/articles/cyber-experts-cite-link-between-dnc-hacks-and-aggression-against-uk

	// Licensed under a CC0 1.0 Universal (CC0 1.0) Public Domain Dedication
	// http://creativecommons.org/publicdomain/zero/1.0/
	(function (win, doc) {
	'use strict';
	if (!win.XMLHttpRequest \|\| !win.FormData \|\| !win.addEventListener \|\| !doc.querySelectorAll) {
	// doesn't cut the mustard.
	return;
	}
	function hijaxForm (formElement) {
	var progressBar;

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset='utf-8' />
	<title></title>
	<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
	<script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.11.4/mapbox-gl.js'></script>
	<link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.11.4/mapbox-gl.css' rel='stylesheet' />
	<style>
	body { margin:0; padding:0; }

	#!/bin/bash

	# Settings: edit these as needed
	PROJECT_NAME="test"
	OUTPUT_DIRECTORY="~/Documents/MapBox/export/"

	# first change into TileMill code directory
	cd /Applications/TileMill.app/Contents/Resources/

	# hint: use http://bboxfinder.com/ to get bounds in lon/lat