Article · 2024
Managing a Sustainable Database for the Excavations at Idalion, Cyprus
A presentation on how the Idalion excavation project uses the OCHRE database to digitise, link, analyse and publish excavation records, objects, images and spatial data.
Wright describes the digital system built for the excavations at Idalion directed by Pam Gaber, which connects legacy records and archaeological materials with current field recording and future online publication. Topics run from the import of the old records and spatial data through recording during excavation, coordinates and mapping, and finds registration and storage, to querying, analysis, linking and the digitisation of photographic records. The system is OCHRE, the Online Cultural and Historical Research Environment, developed at the University of Chicago.
The evidence
The Idalion archive holds handwritten pottery records and notebooks, object and architecture drawings, photographs and geospatial files. Wright located and scanned most of the finds records of the Joint American Expedition, which excavated at Idalion in 1971–80, and has transcribed about half of the worked-stone record into a spreadsheet. A large dataset of spatial records, photographs, documents and geospatial files was imported into OCHRE, where registered finds, pottery buckets, loci and pottery sherds carry descriptive properties in separate fields such as type, material, shape, treatment, decoration, colour and measurements (pp. 4–8).
The fieldwork
In the 2024 season the project worked nearly paperless apart from top plans, recording locus properties, daily notes and spatial relationships in OCHRE. RTK receivers recorded coordinates directly on database items, Map View displayed geospatial layers and finds, and legacy plans could be georeferenced to give coordinates to earlier finds. Registration templates supplied default properties and naming conventions, permanent citation URLs identified records, and queries, saved sets, charts and generated Harris Matrices served to examine and display the data (pp. 8–19).
Stored finds were inventoried and rehoused, with glass, botanical material, metal, slag and bone prioritised for study. Volunteers inventoried finds in 2024, corrected duplicate numbers and typographical errors, applied barcode labels and reorganised material by type, area and trench; nearly one-third of the project's material culture had been inventoried by that year. The 35 mm film archive was digitised as well, with the film strips rehoused and matched against photo logs (pp. 20–22, 28–30).
The argument
Wright argues that an item-based, non-relational graph database can connect records that were difficult to cross-reference in print. OCHRE stores items as XML documents, links objects, loci, periods and resources, and permits queries across those links. It preserves attribution for observations and interpretations, lets project administrators control access, and supports multiple users and permission levels. Published records can display descriptions, properties, images, links and notes, with movement through the spatial hierarchy to an object's context, and can connect an object to photographs, documents and publication references and list the objects appearing in a publication. Wright states that the Idalion datasets remain under study and that the displayed records are not yet finalised for peer-reviewed publication Wright presents these features as a way to integrate excavation data and make contextual relationships accessible in digital publication (pp. 21–27).
What it records
- The Idalion excavations directed by Pam Gaber had run for 22 cumulative seasons since 1987.p. 2
- Wright located and scanned 889 pages making up most of the finds records of the Joint American Expedition.p. 4
- The located finds records of the Joint American Expedition list almost 7,800 finds with their contexts.p. 4
- Wright had transcribed about half of the Joint American Expedition's worked-stone record into an Excel spreadsheet.p. 4
- More than 120,000 items had been imported into the OCHRE project.p. 7
- The Idalion project recorded coordinates with RTK receivers during the 2024 field season.p. 10
- About 1,700 items of glass, botanical material, metal, slag and faunal material were inventoried in 2024.p. 21
- The project reported that 30% of its material culture had been inventoried.p. 21
- The project's digitisation covered 164 rolls of 35 mm film from 1992–2002.p. 28
Where to read
- Digitising the Joint American Expedition finds recordspp. 3–4
- OCHRE field recording, coordinates and geospatial mappingpp. 8–12
- Registration, queries and Harris Matricespp. 13–17
- Find inventory and storage at Idalionpp. 20–22
- Linked online object publicationpp. 23–27
- Digitization of the 35 mm film archivepp. 28–29
Contents
- Publications of the 1971–1980 Joint American Expedition3
- Online Cultural and Historical Research Environment (OCHRE)6
- Digitization by the numbers7
- Field recording (offline)8
- RTK coordinate capture10
- Using geospatial data in map view12
- Registration13
- Querying15
- Harris Matrix generation16
- Creating charts18
- Inventorying finds20
- Data linking and integration23
- Bibliographies and Zotero24
- Online publication using OCHRE25
- 35 mm film digitization (164 rolls, 1992–2002)28
Objects published here
3- Limestone statue fragment, torso, American Expedition to Idalion, Cyprus, LCE/ACE Surface, GR12210 (p. 27)
- Limestone statue fragment, male head, American Expedition to Idalion, Cyprus, LCE/ACE Surface, GR16696 (p. 27)
- Limestone statue fragment, female head with head covering, ear caps and necklace, American Expedition to Idalion, Cyprus, LCS/EN16/L004/P8207, GR18986 (p. 27)
People, places and institutions
People
- Pamela Gaberdirected the Idalion excavations
Institutions
- University of Chicagohome of OCHRE development
- Forum for Digital Culturedevelops and maintains OCHRE
- Joint American Expeditionexcavated at Idalion in 1971–80
Places
- Idalionsite of the excavations
Also named: Larry Stager, Anita Walker, Maria Hadjicosti, Stephan Schmid, Michael Given, Department of Antiquities, Lower City South, Lower City North.
Extent map of excavation areas; top plans illustrated
HellenisticRomanTechnologyHistory of ArchaeologyPotterySculptureChronology and Dating
Excavations it is cited for
1 project- 1987–todayIdalion: Pamela Gaber's excavations (New Hampshire, Arizona and Lycoming College)Directed by Pamela GaberExcavation
Who did what
2 recordsExcavation 2
- 1991–2012 · p. 2
Maria HadjicostiDirectedDepartment of Antiquities di Cipro
Maria Hadjicosti directed the Department of Antiquities excavations of the administrative center.
West Acropolis, Ambelleri
- 1987 · p. 3
Pamela GaberDirected excavations
Pamela Gaber directed excavations at Idalion, where work resumed in 1987.
Institutions it is cited for
1 institution- University of Chicago3 citations
Corrections and additions
Know this document?
Help us cite it fully and point readers to a copy.
Missing from this record
- Journal not recorded
We would like to hear about
- The full citation, or a correction to ours
- Where a copy can be read or downloaded
- Missing parts, volumes or plates
- Related documents
Tell us if you would like to be thanked by name on the page.