Cumberland and Gloucester Streets (CUGL) artefact data

Creator(s): Penny Crook; Tim Murray

Year: 2006

Primary Copyright Holder: La Trobe University

Summary

Complete suite of datasets from the Cumberland and Gloucester Streets assemblage (completed in 1999), as upgraded for the Exploring the Archaeology of the Modern City project (2001-2004).

Cite this Record

Cumberland and Gloucester Streets (CUGL) artefact data. Penny Crook, Tim Murray. 2006 ( tDAR id: 407301) ; doi:10.6067/XCV8SB47T9

This Resource is Part of the Following Collections

Data Set Structure

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

Table Information: Artefacts

Column Name Data Type Type Category Coding Sheet Ontology Search
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
Technique of Manufacture The technological process by which the artefact was manufactured, eg 'hand-thrown', 'moulded', 'blown'.
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
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
Decoration The method of applying the decoration (eg 'transfer-print', 'hand-painted' 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
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
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
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
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
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  Coded Value uncategorized EAMC Activities Definitions EAMC Activities 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
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
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
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
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
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
ActivityQ A checkbox to be ticked when the allocated Activity group is considered tentative or speculative. (Added by the EAMC)
BOOLEAN  Coded Value uncategorized EAMC Uncertainty Coding Sheet 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
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
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
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
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
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  Count 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
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
Modifictions 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
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
LabelPrinted Administrative checkbox to indicate whether a label has been printed for the artefact.
BOOLEAN  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 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
AnimalSize TEXT  Uncoded Value uncategorized none none true
AniMaxSize DOUBLE  Uncoded Value uncategorized none none true
Seed TEXT  Uncoded Value uncategorized none none true
Organic 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
Images 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
Phase2 The latest Site Phase in which the Unit or feature may have been created
BIGINT  Coded Value uncategorized EAMC Phases (CUGL) none true
Phase1 The earliest Site Phase in which the Unit or feature may have been created
BIGINT  Coded Value uncategorized EAMC Phases (CUGL) none true
BldgCode Code of the building with which this Unit is associated.
TEXT  Uncoded Value uncategorized none none true
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
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
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: CurrentSite

Column Name Data Type Type Category Coding Sheet Ontology Search
CurrentSite 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: ListofMakers

Column Name Data Type Type Category Coding Sheet Ontology Search
MakerID BIGINT  Uncoded Value uncategorized none none true
MakerName TEXT  Uncoded Value uncategorized none none true
MakerType M for Maker, D for Distributor
TEXT  Uncoded Value uncategorized none none true
ProductType 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: MasterContexts

Column Name Data Type Type Category Coding Sheet Ontology Search
BldgCode TEXT  Uncoded Value uncategorized none none true
DateNotes TEXT  Uncoded Value uncategorized none none true
MinDate BIGINT  Uncoded Value uncategorized none none true
MaxDate BIGINT  Uncoded Value uncategorized none none true
MasterContext TEXT  Uncoded Value uncategorized none none true
Description 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
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

Table Information: MatchingSets

Column Name Data Type Type Category Coding Sheet Ontology Search
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
TSNo DOUBLE  Uncoded Value uncategorized none none true
TSDetails TEXT  Uncoded Value uncategorized none none true
Notes 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: 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
Arteclass Artefact Class
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
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
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
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
Notes General notes about this subgroup
TEXT  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
EnteredBy TEXT  Uncoded Value uncategorized none none true
Site TEXT  Uncoded Value uncategorized none none true
VesselNo TEXT  Uncoded Value uncategorized none none true
DateEntered DATETIME  Uncoded Value uncategorized none none true
VesselDescription TEXT  Uncoded Value uncategorized none none true
CatNo TEXT  Uncoded Value uncategorized none none true
ID BIGINT  Uncoded Value uncategorized none none true
Context4 TEXT  Uncoded Value uncategorized none none true
Notes 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
DateUpdated DATETIME  Uncoded Value uncategorized none none true
UpdatedBy TEXT  Uncoded Value uncategorized none none true

Data Table Relationships:

Type Local Table Foreign Table Column Relationships
MANY_TO_ONE Artefacts Contexts UnitandArea UnitandArea Site Site
ONE_TO_MANY Artefacts MatchingSets CatalogueNumber CatalogueNumber
MANY_TO_ONE Artefacts Type Series TSName TSName TSNo TSNo Site Site
MANY_TO_ONE Contexts MasterContexts MasterContext MasterContext Site Site
MANY_TO_ONE Phases Contexts PhaseNo Phase1
MANY_TO_ONE Phases Contexts PhaseNo Phase2
ONE_TO_MANY Artefacts Vessels CatalogueNumber CatNo
MANY_TO_ONE Contexts ContextRelationships UnitandArea ContextObject Site Site
MANY_TO_ONE Contexts ContextRelationships Site Site UnitandArea ContextSubject
ONE_TO_MANY Artefacts ImagesTable CatalogueNumber CatalogueNumber

License

license image

Creative Commons Attribution ShareAlike

This license lets others remix, tweak, and build upon your work even for commercial purposes, as long as they credit you and license their new creations under the identical terms. This license is often compared to “copyleft” free and open source software licenses. All new works based on yours will carry the same license, so any derivatives will also allow commercial use. This is the license used by Wikipedia, and is recommended for materials that would benefit from incorporating content from Wikipedia and similarly licensed projects.

view details

Temporal Coverage

Calendar Date: 1800 to 1930

Spatial Coverage

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

Record Identifiers

TDAR ID(s): 6874

Site Code(s): CUGL1994

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

Notes

General Note: See Keeping up with the McNamaras for an account of the EAMC analysis project.

General Note: Martin Carney (Glass & bottle stoppers), Kevin Barnes (Building Materials), Graham Wilson (Ceramics & tobacco pipes), Kate Holmes (Metal), Nadia Iacono (Miscellaneous), Rebecca Bower (Leather), Dominic Steele (Animal bone & shell), Wayne Johnson (Coins, medals & tokens), Roy Lawrie (Soil samples), Claire Everett (Parasites & macrobotanics), Mike McPhail (Palynological), Christina Kanellakis (Drafting of site plans)

Source Collections

The Cumberland and Gloucester Street site (CUGL1994) collection is held by the Sydney Harbour Foreshore Authority.

File Information

  Name Size Creation Date Date Uploaded Access
eamc_cugl.mdb 61.69mb Aug 20, 2016 11:45:29 AM Public
  • Translated version eamc_cugl_translated.xlsx (26.43mb)
    Data column(s) in this dataset have been associated with coding sheet(s) and translated: