Pueblo Grande (AZ U:9:1(ASM)): Unit 11, Van Buren and 44th Streets: SSI DMB Testing and Data Recovery, Faunal (FAUNAL) Data

Creator(s): Maria Martin

Year: 1997

Summary

The DMB Testing and Data Recovery: Faunal (FAUNAL) Data sheet contains data on the faunal remains recovered during SSI's testing and data recovery projects (SSI Project No. 97-02) at Pueblo Grande, Unit 11. The data set lists the provenience designation (PD) and Field Specimen (FS) number of the remains (Note that it is essential that the PD and FS remain associated to identify a given faunal specimen). If the specimen was recovered from an identified feature, the data set also provides the feature number and feature type. The data sheet then documents a specimen's species designation, estimated age and sex, the element type and number, element side, other anatomical data, condition, and any identified modifications. Please see note about fauna data below.

Cite this Record

Pueblo Grande (AZ U:9:1(ASM)): Unit 11, Van Buren and 44th Streets: SSI DMB Testing and Data Recovery, Faunal (FAUNAL) Data. Maria Martin. 1997 ( tDAR id: 366759) ; doi:10.6067/XCV8222SRT

This Resource is Part of the Following Collections

Data Set Structure

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

Table Information: 97-02-dmb-testing-and-data-recovery_faunal_data_cleaned_with-feature-no

Column Name Data Type Type Category Coding Sheet Ontology Search
SIZE The relative size of the faunal element
VARCHAR  Coded Value Fauna : Other Soil Systems, Inc. Faunal Element Size Coding Sheet none true
SIDE The side (e.g., left, right) of the bone element. Please refer to Soil Systems, Inc. Faunal Bone Side Coding Sheet for a list of siding codes.
VARCHAR  Coded Value Fauna : Side Soil Systems, Inc. Faunal Bone Side Coding Sheet none true
PROXIMAL_DISTAL VARCHAR  Coded Value Fauna : Portion/Proximal/Distal Soil Systems, Inc. Faunal Proximal/Distal Coding Sheet none true
WITH_TEETH VARCHAR  Coded Value Fauna Soil Systems, Inc. Faunal Element With Teeth Coding Sheet none true
ANTERIOR_POSTERIOR VARCHAR  Coded Value Fauna : Anterior/Posterior Soil Systems, Inc. Faunal Anterior/Posterior Coding Sheet none true
CONDITION BIGINT  Coded Value Fauna : Completeness Soil Systems, Inc. Faunal Remains Condition (Completeness) Coding Sheet none true
FRONT_HIND VARCHAR  Coded Value Fauna Soil Systems, Inc. Faunal Front/Hind Coding Sheet none true
FS The field specimen number assigned to an artifact type from a given PD unit. Note that one FS # is assigned to multiple artifacts of the same type from a single PD unit. In the field, specimen numbers were assigned to bags of like artifacts from the same PD. When artifacts were collected, a specimen number was assigned to a bag that contained particular artifact types from a PD unit. Thus, a separate FS # was assigned to the ceramics, lithics, groundstone, etc that were recovered from a PD. Specimen numbers run from 1 to n for each PD unit. Thus, to identify a specific specimen, an analyst must use a combination of the PD No and the FS No.
BIGINT  Uncoded Value Provenience and Context none none true
PROJECT The SSI project number during which the faunal specimen was collected.
VARCHAR  Uncoded Value Provenience and Context : Project none none true
PD The Provenience Designation (PD) number is an area that has been examined by archaeological researchers during a given project. PD numbers are assigned to all examined areas, even when no artifacts were collected. For each site, PD numbers run from 1 to n.
BIGINT  Uncoded Value Provenience and Context : Horizontal Location none none true
CF A "c" indicates a bone for which there is a low level of confidence in identification
VARCHAR  Uncoded Value Fauna : Condition none none true
ELEMENT_TYPE The portion of the body tow which the faunal element belongs
BIGINT  Coded Value Fauna : Element Soil Systems, Inc. Faunal Elements Coding Sheet none true
SPECIES The species designation of the faunal specimen. Please refer to Soil Systems, Inc. Faunal Species Coding Sheet for a complete list of available faunal species.
BIGINT  Coded Value Fauna : Taxon Soil Systems, Inc. Faunal Species Coding Sheet 2008 none true
FEATURE_TYPE The inferred type (i.e., function and/or cultural use, significance) of a given feature. Please refer to Soil Systems, Inc. Feature Type Coding Sheet for a list of available feature types.
BIGINT  Coded Value Provenience and Context : Feature ID/Number Soil Systems, Inc. Feature Type Coding Sheet none true
BONE_ARTIFACTS If a faunal element was crafted into an artifact form, the analyst would indicate that the element is an artifact and the type of artifact. Please refer to Soil Systems, Inc. Faunal Artifact Type Coding Sheet for a list of faunal artifact types.
BIGINT  Coded Value Fauna : Bone Artifact Form Soil Systems, Inc. Faunal Artifact Type Coding Sheet none true
FEATURE_NUMBER The number of a feature identified and documented in a given PD unit. At each site, feature numbers were assigned from 1 to n. Subfeature numbers include the associated feature number followed by a decimal; subfeature numbers begin at .01 for each feature. For example, the second subfeature excavated in Feature 15 is coded as 15.02.
DOUBLE  Uncoded Value Provenience and Context : Feature ID/Number none none true
COMMENTS This text field provides a space for additional comments about a faunal specimen.
BIGINT  Uncoded Value Fauna none none true
AUDIT_VERSION BIGINT  Uncoded Value uncategorized none none true
SITE The ASM number of the site under investigation.
VARCHAR  Uncoded Value Provenience and Context : Site none none true
BONE_PORTION The portion of a bone (i.e., vertebral body, diaphysis, articular end) that a faunal specimen represents. Please refer to Soil Systems, Inc. Faunal Bone Portion Coding Sheet for a complete list of bone portion types.
BIGINT  Coded Value Fauna : Portion/Proximal/Distal Soil Systems, Inc. Faunal Bone Portion Coding Sheet none true
BURNING The presence/absence and the type of burning observed on a faunal specimen. Please refer to Soil Systems, Inc. Faunal Remains Burning Coding Sheet for a complete list of burning condition codes.
BIGINT  Coded Value Fauna : Cultural Modification Soil Systems, Inc. Faunal Remains Burning Coding Sheet none true
SEX The inferred sex of the animal from which the faunal specimen came. Please refer to Soil Systems, Inc. Faunal Sex Coding Sheet for a list of faunal sex codes.
BIGINT  Coded Value Fauna : Sex Soil Systems, Inc. Faunal Sex Coding Sheet none true
SUPERIOR_INFERIOR BIGINT  Coded Value Fauna Soil Systems, Inc. Faunal Superior/Inferior Coding Sheet none true
UPPER_LOWER BIGINT  Coded Value Fauna Soil Systems, Inc. Faunal Upper/Lower Coding Sheet none true
DORSAL_VENTRAL BIGINT  Coded Value Fauna : Dorsal/Ventral Soil Systems, Inc. Faunal Dorsal/Ventral Coding Sheet none true
MEDIAL_LATERAL BIGINT  Coded Value Fauna Soil Systems, Inc. Faunal Medial/Lateral Coding Sheet none true
TIME_DATE_STAMP The date stamp generated by the Advanced Revelation (AREV) database software when the record was originally created in the data set.
BIGINT  Uncoded Value uncategorized none none true
WEIGHT The weight of a given faunal element.
BIGINT  Uncoded Value Fauna : Weight none none true
AGE The estimated age at death of the animal from which the faunal specimen came. Note that the analyst may record one of two types of age categories: 1) traditional age references (juvenile, adult, etc), or 2) epiphyseal fusion patterns (for long bone portions). Please refer to Soil Systems, Inc. Fauna Age Coding Sheet for a complete list of available age categories.
BIGINT  Coded Value Fauna : Age Soil Systems, Inc. Fauna Age Coding Sheet none true
MODIFICATION_3 The type of natural or cultural processes that have contributed to modification of the faunal element
BIGINT  Coded Value Fauna : Modification Soil Systems, Inc. Faunal Remains Modification Coding Sheet none true
MODIFICATION_1 The type of natural or cultural processes that have contributed to modification of the faunal element
BIGINT  Coded Value Fauna : Modification Soil Systems, Inc. Faunal Remains Modification Coding Sheet none true
MODIFICATION_2 The type of natural or cultural processes that have contributed to modification of the faunal element
BIGINT  Coded Value Fauna : Modification Soil Systems, Inc. Faunal Remains Modification Coding Sheet none true
HISTORIC If "H" is present, the bone is historic
BIGINT  Uncoded Value Fauna none none true
MINIMUM_NUMBER_OF_FRAGMENTS minimum number of bones (after refitting) or estimated minimum count (after potential refitting)
BIGINT  Uncoded Value Fauna : Count none none true
NUMBER_OF_FRAGMENTS actual number of fragments present
BIGINT  Uncoded Value Fauna : Count none none true
ELEMENT_NUMBER Where applicable, the number of a faunal element (e.g., 2nd metatarsal)
BIGINT  Uncoded Value Fauna : Element none none true

