tDAR Logo tDAR digital antiquity

First Government House datasets

Creator(s): Penny Crook ; Tim Murray

Year: 2005

» Downloads & Basic Metadata

Summary

Complete suite of artefact datasets from the First Government House site, as upgraded for the Exploring the Archaeology of the Modern City project. It combines two datasets created for the main series of excavations from 1983 and 1987, and excavations in Young Street and Raphael Place in 1991. The data was originally created by teams working for Anne Bickford and Wendy Thorp.


This Resource is Part of the Following Collections


Cite this Record

First Government House datasets. Penny Crook, Tim Murray. 2005 ( tDAR id: 407303) ; doi:10.6067/XCV8QJ7KCG


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
Images TEXT  Uncoded Value uncategorized none none
Mineral TEXT  Uncoded Value uncategorized none none
ShellCond TEXT  Uncoded Value uncategorized none none
ShellNoBas DOUBLE  Uncoded Value uncategorized none none
ShellNoLid DOUBLE  Uncoded Value uncategorized none none
ShellNoFra DOUBLE  Uncoded Value uncategorized none none
ShellNoCom DOUBLE  Uncoded Value uncategorized none none
ShellCommn TEXT  Uncoded Value uncategorized none none
ShellScien TEXT  Uncoded Value uncategorized none none
Organic TEXT  Uncoded Value uncategorized none none
Seed TEXT  Uncoded Value uncategorized none none
AniMaxSize DOUBLE  Uncoded Value uncategorized none none
AnimalSize TEXT  Uncoded Value uncategorized none none
ButchOrien TEXT  Uncoded Value uncategorized none none
ButchType TEXT  Uncoded Value uncategorized none none
ButchLocat TEXT  Uncoded Value uncategorized none none
TeethCond TEXT  Uncoded Value uncategorized none none
TeethTooth TEXT  Uncoded Value uncategorized none none
BoneAnimalSide Left, right or centre of animal, eg the left or right femur.
TEXT  Uncoded Value uncategorized none none
BoneRelativeAge Relative age of animal, ie mature or juvenile.
TEXT  Uncoded Value uncategorized none none
BOAgeInGST TEXT  Uncoded Value uncategorized none none
BoAgeInGLC TEXT  Uncoded Value uncategorized none none
BoAttriTAS TEXT  Uncoded Value uncategorized none none
BoAttriTLC TEXT  Uncoded Value uncategorized none none
BoAttriTyp TEXT  Uncoded Value uncategorized none none
BoCondAss TEXT  Uncoded Value uncategorized none none
BoCondDesc TEXT  Uncoded Value uncategorized none none
BoCondName TEXT  Uncoded Value uncategorized none none
BoPortPerc TEXT  Uncoded Value uncategorized none none
BoPortName TEXT  Uncoded Value uncategorized none none
BoneNoFrag DOUBLE  Uncoded Value uncategorized none none
BoneNoComp DOUBLE  Uncoded Value uncategorized none none
SkeletalEl TEXT  Uncoded Value uncategorized none none
SkeletalElGroup TEXT  Uncoded Value uncategorized none none
SpeciesName TEXT  Uncoded Value uncategorized none none
QRAssess Overall Assessment of the extent of Problems identified during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none
QRProblem Any Problem with the artefact record identified during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none
QRChecked Administrative check box used to mark all artefact checked during the Quality Review Assessment.
BOOLEAN  Uncoded Value uncategorized none none
QRNotes Notes field used by the EAMC team during the Quality Review Assessment.
TEXT  Uncoded Value uncategorized none none
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
UpdatedBy The log-on name of the person who modified the record while using the Artefacts Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the Artefacts Form.
DATETIME  Uncoded Value uncategorized none none
EnteredBy The log-on name of the person who created the record.
TEXT  Uncoded Value uncategorized none none
DateEntered The date the database record was created.
DATETIME  Uncoded Value uncategorized none none
LabelPrinted Administrative checkbox to indicate whether a label has been printed for the artefact.
BOOLEAN  Uncoded Value uncategorized none none
SplitFrom For bags split after the initial phase of cataloguing, this field records the original Catalogue Number.
BIGINT  Uncoded Value uncategorized none none
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
MatchingSetType Whether the Matching Set is considered 'Complementary' or an exact match.
TEXT  Uncoded Value uncategorized none none
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
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
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
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
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
MNVQty Minimum number of vessels or objects represented by the MNVID. (Added by the EAMC, Feb 2003)
BIGINT  Count uncategorized none none
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
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
BoxNumber The number of the box in which the artefact is stored.
TEXT  Uncoded Value uncategorized none none
References Bibliographic references for any piece of information provided in the record.
TEXT  Uncoded Value uncategorized none none
Notes General notes about the artefact.
TEXT  Uncoded Value uncategorized none none
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
Condition Brief description of the condition of the artefact. (From the original LV and FGH-YRP catalogues.)
TEXT  Uncoded Value uncategorized none none
WeightGrms Weight of all sherds in the bag (in grams).
DOUBLE  Uncoded Value uncategorized none none
Provenance The country or town where the artefact was made.
TEXT  Uncoded Value uncategorized none none
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
DateTo Numeric field recording the last year of the period in which the artefact may have been manufactured.
BIGINT  Uncoded Value uncategorized none none
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
TSDetails Whether the artefact is the first representative Type (‘T’), or a ‘Repeat’ (‘R’) of that sub-Type.
TEXT  Uncoded Value uncategorized none none
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
TSName Name of the Type Series to which the artefact has been allocated, eg 'TP Earthenware Blue'.
TEXT  Uncoded Value uncategorized none none
Tilestrike For CUGL Building Materials only. (From the original CUGL catalogue)
TEXT  Uncoded Value uncategorized none none
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
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
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
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
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
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
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
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
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
TechniqueManuf The technological process by which the artefact was manufactured, eg 'hand-thrown', 'moulded', 'blown'.
TEXT  Uncoded Value uncategorized none none
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
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
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
Decoration The method of applying the decoration (eg 'transfer-print', 'hand-painted' etc)
TEXT  Uncoded Value uncategorized none none
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
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
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
Quantity The number of sherds or individual elements in the bag, regardless of whether they conjoin to form a whole piece.
DOUBLE  Count uncategorized none none
Percentage Estimated percentage of the total vessel or piece that the elements in the bag represent.
TEXT  Uncoded Value uncategorized none none
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
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
MaterialQ BOOLEAN  Uncoded Value uncategorized none none
Material Specific Material class for each artefact (eg Fine Earthenware, Porcelain).
TEXT  Uncoded Value uncategorized none none
Arteclass Broad Artefact Class for each artefact (eg Glass, Ceramic, Building Material).
TEXT  Uncoded Value uncategorized none none
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
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
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
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
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
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
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
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
UnitandArea The full stratigraphic Unit reference for the deposit from which the artefact was recovered
TEXT  Uncoded Value uncategorized none none
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
Unit The stratigraphic Unit from which the artefact was excavated, eg B101. (From the original CUGL catalogue)
TEXT  Uncoded Value uncategorized none none
Site The excavation site code, often including the year of excavation, eg CUGL1994
TEXT  Uncoded Value uncategorized none none
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
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

