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
Cast TEXT  Uncoded Value uncategorized none none true
CM # TEXT  Uncoded Value uncategorized none none true
Loc 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