Tag Archives: broadsides

Vote!

In anticipation of next Tuesday’s midterm elections, here is a photo gallery of voting-related images from Duke Digital Collections. Click on a photo to view more images from our collections dealing with political movements, voting rights, propaganda, activism, and more!

This image is part of a series of photographs taken by James Karales on assignment for Look Magazine during the voting rights march from Selma to Montgomery, Alabama in March 1965.
Propaganda poster of the Italian Socialist Party. It reads: “Workers, vote for socialism means voting for women’s rights and labor.”
Image is part of “Thirteen-Month Crop: One Year in the Life of a Piedmont Virginia Tobacco Farm,” which documents the Moore family farm in Pittsylvania County, Virginia.
Poster with depiction of large PCI flag with the Italian flag behind it.
Leaflet created by the League of Women Voters of North Carolina.
Socialist Party literature, explaining their views.

If you haven’t already taken advantage of early voting, we at Bitstreams encourage you to exercise your right on November 6!

Mapping the Broadsides Collection, or, how to make an interactive map in 30 minutes or less

Ever find yourself with a pile of data that you want to plot on a map? You’ve got names of places and lots of other data associated with those places, maybe even images? Well, this happened to me recently. Let me explain.

A few years ago we published the Broadsides and Ephemera digital collection, which consists of over 4,100 items representing almost every U.S. state. When we cataloged the items in the collection, we made sure to identify, if possible, the state, county, and city of each broadside. We put quite a bit of effort into this part of the metadata work, but recently I got to thinking…what do we have to show for all of that work? Sure, we have a browseable list of place terms and someone can easily search for something like “Ninety-Six, South Carolina.” But, wouldn’t it be more interesting (and useful) if we could see all of the places represented in the Broadsides collection on one interactive map? Of course it would.

So, I decided to make a map. It was about 4:30pm on a Friday and I don’t work past 5, especially on a Friday. Here’s what I came up with in 30 minutes, a Map of Broadside Places. Below, I’ll explain how I used some free and easy-to-use tools like Excel, Open Refine, and Google Fusion Tables to put this together before quittin’ time.

Step 1: Get some structured data with geographic information
Mapping only works if your data contain some geographic information. You don’t necessarily need coordinates, just a list of place names, addresses, zip codes, etc. It helps if the geographic information is separated from any other data in your source, like in a separate spreadsheet column or database field. The more precise, structured, and consistent your geographic data, the easier it will be to map accurately. To produce the Broadsides Map, I simply exported all of the metadata records from our metadata management system (CONTENTdm) as a tab delimited text file, opened it in Excel, and removed some of the columns that I didn’t want to display on the map.

Step 2: Clean up any messy data..
For the best results, you’ll want to clean your data. After opening my tabbed file in Excel, I noticed that the place name column contained values for country, state, county, and city all strung together in the same cell but separated with semicolons (e.g. United States; North Carolina; Durham County (N.C.); Durham (N.C.)). Because I was only really interested in plotting the cities on the map, I decided to split the place name column into several columns in order to isolate the city values.

To do this, you have a couple of options. You can use Excel’s “text to columns” feature, instructing it to split the column into new columns based on the semicolon delimiter or you can load your tabbed file into Open Refine and use its “split columns into several columns” feature. Both tools work well for this task, but I prefer OpenRefine because it includes several more advanced data cleaning features. If you’ve never used OpenRefine before, I highly recommend it. It’s “cluster and edit” feature will blow your mind (if you’re a metadata librarian).

Step 3: Load the cleaned data into Google Fusion Tables
Google Fusion Tables is a great tool for merging two or more data sets and for mapping geographic data. You can access Fusion Tables from your Google Drive (formerly Google Docs) account. Just upload your spreadsheet to Fusion Tables and typically the application will automatically detect if one of your columns contains geographic or location data. If so, it will create a map view in a separate tab, and then begin geocoding the location data.

geocoding_fusion_tables

