tDAR Logo tDAR digital antiquity

Malpaso Database

Part of the Malpaso Valley - La Quemada project

Year: 2008

» Downloads & Basic Metadata

Summary

no description provided


Cite this Record

Malpaso Database. 2008 ( tDAR id: 1266) ; doi:10.6067/XCV87P8X92


Data Set Structure

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

Table Information: _adHoc_element nameLU

Column Name Data Type Type Category Coding Sheet Ontology
element name TEXT  Uncoded Value uncategorized none none
adhoc_element_id BIGINT  Uncoded Value uncategorized none none

Table Information: _ArtCatAnalyticalClasses

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
AnalyticalClass TEXT  Uncoded Value uncategorized none none
AnalyticalClassId BIGINT  Uncoded Value uncategorized none none

Table Information: _ArtCatFunctionalClasses

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
FunctionalClass TEXT  Uncoded Value uncategorized none none
FunctClassId BIGINT  Uncoded Value uncategorized none none

Table Information: _ArtCatManufacturingClasses

Column Name Data Type Type Category Coding Sheet Ontology
GenAnalyticalClass TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
ManufacturingClass TEXT  Uncoded Value uncategorized none none
ManufacturingClassId BIGINT  Uncoded Value uncategorized none none

Table Information: _ArtCatMaterialClasses

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
Material TEXT  Uncoded Value uncategorized none none
MaterialClassId BIGINT  Uncoded Value uncategorized none none

Table Information: _ArtifactCatTypes

Column Name Data Type Type Category Coding Sheet Ontology
Sort order BIGINT  Uncoded Value uncategorized none none
Type TEXT  Uncoded Value uncategorized none none
TypePrefix TEXT  Uncoded Value uncategorized none none
ArtCatTypeId BIGINT  Uncoded Value uncategorized none none

Table Information: _AU_Phase3

Column Name Data Type Type Category Coding Sheet Ontology
Phase_Name phase name
TEXT  Uncoded Value uncategorized none none
Phase3_ID Phase3 unique identifier -
BIGINT  Uncoded Value uncategorized none none

Table Information: _AUCultSpace

Column Name Data Type Type Category Coding Sheet Ontology
SubChapterId Sub-chapter FK
BIGINT  Uncoded Value uncategorized none none
CultSpace Cultural space name
TEXT  Uncoded Value uncategorized none none
CultSpaceId Cultural Space unique identifier
BIGINT  Uncoded Value uncategorized none none

Table Information: _AUGroupLvl1

Column Name Data Type Type Category Coding Sheet Ontology
SiteId Site Fk
BIGINT  Uncoded Value uncategorized none none
GroupLvl1 Group Level1 name
TEXT  Uncoded Value uncategorized none none
GroupLvl1Id Group Level1 unique identifier
BIGINT  Uncoded Value uncategorized none none

Table Information: _AUGroupLvl2

Column Name Data Type Type Category Coding Sheet Ontology
AuAreaId BIGINT  Uncoded Value uncategorized none none
SiteID BIGINT  Uncoded Value uncategorized none none
GroupLvl2 TEXT  Uncoded Value uncategorized none none
GroupLvl2Id BIGINT  Uncoded Value uncategorized none none

Table Information: _AUPhase

Column Name Data Type Type Category Coding Sheet Ontology
Phase TEXT  Uncoded Value uncategorized none none
PhaseId BIGINT  Uncoded Value uncategorized none none

Table Information: _AUPhase2

Column Name Data Type Type Category Coding Sheet Ontology
Phase2 phase2 name
TEXT  Uncoded Value uncategorized none none
Phase2Id Phase2 unique identifier
BIGINT  Uncoded Value uncategorized none none

Table Information: _AUReportArea

Column Name Data Type Type Category Coding Sheet Ontology
SortOrder numeric field for sorting records
BIGINT  Uncoded Value uncategorized none none
ReportArea Report area name
TEXT  Uncoded Value uncategorized none none
SiteID Site identifier and FK to sites lookup table
BIGINT  Uncoded Value uncategorized none none
ReportAreaId Report area unique identifier
BIGINT  Uncoded Value uncategorized none none

Table Information: _Botan_Types

Column Name Data Type Type Category Coding Sheet Ontology
Botan_type TEXT  Uncoded Value uncategorized none none
Botan_type_id BIGINT  Uncoded Value uncategorized none none

Table Information: _Botanical_Types

Column Name Data Type Type Category Coding Sheet Ontology
Botanical_type TEXT  Uncoded Value uncategorized none none
Botanical_type_id BIGINT  Uncoded Value uncategorized none none

Table Information: _BotTaxaPaula

Column Name Data Type Type Category Coding Sheet Ontology
s_Lineage BLOB  Uncoded Value uncategorized none none
s_GUID TEXT  Uncoded Value uncategorized none none
s_Generation BIGINT  Uncoded Value uncategorized none none
s_ColLineage BLOB  Uncoded Value uncategorized none none
name TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: _CarbonSampleConcentration

Column Name Data Type Type Category Coding Sheet Ontology
ConcentrationSp TEXT  Uncoded Value uncategorized none none
Concentration TEXT  Uncoded Value uncategorized none none
ConcentrationId BIGINT  Uncoded Value uncategorized none none

Table Information: _CarbonSampleComposition

Column Name Data Type Type Category Coding Sheet Ontology
CompositionSp TEXT  Uncoded Value uncategorized none none
Composition TEXT  Uncoded Value uncategorized none none
CompositionId BIGINT  Uncoded Value uncategorized none none

Table Information: _CarbonSamplePriority

Column Name Data Type Type Category Coding Sheet Ontology
PrioritySp TEXT  Uncoded Value uncategorized none none
Priority TEXT  Uncoded Value uncategorized none none
PriorityId BIGINT  Uncoded Value uncategorized none none

Table Information: _CarbonSampleSize

Column Name Data Type Type Category Coding Sheet Ontology
SizeSp TEXT  Uncoded Value uncategorized none none
Size TEXT  Uncoded Value uncategorized none none
SampleSizeId BIGINT  Uncoded Value uncategorized none none

Table Information: _Cer_Element_Groups

Column Name Data Type Type Category Coding Sheet Ontology
Element_group TEXT  Uncoded Value uncategorized none none
Element_group_id BIGINT  Uncoded Value uncategorized none none

Table Information: _Cer_Elements

Column Name Data Type Type Category Coding Sheet Ontology
Element_Group BIGINT  Uncoded Value uncategorized none none
Element TEXT  Uncoded Value uncategorized none none
Cer_element_id BIGINT  Uncoded Value uncategorized none none
Desccription TEXT  Uncoded Value uncategorized none none

Table Information: _CerForm

Column Name Data Type Type Category Coding Sheet Ontology
FormCode TEXT  Uncoded Value uncategorized none none
FormName TEXT  Uncoded Value uncategorized none none
OrderId BIGINT  Uncoded Value uncategorized none none
FormId BIGINT  Uncoded Value uncategorized none none

Table Information: _CerPortion

Column Name Data Type Type Category Coding Sheet Ontology
EnGroupPortion TEXT  Uncoded Value uncategorized none none
SpGroupPortion TEXT  Uncoded Value uncategorized none none
PortionCode TEXT  Uncoded Value uncategorized none none
PortionName TEXT  Uncoded Value uncategorized none none
OrderId BIGINT  Uncoded Value uncategorized none none
PortionId BIGINT  Uncoded Value uncategorized none none

Table Information: _CerRprtGrps

Column Name Data Type Type Category Coding Sheet Ontology
ReportGroupOrder BIGINT  Uncoded Value uncategorized none none
ReportGroupsSpanish TEXT  Uncoded Value uncategorized none none
ReportGroups TEXT  Uncoded Value uncategorized none none
ReportGroupId BIGINT  Uncoded Value uncategorized none none

Table Information: _CerTrtmnt

Column Name Data Type Type Category Coding Sheet Ontology
Treatment TEXT  Uncoded Value uncategorized none none
TrtmntId BIGINT  Uncoded Value uncategorized none none

Table Information: _CerType

Column Name Data Type Type Category Coding Sheet Ontology
TrtmntId BIGINT  Uncoded Value uncategorized none none
ReportGroupId BIGINT  Uncoded Value uncategorized none none
TypeLabel TEXT  Uncoded Value uncategorized none none
TypeNameSpanish TEXT  Uncoded Value uncategorized none none
TypeName TEXT  Uncoded Value uncategorized none none
WareId BIGINT  Uncoded Value uncategorized none none
OrderId DOUBLE  Uncoded Value uncategorized none none
TypeId BIGINT  Uncoded Value uncategorized none none

Table Information: _CerType_Old_Bak

Column Name Data Type Type Category Coding Sheet Ontology
s_Lineage left over from synch no longer needed - cant delete
BLOB  Uncoded Value uncategorized none none
s_GUID left over from synch no longer needed - cant delete
TEXT  Uncoded Value uncategorized none none
s_Generation left over from synch no longer needed - cant delete
BIGINT  Uncoded Value uncategorized none none
s_ColLineage left over from synch no longer needed - cant delete
BLOB  Uncoded Value uncategorized none none
type_label TEXT  Uncoded Value uncategorized none none
type_name TEXT  Uncoded Value uncategorized none none
decoration_type TEXT  Uncoded Value uncategorized none none
order_id BIGINT  Uncoded Value uncategorized none none
type_id BIGINT  Uncoded Value uncategorized none none

Table Information: _CerTypeWare

Column Name Data Type Type Category Coding Sheet Ontology
WareNameSpanish TEXT  Uncoded Value uncategorized none none
WareName TEXT  Uncoded Value uncategorized none none
WareId BIGINT  Uncoded Value uncategorized none none

Table Information: _ChapterGroups

Column Name Data Type Type Category Coding Sheet Ontology
AreaId BIGINT  Uncoded Value uncategorized none none
SiteID BIGINT  Uncoded Value uncategorized none none
ChapterGroup TEXT  Uncoded Value uncategorized none none
ChapterGroupId BIGINT  Uncoded Value uncategorized none none

Table Information: _CulturalSpace

Column Name Data Type Type Category Coding Sheet Ontology
SubGroupId BIGINT  Uncoded Value uncategorized none none
CultSpace TEXT  Uncoded Value uncategorized none none
CultSpaceId BIGINT  Uncoded Value uncategorized none none

Table Information: _DebCortex

Column Name Data Type Type Category Coding Sheet Ontology
CortexSpanish TEXT  Uncoded Value uncategorized none none
Cortex TEXT  Uncoded Value uncategorized none none
CotexId BIGINT  Uncoded Value uncategorized none none

Table Information: _DebMaterial

Column Name Data Type Type Category Coding Sheet Ontology
MaterialSpanish TEXT  Uncoded Value uncategorized none none
Material TEXT  Uncoded Value uncategorized none none
MaterialId BIGINT  Uncoded Value uncategorized none none

Table Information: _DebStage

Column Name Data Type Type Category Coding Sheet Ontology
StageSpanish TEXT  Uncoded Value uncategorized none none
Stage TEXT  Uncoded Value uncategorized none none
StageId BIGINT  Uncoded Value uncategorized none none

Table Information: _DebStageIdx

Column Name Data Type Type Category Coding Sheet Ontology
StageIndexSP TEXT  Uncoded Value uncategorized none none
StageIndex TEXT  Uncoded Value uncategorized none none
StageIdxId BIGINT  Uncoded Value uncategorized none none

Table Information: _DebType

Column Name Data Type Type Category Coding Sheet Ontology
TypeSpanish TEXT  Uncoded Value uncategorized none none
Type TEXT  Uncoded Value uncategorized none none
TypeId BIGINT  Uncoded Value uncategorized none none

Table Information: _DebTypeB

Column Name Data Type Type Category Coding Sheet Ontology
Typeb TEXT  Uncoded Value uncategorized none none
TypeBId BIGINT  Uncoded Value uncategorized none none

Table Information: _FieldNotebooks_old

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
FNTPDF TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Year BIGINT  Uncoded Value uncategorized none none
NoteBookNumber BIGINT  Uncoded Value uncategorized none none
NotebookPrefix TEXT  Uncoded Value uncategorized none none
NotebookId BIGINT  Uncoded Value uncategorized none none

Table Information: _FieldNotebooks

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
FNTPDF TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Year BIGINT  Uncoded Value uncategorized none none
NoteBookNumber BIGINT  Uncoded Value uncategorized none none
NotebookPrefix TEXT  Uncoded Value uncategorized none none
NotebookId BIGINT  Uncoded Value uncategorized none none

Table Information: _FigFinish

Column Name Data Type Type Category Coding Sheet Ontology
Finish TEXT  Uncoded Value uncategorized none none
FinishId BIGINT  Uncoded Value uncategorized none none

Table Information: _FigPortion

Column Name Data Type Type Category Coding Sheet Ontology
Portion TEXT  Uncoded Value uncategorized none none
PortionId BIGINT  Uncoded Value uncategorized none none

Table Information: _FigSex

Column Name Data Type Type Category Coding Sheet Ontology
Sex TEXT  Uncoded Value uncategorized none none
SexId BIGINT  Uncoded Value uncategorized none none

Table Information: _FigType

Column Name Data Type Type Category Coding Sheet Ontology
Type TEXT  Uncoded Value uncategorized none none
TypeId BIGINT  Uncoded Value uncategorized none none

Table Information: _FnaBurn

Column Name Data Type Type Category Coding Sheet Ontology
CodeLabelSpanish TEXT  Uncoded Value uncategorized none none
CodeLabel TEXT  Uncoded Value uncategorized none none
BurnCode BIGINT  Uncoded Value uncategorized none none
BurnId BIGINT  Uncoded Value uncategorized none none

Table Information: _FnaElement

