Orleans Parish precincts colored based on which gubernatorial candidate won in the 2015 general election. Includes simple hover styles.
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.
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