HAA-IncDatabase
Year: 2004
Summary
HAA Inc Database
Cite this Record
HAA-IncDatabase. 2004 ( tDAR id: 520952) ; doi:10.48512/XCV8520952
Data Set Structure
Measurement Column
Count Column
Coded Column
Filename Column
Integration Column (has Ontology)
Table Information: Artifact_Description
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| bytHistoryNumberOfChanges | Number of changes to this record | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| lngHistoryChangeEmplID | Employee who last changed record | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| dtmHistoryChangeDate | Date record was last changed | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| lngHistoryCreateEmplID | Employee who originally added record to database | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| dtmHistoryCreateDate | Date record was originally added to database | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| NYSM_Type | New York State Museum artifact type code | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| NYSM_Material | New York State Museum material code | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Bag_Number | Bag Number or Numbers | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | Additional information not covered in other fields | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Bore_Diameter | Diameter of tobacco pipe bore hole | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Thickness | Thickness or depth of object | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Width | Width of object | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Length | Length of object | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Date_Range | Date inscribed on object or range of dates object was used | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Mark | Description of mark, or text of mark | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Condition | Condiditon of object | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Element | Which portion of the total object, or whole | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Manufacturing_Technology | Method of manufacture | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Color | Color of decoration or object | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Surface_Decoration | Decoration placed on surface of object | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Body_Decoration | Decoration integral to the body of the artifact | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Subtype | More specific name of object | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Type | The basic name of the object | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Material | What the object is made of | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Class | What is its function | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Culture | When was the object made | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Weight | Weight of object in grams | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Count | How many fragments | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Item | Item number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| BagNumber | Context Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Collection_Num | Collection Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Phase | Phase | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Project_Num | Project Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Munsell_Color
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| bytHistoryNumberOfChanges | Number of changes to this record | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| lngHistoryChangeEmplID | Employee who last changed record | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| dtmHistoryChangeDate | Date record was last changed | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| lngHistoryCreateEmplID | Employee who originally added record to database | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| dtmHistoryCreateDate | Date record was originally added to database | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| Munsell_Color_Number | Munsell Color Number and Name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ProvenienceID | Provenience ID | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| lngMunsellColorID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Project_Information
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| bytHistoryNumberOfChanges | Number of changes to this record | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| lngHistoryChangeEmplID | Employee who last changed record | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| dtmHistoryChangeDate | Date record was last changed | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| lngHistoryCreateEmplID | Employee who originally added record to database | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| dtmHistoryCreateDate | Date record was originally added to database | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| Occ_Dates | Cultural affiliation / estimated occupation dates | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Site Components | Site Components (not just historic / prehistoric) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Nat_Reg_HP | State / National Register of Historic Places | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Sect_106 | National Historic Preservation Act - section 106 | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| SEQR | State Environment Quality Review Act - 14.09 | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| State_Fed_Agencies | State / Federal Agencies | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Native_Interest | Native Interest/ Sovereign Nation Jurisdiction | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Repository | Final Destination Repository | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Collection_Owner | Collection owner | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Collection_Num | HAA, Inc. Collection Number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Other_State_Num | Additional state or other site number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Vermont_Site_Num | Vermont Site number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| NYS_OPRHP | NYS OPHRP reference number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Client | Client | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| State | State | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Counties | Each county project is found in | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Municipalities | Cities, Towns, Villages etc. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Project_Director | Project Director | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Project_Name | Project Name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Phase_Name | Descriptive Name of Phase, if needed. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Phase | Phase | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Project_Num | Project Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ProjectID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Provenience
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Feature_SamplesParasites | TEXT | Uncoded Value | uncategorized | none | none | true |
| Feature_SamplesPollen | TEXT | Uncoded Value | uncategorized | none | none | true |
| Feature_SamplesFlotation | TEXT | Uncoded Value | uncategorized | none | none | true |
| Feature_SamplesC-14 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Feature_FillMunsellColor | TEXT | Uncoded Value | uncategorized | none | none | true |
| Feature_FillSoilType | TEXT | Uncoded Value | uncategorized | none | none | true |
| Feature_Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| Feature_GenShape | TEXT | Uncoded Value | uncategorized | none | none | true |
| Feature_Thickness | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Feature_Width | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Feature_Length | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Feature_Description | Additional feature information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Feature_Number | TEXT | Uncoded Value | uncategorized | none | none | true |
| dtmBagDateRetrieved | DATETIME | Uncoded Value | uncategorized | none | none | true |
| strBagExcavator | TEXT | Uncoded Value | uncategorized | none | none | true |
| bytHistoryNumberOfChanges | Number of changes to this record | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| lngHistoryChangeEmplID | Employee who last changed record | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| dtmHistoryChangeDate | Date record was last changed | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| lngHistoryCreateEmplID | Employee who originally added record to database | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| dtmHistoryCreateDate | Date record was originally added to database | |||||
| DATETIME | Uncoded Value | uncategorized | none | none | true | |
| UnitComments | Comments, Disturbances, ect. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitMarerial_Not_Collected | Material that was not collected from context. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitMaterial_Culture | Contains prehistoric, historic, both or no materials | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitSoil_Inclusions | Inclusions within the soil | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitSoil_Type | Soil Type | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level_Cultural | Level type - cultural. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Level_Natural | Level type - natural. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Level_Arbitrary | Level type - arbitrary. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Close_Depth_SE | SE corner closing depthin cm. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Close_Depth_SW | SW corner closing depthin cm. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Close_Depth_NE | NE corner closing depthin cm. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Close_Depth_NW | NW corner closing depthin cm. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Open_Depth_SE | SE corner opening depthin cm. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Open_Depth_SW | SW corner opening depthin cm. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Open_Depth_NE | NE corner opening depthin cm. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Open_Depth_NW | NW corner opening depthin cm. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Datum_At | Datum point for unit. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitCoordinate_E/W | East / West Coordinate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| UnitCoordinate_N/S | North / South Coordinate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Dim_Width | Width Dimension of Unit. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Dim_Length | Lengthwise Dimension of Unit. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| UnitStratum | Stratum Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Unit | Unit Number | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| UnitLocus_Area | Locus or Area of Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TrenchComments | Comments, Disturbances, ect. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TrenchDatum | Datum point for unit. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TrenchCoordinate_E/W | East / West Coordinate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TrenchCoordinate_N/S | North / South Coordinate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TrenchMarerial_Not_Collected | Material that was not collected from context. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TrenchMaterial_Culture | Contains prehistoric, historic, both or no materials | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TrenchSoil_Inclusions | Inclusions within the soil | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TrenchSoil_Type | Soil Type | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus_Area | Locus or Area of Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Ending_Horizontal_Distance | End distance from point of measurement (for this context) in feet. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Starting_Horizontal_Distance | Start distance from point of measurement (for this context) in feet. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Point_of_Measurement | From which end of the trench horizontal measurements were derived. Eg. N, S, NE ... | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Stratum | Stratum Number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Trench_Num | Trench Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ShovelTestComments | Comments, Disturbances, ect. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ShovelTestMarerial_Not_Collected | Material that was not collected from context. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ShovelTestMaterial_Culture | Contains prehistoric, historic, both or no materials | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ShovelTestSoil_Inclusions | Inclusions within the soil | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ShovelTestSoil_Type | Soil Type | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level | Level Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ShovelTestLocus_Area | Locus or Area of Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Termination_Reason | Reason the shovel test was terminated, in the case of base of excavation. | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Base_of_Excavation | Is this context the base of the shovel test ? | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Closing_Depth | Closing depth or depths | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Starting_Depth | Strating depths or depths in centimeters. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Directional | Direction off of original shovel test | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Shovel_Test_Num | Shovel Test Number | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| Other | Other location descriptor | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Coordinate_E/W | East / West Coordinate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Coordinate_N/S | North / South Coordinate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SurfaceDescription | Description | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Transect | Which Transect? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Area | Area of Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus of Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SDP | Survey Datum Point | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| GeneralDescription | Description | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| GeneralLocus_Area | Locus or Area of Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Context | Context Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| BagComments | TEXT | Uncoded Value | uncategorized | none | none | true |
| BagNumber | Bag Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Phase | Phase of project | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Project_Num | Project Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ProvenienceID | BIGINT | Uncoded Value | uncategorized | none | none | true |
Data Table Relationships:
| Type | Local Table | Foreign Table | Column Relationships |
|---|---|---|---|
| MANY_TO_ONE | Munsell_Color | Provenience | ProvenienceID ProvenienceID |
| ONE_TO_MANY | Provenience | Project_Information | Phase Phase Project_Num Project_Num |
| MANY_TO_ONE | Artifact_Description | Provenience | Phase Phase Project_Num Project_Num BagNumber BagNumber |
File Information
| Name | Size | Creation Date | Date Uploaded | Access | |
|---|---|---|---|---|---|
| HAA-IncDatabase.mdb | 35.07mb | Jul 15, 2026 10:55:47 AM | Public | ||
|
Translated version
HAA-IncDatabase_translated.xlsx
(681.16kb)
Data column(s) in this dataset have been associated with coding sheet(s) and translated:
|
|||||