Column Name Data Type Type Category Coding Sheet Ontology
CodeLabelSpanish TEXT  Uncoded Value uncategorized none none
CodeLabel TEXT  Uncoded Value uncategorized none none
ElementId BIGINT  Uncoded Value uncategorized none none
UtilindexSpanish TEXT  Uncoded Value uncategorized none none
Utilindex TEXT  Uncoded Value uncategorized none none

Table Information: _FnaFusion

Column Name Data Type Type Category Coding Sheet Ontology
CodeLabelSpanish TEXT  Uncoded Value uncategorized none none
CodeLabel TEXT  Uncoded Value uncategorized none none
Code TEXT  Uncoded Value uncategorized none none
FusionId BIGINT  Uncoded Value uncategorized none none

Table Information: _FnaHumMod

Column Name Data Type Type Category Coding Sheet Ontology
DescriptionSpanish TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
CodeLabelSpanish TEXT  Uncoded Value uncategorized none none
CodeLabe TEXT  Uncoded Value uncategorized none none
HumModCode TEXT  Uncoded Value uncategorized none none
HumModId BIGINT  Uncoded Value uncategorized none none

Table Information: _FnaNatMod

Column Name Data Type Type Category Coding Sheet Ontology
CodeLabelSpanish TEXT  Uncoded Value uncategorized none none
CodeLabel TEXT  Uncoded Value uncategorized none none
Code TEXT  Uncoded Value uncategorized none none
NatModID BIGINT  Uncoded Value uncategorized none none

Table Information: _FnaProxDist

Column Name Data Type Type Category Coding Sheet Ontology
CodeLabelSpanish TEXT  Uncoded Value uncategorized none none
CodeLabel TEXT  Uncoded Value uncategorized none none
Code TEXT  Uncoded Value uncategorized none none
ProxDistId BIGINT  Uncoded Value uncategorized none none

Table Information: _FnaTaxa

Column Name Data Type Type Category Coding Sheet Ontology
DescriptionSpanish TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
CodeLabelSpanish TEXT  Uncoded Value uncategorized none none
CodeLabel TEXT  Uncoded Value uncategorized none none
Taxa TEXT  Uncoded Value uncategorized none none
TaxaId BIGINT  Uncoded Value uncategorized none none

Table Information: _GndstnCond

Column Name Data Type Type Category Coding Sheet Ontology
ConditionSpanish TEXT  Uncoded Value uncategorized none none
Condition TEXT  Uncoded Value uncategorized none none
CondCode TEXT  Uncoded Value uncategorized none none
CondId BIGINT  Uncoded Value uncategorized none none

Table Information: _GndstnMat

Column Name Data Type Type Category Coding Sheet Ontology
RawMaterialSpanish TEXT  Uncoded Value uncategorized none none
RawMaterial TEXT  Uncoded Value uncategorized none none
RawMatCode TEXT  Uncoded Value uncategorized none none
MatId BIGINT  Uncoded Value uncategorized none none

Table Information: _GndstnMTM

Column Name Data Type Type Category Coding Sheet Ontology
ManoTroughMetateSpanish TEXT  Uncoded Value uncategorized none none
ManoTroughMetate TEXT  Uncoded Value uncategorized none none
MTMCode Mano Trough Metate
TEXT  Uncoded Value uncategorized none none
MTMId BIGINT  Uncoded Value uncategorized none none

Table Information: _GndstnWear

Column Name Data Type Type Category Coding Sheet Ontology
WearSpanish TEXT  Uncoded Value uncategorized none none
Wear TEXT  Uncoded Value uncategorized none none
WearCode TEXT  Uncoded Value uncategorized none none
WearId BIGINT  Uncoded Value uncategorized none none

Table Information: _GrndstnCat

Column Name Data Type Type Category Coding Sheet Ontology
CategorySpanish TEXT  Uncoded Value uncategorized none none
Category TEXT  Uncoded Value uncategorized none none
CatCode TEXT  Uncoded Value uncategorized none none
CatId BIGINT  Uncoded Value uncategorized none none

Table Information: _HmOsLvl1Grp

Column Name Data Type Type Category Coding Sheet Ontology
Lvl1Group TEXT  Uncoded Value uncategorized none none
Lvl1GrpId BIGINT  Uncoded Value uncategorized none none

Table Information: _HmOstEleNorm

Column Name Data Type Type Category Coding Sheet Ontology
Element TEXT  Uncoded Value uncategorized none none
ElementId BIGINT  Uncoded Value uncategorized none none

Table Information: _HmOstLvl2Grp

Column Name Data Type Type Category Coding Sheet Ontology
Lvl2Group TEXT  Uncoded Value uncategorized none none
Lvl2GrpId BIGINT  Uncoded Value uncategorized none none

Table Information: _IE_Element_Fill_revised

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
FIll TEXT  Uncoded Value uncategorized none none
ElementFillId BIGINT  Uncoded Value uncategorized none none

Table Information: _IE_Element_Fill

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
FIll TEXT  Uncoded Value uncategorized none none
ElementFillId BIGINT  Uncoded Value uncategorized none none

Table Information: _IE_Elements

Column Name Data Type Type Category Coding Sheet Ontology
cer_element_group_id_fk BIGINT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
HyperlinkedDrawing TEXT  Uncoded Value uncategorized none none
adhocEleType_id BIGINT  Uncoded Value uncategorized none none
ElementTypeId FK to ElementType Lookup table
BIGINT  Uncoded Value uncategorized none none
ElementDescription TEXT  Uncoded Value uncategorized none none
ElementName TEXT  Uncoded Value uncategorized none none
IE_ElementId BIGINT  Uncoded Value uncategorized none none

Table Information: _IE_Elements_revised

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
HyperlinkedDrawing TEXT  Uncoded Value uncategorized none none
ElementGroups TEXT  Uncoded Value uncategorized none none
ElementTypeId FK to ElementType Lookup table
BIGINT  Uncoded Value uncategorized none none
ElementDescription TEXT  Uncoded Value uncategorized none none
ElementName TEXT  Uncoded Value uncategorized none none
IE_ElementId BIGINT  Uncoded Value uncategorized none none

Table Information: _IE_ElementType_revised

Column Name Data Type Type Category Coding Sheet Ontology
ElementTypeId BIGINT  Uncoded Value uncategorized none none
Element Type TEXT  Uncoded Value uncategorized none none

Table Information: _IE_ElementType

Column Name Data Type Type Category Coding Sheet Ontology
Element Type TEXT  Uncoded Value uncategorized none none
ElementTypeId BIGINT  Uncoded Value uncategorized none none

Table Information: _LPGeneralSiteAreas

Column Name Data Type Type Category Coding Sheet Ontology
SiteArea TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: _LPMound1SubAreas

Column Name Data Type Type Category Coding Sheet Ontology
Mound1SubArea TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: _LPPlaza1SubAreas

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
Plaza1SubArea TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: _MbotFrctnId

Column Name Data Type Type Category Coding Sheet Ontology
Fraction TEXT  Uncoded Value uncategorized none none
FractionId BIGINT  Uncoded Value uncategorized none none

Table Information: _MbotPrtn

Column Name Data Type Type Category Coding Sheet Ontology
Portion TEXT  Uncoded Value uncategorized none none
MbotPortId BIGINT  Uncoded Value uncategorized none none

Table Information: _MbotTaxa

Column Name Data Type Type Category Coding Sheet Ontology
Taxa TEXT  Uncoded Value uncategorized none none
TaxaId BIGINT  Uncoded Value uncategorized none none

Table Information: _RimContourType

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
Hyperlink example TEXT  Uncoded Value uncategorized none none
Contour type TEXT  Uncoded Value uncategorized none none
contour_id BIGINT  Uncoded Value uncategorized none none

Table Information: _RimLipForm

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
Hyperlink example TEXT  Uncoded Value uncategorized none none
Lip form TEXT  Uncoded Value uncategorized none none
lip_id BIGINT  Uncoded Value uncategorized none none

Table Information: _RimLipTreatment

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
Hyperlink example TEXT  Uncoded Value uncategorized none none
Lip treatment TEXT  Uncoded Value uncategorized none none
lip_treat_id BIGINT  Uncoded Value uncategorized none none

Table Information: _RimRimForm

Column Name Data Type Type Category Coding Sheet Ontology
Description TEXT  Uncoded Value uncategorized none none
Hyperlink example TEXT  Uncoded Value uncategorized none none
Rim form TEXT  Uncoded Value uncategorized none none
rim_form_id BIGINT  Uncoded Value uncategorized none none

Table Information: _RimVsslShp

Column Name Data Type Type Category Coding Sheet Ontology
bowl_jar2 only definitives classified
TEXT  Uncoded Value uncategorized none none
bowl_jar1 all vessel shapes classified
TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
Hyperlink example TEXT  Uncoded Value uncategorized none none
Shape TEXT  Uncoded Value uncategorized none none
shape_id BIGINT  Uncoded Value uncategorized none none

Table Information: _RSContourType

Column Name Data Type Type Category Coding Sheet Ontology
example BLOB  Uncoded Value uncategorized none none
ContourType TEXT  Uncoded Value uncategorized none none

Table Information: _RSDecoration

Column Name Data Type Type Category Coding Sheet Ontology
Decoration TEXT  Uncoded Value uncategorized none none

Table Information: _RSLipForm

Column Name Data Type Type Category Coding Sheet Ontology
LipForm TEXT  Uncoded Value uncategorized none none

Table Information: _RSLipTreatment

Column Name Data Type Type Category Coding Sheet Ontology
LipTreatment TEXT  Uncoded Value uncategorized none none

Table Information: _RSRimForm

Column Name Data Type Type Category Coding Sheet Ontology
RimForm TEXT  Uncoded Value uncategorized none none

Table Information: _RSSlipConsistency

Column Name Data Type Type Category Coding Sheet Ontology
SlipConsistency TEXT  Uncoded Value uncategorized none none

Table Information: _RSVesselShape_DELETE

Column Name Data Type Type Category Coding Sheet Ontology
VesselShape TEXT  Uncoded Value uncategorized none none

Table Information: _RSWare_DELETE

Column Name Data Type Type Category Coding Sheet Ontology
Ware TEXT  Uncoded Value uncategorized none none

Table Information: _ShellClass

Column Name Data Type Type Category Coding Sheet Ontology
Class TEXT  Uncoded Value uncategorized none none
ClassId BIGINT  Uncoded Value uncategorized none none

Table Information: _ShellGenera

Column Name Data Type Type Category Coding Sheet Ontology
Genera TEXT  Uncoded Value uncategorized none none
GeneraId BIGINT  Uncoded Value uncategorized none none

Table Information: _Sites

Column Name Data Type Type Category Coding Sheet Ontology
SttlmntAffltn TEXT  Uncoded Value uncategorized none none
SiteName TEXT  Uncoded Value uncategorized none none
SiteCode TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none

Table Information: _SpecArtClass

Column Name Data Type Type Category Coding Sheet Ontology
FunctionalClassSpanish TEXT  Uncoded Value uncategorized none none
FunctionalClass TEXT  Uncoded Value uncategorized none none
ClassId BIGINT  Uncoded Value uncategorized none none

Table Information: _SpecArtDec

Column Name Data Type Type Category Coding Sheet Ontology
DecTechSpanish TEXT  Uncoded Value uncategorized none none
DecTech TEXT  Uncoded Value uncategorized none none
DecTechId BIGINT  Uncoded Value uncategorized none none

Table Information: _SpecArtMat

Column Name Data Type Type Category Coding Sheet Ontology
Material TEXT  Uncoded Value uncategorized none none
SpecArtMatId BIGINT  Uncoded Value uncategorized none none

Table Information: _STMatGrpId

Column Name Data Type Type Category Coding Sheet Ontology
MaterailGroupSpanish TEXT  Uncoded Value uncategorized none none
MaterialGroup TEXT  Uncoded Value uncategorized none none
MatGroupId BIGINT  Uncoded Value uncategorized none none

Table Information: _STType

Column Name Data Type Type Category Coding Sheet Ontology
ToolTypeSpanish TEXT  Uncoded Value uncategorized none none
ToolType TEXT  Uncoded Value uncategorized none none
TypeId BIGINT  Uncoded Value uncategorized none none

Table Information: _SubGroups

Column Name Data Type Type Category Coding Sheet Ontology
ChapterGroupId BIGINT  Uncoded Value uncategorized none none
SubGroupName TEXT  Uncoded Value uncategorized none none
SubGroupId BIGINT  Uncoded Value uncategorized none none

Table Information: _TableGroups

Column Name Data Type Type Category Coding Sheet Ontology
SortOrder DOUBLE  Uncoded Value uncategorized none none
SiteID BIGINT  Uncoded Value uncategorized none none
TableGroupNamesSpanish TEXT  Uncoded Value uncategorized none none
TableGroupName TEXT  Uncoded Value uncategorized none none
TableGroupId BIGINT  Uncoded Value uncategorized none none

Table Information: _TypeCllctnFunctClass

Column Name Data Type Type Category Coding Sheet Ontology
FunctClassId BIGINT  Uncoded Value uncategorized none none
TypeCllctnId BIGINT  Uncoded Value uncategorized none none
FunctionalClassId BIGINT  Uncoded Value uncategorized none none

Table Information: _UnitYear

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
PageNumbers TEXT  Uncoded Value uncategorized none none
PDFURL TEXT  Uncoded Value uncategorized none none
NotebookId BIGINT  Uncoded Value uncategorized none none
YearExcavated BIGINT  Uncoded Value uncategorized none none
UnitId BIGINT  Uncoded Value uncategorized none none
UnitYearId BIGINT  Uncoded Value uncategorized none none

Table Information: _UnitYear_old

Column Name Data Type Type Category Coding Sheet Ontology
PDFURL TEXT  Uncoded Value uncategorized none none
NotebookId BIGINT  Uncoded Value uncategorized none none
YearExcavated BIGINT  Uncoded Value uncategorized none none
UnitId BIGINT  Uncoded Value uncategorized none none
UnitYearId BIGINT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
PageNumbers TEXT  Uncoded Value uncategorized none none

