Roosevelt Platform Mound Study (RPMS): Access Database

Data Set Structure

Table Information: amag - Archaeomag Data

This table (AMAG) contains data for archaeomagnetic dating samples.

Table Information: amagor - Archaeomag Orientation

This table (AMAGOR) contains data on archaeomagnetic sample orientation.

Table Information: artpho - Artifact Photos

This table (ARTPHO) catalogs artifact photos.

Table Information: asmctphotolog - ASMCTphotolog

This table (ASMCTphotolog) catalogs photographs.

Table Information: asmtnf - Site Locations and Numbers

This table (ASMTNF) records site locations and numbers assigned by Arizona State Museum (ASM) and Tonto National Forest (TNF).

Table Information: baseshap - Base Shape Codes

This table (BASESHAP) is a lookup table containing base shape codes and labels for chipped stone tools.

Table Information: beadtype - BEADTYPE

This table (BEADTYPE) is a lookup table containing type codes and labels for shell bead forms.

Table Information: blocks - Construction Block Modification Codes

This table (BLOCKS) is a lookup table containing construction block modification codes and labels.

Table Information: bodyform - Body Form Shape

This table (BodyForm) is a lookup table containing codes and labels for ceramic body forms.

Table Information: boulder - Rock Art Data

This table (BOULDER) contains data on rock art.

Table Information: bowljar - bowljar

Table Information: boxes - Box Locations

This table (BOXES) records information on box locations.

Table Information: boxtype - Box Type

This table (BOXTYPE) is a lookup table containing codes and labels for box type (material contents).

Table Information: burials - Burial Data

This table (BURIALS) contains data on burials and general body orientation.

Table Information: butcher - Presence of Butcher Marks on Bones

This table (BUTCHER) is a lookup table containing codes and labels for recording the presence or absence of butcher marks on bones.

Table Information: c14 - Carbon 14 Data

This table (C14) contains data on Carbon 14 samples.

Table Information: c14_with_bad_spec - C14 with bad spec #

Table Information: c14res - Carbon 14 Results

This table (C14RES) contains data on Carbon 14 dating results.

Table Information: carbstre - Carbon Streak

This table (CARBSTRE) is a lookup table containing codes and labels for documenting carbon streak in ceramics.

Table Information: category - Disk type

This table (CATEGORY) is a lookup table containing codes and labels documenting disk type (ceramic or lithic material, perforated or unperforated disk).

Table Information: cdresul - Cross Dating Results

This table (CDRESUL) contains data on cross dating results.

Table Information: centhole - Center Hole

This table (CENTHOLE) is a lookup table containing codes and labels for documenting presence and completeness of center holes in ceramic and lithic disks (i.e., none, partial, or complete).

Table Information: changes - CHANGES

Table Information: charcoal - Charcoal Codes

This table (CHARCOAL) is a lookup table containing codes and labels for charcoal.

Table Information: choice - Choice

This table (CHOICE) is a lookup table containing codes and labels for obsidian sources.

Table Information: codelist - Code List

This table (CODELIST) contains labels identifying lookup tables in the RPMS database.

Table Information: col_location - Box Locations

Table Information: col_source - Shell Source Codes

Table Information: col_style - Ceramic Style

Table Information: collmeth - Collection Method Codes

This table (COLLMETH) is a lookup table containing codes and labels for collection methods.

Table Information: complet - Shell Completeness Codes

This table (COMPLET) is a lookup table containing codes and labels for documenting shell completeness.

Table Information: complete - Completeness Codes

This table (COMPLETE) is a lookup table containing codes and labels for documenting object completeness.

Table Information: conditio - Condition Codes

This table (CONDITIO) is a lookup table containing codes and labels for documenting object condition.

Table Information: construc - Construction Type Codes

This table (CONSTRUC) is a lookup table containing codes and labels for documenting construction type.

Table Information: context - Context Codes

This table (CONTEXT) is a lookup table containing codes and labels for designating archaeological context.

Table Information: crew - Crew Name Codes

This table (CREW) contains crew member initials and full names.

Table Information: crossdat - Cross Dating Data

This table (CROSSDAT) contains cross dating data.

Table Information: cultzone - Cultural Zone Codes

