Malpaso Database
Part of the Malpaso Valley - La Quemada project
Year: 2008
Summary
no description provided
Cite this Record
Malpaso Database. 2008 ( tDAR id: 1266) ; doi:10.6067/XCV87P8X92
Data Set Structure
Measurement Column
Count Column
Coded Column
Filename Column
Integration Column (has Ontology)
Table Information: _adHoc_element nameLU
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| element name | TEXT | Uncoded Value | uncategorized | none | none |
| adhoc_element_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _ArtCatAnalyticalClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| AnalyticalClass | TEXT | Uncoded Value | uncategorized | none | none |
| AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _ArtCatFunctionalClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| FunctionalClass | TEXT | Uncoded Value | uncategorized | none | none |
| FunctClassId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _ArtCatManufacturingClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| GenAnalyticalClass | TEXT | Uncoded Value | uncategorized | none | none |
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| ManufacturingClass | TEXT | Uncoded Value | uncategorized | none | none |
| ManufacturingClassId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _ArtCatMaterialClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| Material | TEXT | Uncoded Value | uncategorized | none | none |
| MaterialClassId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _ArtifactCatTypes
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Sort order | BIGINT | Uncoded Value | uncategorized | none | none |
| Type | TEXT | Uncoded Value | uncategorized | none | none |
| TypePrefix | TEXT | Uncoded Value | uncategorized | none | none |
| ArtCatTypeId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _AU_Phase3
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Phase_Name | phase name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Phase3_ID | Phase3 unique identifier - | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: _AUCultSpace
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| SubChapterId | Sub-chapter FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| CultSpace | Cultural space name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| CultSpaceId | Cultural Space unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: _AUGroupLvl1
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| SiteId | Site Fk | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| GroupLvl1 | Group Level1 name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| GroupLvl1Id | Group Level1 unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: _AUGroupLvl2
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| AuAreaId | BIGINT | Uncoded Value | uncategorized | none | none |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none |
| GroupLvl2 | TEXT | Uncoded Value | uncategorized | none | none |
| GroupLvl2Id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _AUPhase
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Phase | TEXT | Uncoded Value | uncategorized | none | none |
| PhaseId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _AUPhase2
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Phase2 | phase2 name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Phase2Id | Phase2 unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: _AUReportArea
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| SortOrder | numeric field for sorting records | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ReportArea | Report area name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteID | Site identifier and FK to sites lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ReportAreaId | Report area unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: _Botan_Types
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Botan_type | TEXT | Uncoded Value | uncategorized | none | none |
| Botan_type_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _Botanical_Types
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Botanical_type | TEXT | Uncoded Value | uncategorized | none | none |
| Botanical_type_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _BotTaxaPaula
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| s_Lineage | BLOB | Uncoded Value | uncategorized | none | none |
| s_GUID | TEXT | Uncoded Value | uncategorized | none | none |
| s_Generation | BIGINT | Uncoded Value | uncategorized | none | none |
| s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none |
| name | TEXT | Uncoded Value | uncategorized | none | none |
| ID | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CarbonSampleConcentration
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| ConcentrationSp | TEXT | Uncoded Value | uncategorized | none | none |
| Concentration | TEXT | Uncoded Value | uncategorized | none | none |
| ConcentrationId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CarbonSampleComposition
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CompositionSp | TEXT | Uncoded Value | uncategorized | none | none |
| Composition | TEXT | Uncoded Value | uncategorized | none | none |
| CompositionId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CarbonSamplePriority
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| PrioritySp | TEXT | Uncoded Value | uncategorized | none | none |
| Priority | TEXT | Uncoded Value | uncategorized | none | none |
| PriorityId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CarbonSampleSize
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| SizeSp | TEXT | Uncoded Value | uncategorized | none | none |
| Size | TEXT | Uncoded Value | uncategorized | none | none |
| SampleSizeId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _Cer_Element_Groups
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Element_group | TEXT | Uncoded Value | uncategorized | none | none |
| Element_group_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _Cer_Elements
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Element_Group | BIGINT | Uncoded Value | uncategorized | none | none |
| Element | TEXT | Uncoded Value | uncategorized | none | none |
| Cer_element_id | BIGINT | Uncoded Value | uncategorized | none | none |
| Desccription | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _CerForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| FormCode | TEXT | Uncoded Value | uncategorized | none | none |
| FormName | TEXT | Uncoded Value | uncategorized | none | none |
| OrderId | BIGINT | Uncoded Value | uncategorized | none | none |
| FormId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CerPortion
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| EnGroupPortion | TEXT | Uncoded Value | uncategorized | none | none |
| SpGroupPortion | TEXT | Uncoded Value | uncategorized | none | none |
| PortionCode | TEXT | Uncoded Value | uncategorized | none | none |
| PortionName | TEXT | Uncoded Value | uncategorized | none | none |
| OrderId | BIGINT | Uncoded Value | uncategorized | none | none |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CerRprtGrps
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| ReportGroupOrder | BIGINT | Uncoded Value | uncategorized | none | none |
| ReportGroupsSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| ReportGroups | TEXT | Uncoded Value | uncategorized | none | none |
| ReportGroupId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CerTrtmnt
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Treatment | TEXT | Uncoded Value | uncategorized | none | none |
| TrtmntId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CerType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| TrtmntId | BIGINT | Uncoded Value | uncategorized | none | none |
| ReportGroupId | BIGINT | Uncoded Value | uncategorized | none | none |
| TypeLabel | TEXT | Uncoded Value | uncategorized | none | none |
| TypeNameSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| TypeName | TEXT | Uncoded Value | uncategorized | none | none |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none |
| OrderId | DOUBLE | Uncoded Value | uncategorized | none | none |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CerType_Old_Bak
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| s_Lineage | left over from synch no longer needed - cant delete | |||||
| BLOB | Uncoded Value | uncategorized | none | none | ||
| s_GUID | left over from synch no longer needed - cant delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| s_Generation | left over from synch no longer needed - cant delete | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| s_ColLineage | left over from synch no longer needed - cant delete | |||||
| BLOB | Uncoded Value | uncategorized | none | none | ||
| type_label | TEXT | Uncoded Value | uncategorized | none | none | |
| type_name | TEXT | Uncoded Value | uncategorized | none | none | |
| decoration_type | TEXT | Uncoded Value | uncategorized | none | none | |
| order_id | BIGINT | Uncoded Value | uncategorized | none | none | |
| type_id | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: _CerTypeWare
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| WareNameSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| WareName | TEXT | Uncoded Value | uncategorized | none | none |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _ChapterGroups
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| AreaId | BIGINT | Uncoded Value | uncategorized | none | none |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none |
| ChapterGroup | TEXT | Uncoded Value | uncategorized | none | none |
| ChapterGroupId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _CulturalSpace
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| SubGroupId | BIGINT | Uncoded Value | uncategorized | none | none |
| CultSpace | TEXT | Uncoded Value | uncategorized | none | none |
| CultSpaceId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _DebCortex
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CortexSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Cortex | TEXT | Uncoded Value | uncategorized | none | none |
| CotexId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _DebMaterial
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| MaterialSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Material | TEXT | Uncoded Value | uncategorized | none | none |
| MaterialId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _DebStage
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| StageSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Stage | TEXT | Uncoded Value | uncategorized | none | none |
| StageId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _DebStageIdx
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| StageIndexSP | TEXT | Uncoded Value | uncategorized | none | none |
| StageIndex | TEXT | Uncoded Value | uncategorized | none | none |
| StageIdxId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _DebType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| TypeSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Type | TEXT | Uncoded Value | uncategorized | none | none |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _DebTypeB
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Typeb | TEXT | Uncoded Value | uncategorized | none | none |
| TypeBId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FieldNotebooks_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| FNTPDF | TEXT | Uncoded Value | uncategorized | none | none |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none |
| Year | BIGINT | Uncoded Value | uncategorized | none | none |
| NoteBookNumber | BIGINT | Uncoded Value | uncategorized | none | none |
| NotebookPrefix | TEXT | Uncoded Value | uncategorized | none | none |
| NotebookId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FieldNotebooks
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| FNTPDF | TEXT | Uncoded Value | uncategorized | none | none |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none |
| Year | BIGINT | Uncoded Value | uncategorized | none | none |
| NoteBookNumber | BIGINT | Uncoded Value | uncategorized | none | none |
| NotebookPrefix | TEXT | Uncoded Value | uncategorized | none | none |
| NotebookId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FigFinish
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Finish | TEXT | Uncoded Value | uncategorized | none | none |
| FinishId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FigPortion
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Portion | TEXT | Uncoded Value | uncategorized | none | none |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FigSex
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Sex | TEXT | Uncoded Value | uncategorized | none | none |
| SexId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FigType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Type | TEXT | Uncoded Value | uncategorized | none | none |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FnaBurn
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none |
| BurnCode | BIGINT | Uncoded Value | uncategorized | none | none |
| BurnId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FnaElement
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none |
| ElementId | BIGINT | Uncoded Value | uncategorized | none | none |
| UtilindexSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Utilindex | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _FnaFusion
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none |
| Code | TEXT | Uncoded Value | uncategorized | none | none |
| FusionId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FnaHumMod
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| DescriptionSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabe | TEXT | Uncoded Value | uncategorized | none | none |
| HumModCode | TEXT | Uncoded Value | uncategorized | none | none |
| HumModId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FnaNatMod
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none |
| Code | TEXT | Uncoded Value | uncategorized | none | none |
| NatModID | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FnaProxDist
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none |
| Code | TEXT | Uncoded Value | uncategorized | none | none |
| ProxDistId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _FnaTaxa
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| DescriptionSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none |
| Taxa | TEXT | Uncoded Value | uncategorized | none | none |
| TaxaId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _GndstnCond
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| ConditionSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Condition | TEXT | Uncoded Value | uncategorized | none | none |
| CondCode | TEXT | Uncoded Value | uncategorized | none | none |
| CondId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _GndstnMat
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| RawMaterialSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| RawMaterial | TEXT | Uncoded Value | uncategorized | none | none |
| RawMatCode | TEXT | Uncoded Value | uncategorized | none | none |
| MatId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _GndstnMTM
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| ManoTroughMetateSpanish | TEXT | Uncoded Value | uncategorized | none | none | |
| ManoTroughMetate | TEXT | Uncoded Value | uncategorized | none | none | |
| MTMCode | Mano Trough Metate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| MTMId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: _GndstnWear
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| WearSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Wear | TEXT | Uncoded Value | uncategorized | none | none |
| WearCode | TEXT | Uncoded Value | uncategorized | none | none |
| WearId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _GrndstnCat
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CategorySpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Category | TEXT | Uncoded Value | uncategorized | none | none |
| CatCode | TEXT | Uncoded Value | uncategorized | none | none |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _HmOsLvl1Grp
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Lvl1Group | TEXT | Uncoded Value | uncategorized | none | none |
| Lvl1GrpId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _HmOstEleNorm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Element | TEXT | Uncoded Value | uncategorized | none | none |
| ElementId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _HmOstLvl2Grp
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Lvl2Group | TEXT | Uncoded Value | uncategorized | none | none |
| Lvl2GrpId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _IE_Element_Fill_revised
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| FIll | TEXT | Uncoded Value | uncategorized | none | none |
| ElementFillId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _IE_Element_Fill
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| FIll | TEXT | Uncoded Value | uncategorized | none | none |
| ElementFillId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _IE_Elements
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| cer_element_group_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| HyperlinkedDrawing | TEXT | Uncoded Value | uncategorized | none | none | |
| adhocEleType_id | BIGINT | Uncoded Value | uncategorized | none | none | |
| ElementTypeId | FK to ElementType Lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ElementDescription | TEXT | Uncoded Value | uncategorized | none | none | |
| ElementName | TEXT | Uncoded Value | uncategorized | none | none | |
| IE_ElementId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: _IE_Elements_revised
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| HyperlinkedDrawing | TEXT | Uncoded Value | uncategorized | none | none | |
| ElementGroups | TEXT | Uncoded Value | uncategorized | none | none | |
| ElementTypeId | FK to ElementType Lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ElementDescription | TEXT | Uncoded Value | uncategorized | none | none | |
| ElementName | TEXT | Uncoded Value | uncategorized | none | none | |
| IE_ElementId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: _IE_ElementType_revised
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| ElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none |
| Element Type | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _IE_ElementType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Element Type | TEXT | Uncoded Value | uncategorized | none | none |
| ElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _LPGeneralSiteAreas
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| SiteArea | TEXT | Uncoded Value | uncategorized | none | none |
| ID | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _LPMound1SubAreas
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Mound1SubArea | TEXT | Uncoded Value | uncategorized | none | none |
| ID | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _LPPlaza1SubAreas
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| Plaza1SubArea | TEXT | Uncoded Value | uncategorized | none | none |
| ID | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _MbotFrctnId
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Fraction | TEXT | Uncoded Value | uncategorized | none | none |
| FractionId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _MbotPrtn
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Portion | TEXT | Uncoded Value | uncategorized | none | none |
| MbotPortId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _MbotTaxa
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Taxa | TEXT | Uncoded Value | uncategorized | none | none |
| TaxaId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _RimContourType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none |
| Contour type | TEXT | Uncoded Value | uncategorized | none | none |
| contour_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _RimLipForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none |
| Lip form | TEXT | Uncoded Value | uncategorized | none | none |
| lip_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _RimLipTreatment
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none |
| Lip treatment | TEXT | Uncoded Value | uncategorized | none | none |
| lip_treat_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _RimRimForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none |
| Rim form | TEXT | Uncoded Value | uncategorized | none | none |
| rim_form_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _RimVsslShp
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| bowl_jar2 | only definitives classified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| bowl_jar1 | all vessel shapes classified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Description | TEXT | Uncoded Value | uncategorized | none | none | |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | |
| Shape | TEXT | Uncoded Value | uncategorized | none | none | |
| shape_id | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: _RSContourType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| example | BLOB | Uncoded Value | uncategorized | none | none |
| ContourType | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _RSDecoration
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Decoration | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _RSLipForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| LipForm | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _RSLipTreatment
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| LipTreatment | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _RSRimForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| RimForm | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _RSSlipConsistency
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| SlipConsistency | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _RSVesselShape_DELETE
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| VesselShape | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _RSWare_DELETE
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Ware | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _ShellClass
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Class | TEXT | Uncoded Value | uncategorized | none | none |
| ClassId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _ShellGenera
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Genera | TEXT | Uncoded Value | uncategorized | none | none |
| GeneraId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _Sites
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| SttlmntAffltn | 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: _SpecArtClass
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| FunctionalClassSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| FunctionalClass | TEXT | Uncoded Value | uncategorized | none | none |
| ClassId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _SpecArtDec
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| DecTechSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| DecTech | TEXT | Uncoded Value | uncategorized | none | none |
| DecTechId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _SpecArtMat
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Material | TEXT | Uncoded Value | uncategorized | none | none |
| SpecArtMatId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _STMatGrpId
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| MaterailGroupSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| MaterialGroup | TEXT | Uncoded Value | uncategorized | none | none |
| MatGroupId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _STType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| ToolTypeSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| ToolType | TEXT | Uncoded Value | uncategorized | none | none |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _SubGroups
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| ChapterGroupId | BIGINT | Uncoded Value | uncategorized | none | none |
| SubGroupName | TEXT | Uncoded Value | uncategorized | none | none |
| SubGroupId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _TableGroups
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| SortOrder | DOUBLE | Uncoded Value | uncategorized | none | none |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none |
| TableGroupNamesSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| TableGroupName | TEXT | Uncoded Value | uncategorized | none | none |
| TableGroupId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _TypeCllctnFunctClass
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| FunctClassId | BIGINT | Uncoded Value | uncategorized | none | none |
| TypeCllctnId | BIGINT | Uncoded Value | uncategorized | none | none |
| FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _UnitYear
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| PageNumbers | TEXT | Uncoded Value | uncategorized | none | none |
| PDFURL | TEXT | Uncoded Value | uncategorized | none | none |
| NotebookId | BIGINT | Uncoded Value | uncategorized | none | none |
| YearExcavated | BIGINT | Uncoded Value | uncategorized | none | none |
| UnitId | BIGINT | Uncoded Value | uncategorized | none | none |
| UnitYearId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: _UnitYear_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| PDFURL | TEXT | Uncoded Value | uncategorized | none | none |
| NotebookId | BIGINT | Uncoded Value | uncategorized | none | none |
| YearExcavated | BIGINT | Uncoded Value | uncategorized | none | none |
| UnitId | BIGINT | Uncoded Value | uncategorized | none | none |
| UnitYearId | BIGINT | Uncoded Value | uncategorized | none | none |
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| PageNumbers | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: _WoodTaxa
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| TaxaSpanish | TEXT | Uncoded Value | uncategorized | none | none |
| Taxa | TEXT | Uncoded Value | uncategorized | none | none |
| WoodtaxaId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: Area_labels_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Area_label | TEXT | Uncoded Value | uncategorized | none | none |
| Area_name | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: ArtCatAnalyticalClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: ArtCatFunctionalClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Priority | TEXT | Uncoded Value | uncategorized | none | none |
| FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: ArtCatVesselAnalysis
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: ArtifactCat_Bags
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| SummaryDescription | The inventory summary for the Artifact Catalog | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| BoxId | BIGINT | Uncoded Value | uncategorized | none | none | |
| BagName | TEXT | Uncoded Value | uncategorized | none | none | |
| BagId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: ArtifactCat_BoxInventory
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| SortOrder | BIGINT | Uncoded Value | uncategorized | none | none |
| Cataloged | BOOLEAN | Uncoded Value | uncategorized | none | none |
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| BoxNo | TEXT | Uncoded Value | uncategorized | none | none |
| BoxId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: ArtifactCatalog
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| MaterialClassId | BIGINT | Uncoded Value | uncategorized | none | none | |
| AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ManufacturingClassId | BIGINT | Uncoded Value | uncategorized | none | none | |
| FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none | |
| VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none | |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | |
| INAHBoxNum | TEXT | Uncoded Value | uncategorized | none | none | |
| INAHCatNum | TEXT | Uncoded Value | uncategorized | none | none | |
| 2007comments | TEXT | Uncoded Value | uncategorized | none | none | |
| form | TEXT | Uncoded Value | uncategorized | none | none | |
| type | TEXT | Uncoded Value | uncategorized | none | none | |
| ware | TEXT | Uncoded Value | uncategorized | none | none | |
| BulkSheetDescription | 250 word limit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Slash # | TEXT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Site | TEXT | Uncoded Value | uncategorized | none | none | |
| MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ArtifactCatType | BIGINT | Uncoded Value | uncategorized | none | none | |
| YearExcavated | TEXT | Uncoded Value | uncategorized | none | none | |
| SummarySheet | Is this item in the general catalog summary for its respective box? | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| DetailSheet | Does this item require a Detail catalog sheet? | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| CatalogName | TEXT | Uncoded Value | uncategorized | none | none | |
| DetailSheetDescription | 250 word limit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Other Description | TEXT | Uncoded Value | uncategorized | none | none | |
| Description | TEXT | Uncoded Value | uncategorized | none | none | |
| count | BIGINT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| Other Prov | TEXT | Uncoded Value | uncategorized | none | none | |
| BagId | The bag number is unique and assigned to a unique box number in the ArtifactCat_Bags table - the bag and box number must already exist before this id can be assigned | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Item | BIGINT | Uncoded Value | uncategorized | none | none | |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: AUs
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| ChapterId | AUs grouped by the chapters of the informe final (each midden included - even though there is one chapter for all the middens) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ReportAreaId | AUs grouped by the areas discussed in the Informe Final - FK to _ReportArea table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Comments | General comments about the AU | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| CeremonialStatus | Is the context ceremonial or non-ceremonial - constructed from Jaime H's groundstone analysis | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| CultSpaceId | AUs grouped by somewhat useful cultural spaces such as room # and the like may need additional work for consistency - FK _CultSpace table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| GroupLvl2Id | Useful AU grouping by cultural spaces - needs additional work to be fully consistent and should be moved to separate table - FK to _GroupLvl2 table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| GroupLvl1Id | Useful AU grouping by cultural spaces - needs additional work to be fully consistent and should be moved to separate table - FK to _GroupLvl1 table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| MiddenPhasewithDetail | Used to help further break down phase information by the nature of the context (eg PO, Late, etc.) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| MiddenPhases | Midden phases and architectural phases are independent of one another. This field applies only to relative strata position within each midden | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| DepNotes | Notes about the depositional contexts | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Phase3Id | AUs grouped by phases with midden trash included with early contexts - only includes early terrace contexts and late Fill above floor and no PO | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Phase2Id | AUs grouped by inferred phases and deposit type (eg Early, Late, Post-occupational fill, Fill above floor etc). Needs work to be more consistent - FK to _AU Phase2 table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| TableGroupId | FK to TableGroup TableGroupId - Initially built to accomodate the organization of artifact counts in the final report tables | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| MidNonmid | FK to MidNonmid MidNonmidId - can be used to determine if the AU is from a Midden or Non-Midden context | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Midden | AUs related to trash or midden deposits | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Hearth | AUs related to hearths | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| FF | AUs that include pure fill immediately above floors | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| FloorDeposits | All AUs that include floor matrices, and firmes, and fill immediate above floors (ca 10 cm) - doesn't include AUs with other kinds of fill | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| BoneConc | AUs related to Bone Concentrations | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| SurfHum | AUs that contain surface and humus deposits | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Mixed | AUs for which the provenience is not known in more detail than the unit | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| TerraceFill | AUs related to terrace fill | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| SPFullDesc | Spanish translation of FullDesc | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| FullDesc | No abbreviations - Fully written out description of the AU | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ShortDesc | Contains some abbreviations | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| BriefDesc | Abbreviated brief description of the AU | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| new num | temp field used for renumbering aus on the fly | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| SortNumber | Nymber used to perform numeric sorts on the text field AUNum | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| AUNum | Official Analytical Unit Number as appears in final report | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| SiteId | FK to SITE_ID in _SITE table - the Site ID is also avalaible in the ULL table - Field is provided only as a convenience for manipulating this table directly | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| AUId | PK identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| PhaseId | AUs gouped by inferred phases (Early, Late, Terrace FIll, N/A) FK to _TableGroup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: BoxInv
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Comments | Comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Bag count | Bag Count | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Recorder | Recorder | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Vertical | Vertical | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Horizontal | Horizontal | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Locality | Locality | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Year | Year | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Size | Size | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Material | Material | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Bag number | Bag Number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Box number | Box Number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Site | What site does the material come from | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Collection | Which artifact collection does the box hold | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ID | unique box indentifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: CADLabels
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| SpanishLabels | Spanish label text | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| EnglishLabels | English label text | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| FileName | AutoCad file to which the label belongs | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ID | Unique label identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: CarbonSamples
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| DateId | Has value if the sample was dated - this is the FK link to the Dates table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Comments | Comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Soil | Nature of the soil matrix within which the sample was found | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| PriorityNotes | Comments in the field note regarding the importance and datability of the sample | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| PriorityId | Priority FK to lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Priority | Scale of 1 to 10 (1 being highest) of the excavator's opinion on whether the sample should be sent to C14 lab for dating | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Contamination | Potential sources of sample contamination | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ConcNotes | Comments in the field notes regarding the nature of the sample's concentration | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ConcentrationId | Concentration Fk to lookup | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Concentration | Category referring to the degree of dispersion or concentration of the sample | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Associations | Comments from the field notes regarding other artifact or feature associations with the sample | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| CompNotes | Comments from the field notees regarding the sample's composition | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| CompositionId | Composition identifier and FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Composition | Composition - not a necessary field - was used for checking accuracy of the CompositionID | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SizeNotes | Comments from the field notes regarding sample size | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| DateExcavated | Date sample was excavated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| PointLocation | Point provenience information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULLId | Unit-Level-Locus identifier and FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | Unit-Level-Locus - not a necessary field - was for checking accuracy of ULLID | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Level | Level | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unit | Unit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | Site ID FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| CarbonSampleId | Unique carbon sample identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| SampleSizeId | Sample Size identifier and FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| SampleSize | Sample Size - not a necessary field - used to check accuracy of the SampleSizeID field | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
Table Information: Ceramics
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| TypeOld | TEXT | Uncoded Value | uncategorized | none | none | |
| Comments | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Sorter | Name of ceramic sorter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Count | Artifact count | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| PortionId | Portion Designation - FK to _CerPortionId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| FormCnfdnc | C - Confident, U - Unconfident | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| FormId | Form Designation - FK to _CerForm table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| TypeCnfdnc | C - Confident, U - Unconfident | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TypeId | Type designation - FK to _CerType table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Locus | Locus Designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Level | Level designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unit | Unit designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULLId | ULL identification number creating link to ULL tabl - FK to ULL table (displays the ULL, but underlying value is the ULLId value) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| CerId | Ceramic idenitification Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | Redundant data left for purposes of crosschecking for reassigned ULLs - do not delet yet | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | Site at which specimens derived - FK to _Site table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Year | Year specimens were excavated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Collection | LQ-MVAP - from our excavations, Armillas - from the Armillas collection | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
Table Information: Ceramics_old_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| TypeOld | TEXT | Uncoded Value | uncategorized | none | none | |
| Comments | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Sorter | Name of ceramic sorter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Count | Artifact count | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| PortionId | Portion Designation - FK to _CerPortionId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| FormCnfdnc | C - Confident, U - Unconfident | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| FormId | Form Designation - FK to _CerForm table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| TypeCnfdnc | C - Confident, U - Unconfident | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TypeId | Type designation - FK to _CerType table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Locus | Locus Designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Level | Level designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unit | Unit designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULLId | ULL identification number creating link to ULL tabl - FK to ULL table (displays the ULL, but underlying value is the ULLId value) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | Redundant data left for purposes of crosschecking for reassigned ULLs - do not delet yet | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | Site at which specimens derived - FK to _Site table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Collection | LQ-MVAP - from our excavations, Armillas - from the Armillas collection | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Year | Year specimens were excavated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| CerId | Ceramic idenitification Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: Dates
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| Reference | TEXT | Uncoded Value | uncategorized | none | none |
| OxCal2sig | TEXT | Uncoded Value | uncategorized | none | none |
| OxCal1sig | TEXT | Uncoded Value | uncategorized | none | none |
| Cal2sig | TEXT | Uncoded Value | uncategorized | none | none |
| ConC14 | TEXT | Uncoded Value | uncategorized | none | none |
| 13C/12C | TEXT | Uncoded Value | uncategorized | none | none |
| StanDevMeas | BIGINT | Uncoded Value | uncategorized | none | none |
| MeasC14 | BIGINT | Uncoded Value | uncategorized | none | none |
| StratPos | TEXT | Uncoded Value | uncategorized | none | none |
| Material | TEXT | Uncoded Value | uncategorized | none | none |
| ExcArea | TEXT | Uncoded Value | uncategorized | none | none |
| Slash | TEXT | Uncoded Value | uncategorized | none | none |
| Locus | TEXT | Uncoded Value | uncategorized | none | none |
| Level | TEXT | Uncoded Value | uncategorized | none | none |
| Unit | TEXT | Uncoded Value | uncategorized | none | none |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none |
| ULL | TEXT | Uncoded Value | uncategorized | none | none |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none |
| Submitted | TEXT | Uncoded Value | uncategorized | none | none |
| DateType | TEXT | Uncoded Value | uncategorized | none | none |
| RadiocarbonFormId | BIGINT | Uncoded Value | uncategorized | none | none |
| DateId | BIGINT | Uncoded Value | uncategorized | none | none |
| LabId | TEXT | Uncoded Value | uncategorized | none | none |
| Lab | TEXT | Uncoded Value | uncategorized | none | none |
| Cal1sig | TEXT | Uncoded Value | uncategorized | none | none |
| IntCal | TEXT | Uncoded Value | uncategorized | none | none |
| StanDevCon | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: DatesListLQ(old)_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| calibrated results (2 sigma, 95% prob) | TEXT | Uncoded Value | uncategorized | none | none |
| +/-* | BIGINT | Uncoded Value | uncategorized | none | none |
| conventional C14 age | BIGINT | Uncoded Value | uncategorized | none | none |
| C13/C12 ratio | TEXT | Uncoded Value | uncategorized | none | none |
| +/- | BIGINT | Uncoded Value | uncategorized | none | none |
| measured C14 age | BIGINT | Uncoded Value | uncategorized | none | none |
| slash | TEXT | Uncoded Value | uncategorized | none | none |
| locus | TEXT | Uncoded Value | uncategorized | none | none |
| level | BIGINT | Uncoded Value | uncategorized | none | none |
| unit | BIGINT | Uncoded Value | uncategorized | none | none |
| site | TEXT | Uncoded Value | uncategorized | none | none |
| beta sample # | TEXT | Uncoded Value | uncategorized | none | none |
| id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: Debitage
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Comment | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Count | Specimen count by row | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Tool | ??? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| MatId | Raw material of specimen - FK to _DebMaterial table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| CortexId | Presence or absence of cortex - FK to _DebCortex table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| StageId | Reduction stage - FK to _DebStage table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| StageIndexId | Reduction stage index - FK to _DebStageIndex Table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| TypeBId | Flake TypeB - FK to _DebTypeB table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| TypeId | Flake Type - FK to _DebType table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Slash | Slash number or letter of the specimen | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULLId | Unit Level Locus Id - FK to ULL table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | Unit-Level-Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | Site from which the samples derive - FK _Sites table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| DebId | Debitage identification number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: elements
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Type | TEXT | Uncoded Value | uncategorized | none | none |
| Count | BIGINT | Uncoded Value | uncategorized | none | none |
| Element_group | TEXT | Uncoded Value | uncategorized | none | none |
| ReportArea | TEXT | Uncoded Value | uncategorized | none | none |
| Phase_Name | TEXT | Uncoded Value | uncategorized | none | none |
| ReportAreaId | BIGINT | Uncoded Value | uncategorized | none | none |
| SiteCode | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: elements3_delete
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| type | TEXT | Uncoded Value | uncategorized | none | none |
| count | BIGINT | Uncoded Value | uncategorized | none | none |
| Element_group | TEXT | Uncoded Value | uncategorized | none | none |
| ReportArea | TEXT | Uncoded Value | uncategorized | none | none |
| Phase_Name | TEXT | Uncoded Value | uncategorized | none | none |
| ReportAreaId | BIGINT | Uncoded Value | uncategorized | none | none |
| SiteCode | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: EP_ULL_VOL_EST_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | |
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: ExcvtdUnits_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| Location | TEXT | Uncoded Value | uncategorized | none | none |
| UnitNum | TEXT | Uncoded Value | uncategorized | none | none |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none |
| UnitId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: Fauna
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| TypeSpecimen | Is the specimen useful for comparison or as a type? - see Rebekah Parks for details | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Count | Count of items in row | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| NatModId | FK to the NatModId column of the _FnaNatMod table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| HumModDesc | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| HumModId | FK to the HumModId column of the _FnaHumMod table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| BurnDesc | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| BurnId | FK to the BurnId column of the _FnaBurn table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| FusionId | FK to the FusionId column of the _FnaFusion table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Fusion | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ProxDistId | FK to the ProxDistId column of the _FnaProxDist table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ProxDist | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ElementId | FK to ElementId column of the _FnaElement table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| TaxaDesc | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TaxaId | FK to the TaxaId column of the _FnaTaxa table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Taxa | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Locus | Locus designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Level | Level designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unit | Unit designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SecondaryAU | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Comments | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Sorter | Person who sorted, coded and counted the information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| AU | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULLId | FK to ULLId of the ULL table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | Unit Level Locus - to be deleted eventually | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | FK to SitesId column of the _Sites table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Bag | Specimens were pulled from a Bag with this identifier | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ID | Identification number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: Fauna_Old_Bak_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| Count | TEXT | Uncoded Value | uncategorized | none | none |
| Nat_mod | TEXT | Uncoded Value | uncategorized | none | none |
| hum_mod desc | TEXT | Uncoded Value | uncategorized | none | none |
| Hum_mod | TEXT | Uncoded Value | uncategorized | none | none |
| burn desc | TEXT | Uncoded Value | uncategorized | none | none |
| Burn | BIGINT | Uncoded Value | uncategorized | none | none |
| Fusion | TEXT | Uncoded Value | uncategorized | none | none |
| Prox-dist | TEXT | Uncoded Value | uncategorized | none | none |
| Element | TEXT | Uncoded Value | uncategorized | none | none |
| taxa desc | TEXT | Uncoded Value | uncategorized | none | none |
| Taxa | TEXT | Uncoded Value | uncategorized | none | none |
| Slash | TEXT | Uncoded Value | uncategorized | none | none |
| Locus | TEXT | Uncoded Value | uncategorized | none | none |
| Level | TEXT | Uncoded Value | uncategorized | none | none |
| Unit | TEXT | Uncoded Value | uncategorized | none | none |
| Secondary AU | TEXT | Uncoded Value | uncategorized | none | none |
| ULL | TEXT | Uncoded Value | uncategorized | none | none |
| Site | TEXT | Uncoded Value | uncategorized | none | none |
| Bag | TEXT | Uncoded Value | uncategorized | none | none |
| ID | BIGINT | Uncoded Value | uncategorized | none | none |
| AU | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: Figurines before removal of 4 items_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| KimsComments | TEXT | Uncoded Value | uncategorized | none | none | |
| Count | TEXT | Uncoded Value | uncategorized | none | none | |
| Other_com | TEXT | Uncoded Value | uncategorized | none | none | |
| Com10 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com9 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com 8 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com7 | TEXT | Uncoded Value | uncategorized | none | none | |
| PaintId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Paint | TEXT | Uncoded Value | uncategorized | none | none | |
| SexId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Sex | TEXT | Uncoded Value | uncategorized | none | none | |
| FullDesc | TEXT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Part | TEXT | Uncoded Value | uncategorized | none | none | |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| Old_Type_Id | Kim Goldstein's original type - no longer used | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| LQ_Type | New Types based on Jaime H's classification of 2006 | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Williams_Type | TEXT | Uncoded Value | uncategorized | none | none | |
| F_numb | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Prim_id | TEXT | Uncoded Value | uncategorized | none | none | |
| Com2 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com1 | TEXT | Uncoded Value | uncategorized | none | none | |
| FinishId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Finish | TEXT | Uncoded Value | uncategorized | none | none | |
| Com6 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com5 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com4 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com3 | TEXT | Uncoded Value | uncategorized | none | none | |
| Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | |
| Site | TEXT | Uncoded Value | uncategorized | none | none | |
| Figurine_Id | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: Figurines_legacy_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Count | BIGINT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| Other_com | TEXT | Uncoded Value | uncategorized | none | none | |
| Com10 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com9 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com 8 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com7 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com6 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com5 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com3 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com2 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com1 | TEXT | Uncoded Value | uncategorized | none | none | |
| FinishId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Finish | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| PaintId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Paint | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SexId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Sex | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Type | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Part | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | |
| Level | TEXT | Uncoded Value | uncategorized | none | none | |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Item_numb | TEXT | Uncoded Value | uncategorized | none | none | |
| F_numb | BIGINT | Uncoded Value | uncategorized | none | none | |
| ID_name | TEXT | Uncoded Value | uncategorized | none | none | |
| Com4 | TEXT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| FigurineId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: Figurines_new
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| KimsComments | TEXT | Uncoded Value | uncategorized | none | none | |
| Count | TEXT | Uncoded Value | uncategorized | none | none | |
| Other_com | TEXT | Uncoded Value | uncategorized | none | none | |
| Com10 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com9 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com 8 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com7 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com6 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com5 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com4 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com3 | TEXT | Uncoded Value | uncategorized | none | none | |
| Com2 | TEXT | Uncoded Value | uncategorized | none | none | |
| FullDesc | TEXT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Part | TEXT | Uncoded Value | uncategorized | none | none | |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| Old_Type_Id | Kim Goldstein's original type - no longer used | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| LQ_Type | New Types based on Jaime H's classification of 2006 | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Williams_Type | TEXT | Uncoded Value | uncategorized | none | none | |
| F_numb | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Prim_id | TEXT | Uncoded Value | uncategorized | none | none | |
| Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | |
| Site | TEXT | Uncoded Value | uncategorized | none | none | |
| Figurine_Id | BIGINT | Uncoded Value | uncategorized | none | none | |
| Com1 | TEXT | Uncoded Value | uncategorized | none | none | |
| FinishId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Finish | TEXT | Uncoded Value | uncategorized | none | none | |
| PaintId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Paint | TEXT | Uncoded Value | uncategorized | none | none | |
| SexId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Sex | TEXT | Uncoded Value | uncategorized | none | none | |
Table Information: Grndstn
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Count | DOUBLE | Uncoded Value | uncategorized | none | none | |
| TypeCnfdnc | TEXT | Uncoded Value | uncategorized | none | none | |
| AnalyticGroup | special category created for Jaime to help her sort out the specimens she wished to include in her analysis | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| MatCnfdnc | TEXT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| TypeCllctn | TEXT | Uncoded Value | uncategorized | none | none | |
| MTMId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ManoSurfaces | DOUBLE | Uncoded Value | uncategorized | none | none | |
| MatId | BIGINT | Uncoded Value | uncategorized | none | none | |
| WearId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Weight | TEXT | Uncoded Value | uncategorized | none | none | |
| Thickest | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Thinnest | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Width | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Length | DOUBLE | Uncoded Value | uncategorized | none | none | |
| PrcntPrsnt | DOUBLE | Uncoded Value | uncategorized | none | none | |
| ConId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | |
| Level | TEXT | Uncoded Value | uncategorized | none | none | |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Year | BIGINT | Uncoded Value | uncategorized | none | none | |
| TypeCatId | BIGINT | Uncoded Value | uncategorized | none | none | |
| CatId | FK to the Artifact Catalog Table where possible | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| GrndstnId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: Grndstn_Old_Bak_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| comments | TEXT | Uncoded Value | uncategorized | none | none |
| manopolish_shapedbytroughmetate? | TEXT | Uncoded Value | uncategorized | none | none |
| manopolish_#wearsurfaces | BIGINT | Uncoded Value | uncategorized | none | none |
| thickest | DOUBLE | Uncoded Value | uncategorized | none | none |
| thinnest | DOUBLE | Uncoded Value | uncategorized | none | none |
| count | BIGINT | Uncoded Value | uncategorized | none | none |
| raw_material | TEXT | Uncoded Value | uncategorized | none | none |
| material | TEXT | Uncoded Value | uncategorized | none | none |
| degree_of_wear | TEXT | Uncoded Value | uncategorized | none | none |
| wear | TEXT | Uncoded Value | uncategorized | none | none |
| width | DOUBLE | Uncoded Value | uncategorized | none | none |
| length | DOUBLE | Uncoded Value | uncategorized | none | none |
| condition | TEXT | Uncoded Value | uncategorized | none | none |
| tool_category | TEXT | Uncoded Value | uncategorized | none | none |
| type | TEXT | Uncoded Value | uncategorized | none | none |
| analytica_unit | TEXT | Uncoded Value | uncategorized | none | none |
| locale | TEXT | Uncoded Value | uncategorized | none | none |
| slash | TEXT | Uncoded Value | uncategorized | none | none |
| locus | TEXT | Uncoded Value | uncategorized | none | none |
| level | TEXT | Uncoded Value | uncategorized | none | none |
| unit | TEXT | Uncoded Value | uncategorized | none | none |
| ULL | TEXT | Uncoded Value | uncategorized | none | none |
| site | TEXT | Uncoded Value | uncategorized | none | none |
| year | BIGINT | Uncoded Value | uncategorized | none | none |
| id | BIGINT | Uncoded Value | uncategorized | none | none |
| percent_present | BIGINT | Uncoded Value | uncategorized | none | none |
| AU | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: IE_SherdElemJunct
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| IE_ElementFillId | FK to Element Fill table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| IE_ElementId | FK to IE_Element table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| IESherdId | FK to IESherdId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: IE_Sherds
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| YearExcavated | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| BagNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| BoxNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | |
| Slash | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULL_id | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Site | Site Name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | FK to _Sites | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| RNumber | FK to RimStudy R number field | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| RimStudyId | FK to RimStudy RimStudyId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| IESherdsIdD | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: iesherds_copy
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| ULL_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | |
| YearExcavated | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| BagNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| BoxNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | |
| Slash | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULL_id | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | FK to _Sites | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| VNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| RNumber | FK to RimStudy R number field | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| RimStudyId | FK to RimStudy RimStudyId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| IESherdsIdD | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: IllstArtfcts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| SelectedForCat | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| SelectForReport | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Illustration | BLOB | Uncoded Value | uncategorized | none | none | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | FK to SiteId column of _Sites tables | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Status | TEXT | Uncoded Value | uncategorized | none | none | |
| Link | This is a hyperlink to the illustration living on the server | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TypeCllctnId | FK to TypeCllctnId column in the TypeCllctn table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | |
| CodeId | This code is the lookup to the physical drawings stored in portfolios and notebooks | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| IllustId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: IllstOthers
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| Report/Figure | TEXT | Uncoded Value | uncategorized | none | none |
| Area | TEXT | Uncoded Value | uncategorized | none | none |
| Unit | TEXT | Uncoded Value | uncategorized | none | none |
| TypeId | TEXT | Uncoded Value | uncategorized | none | none |
| Type | TEXT | Uncoded Value | uncategorized | none | none |
| SiteId | TEXT | Uncoded Value | uncategorized | none | none |
| Site | TEXT | Uncoded Value | uncategorized | none | none |
| IllustNum | TEXT | Uncoded Value | uncategorized | none | none |
| IlustId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: INAH_CAT_EXT_REF_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| BOXNO | TEXT | Uncoded Value | uncategorized | none | none |
| CATNO | TEXT | Uncoded Value | uncategorized | none | none |
| INAH_ID | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: Legacy_BotTaxaMich_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Comment | TEXT | Uncoded Value | uncategorized | none | none | |
| Charred | No values | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Weight | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | |
| Portion | No values | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Taxon | TEXT | Uncoded Value | uncategorized | none | none | |
| TaxonId | TEXT | Uncoded Value | uncategorized | none | none | |
| FractionId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | |
| Level | TEXT | Uncoded Value | uncategorized | none | none | |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Area | TEXT | Uncoded Value | uncategorized | none | none | |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none | |
| Site | TEXT | Uncoded Value | uncategorized | none | none | |
| ID | Old unique identifier -kept in for legacy purposes but too hard to maintain (not an auto-number) - taxa_id replaced this ID | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Phase | TEXT | Uncoded Value | uncategorized | none | none | |
| taxa_id | Taxa unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Fraction | TEXT | Uncoded Value | uncategorized | none | none | |
Table Information: LP_ULL_VOL_EST_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | |
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | |
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | |
Table Information: LPHumBone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Count | BIGINT | Uncoded Value | uncategorized | none | none | |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | |
| PolPho | TEXT | Uncoded Value | uncategorized | none | none | |
| ConjSets | TEXT | Uncoded Value | uncategorized | none | none | |
| Size | TEXT | Uncoded Value | uncategorized | none | none | |
| Taphonomy | TEXT | Uncoded Value | uncategorized | none | none | |
| Perimortem | TEXT | Uncoded Value | uncategorized | none | none | |
| Intextsurf | TEXT | Uncoded Value | uncategorized | none | none | |
| Compl | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Sex | TEXT | Uncoded Value | uncategorized | none | none | |
| Age | TEXT | Uncoded Value | uncategorized | none | none | |
| Segment | TEXT | Uncoded Value | uncategorized | none | none | |
| Side | TEXT | Uncoded Value | uncategorized | none | none | |
| Lvl2GrpId | FK to _HmOstLvl2Grp | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Lvl2Group | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Lvl1GrpId | FK to _HmOstLvl1Grp | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Lvl1Group | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ElementId | FK to _HmOstEleNorm | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ElementST | TEXT | Uncoded Value | uncategorized | none | none | |
| Element | TEXT | Uncoded Value | uncategorized | none | none | |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Prov | TEXT | Uncoded Value | uncategorized | none | none | |
| Unit | DOUBLE | Uncoded Value | uncategorized | none | none | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| AnalyticUnit | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Box | TEXT | Uncoded Value | uncategorized | none | none | |
| SPNum | TEXT | Uncoded Value | uncategorized | none | none | |
| SpecimenId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: LPHumTeeth
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Pathology | TEXT | Uncoded Value | uncategorized | none | none |
| AgeYr | TEXT | Uncoded Value | uncategorized | none | none |
| Aged/Up | TEXT | Uncoded Value | uncategorized | none | none |
| Side | TEXT | Uncoded Value | uncategorized | none | none |
| Tooth | TEXT | Uncoded Value | uncategorized | none | none |
| UpLo | TEXT | Uncoded Value | uncategorized | none | none |
| Art | TEXT | Uncoded Value | uncategorized | none | none |
| NumFfound | DOUBLE | Uncoded Value | uncategorized | none | none |
| Slash | TEXT | Uncoded Value | uncategorized | none | none |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none |
| Prov | TEXT | Uncoded Value | uncategorized | none | none |
| UNIT | DOUBLE | Uncoded Value | uncategorized | none | none |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none |
| ULL | TEXT | Uncoded Value | uncategorized | none | none |
| Box | TEXT | Uncoded Value | uncategorized | none | none |
| AnalyticUnit | TEXT | Uncoded Value | uncategorized | none | none |
| SpNum | DOUBLE | Uncoded Value | uncategorized | none | none |
| Site | TEXT | Uncoded Value | uncategorized | none | none |
| LPHumTeethId | BIGINT | Uncoded Value | uncategorized | none | none |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: LQ_Commingled_Human_Bone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| end | DOUBLE | Uncoded Value | uncategorized | none | none |
| comments | TEXT | Uncoded Value | uncategorized | none | none |
| slash | TEXT | Uncoded Value | uncategorized | none | none |
| other info | TEXT | Uncoded Value | uncategorized | none | none |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none |
| Ull_rect_comments | TEXT | Uncoded Value | uncategorized | none | none |
| ULL | TEXT | Uncoded Value | uncategorized | none | none |
| locus | TEXT | Uncoded Value | uncategorized | none | none |
| level | BIGINT | Uncoded Value | uncategorized | none | none |
| unit | DOUBLE | Uncoded Value | uncategorized | none | none |
| Site_ID | BIGINT | Uncoded Value | uncategorized | none | none |
| box | TEXT | Uncoded Value | uncategorized | none | none |
| age | TEXT | Uncoded Value | uncategorized | none | none |
| n | DOUBLE | Uncoded Value | uncategorized | none | none |
| % | DOUBLE | Uncoded Value | uncategorized | none | none |
| segment | TEXT | Uncoded Value | uncategorized | none | none |
| side | TEXT | Uncoded Value | uncategorized | none | none |
| bone | TEXT | Uncoded Value | uncategorized | none | none |
| id | DOUBLE | Uncoded Value | uncategorized | none | none |
| b | DOUBLE | Uncoded Value | uncategorized | none | none |
Table Information: LQ_Cut_Marks_Human_Bone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| CM Total | TEXT | Uncoded Value | uncategorized | none | none |
| Side | TEXT | Uncoded Value | uncategorized | none | none |
| Field # | TEXT | Uncoded Value | uncategorized | none | none |
| Bone | TEXT | Uncoded Value | uncategorized | none | none |
| Provience | TEXT | Uncoded Value | uncategorized | none | none |
| Slash | TEXT | Uncoded Value | uncategorized | none | none |
| other info | TEXT | Uncoded Value | uncategorized | none | none |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none |
| ULL | TEXT | Uncoded Value | uncategorized | none | none |
| Unit | TEXT | Uncoded Value | uncategorized | none | none |
| Site_Id | BIGINT | Uncoded Value | uncategorized | none | none |
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| Dir | TEXT | Uncoded Value | uncategorized | none | none |
| Shape | TEXT | Uncoded Value | uncategorized | none | none |
| Depth | TEXT | Uncoded Value | uncategorized | none | none |
| Width | TEXT | Uncoded Value | uncategorized | none | none |
| Length | TEXT | Uncoded Value | uncategorized | none | none |
| Pos | TEXT | Uncoded Value | uncategorized | none | none |
| Loc | TEXT | Uncoded Value | uncategorized | none | none |
| CM # | TEXT | Uncoded Value | uncategorized | none | none |
| Cast | TEXT | Uncoded Value | uncategorized | none | none |
| Cast # | TEXT | Uncoded Value | uncategorized | none | none |
| Sort # | TEXT | Uncoded Value | uncategorized | none | none |
Table Information: LQ_Processed_Human_Bone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| comments | TEXT | Uncoded Value | uncategorized | none | none |
| measurement | TEXT | Uncoded Value | uncategorized | none | none |
| box | TEXT | Uncoded Value | uncategorized | none | none |
| b | TEXT | Uncoded Value | uncategorized | none | none |
| cd | TEXT | Uncoded Value | uncategorized | none | none |
| gn | TEXT | Uncoded Value | uncategorized | none | none |
| ps | TEXT | Uncoded Value | uncategorized | none | none |
| sc2 | TEXT | Uncoded Value | uncategorized | none | none |
| pp | TEXT | Uncoded Value | uncategorized | none | none |
| ch | TEXT | Uncoded Value | uncategorized | none | none |
| ct | TEXT | Uncoded Value | uncategorized | none | none |
| pe | TEXT | Uncoded Value | uncategorized | none | none |
| fl | TEXT | Uncoded Value | uncategorized | none | none |
| pt | TEXT | Uncoded Value | uncategorized | none | none |
| cr | TEXT | Uncoded Value | uncategorized | none | none |
| sc1 | DOUBLE | Uncoded Value | uncategorized | none | none |
| ivr | TEXT | Uncoded Value | uncategorized | none | none |
| peri fract | TEXT | Uncoded Value | uncategorized | none | none |
| % | DOUBLE | Uncoded Value | uncategorized | none | none |
| age | TEXT | Uncoded Value | uncategorized | none | none |
| bone | TEXT | Uncoded Value | uncategorized | none | none |
| frag | TEXT | Uncoded Value | uncategorized | none | none |
| side | TEXT | Uncoded Value | uncategorized | none | none |
| slash | TEXT | Uncoded Value | uncategorized | none | none |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none |
| otherinfo | TEXT | Uncoded Value | uncategorized | none | none |
| Ull_rect_comments | TEXT | Uncoded Value | uncategorized | none | none |
| ULL | TEXT | Uncoded Value | uncategorized | none | none |
| locus | TEXT | Uncoded Value | uncategorized | none | none |
| level | TEXT | Uncoded Value | uncategorized | none | none |
| unit | DOUBLE | Uncoded Value | uncategorized | none | none |
| Site_ID | BIGINT | Uncoded Value | uncategorized | none | none |
| id | DOUBLE | Uncoded Value | uncategorized | none | none |
Table Information: LQ_ULL_VOL_EST
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | |
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: LQVolEstsOld
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | |
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | |
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
Table Information: Macrobot
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Comment | TEXT | Uncoded Value | uncategorized | none | none | |
| Charred | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Weight | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Portion | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| MbotTaxaId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Taxa | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ID | to be deleted? | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| FractionId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Fraction | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| Area | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | |
| SampleId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: Mbot_Type_Analysis
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| botanical_type_id_fk | BIGINT | Uncoded Value | uncategorized | none | none |
| speci_id_fk | BIGINT | Uncoded Value | uncategorized | none | none |
| Mbot_type_anal_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: MD_Fields
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| MetaData_Desc | TEXT | Uncoded Value | uncategorized | none | none |
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| Doc_Object | BLOB | Uncoded Value | uncategorized | none | none |
| Table_id_fk | BIGINT | Uncoded Value | uncategorized | none | none |
| Field_name | TEXT | Uncoded Value | uncategorized | none | none |
| Field_Id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: MD_Tables
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Doc_object | BLOB | Uncoded Value | uncategorized | none | none |
| MetaData | TEXT | Uncoded Value | uncategorized | none | none |
| Description | TEXT | Uncoded Value | uncategorized | none | none |
| Table_Name | TEXT | Uncoded Value | uncategorized | none | none |
| Table_id | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: NewFlots
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Land Snails (100=more not pulled) | TEXT | Uncoded Value | uncategorized | none | none | |
| Unid Fragments | Unidentified Fragments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Misc tissue (grams) | TEXT | Uncoded Value | uncategorized | none | none | |
| Misc Stems | TEXT | Uncoded Value | uncategorized | none | none | |
| Reeds | TEXT | Uncoded Value | uncategorized | none | none | |
| Unid Spines | Unidentified spines | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid Fruit 5 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid Fruit 4 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid Fruit 3 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid Fruit 2 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid Fruit 1 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 26 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 25 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 24 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 23 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 22 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 21 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 20 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 18 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 17 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 16 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 14 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid13 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 12 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 11 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 10 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 9 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 8 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 2 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 1 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Labiateae | TEXT | Uncoded Value | uncategorized | none | none | |
| Lychnis | TEXT | Uncoded Value | uncategorized | none | none | |
| Polygonum | TEXT | Uncoded Value | uncategorized | none | none | |
| Gramineae | TEXT | Uncoded Value | uncategorized | none | none | |
| Leguminoseae sp 2 | TEXT | Uncoded Value | uncategorized | none | none | |
| Setaria | TEXT | Uncoded Value | uncategorized | none | none | |
| Stellaria | TEXT | Uncoded Value | uncategorized | none | none | |
| Prosopis | TEXT | Uncoded Value | uncategorized | none | none | |
| Pinus nut frag | TEXT | Uncoded Value | uncategorized | none | none | |
| Helianthus | TEXT | Uncoded Value | uncategorized | none | none | |
| Compositae sp 2 | TEXT | Uncoded Value | uncategorized | none | none | |
| Compositae | TEXT | Uncoded Value | uncategorized | none | none | |
| Portulaca | TEXT | Uncoded Value | uncategorized | none | none | |
| Brassica | TEXT | Uncoded Value | uncategorized | none | none | |
| Euphorbiaceae | TEXT | Uncoded Value | uncategorized | none | none | |
| Solanaceae | TEXT | Uncoded Value | uncategorized | none | none | |
| Physalis | TEXT | Uncoded Value | uncategorized | none | none | |
| Cactaceae | TEXT | Uncoded Value | uncategorized | none | none | |
| Mammalaria | TEXT | Uncoded Value | uncategorized | none | none | |
| Amaranthus | TEXT | Uncoded Value | uncategorized | none | none | |
| Chenopodium-tiny | TEXT | Uncoded Value | uncategorized | none | none | |
| Chenopodium album | TEXT | Uncoded Value | uncategorized | none | none | |
| Chenopodium sp 3 | TEXT | Uncoded Value | uncategorized | none | none | |
| Chenopodium sp 2 | TEXT | Uncoded Value | uncategorized | none | none | |
| Chenopodium | TEXT | Uncoded Value | uncategorized | none | none | |
| Wild Legume | TEXT | Uncoded Value | uncategorized | none | none | |
| Agave Tissue (in grams) | TEXT | Uncoded Value | uncategorized | none | none | |
| Opuntia sp 2 | TEXT | Uncoded Value | uncategorized | none | none | |
| Opuntia | TEXT | Uncoded Value | uncategorized | none | none | |
| Curcurbita | TEXT | Uncoded Value | uncategorized | none | none | |
| Phaseolus | TEXT | Uncoded Value | uncategorized | none | none | |
| Kernel Weight (in grams) | TEXT | Uncoded Value | uncategorized | none | none | |
| Maize kernel-count | TEXT | Uncoded Value | uncategorized | none | none | |
| Cupule Weight (in grams) | TEXT | Uncoded Value | uncategorized | none | none | |
| Maize cupule-count | TEXT | Uncoded Value | uncategorized | none | none | |
| Wood Charcoal (in grams) | TEXT | Uncoded Value | uncategorized | none | none | |
| AU Description(old) | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| AU(old) | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Phase | delete - these phases inlcude those from middens based on their specific stratigraphy and are not necessarliy the same phases as those in architectural areas | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Level | Level | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unit | Unit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULLId | Unit-Leve-LLocus ID | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| ULL | Unit-Level-Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Area | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SiteId | Site ID and FK to sites table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Site | Site name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ID | NewFlots unique identifier - data set created by Paula Turkon summer of 2006 | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Unid 4 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 3 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 7 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Unid 6 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
Table Information: Obsidian 97
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| location | Where curated? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| photo | Photogrpahed? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| drawn | Drawn? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| means_of_procurement | Least detail, only similarly acquisition - Unk E and Noch for example | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| source_area | Less detail, only similar source areas are recoded | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| chemical_source | Greatest detail, only recorded if only one source associates with the group | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| naa_source | Sub source based on color association | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| analysis | Type of Analysis | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| mvp_id | MURR sample number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| color_group | Color group | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| special | Special qualities | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| opalescent | + is yes, = is maybe, - is no | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| tertiary_clr | Tertiary Color: Black; Grey; Brown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| secondary_clr | Secondary Color: Grey; Black; Dark Grey; Black-Dark Grey; Light Grey; Light Green; White; Red; Brown-Green; Dark Red; Red-Orange; Brown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| primary_clr | Primary Color: Black; Black-Dark Grey; Dark Grey; Grey; Light Grey; White; Green; Light Green; Dark Green; Grey-Green; Red; Red-Brown; Brown; Brown-Green; Red-Orange; Dark Red-Brown; Ochre; UNknown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| inclusions | STRiations, SHMutz, BUBbles, SPLotches, RIBbons, CLOuds, FLEcks, MOTtling, SPEckles | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| clarity | Clarity 1=Clear; 2= Clear with cloudiness; 3= cloudy but translucent; 4= Part opaque, part cloudy/translucent; 5= Fully opaque, possible translucent at thin edges; 6= Special; 7= Unknown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| surface | Surface Quality: Rough or Calcified, no entry = smooth and clean | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| luster | Luster: GReasy; GLassy; Lustrous (not types as GR or GL); UNknown | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| color | Flake Color, Loni's categories/classification: Lustrous Black; Dull Black; Translucent Black; Translucent Green; Dull Green; Dull Grey; Lustrous Dark Grey; Lustrous Red | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| cortex_surface | Cortex surface - 1=smooth and flat, 2 = smooth and ridged, 3 = rough and flat, 4 = rough and ridged, 5 = very rough | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| cortex | + or - (TF's with cortex on platform and cores) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| edge | U=used, PL= likely usable/used, PD=doubtful usable/used, N=not usable | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| flake | Flake type: Primary Flake, Secondary Flake, Tertiary Flake, Primary RETouch flake, Secondary RETouch flake, Tertiary RETouch flake, CORE, COBBLE, Fragmentary Flake, FRAGment | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| count | Number of flakes | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| mg | Weight in mg +-10mg | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| / | Slash - Number=Point Proveniece, Letter=Special Find | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ULL_ID_FK | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| level | Level | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| unit | Excavation Unit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| midden_phase | Midden phase (early, middle, late, mixed) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Area_name | Portion of Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Site_ID_FK | BIGINT | Uncoded Value | uncategorized | none | none | |
| site | La Quemada or Los Pilarillos | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| analytical_unit | Analytical unit | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| bag_id | Bag number (Zacatecas only) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| obs_id | Primary key | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: OtherArtifacts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| count | count | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Details | Details | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Functional subclass | Functional subclass | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Class | Class | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Material subclass | Material subclass | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Material | Material | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TypeCllcntID | Type Collection ID and FK to the Type Collection table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| OtherId | Unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: Photo_Artifacts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Image | BLOB | Uncoded Value | uncategorized | none | none | |
| SelectedForReport | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| SelectedForArtCat | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| ULLInfo | TEXT | Uncoded Value | uncategorized | none | none | |
| RimNumber | TEXT | Uncoded Value | uncategorized | none | none | |
| PrimId | TEXT | Uncoded Value | uncategorized | none | none | |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Exposure | TEXT | Uncoded Value | uncategorized | none | none | |
| PhotoId | Link back to traditional prints in Photolog table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| PhotoArtifactsId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: Photo_ULLS
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| AUId | BIGINT | Uncoded Value | uncategorized | none | none |
| SIte_id | BIGINT | Uncoded Value | uncategorized | none | none |
| ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none |
| ULL | TEXT | Uncoded Value | uncategorized | none | none |
| PohotoId | BIGINT | Uncoded Value | uncategorized | none | none |
| IdPhotoNum_ULL | BIGINT | Uncoded Value | uncategorized | none | none |
Table Information: Photologs
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| Item12 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item11 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item10 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item9 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item8 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item7 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item6 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item5 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item4 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item3 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item2 | TEXT | Uncoded Value | uncategorized | none | none | |
| Item1 | TEXT | Uncoded Value | uncategorized | none | none | |
| Hyperlink | Hyperlink to digital copy of photograph | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Photographer | Photographer | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Direction | Direction facing when photo taken | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Description | Description | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Date | Date photo was taken | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Subject | Subject | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Site | Site | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Sort | Sort number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Exp | Exposure number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Speed | Film speed | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Film | Film Type | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Roll | Roll identifier | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| BinderNum | Note book binder number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Page | Page | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| PhotoId | Unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
Table Information: RimStudy
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| s_Lineage | BLOB | Uncoded Value | uncategorized | none | none | |
| s_GUID | TEXT | Uncoded Value | uncategorized | none | none | |
| s_Generation | BIGINT | Uncoded Value | uncategorized | none | none | |
| s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none | |
| Gen_Comments | BIGINT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| Firing int | Reduced, Oxidized, Both | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Firing ext | Reduced, Oxidized, Both | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Carbon sym | Centered, Exteriorly biased, Interiorly biased | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Carbon streak width | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Foot type | Flared, Direct, Clawed, Pointed | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Support attachment | Simple, Complex | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Support shaft type | Simple, Kneed, Bulbuous | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Support xsection | Circular, Elliptical | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Brushed ware neck treat | Simple, Smoothed, Burnished, Highly burnished/Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Lip to brushing | The measurement on brushed wares from the top of the lip to the point at which brushing begins - measures the amount of obliterated brushing at rim. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| Handle position | Rim, Neck, Shoulder, Body | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Handle orientation | Vertical, Horizontal | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Tripod whole | Presence of the entire tripod - shape, length, and width measurements should be possible. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Tripod frag | Only a portion of the tripod remains - either shape, length, and/or width measurement would be missing. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Tripod facet | Scar where tripod broke off, but effectively no tripod remaining. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Rim tab | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Base | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Body | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Arc int | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Orifice radius int | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Arc ext | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Orifice radius ext | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Slip consistency | Washy, Complete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Surface finish int | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Surface finish ext | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| DecorationId | FK to _CerTrtmnt | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Decoration | Decorated, Undecorated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| LipTreatmentId | FK to _RimLipTreatment | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Lip treatment | Ticking, Notching, Continuous lines, Discontinuous line, Zig-Zag, Wavy, Diagonal lines, Combination | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Lip thickening | Yes or No | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| LipFormId | FK to _RimLipForm | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Lip form | Tapered, Rounded, Squared | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Neck-shoulder thickness | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Rim thickening | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| RimFormId | FK to _RimRimForm | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Rim form | Look to "Rim study: rim form lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ContourTypeId | FK to _RimContourType | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Contour type | Look to "Rim study: contour type lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VesselShapeId | FK to _RimVsslShape | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Vessel shape | Look to "Rim study: vessel shape lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TypeId | FK to _CerType | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Type | Look to "Ceramics: type lookup" for more information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| WareId | FK to _CerTypeWare | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | ||
| Ware | Incised-engraved, Painted, Plain, Negative, Pseudo-cloisonné, Indeterminate, Historic, Slipped | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Date coded | DATETIME | Uncoded Value | uncategorized | none | none | |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | |
| Year | TEXT | Uncoded Value | uncategorized | none | none | |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| Bag number | TEXT | Uncoded Value | uncategorized | none | none | |
| Box number | BIGINT | Uncoded Value | uncategorized | none | none | |
| BoxId_new | BIGINT | Uncoded Value | uncategorized | none | none | |
| PrimId | TEXT | Uncoded Value | uncategorized | none | none | |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | |
| V number | BIGINT | Uncoded Value | uncategorized | none | none | |
| Sort number | BIGINT | Uncoded Value | uncategorized | none | none | |
| AndrewComment | TEXT | Uncoded Value | uncategorized | none | none | |
| R number | TEXT | Uncoded Value | uncategorized | none | none | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Site | TEXT | Uncoded Value | uncategorized | none | none | |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | |
| Level | TEXT | Uncoded Value | uncategorized | none | none | |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: RimStudy_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| GenComments | BIGINT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | |
| FiringInt | TEXT | Uncoded Value | uncategorized | none | none | |
| FiringExt | TEXT | Uncoded Value | uncategorized | none | none | |
| CarbonSym | TEXT | Uncoded Value | uncategorized | none | none | |
| CarbonStreakWidth | DOUBLE | Uncoded Value | uncategorized | none | none | |
| FootType | TEXT | Uncoded Value | uncategorized | none | none | |
| SupportAttachment | TEXT | Uncoded Value | uncategorized | none | none | |
| SupportShaftType | TEXT | Uncoded Value | uncategorized | none | none | |
| SupportXSection | TEXT | Uncoded Value | uncategorized | none | none | |
| BrushedWareNeckTreat | TEXT | Uncoded Value | uncategorized | none | none | |
| LipToBrushing | DOUBLE | Uncoded Value | uncategorized | none | none | |
| HandlePositionId | BIGINT | Uncoded Value | uncategorized | none | none | |
| HandlePosition | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| HandelPositionId | BIGINT | Uncoded Value | uncategorized | none | none | |
| HandleOrientation | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| TripodWhole | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| TripodFrag | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| TripodFacet | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| RimTab | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Base | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| ArcInt | DOUBLE | Uncoded Value | uncategorized | none | none | |
| OrificeRadiusInt | DOUBLE | Uncoded Value | uncategorized | none | none | |
| ArcExt | DOUBLE | Uncoded Value | uncategorized | none | none | |
| OrificeRadiusExt | DOUBLE | Uncoded Value | uncategorized | none | none | |
| SlipConsistencyId | BIGINT | Uncoded Value | uncategorized | none | none | |
| SlipConsistency | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| SurfaceFinishInt | TEXT | Uncoded Value | uncategorized | none | none | |
| SurfaceFinishExt | TEXT | Uncoded Value | uncategorized | none | none | |
| DecorationId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Decoration | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| LipTreatmentId | BIGINT | Uncoded Value | uncategorized | none | none | |
| LipTreatment | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| LipThickening | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| LipFormId | BIGINT | Uncoded Value | uncategorized | none | none | |
| LipForm | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| NeckSsoulderThickness | DOUBLE | Uncoded Value | uncategorized | none | none | |
| RimThickening | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| RimFormId | BIGINT | Uncoded Value | uncategorized | none | none | |
| RimForm | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| ContourTypeId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ContourType | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none | |
| VesselShape | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Type | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Ware | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | |
| Year | TEXT | Uncoded Value | uncategorized | none | none | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | |
| ULL | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | |
| Level | TEXT | Uncoded Value | uncategorized | none | none | |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| BagNumber | TEXT | Uncoded Value | uncategorized | none | none | |
| Body | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| BoxNumber | BIGINT | Uncoded Value | uncategorized | none | none | |
| VNumber | BIGINT | Uncoded Value | uncategorized | none | none | |
| SortNumber | BIGINT | Uncoded Value | uncategorized | none | none | |
| RNumber | TEXT | Uncoded Value | uncategorized | none | none | |
| RimId | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: RimStudyold_2
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | |
|---|---|---|---|---|---|---|
| s_Lineage | BLOB | Uncoded Value | uncategorized | none | none | |
| s_GUID | TEXT | Uncoded Value | uncategorized | none | none | |
| s_Generation | BIGINT | Uncoded Value | uncategorized | none | none | |
| s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none | |
| Gen_Comments | BIGINT | Uncoded Value | uncategorized | none | none | |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | |
| Firing int | Reduced, Oxidized, Both | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Firing ext | Reduced, Oxidized, Both | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Carbon sym | Centered, Exteriorly biased, Interiorly biased | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Carbon streak width | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Foot type | Flared, Direct, Clawed, Pointed | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Support attachment | Simple, Complex | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Support shaft type | Simple, Kneed, Bulbuous | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Support xsection | Circular, Elliptical | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Brushed ware neck treat | Simple, Smoothed, Burnished, Highly burnished/Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Lip to brushing | The measurement on brushed wares from the top of the lip to the point at which brushing begins - measures the amount of obliterated brushing at rim. | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | ||
| Handle position | Rim, Neck, Shoulder, Body | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Handle orientation | Vertical, Horizontal | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Handle | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Tripod whole | Presence of the entire tripod - shape, length, and width measurements should be possible. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Tripod frag | Only a portion of the tripod remains - either shape, length, and/or width measurement would be missing. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Tripod facet | Scar where tripod broke off, but effectively no tripod remaining. | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Rim tab | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Base | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Body | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Shoulder | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Neck | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Lip | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Rim | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Arc int | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Orifice radius int | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Arc ext | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Orifice radius ext | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Slip consistency | Washy, Complete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Surface finish int | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Surface finish ext | Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Decoration | Decorated, Undecorated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Lip treatment | Ticking, Notching, Continuous lines, Discontinuous line, Zig-Zag, Wavy, Diagonal lines, Combination | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Lip thickening | Yes or No | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | ||
| Lip form | Tapered, Rounded, Squared | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Neck-shoulder thickness | DOUBLE | Uncoded Value | uncategorized | none | none | |
| Rim thickening | BOOLEAN | Uncoded Value | uncategorized | none | none | |
| Rim form | Look to "Rim study: rim form lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Contour type | Look to "Rim study: contour type lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Vessel shape | Look to "Rim study: vessel shape lookup" for possible values, definitions, and examples | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Type | Look to "Ceramics: type lookup" for more information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Ware | Incised-engraved, Painted, Plain, Negative, Pseudo-cloisonné, Indeterminate, Historic, Slipped | |||||
| TEXT | Uncoded Value | uncategorized | none | none | ||
| Date coded | DATETIME | Uncoded Value | uncategorized | none | none | |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | |
| Year | TEXT | Uncoded Value | uncategorized | none | none | |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | |
| Level | TEXT | Uncoded Value | uncategorized | none | none | |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | |
| Site | TEXT | Uncoded Value | uncategorized | none | none | |
| Bag number | TEXT | Uncoded Value | uncategorized | none | none | |
| Box number | BIGINT | Uncoded Value | uncategorized | none | none | |
| V number | BIGINT | Uncoded Value | uncategorized | none | none | |
| Sort number | BIGINT | Uncoded Value | uncategorized | none | none | |
| R number | TEXT | Uncoded Value | uncategorized | none | none | |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | |
Table Information: Romos2001Blk
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology |
|---|---|---|---|---|---|
| Comments | TEXT | Uncoded Value | uncategorized | none | none |
| RimExt_AllInt | DOUBLE | Uncoded Value | uncategorized | none | none |
| RimInt_AllExt | DOUBLE | Uncoded Value | uncategorized | none | none |
| AllBoth | DOUBLE | Uncoded Value | uncategorized | none | none |
| AllExt | DOUBLE | Uncoded Value | uncategorized | none | none |
| AllInt | DOUBLE | Uncoded Value | uncategorized | none | none |
| RimIntExt | DOUBLE | Uncoded Value | uncategorized | none | none |
| RimExt | DOUBLE | Uncoded Value | uncategorized | none | none |
| RimInt | DOUBLE | Uncoded Value | uncategorized | none | none |
| BrdOtr | DOUBLE | Uncoded Value | uncategorized | none | none |
| BrdStr | DOUBLE | Uncoded Value | uncategorized | none | none |
| ThkOtr | DOUBLE | Uncoded Value | uncategorized | none | none |
| ThkStr | DOUBLE | Uncoded Value | uncategorized | none | none |
| ThnOtr | DOUBLE | Uncoded Value |