Table Information: _WoodTaxa

Column Name Data Type Type Category Coding Sheet Ontology
TaxaSpanish TEXT  Uncoded Value uncategorized none none
Taxa TEXT  Uncoded Value uncategorized none none
WoodtaxaId BIGINT  Uncoded Value uncategorized none none

Table Information: Area_labels_lookup

Column Name Data Type Type Category Coding Sheet Ontology
Area_label TEXT  Uncoded Value uncategorized none none
Area_name TEXT  Uncoded Value uncategorized none none

Table Information: ArtCatAnalyticalClasses

Column Name Data Type Type Category Coding Sheet Ontology
AnalyticalClassId BIGINT  Uncoded Value uncategorized none none
CatId BIGINT  Uncoded Value uncategorized none none

Table Information: ArtCatFunctionalClasses

Column Name Data Type Type Category Coding Sheet Ontology
Priority TEXT  Uncoded Value uncategorized none none
FunctionalClassId BIGINT  Uncoded Value uncategorized none none
CatId BIGINT  Uncoded Value uncategorized none none

Table Information: ArtCatVesselAnalysis

Column Name Data Type Type Category Coding Sheet Ontology
VesselShapeId BIGINT  Uncoded Value uncategorized none none
TypeId BIGINT  Uncoded Value uncategorized none none
WareId BIGINT  Uncoded Value uncategorized none none
CatId BIGINT  Uncoded Value uncategorized none none

Table Information: ArtifactCat_Bags

Column Name Data Type Type Category Coding Sheet Ontology
SummaryDescription The inventory summary for the Artifact Catalog
TEXT  Uncoded Value uncategorized none none
BoxId BIGINT  Uncoded Value uncategorized none none
BagName TEXT  Uncoded Value uncategorized none none
BagId BIGINT  Uncoded Value uncategorized none none

Table Information: ArtifactCat_BoxInventory

Column Name Data Type Type Category Coding Sheet Ontology
SortOrder BIGINT  Uncoded Value uncategorized none none
Cataloged BOOLEAN  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
BoxNo TEXT  Uncoded Value uncategorized none none
BoxId BIGINT  Uncoded Value uncategorized none none

Table Information: ArtifactCatalog

Column Name Data Type Type Category Coding Sheet Ontology
MaterialClassId BIGINT  Uncoded Value uncategorized none none
AnalyticalClassId BIGINT  Uncoded Value uncategorized none none
ManufacturingClassId BIGINT  Uncoded Value uncategorized none none
FunctionalClassId BIGINT  Uncoded Value uncategorized none none
VesselShapeId BIGINT  Uncoded Value uncategorized none none
TypeId BIGINT  Uncoded Value uncategorized none none
WareId BIGINT  Uncoded Value uncategorized none none
INAHBoxNum TEXT  Uncoded Value uncategorized none none
INAHCatNum TEXT  Uncoded Value uncategorized none none
2007comments TEXT  Uncoded Value uncategorized none none
form TEXT  Uncoded Value uncategorized none none
type TEXT  Uncoded Value uncategorized none none
ware TEXT  Uncoded Value uncategorized none none
BulkSheetDescription 250 word limit
TEXT  Uncoded Value uncategorized none none
Slash # TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
MaterialId BIGINT  Uncoded Value uncategorized none none
ArtifactCatType BIGINT  Uncoded Value uncategorized none none
YearExcavated TEXT  Uncoded Value uncategorized none none
SummarySheet Is this item in the general catalog summary for its respective box?
BOOLEAN  Uncoded Value uncategorized none none
DetailSheet Does this item require a Detail catalog sheet?
BOOLEAN  Uncoded Value uncategorized none none
CatalogName TEXT  Uncoded Value uncategorized none none
DetailSheetDescription 250 word limit
TEXT  Uncoded Value uncategorized none none
Other Description TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
count BIGINT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
Other Prov TEXT  Uncoded Value uncategorized none none
BagId The bag number is unique and assigned to a unique box number in the ArtifactCat_Bags table - the bag and box number must already exist before this id can be assigned
BIGINT  Uncoded Value uncategorized none none
Item BIGINT  Uncoded Value uncategorized none none
CatId BIGINT  Uncoded Value uncategorized none none

Table Information: AUs

Column Name Data Type Type Category Coding Sheet Ontology
ChapterId AUs grouped by the chapters of the informe final (each midden included - even though there is one chapter for all the middens)
BIGINT  Uncoded Value uncategorized none none
ReportAreaId AUs grouped by the areas discussed in the Informe Final - FK to _ReportArea table
BIGINT  Uncoded Value uncategorized none none
Comments General comments about the AU
TEXT  Uncoded Value uncategorized none none
CeremonialStatus Is the context ceremonial or non-ceremonial - constructed from Jaime H's groundstone analysis
TEXT  Uncoded Value uncategorized none none
CultSpaceId AUs grouped by somewhat useful cultural spaces such as room # and the like may need additional work for consistency - FK _CultSpace table
BIGINT  Uncoded Value uncategorized none none
GroupLvl2Id Useful AU grouping by cultural spaces - needs additional work to be fully consistent and should be moved to separate table - FK to _GroupLvl2 table
BIGINT  Uncoded Value uncategorized none none
GroupLvl1Id Useful AU grouping by cultural spaces - needs additional work to be fully consistent and should be moved to separate table - FK to _GroupLvl1 table
BIGINT  Uncoded Value uncategorized none none
MiddenPhasewithDetail Used to help further break down phase information by the nature of the context (eg PO, Late, etc.)
TEXT  Uncoded Value uncategorized none none
MiddenPhases Midden phases and architectural phases are independent of one another. This field applies only to relative strata position within each midden
TEXT  Uncoded Value uncategorized none none
DepNotes Notes about the depositional contexts
TEXT  Uncoded Value uncategorized none none
Phase3Id AUs grouped by phases with midden trash included with early contexts - only includes early terrace contexts and late Fill above floor and no PO
BIGINT  Uncoded Value uncategorized none none
Phase2Id AUs grouped by inferred phases and deposit type (eg Early, Late, Post-occupational fill, Fill above floor etc). Needs work to be more consistent - FK to _AU Phase2 table
BIGINT  Uncoded Value uncategorized none none
TableGroupId FK to TableGroup TableGroupId - Initially built to accomodate the organization of artifact counts in the final report tables
BIGINT  Uncoded Value uncategorized none none
MidNonmid FK to MidNonmid MidNonmidId - can be used to determine if the AU is from a Midden or Non-Midden context
BIGINT  Uncoded Value uncategorized none none
Midden AUs related to trash or midden deposits
BOOLEAN  Uncoded Value uncategorized none none
Hearth AUs related to hearths
BOOLEAN  Uncoded Value uncategorized none none
FF AUs that include pure fill immediately above floors
BOOLEAN  Uncoded Value uncategorized none none
FloorDeposits All AUs that include floor matrices, and firmes, and fill immediate above floors (ca 10 cm) - doesn't include AUs with other kinds of fill
BOOLEAN  Uncoded Value uncategorized none none
BoneConc AUs related to Bone Concentrations
BOOLEAN  Uncoded Value uncategorized none none
SurfHum AUs that contain surface and humus deposits
BOOLEAN  Uncoded Value uncategorized none none
Mixed AUs for which the provenience is not known in more detail than the unit
BOOLEAN  Uncoded Value uncategorized none none
TerraceFill AUs related to terrace fill
BOOLEAN  Uncoded Value uncategorized none none
SPFullDesc Spanish translation of FullDesc
TEXT  Uncoded Value uncategorized none none
FullDesc No abbreviations - Fully written out description of the AU
TEXT  Uncoded Value uncategorized none none
ShortDesc Contains some abbreviations
TEXT  Uncoded Value uncategorized none none
BriefDesc Abbreviated brief description of the AU
TEXT  Uncoded Value uncategorized none none
new num temp field used for renumbering aus on the fly
BIGINT  Uncoded Value uncategorized none none
SortNumber Nymber used to perform numeric sorts on the text field AUNum
BIGINT  Uncoded Value uncategorized none none
AUNum Official Analytical Unit Number as appears in final report
DOUBLE  Uncoded Value uncategorized none none
SiteId FK to SITE_ID in _SITE table - the Site ID is also avalaible in the ULL table - Field is provided only as a convenience for manipulating this table directly
BIGINT  Uncoded Value uncategorized none none
AUId PK identifier
BIGINT  Uncoded Value uncategorized none none
PhaseId AUs gouped by inferred phases (Early, Late, Terrace FIll, N/A) FK to _TableGroup table
BIGINT  Uncoded Value uncategorized none none

Table Information: BoxInv

Column Name Data Type Type Category Coding Sheet Ontology
Comments Comments
TEXT  Uncoded Value uncategorized none none
Bag count Bag Count
BIGINT  Uncoded Value uncategorized none none
Recorder Recorder
TEXT  Uncoded Value uncategorized none none
Vertical Vertical
TEXT  Uncoded Value uncategorized none none
Horizontal Horizontal
TEXT  Uncoded Value uncategorized none none
Locus Locus
TEXT  Uncoded Value uncategorized none none
Locality Locality
TEXT  Uncoded Value uncategorized none none
Year Year
TEXT  Uncoded Value uncategorized none none
Size Size
TEXT  Uncoded Value uncategorized none none
Material Material
TEXT  Uncoded Value uncategorized none none
Bag number Bag Number
TEXT  Uncoded Value uncategorized none none
Box number Box Number
TEXT  Uncoded Value uncategorized none none
Site What site does the material come from
TEXT  Uncoded Value uncategorized none none
Collection Which artifact collection does the box hold
TEXT  Uncoded Value uncategorized none none
ID unique box indentifier
BIGINT  Uncoded Value uncategorized none none

Table Information: CADLabels

Column Name Data Type Type Category Coding Sheet Ontology
SpanishLabels Spanish label text
TEXT  Uncoded Value uncategorized none none
EnglishLabels English label text
TEXT  Uncoded Value uncategorized none none
FileName AutoCad file to which the label belongs
TEXT  Uncoded Value uncategorized none none
ID Unique label identifier
BIGINT  Uncoded Value uncategorized none none

Table Information: CarbonSamples

Column Name Data Type Type Category Coding Sheet Ontology
DateId Has value if the sample was dated - this is the FK link to the Dates table
BIGINT  Uncoded Value uncategorized none none
Comments Comments
TEXT  Uncoded Value uncategorized none none
Soil Nature of the soil matrix within which the sample was found
TEXT  Uncoded Value uncategorized none none
PriorityNotes Comments in the field note regarding the importance and datability of the sample
TEXT  Uncoded Value uncategorized none none
PriorityId Priority FK to lookup table
BIGINT  Uncoded Value uncategorized none none
Priority Scale of 1 to 10 (1 being highest) of the excavator's opinion on whether the sample should be sent to C14 lab for dating
TEXT  Uncoded Value uncategorized none none
Contamination Potential sources of sample contamination
TEXT  Uncoded Value uncategorized none none
ConcNotes Comments in the field notes regarding the nature of the sample's concentration
TEXT  Uncoded Value uncategorized none none
ConcentrationId Concentration Fk to lookup
BIGINT  Uncoded Value uncategorized none none
Concentration Category referring to the degree of dispersion or concentration of the sample
TEXT  Uncoded Value uncategorized none none
Associations Comments from the field notes regarding other artifact or feature associations with the sample
TEXT  Uncoded Value uncategorized none none
CompNotes Comments from the field notees regarding the sample's composition
TEXT  Uncoded Value uncategorized none none
CompositionId Composition identifier and FK
BIGINT  Uncoded Value uncategorized none none
Composition Composition - not a necessary field - was used for checking accuracy of the CompositionID
TEXT  Uncoded Value uncategorized none none
SizeNotes Comments from the field notes regarding sample size
TEXT  Uncoded Value uncategorized none none
DateExcavated Date sample was excavated
TEXT  Uncoded Value uncategorized none none
PointLocation Point provenience information
TEXT  Uncoded Value uncategorized none none
ULLId Unit-Level-Locus identifier and FK
BIGINT  Uncoded Value uncategorized none none
ULL Unit-Level-Locus - not a necessary field - was for checking accuracy of ULLID
TEXT  Uncoded Value uncategorized none none
Slash Slash number or letter
TEXT  Uncoded Value uncategorized none none
Locus Locus
TEXT  Uncoded Value uncategorized none none
Level Level
TEXT  Uncoded Value uncategorized none none
Unit Unit
TEXT  Uncoded Value uncategorized none none
SiteId Site ID FK
BIGINT  Uncoded Value uncategorized none none
CarbonSampleId Unique carbon sample identifier
BIGINT  Uncoded Value uncategorized none none
SampleSizeId Sample Size identifier and FK
BIGINT  Uncoded Value uncategorized none none
SampleSize Sample Size - not a necessary field - used to check accuracy of the SampleSizeID field
TEXT  Uncoded Value uncategorized none none

Table Information: Ceramics

