Cumberland and Gloucester Streets (CUGL) artefact data
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
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
Table Information: Artefacts
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
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 |
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 |
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 |
Context4 | 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 |
Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
Context1 | 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 |
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
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.
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)
Site Type
Commercial
•
Cottage
•
Domestic
•
House
•
Industrial
•
Manufacturing
•
Shop
•
Terrace
•
Urban
General
Comparative assemblage analysis
Geographic Keywords
Sydney, New South Wales, Australia
Temporal Keywords
19th Century
•
Convict era
•
early-20th century
•
late-18th century
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 ;
Individual & Institutional Roles
Principal Investigator(s): Martin Carney; Graham Wilson; Kevin Barnes; Kate Holmes; Nadia Iacono; Rebecca Bower; Dominic Steele; Wayne Johnson
Sponsor(s): Sydney Harbour Foreshore Authority; Historic Houses Trust; Heritage Victoria; Godden Mackay Logan; NSW Heritage Office ; City of Sydney
Repository(s): Sydney Harbour Foreshore Authority
Prepared By(s): Godden Mackay Logan
Submitted To(s): Sydney Harbour Foreshore Authority
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:
|