For a self-described data lover like junior Matt Raybaud, this summer job was a perfect fit.
Raybaud, a geography and sociology double major from St. Clair Shores, Mich., landed a position through Calvin’s summer research program.
The job was mapping data for Calvin College emeritus professor Henk Aay’s atlas project, “The Atlas of Dutch American History and Culture.”
Over the course of 10 weeks, Raybaud’s job was to take databases of information from other researchers, U.S. census records, and Dutch provincial records and ship manifests, and convert them into maps. Five hundred maps.
To begin, Raybaud converted a series of punch cards created by researcher Robert Swierenga into Comma Separated Value (CSV) files.
He made Excel sheets from the CSV files, then took information from the Excel sheets and plugged it into Calvin’s Geographic Information Systems (GIS) software, which, as he put it, “is just a fancy term for cartography on the computer.”
Aay’s atlas project has been a multi-year endeavor so far, and he’s enlisted the help of several students from Calvin and from Hope College, where he is senior research fellow at the Van Raalte Institute.
Raybaud gets Calvin College credit for converting the Swierenga punch cards into useable data for mapping—and the result is clear. His maps show counties of origin, numbers of immigrants and their destinations, demographics, occupation, location of churches, and more.
Aay said the maps are an important step forward in the atlas project.
“An atlas by its very nature begins to translate into a visual and more understandable form the scholarship of academics,” he said. “I have only praise for [Matt’s] output and for his ability to put his shoulder to those tasks.”
Aay also said that beyond its usefulness for the atlas project, the data Raybaud converted will pay dividends for other researchers.
Most of this data is from the 1980s [when Robert Swierenga collected it]. It had been gathering dust and no one was really using it,” Aay said.
“By updating it into readable form for today’s software, we could make much more use of it, and now we are likely going to post all these databases for everyone to use in the future.
“I think what we’ve done here is not only prepared maps for the atlas and for other publications; it has made these databases retain their usefulness in perpetuity.”
About the Author
Rachel Watson, Calvin College