Column Name Data Type Type Category Coding Sheet Ontology
TypeOld TEXT  Uncoded Value uncategorized none none
Comments General comments
TEXT  Uncoded Value uncategorized none none
Sorter Name of ceramic sorter
TEXT  Uncoded Value uncategorized none none
Count Artifact count
BIGINT  Uncoded Value uncategorized none none
PortionId Portion Designation - FK to _CerPortionId
BIGINT  Uncoded Value uncategorized none none
FormCnfdnc C - Confident, U - Unconfident
TEXT  Uncoded Value uncategorized none none
FormId Form Designation - FK to _CerForm table
BIGINT  Uncoded Value uncategorized none none
TypeCnfdnc C - Confident, U - Unconfident
TEXT  Uncoded Value uncategorized none none
TypeId Type designation - FK to _CerType table
BIGINT  Uncoded Value uncategorized none none
Slash Slash number or letter
TEXT  Uncoded Value uncategorized none none
Locus Locus Designation
TEXT  Uncoded Value uncategorized none none
Level Level designation
TEXT  Uncoded Value uncategorized none none
Unit Unit designation
TEXT  Uncoded Value uncategorized none none
ULLId ULL identification number creating link to ULL tabl - FK to ULL table (displays the ULL, but underlying value is the ULLId value)
BIGINT  Uncoded Value uncategorized none none
CerId Ceramic idenitification Number
BIGINT  Uncoded Value uncategorized none none
ULL Redundant data left for purposes of crosschecking for reassigned ULLs - do not delet yet
TEXT  Uncoded Value uncategorized none none
SiteId Site at which specimens derived - FK to _Site table
BIGINT  Uncoded Value uncategorized none none
Year Year specimens were excavated
TEXT  Uncoded Value uncategorized none none
Collection LQ-MVAP - from our excavations, Armillas - from the Armillas collection
TEXT  Uncoded Value uncategorized none none

Table Information: Ceramics_old_del

Column Name Data Type Type Category Coding Sheet Ontology
TypeOld TEXT  Uncoded Value uncategorized none none
Comments General comments
TEXT  Uncoded Value uncategorized none none
Sorter Name of ceramic sorter
TEXT  Uncoded Value uncategorized none none
Count Artifact count
BIGINT  Uncoded Value uncategorized none none
PortionId Portion Designation - FK to _CerPortionId
BIGINT  Uncoded Value uncategorized none none
FormCnfdnc C - Confident, U - Unconfident
TEXT  Uncoded Value uncategorized none none
FormId Form Designation - FK to _CerForm table
BIGINT  Uncoded Value uncategorized none none
TypeCnfdnc C - Confident, U - Unconfident
TEXT  Uncoded Value uncategorized none none
TypeId Type designation - FK to _CerType table
BIGINT  Uncoded Value uncategorized none none
Slash Slash number or letter
TEXT  Uncoded Value uncategorized none none
Locus Locus Designation
TEXT  Uncoded Value uncategorized none none
Level Level designation
TEXT  Uncoded Value uncategorized none none
Unit Unit designation
TEXT  Uncoded Value uncategorized none none
ULLId ULL identification number creating link to ULL tabl - FK to ULL table (displays the ULL, but underlying value is the ULLId value)
BIGINT  Uncoded Value uncategorized none none
ULL Redundant data left for purposes of crosschecking for reassigned ULLs - do not delet yet
TEXT  Uncoded Value uncategorized none none
SiteId Site at which specimens derived - FK to _Site table
BIGINT  Uncoded Value uncategorized none none
Collection LQ-MVAP - from our excavations, Armillas - from the Armillas collection
TEXT  Uncoded Value uncategorized none none
Year Year specimens were excavated
TEXT  Uncoded Value uncategorized none none
CerId Ceramic idenitification Number
BIGINT  Uncoded Value uncategorized none none

Table Information: Dates

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
Reference TEXT  Uncoded Value uncategorized none none
OxCal2sig TEXT  Uncoded Value uncategorized none none
OxCal1sig TEXT  Uncoded Value uncategorized none none
Cal2sig TEXT  Uncoded Value uncategorized none none
ConC14 TEXT  Uncoded Value uncategorized none none
13C/12C TEXT  Uncoded Value uncategorized none none
StanDevMeas BIGINT  Uncoded Value uncategorized none none
MeasC14 BIGINT  Uncoded Value uncategorized none none
StratPos TEXT  Uncoded Value uncategorized none none
Material TEXT  Uncoded Value uncategorized none none
ExcArea TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus TEXT  Uncoded Value uncategorized none none
Level TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Submitted TEXT  Uncoded Value uncategorized none none
DateType TEXT  Uncoded Value uncategorized none none
RadiocarbonFormId BIGINT  Uncoded Value uncategorized none none
DateId BIGINT  Uncoded Value uncategorized none none
LabId TEXT  Uncoded Value uncategorized none none
Lab TEXT  Uncoded Value uncategorized none none
Cal1sig TEXT  Uncoded Value uncategorized none none
IntCal TEXT  Uncoded Value uncategorized none none
StanDevCon TEXT  Uncoded Value uncategorized none none

Table Information: DatesListLQ(old)_del

Column Name Data Type Type Category Coding Sheet Ontology
calibrated results (2 sigma, 95% prob) TEXT  Uncoded Value uncategorized none none
+/-* BIGINT  Uncoded Value uncategorized none none
conventional C14 age BIGINT  Uncoded Value uncategorized none none
C13/C12 ratio TEXT  Uncoded Value uncategorized none none
+/- BIGINT  Uncoded Value uncategorized none none
measured C14 age BIGINT  Uncoded Value uncategorized none none
slash TEXT  Uncoded Value uncategorized none none
locus TEXT  Uncoded Value uncategorized none none
level BIGINT  Uncoded Value uncategorized none none
unit BIGINT  Uncoded Value uncategorized none none
site TEXT  Uncoded Value uncategorized none none
beta sample # TEXT  Uncoded Value uncategorized none none
id BIGINT  Uncoded Value uncategorized none none

Table Information: Debitage

Column Name Data Type Type Category Coding Sheet Ontology
Comment General comments
TEXT  Uncoded Value uncategorized none none
Count Specimen count by row
BIGINT  Uncoded Value uncategorized none none
Tool ???
TEXT  Uncoded Value uncategorized none none
MatId Raw material of specimen - FK to _DebMaterial table
BIGINT  Uncoded Value uncategorized none none
CortexId Presence or absence of cortex - FK to _DebCortex table
BIGINT  Uncoded Value uncategorized none none
StageId Reduction stage - FK to _DebStage table
BIGINT  Uncoded Value uncategorized none none
StageIndexId Reduction stage index - FK to _DebStageIndex Table
BIGINT  Uncoded Value uncategorized none none
TypeBId Flake TypeB - FK to _DebTypeB table
BIGINT  Uncoded Value uncategorized none none
TypeId Flake Type - FK to _DebType table
BIGINT  Uncoded Value uncategorized none none
Slash Slash number or letter of the specimen
TEXT  Uncoded Value uncategorized none none
ULLId Unit Level Locus Id - FK to ULL table
BIGINT  Uncoded Value uncategorized none none
ULL Unit-Level-Locus
TEXT  Uncoded Value uncategorized none none
SiteId Site from which the samples derive - FK _Sites table
BIGINT  Uncoded Value uncategorized none none
Site to be deleted
TEXT  Uncoded Value uncategorized none none
DebId Debitage identification number
BIGINT  Uncoded Value uncategorized none none

Table Information: elements

Column Name Data Type Type Category Coding Sheet Ontology
Type TEXT  Uncoded Value uncategorized none none
Count BIGINT  Uncoded Value uncategorized none none
Element_group TEXT  Uncoded Value uncategorized none none
ReportArea TEXT  Uncoded Value uncategorized none none
Phase_Name TEXT  Uncoded Value uncategorized none none
ReportAreaId BIGINT  Uncoded Value uncategorized none none
SiteCode TEXT  Uncoded Value uncategorized none none

Table Information: elements3_delete

Column Name Data Type Type Category Coding Sheet Ontology
type TEXT  Uncoded Value uncategorized none none
count BIGINT  Uncoded Value uncategorized none none
Element_group TEXT  Uncoded Value uncategorized none none
ReportArea TEXT  Uncoded Value uncategorized none none
Phase_Name TEXT  Uncoded Value uncategorized none none
ReportAreaId BIGINT  Uncoded Value uncategorized none none
SiteCode TEXT  Uncoded Value uncategorized none none

Table Information: EP_ULL_VOL_EST_del

Column Name Data Type Type Category Coding Sheet Ontology
NOTES note any unusual steps needed in orde rto make your calculation
TEXT  Uncoded Value uncategorized none none
VOL measurement in cubic meters (AREA * DEPTH)
DOUBLE  Uncoded Value uncategorized none none
DEPTH average depth measurement in meters
DOUBLE  Uncoded Value uncategorized none none
AREA shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc])
DOUBLE  Uncoded Value uncategorized none none
RADIUS DOUBLE  Uncoded Value uncategorized none none
L_BASE lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_HEIGHT lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_WIDTH lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_LENGTH lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
SIDE_B DOUBLE  Uncoded Value uncategorized none none
SIDE_A DOUBLE  Uncoded Value uncategorized none none
U_BASE upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_HEIGHT upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_WIDTH upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_LENGTH upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
L_SHAPE TEXT  Uncoded Value uncategorized none none
U_SHAPE combo box of acceptable shapes - not based on a table
TEXT  Uncoded Value uncategorized none none
TOP_BOT_IRREG is the top shape different from the bottom shape (YES or NO)?
TEXT  Uncoded Value uncategorized none none
locus used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
level used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
unit used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
ULL all valid Ulls from La Qemada
TEXT  Uncoded Value uncategorized none none
VOL_EST_ID BIGINT  Uncoded Value uncategorized none none

Table Information: ExcvtdUnits_del

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
Location TEXT  Uncoded Value uncategorized none none
UnitNum TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
UnitId BIGINT  Uncoded Value uncategorized none none

Table Information: Fauna

Column Name Data Type Type Category Coding Sheet Ontology
TypeSpecimen Is the specimen useful for comparison or as a type? - see Rebekah Parks for details
TEXT  Uncoded Value uncategorized none none
Count Count of items in row
TEXT  Uncoded Value uncategorized none none
NatModId FK to the NatModId column of the _FnaNatMod table
BIGINT  Uncoded Value uncategorized none none
HumModDesc to be deleted
TEXT  Uncoded Value uncategorized none none
HumModId FK to the HumModId column of the _FnaHumMod table
BIGINT  Uncoded Value uncategorized none none
BurnDesc to be deleted
TEXT  Uncoded Value uncategorized none none
BurnId FK to the BurnId column of the _FnaBurn table
BIGINT  Uncoded Value uncategorized none none
FusionId FK to the FusionId column of the _FnaFusion table
BIGINT  Uncoded Value uncategorized none none
Fusion to be delted
TEXT  Uncoded Value uncategorized none none
ProxDistId FK to the ProxDistId column of the _FnaProxDist table
BIGINT  Uncoded Value uncategorized none none
ProxDist to be delted
TEXT  Uncoded Value uncategorized none none
ElementId FK to ElementId column of the _FnaElement table
BIGINT  Uncoded Value uncategorized none none
TaxaDesc to be deleted
TEXT  Uncoded Value uncategorized none none
TaxaId FK to the TaxaId column of the _FnaTaxa table
BIGINT  Uncoded Value uncategorized none none
Taxa to be deleted
TEXT  Uncoded Value uncategorized none none
Slash Slash number or letter
TEXT  Uncoded Value uncategorized none none
Locus Locus designation
TEXT  Uncoded Value uncategorized none none
Level Level designation
TEXT  Uncoded Value uncategorized none none
Unit Unit designation
TEXT  Uncoded Value uncategorized none none
SecondaryAU to be deleted?
TEXT  Uncoded Value uncategorized none none
Comments General comments
TEXT  Uncoded Value uncategorized none none
Sorter Person who sorted, coded and counted the information
TEXT  Uncoded Value uncategorized none none
AU to be deleted?
TEXT  Uncoded Value uncategorized none none
ULLId FK to ULLId of the ULL table
BIGINT  Uncoded Value uncategorized none none
ULL Unit Level Locus - to be deleted eventually
TEXT  Uncoded Value uncategorized none none
SiteId FK to SitesId column of the _Sites table
BIGINT  Uncoded Value uncategorized none none
Site to be deleted
TEXT  Uncoded Value uncategorized none none
Bag Specimens were pulled from a Bag with this identifier
TEXT  Uncoded Value uncategorized none none
ID Identification number
BIGINT  Uncoded Value uncategorized none none

Table Information: Fauna_Old_Bak_del

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
Count TEXT  Uncoded Value uncategorized none none
Nat_mod TEXT  Uncoded Value uncategorized none none
hum_mod desc TEXT  Uncoded Value uncategorized none none
Hum_mod TEXT  Uncoded Value uncategorized none none
burn desc TEXT  Uncoded Value uncategorized none none
Burn BIGINT  Uncoded Value uncategorized none none
Fusion TEXT  Uncoded Value uncategorized none none
Prox-dist TEXT  Uncoded Value uncategorized none none
Element TEXT  Uncoded Value uncategorized none none
taxa desc TEXT  Uncoded Value uncategorized none none
Taxa TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus TEXT  Uncoded Value uncategorized none none
Level TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
Secondary AU TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
Bag TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none
AU TEXT  Uncoded Value uncategorized none none

Table Information: Figurines before removal of 4 items_del

Column Name Data Type Type Category Coding Sheet Ontology
KimsComments TEXT  Uncoded Value uncategorized none none
Count TEXT  Uncoded Value uncategorized none none
Other_com TEXT  Uncoded Value uncategorized none none
Com10 TEXT  Uncoded Value uncategorized none none
Com9 TEXT  Uncoded Value uncategorized none none
Com 8 TEXT  Uncoded Value uncategorized none none
Com7 TEXT  Uncoded Value uncategorized none none
PaintId BIGINT  Uncoded Value uncategorized none none
Paint TEXT  Uncoded Value uncategorized none none
SexId BIGINT  Uncoded Value uncategorized none none
Sex TEXT  Uncoded Value uncategorized none none
FullDesc TEXT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
PortionId BIGINT  Uncoded Value uncategorized none none
Part TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
ULL_Id BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
Old_Type_Id Kim Goldstein's original type - no longer used
BIGINT  Uncoded Value uncategorized none none
LQ_Type New Types based on Jaime H's classification of 2006
TEXT  Uncoded Value uncategorized none none
Williams_Type TEXT  Uncoded Value uncategorized none none
F_numb DOUBLE  Uncoded Value uncategorized none none
Prim_id TEXT  Uncoded Value uncategorized none none
Com2 TEXT  Uncoded Value uncategorized none none
Com1 TEXT  Uncoded Value uncategorized none none
FinishId BIGINT  Uncoded Value uncategorized none none
Finish TEXT  Uncoded Value uncategorized none none
Com6 TEXT  Uncoded Value uncategorized none none
Com5 TEXT  Uncoded Value uncategorized none none
Com4 TEXT  Uncoded Value uncategorized none none
Com3 TEXT  Uncoded Value uncategorized none none
Site_Id BIGINT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
Figurine_Id BIGINT  Uncoded Value uncategorized none none

