tDAR Logo tDAR digital antiquity

Lilyvale datasets

Creator(s): Penny Crook ; Tim Murray

Year: 2006

» Downloads & Basic Metadata

Summary

Artefact and context data from the Lilyvale excavation in 1989. Records were compiled and assessed by the EAMC team, and some terminology was normalised, but the core artefact descriptions were not modified. The original catalogue was co-ordinated by Wendy Thorp and Leah McKenzie.


This Resource is Part of the Following Collections


Cite this Record

Lilyvale datasets. Penny Crook, Tim Murray. 2006 ( tDAR id: 407304) ; doi:10.6067/XCV8CF9S6N


Restricted Access Some or all of this resource's attached file(s) are not publicly accessible.

Data Set Structure

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

Table Information: Artefacts

Column Name Data Type Type Category Coding Sheet Ontology
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  Uncoded Value 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
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  Uncoded Value uncategorized none none
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
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
Images 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
Mineral TEXT  Uncoded Value uncategorized none none
BoAgeInGLC TEXT  Uncoded Value uncategorized none none
MaterialQ BOOLEAN  Uncoded Value uncategorized none none
Site The excavation site code, often including the year of excavation, eg CUGL1994
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
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  Uncoded Value 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
BoneAnimalSide Left, right or centre of animal, eg the left or right femur.
TEXT  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: ListOfActivities

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Source TEXT  Uncoded Value uncategorized none none
OtherNames TEXT  Uncoded Value uncategorized none none
Notes TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
Activity TEXT  Uncoded Value uncategorized none none
ActivityID BIGINT  Uncoded Value uncategorized none none

Table Information: ListOfArtefactClasses

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
Arteclass TEXT  Uncoded Value uncategorized none none
ArteclassID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofColours

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
ColourID BIGINT  Uncoded Value uncategorized none none
ColourName TEXT  Uncoded Value uncategorized none none

Table Information: ListofContextTypes

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
context type 2 TEXT  Uncoded Value uncategorized none none
context type 1 TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofDecorations

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
DecorationName TEXT  Uncoded Value uncategorized none none
DecorationID BIGINT  Uncoded Value uncategorized none none
Notes TEXT  Uncoded Value uncategorized none none

Table Information: ListofFormProfiles

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
FormName TEXT  Uncoded Value uncategorized none none
FormID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofFormSections

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
SectionShapeName TEXT  Uncoded Value uncategorized none none
SectionShapeID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofFunctions

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
SampleSubfunctions TEXT  Uncoded Value uncategorized none none
FunctionName TEXT  Uncoded Value uncategorized none none
Activity TEXT  Uncoded Value uncategorized none none
OldFunctionID BIGINT  Uncoded Value uncategorized none none
FunctionID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofIDMarks

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
IDMarkName TEXT  Uncoded Value uncategorized none none
MarkID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofMakers

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
References TEXT  Uncoded Value uncategorized none none
MakerNotes TEXT  Uncoded Value uncategorized none none
MakerDates TEXT  Uncoded Value uncategorized none none
MakerProvinence TEXT  Uncoded Value uncategorized none none
ProductType TEXT  Uncoded Value uncategorized none none
MakerType M for Maker, D for Distributor
TEXT  Uncoded Value uncategorized none none
MakerName TEXT  Uncoded Value uncategorized none none
MakerID BIGINT  Uncoded Value uncategorized none none

Table Information: ListOfMaterials

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
ArtefactClassID BIGINT  Uncoded Value uncategorized none none
ArtefactClass TEXT  Uncoded Value uncategorized none none
MaterialName TEXT  Uncoded Value uncategorized none none
MaterialID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofModifications

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
ModificationName TEXT  Uncoded Value uncategorized none none
ModificationID BIGINT  Uncoded Value uncategorized none none

Table Information: ListOfPatterns

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
PatternType TEXT  Uncoded Value uncategorized none none
PatternName TEXT  Uncoded Value uncategorized none none
PatternID BIGINT  Uncoded Value uncategorized none none