Table Information: decorat - Groundstone Decoration Codes

Table Information: dorsvent - Dorsal or Ventral vertebral parts

Table Information: drilhole - Drill hole characteristics

Table Information: drillhol - Drill Hole Codes

Table Information: drillrot - Drill Rotation Codes

Table Information: edge - Ornament Edge Codes

Table Information: elem - Rock Art Element Data

Table Information: endshape - End Shape

Table Information: endtype - End Type Codes

Table Information: entryfac - Entry Facing

Table Information: entryway - Entryway Location Codes

Table Information: exattach - Exterior Attachment Codes

Table Information: excameth - Excavation Method Codes

Table Information: exsurffi - External Ceramic Surface Finish

Table Information: exsurftr - External Surface Treatment

Table Information: facedec - Decoration Codes

Table Information: fburn - Burning characteristics

Table Information: fcond - Condition of Faunal Material

Table Information: fcr - Fire Cracked Rock Data

Table Information: feat - Features Data

Table Information: featclas - Feature Class Codes

Table Information: featgrou - Feature Group

Table Information: feattype - Feature Type Codes

Table Information: felem - Faunal Element type

Table Information: ffrag - Bone fragmentation

Table Information: ffusion - Proximal and Distal Fusion

Table Information: filelist - File List

Table Information: film - Film Data

Table Information: fincond - Final Condition Codes

Table Information: fmod - Bone modification codes

Table Information: form - Shell Form Codes

Table Information: fscreen - Screen mesh used

Table Information: fside - Side from which animal bones come

Table Information: fspecies - Species of animal bone

Table Information: genfeat - General Feature Data

Table Information: genshape - General Shape Codes

Table Information: glennpollen - GLENNPOLLEN

Table Information: goodie - Special Finds

Table Information: grainsiz - Groundstone Grain Size

Table Information: grovshap - Groove Shape Codes

Table Information: grovstri - Groove Striation Codes

Table Information: grovtype - Groove Type Codes

Table Information: gsclass - Ground Stone Artifact Class

Table Information: hafthole - Hafthole Codes

Table Information: hafting - Hafting Codes

Table Information: hole - Ornament Hole Codes

Table Information: inattach - Interior Attachment Codes

Table Information: inclusio - Feature Inclusion Codes

Table Information: insurffi - Internal Ceramic Surface Finish

Table Information: insurftr - Internal Ceramic Surface Treatment

Table Information: invent - Inventory

Table Information: iow - Items of Worth

Table Information: iow_with_bad_spec - IOW with bad spec#

Table Information: level - Level Data

Table Information: leveltyp - Level Type Codes

Table Information: lithclas - Lithic Class Codes

Table Information: lithshap - Lithic Shape Codes

Table Information: lithsize - Lithic Size Codes

Table Information: lithtype - Lithic Type Codes

Table Information: macrobot_with_prov - macrobot with prov

Table Information: mangroup - Management Group Codes

Table Information: manutech - Manufacturing Technique

Table Information: material - Lithic Material

Table Information: mbotres - Macrobotanical Results

Table Information: mcommon - Macrobotanical Common Names

Table Information: mni - MNI Codes

Table Information: motif - Shell Motif Codes

Table Information: mspecies - Macrobotanical Species Codes

Table Information: mspecies__2____with_old - MSPECIES (2) - with old labels

Table Information: notches - Lithic Notch Codes

Table Information: notching - Ornament Notching Codes

Table Information: nullspec - NULLSPEC

Table Information: obsidian - Obsidian Sourcing

Table Information: oldshel - OLDSHEL

Table Information: ornament - Ornament Type Codes

Table Information: paint - Paint Color and Material

Table Information: paste - Interior Core Paste Color

Table Information: permit - Permit Codes

Table Information: photos - Photo Log

Table Information: pigcomb - Pigment Combination Codes

Table Information: pigmod - Pigment Modification Codes

Table Information: piguse - Pigment Use Codes

Table Information: planshap - Feature Plan Shape Codes

Table Information: pname - Macrobotanical Part Name

Table Information: pname__2__with_old_label - PNAME (2) with old labels

Table Information: polfeat - POLFEAT

Table Information: pollen - Pollen Data