Table Information: Figurines_legacy_del

Column Name Data Type Type Category Coding Sheet Ontology
Count BIGINT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
Other_com TEXT  Uncoded Value uncategorized none none
Com10 TEXT  Uncoded Value uncategorized none none
Com9 TEXT  Uncoded Value uncategorized none none
Com 8 TEXT  Uncoded Value uncategorized none none
Com7 TEXT  Uncoded Value uncategorized none none
Com6 TEXT  Uncoded Value uncategorized none none
Com5 TEXT  Uncoded Value uncategorized none none
Com3 TEXT  Uncoded Value uncategorized none none
Com2 TEXT  Uncoded Value uncategorized none none
Com1 TEXT  Uncoded Value uncategorized none none
FinishId BIGINT  Uncoded Value uncategorized none none
Finish to be deleted
TEXT  Uncoded Value uncategorized none none
PaintId BIGINT  Uncoded Value uncategorized none none
Paint to be deleted
TEXT  Uncoded Value uncategorized none none
SexId BIGINT  Uncoded Value uncategorized none none
Sex to be deleted
TEXT  Uncoded Value uncategorized none none
TypeId BIGINT  Uncoded Value uncategorized none none
Type to be deleted
TEXT  Uncoded Value uncategorized none none
PortionId BIGINT  Uncoded Value uncategorized none none
Part to be deleted
TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus TEXT  Uncoded Value uncategorized none none
Level TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Site to be deleted
TEXT  Uncoded Value uncategorized none none
Item_numb TEXT  Uncoded Value uncategorized none none
F_numb BIGINT  Uncoded Value uncategorized none none
ID_name TEXT  Uncoded Value uncategorized none none
Com4 TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
FigurineId BIGINT  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none

Table Information: Figurines_new

Column Name Data Type Type Category Coding Sheet Ontology
KimsComments TEXT  Uncoded Value uncategorized none none
Count TEXT  Uncoded Value uncategorized none none
Other_com TEXT  Uncoded Value uncategorized none none
Com10 TEXT  Uncoded Value uncategorized none none
Com9 TEXT  Uncoded Value uncategorized none none
Com 8 TEXT  Uncoded Value uncategorized none none
Com7 TEXT  Uncoded Value uncategorized none none
Com6 TEXT  Uncoded Value uncategorized none none
Com5 TEXT  Uncoded Value uncategorized none none
Com4 TEXT  Uncoded Value uncategorized none none
Com3 TEXT  Uncoded Value uncategorized none none
Com2 TEXT  Uncoded Value uncategorized none none
FullDesc TEXT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
PortionId BIGINT  Uncoded Value uncategorized none none
Part TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
ULL_Id BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
Old_Type_Id Kim Goldstein's original type - no longer used
BIGINT  Uncoded Value uncategorized none none
LQ_Type New Types based on Jaime H's classification of 2006
TEXT  Uncoded Value uncategorized none none
Williams_Type TEXT  Uncoded Value uncategorized none none
F_numb DOUBLE  Uncoded Value uncategorized none none
Prim_id TEXT  Uncoded Value uncategorized none none
Site_Id BIGINT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
Figurine_Id BIGINT  Uncoded Value uncategorized none none
Com1 TEXT  Uncoded Value uncategorized none none
FinishId BIGINT  Uncoded Value uncategorized none none
Finish TEXT  Uncoded Value uncategorized none none
PaintId BIGINT  Uncoded Value uncategorized none none
Paint TEXT  Uncoded Value uncategorized none none
SexId BIGINT  Uncoded Value uncategorized none none
Sex TEXT  Uncoded Value uncategorized none none

Table Information: Grndstn

Column Name Data Type Type Category Coding Sheet Ontology
Count DOUBLE  Uncoded Value uncategorized none none
TypeCnfdnc TEXT  Uncoded Value uncategorized none none
AnalyticGroup special category created for Jaime to help her sort out the specimens she wished to include in her analysis
TEXT  Uncoded Value uncategorized none none
MatCnfdnc TEXT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
TypeCllctn TEXT  Uncoded Value uncategorized none none
MTMId BIGINT  Uncoded Value uncategorized none none
ManoSurfaces DOUBLE  Uncoded Value uncategorized none none
MatId BIGINT  Uncoded Value uncategorized none none
WearId BIGINT  Uncoded Value uncategorized none none
Weight TEXT  Uncoded Value uncategorized none none
Thickest DOUBLE  Uncoded Value uncategorized none none
Thinnest DOUBLE  Uncoded Value uncategorized none none
Width DOUBLE  Uncoded Value uncategorized none none
Length DOUBLE  Uncoded Value uncategorized none none
PrcntPrsnt DOUBLE  Uncoded Value uncategorized none none
ConId BIGINT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus TEXT  Uncoded Value uncategorized none none
Level TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Year BIGINT  Uncoded Value uncategorized none none
TypeCatId BIGINT  Uncoded Value uncategorized none none
CatId FK to the Artifact Catalog Table where possible
BIGINT  Uncoded Value uncategorized none none
GrndstnId BIGINT  Uncoded Value uncategorized none none

Table Information: Grndstn_Old_Bak_del

Column Name Data Type Type Category Coding Sheet Ontology
comments TEXT  Uncoded Value uncategorized none none
manopolish_shapedbytroughmetate? TEXT  Uncoded Value uncategorized none none
manopolish_#wearsurfaces BIGINT  Uncoded Value uncategorized none none
thickest DOUBLE  Uncoded Value uncategorized none none
thinnest DOUBLE  Uncoded Value uncategorized none none
count BIGINT  Uncoded Value uncategorized none none
raw_material TEXT  Uncoded Value uncategorized none none
material TEXT  Uncoded Value uncategorized none none
degree_of_wear TEXT  Uncoded Value uncategorized none none
wear TEXT  Uncoded Value uncategorized none none
width DOUBLE  Uncoded Value uncategorized none none
length DOUBLE  Uncoded Value uncategorized none none
condition TEXT  Uncoded Value uncategorized none none
tool_category TEXT  Uncoded Value uncategorized none none
type TEXT  Uncoded Value uncategorized none none
analytica_unit TEXT  Uncoded Value uncategorized none none
locale TEXT  Uncoded Value uncategorized none none
slash TEXT  Uncoded Value uncategorized none none
locus TEXT  Uncoded Value uncategorized none none
level TEXT  Uncoded Value uncategorized none none
unit TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
site TEXT  Uncoded Value uncategorized none none
year BIGINT  Uncoded Value uncategorized none none
id BIGINT  Uncoded Value uncategorized none none
percent_present BIGINT  Uncoded Value uncategorized none none
AU TEXT  Uncoded Value uncategorized none none

Table Information: IE_SherdElemJunct

Column Name Data Type Type Category Coding Sheet Ontology
IE_ElementFillId FK to Element Fill table
BIGINT  Uncoded Value uncategorized none none
IE_ElementId FK to IE_Element table
BIGINT  Uncoded Value uncategorized none none
IESherdId FK to IESherdId
BIGINT  Uncoded Value uncategorized none none

Table Information: IE_Sherds

Column Name Data Type Type Category Coding Sheet Ontology
YearExcavated Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
VNumber Only necessary if there is no RNumber (unit-level-locus)
BIGINT  Uncoded Value uncategorized none none
BagNumber Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
BoxNumber Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
DateCoded DATETIME  Uncoded Value uncategorized none none
Coder TEXT  Uncoded Value uncategorized none none
Slash Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
ULL_id BIGINT  Uncoded Value uncategorized none none
ULL Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
Site Site Name
TEXT  Uncoded Value uncategorized none none
SiteId FK to _Sites
BIGINT  Uncoded Value uncategorized none none
RNumber FK to RimStudy R number field
BIGINT  Uncoded Value uncategorized none none
RimStudyId FK to RimStudy RimStudyId
BIGINT  Uncoded Value uncategorized none none
IESherdsIdD BIGINT  Uncoded Value uncategorized none none

Table Information: iesherds_copy

Column Name Data Type Type Category Coding Sheet Ontology
ULL_id_fk BIGINT  Uncoded Value uncategorized none none
YearExcavated Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
BagNumber Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
BoxNumber Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
DateCoded DATETIME  Uncoded Value uncategorized none none
Coder TEXT  Uncoded Value uncategorized none none
Slash Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
ULL_id BIGINT  Uncoded Value uncategorized none none
ULL Only necessary if there is no RNumber (unit-level-locus)
TEXT  Uncoded Value uncategorized none none
SiteId FK to _Sites
BIGINT  Uncoded Value uncategorized none none
VNumber Only necessary if there is no RNumber (unit-level-locus)
BIGINT  Uncoded Value uncategorized none none
RNumber FK to RimStudy R number field
TEXT  Uncoded Value uncategorized none none
RimStudyId FK to RimStudy RimStudyId
BIGINT  Uncoded Value uncategorized none none
IESherdsIdD BIGINT  Uncoded Value uncategorized none none

Table Information: IllstArtfcts

Column Name Data Type Type Category Coding Sheet Ontology
SelectedForCat BOOLEAN  Uncoded Value uncategorized none none
SelectForReport BOOLEAN  Uncoded Value uncategorized none none
Illustration BLOB  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
ULL to be deleted?
TEXT  Uncoded Value uncategorized none none
SiteId FK to SiteId column of _Sites tables
BIGINT  Uncoded Value uncategorized none none
Status TEXT  Uncoded Value uncategorized none none
Link This is a hyperlink to the illustration living on the server
TEXT  Uncoded Value uncategorized none none
TypeCllctnId FK to TypeCllctnId column in the TypeCllctn table
BIGINT  Uncoded Value uncategorized none none
CatId BIGINT  Uncoded Value uncategorized none none
CodeId This code is the lookup to the physical drawings stored in portfolios and notebooks
TEXT  Uncoded Value uncategorized none none
IllustId BIGINT  Uncoded Value uncategorized none none

Table Information: IllstOthers

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
Report/Figure TEXT  Uncoded Value uncategorized none none
Area TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
TypeId TEXT  Uncoded Value uncategorized none none
Type TEXT  Uncoded Value uncategorized none none
SiteId TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
IllustNum TEXT  Uncoded Value uncategorized none none
IlustId BIGINT  Uncoded Value uncategorized none none

Table Information: INAH_CAT_EXT_REF_del

Column Name Data Type Type Category Coding Sheet Ontology
BOXNO TEXT  Uncoded Value uncategorized none none
CATNO TEXT  Uncoded Value uncategorized none none
INAH_ID BIGINT  Uncoded Value uncategorized none none

Table Information: Legacy_BotTaxaMich_del

Column Name Data Type Type Category Coding Sheet Ontology
Comment TEXT  Uncoded Value uncategorized none none
Charred No values
TEXT  Uncoded Value uncategorized none none
Weight DOUBLE  Uncoded Value uncategorized none none
Count BIGINT  Uncoded Value uncategorized none none
Portion No values
TEXT  Uncoded Value uncategorized none none
Taxon TEXT  Uncoded Value uncategorized none none
TaxonId TEXT  Uncoded Value uncategorized none none
FractionId BIGINT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus TEXT  Uncoded Value uncategorized none none
Level TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
Area TEXT  Uncoded Value uncategorized none none
SiteID BIGINT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
ID Old unique identifier -kept in for legacy purposes but too hard to maintain (not an auto-number) - taxa_id replaced this ID
BIGINT  Uncoded Value uncategorized none none
Phase TEXT  Uncoded Value uncategorized none none
taxa_id Taxa unique identifier
BIGINT  Uncoded Value uncategorized none none
Fraction TEXT  Uncoded Value uncategorized none none

Table Information: LP_ULL_VOL_EST_del

Column Name Data Type Type Category Coding Sheet Ontology
NOTES note any unusual steps needed in orde rto make your calculation
TEXT  Uncoded Value uncategorized none none
VOL measurement in cubic meters (AREA * DEPTH)
DOUBLE  Uncoded Value uncategorized none none
DEPTH average depth measurement in meters
DOUBLE  Uncoded Value uncategorized none none
AREA shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc])
DOUBLE  Uncoded Value uncategorized none none
L_BASE lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_HEIGHT lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_WIDTH lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_LENGTH lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
SIDE_B DOUBLE  Uncoded Value uncategorized none none
SIDE_A DOUBLE  Uncoded Value uncategorized none none
U_BASE upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_HEIGHT upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_WIDTH upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_LENGTH upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
L_SHAPE TEXT  Uncoded Value uncategorized none none
U_SHAPE combo box of acceptable shapes - not based on a table
TEXT  Uncoded Value uncategorized none none
TOP_BOT_IRREG is the top shape different from the bottom shape (YES or NO)?
TEXT  Uncoded Value uncategorized none none
locus used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
level used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
unit used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
ULL all valid Ulls from La Qemada
TEXT  Uncoded Value uncategorized none none
VOL_EST_ID BIGINT  Uncoded Value uncategorized none none
RADIUS DOUBLE  Uncoded Value uncategorized none none

Table Information: LPHumBone

