EAMC Archaeology Database (v1.0)

Creator(s): Penny Crook; Tim Murray

Year: 2006

Primary Copyright Holder: La Trobe University

Summary

The EAMC Archaeology Database is a customised relational database, created in Microsoft Access, and designed to store, display, search and analyse archaeological data. It contains: a detailed catalogue of artefacts; a register of stratigraphic context data; a register of type series data the capacity to hold multiple images of key artefacts; in-built data definitions; and a range of tools to make the task of cataloguing assemblages more efficient.

Released in 2006, it drew together, for the first time, artefact data from Sydney’s major urban excavations: the Cumberland and Gloucester Streets site, the Lilyvale site, the site of First Government House and Paddy’s Market. These catalogues were prepared about a decade or more prior to the creation of the EAMC Project and we acknowledge the work of these artefacts specialists, led by Anne Bickford, Wendy Thorp and Godden Mackay Logan.

Cite this Record

EAMC Archaeology Database (v1.0). Penny Crook, Tim Murray. 2006 ( tDAR id: 407300) ; doi:10.6067/XCV8RB76N6

This Resource is Part of the Following Collections

URL: http://www.latrobe.edu.au/amc/database.html


Restricted Access Some or all of this resource's attached file(s) are not publicly accessible.

Data Set Structure

Measurement Column
Count Column
Coded Column
Filename Column
Integration Column (has Ontology)

Table Information: ArtefactNotes

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
Description TEXT  Uncoded Value uncategorized none none true
Category TEXT  Uncoded Value uncategorized none none true
Class TEXT  Uncoded Value uncategorized none none true
Activity TEXT  Uncoded Value uncategorized none none true
Function TEXT  Uncoded Value uncategorized none none true
Subfunction TEXT  Uncoded Value uncategorized none none true
TypeName TEXT  Uncoded Value uncategorized none none true
DateFrom TEXT  Uncoded Value uncategorized none none true
DateTo TEXT  Uncoded Value uncategorized none none true
DateNotes TEXT  Uncoded Value uncategorized none none true
Print BOOLEAN  Uncoded Value uncategorized none none true
Material TEXT  Coded Value uncategorized Generated identity coding sheet for Material EAMC Materials true

Table Information: Artefacts

