Orleans Parish precincts colored based on which gubernatorial candidate won in the 2015 general election. Includes simple hover styles.
Practice with map locations and labels.
.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 $@ |
height: 450 | |
height: 550 |
The code that powers the text animations shown here: http://projects.fivethirtyeight.com/.
height: 700 | |
border: no |
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.
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.
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
SELECT
and FROM