Column Name Data Type Type Category Coding Sheet Ontology
Count BIGINT  Uncoded Value uncategorized none none
Notes TEXT  Uncoded Value uncategorized none none
PolPho TEXT  Uncoded Value uncategorized none none
ConjSets TEXT  Uncoded Value uncategorized none none
Size TEXT  Uncoded Value uncategorized none none
Taphonomy TEXT  Uncoded Value uncategorized none none
Perimortem TEXT  Uncoded Value uncategorized none none
Intextsurf TEXT  Uncoded Value uncategorized none none
Compl DOUBLE  Uncoded Value uncategorized none none
Sex TEXT  Uncoded Value uncategorized none none
Age TEXT  Uncoded Value uncategorized none none
Segment TEXT  Uncoded Value uncategorized none none
Side TEXT  Uncoded Value uncategorized none none
Lvl2GrpId FK to _HmOstLvl2Grp
BIGINT  Uncoded Value uncategorized none none
Lvl2Group to be deleted
TEXT  Uncoded Value uncategorized none none
Lvl1GrpId FK to _HmOstLvl1Grp
BIGINT  Uncoded Value uncategorized none none
Lvl1Group to be deleted
TEXT  Uncoded Value uncategorized none none
ElementId FK to _HmOstEleNorm
BIGINT  Uncoded Value uncategorized none none
ElementST TEXT  Uncoded Value uncategorized none none
Element TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus DOUBLE  Uncoded Value uncategorized none none
Level DOUBLE  Uncoded Value uncategorized none none
Prov TEXT  Uncoded Value uncategorized none none
Unit DOUBLE  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Site to be deleted
TEXT  Uncoded Value uncategorized none none
AnalyticUnit to be deleted
TEXT  Uncoded Value uncategorized none none
Box TEXT  Uncoded Value uncategorized none none
SPNum TEXT  Uncoded Value uncategorized none none
SpecimenId BIGINT  Uncoded Value uncategorized none none

Table Information: LPHumTeeth

Column Name Data Type Type Category Coding Sheet Ontology
Pathology TEXT  Uncoded Value uncategorized none none
AgeYr TEXT  Uncoded Value uncategorized none none
Aged/Up TEXT  Uncoded Value uncategorized none none
Side TEXT  Uncoded Value uncategorized none none
Tooth TEXT  Uncoded Value uncategorized none none
UpLo TEXT  Uncoded Value uncategorized none none
Art TEXT  Uncoded Value uncategorized none none
NumFfound DOUBLE  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus DOUBLE  Uncoded Value uncategorized none none
Level DOUBLE  Uncoded Value uncategorized none none
Prov TEXT  Uncoded Value uncategorized none none
UNIT DOUBLE  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
Box TEXT  Uncoded Value uncategorized none none
AnalyticUnit TEXT  Uncoded Value uncategorized none none
SpNum DOUBLE  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
LPHumTeethId BIGINT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none

Table Information: LQ_Commingled_Human_Bone

Column Name Data Type Type Category Coding Sheet Ontology
end DOUBLE  Uncoded Value uncategorized none none
comments TEXT  Uncoded Value uncategorized none none
slash TEXT  Uncoded Value uncategorized none none
other info TEXT  Uncoded Value uncategorized none none
ULL_ID BIGINT  Uncoded Value uncategorized none none
Ull_rect_comments TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
locus TEXT  Uncoded Value uncategorized none none
level BIGINT  Uncoded Value uncategorized none none
unit DOUBLE  Uncoded Value uncategorized none none
Site_ID BIGINT  Uncoded Value uncategorized none none
box TEXT  Uncoded Value uncategorized none none
age TEXT  Uncoded Value uncategorized none none
n DOUBLE  Uncoded Value uncategorized none none
% DOUBLE  Uncoded Value uncategorized none none
segment TEXT  Uncoded Value uncategorized none none
side TEXT  Uncoded Value uncategorized none none
bone TEXT  Uncoded Value uncategorized none none
id DOUBLE  Uncoded Value uncategorized none none
b DOUBLE  Uncoded Value uncategorized none none

Table Information: LQ_Cut_Marks_Human_Bone

Column Name Data Type Type Category Coding Sheet Ontology
CM Total TEXT  Uncoded Value uncategorized none none
Side TEXT  Uncoded Value uncategorized none none
Field # TEXT  Uncoded Value uncategorized none none
Bone TEXT  Uncoded Value uncategorized none none
Provience TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
other info TEXT  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
Site_Id BIGINT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
Dir TEXT  Uncoded Value uncategorized none none
Shape TEXT  Uncoded Value uncategorized none none
Depth TEXT  Uncoded Value uncategorized none none
Width TEXT  Uncoded Value uncategorized none none
Length TEXT  Uncoded Value uncategorized none none
Pos TEXT  Uncoded Value uncategorized none none
Loc TEXT  Uncoded Value uncategorized none none
CM # TEXT  Uncoded Value uncategorized none none
Cast TEXT  Uncoded Value uncategorized none none
Cast # TEXT  Uncoded Value uncategorized none none
Sort # TEXT  Uncoded Value uncategorized none none

Table Information: LQ_Processed_Human_Bone

Column Name Data Type Type Category Coding Sheet Ontology
comments TEXT  Uncoded Value uncategorized none none
measurement TEXT  Uncoded Value uncategorized none none
box TEXT  Uncoded Value uncategorized none none
b TEXT  Uncoded Value uncategorized none none
cd TEXT  Uncoded Value uncategorized none none
gn TEXT  Uncoded Value uncategorized none none
ps TEXT  Uncoded Value uncategorized none none
sc2 TEXT  Uncoded Value uncategorized none none
pp TEXT  Uncoded Value uncategorized none none
ch TEXT  Uncoded Value uncategorized none none
ct TEXT  Uncoded Value uncategorized none none
pe TEXT  Uncoded Value uncategorized none none
fl TEXT  Uncoded Value uncategorized none none
pt TEXT  Uncoded Value uncategorized none none
cr TEXT  Uncoded Value uncategorized none none
sc1 DOUBLE  Uncoded Value uncategorized none none
ivr TEXT  Uncoded Value uncategorized none none
peri fract TEXT  Uncoded Value uncategorized none none
% DOUBLE  Uncoded Value uncategorized none none
age TEXT  Uncoded Value uncategorized none none
bone TEXT  Uncoded Value uncategorized none none
frag TEXT  Uncoded Value uncategorized none none
side TEXT  Uncoded Value uncategorized none none
slash TEXT  Uncoded Value uncategorized none none
ULL_ID BIGINT  Uncoded Value uncategorized none none
otherinfo TEXT  Uncoded Value uncategorized none none
Ull_rect_comments TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
locus TEXT  Uncoded Value uncategorized none none
level TEXT  Uncoded Value uncategorized none none
unit DOUBLE  Uncoded Value uncategorized none none
Site_ID BIGINT  Uncoded Value uncategorized none none
id DOUBLE  Uncoded Value uncategorized none none

Table Information: LQ_ULL_VOL_EST

Column Name Data Type Type Category Coding Sheet Ontology
NOTES note any unusual steps needed in orde rto make your calculation
TEXT  Uncoded Value uncategorized none none
VOL measurement in cubic meters (AREA * DEPTH)
DOUBLE  Uncoded Value uncategorized none none
DEPTH average depth measurement in meters
DOUBLE  Uncoded Value uncategorized none none
AREA shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc])
DOUBLE  Uncoded Value uncategorized none none
RADIUS DOUBLE  Uncoded Value uncategorized none none
L_BASE lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_HEIGHT lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_WIDTH lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_LENGTH lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
SIDE_B DOUBLE  Uncoded Value uncategorized none none
SIDE_A DOUBLE  Uncoded Value uncategorized none none
U_BASE upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_HEIGHT upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_WIDTH upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_LENGTH upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
L_SHAPE TEXT  Uncoded Value uncategorized none none
U_SHAPE combo box of acceptable shapes - not based on a table
TEXT  Uncoded Value uncategorized none none
TOP_BOT_IRREG is the top shape different from the bottom shape (YES or NO)?
TEXT  Uncoded Value uncategorized none none
locus used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
level used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
unit used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
ULL all valid Ulls from La Qemada
TEXT  Uncoded Value uncategorized none none
VOL_EST_ID BIGINT  Uncoded Value uncategorized none none

Table Information: LQVolEstsOld

Column Name Data Type Type Category Coding Sheet Ontology
NOTES note any unusual steps needed in orde rto make your calculation
TEXT  Uncoded Value uncategorized none none
VOL measurement in cubic meters (AREA * DEPTH)
DOUBLE  Uncoded Value uncategorized none none
DEPTH average depth measurement in meters
DOUBLE  Uncoded Value uncategorized none none
AREA shape area in meters (formula depends on shape [eg. rectangle: L*W, circle: pi * radius squared, etc])
DOUBLE  Uncoded Value uncategorized none none
RADIUS DOUBLE  Uncoded Value uncategorized none none
L_BASE lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_HEIGHT lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_WIDTH lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
L_LENGTH lower shape measurement in meters (entry only required if the top and bottom shapes differ).
DOUBLE  Uncoded Value uncategorized none none
SIDE_B DOUBLE  Uncoded Value uncategorized none none
SIDE_A DOUBLE  Uncoded Value uncategorized none none
U_BASE upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_HEIGHT upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
TOP_BOT_IRREG is the top shape different from the bottom shape (YES or NO)?
TEXT  Uncoded Value uncategorized none none
locus used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
level used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
unit used to sort/order ulls
BIGINT  Uncoded Value uncategorized none none
ULL all valid Ulls from La Qemada
TEXT  Uncoded Value uncategorized none none
VOL_EST_ID BIGINT  Uncoded Value uncategorized none none
U_WIDTH upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
U_LENGTH upper shape measurement in meters
DOUBLE  Uncoded Value uncategorized none none
L_SHAPE TEXT  Uncoded Value uncategorized none none
U_SHAPE combo box of acceptable shapes - not based on a table
TEXT  Uncoded Value uncategorized none none

Table Information: Macrobot

Column Name Data Type Type Category Coding Sheet Ontology
Comment TEXT  Uncoded Value uncategorized none none
Charred BOOLEAN  Uncoded Value uncategorized none none
Weight DOUBLE  Uncoded Value uncategorized none none
Count BIGINT  Uncoded Value uncategorized none none
PortionId BIGINT  Uncoded Value uncategorized none none
Portion to be deleted
TEXT  Uncoded Value uncategorized none none
MbotTaxaId BIGINT  Uncoded Value uncategorized none none
Taxa to be deleted
TEXT  Uncoded Value uncategorized none none
ID to be deleted?
BIGINT  Uncoded Value uncategorized none none
FractionId BIGINT  Uncoded Value uncategorized none none
Fraction to be deleted
TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus DOUBLE  Uncoded Value uncategorized none none
Level DOUBLE  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
ULL_ID BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
Area to be deleted?
TEXT  Uncoded Value uncategorized none none
Site to be deleted
TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
SampleId BIGINT  Uncoded Value uncategorized none none

Table Information: Mbot_Type_Analysis

Column Name Data Type Type Category Coding Sheet Ontology
botanical_type_id_fk BIGINT  Uncoded Value uncategorized none none
speci_id_fk BIGINT  Uncoded Value uncategorized none none
Mbot_type_anal_id BIGINT  Uncoded Value uncategorized none none

Table Information: MD_Fields

Column Name Data Type Type Category Coding Sheet Ontology
MetaData_Desc TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
Doc_Object BLOB  Uncoded Value uncategorized none none
Table_id_fk BIGINT  Uncoded Value uncategorized none none
Field_name TEXT  Uncoded Value uncategorized none none
Field_Id BIGINT  Uncoded Value uncategorized none none

Table Information: MD_Tables

Column Name Data Type Type Category Coding Sheet Ontology
Doc_object BLOB  Uncoded Value uncategorized none none
MetaData TEXT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
Table_Name TEXT  Uncoded Value uncategorized none none
Table_id BIGINT  Uncoded Value uncategorized none none

Table Information: NewFlots