Column Name Data Type Type Category Coding Sheet Ontology Search
Organic TEXT  Uncoded Value uncategorized none none true
IDNumber Unique identification number allocated to each artefact. For all artefacts catalogued prior to 2001 this is the 'original' number and appears on the bag.
DOUBLE  Uncoded Value uncategorized none none true
CatalogueNumber The IDNumber preceded by an abbreviated Site code. This allows multiple catalogues each numbered 1 to ~ to be combined in the same database. All labels printed from 2001 onwards show the Catalogue Number rather than IDNumber. (Added by the EAMC)
TEXT  Uncoded Value uncategorized none none true
Site The excavation site code, often including the year of excavation, eg CUGL1994
TEXT  Uncoded Value uncategorized none none true
Unit The stratigraphic Unit from which the artefact was excavated, eg B101. (From the original CUGL catalogue)
TEXT  Uncoded Value uncategorized none none true
UnitArea A sub-strata of the Unit, ie a grid square within a Unit (eg B101/B1). The 'UnitArea' as defined in the original CUGL catalogue.
TEXT  Uncoded Value uncategorized none none true
UnitandArea The full stratigraphic Unit reference for the deposit from which the artefact was recovered
TEXT  Uncoded Value uncategorized none none true
PhaseA The first Site Phase to which the stratigraphic Unit from which the artefact was recovered may be dated. (From the original CUGL catalogue)
DOUBLE  Uncoded Value uncategorized none none true
PhaseB The last Site Phase to which the stratigraphic Unit from which the artefact was recovered may be dated. (From the original CUGL catalogue)
DOUBLE  Uncoded Value uncategorized none none true
Activity The pre-defined, broad functional Activity group to which the artefact was likely to belong. Activity is the first of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came).
TEXT  Uncoded Value uncategorized none none true
ActivityQ A checkbox to be ticked when the allocated Activity group is considered tentative or speculative. (Added by the EAMC)
BOOLEAN  Uncoded Value uncategorized none none true
DateTo Numeric field recording the last year of the period in which the artefact may have been manufactured.
BIGINT  Uncoded Value uncategorized none none true
Function The pre-defined, Function group to which the artefact was likely to belong. Function is the second of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came).
TEXT  Uncoded Value uncategorized none none true
FunctionQ A checkbox to be ticked when the allocated Function group is considered tentative or speculative. (Added by the EAMC)
BOOLEAN  Uncoded Value uncategorized none none true
Subfunction The pre-defined, a more specific functional group to which the artefact was likely to belong. Function is the second of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came).
TEXT  Uncoded Value uncategorized none none true
AnimalSize TEXT  Uncoded Value uncategorized none none true
SubfunctionQ A checkbox to be ticked when the allocated Subfunction group is considered tentative or speculative. (Added by the EAMC)
BOOLEAN  Uncoded Value uncategorized none none true
Arteclass Broad Artefact Class for each artefact (eg Glass, Ceramic, Building Material).
TEXT  Uncoded Value uncategorized none none true
Material Specific Material class for each artefact (eg Fine Earthenware, Porcelain).
TEXT  Uncoded Value uncategorized none none true
MaterialQ BOOLEAN  Uncoded Value uncategorized none none true
CeramicBody The specific fabric of a ceramic vessel (eg 'Creamware', where 'Fine Earthenware' appears in the Material field). (From the original LV and FGH-YRP catalogues. In the CUGL system the Ceramic Body is described via the Type Series.)
TEXT  Uncoded Value uncategorized none none true
Integrity Describes the Integrity or completeness of sherd within one bag by recording the relationship of elements within that bag.
TEXT  Uncoded Value uncategorized none none true
Percentage Estimated percentage of the total vessel or piece that the elements in the bag represent.
TEXT  Uncoded Value uncategorized none none true
Quantity The number of sherds or individual elements in the bag, regardless of whether they conjoin to form a whole piece.
DOUBLE  Uncoded Value uncategorized none none true
Form Description of the profile of the original vessel or part there of (eg base or rim), as determined from the surviving sherd (eg 'everted rim', 'London-profile' for a tea cup).
TEXT  Uncoded Value uncategorized none none true
Shape Description of the section of vessel, as determined from the sherd (eg 'round' for a teacup, 'oval' for a platter etc)
TEXT  Uncoded Value uncategorized none none true
Portion The part of the vessel that artefact derived. Eg the 'stem' of a pipe, or 'rim' of tea cup.
TEXT  Uncoded Value uncategorized none none true
Decoration The method of applying the decoration (eg 'transfer-print', 'hand-painted' etc)
TEXT  Uncoded Value uncategorized none none true
DecorationPlacement The face(s) of the vessel or sherd on which the decoration appears. This aids the identification of function, eg decoration appears on the 'concave' face of plates and saucers; teacups are 'double-sided'. (Added by the EAMC, Nov 2002)
TEXT  Uncoded Value uncategorized none none true
Colour The colour(s) of the decoration on the vessel (eg 'red' transfer-print, or the body of an undecorated vessel or object (eg 'olive-green' glass).
TEXT  Uncoded Value uncategorized none none true
Pattern The name of a known pattern or decorative style (eg ‘Lachlander’ pipe; ‘Willow’ plate), or general description (eg ‘Scenic’; 'Floral') if the precise pattern name is not known.
TEXT  Uncoded Value uncategorized none none true
TechniqueManuf The technological process by which the artefact was manufactured, eg 'hand-thrown', 'moulded', 'blown'.
TEXT  Uncoded Value uncategorized none none true
LabelPrinted Administrative checkbox to indicate whether a label has been printed for the artefact.
BOOLEAN  Uncoded Value uncategorized none none true
Modifictns Changes to the artefact occurring after its manufacture, while in use or after discard and deposition, excluding breakage, eg 'mended', 'inscribed'.
TEXT  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
IDMarks Function or purpose of any mark found on an artefact, as described in the Transcript field, eg 'Manufacturer's mark', 'Slogan'.
TEXT  Uncoded Value uncategorized none none true
Transcript Direct transcription of any text found on the artefact; gaps or speculative text should be enclosed in square parentheses: [ and ].
TEXT  Uncoded Value uncategorized none none true
MakerID Dedicated field for the name of the Maker, as identified from basemarks, unique patterns, etc. This field contained a unique identifier for each maker, stored in the ListOfMakers table. (Added by the EAMC; Feb 2002)
BIGINT  Uncoded Value uncategorized none none true
DistributorID Dedicated field for the name of the Distributor, as identified from basemarks, unique patterns, etc. This field contained a unique identifier for each distributor, stored in the ListOfMakers table. (Added by the EAMC; Feb 2002)
BIGINT  Uncoded Value uncategorized none none true
Lengthinmm Actual or estimated length of the vessel from which the sherd derives, in mm. This field does not record the length of sherds in their current state.
DOUBLE  Uncoded Value uncategorized none none true
Widthinmm Actual or estimated width or diameter of the vessel from which the sherd derives, in mm. This field does not record the width of sherds in their current state.
DOUBLE  Uncoded Value uncategorized none none true
Heightinmm Actual or estimated height of the vessel from which the sherd derives, in mm. This field does not record the height of sherds in their current state.
DOUBLE  Uncoded Value uncategorized none none true
Thickinmm Thickness of a specific part of the vessel from which the sherd derives, in mm. Eg base or body thickness.
DOUBLE  Uncoded Value uncategorized none none true
Tilestrike For CUGL Building Materials only. (From the original CUGL catalogue)
TEXT  Uncoded Value uncategorized none none true
TSName Name of the Type Series to which the artefact has been allocated, eg 'TP Earthenware Blue'.
TEXT  Uncoded Value uncategorized none none true
TSNo The Specific Number in the Type group described in the TS Name field, to which the artefact has been allocated, 'TP Earthenware Blue 12'.
DOUBLE  Uncoded Value uncategorized none none true
TSDetails Whether the artefact is the first representative Type (‘T’), or a ‘Repeat’ (‘R’) of that sub-Type.
TEXT  Uncoded Value uncategorized none none true
DateFrom Numeric field recording the artefact’s date of manufacture, or the first year of the period in which the artefact may have been manufactured.
BIGINT  Uncoded Value uncategorized none none true
DateNote Text field for additional notes regarding the Dates To and From that cannot be accommodated in those numeric fields.
TEXT  Uncoded Value uncategorized none none true
Provenance The country or town where the artefact was made.
TEXT  Uncoded Value uncategorized none none true
WeightGrms Weight of all sherds in the bag (in grams).
DOUBLE  Uncoded Value uncategorized none none true
Condition Brief description of the condition of the artefact. (From the original LV and FGH-YRP catalogues.)
TEXT  Uncoded Value uncategorized none none true
AniMaxSize DOUBLE  Uncoded Value uncategorized none none true
Seed TEXT  Uncoded Value uncategorized none none true
Conservation Brief description of any treatment applied to the artefact in order to conserve it. (From the original LV and FGH-YRP catalogues.)
TEXT  Uncoded Value uncategorized none none true
Notes General notes about the artefact.
TEXT  Uncoded Value uncategorized none none true
References Bibliographic references for any piece of information provided in the record.
TEXT  Uncoded Value uncategorized none none true
BoxNumber The number of the box in which the artefact is stored.
TEXT  Uncoded Value uncategorized none none true
VesselIDno Identification number to represent sherds recovered from different contexts (and hence in different bags) that conjoin to form a single object. (Added by the EAMC, 2001)
BIGINT  Uncoded Value uncategorized none none true
MNVID Identification number to group artefacts that potentially are part of the same vessel, for the purposes of Minimum Vessel Counts (MVC) only. (Added by the EAMC, Feb 2003)
DOUBLE  Uncoded Value uncategorized none none true
MNVQty Minimum number of vessels or objects represented by the MNVID. (Added by the EAMC, Feb 2003)
BIGINT  Uncoded Value uncategorized none none true
MNVNotes Field to contain notes relating to the grouping of the artefact(s) under the chosen MNVID. (Added by the EAMC, Feb 2003)
TEXT  Uncoded Value uncategorized none none true
MNVtocheck Administrative checkbox to indicate that the artefact must be inspected to verify the MVC. (100% complete vessels do not require physical verification for the purpose of MVC counts.) (Added by the EAMC, Feb 2003)
BOOLEAN  Uncoded Value uncategorized none none true
MNVverified Administrative checkbox to indicate that the MNVID and MNVQty for this artefact have been verified. (Added by the EAMC, Feb 2003)
BOOLEAN  Uncoded Value uncategorized none none true
SpecialFindNo The Special Find Number allocated to some artefacts during excavation. (Added by the EAMC to track the SF numbers in the FGH catalogue)
BIGINT  Uncoded Value uncategorized none none true
MatchingSetID Unique Identification number to group artefacts that potentially formed part of a matching set. (Added by the EAMC, Feb 2003)
BIGINT  Uncoded Value uncategorized none none true
MatchingSetType Whether the Matching Set is considered 'Complementary' or an exact match.
TEXT  Uncoded Value uncategorized none none true
OriginalContext Field containing the stratigraphic Unit as it was when imported into the database. Several FGH Units were originally mistyped and referred to unknown strata. These were corrected in order to link to Contexts table; and the original data retained..
TEXT  Uncoded Value uncategorized none none true
SplitFrom For bags split after the initial phase of cataloguing, this field records the original Catalogue Number.
BIGINT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the Artefacts Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the Artefacts Form.
TEXT  Uncoded Value uncategorized none none true
RecordAdmin Memo field to record any alterations made to Artefact Record since the initial phases of cataloguing and data entry.
TEXT  Uncoded Value uncategorized none none true
QRNotes Notes field used by the EAMC team during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none true
QRChecked Administrative check box used to mark all artefact checked during the Quality Review Assessment.
BOOLEAN  Uncoded Value uncategorized none none true
QRProblem Any Problem with the artefact record identified during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none true
QRAssess Overall Assessment of the extent of Problems identified during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none true
SpeciesName TEXT  Uncoded Value uncategorized none none true
SkeletalElGroup TEXT  Uncoded Value uncategorized none none true
SkeletalEl TEXT  Uncoded Value uncategorized none none true
BoneNoComp DOUBLE  Uncoded Value uncategorized none none true
BoneNoFrag DOUBLE  Uncoded Value uncategorized none none true
BoPortName TEXT  Uncoded Value uncategorized none none true
BoPortPerc TEXT  Uncoded Value uncategorized none none true
BoCondName TEXT  Uncoded Value uncategorized none none true
BoCondDesc TEXT  Uncoded Value uncategorized none none true
BoCondAss TEXT  Uncoded Value uncategorized none none true
BoAttriTyp TEXT  Uncoded Value uncategorized none none true
BoAttriTLC TEXT  Uncoded Value uncategorized none none true
BoAttriTAS TEXT  Uncoded Value uncategorized none none true
BoAgeInGLC TEXT  Uncoded Value uncategorized none none true
BOAgeInGST TEXT  Uncoded Value uncategorized none none true
BoneRelativeAge Relative age of animal, ie mature or juvenile.
TEXT  Uncoded Value uncategorized none none true
BoneAnimalSide Left, right or centre of animal, eg the left or right femur.
TEXT  Uncoded Value uncategorized none none true
TeethTooth TEXT  Uncoded Value uncategorized none none true
TeethCond TEXT  Uncoded Value uncategorized none none true
ButchLocat TEXT  Uncoded Value uncategorized none none true
ButchType TEXT  Uncoded Value uncategorized none none true
ButchOrien TEXT  Uncoded Value uncategorized none none true
ShellScien TEXT  Uncoded Value uncategorized none none true
ShellCommn TEXT  Uncoded Value uncategorized none none true
ShellNoCom DOUBLE  Uncoded Value uncategorized none none true
ShellNoFra DOUBLE  Uncoded Value uncategorized none none true
ShellNoLid DOUBLE  Uncoded Value uncategorized none none true
ShellNoBas DOUBLE  Uncoded Value uncategorized none none true
ShellCond TEXT  Uncoded Value uncategorized none none true
Mineral TEXT  Uncoded Value uncategorized none none true

Table Information: BiblioData_Artefacts

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
AuthorSurname Surname of the main author.
TEXT  Uncoded Value uncategorized none none true
AuthorFirstName First name or initial of the main author.
TEXT  Uncoded Value uncategorized none none true
OtherAuthorJoin 'and', ',' or 'with'
TEXT  Uncoded Value uncategorized none none true
Other Authors Full names of other authors, with firstname first, eg 'Jane Smith'.
TEXT  Uncoded Value uncategorized none none true
Editors ed. or eds
TEXT  Uncoded Value uncategorized none none true
Title The full title of the published document or report, or a description of an excerpt or other work.
TEXT  Uncoded Value uncategorized none none true
Publisher Name of the publisher or client. If a client, include 'for': eg, 'for Jo Smith Pty Ltd'.
TEXT  Uncoded Value uncategorized none none true
PublishedIn Place of publication.
TEXT  Uncoded Value uncategorized none none true
PublishedMonth Month in the year when report was released.
TEXT  Uncoded Value uncategorized none none true
PublishedDate Year of publication or the year a report was released.
TEXT  Uncoded Value uncategorized none none true
JournalVol The Volume number or reference for a journal
TEXT  Uncoded Value uncategorized none none true
JournalNo The Number of the volume for a journal
TEXT  Uncoded Value uncategorized none none true
Vol Number of volumes included in this entry. (Each volume in a series may be given its own entry.)
TEXT  Uncoded Value uncategorized none none true
Volume or Series Details Details of the series (if this is one volume from a larger series) or all the volumes (if all volumes in a series are included in this record).
TEXT  Uncoded Value uncategorized none none true
PageFrom If an article or excerpt from a larger document, the first page number of this excerpt.
TEXT  Uncoded Value uncategorized none none true
PageTo If an article or excerpt from a larger document, the last page number of this excerpt.
TEXT  Uncoded Value uncategorized none none true
Datefrom Earliest date that information in this document refers to.
TEXT  Uncoded Value uncategorized none none true
DateTo Latest date that information in this document refers to.
TEXT  Uncoded Value uncategorized none none true
Source The place or places where this document is held.
TEXT  Uncoded Value uncategorized none none true
RefNo The reference number or name to retrieve this document from the source selected.
TEXT  Uncoded Value uncategorized none none true
SourceType The type of information contained in this document: either primary or secondary.
TEXT  Uncoded Value uncategorized none none true
Format Format of physical document, eg 'photocopies of newspapers', 'book', 'box of photographs'.
TEXT  Uncoded Value uncategorized none none true
DocumentType TEXT  Uncoded Value uncategorized none none true
Site Name The name of the site or sites to which the document may refer.
TEXT  Uncoded Value uncategorized none none true
Keyword TEXT  Uncoded Value uncategorized none none true
Streets TEXT  Uncoded Value uncategorized none none true
Comments Any additional comments about the work.
TEXT  Uncoded Value uncategorized none none true
Entered by Name of the person who entered the information about this document into this form.
TEXT  Uncoded Value uncategorized none none true
DateEntered Date when the information about this document was entered.
DATETIME  Uncoded Value uncategorized none none true
SiteNameNu BIGINT  Uncoded Value uncategorized none none true
CatalogueNo SHFA Catalogue Number
TEXT  Uncoded Value uncategorized none none true
Project TEXT  Uncoded Value uncategorized none none true

Table Information: BoxNumbers

Column Name Data Type Type Category Coding Sheet Ontology Search
Order DOUBLE  Uncoded Value uncategorized none none true
BoxNumber TEXT  Uncoded Value uncategorized none none true

Table Information: ContextRelationships

Column Name Data Type Type Category Coding Sheet Ontology Search
RelationshipID BIGINT  Uncoded Value uncategorized none none true
Site TEXT  Uncoded Value uncategorized none none true
ContextSubject TEXT  Uncoded Value uncategorized none none true
RelationshipType TEXT  Uncoded Value uncategorized none none true
Trench TEXT  Uncoded Value uncategorized none none true
UnitNo TEXT  Uncoded Value uncategorized none none true
ContextObject TEXT  Uncoded Value uncategorized none none true

Table Information: Contexts

Column Name Data Type Type Category Coding Sheet Ontology Search
Site Site code
TEXT  Uncoded Value uncategorized none none true
MasterContext Overarching Context Number allocated to a group of stratigraphic contexts or Units deposited as part of the same event, but excavated separately (added by EAMC, 2002)
TEXT  Uncoded Value uncategorized none none true
Unit Trench or area number of the stratigraphic context or feature
TEXT  Uncoded Value uncategorized none none true
UnitArea Specific unit number of the stratigraphic context or feature
TEXT  Uncoded Value uncategorized none none true
UnitandArea Full unit code including Trench and Unit Number, and Site if required to distinguish from other contexts.
TEXT  Uncoded Value uncategorized none none true
UnitCode Unique code incorporating Site and Unit number
TEXT  Uncoded Value uncategorized none none true
AreaAlph Alpha ref or square for gridded occupation deposits, eg 'A' for square 'A1'
TEXT  Uncoded Value uncategorized none none true
AreaNo Numerical ref of square for gridded occupation deposits, eg '1' for square 'A1'
TEXT  Uncoded Value uncategorized none none true
Spit Spit number, where relevant
BIGINT  Uncoded Value uncategorized none none true
ContextType1 The broad category of strata, eg 'Fill', 'Service feature', 'Structural element'
TEXT  Uncoded Value uncategorized none none true
ContextType2 The specific kind of context eg 'Fill - cesspit', 'Service feature - drain', etc
TEXT  Uncoded Value uncategorized none none true
BldgPhase TEXT  Uncoded Value uncategorized none none true
BldgCode Code of the building with which this Unit is associated.
TEXT  Uncoded Value uncategorized none none true
BldgCodeNotes Additional notes about bldg code, where necessary
TEXT  Uncoded Value uncategorized none none true
BldgArea The Area of the Building in which this Unit or feature was revealed.
TEXT  Uncoded Value uncategorized none none true
Location The part of the site where this Unit or feature was revealed. This is designed to allow for Units or features revealed in the locale of a building bu could not be associated with the Building itself (ie it may have been earlier or later).
TEXT  Uncoded Value uncategorized none none true
Description Brief description of context
TEXT  Uncoded Value uncategorized none none true
Notes More detailed notes about the Unit.
TEXT  Uncoded Value uncategorized none none true
ExcavationPhase Phase of the site's excavation during which the context was dug; added largely to cater for FGH
TEXT  Uncoded Value uncategorized none none true
ExcavatedBy Name of the excavator, where known
TEXT  Uncoded Value uncategorized none none true
ExcavatedDate Date excavation began, where known
DATETIME  Uncoded Value uncategorized none none true
Below The Unit above the current Unit, ie the current Unit is Below Unit X
TEXT  Uncoded Value uncategorized none none true
Above The Unit below the current Unit, ie the current Unit is Above Unit X
TEXT  Uncoded Value uncategorized none none true
SameAs Other Units identified during excavation to be the same as the current Unit.
TEXT  Uncoded Value uncategorized none none true
Disturbed Whether or not the Unit or feature has been disturbed by later deposition (added by the EAMC)
BOOLEAN  Uncoded Value uncategorized none none true
ConjoinsWith Other Units identified as containing sherds that conjoin with artefacts in the current Unit.
TEXT  Uncoded Value uncategorized none none true
Priority1 Priority for detailed cataloguing as identified for the CUGL assemblage. (For the CUGL catalogue only.)
BIGINT  Uncoded Value uncategorized none none true
Priority2 Priority for detailed cataloguing as identified for the CUGL assemblage. (For the CUGL catalogue only.)
BIGINT  Uncoded Value uncategorized none none true
Phase1 The earliest Site Phase in which the Unit or feature may have been created
BIGINT  Uncoded Value uncategorized none none true
Phase2 The latest Site Phase in which the Unit or feature may have been created
BIGINT  Uncoded Value uncategorized none none true
PhaseNotes Notes about the phasing of the Unit or feature.
TEXT  Uncoded Value uncategorized none none true
MinDate TPQ, or the earliest minimum year in which the Unit or feature may have been created, as determined by the artefact with the latest minimum manufacture date
TEXT  Uncoded Value uncategorized none none true
MinDateNotes Notes regarding the determination of the TPQ.
TEXT  Uncoded Value uncategorized none none true
MaxDate TAQ, or the latest maximum year in which the Unit or feature may have been created, usually determined by the minimum date of the strata above this Unit.
TEXT  Uncoded Value uncategorized none none true
MaxDateNotes Notes regarding the determination of the TAQ.
TEXT  Uncoded Value uncategorized none none true
DateNotes General notes about dating the Unit or feature.
TEXT  Uncoded Value uncategorized none none true
Volume Volume of the Unit, if provided on the Context Sheet.
DOUBLE  Uncoded Value uncategorized none none true
Reference Bibliographic reference for the Unit or feature.
TEXT  Uncoded Value uncategorized none none true
Plans Plans showing the Unit or feature.
TEXT  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the Contexts Form.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the Contexts Form.
DATETIME  Uncoded Value uncategorized none none true
Colour Colour of the deposit (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Texture Texture of the deposit (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Moisture Moisture level of the deposit (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Components Components within the deposit (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Length Length of the deposit or feature (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Width Width of the deposit or feature (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
Diameter Diameter of the deposit or feature (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true
HeightOrDepth Height or depth of the deposit or feature (Added 17 July 02 to accommodate LV context sheets)
TEXT  Uncoded Value uncategorized none none true

Table Information: ImagesTable

Column Name Data Type Type Category Coding Sheet Ontology Search
ImageNo Unique ID number automatically allocated to each record of an Image in the database
BIGINT  Uncoded Value uncategorized none none true
CatalogueNumber The Catalogue Number of the artefact (or one of the artefacts) in the image
TEXT  Uncoded Value uncategorized none none true
Site Site Code
TEXT  Uncoded Value uncategorized none none true
FileName Exact name of file, including the extension
TEXT  Uncoded Value uncategorized none none true
Caption Caption for the image, where required
TEXT  Uncoded Value uncategorized none none true
Date Date the photograph was taken, where known
DATETIME  Uncoded Value uncategorized none none true
Copyright Details of copyright restrictions on the image, if appropriate
TEXT  Uncoded Value uncategorized none none true
BoxNo Number of box in which the artefact was recovered. The CUGL type series was photographed box by box; the Box No. was recorded to assist finding the image file on CD and to match with the Artefact Data record.
TEXT  Uncoded Value uncategorized none none true
CDNo No of CD in the EAMC pic series on which the original tif file is stored
TEXT  Uncoded Value uncategorized none none true
FileType Jpg or .tif
TEXT  Uncoded Value uncategorized none none true
Notes General notes about the image
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfActivities

Column Name Data Type Type Category Coding Sheet Ontology Search
ActivityID BIGINT  Uncoded Value uncategorized none none true
Activity TEXT  Uncoded Value uncategorized none none true
Description TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
OtherNames TEXT  Uncoded Value uncategorized none none true
Source TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfArtefactClasses

Column Name Data Type Type Category Coding Sheet Ontology Search
ArteclassID BIGINT  Uncoded Value uncategorized none none true
Arteclass TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofColours

Column Name Data Type Type Category Coding Sheet Ontology Search
ColourID BIGINT  Uncoded Value uncategorized none none true
ColourName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofContextTypes

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
context type 1 TEXT  Uncoded Value uncategorized none none true
context type 2 TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofDecorations

Column Name Data Type Type Category Coding Sheet Ontology Search
DecorationID BIGINT  Uncoded Value uncategorized none none true
DecorationName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofFormProfiles

Column Name Data Type Type Category Coding Sheet Ontology Search
FormID BIGINT  Uncoded Value uncategorized none none true
FormName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofFormSections

Column Name Data Type Type Category Coding Sheet Ontology Search
Notes TEXT  Uncoded Value uncategorized none none true
SectionShapeID BIGINT  Uncoded Value uncategorized none none true
SectionShapeName TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofFunctions

Column Name Data Type Type Category Coding Sheet Ontology Search
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
FunctionID BIGINT  Uncoded Value uncategorized none none true
OldFunctionID BIGINT  Uncoded Value uncategorized none none true
Activity TEXT  Uncoded Value uncategorized none none true
FunctionName TEXT  Uncoded Value uncategorized none none true
SampleSubfunctions TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofIDMarks

Column Name Data Type Type Category Coding Sheet Ontology Search
MarkID BIGINT  Uncoded Value uncategorized none none true
IDMarkName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofMakers

Column Name Data Type Type Category Coding Sheet Ontology Search
MakerType M for Maker, D for Distributor
TEXT  Uncoded Value uncategorized none none true
ProductType TEXT  Uncoded Value uncategorized none none true
MakerID BIGINT  Uncoded Value uncategorized none none true
MakerName TEXT  Uncoded Value uncategorized none none true
MakerProvinence TEXT  Uncoded Value uncategorized none none true
MakerDates TEXT  Uncoded Value uncategorized none none true
MakerNotes TEXT  Uncoded Value uncategorized none none true
References TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfMaterials

Column Name Data Type Type Category Coding Sheet Ontology Search
ArtefactClass TEXT  Uncoded Value uncategorized none none true
MaterialID BIGINT  Uncoded Value uncategorized none none true
MaterialName TEXT  Uncoded Value uncategorized none none true
ArtefactClassID BIGINT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofModifications

Column Name Data Type Type Category Coding Sheet Ontology Search
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
ModificationID BIGINT  Uncoded Value uncategorized none none true
ModificationName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfPatterns

Column Name Data Type Type Category Coding Sheet Ontology Search
PatternID BIGINT  Uncoded Value uncategorized none none true
PatternName TEXT  Uncoded Value uncategorized none none true
PatternType TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfPortions

Column Name Data Type Type Category Coding Sheet Ontology Search
PortionName TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
PortionID BIGINT  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofProvenance

Column Name Data Type Type Category Coding Sheet Ontology Search
ProvenanceID BIGINT  Uncoded Value uncategorized none none true
ProvenanceName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofRemovalReasons

Column Name Data Type Type Category Coding Sheet Ontology Search
RemovalReasonID BIGINT  Uncoded Value uncategorized none none true
RemovalReasonType TEXT  Uncoded Value uncategorized none none true
RemovalReason TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListOfSites

Column Name Data Type Type Category Coding Sheet Ontology Search
Year/s TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
SiteID BIGINT  Uncoded Value uncategorized none none true
SiteCode TEXT  Uncoded Value uncategorized none none true
SiteName TEXT  Uncoded Value uncategorized none none true
CatalogueNumberPrefix TEXT  Uncoded Value uncategorized none none true
Address TEXT  Uncoded Value uncategorized none none true
SiteOwner TEXT  Uncoded Value uncategorized none none true
Excavator TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofSkeletalElements

Column Name Data Type Type Category Coding Sheet Ontology Search
Notes TEXT  Uncoded Value uncategorized none none true
ID BIGINT  Uncoded Value uncategorized none none true
skeletal element TEXT  Uncoded Value uncategorized none none true
area of body TEXT  Uncoded Value uncategorized none none true
Activity TEXT  Uncoded Value uncategorized none none true
Use TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofSubfunctions

Column Name Data Type Type Category Coding Sheet Ontology Search
SubfunctionID BIGINT  Uncoded Value uncategorized none none true
SubfunctionName TEXT  Uncoded Value uncategorized none none true
Order BIGINT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
FunctionID BIGINT  Uncoded Value uncategorized none none true
ActivityID BIGINT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: ListofTechniques

Column Name Data Type Type Category Coding Sheet Ontology Search
TechniqueManufID BIGINT  Uncoded Value uncategorized none none true
TechniqueName TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none true
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The last date on which any field in this record was modified while using the List Form.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none true

Table Information: MasterContexts

Column Name Data Type Type Category Coding Sheet Ontology Search
MasterContext TEXT  Uncoded Value uncategorized none none true
BldgCode TEXT  Uncoded Value uncategorized none none true
BldgArea TEXT  Uncoded Value uncategorized none none true
Phase1 BIGINT  Uncoded Value uncategorized none none true
Phase2 BIGINT  Uncoded Value uncategorized none none true
Description TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
Site TEXT  Uncoded Value uncategorized none none true
ContextType1 TEXT  Uncoded Value uncategorized none none true
ContextType2 TEXT  Uncoded Value uncategorized none none true
MinDate BIGINT  Uncoded Value uncategorized none none true
MaxDate BIGINT  Uncoded Value uncategorized none none true
DateNotes TEXT  Uncoded Value uncategorized none none true

Table Information: MatchingSets

Column Name Data Type Type Category Coding Sheet Ontology Search
TSDetails TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
TSNo DOUBLE  Uncoded Value uncategorized none none true
MatchSetID BIGINT  Uncoded Value uncategorized none none true
MatchSetDescription TEXT  Uncoded Value uncategorized none none true
MatchSetType TEXT  Uncoded Value uncategorized none none true
CatalogueNumber TEXT  Uncoded Value uncategorized none none true
Site TEXT  Uncoded Value uncategorized none none true
TSName TEXT  Uncoded Value uncategorized none none true
DateUpdated DATETIME  Uncoded Value uncategorized none none true
UpdatedBy TEXT  Uncoded Value uncategorized none none true

Table Information: ObjectRemovalData

Column Name Data Type Type Category Coding Sheet Ontology Search
UpdatedBy TEXT  Uncoded Value uncategorized none none true
EnteredBy TEXT  Uncoded Value uncategorized none none true
DateUpdated DATETIME  Uncoded Value uncategorized none none true
CatalogueNumber TEXT  Uncoded Value uncategorized none none true
BoxNo TEXT  Uncoded Value uncategorized none none true
ID BIGINT  Uncoded Value uncategorized none none true
Description TEXT  Uncoded Value uncategorized none none true
RemovalDate DATETIME  Uncoded Value uncategorized none none true
RemovalReason TEXT  Uncoded Value uncategorized none none true
AuthorisingOfficer TEXT  Uncoded Value uncategorized none none true
ExpectedReturnDate TEXT  Uncoded Value uncategorized none none true
ReturnDate DATETIME  Uncoded Value uncategorized none none true
ReturnedBy TEXT  Uncoded Value uncategorized none none true
Condition TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
ReturnedToBox BOOLEAN  Uncoded Value uncategorized none none true
DateEntered DATETIME  Uncoded Value uncategorized none none true

Table Information: Phases

Column Name Data Type Type Category Coding Sheet Ontology Search
PhaseID Unique ID number allocated to each database record of a Site Phase
BIGINT  Uncoded Value uncategorized none none true
Site Site Code
TEXT  Uncoded Value uncategorized none none true
PhaseNo The number allocated to each Phase by the excavators
BIGINT  Uncoded Value uncategorized none none true
PhaseCode Code combing the Site and Phase No, to distinguish phases from each site in the database
TEXT  Uncoded Value uncategorized none none true
PhaseName The name allocated to each Phase by the excavators
TEXT  Uncoded Value uncategorized none none true
DateFrom The minimum year allocated to each Phase by the excavators
TEXT  Uncoded Value uncategorized none none true
DateTo The maximum year allocated to each Phase by the excavators
TEXT  Uncoded Value uncategorized none none true
Notes Description of the Phase
TEXT  Uncoded Value uncategorized none none true

Table Information: Type Series

Column Name Data Type Type Category Coding Sheet Ontology Search
Notes General notes about this subgroup
TEXT  Uncoded Value uncategorized none none true
Site Must match the site code in the artefacts database
TEXT  Uncoded Value uncategorized none none true
Project Specify project if not part of the original catalogue, ie EAMC.
TEXT  Uncoded Value uncategorized none none true
Arteclass Artefact Class
TEXT  Uncoded Value uncategorized none none true
TSName Name of this Type Series group
TEXT  Uncoded Value uncategorized none none true
TSNo Number of the subgroup within Type Series group
BIGINT  Uncoded Value uncategorized none none true
ArtID ID number of the artefact selected as the representative Type ('T') for this Type Group.
TEXT  Uncoded Value uncategorized none none true
ArtefactID ID number of the artefact selected as the representative Type ('T') for this Type Group.
BIGINT  Uncoded Value uncategorized none none true
Description Description of this subgroup
TEXT  Uncoded Value uncategorized none none true
Colour/pattern Colour or pattern name, where appropriate
TEXT  Uncoded Value uncategorized none none true
Portion The portion of artefact defined by this subgroup, where appropriate (eg pushup bases for bottle groups)
TEXT  Uncoded Value uncategorized none none true
Dimensions Dimensions of artefacts as defined by this subgroup, where appropriate
TEXT  Uncoded Value uncategorized none none true
TS abbrev Abreviation of the TS Name, used in cataloguing, where known (eg AW for Aerated Waters')
TEXT  Uncoded Value uncategorized none none true
Maker Name of Maker defined by this subgroup, where appropriate
TEXT  Uncoded Value uncategorized none none true
Provenance Provenance or place made, as defined by this subgroup, where appropriate
TEXT  Uncoded Value uncategorized none none true
From The earliest production date of artefacts defined by this subgroup, where known
BIGINT  Uncoded Value uncategorized none none true
To The latest production date of artefacts defined by this subgroup, where known
BIGINT  Uncoded Value uncategorized none none true
Photographed Whether or not the representative Type ('T') for this subgroup has been photographed.
BOOLEAN  Uncoded Value uncategorized none none true
EnteredBy The date the database record was created.
TEXT  Uncoded Value uncategorized none none true
DateEntered The log-on name of the person who created the record.
DATETIME  Uncoded Value uncategorized none none true
UpdatedBy The last date on which any field in this record was modified while using the List Form.
TEXT  Uncoded Value uncategorized none none true
DateUpdated The log-on name of the person who modified the record while using the List Form.
DATETIME  Uncoded Value uncategorized none none true

Table Information: Vessels

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
VesselNo TEXT  Uncoded Value uncategorized none none true
VesselDescription TEXT  Uncoded Value uncategorized none none true
CatNo TEXT  Uncoded Value uncategorized none none true
Site TEXT  Uncoded Value uncategorized none none true
TSName TEXT  Uncoded Value uncategorized none none true
TSNo DOUBLE  Uncoded Value uncategorized none none true
TSDetails TEXT  Uncoded Value uncategorized none none true
Context1 TEXT  Uncoded Value uncategorized none none true
Context2 TEXT  Uncoded Value uncategorized none none true
Context3 TEXT  Uncoded Value uncategorized none none true
Context4 TEXT  Uncoded Value uncategorized none none true
Notes TEXT  Uncoded Value uncategorized none none true
DateEntered DATETIME  Uncoded Value uncategorized none none true
EnteredBy TEXT  Uncoded Value uncategorized none none true
DateUpdated DATETIME  Uncoded Value uncategorized none none true
UpdatedBy TEXT  Uncoded Value uncategorized none none true

License

license image

Creative Commons Attribution

This license lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.

view details

Spatial Coverage

min long: 151.186; min lat: -33.876 ; max long: 151.217; max lat: -33.85 ;

Record Identifiers

TDAR ID(s): 6867

FAIMS ID(s): repo.fedarch.org/dataset/6867

Notes

General Note: Disclaimer While the creators have made all possible efforts to ensure the accuracy of the data contained in these databases, we cannot guarantee it. Users are strongly advised to carefully check the accuracy of any data drawn from these databases. This database is designed for search purposes only and users store data in it at their own risk. We do not warrant the quality and efficiency of the database design with regard to data entry.

Rights & Attribution: This database is copyright to the Industry Partners of the Exploring the Archaeology of the Modern City Project. Unauthorised copying or use of its contents or design is prohibited. Potential users should contact Professor Tim Murray (t.murray@latrobe.edu.au) for information about how to obtain permission.

Redaction Note: Only the back end of the EAMC database has been uploaded here. The following tables were removed from the original EAMC database: ObjectRemovalData, ArtefactNotes and BiblioData.

File Information

  Name Size Creation Date Date Uploaded Access
archaeologydata.mdb 145.95mb Mar 1, 2012 Aug 20, 2016 11:40:21 AM Confidential
Backend of the EAMC database
  • Translated version archaeologydata_translated.xlsx (53.41mb)
    Data column(s) in this dataset have been associated with coding sheet(s) and translated:
  • Accessing Restricted Files

    At least one of the files for this resource is restricted from public view. For more information regarding access to these files, please reference the contact information below

    Contact(s): Tim Murray