Table Information: ContextRelationships

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

Table Information: Contexts

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

Table Information: CurrentSite

Column Name Data Type Type Category Coding Sheet Ontology
CurrentSite TEXT  Uncoded Value uncategorized none none

Table Information: ImagesTable

Column Name Data Type Type Category Coding Sheet Ontology
Notes General notes about the image
TEXT  Uncoded Value uncategorized none none
FileType Jpg or .tif
TEXT  Uncoded Value uncategorized none none
CDNo No of CD in the EAMC pic series on which the original tif file is stored
TEXT  Uncoded Value uncategorized none none
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
Copyright Details of copyright restrictions on the image, if appropriate
TEXT  Uncoded Value uncategorized none none
Date Date the photograph was taken, where known
DATETIME  Uncoded Value uncategorized none none
Caption Caption for the image, where required
TEXT  Uncoded Value uncategorized none none
FileName Exact name of file, including the extension
TEXT  Uncoded Value uncategorized none none
Site Site Code
TEXT  Uncoded Value uncategorized none none
CatalogueNumber The Catalogue Number of the artefact (or one of the artefacts) in the image
TEXT  Uncoded Value uncategorized none none
ImageNo Unique ID number automatically allocated to each record of an Image in the database
BIGINT  Uncoded Value uncategorized none none

Table Information: Phases

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

Table Information: Type Series

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

Table Information: Vessels

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

Data Table Relationships:

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

License

license image

Creative Commons Attribution

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

view details

Keywords


Spatial Coverage

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

Individual & Institutional Roles

Field Director(s): Anne Bickford

Lab Director(s): Anne Bickford ; Wendy Thorp

Principal Investigator(s): Leah McKenzie ; Mafalda Rossi ; Julia Byrnes ; Wayne Johnson ; Brett Noble ; Graham Wilson ; Dominic Steele ; Jocelyn Brown ; John Macdonald ; Martin Carney ; Jean Smith ; Sarah Colley ; Lachlan Mairs ; Jennie Lindbergh ; Anthony Lowe ; Pam Watson ; Alice Gorman

Sponsor(s): Historic Houses Trust

Repository(s): Museum of Sydney


Record Identifiers

TDAR ID(s): 6876

Site Code(s): FGH-YRP; FGH83-87

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

Notes

Redaction Note: This record includes only the primary tables relevant to the First Government House assemblage. Look up tables are stored in the main EAMC dataset record.

General Note: FGH1983-87 cataloguers were: Leah McKenzie, Mafalda Rossi, Julie Byrnes, Wendy Thorp, Wayne Johnson, Brett Noble, Graham Wilson and Dominic Steele. Jocelyn Brown, John Macdonald and Wendy Thorp undertook data entry (Thorp & Campbell Conservation 1994: 24).

General Note: YRP cataloguers were Mafalda Rossi (ceramics), Martin Carney (glass bottles), Jean Smith (glass tableware), Sarah Colley and Lachlan Mairs (bone), Sarah Colley (shell), Jennie Lindbergh (metal, clay tobacco pipes), Anthony Lowe (building materials), Pam Watson (miscellaneous artefacts, synthetics, lead, coal/coke etc), Alice Gorman (Aboriginal artefacts) and Jennifer Dickens (conservation). Pam Watson undertook the data-entry and management of the Minark database.


Source Collections

The FGH collection is held at the Museum of Sydney, on the site of First Government House.

File Information

  Name Size Creation Date Date Uploaded Access
eamc_fgh.mdb 26.04mb Aug 20, 2016 11:50:46 AM Public
Translated version eamc_fgh_translated.xlsx (8.49mb)
Data column(s) in this dataset have been associated with coding sheet(s) and translated:
Arizona State University The Andrew W. Mellon Foundation National Science Foundation National Endowment for the Humanities Society for American Archaeology Archaeological Institute of America