If Fusion Tables doesn’t automatically detect the geographic data in your source file, you can explicitly change a column’s data type in Fusion Tables to “Location” to trigger the geocoding process. Once the geocoding process begins, Fusion Tables will process every place name in your spreadsheet through the Google Maps API and attempt to plot that place on the map. In essence, it’s as if you were searching for each one of those terms in Google Maps and putting the results of all of those searches on the same map.

Once the geocoding process is complete, you’re left with a map that features a placemark for every place term the service was able to geocode. If you click on any of the placemarks, you’ll see a pop-up information window that, by default, lists all of the other metadata elements and values associated with that record. You’ll notice that the field labels in the info window match the column headers in your spreadsheet. You’ll probably want to tweak some settings to make this info window a little more user-friendly.

info_window_styled

Step 4: Make some simple tweaks to add images and clickable links to your map
To change the appearance of the information window, select the “change” option under the map tab then choose “change info window.” From here, you can add or remove fields from the info window display, change the data labels, or add some custom HTML code to turn the titles into clickable links or add thumbnail images. If your spreadsheet contains any sort of URL, or identifier that you can use to reliably construct a URL, adding these links and images is quite simple. You can call any value in your spreadsheet by referencing the column name in braces (e.g. {Identifier-DukeID}). Below is the custom HTML code I used to style the info window for my Broadsides map. Notice how the data in the {Identifier-DukeID} column is used to construct the links for the titles and image thumbnails in the info window.

info_window_screen

Step 5: Publish your map
Once you’re satisfied with you map, you can share a link to it or embed the map in your own web page or blog…like this one. Just choose tools->publish to grab the link or copy and paste the HTML code into your web page or blog.

To learn more about creating maps in Google Fusion Tables, see this Tutorial or contact the Duke Library’s Data and GIS Services.

Exams? Graduation? Already?

Yes, it is here; exams and graduation. It can be a time of stress, a time to recognize your hard work, even a time of celebration. But first, take a moment for diversion.

On Exams

Feeling stressed?
Learn how to deal with stressful exams through vintage advertising such as this ad for Lifebuoy soap: Whew! This Exam Is A Tough One! At least you won’t lose any dates if you follow their directions.

Ad for Lifebuoy soap

Tough questions?cover of teacher exam
Could you pass this 1892 teacher’s examination found in our Broadsides collection? Answers to the math questions have already been filled in. But alas, they didn’t show their work. Shouldn’t that lead to partial credit?

Who had an exam?
We even hear from Thomas Long about “Jesus’ Final Exam.” Can’t anyone get a break from exams? Long’s sermon begins at 32 minutes into the audio recording of this 1986 worship service from the Duke Chapel recordings collection.

Commencement

Once you’ve passed all of your exams, thoughts turn to time-honored traditions of graduation.

52 years ago at Duke
four-page issue of The Duke Chronicle notes what the Duke community could expect during the four days of commencement activities in June, 1962. But when you still have exams and papers due, graduation can still seem so far away.

Cover of Duke Chronicle 1962 commencement issue

Drama at commencement?
This commencement program from June, 1905 for the Memminger High and Normal School Academy of Music highlights not only a valedictory speech, but also the presentation of two essays, five musical performances, and two dramatic plays. Now, what drama would exemplify your academic experience?

Ahhh…

Once you work is done, whether you are graduating or simply completing another year of rigorous study at Duke, it’s time to unwind.

Taking to the streets
This photo from the William Gedney collection shows people celebrating in the streets of Benares, India. Gedney had just told them that you would ace your exams this year and so they started partying. Now that you know how they’ve celebrated your success, how do you plan to celebrate?

Image of people celebrating in the streets of Benares, India

Definitely time for cake
Will this vintage Pillsbury commercial from our AdViews collection tempt you into including their Deluxe Chocolate Cake in your party plans? Or, will you resist the cake and simply use the commercial as inspiration for your wardrobe choices for your end-of-year soirées?

May all of your papers, projects and exams go well. Good luck and best wishes from Duke University Libraries.