EAMC Archaeology Database (v1.0)
Part of the Exploring the Archaeology of the Modern City project
Creator(s): Penny Crook; Tim Murray
Year: 2006
Primary Copyright Holder: La Trobe UniversitySummary
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 |
| 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
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.
Keywords
Culture
Historical Archaeology (incl. Industrial Archaeology) (FOR 210108)
Material
Building Materials
•
Ceramic
•
Glass
•
Metal
•
miscellaneous
•
Organic
Site Name
Cumberland and Gloucester Streets site (The Rocks)
•
First Government House site (Sydney)
•
Lilyvale site (Cumberland Street, The Rocks)
•
Paddy's Market site (Haymarket)
General
Comparative assemblage analysis
Geographic Keywords
Sydney, New South Wales, Australia
Temporal Keywords
19th Century
•
Convict era
•
early-20th century
•
late-18th century
Spatial Coverage
min long: 151.186; min lat: -33.876 ; max long: 151.217; max lat: -33.85 ;
Individual & Institutional Roles
Contact(s): Tim Murray; La Trobe University
Contributor(s): Anne Bickford; Wendy Thorp; Godden Mackay Logan
Sponsor(s): Sydney Harbour Foreshore Authority; Godden Mackay Logan; Historic Houses Trust; NSW Heritage Office ; City of Sydney
Repository(s): Historic Houses Trust; Sydney Harbour Foreshore Authority
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