University of Luxembourg
November 29, 2016
Online slides optimised for Full-HD screens in full-screen mode
Download PDF here
Doing Digital History: Introduction to Tools and Technology
Gregory - Exploiting Time and Space
Separation of time (historians) and space (geographers)
Cronon: two theories of growth of Chicago
Taking only one perspective is a serious limitation
Gregory - GIS does not answer the why question: this is where more traditional approaches are of use
Bodenhamer - The Potential of Spatial Humanities
Critique of GIS as being positivist or realist:
Bodenhamer - How can we make GIS do what it was not intended to do, namely, represent the world as culture and not simply mapped locations?
Rather than using GIS in a quantitative sense, we will try to tell a story with a map
Before you start: StoryMap is not a data tool where you upload data to work on
Instead, you write texts and manually put the texts on the map
When working with the emails: look up selected emails by following the wikileaks url, read them, and summarise them per location
Start by "Make a StoryMap now"
Login with Google account
Create a new StoryMap
Choose a title for now & create a first slide
The system works with slides similar to PowerPoint
Create a new slide per new location, drag to reorder
With the pin you can select the location you want to describe
Drag to move the pin to where you want, zoom using the + and - symbols in the upper-left corner
Alternatively, you can search a location by its name
Tell the story: give the slide a title/headline and write the story. You can use HTML here
To make the story more visual, include relevant photos
Change the map with fonts, and different map types
Make sure to regularly save your work. And save when you're done
When you're done: click the Share button to get a link or HTML code for embedding in your report
Embedding: You might want to play a bit with the width and height settings
As showcased last week by Kate Jones
You can login with your Google account
Either drag and drop the file onto the browser window, or select the "Browse" button
CartoDB does not work with the ODS file, upload the CSV instead
However, if you have been working with the ODS in Spreadsheets (because your laptop is French/German), then import the spreadsheet by connecting to Google Drive
Your first result will be a table
Click "Create map" to start working on the map
Your first map will show pins of all the locations
To edit the map click the title of the layer with the same name as your dataset
Select "Pop-up" and play with the settings to get information when clicking a pin on the map
To get other types of maps, select "Style"
Here I've chosen the heatmap
When you have multiple colours, maybe add a legend to explain the colours
If you haven't made a selection with Google Spreadsheets before, this can be done in Carto as well
To make a selection of emails, change "Values" to "SQL". You will get this screen
Type a query for example to select emails where the subject contains "bomb"
Click "apply" to apply the SQL. With the lower right buttons you can switch between table view and map view of your selection
The SQL query should have the following form:
SELECT * FROM name-of-dataset where name-of-column ilike '%word-of-interest%'
Don't touch the first parts
For name-of-column, you can select subject, _from, _to, or date (NOTE THE _ on the _from and _to columns!)
For word-of-interest you can fill in anything you find of interest
Do not leave out the '% %'!
SELECT * FROM f1_geocoded where _from ilike '%clinton%'
SELECT * FROM f1_geocoded where _to ilike '%clinton%'
SELECT * FROM f1_geocoded where subject ilike '%bomb%'
SELECT * FROM f1_geocoded where _from ilike '%abedin%' and _to ilike '%clinton%'
Selecting emails from specific time period works a bit differently:
SELECT * FROM f1_geocoded where date >= '2010-01-01' and date < '2011-01-01'
Read: select emails where the date is January 1st of 2010 or later, and before January 1st 2011
Can also be used to choose a specific month, or a period spanning multiple months or years
If you want to compare different information, you can create layers in a map
For example, suppose we want to see the difference between emails from Cheryll Mills and from Huma Abedin
First, in the first layer we will select emails from Cheryll Mills and apply
To know which layer shows what, we will rename the layer to describe what it shows. Next, click the blue Add button (encircled)
To create a 2nd layer, just select the same dataset and click add layer
In the 2nd layer, we now select emails from Huma Abedin and apply
Finally, to show the difference, in one of the 2 layers change the style of the pins and choose a different colour
To share your map, select the icon in the blue bar and follow the options. Finally click "Share"
Either copy the link, or the HTML-code to embed the map in your report
800-1500 words, in English (not including the text in the StoryMap)
Email to firstname.lastname@example.org before the start of the lecture of 13 December