ThomasThoren

Orleans Parish precincts colored based on which gubernatorial candidate won in the 2015 general election. Includes simple hover styles.

ThomasThoren

Practice with map locations and labels.

ThomasThoren

.PHONY: all

.SECONDARY:

# Download .zip files
zip/tl_2015_us_county.zip:
	@mkdir -p $(dir $@)
	@curl -sS -o $@.download 'ftp://ftp2.census.gov/geo/tiger/TIGER2015/COUNTY/tl_2015_us_county.zip'
	@mv $@.download $@

ThomasThoren

height: 450

ThomasThoren

height: 550

ThomasThoren

The code that powers the text animations shown here: http://projects.fivethirtyeight.com/.

ThomasThoren

height: 700
border: no

ThomasThoren

This guide will walk you through the process of using Google Fusion Tables to turn a spreadsheet into a map.

Before we begin, make sure you are logged into your Google account. (Note to Lens staff: Our work accounts don't seem to allow Google Fusion Tables, so log in as a separate account for now.)

Read on for a detailed explanation of the steps.

1. Saving your spreadsheet as a CSV file

CSV (comma-separated values) files are the same as Excel files (.xlsx and .xls), for all intents and purposes. You can open either in Excel. The key difference is that CSV files aren't specific to any single program, so they can be used by any program.

ThomasThoren

Intro to SQL

This guide was made for the hands-on SQL workshop at IRE 2016 in New Orleans. It uses bridge inspection data from the Federal Highway Administration's Bridge Inventory Database. You can download the Louisiana data here, courtesy of IRE.

The rest of the hands-on SQL class material is located here: http://bit.ly/hands_on_sql_ire2016

Selecting your data

SELECT and FROM

ThomasThoren