Archiving Ipswich

Two years after posting about my work on the Silbury Hill digital archive, in ‘AN ADS DAY OF ARCHAEOLOGY’, and I’m still busy working as a Digital Archivist with the ADS!

For the past few months, I have been working on the Ipswich Backlog Excavation Archive, deposited by Suffolk County Council, which covers 34 sites, excavated between 1974 and 1990.


Excavation at St Stephen’s Lane, Ipswich 1987-1988

To give a quick summary of the work so far, the data first needed to be accessioned into our systems which involved all of the usual checks for viruses, removing spaces from file names, sorting the data into 34 separate collections and sifting out duplicates etc.  The archive packages were then created which involved migrating the files to their preservation and dissemination formats and creating file-level metadata using DROID.  The different representations of the files were linked together using object ids in our database and all of the archiving processes were documented before the coverage and location metadata were added to the individual site collections.

Though time consuming, due to the quantity of data, this process was fairly simple as most of the file names were created consistently and contained the site code.  Those that didn’t have descriptive file names could be found in the site database and sorted according to the information there.

The next job was to create the interfaces; again, this was fairly simple for the individual sites as they were made using a template which retrieves the relevant information from our database allowing the pages to be consistent and easily updateable.

The Ipswich Backlog Excavation Archive called for a more innovative approach, however, in order to allow the users greater flexibility with regards to searching, so the depositors requested a map interface as well as a way to query information from their core database.  The map interface was the most complex part of the process and involved a steep learning curve for me as it involved applications, software and code that I had not previously used such as JavaScript, OpenLayers, GeoServer and QGIS.  The resulting map allows the user to view the features excavated on the 34 sites and retrieve information such as feature type and period as well as linking through to the project archive for that site.

OpenLayers map of Ipswich excavation sites.

OpenLayers map of Ipswich excavation sites.

So, as to what I’m up to today…

The next, and final step, is to create the page that queries the database.  For the past couple of weeks I have been sorting the data from the core database into a form that will fit into the ADS object tables, cleaning and consolidating period, monument and subject terms and, where possible, matching them to recognised thesauri such as the English Heritage Monument Type Thesaurus.

Today will be a continuation of that process and hopefully, by the end of the day, all of the information required by the query pages will be added to our database tables so that I can begin to build that part of the interface next week.  If all goes to plan, the user should be able to view specific files based on searches by period, monument/feature type, find type, context, site location etc. with more specialist information, such as pottery identification, being available directly from the core database tables which will be available for download in their entirety.  Fingers crossed that it does all go to plan!

So, that’s my Day of Archaeology 2015, keep a look out for ADS announcements regarding the release of the Ipswich Backlog Excavation Archive sometime over the next few weeks and check out the posts from my ADS colleagues Jo Gilham and Georgie Field!

A Third Day In The Life (Of An Archaeological Geophysicist)

Wow, time has flown. This time last year, I was doing radar work in Ballarat on gold mine sludge. But that’s more geological than archaeological, and it should have been covered in last year’s non-existent post (what happened last year, admins??), so I won’t discuss that further.

Let’s see… what was I doing this year?

Ah, yes. Friday. It was the last day of an eight-day project using ground-penetrating radar to search for unmarked graves in a cemetery. The day didn’t really involve any geophysical surveying as such – all that had been done over the preceding week. Instead, Friday was spent using one of my new toys – a Topcon Power Station robotic total station. I love it. It has reflectorless mode so I don’t have to walk around the cemetery to map things. Set-up is a breeze with re-sections (I was previously using a 25-year old reflector-only total station that required two operators and couldn’t do re-sections).

Can you tell from my passion for a robotic total station that I don’t have a romantic partner?

Anyway, I don’t want to sound like a Topcon salesman, so I shall move on.

Basically, what I did that day was map the headstones that were present in the cemetery. That took me from 7am until about 1pm.

It’s one thing to have a geophysical survey performed, but you really need to have a map of the surrounding “stuff” so you know exactly where the geophysical survey was performed (and, hence, where all the unmarked graves are located). If you don’t do this, you’re just wasting time (and the client’s money).

Once I collected all the points needed to create the site map, I packed up, headed to my motel room and entered all the data into GIS (I use Global Mapper. It’s far easier and better than anything else. Yes, including ArcGIS. Deal with it. 😛 ). Then I spent the afternoon colour-coding the different points and lines and shapes and what-have-you. Little trees to indicate trees. Dark grey areas to indicate marked graves. Light grey areas to indicate concrete slabs for the lawn section. A crossed orange line to indicate the cemetery boundary fence. You get the idea. Make the map look pretty. Then whack a north arrow, scale and legend on it and Robert is your mother’s brother. And then the clock hit 5pm and it was time to sleep. (This week involved working from 6.30am until about 7pm each day. So I was overjoyed to see the bed Friday night).

So that was the excitement for my Day of Archaeology.Until next time, live long and prosper.Dave The Grave HunterPS: Sorry for the lack of photos. Here are some on my Facebook business page.