Jill Craig, Western Maryland Regional Library.
• Making Maps with the CONTENTdm API, Marcus Ladd, Miami University of Ohio
This was a session on how to build a map of a geographically-oriented collection in CONTENTdm with publicly available PHP and Javascript resources.
Marcus had a postcard collection of cards from Ohio. His code, which he shared on github, https://github.com/laddmm/CONTENTdm_MAP, uses the address of the image from his CONTENTdm url and that links to an sql table using javascript. This way CONTENTdm api harvests the data and Google maps creates a map using the address to create coordinates. Marcus has additional steps as he described the application as “buggy”. Miami University, Ohio, Bowden Postcards Collection
The question I would have is whether this program would work with our data which does not contain recognizable street addresses. The Confederate dead were buried in locations like “Mrs. Lucketts barn”. In that case I would need to create the lat/long myself, add to the CONTENTdm database and then use the google api. There are several other applications where pinpointing the location will be helpful.
• Introduction Data Cleaning and Preservation, Morgan Daniels, Vanderbilt University
My need to clean up data is much less than Tracy’s but I can still see a use for OpenRefine (http://www.openrefine.org/ ), OpenRefine is an open source application that runs through Google. It adds power to the kinds of things I have been doing in Excel and makes decisions for you, so instead of having to sort a field, see what the options are, select which is correct, and then search and replace. It would replace all variants for “Hagerstown” for example with the most commonly used term. I would need to be cautious in using with names that may have been correct at some point, like “Hagers-town” and “Boonesborough” – transcription spellings are unique
and their spellings are unique
This was a session on how to build a map of a geographically-oriented collection in CONTENTdm with publicly available PHP and Javascript resources.
Marcus had a postcard collection of cards from Ohio. His code, which he shared on github, https://github.com/laddmm/CONTENTdm_MAP, uses the address of the image from his CONTENTdm url and that links to an sql table using javascript. This way CONTENTdm api harvests the data and Google maps creates a map using the address to create coordinates. Marcus has additional steps as he described the application as “buggy”. Miami University, Ohio, Bowden Postcards Collection
The question I would have is whether this program would work with our data which does not contain recognizable street addresses. The Confederate dead were buried in locations like “Mrs. Lucketts barn”. In that case I would need to create the lat/long myself, add to the CONTENTdm database and then use the google api. There are several other applications where pinpointing the location will be helpful.
• Introduction Data Cleaning and Preservation, Morgan Daniels, Vanderbilt University
My need to clean up data is much less than Tracy’s but I can still see a use for OpenRefine (http://www.openrefine.org/ ), OpenRefine is an open source application that runs through Google. It adds power to the kinds of things I have been doing in Excel and makes decisions for you, so instead of having to sort a field, see what the options are, select which is correct, and then search and replace. It would replace all variants for “Hagerstown” for example with the most commonly used term. I would need to be cautious in using with names that may have been correct at some point, like “Hagers-town” and “Boonesborough” – transcription spellings are unique
and their spellings are unique