Keywords

Culture
Hohokam

Material
Fauna

Site Name
AZ U:9:1(ASM) • AZ U:9:7(ASM) • Pueblo Grande

Site Type
Ancient Earthwork • Ball Court • Canal or Canal Feature • Funerary and Burial Structures or Features • Hamlet / Village • Pit House / Earth Lodge • Platform Mound • Room Block / Compound / Pueblo

Investigation Types
Bioarchaeological Research • Data Recovery / Excavation • Records Search / Inventory Checking • Site Evaluation / Testing

Spatial Coverage

min long: -111.999; min lat: 33.436 ; max long: -111.972; max lat: 33.47 ;

Individual & Institutional Roles

Principal Investigator(s): Cory D. Breternitz

Project Director(s): Banks L. Leonard

Record Identifiers

Soil Systems Project No.(s): 97-02

Notes

General Note: These data were extracted from SSI's Advanced Revelation (AREV) relational database. The flat data set presented here represent a near complete extraction of the FAUNAL_DATA table in AREV database 97-02 DMB PG. The faunal data in the AREV FAUNAL_DATA table were incorrectly shifted, such that data were not in the correct columns. This incorrect shift remained even after the data were extracted into an ASCII file and then imported into an Excel file. The data set here has been re-shifted to the correct columns as accurately as possible and has been cleaned.

General Note: Please note that SSI recorded the Pueblo Grande number as AZ U:9:7(ASM), which is the designation for a portion of Pueblo Grande. The correct number for the site as a whole is AZ U:9:1(ASM).

File Information

  Name Size Creation Date Date Uploaded Access
97-02-dmb-testing-and-data-recovery_faunal_data_cleaned_with-f... 30.16kb Feb 4, 2013 12:58:23 PM Public
  • Translated version 97-02-dmb-testing-and-data-recovery_faunal_data_cleaned_with-f... (79.00kb)
    Data column(s) in this dataset have been associated with coding sheet(s) and translated:

    • This Resource is Part of the Following User Created Collections