Table Information: ListOfPortions

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
PortionName TEXT  Uncoded Value uncategorized none none
PortionID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofProvenance

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
ProvenanceName TEXT  Uncoded Value uncategorized none none
ProvenanceID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofRemovalReasons

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
RemovalReason TEXT  Uncoded Value uncategorized none none
RemovalReasonID BIGINT  Uncoded Value uncategorized none none
RemovalReasonType TEXT  Uncoded Value uncategorized none none

Table Information: ListOfSites

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
Year/s TEXT  Uncoded Value uncategorized none none
Excavator TEXT  Uncoded Value uncategorized none none
SiteOwner TEXT  Uncoded Value uncategorized none none
Address TEXT  Uncoded Value uncategorized none none
CatalogueNumberPrefix TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
SiteCode TEXT  Uncoded Value uncategorized none none
SiteID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofSkeletalElements

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
Use TEXT  Uncoded Value uncategorized none none
Activity TEXT  Uncoded Value uncategorized none none
area of body TEXT  Uncoded Value uncategorized none none
skeletal element TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofSubfunctions

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
ActivityID BIGINT  Uncoded Value uncategorized none none
FunctionID BIGINT  Uncoded Value uncategorized none none
Notes TEXT  Uncoded Value uncategorized none none
Order BIGINT  Uncoded Value uncategorized none none
SubfunctionName TEXT  Uncoded Value uncategorized none none
SubfunctionID BIGINT  Uncoded Value uncategorized none none

Table Information: ListofTechniques

Column Name Data Type Type Category Coding Sheet Ontology
UpdatedBy The log-on name of the person who modified the record while using the List Form.
TEXT  Uncoded Value uncategorized none none
DateUpdated The last date on which any field in this record was modified while using the List 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
Notes TEXT  Uncoded Value uncategorized none none
TechniqueName TEXT  Uncoded Value uncategorized none none
TechniqueManufID BIGINT  Uncoded Value uncategorized none none

Table Information: MasterContexts

Column Name Data Type Type Category Coding Sheet Ontology
DateNotes TEXT  Uncoded Value uncategorized none none
MaxDate BIGINT  Uncoded Value uncategorized none none
MinDate BIGINT  Uncoded Value uncategorized none none
ContextType2 TEXT  Uncoded Value uncategorized none none
ContextType1 TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
Notes TEXT  Uncoded Value uncategorized none none
Phase2 BIGINT  Uncoded Value uncategorized none none
Phase1 BIGINT  Uncoded Value uncategorized none none
BldgArea TEXT  Uncoded Value uncategorized none none
BldgCode TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
MasterContext TEXT  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

Data Table Relationships:

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

Keywords


Spatial Coverage

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

Individual & Institutional Roles

Contact(s): Penny Crook

Lab Director(s): Leah McKenzie

Principal Investigator(s): Wendy Thorp ; Graham Wilson ; Julia Byrnes ; Brett Noble ; Dominic Steele ; Jane Lydon ; Wayne Johnson ; Mafalda Rossi

Sponsor(s): Sydney Harbour Foreshore Authority ; Godden Mackay Logan ; Heritage Victoria ; NSW Heritage Office ; City of Sydney

Repository(s): Sydney Harbour Foreshore Authority


Record Identifiers

Site Code(s): LV

TDAR ID(s): 6877

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

Notes

General Note: Leah McKenzie (Co-ordinator); Graham Wilson (tobacco pipes); J Byrnes (glass); Dominic Steele (Animal bone & shell); Brett Noble (Building Materials); Jane Lydon (Sewing artefacts, Flatware and Clerical/education artefacts) ; Wayne Johnson (Coins and tokens); Mafalda Rossi (Lead bottle seals, Buttons & beads, Seeds); Ruth Norton & Kate Chidlow, Powerhouse Museum (Conservation)

Rights & Attribution: © EAMC Industry Partners 2012


File Information

  Name Size Creation Date Date Uploaded Access
eamc_lv.mdb 21.47mb Aug 20, 2016 11:52:17 AM Confidential

Accessing Restricted Files

At least one of the files for this resource is restricted from public view. For more information regarding access to these files, please reference the contact information below

Contact(s): Penny Crook

Arizona State University The Andrew W. Mellon Foundation National Science Foundation National Endowment for the Humanities Society for American Archaeology Archaeological Institute of America