Column Name Data Type Type Category Coding Sheet Ontology
Land Snails (100=more not pulled) TEXT  Uncoded Value uncategorized none none
Unid Fragments Unidentified Fragments
TEXT  Uncoded Value uncategorized none none
Misc tissue (grams) TEXT  Uncoded Value uncategorized none none
Misc Stems TEXT  Uncoded Value uncategorized none none
Reeds TEXT  Uncoded Value uncategorized none none
Unid Spines Unidentified spines
TEXT  Uncoded Value uncategorized none none
Unid Fruit 5 Unidentified fruit
TEXT  Uncoded Value uncategorized none none
Unid Fruit 4 Unidentified fruit
TEXT  Uncoded Value uncategorized none none
Unid Fruit 3 Unidentified fruit
TEXT  Uncoded Value uncategorized none none
Unid Fruit 2 Unidentified fruit
TEXT  Uncoded Value uncategorized none none
Unid Fruit 1 Unidentified fruit
TEXT  Uncoded Value uncategorized none none
Unid 26 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 25 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 24 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 23 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 22 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 21 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 20 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 18 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 17 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 16 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 14 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid13 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 12 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 11 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 10 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 9 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 8 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 2 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 1 Unidentified
TEXT  Uncoded Value uncategorized none none
Labiateae TEXT  Uncoded Value uncategorized none none
Lychnis TEXT  Uncoded Value uncategorized none none
Polygonum TEXT  Uncoded Value uncategorized none none
Gramineae TEXT  Uncoded Value uncategorized none none
Leguminoseae sp 2 TEXT  Uncoded Value uncategorized none none
Setaria TEXT  Uncoded Value uncategorized none none
Stellaria TEXT  Uncoded Value uncategorized none none
Prosopis TEXT  Uncoded Value uncategorized none none
Pinus nut frag TEXT  Uncoded Value uncategorized none none
Helianthus TEXT  Uncoded Value uncategorized none none
Compositae sp 2 TEXT  Uncoded Value uncategorized none none
Compositae TEXT  Uncoded Value uncategorized none none
Portulaca TEXT  Uncoded Value uncategorized none none
Brassica TEXT  Uncoded Value uncategorized none none
Euphorbiaceae TEXT  Uncoded Value uncategorized none none
Solanaceae TEXT  Uncoded Value uncategorized none none
Physalis TEXT  Uncoded Value uncategorized none none
Cactaceae TEXT  Uncoded Value uncategorized none none
Mammalaria TEXT  Uncoded Value uncategorized none none
Amaranthus TEXT  Uncoded Value uncategorized none none
Chenopodium-tiny TEXT  Uncoded Value uncategorized none none
Chenopodium album TEXT  Uncoded Value uncategorized none none
Chenopodium sp 3 TEXT  Uncoded Value uncategorized none none
Chenopodium sp 2 TEXT  Uncoded Value uncategorized none none
Chenopodium TEXT  Uncoded Value uncategorized none none
Wild Legume TEXT  Uncoded Value uncategorized none none
Agave Tissue (in grams) TEXT  Uncoded Value uncategorized none none
Opuntia sp 2 TEXT  Uncoded Value uncategorized none none
Opuntia TEXT  Uncoded Value uncategorized none none
Curcurbita TEXT  Uncoded Value uncategorized none none
Phaseolus TEXT  Uncoded Value uncategorized none none
Kernel Weight (in grams) TEXT  Uncoded Value uncategorized none none
Maize kernel-count TEXT  Uncoded Value uncategorized none none
Cupule Weight (in grams) TEXT  Uncoded Value uncategorized none none
Maize cupule-count TEXT  Uncoded Value uncategorized none none
Wood Charcoal (in grams) TEXT  Uncoded Value uncategorized none none
AU Description(old) delete
TEXT  Uncoded Value uncategorized none none
AU(old) delete
TEXT  Uncoded Value uncategorized none none
Phase delete - these phases inlcude those from middens based on their specific stratigraphy and are not necessarliy the same phases as those in architectural areas
TEXT  Uncoded Value uncategorized none none
Slash Slash number or letter
TEXT  Uncoded Value uncategorized none none
Locus Locus
TEXT  Uncoded Value uncategorized none none
Level Level
TEXT  Uncoded Value uncategorized none none
Unit Unit
TEXT  Uncoded Value uncategorized none none
ULLId Unit-Leve-LLocus ID
BIGINT  Uncoded Value uncategorized none none
ULL Unit-Level-Locus
TEXT  Uncoded Value uncategorized none none
Area delete
TEXT  Uncoded Value uncategorized none none
SiteId Site ID and FK to sites table
BIGINT  Uncoded Value uncategorized none none
Site Site name
TEXT  Uncoded Value uncategorized none none
ID NewFlots unique identifier - data set created by Paula Turkon summer of 2006
BIGINT  Uncoded Value uncategorized none none
Unid 4 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 3 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 7 Unidentified
TEXT  Uncoded Value uncategorized none none
Unid 6 Unidentified
TEXT  Uncoded Value uncategorized none none

Table Information: Obsidian 97

