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 | Search |
|---|---|---|---|---|---|---|
| adhoc_element_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| element name | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtCatAnalyticalClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AnalyticalClass | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtCatFunctionalClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FunctClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FunctionalClass | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtCatManufacturingClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ManufacturingClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ManufacturingClass | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| GenAnalyticalClass | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtCatMaterialClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MaterialClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Material | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ArtifactCatTypes
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ArtCatTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TypePrefix | TEXT | Uncoded Value | uncategorized | none | none | true |
| Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| Sort order | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AU_Phase3
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Phase3_ID | Phase3 unique identifier - | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Phase_Name | phase name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: _AUCultSpace
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CultSpaceId | Cultural Space unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| CultSpace | Cultural space name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SubChapterId | Sub-chapter FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
Table Information: _AUGroupLvl1
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| GroupLvl1Id | Group Level1 unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| GroupLvl1 | Group Level1 name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | Site Fk | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
Table Information: _AUGroupLvl2
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| GroupLvl2Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| GroupLvl2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AuAreaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AUPhase
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PhaseId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Phase | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _AUPhase2
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Phase2Id | Phase2 unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Phase2 | phase2 name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: _AUReportArea
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ReportAreaId | Report area unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| SiteID | Site identifier and FK to sites lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ReportArea | Report area name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SortOrder | numeric field for sorting records | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
Table Information: _Botan_Types
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Botan_type_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Botan_type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Botanical_Types
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Botanical_type_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Botanical_type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _BotTaxaPaula
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| name | TEXT | Uncoded Value | uncategorized | none | none | true |
| s_ColLineage | BLOB | Uncoded Value | uncategorized | none | none | true |
| s_Generation | BIGINT | Uncoded Value | uncategorized | none | none | true |
| s_GUID | TEXT | Uncoded Value | uncategorized | none | none | true |
| s_Lineage | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: _CarbonSampleConcentration
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ConcentrationId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Concentration | TEXT | Uncoded Value | uncategorized | none | none | true |
| ConcentrationSp | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CarbonSampleComposition
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CompositionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Composition | TEXT | Uncoded Value | uncategorized | none | none | true |
| CompositionSp | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CarbonSamplePriority
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PriorityId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Priority | TEXT | Uncoded Value | uncategorized | none | none | true |
| PrioritySp | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CarbonSampleSize
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SampleSizeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Size | TEXT | Uncoded Value | uncategorized | none | none | true |
| SizeSp | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Cer_Element_Groups
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Element_group_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Element_group | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Cer_Elements
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Desccription | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cer_element_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Element | TEXT | Uncoded Value | uncategorized | none | none | true |
| Element_Group | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| OrderId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FormName | TEXT | Uncoded Value | uncategorized | none | none | true |
| FormCode | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerPortion
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| OrderId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PortionName | TEXT | Uncoded Value | uncategorized | none | none | true |
| PortionCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| SpGroupPortion | TEXT | Uncoded Value | uncategorized | none | none | true |
| EnGroupPortion | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerRprtGrps
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ReportGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ReportGroups | TEXT | Uncoded Value | uncategorized | none | none | true |
| ReportGroupsSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
| ReportGroupOrder | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerTrtmnt
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TrtmntId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Treatment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| OrderId | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TypeName | TEXT | Uncoded Value | uncategorized | none | none | true |
| TypeNameSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
| TypeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
| ReportGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TrtmntId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CerType_Old_Bak
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| type_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| order_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| decoration_type | TEXT | Uncoded Value | uncategorized | none | none | true |
| type_name | TEXT | Uncoded Value | uncategorized | none | none | true |
| type_label | TEXT | Uncoded Value | uncategorized | none | none | true |
| s_ColLineage | left over from synch no longer needed - cant delete | |||||
| BLOB | Uncoded Value | uncategorized | none | none | true | |
| s_Generation | left over from synch no longer needed - cant delete | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| s_GUID | left over from synch no longer needed - cant delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| s_Lineage | left over from synch no longer needed - cant delete | |||||
| BLOB | Uncoded Value | uncategorized | none | none | true | |
Table Information: _CerTypeWare
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| WareName | TEXT | Uncoded Value | uncategorized | none | none | true |
| WareNameSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ChapterGroups
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ChapterGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ChapterGroup | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AreaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _CulturalSpace
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CultSpaceId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CultSpace | TEXT | Uncoded Value | uncategorized | none | none | true |
| SubGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebCortex
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CotexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Cortex | TEXT | Uncoded Value | uncategorized | none | none | true |
| CortexSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebMaterial
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Material | TEXT | Uncoded Value | uncategorized | none | none | true |
| MaterialSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebStage
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| StageId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Stage | TEXT | Uncoded Value | uncategorized | none | none | true |
| StageSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebStageIdx
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| StageIdxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| StageIndex | TEXT | Uncoded Value | uncategorized | none | none | true |
| StageIndexSP | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| TypeSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _DebTypeB
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TypeBId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Typeb | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FieldNotebooks_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| NotebookId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| NotebookPrefix | TEXT | Uncoded Value | uncategorized | none | none | true |
| NoteBookNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Year | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FNTPDF | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FieldNotebooks
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| NotebookId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| NotebookPrefix | TEXT | Uncoded Value | uncategorized | none | none | true |
| NoteBookNumber | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Year | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FNTPDF | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FigFinish
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FinishId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Finish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FigPortion
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Portion | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FigSex
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Sex | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FigType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaBurn
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| BurnId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BurnCode | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaElement
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Utilindex | TEXT | Uncoded Value | uncategorized | none | none | true |
| UtilindexSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
| ElementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaFusion
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FusionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Code | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaHumMod
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| HumModId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| HumModCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabe | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| DescriptionSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaNatMod
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| NatModID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Code | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaProxDist
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ProxDistId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Code | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _FnaTaxa
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Taxa | TEXT | Uncoded Value | uncategorized | none | none | true |
| TaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CodeLabel | TEXT | Uncoded Value | uncategorized | none | none | true |
| CodeLabelSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| DescriptionSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GndstnCond
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CondId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CondCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| Condition | TEXT | Uncoded Value | uncategorized | none | none | true |
| ConditionSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GndstnMat
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RawMatCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| RawMaterial | TEXT | Uncoded Value | uncategorized | none | none | true |
| RawMaterialSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GndstnMTM
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MTMId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MTMCode | Mano Trough Metate | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ManoTroughMetate | TEXT | Uncoded Value | uncategorized | none | none | true |
| ManoTroughMetateSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GndstnWear
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| WearId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| WearCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| Wear | TEXT | Uncoded Value | uncategorized | none | none | true |
| WearSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _GrndstnCat
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CatCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| Category | TEXT | Uncoded Value | uncategorized | none | none | true |
| CategorySpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _HmOsLvl1Grp
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Lvl1GrpId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Lvl1Group | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _HmOstEleNorm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ElementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Element | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _HmOstLvl2Grp
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Lvl2GrpId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Lvl2Group | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_Element_Fill_revised
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ElementFillId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FIll | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_Element_Fill
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ElementFillId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FIll | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_Elements
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| IE_ElementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ElementName | TEXT | Uncoded Value | uncategorized | none | none | true |
| ElementDescription | TEXT | Uncoded Value | uncategorized | none | none | true |
| ElementTypeId | FK to ElementType Lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| adhocEleType_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| HyperlinkedDrawing | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| cer_element_group_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_Elements_revised
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| IE_ElementId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ElementName | TEXT | Uncoded Value | uncategorized | none | none | true |
| ElementDescription | TEXT | Uncoded Value | uncategorized | none | none | true |
| ElementTypeId | FK to ElementType Lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ElementGroups | TEXT | Uncoded Value | uncategorized | none | none | true |
| HyperlinkedDrawing | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_ElementType_revised
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Element Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| ElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _IE_ElementType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ElementTypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Element Type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _LPGeneralSiteAreas
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteArea | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _LPMound1SubAreas
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Mound1SubArea | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _LPPlaza1SubAreas
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Plaza1SubArea | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _MbotFrctnId
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FractionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Fraction | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _MbotPrtn
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MbotPortId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Portion | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _MbotTaxa
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Taxa | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimContourType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| contour_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Contour type | TEXT | Uncoded Value | uncategorized | none | none | true |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimLipForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| lip_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Lip form | TEXT | Uncoded Value | uncategorized | none | none | true |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimLipTreatment
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| lip_treat_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Lip treatment | TEXT | Uncoded Value | uncategorized | none | none | true |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimRimForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| rim_form_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Rim form | TEXT | Uncoded Value | uncategorized | none | none | true |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RimVsslShp
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| shape_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Shape | TEXT | Uncoded Value | uncategorized | none | none | true |
| Hyperlink example | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| bowl_jar1 | all vessel shapes classified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| bowl_jar2 | only definitives classified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: _RSContourType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ContourType | TEXT | Uncoded Value | uncategorized | none | none | true |
| example | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSDecoration
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Decoration | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSLipForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| LipForm | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSLipTreatment
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| LipTreatment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSRimForm
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| RimForm | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSSlipConsistency
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SlipConsistency | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSVesselShape_DELETE
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| VesselShape | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _RSWare_DELETE
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Ware | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ShellClass
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Class | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _ShellGenera
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| GeneraId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Genera | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _Sites
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteName | TEXT | Uncoded Value | uncategorized | none | none | true |
| SttlmntAffltn | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _SpecArtClass
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FunctionalClass | TEXT | Uncoded Value | uncategorized | none | none | true |
| FunctionalClassSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _SpecArtDec
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| DecTechId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| DecTech | TEXT | Uncoded Value | uncategorized | none | none | true |
| DecTechSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _SpecArtMat
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SpecArtMatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Material | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _STMatGrpId
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| MatGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MaterialGroup | TEXT | Uncoded Value | uncategorized | none | none | true |
| MaterailGroupSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _STType
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ToolType | TEXT | Uncoded Value | uncategorized | none | none | true |
| ToolTypeSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _SubGroups
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SubGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SubGroupName | TEXT | Uncoded Value | uncategorized | none | none | true |
| ChapterGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _TableGroups
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| TableGroupId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TableGroupName | TEXT | Uncoded Value | uncategorized | none | none | true |
| TableGroupNamesSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SortOrder | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Table Information: _TypeCllctnFunctClass
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TypeCllctnId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FunctClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: _UnitYear
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| UnitYearId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| UnitId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| YearExcavated | BIGINT | Uncoded Value | uncategorized | none | none | true |
| NotebookId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PDFURL | TEXT | Uncoded Value | uncategorized | none | none | true |
| PageNumbers | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _UnitYear_old
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PageNumbers | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| UnitYearId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| UnitId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| YearExcavated | BIGINT | Uncoded Value | uncategorized | none | none | true |
| NotebookId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PDFURL | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: _WoodTaxa
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| WoodtaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Taxa | TEXT | Uncoded Value | uncategorized | none | none | true |
| TaxaSpanish | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Area_labels_lookup
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Area_name | TEXT | Uncoded Value | uncategorized | none | none | true |
| Area_label | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtCatAnalyticalClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtCatFunctionalClasses
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Priority | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtCatVesselAnalysis
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtifactCat_Bags
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| BagId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BagName | TEXT | Uncoded Value | uncategorized | none | none | true |
| BoxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SummaryDescription | The inventory summary for the Artifact Catalog | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ArtifactCat_BoxInventory
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| BoxId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| BoxNo | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cataloged | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| SortOrder | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: ArtifactCatalog
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Item | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 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 | true | |
| Other Prov | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| Other Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| DetailSheetDescription | 250 word limit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| CatalogName | TEXT | Uncoded Value | uncategorized | none | none | true |
| DetailSheet | Does this item require a Detail catalog sheet? | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| SummarySheet | Is this item in the general catalog summary for its respective box? | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| YearExcavated | TEXT | Uncoded Value | uncategorized | none | none | true |
| ArtifactCatType | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MaterialId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash # | TEXT | Uncoded Value | uncategorized | none | none | true |
| BulkSheetDescription | 250 word limit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ware | TEXT | Uncoded Value | uncategorized | none | none | true |
| type | TEXT | Uncoded Value | uncategorized | none | none | true |
| form | TEXT | Uncoded Value | uncategorized | none | none | true |
| 2007comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| INAHCatNum | TEXT | Uncoded Value | uncategorized | none | none | true |
| INAHBoxNum | TEXT | Uncoded Value | uncategorized | none | none | true |
| WareId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| VesselShapeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FunctionalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ManufacturingClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| AnalyticalClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MaterialClassId | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: AUs
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| PhaseId | AUs gouped by inferred phases (Early, Late, Terrace FIll, N/A) FK to _TableGroup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| AUId | PK identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
| AUNum | Official Analytical Unit Number as appears in final report | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| SortNumber | Nymber used to perform numeric sorts on the text field AUNum | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| new num | temp field used for renumbering aus on the fly | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| BriefDesc | Abbreviated brief description of the AU | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ShortDesc | Contains some abbreviations | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FullDesc | No abbreviations - Fully written out description of the AU | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SPFullDesc | Spanish translation of FullDesc | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TerraceFill | AUs related to terrace fill | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Mixed | AUs for which the provenience is not known in more detail than the unit | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| SurfHum | AUs that contain surface and humus deposits | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| BoneConc | AUs related to Bone Concentrations | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
| FF | AUs that include pure fill immediately above floors | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Hearth | AUs related to hearths | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| Midden | AUs related to trash or midden deposits | |||||
| BOOLEAN | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
| 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 | true | |
| 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 | true | |
| 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 | true | |
| DepNotes | Notes about the depositional contexts | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
| 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 | true | |
| 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 | true | |
| 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 | true | |
| 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 | true | |
| CeremonialStatus | Is the context ceremonial or non-ceremonial - constructed from Jaime H's groundstone analysis | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | General comments about the AU | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ReportAreaId | AUs grouped by the areas discussed in the Informe Final - FK to _ReportArea table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
Table Information: BoxInv
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | unique box indentifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Collection | Which artifact collection does the box hold | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Site | What site does the material come from | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Box number | Box Number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Bag number | Bag Number | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Material | Material | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Size | Size | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Year | Year | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locality | Locality | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Horizontal | Horizontal | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Vertical | Vertical | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Recorder | Recorder | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Bag count | Bag Count | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Comments | Comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: CADLabels
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | Unique label identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| FileName | AutoCad file to which the label belongs | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| EnglishLabels | English label text | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SpanishLabels | Spanish label text | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: CarbonSamples
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SampleSize | Sample Size - not a necessary field - used to check accuracy of the SampleSizeID field | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SampleSizeId | Sample Size identifier and FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| CarbonSampleId | Unique carbon sample identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | Site ID FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Unit | Unit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level | Level | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Unit-Level-Locus - not a necessary field - was for checking accuracy of ULLID | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | Unit-Level-Locus identifier and FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| PointLocation | Point provenience information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateExcavated | Date sample was excavated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SizeNotes | Comments from the field notes regarding sample size | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Composition | Composition - not a necessary field - was used for checking accuracy of the CompositionID | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| CompositionId | Composition identifier and FK | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| CompNotes | Comments from the field notees regarding the sample's composition | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Associations | Comments from the field notes regarding other artifact or feature associations with the sample | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Concentration | Category referring to the degree of dispersion or concentration of the sample | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ConcentrationId | Concentration Fk to lookup | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ConcNotes | Comments in the field notes regarding the nature of the sample's concentration | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Contamination | Potential sources of sample contamination | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
| PriorityId | Priority FK to lookup table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| PriorityNotes | Comments in the field note regarding the importance and datability of the sample | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Soil | Nature of the soil matrix within which the sample was found | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | Comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateId | Has value if the sample was dated - this is the FK link to the Dates table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Ceramics
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Collection | LQ-MVAP - from our excavations, Armillas - from the Armillas collection | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Year | Year specimens were excavated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | Site at which specimens derived - FK to _Site table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Redundant data left for purposes of crosschecking for reassigned ULLs - do not delet yet | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| CerId | Ceramic idenitification Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
| Unit | Unit designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level | Level designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus Designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeId | Type designation - FK to _CerType table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TypeCnfdnc | C - Confident, U - Unconfident | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FormId | Form Designation - FK to _CerForm table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| FormCnfdnc | C - Confident, U - Unconfident | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PortionId | Portion Designation - FK to _CerPortionId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Count | Artifact count | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Sorter | Name of ceramic sorter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeOld | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Ceramics_old_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CerId | Ceramic idenitification Number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Year | Year specimens were excavated | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Collection | LQ-MVAP - from our excavations, Armillas - from the Armillas collection | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | Site at which specimens derived - FK to _Site table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Redundant data left for purposes of crosschecking for reassigned ULLs - do not delet yet | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
| Unit | Unit designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level | Level designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus Designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeId | Type designation - FK to _CerType table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TypeCnfdnc | C - Confident, U - Unconfident | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FormId | Form Designation - FK to _CerForm table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| FormCnfdnc | C - Confident, U - Unconfident | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PortionId | Portion Designation - FK to _CerPortionId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Count | Artifact count | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Sorter | Name of ceramic sorter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeOld | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Dates
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| StanDevCon | TEXT | Uncoded Value | uncategorized | none | none | true |
| IntCal | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cal1sig | TEXT | Uncoded Value | uncategorized | none | none | true |
| Lab | TEXT | Uncoded Value | uncategorized | none | none | true |
| LabId | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RadiocarbonFormId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| DateType | TEXT | Uncoded Value | uncategorized | none | none | true |
| Submitted | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| ExcArea | TEXT | Uncoded Value | uncategorized | none | none | true |
| Material | TEXT | Uncoded Value | uncategorized | none | none | true |
| StratPos | TEXT | Uncoded Value | uncategorized | none | none | true |
| MeasC14 | BIGINT | Uncoded Value | uncategorized | none | none | true |
| StanDevMeas | BIGINT | Uncoded Value | uncategorized | none | none | true |
| 13C/12C | TEXT | Uncoded Value | uncategorized | none | none | true |
| ConC14 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cal2sig | TEXT | Uncoded Value | uncategorized | none | none | true |
| OxCal1sig | TEXT | Uncoded Value | uncategorized | none | none | true |
| OxCal2sig | TEXT | Uncoded Value | uncategorized | none | none | true |
| Reference | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: DatesListLQ(old)_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| +/-* | BIGINT | Uncoded Value | uncategorized | none | none | true |
| id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| beta sample # | TEXT | Uncoded Value | uncategorized | none | none | true |
| site | TEXT | Uncoded Value | uncategorized | none | none | true |
| unit | BIGINT | Uncoded Value | uncategorized | none | none | true |
| level | BIGINT | Uncoded Value | uncategorized | none | none | true |
| locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| measured C14 age | BIGINT | Uncoded Value | uncategorized | none | none | true |
| +/- | BIGINT | Uncoded Value | uncategorized | none | none | true |
| C13/C12 ratio | TEXT | Uncoded Value | uncategorized | none | none | true |
| conventional C14 age | BIGINT | Uncoded Value | uncategorized | none | none | true |
| calibrated results (2 sigma, 95% prob) | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Debitage
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| DebId | Debitage identification number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | Site from which the samples derive - FK _Sites table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Unit-Level-Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | Unit Level Locus Id - FK to ULL table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Slash | Slash number or letter of the specimen | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeId | Flake Type - FK to _DebType table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TypeBId | Flake TypeB - FK to _DebTypeB table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| StageIndexId | Reduction stage index - FK to _DebStageIndex Table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| StageId | Reduction stage - FK to _DebStage table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| CortexId | Presence or absence of cortex - FK to _DebCortex table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| MatId | Raw material of specimen - FK to _DebMaterial table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Tool | ??? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Count | Specimen count by row | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Comment | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: elements
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SiteCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| ReportAreaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Phase_Name | TEXT | Uncoded Value | uncategorized | none | none | true |
| ReportArea | TEXT | Uncoded Value | uncategorized | none | none | true |
| Element_group | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: elements3_delete
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SiteCode | TEXT | Uncoded Value | uncategorized | none | none | true |
| ReportAreaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Phase_Name | TEXT | Uncoded Value | uncategorized | none | none | true |
| ReportArea | TEXT | Uncoded Value | uncategorized | none | none | true |
| Element_group | TEXT | Uncoded Value | uncategorized | none | none | true |
| count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| type | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: EP_ULL_VOL_EST_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: ExcvtdUnits_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| UnitId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| UnitNum | TEXT | Uncoded Value | uncategorized | none | none | true |
| Location | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Fauna
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ID | Identification number | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Bag | Specimens were pulled from a Bag with this identifier | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | FK to SitesId column of the _Sites table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Unit Level Locus - to be deleted eventually | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | FK to ULLId of the ULL table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| AU | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Sorter | Person who sorted, coded and counted the information | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comments | General comments | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SecondaryAU | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unit | Unit designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level | Level designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus designation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Taxa | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TaxaId | FK to the TaxaId column of the _FnaTaxa table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TaxaDesc | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ElementId | FK to ElementId column of the _FnaElement table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ProxDist | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ProxDistId | FK to the ProxDistId column of the _FnaProxDist table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Fusion | to be delted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FusionId | FK to the FusionId column of the _FnaFusion table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| BurnId | FK to the BurnId column of the _FnaBurn table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| BurnDesc | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| HumModId | FK to the HumModId column of the _FnaHumMod table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| HumModDesc | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| NatModId | FK to the NatModId column of the _FnaNatMod table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Count | Count of items in row | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeSpecimen | Is the specimen useful for comparison or as a type? - see Rebekah Parks for details | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Fauna_Old_Bak_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| AU | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Bag | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Secondary AU | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Taxa | TEXT | Uncoded Value | uncategorized | none | none | true |
| taxa desc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Element | TEXT | Uncoded Value | uncategorized | none | none | true |
| Prox-dist | TEXT | Uncoded Value | uncategorized | none | none | true |
| Fusion | TEXT | Uncoded Value | uncategorized | none | none | true |
| Burn | BIGINT | Uncoded Value | uncategorized | none | none | true |
| burn desc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Hum_mod | TEXT | Uncoded Value | uncategorized | none | none | true |
| hum_mod desc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Nat_mod | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Figurines before removal of 4 items_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Figurine_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Com3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com4 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com5 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com6 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Finish | TEXT | Uncoded Value | uncategorized | none | none | true |
| FinishId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Com1 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Prim_id | TEXT | Uncoded Value | uncategorized | none | none | true |
| F_numb | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Williams_Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| LQ_Type | New Types based on Jaime H's classification of 2006 | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Old_Type_Id | Kim Goldstein's original type - no longer used | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Part | TEXT | Uncoded Value | uncategorized | none | none | true |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| FullDesc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Sex | TEXT | Uncoded Value | uncategorized | none | none | true |
| SexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Paint | TEXT | Uncoded Value | uncategorized | none | none | true |
| PaintId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Com7 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com 8 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com9 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com10 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Other_com | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | TEXT | Uncoded Value | uncategorized | none | none | true |
| KimsComments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Figurines_legacy_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| FigurineId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com4 | TEXT | Uncoded Value | uncategorized | none | none | true |
| ID_name | TEXT | Uncoded Value | uncategorized | none | none | true |
| F_numb | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Item_numb | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Part | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Type | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| TypeId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Sex | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Paint | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PaintId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Finish | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FinishId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Com1 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com5 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com6 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com7 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com 8 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com9 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com10 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Other_com | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: Figurines_new
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Sex | TEXT | Uncoded Value | uncategorized | none | none | true |
| SexId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Paint | TEXT | Uncoded Value | uncategorized | none | none | true |
| PaintId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Finish | TEXT | Uncoded Value | uncategorized | none | none | true |
| FinishId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Com1 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Figurine_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Prim_id | TEXT | Uncoded Value | uncategorized | none | none | true |
| F_numb | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Williams_Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| LQ_Type | New Types based on Jaime H's classification of 2006 | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Old_Type_Id | Kim Goldstein's original type - no longer used | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Part | TEXT | Uncoded Value | uncategorized | none | none | true |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| FullDesc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com4 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com5 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com6 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com7 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com 8 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com9 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Com10 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Other_com | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | TEXT | Uncoded Value | uncategorized | none | none | true |
| KimsComments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Grndstn
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| GrndstnId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CatId | FK to the Artifact Catalog Table where possible | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TypeCatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Year | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| ConId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| PrcntPrsnt | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Length | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Thinnest | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Thickest | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Weight | TEXT | Uncoded Value | uncategorized | none | none | true |
| WearId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| MatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ManoSurfaces | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| MTMId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TypeCllctn | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| MatCnfdnc | TEXT | Uncoded Value | uncategorized | none | none | true |
| 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 | true | |
| TypeCnfdnc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Table Information: Grndstn_Old_Bak_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| AU | TEXT | Uncoded Value | uncategorized | none | none | true |
| percent_present | BIGINT | Uncoded Value | uncategorized | none | none | true |
| id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| year | BIGINT | Uncoded Value | uncategorized | none | none | true |
| site | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| level | TEXT | Uncoded Value | uncategorized | none | none | true |
| locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| locale | TEXT | Uncoded Value | uncategorized | none | none | true |
| analytica_unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| type | TEXT | Uncoded Value | uncategorized | none | none | true |
| tool_category | TEXT | Uncoded Value | uncategorized | none | none | true |
| condition | TEXT | Uncoded Value | uncategorized | none | none | true |
| length | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| width | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| wear | TEXT | Uncoded Value | uncategorized | none | none | true |
| degree_of_wear | TEXT | Uncoded Value | uncategorized | none | none | true |
| material | TEXT | Uncoded Value | uncategorized | none | none | true |
| raw_material | TEXT | Uncoded Value | uncategorized | none | none | true |
| count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| thinnest | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| thickest | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| manopolish_#wearsurfaces | BIGINT | Uncoded Value | uncategorized | none | none | true |
| manopolish_shapedbytroughmetate? | TEXT | Uncoded Value | uncategorized | none | none | true |
| comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: IE_SherdElemJunct
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| IESherdId | FK to IESherdId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| IE_ElementId | FK to IE_Element table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| IE_ElementFillId | FK to Element Fill table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
Table Information: IE_Sherds
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
| IESherdsIdD | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RimStudyId | FK to RimStudy RimStudyId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| RNumber | FK to RimStudy R number field | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | FK to _Sites | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Site | Site Name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Slash | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | true |
| BoxNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| BagNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| VNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| YearExcavated | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: iesherds_copy
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| IESherdsIdD | BIGINT | Uncoded Value | uncategorized | none | none | true |
| RimStudyId | FK to RimStudy RimStudyId | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| RNumber | FK to RimStudy R number field | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| VNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | FK to _Sites | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Slash | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Coder | TEXT | Uncoded Value | uncategorized | none | none | true |
| DateCoded | DATETIME | Uncoded Value | uncategorized | none | none | true |
| BoxNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| BagNumber | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| YearExcavated | Only necessary if there is no RNumber (unit-level-locus) | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: IllstArtfcts
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| IllustId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CodeId | This code is the lookup to the physical drawings stored in portfolios and notebooks | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| CatId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TypeCllctnId | FK to TypeCllctnId column in the TypeCllctn table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Link | This is a hyperlink to the illustration living on the server | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Status | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteId | FK to SiteId column of _Sites tables | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| ULL | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Illustration | BLOB | Uncoded Value | uncategorized | none | none | true |
| SelectForReport | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| SelectedForCat | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
Table Information: IllstOthers
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| IlustId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| IllustNum | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteId | TEXT | Uncoded Value | uncategorized | none | none | true |
| Type | TEXT | Uncoded Value | uncategorized | none | none | true |
| TypeId | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Area | TEXT | Uncoded Value | uncategorized | none | none | true |
| Report/Figure | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: INAH_CAT_EXT_REF_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| INAH_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| CATNO | TEXT | Uncoded Value | uncategorized | none | none | true |
| BOXNO | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Legacy_BotTaxaMich_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Fraction | TEXT | Uncoded Value | uncategorized | none | none | true |
| taxa_id | Taxa unique identifier | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Phase | TEXT | Uncoded Value | uncategorized | none | none | true |
| 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 | true | |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Area | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | TEXT | Uncoded Value | uncategorized | none | none | true |
| Locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| FractionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| TaxonId | TEXT | Uncoded Value | uncategorized | none | none | true |
| Taxon | TEXT | Uncoded Value | uncategorized | none | none | true |
| Portion | No values | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Charred | No values | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Comment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LP_ULL_VOL_EST_del
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: LPHumBone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SpecimenId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SPNum | TEXT | Uncoded Value | uncategorized | none | none | true |
| Box | TEXT | Uncoded Value | uncategorized | none | none | true |
| AnalyticUnit | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Prov | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Element | TEXT | Uncoded Value | uncategorized | none | none | true |
| ElementST | TEXT | Uncoded Value | uncategorized | none | none | true |
| ElementId | FK to _HmOstEleNorm | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Lvl1Group | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Lvl1GrpId | FK to _HmOstLvl1Grp | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Lvl2Group | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Lvl2GrpId | FK to _HmOstLvl2Grp | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Side | TEXT | Uncoded Value | uncategorized | none | none | true |
| Segment | TEXT | Uncoded Value | uncategorized | none | none | true |
| Age | TEXT | Uncoded Value | uncategorized | none | none | true |
| Sex | TEXT | Uncoded Value | uncategorized | none | none | true |
| Compl | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Intextsurf | TEXT | Uncoded Value | uncategorized | none | none | true |
| Perimortem | TEXT | Uncoded Value | uncategorized | none | none | true |
| Taphonomy | TEXT | Uncoded Value | uncategorized | none | none | true |
| Size | TEXT | Uncoded Value | uncategorized | none | none | true |
| ConjSets | TEXT | Uncoded Value | uncategorized | none | none | true |
| PolPho | TEXT | Uncoded Value | uncategorized | none | none | true |
| Notes | TEXT | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: LPHumTeeth
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| LPHumTeethId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Site | TEXT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SpNum | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AnalyticUnit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Box | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| UNIT | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Prov | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| NumFfound | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Art | TEXT | Uncoded Value | uncategorized | none | none | true |
| UpLo | TEXT | Uncoded Value | uncategorized | none | none | true |
| Tooth | TEXT | Uncoded Value | uncategorized | none | none | true |
| Side | TEXT | Uncoded Value | uncategorized | none | none | true |
| Aged/Up | TEXT | Uncoded Value | uncategorized | none | none | true |
| AgeYr | TEXT | Uncoded Value | uncategorized | none | none | true |
| Pathology | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_Commingled_Human_Bone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| b | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| id | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| bone | TEXT | Uncoded Value | uncategorized | none | none | true |
| side | TEXT | Uncoded Value | uncategorized | none | none | true |
| segment | TEXT | Uncoded Value | uncategorized | none | none | true |
| % | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| n | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| age | TEXT | Uncoded Value | uncategorized | none | none | true |
| box | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| level | BIGINT | Uncoded Value | uncategorized | none | none | true |
| locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Ull_rect_comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| other info | TEXT | Uncoded Value | uncategorized | none | none | true |
| slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| end | DOUBLE | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_Cut_Marks_Human_Bone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| CM # | TEXT | Uncoded Value | uncategorized | none | none | true |
| Loc | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cast | TEXT | Uncoded Value | uncategorized | none | none | true |
| Pos | TEXT | Uncoded Value | uncategorized | none | none | true |
| Sort # | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cast # | TEXT | Uncoded Value | uncategorized | none | none | true |
| Length | TEXT | Uncoded Value | uncategorized | none | none | true |
| Width | TEXT | Uncoded Value | uncategorized | none | none | true |
| Depth | TEXT | Uncoded Value | uncategorized | none | none | true |
| Shape | TEXT | Uncoded Value | uncategorized | none | none | true |
| Dir | TEXT | Uncoded Value | uncategorized | none | none | true |
| Comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| Site_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULLId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| other info | TEXT | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Provience | TEXT | Uncoded Value | uncategorized | none | none | true |
| Bone | TEXT | Uncoded Value | uncategorized | none | none | true |
| Field # | TEXT | Uncoded Value | uncategorized | none | none | true |
| Side | TEXT | Uncoded Value | uncategorized | none | none | true |
| CM Total | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_Processed_Human_Bone
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| ps | TEXT | Uncoded Value | uncategorized | none | none | true |
| id | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Site_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| unit | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| level | TEXT | Uncoded Value | uncategorized | none | none | true |
| locus | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| Ull_rect_comments | TEXT | Uncoded Value | uncategorized | none | none | true |
| otherinfo | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| side | TEXT | Uncoded Value | uncategorized | none | none | true |
| frag | TEXT | Uncoded Value | uncategorized | none | none | true |
| bone | TEXT | Uncoded Value | uncategorized | none | none | true |
| age | TEXT | Uncoded Value | uncategorized | none | none | true |
| % | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| peri fract | TEXT | Uncoded Value | uncategorized | none | none | true |
| ivr | TEXT | Uncoded Value | uncategorized | none | none | true |
| sc1 | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| cr | TEXT | Uncoded Value | uncategorized | none | none | true |
| pt | TEXT | Uncoded Value | uncategorized | none | none | true |
| fl | TEXT | Uncoded Value | uncategorized | none | none | true |
| pe | TEXT | Uncoded Value | uncategorized | none | none | true |
| ct | TEXT | Uncoded Value | uncategorized | none | none | true |
| ch | TEXT | Uncoded Value | uncategorized | none | none | true |
| pp | TEXT | Uncoded Value | uncategorized | none | none | true |
| sc2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| gn | TEXT | Uncoded Value | uncategorized | none | none | true |
| cd | TEXT | Uncoded Value | uncategorized | none | none | true |
| b | TEXT | Uncoded Value | uncategorized | none | none | true |
| box | TEXT | Uncoded Value | uncategorized | none | none | true |
| measurement | TEXT | Uncoded Value | uncategorized | none | none | true |
| comments | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: LQ_ULL_VOL_EST
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: LQVolEstsOld
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| U_SHAPE | combo box of acceptable shapes - not based on a table | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| L_SHAPE | TEXT | Uncoded Value | uncategorized | none | none | true |
| U_LENGTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_WIDTH | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| VOL_EST_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ULL | all valid Ulls from La Qemada | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| unit | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| level | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| locus | used to sort/order ulls | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| TOP_BOT_IRREG | is the top shape different from the bottom shape (YES or NO)? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| U_HEIGHT | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| U_BASE | upper shape measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| SIDE_A | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| SIDE_B | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| L_LENGTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_WIDTH | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_HEIGHT | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| L_BASE | lower shape measurement in meters (entry only required if the top and bottom shapes differ). | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| RADIUS | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| AREA | shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc]) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| DEPTH | average depth measurement in meters | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| VOL | measurement in cubic meters (AREA * DEPTH) | |||||
| DOUBLE | Uncoded Value | uncategorized | none | none | true | |
| NOTES | note any unusual steps needed in orde rto make your calculation | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
Table Information: Macrobot
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| SampleId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| SiteId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Site | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Area | to be deleted? | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL | TEXT | Uncoded Value | uncategorized | none | none | true |
| ULL_ID | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Unit | TEXT | Uncoded Value | uncategorized | none | none | true |
| Level | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Locus | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Slash | TEXT | Uncoded Value | uncategorized | none | none | true |
| Fraction | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| FractionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| ID | to be deleted? | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Taxa | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| MbotTaxaId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Portion | to be deleted | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| PortionId | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Count | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Weight | DOUBLE | Uncoded Value | uncategorized | none | none | true |
| Charred | BOOLEAN | Uncoded Value | uncategorized | none | none | true |
| Comment | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: Mbot_Type_Analysis
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Mbot_type_anal_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| speci_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| botanical_type_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
Table Information: MD_Fields
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Field_Id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Field_name | TEXT | Uncoded Value | uncategorized | none | none | true |
| Table_id_fk | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Doc_Object | BLOB | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| MetaData_Desc | TEXT | Uncoded Value | uncategorized | none | none | true |
Table Information: MD_Tables
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Table_id | BIGINT | Uncoded Value | uncategorized | none | none | true |
| Table_Name | TEXT | Uncoded Value | uncategorized | none | none | true |
| Description | TEXT | Uncoded Value | uncategorized | none | none | true |
| MetaData | TEXT | Uncoded Value | uncategorized | none | none | true |
| Doc_object | BLOB | Uncoded Value | uncategorized | none | none | true |
Table Information: NewFlots
| Column Name | Data Type | Type | Category | Coding Sheet | Ontology | Search |
|---|---|---|---|---|---|---|
| Unid 6 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 7 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 3 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 4 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ID | NewFlots unique identifier - data set created by Paula Turkon summer of 2006 | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Site | Site name | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| SiteId | Site ID and FK to sites table | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Area | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULL | Unit-Level-Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| ULLId | Unit-Leve-LLocus ID | |||||
| BIGINT | Uncoded Value | uncategorized | none | none | true | |
| Unit | Unit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Level | Level | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Locus | Locus | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Slash | Slash number or letter | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| 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 | true | |
| AU(old) | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| AU Description(old) | delete | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Wood Charcoal (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Maize cupule-count | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cupule Weight (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Maize kernel-count | TEXT | Uncoded Value | uncategorized | none | none | true |
| Kernel Weight (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Phaseolus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Curcurbita | TEXT | Uncoded Value | uncategorized | none | none | true |
| Opuntia | TEXT | Uncoded Value | uncategorized | none | none | true |
| Opuntia sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Agave Tissue (in grams) | TEXT | Uncoded Value | uncategorized | none | none | true |
| Wild Legume | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium sp 3 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium album | TEXT | Uncoded Value | uncategorized | none | none | true |
| Chenopodium-tiny | TEXT | Uncoded Value | uncategorized | none | none | true |
| Amaranthus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Mammalaria | TEXT | Uncoded Value | uncategorized | none | none | true |
| Cactaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Physalis | TEXT | Uncoded Value | uncategorized | none | none | true |
| Solanaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Euphorbiaceae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Brassica | TEXT | Uncoded Value | uncategorized | none | none | true |
| Portulaca | TEXT | Uncoded Value | uncategorized | none | none | true |
| Compositae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Compositae sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Helianthus | TEXT | Uncoded Value | uncategorized | none | none | true |
| Pinus nut frag | TEXT | Uncoded Value | uncategorized | none | none | true |
| Prosopis | TEXT | Uncoded Value | uncategorized | none | none | true |
| Stellaria | TEXT | Uncoded Value | uncategorized | none | none | true |
| Setaria | TEXT | Uncoded Value | uncategorized | none | none | true |
| Leguminoseae sp 2 | TEXT | Uncoded Value | uncategorized | none | none | true |
| Gramineae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Polygonum | TEXT | Uncoded Value | uncategorized | none | none | true |
| Lychnis | TEXT | Uncoded Value | uncategorized | none | none | true |
| Labiateae | TEXT | Uncoded Value | uncategorized | none | none | true |
| Unid 1 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 2 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 8 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 9 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 10 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 11 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 12 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid13 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 14 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 16 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 17 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 18 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 20 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 21 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 22 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 23 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 24 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 25 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid 26 | Unidentified | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 1 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 2 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 3 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 4 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Fruit 5 | Unidentified fruit | |||||
| TEXT | Uncoded Value | uncategorized | none | none | true | |
| Unid Spines | ||||||