ThomasThoren

AWSCLI

sync

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

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

Uses a small inset map to provide context for the larger, zoomed map. The same bounding coordinates for the raster image are used to create the reference box in the inset map.

ThomasThoren

Practice with map locations and labels.

ThomasThoren

.PHONY: all clean

.SECONDARY:

# Download 90-meter SRTM tiles for Louisiana
zip/srtm_%.zip:
	@mkdir -p $(dir $@)
	@curl -sS -o $@.download 'http://srtm.csi.cgiar.org/SRT-ZIP/SRTM_V41/SRTM_Data_GeoTiff/$(notdir $@)'
	@mv $@.download $@

ThomasThoren

height: 800

ThomasThoren

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

ThomasThoren

Example of how to create dynamic map distance scales.

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