Column Name Data Type Type Category Coding Sheet Ontology
location Where curated?
TEXT  Uncoded Value uncategorized none none
photo Photogrpahed?
TEXT  Uncoded Value uncategorized none none
drawn Drawn?
TEXT  Uncoded Value uncategorized none none
means_of_procurement Least detail, only similarly acquisition - Unk E and Noch for example
TEXT  Uncoded Value uncategorized none none
source_area Less detail, only similar source areas are recoded
TEXT  Uncoded Value uncategorized none none
chemical_source Greatest detail, only recorded if only one source associates with the group
TEXT  Uncoded Value uncategorized none none
naa_source Sub source based on color association
TEXT  Uncoded Value uncategorized none none
analysis Type of Analysis
TEXT  Uncoded Value uncategorized none none
mvp_id MURR sample number
TEXT  Uncoded Value uncategorized none none
color_group Color group
BIGINT  Uncoded Value uncategorized none none
special Special qualities
TEXT  Uncoded Value uncategorized none none
opalescent + is yes, = is maybe, - is no
TEXT  Uncoded Value uncategorized none none
tertiary_clr Tertiary Color: Black; Grey; Brown
TEXT  Uncoded Value uncategorized none none
secondary_clr Secondary Color: Grey; Black; Dark Grey; Black-Dark Grey; Light Grey; Light Green; White; Red; Brown-Green; Dark Red; Red-Orange; Brown
TEXT  Uncoded Value uncategorized none none
primary_clr Primary Color: Black; Black-Dark Grey; Dark Grey; Grey; Light Grey; White; Green; Light Green; Dark Green; Grey-Green; Red; Red-Brown; Brown; Brown-Green; Red-Orange; Dark Red-Brown; Ochre; UNknown
TEXT  Uncoded Value uncategorized none none
inclusions STRiations, SHMutz, BUBbles, SPLotches, RIBbons, CLOuds, FLEcks, MOTtling, SPEckles
TEXT  Uncoded Value uncategorized none none
clarity Clarity 1=Clear; 2= Clear with cloudiness; 3= cloudy but translucent; 4= Part opaque, part cloudy/translucent; 5= Fully opaque, possible translucent at thin edges; 6= Special; 7= Unknown
TEXT  Uncoded Value uncategorized none none
surface Surface Quality: Rough or Calcified, no entry = smooth and clean
TEXT  Uncoded Value uncategorized none none
luster Luster: GReasy; GLassy; Lustrous (not types as GR or GL); UNknown
TEXT  Uncoded Value uncategorized none none
color Flake Color, Loni's categories/classification: Lustrous Black; Dull Black; Translucent Black; Translucent Green; Dull Green; Dull Grey; Lustrous Dark Grey; Lustrous Red
TEXT  Uncoded Value uncategorized none none
cortex_surface Cortex surface - 1=smooth and flat, 2 = smooth and ridged, 3 = rough and flat, 4 = rough and ridged, 5 = very rough
TEXT  Uncoded Value uncategorized none none
cortex + or - (TF's with cortex on platform and cores)
TEXT  Uncoded Value uncategorized none none
edge U=used, PL= likely usable/used, PD=doubtful usable/used, N=not usable
TEXT  Uncoded Value uncategorized none none
flake Flake type: Primary Flake, Secondary Flake, Tertiary Flake, Primary RETouch flake, Secondary RETouch flake, Tertiary RETouch flake, CORE, COBBLE, Fragmentary Flake, FRAGment
TEXT  Uncoded Value uncategorized none none
count Number of flakes
BIGINT  Uncoded Value uncategorized none none
mg Weight in mg +-10mg
BIGINT  Uncoded Value uncategorized none none
/ Slash - Number=Point Proveniece, Letter=Special Find
TEXT  Uncoded Value uncategorized none none
ULL_ID_FK BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
locus Locus
TEXT  Uncoded Value uncategorized none none
level Level
TEXT  Uncoded Value uncategorized none none
unit Excavation Unit
TEXT  Uncoded Value uncategorized none none
midden_phase Midden phase (early, middle, late, mixed)
TEXT  Uncoded Value uncategorized none none
Area_name Portion of Site
TEXT  Uncoded Value uncategorized none none
Site_ID_FK BIGINT  Uncoded Value uncategorized none none
site La Quemada or Los Pilarillos
TEXT  Uncoded Value uncategorized none none
analytical_unit Analytical unit
BIGINT  Uncoded Value uncategorized none none
bag_id Bag number (Zacatecas only)
BIGINT  Uncoded Value uncategorized none none
obs_id Primary key
BIGINT  Uncoded Value uncategorized none none

Table Information: OtherArtifacts

Column Name Data Type Type Category Coding Sheet Ontology
count count
BIGINT  Uncoded Value uncategorized none none
Details Details
TEXT  Uncoded Value uncategorized none none
Functional subclass Functional subclass
TEXT  Uncoded Value uncategorized none none
Class Class
TEXT  Uncoded Value uncategorized none none
Material subclass Material subclass
TEXT  Uncoded Value uncategorized none none
Material Material
TEXT  Uncoded Value uncategorized none none
TypeCllcntID Type Collection ID and FK to the Type Collection table
BIGINT  Uncoded Value uncategorized none none
OtherId Unique identifier
BIGINT  Uncoded Value uncategorized none none

Table Information: Photo_Artifacts

Column Name Data Type Type Category Coding Sheet Ontology
Image BLOB  Uncoded Value uncategorized none none
SelectedForReport BOOLEAN  Uncoded Value uncategorized none none
SelectedForArtCat BOOLEAN  Uncoded Value uncategorized none none
ULLInfo TEXT  Uncoded Value uncategorized none none
RimNumber TEXT  Uncoded Value uncategorized none none
PrimId TEXT  Uncoded Value uncategorized none none
CatId BIGINT  Uncoded Value uncategorized none none
Exposure TEXT  Uncoded Value uncategorized none none
PhotoId Link back to traditional prints in Photolog table
BIGINT  Uncoded Value uncategorized none none
PhotoArtifactsId BIGINT  Uncoded Value uncategorized none none

Table Information: Photo_ULLS

Column Name Data Type Type Category Coding Sheet Ontology
AUId BIGINT  Uncoded Value uncategorized none none
SIte_id BIGINT  Uncoded Value uncategorized none none
ULL_Id BIGINT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
PohotoId BIGINT  Uncoded Value uncategorized none none
IdPhotoNum_ULL BIGINT  Uncoded Value uncategorized none none

Table Information: Photologs

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
Item12 TEXT  Uncoded Value uncategorized none none
Item11 TEXT  Uncoded Value uncategorized none none
Item10 TEXT  Uncoded Value uncategorized none none
Item9 TEXT  Uncoded Value uncategorized none none
Item8 TEXT  Uncoded Value uncategorized none none
Item7 TEXT  Uncoded Value uncategorized none none
Item6 TEXT  Uncoded Value uncategorized none none
Item5 TEXT  Uncoded Value uncategorized none none
Item4 TEXT  Uncoded Value uncategorized none none
Item3 TEXT  Uncoded Value uncategorized none none
Item2 TEXT  Uncoded Value uncategorized none none
Item1 TEXT  Uncoded Value uncategorized none none
Hyperlink Hyperlink to digital copy of photograph
TEXT  Uncoded Value uncategorized none none
Photographer Photographer
TEXT  Uncoded Value uncategorized none none
Direction Direction facing when photo taken
TEXT  Uncoded Value uncategorized none none
Description Description
TEXT  Uncoded Value uncategorized none none
Date Date photo was taken
TEXT  Uncoded Value uncategorized none none
Subject Subject
TEXT  Uncoded Value uncategorized none none
Site Site
TEXT  Uncoded Value uncategorized none none
Sort Sort number
BIGINT  Uncoded Value uncategorized none none
Exp Exposure number
TEXT  Uncoded Value uncategorized none none
Speed Film speed
TEXT  Uncoded Value uncategorized none none
Film Film Type
TEXT  Uncoded Value uncategorized none none
Roll Roll identifier
TEXT  Uncoded Value uncategorized none none
BinderNum Note book binder number
TEXT  Uncoded Value uncategorized none none
Page Page
TEXT  Uncoded Value uncategorized none none
PhotoId Unique identifier
BIGINT  Uncoded Value uncategorized none none

Table Information: RimStudy

Column Name Data Type Type Category Coding Sheet Ontology
s_Lineage BLOB  Uncoded Value uncategorized none none
s_GUID TEXT  Uncoded Value uncategorized none none
s_Generation BIGINT  Uncoded Value uncategorized none none
s_ColLineage BLOB  Uncoded Value uncategorized none none
Gen_Comments BIGINT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
Firing int Reduced, Oxidized, Both
TEXT  Uncoded Value uncategorized none none
Firing ext Reduced, Oxidized, Both
TEXT  Uncoded Value uncategorized none none
Carbon sym Centered, Exteriorly biased, Interiorly biased
TEXT  Uncoded Value uncategorized none none
Carbon streak width DOUBLE  Uncoded Value uncategorized none none
Foot type Flared, Direct, Clawed, Pointed
TEXT  Uncoded Value uncategorized none none
Support attachment Simple, Complex
TEXT  Uncoded Value uncategorized none none
Support shaft type Simple, Kneed, Bulbuous
TEXT  Uncoded Value uncategorized none none
Support xsection Circular, Elliptical
TEXT  Uncoded Value uncategorized none none
Brushed ware neck treat Simple, Smoothed, Burnished, Highly burnished/Self-slipped, Polished
TEXT  Uncoded Value uncategorized none none
Lip to brushing The measurement on brushed wares from the top of the lip to the point at which brushing begins - measures the amount of obliterated brushing at rim.
DOUBLE  Uncoded Value uncategorized none none
Handle position Rim, Neck, Shoulder, Body
TEXT  Uncoded Value uncategorized none none
Handle orientation Vertical, Horizontal
TEXT  Uncoded Value uncategorized none none
Handle BOOLEAN  Uncoded Value uncategorized none none
Tripod whole Presence of the entire tripod - shape, length, and width measurements should be possible.
BOOLEAN  Uncoded Value uncategorized none none
Tripod frag Only a portion of the tripod remains - either shape, length, and/or width measurement would be missing.
BOOLEAN  Uncoded Value uncategorized none none
Tripod facet Scar where tripod broke off, but effectively no tripod remaining.
BOOLEAN  Uncoded Value uncategorized none none
Rim tab BOOLEAN  Uncoded Value uncategorized none none
Base BOOLEAN  Uncoded Value uncategorized none none
Body BOOLEAN  Uncoded Value uncategorized none none
Shoulder BOOLEAN  Uncoded Value uncategorized none none
Neck BOOLEAN  Uncoded Value uncategorized none none
Lip BOOLEAN  Uncoded Value uncategorized none none
Rim BOOLEAN  Uncoded Value uncategorized none none
Arc int DOUBLE  Uncoded Value uncategorized none none
Orifice radius int DOUBLE  Uncoded Value uncategorized none none
Arc ext DOUBLE  Uncoded Value uncategorized none none
Orifice radius ext DOUBLE  Uncoded Value uncategorized none none
Slip consistency Washy, Complete
TEXT  Uncoded Value uncategorized none none
Surface finish int Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished
TEXT  Uncoded Value uncategorized none none
Surface finish ext Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished
TEXT  Uncoded Value uncategorized none none
DecorationId FK to _CerTrtmnt
BIGINT  Uncoded Value uncategorized none none
Decoration Decorated, Undecorated
TEXT  Uncoded Value uncategorized none none
LipTreatmentId FK to _RimLipTreatment
BIGINT  Uncoded Value uncategorized none none
Lip treatment Ticking, Notching, Continuous lines, Discontinuous line, Zig-Zag, Wavy, Diagonal lines, Combination
TEXT  Uncoded Value uncategorized none none
Lip thickening Yes or No
BOOLEAN  Uncoded Value uncategorized none none
LipFormId FK to _RimLipForm
BIGINT  Uncoded Value uncategorized none none
Lip form Tapered, Rounded, Squared
TEXT  Uncoded Value uncategorized none none
Neck-shoulder thickness DOUBLE  Uncoded Value uncategorized none none
Rim thickening BOOLEAN  Uncoded Value uncategorized none none
RimFormId FK to _RimRimForm
BIGINT  Uncoded Value uncategorized none none
Rim form Look to "Rim study: rim form lookup" for possible values, definitions, and examples
TEXT  Uncoded Value uncategorized none none
ContourTypeId FK to _RimContourType
BIGINT  Uncoded Value uncategorized none none
Contour type Look to "Rim study: contour type lookup" for possible values, definitions, and examples
TEXT  Uncoded Value uncategorized none none
VesselShapeId FK to _RimVsslShape
BIGINT  Uncoded Value uncategorized none none
Vessel shape Look to "Rim study: vessel shape lookup" for possible values, definitions, and examples
TEXT  Uncoded Value uncategorized none none
TypeId FK to _CerType
BIGINT  Uncoded Value uncategorized none none
Type Look to "Ceramics: type lookup" for more information
TEXT  Uncoded Value uncategorized none none
WareId FK to _CerTypeWare
BIGINT  Uncoded Value uncategorized none none
Ware Incised-engraved, Painted, Plain, Negative, Pseudo-cloisonné, Indeterminate, Historic, Slipped
TEXT  Uncoded Value uncategorized none none
Date coded DATETIME  Uncoded Value uncategorized none none
Coder TEXT  Uncoded Value uncategorized none none
Year TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Bag number TEXT  Uncoded Value uncategorized none none
Box number BIGINT  Uncoded Value uncategorized none none
BoxId_new BIGINT  Uncoded Value uncategorized none none
PrimId TEXT  Uncoded Value uncategorized none none
CatId BIGINT  Uncoded Value uncategorized none none
V number BIGINT  Uncoded Value uncategorized none none
Sort number BIGINT  Uncoded Value uncategorized none none
AndrewComment TEXT  Uncoded Value uncategorized none none
R number TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
Locus TEXT  Uncoded Value uncategorized none none
Level TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: RimStudy_old

Column Name Data Type Type Category Coding Sheet Ontology
GenComments BIGINT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
Count BIGINT  Uncoded Value uncategorized none none
FiringInt TEXT  Uncoded Value uncategorized none none
FiringExt TEXT  Uncoded Value uncategorized none none
CarbonSym TEXT  Uncoded Value uncategorized none none
CarbonStreakWidth DOUBLE  Uncoded Value uncategorized none none
FootType TEXT  Uncoded Value uncategorized none none
SupportAttachment TEXT  Uncoded Value uncategorized none none
SupportShaftType TEXT  Uncoded Value uncategorized none none
SupportXSection TEXT  Uncoded Value uncategorized none none
BrushedWareNeckTreat TEXT  Uncoded Value uncategorized none none
LipToBrushing DOUBLE  Uncoded Value uncategorized none none
HandlePositionId BIGINT  Uncoded Value uncategorized none none
HandlePosition to be deleted
TEXT  Uncoded Value uncategorized none none
HandelPositionId BIGINT  Uncoded Value uncategorized none none
HandleOrientation to be deleted
TEXT  Uncoded Value uncategorized none none
Handle BOOLEAN  Uncoded Value uncategorized none none
TripodWhole BOOLEAN  Uncoded Value uncategorized none none
TripodFrag BOOLEAN  Uncoded Value uncategorized none none
TripodFacet BOOLEAN  Uncoded Value uncategorized none none
RimTab BOOLEAN  Uncoded Value uncategorized none none
Base BOOLEAN  Uncoded Value uncategorized none none
Shoulder BOOLEAN  Uncoded Value uncategorized none none
Neck BOOLEAN  Uncoded Value uncategorized none none
Lip BOOLEAN  Uncoded Value uncategorized none none
Rim BOOLEAN  Uncoded Value uncategorized none none
ArcInt DOUBLE  Uncoded Value uncategorized none none
OrificeRadiusInt DOUBLE  Uncoded Value uncategorized none none
ArcExt DOUBLE  Uncoded Value uncategorized none none
OrificeRadiusExt DOUBLE  Uncoded Value uncategorized none none
SlipConsistencyId BIGINT  Uncoded Value uncategorized none none
SlipConsistency to be deleted
TEXT  Uncoded Value uncategorized none none
SurfaceFinishInt TEXT  Uncoded Value uncategorized none none
SurfaceFinishExt TEXT  Uncoded Value uncategorized none none
DecorationId BIGINT  Uncoded Value uncategorized none none
Decoration to be delted
TEXT  Uncoded Value uncategorized none none
LipTreatmentId BIGINT  Uncoded Value uncategorized none none
LipTreatment to be delted
TEXT  Uncoded Value uncategorized none none
LipThickening BOOLEAN  Uncoded Value uncategorized none none
LipFormId BIGINT  Uncoded Value uncategorized none none
LipForm to be deleted
TEXT  Uncoded Value uncategorized none none
NeckSsoulderThickness DOUBLE  Uncoded Value uncategorized none none
RimThickening BOOLEAN  Uncoded Value uncategorized none none
RimFormId BIGINT  Uncoded Value uncategorized none none
RimForm to be deleted
TEXT  Uncoded Value uncategorized none none
ContourTypeId BIGINT  Uncoded Value uncategorized none none
ContourType to be delted
TEXT  Uncoded Value uncategorized none none
VesselShapeId BIGINT  Uncoded Value uncategorized none none
VesselShape to be deleted
TEXT  Uncoded Value uncategorized none none
TypeId BIGINT  Uncoded Value uncategorized none none
Type to be deleted
TEXT  Uncoded Value uncategorized none none
WareId BIGINT  Uncoded Value uncategorized none none
Ware to be deleted
TEXT  Uncoded Value uncategorized none none
DateCoded DATETIME  Uncoded Value uncategorized none none
Coder TEXT  Uncoded Value uncategorized none none
Year TEXT  Uncoded Value uncategorized none none
ULLId BIGINT  Uncoded Value uncategorized none none
ULL to be deleted?
TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus TEXT  Uncoded Value uncategorized none none
Level TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
SiteId BIGINT  Uncoded Value uncategorized none none
Site to be deleted
TEXT  Uncoded Value uncategorized none none
BagNumber TEXT  Uncoded Value uncategorized none none
Body BOOLEAN  Uncoded Value uncategorized none none
BoxNumber BIGINT  Uncoded Value uncategorized none none
VNumber BIGINT  Uncoded Value uncategorized none none
SortNumber BIGINT  Uncoded Value uncategorized none none
RNumber TEXT  Uncoded Value uncategorized none none
RimId BIGINT  Uncoded Value uncategorized none none

Table Information: RimStudyold_2

Column Name Data Type Type Category Coding Sheet Ontology
s_Lineage BLOB  Uncoded Value uncategorized none none
s_GUID TEXT  Uncoded Value uncategorized none none
s_Generation BIGINT  Uncoded Value uncategorized none none
s_ColLineage BLOB  Uncoded Value uncategorized none none
Gen_Comments BIGINT  Uncoded Value uncategorized none none
Comments TEXT  Uncoded Value uncategorized none none
Firing int Reduced, Oxidized, Both
TEXT  Uncoded Value uncategorized none none
Firing ext Reduced, Oxidized, Both
TEXT  Uncoded Value uncategorized none none
Carbon sym Centered, Exteriorly biased, Interiorly biased
TEXT  Uncoded Value uncategorized none none
Carbon streak width DOUBLE  Uncoded Value uncategorized none none
Foot type Flared, Direct, Clawed, Pointed
TEXT  Uncoded Value uncategorized none none
Support attachment Simple, Complex
TEXT  Uncoded Value uncategorized none none
Support shaft type Simple, Kneed, Bulbuous
TEXT  Uncoded Value uncategorized none none
Support xsection Circular, Elliptical
TEXT  Uncoded Value uncategorized none none
Brushed ware neck treat Simple, Smoothed, Burnished, Highly burnished/Self-slipped, Polished
TEXT  Uncoded Value uncategorized none none
Lip to brushing The measurement on brushed wares from the top of the lip to the point at which brushing begins - measures the amount of obliterated brushing at rim.
DOUBLE  Uncoded Value uncategorized none none
Handle position Rim, Neck, Shoulder, Body
TEXT  Uncoded Value uncategorized none none
Handle orientation Vertical, Horizontal
TEXT  Uncoded Value uncategorized none none
Handle BOOLEAN  Uncoded Value uncategorized none none
Tripod whole Presence of the entire tripod - shape, length, and width measurements should be possible.
BOOLEAN  Uncoded Value uncategorized none none
Tripod frag Only a portion of the tripod remains - either shape, length, and/or width measurement would be missing.
BOOLEAN  Uncoded Value uncategorized none none
Tripod facet Scar where tripod broke off, but effectively no tripod remaining.
BOOLEAN  Uncoded Value uncategorized none none
Rim tab BOOLEAN  Uncoded Value uncategorized none none
Base BOOLEAN  Uncoded Value uncategorized none none
Body BOOLEAN  Uncoded Value uncategorized none none
Shoulder BOOLEAN  Uncoded Value uncategorized none none
Neck BOOLEAN  Uncoded Value uncategorized none none
Lip BOOLEAN  Uncoded Value uncategorized none none
Rim BOOLEAN  Uncoded Value uncategorized none none
Arc int DOUBLE  Uncoded Value uncategorized none none
Orifice radius int DOUBLE  Uncoded Value uncategorized none none
Arc ext DOUBLE  Uncoded Value uncategorized none none
Orifice radius ext DOUBLE  Uncoded Value uncategorized none none
Slip consistency Washy, Complete
TEXT  Uncoded Value uncategorized none none
Surface finish int Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished
TEXT  Uncoded Value uncategorized none none
Surface finish ext Simple, Smooth, Burnished, Highly Burnished-Self-slipped, Polished
TEXT  Uncoded Value uncategorized none none
Decoration Decorated, Undecorated
TEXT  Uncoded Value uncategorized none none
Lip treatment Ticking, Notching, Continuous lines, Discontinuous line, Zig-Zag, Wavy, Diagonal lines, Combination
TEXT  Uncoded Value uncategorized none none
Lip thickening Yes or No
BOOLEAN  Uncoded Value uncategorized none none
Lip form Tapered, Rounded, Squared
TEXT  Uncoded Value uncategorized none none
Neck-shoulder thickness DOUBLE  Uncoded Value uncategorized none none
Rim thickening BOOLEAN  Uncoded Value uncategorized none none
Rim form Look to "Rim study: rim form lookup" for possible values, definitions, and examples
TEXT  Uncoded Value uncategorized none none
Contour type Look to "Rim study: contour type lookup" for possible values, definitions, and examples
TEXT  Uncoded Value uncategorized none none
Vessel shape Look to "Rim study: vessel shape lookup" for possible values, definitions, and examples
TEXT  Uncoded Value uncategorized none none
Type Look to "Ceramics: type lookup" for more information
TEXT  Uncoded Value uncategorized none none
Ware Incised-engraved, Painted, Plain, Negative, Pseudo-cloisonné, Indeterminate, Historic, Slipped
TEXT  Uncoded Value uncategorized none none
Date coded DATETIME  Uncoded Value uncategorized none none
Coder TEXT  Uncoded Value uncategorized none none
Year TEXT  Uncoded Value uncategorized none none
Slash TEXT  Uncoded Value uncategorized none none
Locus TEXT  Uncoded Value uncategorized none none
Level TEXT  Uncoded Value uncategorized none none
Unit TEXT  Uncoded Value uncategorized none none
ULL TEXT  Uncoded Value uncategorized none none
Site TEXT  Uncoded Value uncategorized none none
Bag number TEXT  Uncoded Value uncategorized none none
Box number BIGINT  Uncoded Value uncategorized none none
V number BIGINT  Uncoded Value uncategorized none none
Sort number BIGINT  Uncoded Value uncategorized none none
R number TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: Romos2001Blk

Column Name Data Type Type Category Coding Sheet Ontology
Comments TEXT  Uncoded Value uncategorized none none
RimExt_AllInt DOUBLE  Uncoded Value uncategorized none none
RimInt_AllExt DOUBLE  Uncoded Value uncategorized none none
AllBoth DOUBLE  Uncoded Value uncategorized none none
AllExt DOUBLE  Uncoded Value uncategorized none none
AllInt DOUBLE  Uncoded Value uncategorized none none
RimIntExt DOUBLE  Uncoded Value uncategorized none none
RimExt DOUBLE  Uncoded Value uncategorized none none
RimInt DOUBLE  Uncoded Value uncategorized none none
BrdOtr DOUBLE  Uncoded Value uncategorized none none
BrdStr DOUBLE  Uncoded Value uncategorized none none
ThkOtr DOUBLE  Uncoded Value uncategorized none none
ThkStr DOUBLE  Uncoded Value uncategorized none none
ThnOtr DOUBLE  Uncoded Value