ThomasThoren

AWSCLI

sync

aws s3 sync \
  /home/tom/ \
  s3://mybucket/ \
  --exclude "*.DS_Store"

ThomasThoren

height: 725

ThomasThoren

height: 1000

ThomasThoren

Example of how to create dynamic map distance scales.

ThomasThoren

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

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

height: 700
border: no

ThomasThoren

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

ThomasThoren

height: 550