Pueblo Grande (AZ U:9:1(ASM)): Unit 14, Washington Park Development Area: SSI SunAmerica, Inc. Data Recovery, Faunal Data

Summary

The Sun America Data Recovery and Burial Removal Faunal (FAUNAL) Data sheet contains data on the faunal remains recovered during SSI's data recovery work in Unit 14 of Pueblo Grande (Soil Systems Project No. 97-24). 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.

Cite this Record

Pueblo Grande (AZ U:9:1(ASM)): Unit 14, Washington Park Development Area: SSI SunAmerica, Inc. Data Recovery, Faunal Data. Maria Martin. 2007 ( tDAR id: 374225) ; doi:10.6067/XCV88G8JTD

Data Set Structure

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

Table Information: 97-24-sun-america_faunal_data_with-feature-no

Column Name Data Type Type Category Coding Sheet Ontology Search
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
CONDITION BIGINT  Coded Value Fauna : Completeness Soil Systems, Inc. Faunal Remains Condition (Completeness) Coding Sheet none true
WITH_TEETH VARCHAR  Coded Value Fauna Soil Systems, Inc. Faunal Element With Teeth Coding Sheet 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
ANTERIOR_POSTERIOR BIGINT  Coded Value Fauna : Anterior/Posterior Soil Systems, Inc. Faunal Anterior/Posterior Coding Sheet none true
PROXIMAL_DISTAL VARCHAR  Coded Value Fauna : Portion/Proximal/Distal Soil Systems, Inc. Faunal Proximal/Distal 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
UPPER_LOWER VARCHAR  Coded Value Fauna Soil Systems, Inc. Faunal Upper/Lower 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
COMMENTS This text field provides a space for additional comments about a faunal specimen.
VARCHAR  Uncoded Value Fauna none none true
AUDIT_VERSION BIGINT  Uncoded Value uncategorized none 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 Type Soil Systems, Inc. Feature Type Coding Sheet none true
WEIGHT The weight of a given faunal element.
BIGINT  Uncoded Value Fauna : Weight none 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
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
PROJECT The SSI project number during which the faunal specimen was collected.
VARCHAR  Uncoded Value Provenience and Context : Project none none true
SITE The ASM number of the site under investigation.
VARCHAR  Uncoded Value Provenience and Context : Site none 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.
VARCHAR  Uncoded Value uncategorized none none true
MEDIAL_LATERAL BIGINT  Coded Value Fauna Soil Systems, Inc. Faunal Medial/Lateral Coding Sheet none true
DORSAL_VENTRAL BIGINT  Coded Value Fauna : Dorsal/Ventral Soil Systems, Inc. Faunal Dorsal/Ventral Coding Sheet none true
FRONT_HIND BIGINT  Coded Value Fauna Soil Systems, Inc. Faunal Front/Hind Coding Sheet 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
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.
BIGINT  Uncoded Value Provenience and Context : Feature ID/Number none none true
ARTIFACT_TYPE The type of artifact that the faunal bone represents
BIGINT  Coded Value Lookup : Code Soil Systems, Inc. Artifact Type Coding Sheet none true
NUMBER_OF_FRAGMENTS actual number of fragments present
BIGINT  Uncoded Value Fauna : Count 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
BONE_ARTIFACT If the faunal bone was shaped in an artifact (e.g., a tool), the type of artifact is coded here
BIGINT  Coded Value Fauna : Bone Artifact Form Soil Systems, Inc. Faunal Artifact Type Coding Sheet none true
ELEMENT_NUMBER Where applicable, the number of a faunal element (e.g., 2nd metatarsal)
BIGINT  Uncoded Value Fauna : Element none 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  Coded Value Fauna : Other Soil Systems, Inc. Faunal Historic Period 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
CF A "c" indicates a bone for which there is a low level of confidence in identification
BIGINT  Uncoded Value Fauna : Condition none 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
SIZE The relative size of the faunal element
BIGINT  Coded Value Fauna : Other Soil Systems, Inc. Faunal Element Size Coding Sheet none true

Spatial Coverage

min long: -111.996; min lat: 33.433 ; max long: -111.97; 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-24

Notes

General Note: Soil Systems analysts stored all provenience and artifact data for post-Hohokam Expressway Pueblo Grande projects in a relational database program called Advanced Revelations (AREV). The provenience and artifact data tables were standardized within this database. Thus, the Faunal data tables from this project and other Pueblo Grande projects were created in a table named FAUNAL_DATA, and saved in this table. The data sheet presented here has been extracted from the FAUNAL_DATA table in SSI's AREV database.

General Note: The Faunal data from this project should be directly compatible with the Faunal data from all other Soil Systems, Inc. Pueblo Grande projects, because the data were created in a standardized format (see above). Users can easily integrate this Faunal data with the data from other SSI projects.

General Note: When the Sun America Faunal Data were extracted from the AREV database, the data were incorrectly shifted across columns. The data presented here have been re-formatted and cleaned to restore the appropriate column headings to the correct data.

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-24-sun-america_faunal_data_with-feature-no.xlsx 43.78kb Feb 1, 2013 4:05:17 PM Public
  • Translated version 97-24-sun-america_faunal_data_with-feature-no_translated.xls (137.50kb)
    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