First Government House datasets
Part of the Exploring the Archaeology of the Modern City project
Creator(s): Penny Crook; Tim Murray
Year: 2005
Primary Copyright Holder: La Trobe UniversitySummary
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.
Cite this Record
First Government House datasets. Penny Crook, Tim Murray. 2005 ( tDAR id: 407303) ; doi:10.6067/XCV8QJ7KCG
This Resource is Part of the Following Collections
Data Set Structure
Table Information: Artefacts
Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
---|---|---|---|---|---|---|
IDNumber | Unique identification number allocated to each artefact. For all artefacts catalogued prior to 2001 this is the 'original' number and appears on the bag. | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
CatalogueNumber | The IDNumber preceded by an abbreviated Site code. This allows multiple catalogues each numbered 1 to ~ to be combined in the same database. All labels printed from 2001 onwards show the Catalogue Number rather than IDNumber. (Added by the EAMC) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Site | The excavation site code, often including the year of excavation, eg CUGL1994 | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unit | The stratigraphic Unit from which the artefact was excavated, eg B101. (From the original CUGL catalogue) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
UnitArea | A sub-strata of the Unit, ie a grid square within a Unit (eg B101/B1). The 'UnitArea' as defined in the original CUGL catalogue. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
UnitandArea | The full stratigraphic Unit reference for the deposit from which the artefact was recovered | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
PhaseA | The first Site Phase to which the stratigraphic Unit from which the artefact was recovered may be dated. (From the original CUGL catalogue) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
PhaseB | The last Site Phase to which the stratigraphic Unit from which the artefact was recovered may be dated. (From the original CUGL catalogue) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
Activity | The pre-defined, broad functional Activity group to which the artefact was likely to belong. Activity is the first of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came). | |||||
TEXT | Coded Value | uncategorized | EAMC Activities Definitions | EAMC Activities | true | |
ActivityQ | A checkbox to be ticked when the allocated Activity group is considered tentative or speculative. (Added by the EAMC) | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Function | The pre-defined, Function group to which the artefact was likely to belong. Function is the second of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came). | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
FunctionQ | A checkbox to be ticked when the allocated Function group is considered tentative or speculative. (Added by the EAMC) | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Subfunction | The pre-defined, a more specific functional group to which the artefact was likely to belong. Function is the second of three tiers of fields that describe the likely function of the artefact (or the vessel or object from which it came). | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SubfunctionQ | A checkbox to be ticked when the allocated Subfunction group is considered tentative or speculative. (Added by the EAMC) | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
Arteclass | Broad Artefact Class for each artefact (eg Glass, Ceramic, Building Material). | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Material | Specific Material class for each artefact (eg Fine Earthenware, Porcelain). | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MaterialQ | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
CeramicBody | The specific fabric of a ceramic vessel (eg 'Creamware', where 'Fine Earthenware' appears in the Material field). (From the original LV and FGH-YRP catalogues. In the CUGL system the Ceramic Body is described via the Type Series.) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Integrity | Describes the Integrity or completeness of sherd within one bag by recording the relationship of elements within that bag. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Percentage | Estimated percentage of the total vessel or piece that the elements in the bag represent. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Quantity | The number of sherds or individual elements in the bag, regardless of whether they conjoin to form a whole piece. | |||||
DOUBLE | Count | uncategorized | none | none | true | |
Form | Description of the profile of the original vessel or part there of (eg base or rim), as determined from the surviving sherd (eg 'everted rim', 'London-profile' for a tea cup). | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Shape | Description of the section of vessel, as determined from the sherd (eg 'round' for a teacup, 'oval' for a platter etc) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Portion | The part of the vessel that artefact derived. Eg the 'stem' of a pipe, or 'rim' of tea cup. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Decoration | The method of applying the decoration (eg 'transfer-print', 'hand-painted' etc) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DecorationPlacement | The face(s) of the vessel or sherd on which the decoration appears. This aids the identification of function, eg decoration appears on the 'concave' face of plates and saucers; teacups are 'double-sided'. (Added by the EAMC, Nov 2002) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Colour | The colour(s) of the decoration on the vessel (eg 'red' transfer-print, or the body of an undecorated vessel or object (eg 'olive-green' glass). | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Pattern | The name of a known pattern or decorative style (eg ‘Lachlander’ pipe; ‘Willow’ plate), or general description (eg ‘Scenic’; 'Floral') if the precise pattern name is not known. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TechniqueManuf | The technological process by which the artefact was manufactured, eg 'hand-thrown', 'moulded', 'blown'. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Modifictns | Changes to the artefact occurring after its manufacture, while in use or after discard and deposition, excluding breakage, eg 'mended', 'inscribed'. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
IDMarks | Function or purpose of any mark found on an artefact, as described in the Transcript field, eg 'Manufacturer's mark', 'Slogan'. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Transcript | Direct transcription of any text found on the artefact; gaps or speculative text should be enclosed in square parentheses: [ and ]. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MakerID | Dedicated field for the name of the Maker, as identified from basemarks, unique patterns, etc. This field contained a unique identifier for each maker, stored in the ListOfMakers table. (Added by the EAMC; Feb 2002) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
DistributorID | Dedicated field for the name of the Distributor, as identified from basemarks, unique patterns, etc. This field contained a unique identifier for each distributor, stored in the ListOfMakers table. (Added by the EAMC; Feb 2002) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Lengthinmm | Actual or estimated length of the vessel from which the sherd derives, in mm. This field does not record the length of sherds in their current state. | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
QRChecked | Administrative check box used to mark all artefact checked during the Quality Review Assessment. | |||||
BOOLEAN | 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 | |
VesselIDno | Identification number to represent sherds recovered from different contexts (and hence in different bags) that conjoin to form a single object. (Added by the EAMC, 2001) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
MNVID | Identification number to group artefacts that potentially are part of the same vessel, for the purposes of Minimum Vessel Counts (MVC) only. (Added by the EAMC, Feb 2003) | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
MNVQty | Minimum number of vessels or objects represented by the MNVID. (Added by the EAMC, Feb 2003) | |||||
BIGINT | 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 | |
MatchingSetID | Unique Identification number to group artefacts that potentially formed part of a matching set. (Added by the EAMC, Feb 2003) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
MatchingSetType | Whether the Matching Set is considered 'Complementary' or an exact match. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
OriginalContext | Field containing the stratigraphic Unit as it was when imported into the database. Several FGH Units were originally mistyped and referred to unknown strata. These were corrected in order to link to Contexts table; and the original data retained.. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SplitFrom | For bags split after the initial phase of cataloguing, this field records the original Catalogue Number. | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
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 | |
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 |
---|---|---|---|---|---|---|
Site | Site code | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MasterContext | Overarching Context Number allocated to a group of stratigraphic contexts or Units deposited as part of the same event, but excavated separately (added by EAMC, 2002) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Unit | Trench or area number of the stratigraphic context or feature | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
UnitArea | Specific unit number of the stratigraphic context or feature | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
UnitandArea | Full unit code including Trench and Unit Number, and Site if required to distinguish from other contexts. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
UnitCode | Unique code incorporating Site and Unit number | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
AreaAlph | Alpha ref or square for gridded occupation deposits, eg 'A' for square 'A1' | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
AreaNo | Numerical ref of square for gridded occupation deposits, eg '1' for square 'A1' | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Spit | Spit number, where relevant | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ContextType1 | The broad category of strata, eg 'Fill', 'Service feature', 'Structural element' | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ContextType2 | The specific kind of context eg 'Fill - cesspit', 'Service feature - drain', etc | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
BldgPhase | TEXT | Uncoded Value | uncategorized | none | none | true |
BldgCode | Code of the building with which this Unit is associated. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
BldgCodeNotes | Additional notes about bldg code, where necessary | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
BldgArea | The Area of the Building in which this Unit or feature was revealed. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Location | The part of the site where this Unit or feature was revealed. This is designed to allow for Units or features revealed in the locale of a building bu could not be associated with the Building itself (ie it may have been earlier or later). | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Description | Brief description of context | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Notes | More detailed notes about the Unit. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ExcavationPhase | Phase of the site's excavation during which the context was dug; added largely to cater for FGH | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ExcavatedBy | Name of the excavator, where known | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ExcavatedDate | Date excavation began, where known | |||||
DATETIME | Uncoded Value | uncategorized | none | none | true | |
Below | The Unit above the current Unit, ie the current Unit is Below Unit X | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Above | The Unit below the current Unit, ie the current Unit is Above Unit X | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
SameAs | Other Units identified during excavation to be the same as the current Unit. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Disturbed | Whether or not the Unit or feature has been disturbed by later deposition (added by the EAMC) | |||||
BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
ConjoinsWith | Other Units identified as containing sherds that conjoin with artefacts in the current Unit. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Priority1 | Priority for detailed cataloguing as identified for the CUGL assemblage. (For the CUGL catalogue only.) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Priority2 | Priority for detailed cataloguing as identified for the CUGL assemblage. (For the CUGL catalogue only.) | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Phase1 | The earliest Site Phase in which the Unit or feature may have been created | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Phase2 | The latest Site Phase in which the Unit or feature may have been created | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
PhaseNotes | Notes about the phasing of the Unit or feature. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MinDate | TPQ, or the earliest minimum year in which the Unit or feature may have been created, as determined by the artefact with the latest minimum manufacture date | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MinDateNotes | Notes regarding the determination of the TPQ. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MaxDate | TAQ, or the latest maximum year in which the Unit or feature may have been created, usually determined by the minimum date of the strata above this Unit. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
MaxDateNotes | Notes regarding the determination of the TAQ. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DateNotes | General notes about dating the Unit or feature. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Volume | Volume of the Unit, if provided on the Context Sheet. | |||||
DOUBLE | Uncoded Value | uncategorized | none | none | true | |
Reference | Bibliographic reference for the Unit or feature. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Plans | Plans showing the Unit or feature. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
EnteredBy | The log-on name of the person who created the record. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DateEntered | The date the database record was created. | |||||
DATETIME | Uncoded Value | uncategorized | none | none | true | |
UpdatedBy | The log-on name of the person who modified the record while using the Contexts Form. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
DateUpdated | The last date on which any field in this record was modified while using the Contexts Form. | |||||
DATETIME | Uncoded Value | uncategorized | none | none | true | |
Colour | Colour of the deposit (Added 17 July 02 to accommodate LV context sheets) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Texture | Texture of the deposit (Added 17 July 02 to accommodate LV context sheets) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Moisture | Moisture level of the deposit (Added 17 July 02 to accommodate LV context sheets) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Components | Components within the deposit (Added 17 July 02 to accommodate LV context sheets) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Length | Length of the deposit or feature (Added 17 July 02 to accommodate LV context sheets) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Width | Width of the deposit or feature (Added 17 July 02 to accommodate LV context sheets) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Diameter | Diameter of the deposit or feature (Added 17 July 02 to accommodate LV context sheets) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
HeightOrDepth | Height or depth of the deposit or feature (Added 17 July 02 to accommodate LV context sheets) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: 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: 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 |
---|---|---|---|---|---|---|
Site | Must match the site code in the artefacts database | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Project | Specify project if not part of the original catalogue, ie EAMC. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Arteclass | Artefact Class | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TSName | Name of this Type Series group | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TSNo | Number of the subgroup within Type Series group | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
ArtID | ID number of the artefact selected as the representative Type ('T') for this Type Group. | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
ArtefactID | ID number of the artefact selected as the representative Type ('T') for this Type Group. | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
Description | Description of this subgroup | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Colour/pattern | Colour or pattern name, where appropriate | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Portion | The portion of artefact defined by this subgroup, where appropriate (eg pushup bases for bottle groups) | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Dimensions | Dimensions of artefacts as defined by this subgroup, where appropriate | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
TS abbrev | Abreviation of the TS Name, used in cataloguing, where known (eg AW for Aerated Waters') | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Maker | Name of Maker defined by this subgroup, where appropriate | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
Provenance | Provenance or place made, as defined by this subgroup, where appropriate | |||||
TEXT | Uncoded Value | uncategorized | none | none | true | |
From | The earliest production date of artefacts defined by this subgroup, where known | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
To | The latest production date of artefacts defined by this subgroup, where known | |||||
BIGINT | Uncoded Value | uncategorized | none | none | true | |
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 |
---|---|---|---|---|---|---|
ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
VesselNo | TEXT | Uncoded Value | uncategorized | none | none | true |
VesselDescription | TEXT | Uncoded Value | uncategorized | none | none | true |
CatNo | TEXT | Uncoded Value | uncategorized | none | none | true |
Site | TEXT | Uncoded Value | uncategorized | none | none | true |
TSName | TEXT | Uncoded Value | uncategorized | none | none | true |
TSNo | DOUBLE | Uncoded Value | uncategorized | none | none | true |
TSDetails | TEXT | Uncoded Value | uncategorized | none | none | true |
Context1 | TEXT | Uncoded Value | uncategorized | none | none | true |
Context2 | TEXT | Uncoded Value | uncategorized | none | none | true |
Context3 | TEXT | Uncoded Value | uncategorized | none | none | true |
Context4 | TEXT | Uncoded Value | uncategorized | none | none | true |
Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
DateEntered | DATETIME | Uncoded Value | uncategorized | none | none | true |
EnteredBy | TEXT | Uncoded Value | uncategorized | none | none | true |
DateUpdated | DATETIME | Uncoded Value | uncategorized | none | none | true |
UpdatedBy | TEXT | Uncoded Value | uncategorized | none | none | true |
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
Creative Commons Attribution
This license lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.
Keywords
Material
Building Materials
•
Ceramic
•
Glass
•
Metal
•
miscellaneous
•
Organic
Site Name
First Government House site (Sydney)
Site Type
Cottage
•
Domestic
•
House
•
Institution
•
Municipal
•
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
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:
|