Pueblo Grande (AZ U:9:1(ASM)): Unit 13, NE Corner of Van Buren and 44th Streets: SSI DMB Utility Trench Monitoring, Field Specimen (FS) Data

Creator(s): Maria Martin

Year: 1998

Summary

The DMB Utility Trench Monitoring project Field Specimen (FS) Data sheet contains basic artifact data for the cultural material recovered in each PD unit. It lists the PD number, the specimen (FS) number (specimen numbers range from 1 to n for each PD unit), and the point location (PL) number (if applicable). Please note that a combination of a PD number AND FS number is necessary to identify an artifact specimen. The table then provides data on artifact type, lithic material (if applicable), lithic condition (if applicable), and Vessel ID (if applicable) data. It also provides additional artifact processing and curation information.

Cite this Record

Pueblo Grande (AZ U:9:1(ASM)): Unit 13, NE Corner of Van Buren and 44th Streets: SSI DMB Utility Trench Monitoring, Field Specimen (FS) Data. Maria Martin. 1998 ( tDAR id: 372329) ; doi:10.6067/XCV857192G

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: 98-02-dmb-utility-trnch-monitor_fs_data_with-feature-no

Column Name Data Type Type Category Coding Sheet Ontology Search
ARTIFACT_TYPE The general artifact type of a given artifact specimen from a particular PD unit.
BIGINT  Coded Value uncategorized Soil Systems, Inc. Artifact Type Coding Sheet 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 all available feature types.
BIGINT  Coded Value Provenience and Context : Feature ID/Number Soil Systems, Inc. Feature Type Coding Sheet none true
LITHIC_MATERIAL The material type that best describes the raw material from which a lithic artifact is made. Please refer to Soil Systems, Inc. Material Type Coding Sheet for a list of all available lithic material types.
BIGINT  Coded Value Chipped Stone : Material Soil Systems, Inc. Lithic Material Type Coding Sheet none true
ANALYSIS_DATE The date when basic artifact analysis was performed on a given specimen.
BIGINT  Uncoded Value Storage : Other none none true
COMMENTS Additional description of and/or comments about a given artifact specimen.
VARCHAR  Uncoded Value uncategorized none none true
DEACCESS_COMMENTS Additional notes describing the de-accession of an artifact specimen (PD and FS).
BIGINT  Uncoded Value uncategorized none none true
AUDIT_VERSION The Soil Systems, Inc. relational database originally contained audit tables for each artifact/analysis type to track updates/changes made to the primary data tables. Database managers recorded changes to particular data values in these audit tables. The changes were then passed on to the main data table (e.g., RS_CERAMICS). The AUDIT_VERSION number refers to the "audit number" for that particular row. Thus, if a data row contains an AUDIT_VERSION value of "2", then that row has been updated/changed with the audit-version number 2 (i.e., it has been updated two times).
BIGINT  Uncoded Value uncategorized none none true
CATALOG BIGINT  Uncoded Value uncategorized none none true
BAG_DATE The date that an FS # was assigned to a bag of like artifacts in the field.
VARCHAR  Uncoded Value Storage : Other none 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 : Horizontal Location none none true
DEACCESS A presence/absence field that records de-accession of an artifact specimen (PD and FS specimen). In general, de-accession occurred when artifact samples were repatriated to affiliated tribal groups (predominantly Salt River Pima Maricopa).
BIGINT  Uncoded Value Storage : Other none none true
DETAILED A presence/absence field that records whether or not an SSI analyst performed additional, detailed artifact analysis on a given artifact specimen (PD and FS specimen).
BIGINT  Uncoded Value Storage : Other none none true
FS The field specimen number assigned to an artifact type from a given PD unit. Note that one FS # was assigned to multiple artifacts of the same type from a single PD unit. See detailed analysis data tables (i.e., ceramic tables, shell tables, etc) for artifact counts. 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 : Item/Slash none none true
PD The provenience designation (PD) unit from which a given FS was collected. It is essential that the PD number remain associated with the FS #. A combination of the PD unit No. and the FS No. identifies a unique FS from that unit.
BIGINT  Uncoded Value Provenience and Context : Horizontal Location none none true
PROJECT The SSI project number during which a given PD was defined/investigated/excavated.
VARCHAR  Uncoded Value Provenience and Context : Project none none true
LITHIC_TOTAL The total number of lithic artifacts in a given FS.
BIGINT  Uncoded Value Chipped Stone : Count none none true
PL A point location number assigned to a particular artifact or group of artifacts. When an artifact or group of artifacts were found in a particularly well-preserved and/or meaningful behavioral context (e.g., on a house floor, sealed beneath a vessel), the artifact or artifacts may have been mapped in place. These artifacts were assigned PL #s to identify them (and their associated individual spatial data). PL #s run from 1 to n in a given unit/feature. Each PL should be assigned a unique FS # (with some exceptions). It is essential to maintain the association of a PD No, Feature No, and PL No. to identify a specific point located artifact.
BIGINT  Uncoded Value Lookup : Label none none true
SITE The ASM number of the site under investigation.
VARCHAR  Uncoded Value Provenience and Context : Site none none true
VESSEL_ID When whole or reconstructible vessels were found in the field, SSI archaeologists assigned to a capital letter designation (A through Z) to identify individual vessels and any sherds that belonged to those vessels. This field records the letter (A through Z) that identifies an individual vessel and/or the sherds that comprise it. Vessel ID letters run from to A to Z in a given feature. It is essential that the PD No, the FS No., and the Vessel ID remain associated to identify a particular vessel and its pieces.
VARCHAR  Uncoded Value Ceramic none none true
TIME_DATE_STAMP The date stamp generated by the Advanced Revelation (AREV) database software when this FS record was originally created in the data set.
BIGINT  Uncoded Value uncategorized none none true
LITHIC_CONDITION The completeness (e.g., whole, fragmentary) of lithic artifacts in a given PD and FS.
BIGINT  Coded Value Chipped Stone : Form Soil Systems, Inc. Lithic Condition Coding Sheet none true
LITHIC_COMMENTS Additional description and/or notes on lithic artifacts in a given FS. If an artifact was categorized as "unidentified" or "other," it should be described in this field. Note that this field was typically NOT entered into the SSI's AREV digital database.
BIGINT  Uncoded Value Chipped Stone : Form none none true
FROM_FS During rough sort artifact analysis, any artifact that was categorized incorrectly and placed in the wrong FS bag in the field was re-categorized and placed in the correct FS. When an artifact was moved to the correct FS, the analyst recorded the original FS from which the artifact was removed in this column.
BIGINT  Uncoded Value Provenience and Context none none true
BOX_NUMBER The number of the curation box that holds a given artfiact PD and FS. The curation boxes were sent either to the Arizona State Museum (ASM) repository or to Pueblo Grande Museum for cataloging and storage.
BIGINT  Uncoded Value Storage : Box Number none none true

Keywords

Culture
Hohokam

Material
Ceramic • Chipped Stone • Fauna • Ground Stone • Shell

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

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

Investigation Types
Ground Disturbance Monitoring • Site Evaluation / Testing

Spatial Coverage

min long: -111.999; min lat: 33.438 ; max long: -111.972; max lat: 33.462 ;

Individual & Institutional Roles

Principal Investigator(s): Cory D. Breternitz

Project Director(s): Banks L. Leonard

Record Identifiers

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

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 FS data tables from this project and other Pueblo Grande projects were created in a table named FS_DATA, and saved in this table. The data sheet presented here has been extracted from the FS_DATA table in SSI's AREV database.

General Note: The FS data from this project should be directly compatible with the FS 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 FS data with the data from other SSI projects.

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
98-02-dmb-utility-trnch-monitor_fs_data_with-feature-no.xlsx 12.18kb Feb 4, 2013 11:34:42 AM Public
  • Translated version 98-02-dmb-utility-trnch-monitor_fs_data_with-feature-no_transl... (13.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