tDAR Logo tDAR digital antiquity

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

Creator(s): Maria Martin

Year: 1998

» Downloads & Basic Metadata

Summary

The DMB Utility Trench Monitoring Provenience Designation (PD) data sheet summarizes the PD's excavated during the project's data recovery efforts. It is the master list for all excavated contexts in the DMB trench monitoring effort. It contains information about each PD and the features recorded during excavation.


This Resource is Part of the Following Collections


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, Provenience Designation (PD) Data. Maria Martin. 1998 ( tDAR id: 372328) ; doi:10.6067/XCV8FX77N9


Data Set Structure

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

Table Information: PD_DATA

Column Name Data Type Type Category Coding Sheet Ontology
STRUCTURAL_UNIT The number designation of a defined structural unit. A structural unit is any further division of a PD unit. Structural units were defined by project directors of field directors during data recovery.
BIGINT  Uncoded Value Provenience and Context : Horizontal Location none none
COLLECTION_UNIT_NUMBER The number designation of a given collection unit. For each site, collection units are numbered in a series from 1 to n within each collection unit type. For example, at one site there may be a Surface Unit #1, and an Excavation Unit #1, and an Auger Test Unit #1. Backhoe trenches are also numbered consecutively per site. CU numbers are not assigned to all CU Types; they are not assigned to CU types that represent partial units and/or are voided contexts.
BIGINT  Uncoded Value Provenience and Context : Horizontal Location none none
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
AVERAGE_ENDING_ELEVATION The average ending elevation of a PD unit after excavation. All measurements are in meters. See the ELEVATION_REFERENCE column for the reference point (measured below datum, measured below ground surface, etc) for each elevation measurement.
DOUBLE  Measurement (meter) Provenience and Context : Vertical Position none none
UNIT_AREA_NUMBER The number designation of any unit division of a site. When a site is particularly large and/or the cultural deposits complex, the site director might choose to divide the site into units.
BIGINT  Uncoded Value Provenience and Context : Horizontal Location none none
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
PROJECT The SSI project number during which these PD units were defined/investigated/excavated.
VARCHAR  Uncoded Value Provenience and Context : Project none none
FEATURE_FILE_ID BIGINT  Uncoded Value uncategorized none none
PD The Provenience Designation (PD) number. A PD is any 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
STRUCTURAL_UNIT_TYPE The type description of a defined structural unit. Structural unit types include Stripping Area (SA), Habitation Area (HA), Burial Group (BG), etc. Please refer to Soil Systems, Inc. Structural Unit Type Coding Sheet for a complete list of structural unit type codes.
BIGINT  Coded Value Provenience and Context : Horizontal Location Soil Systems, Inc. Structural Unit Type Coding Sheet none
ELEVATION_REFERENCE The reference point (e.g., below datum, below ground surface, etc.) from which an elevation measurement was taken. Please refer to Soil Systems, Inc. Provenience Elevation Reference Coding Sheet for a list of elevation reference codes.
VARCHAR  Coded Value Provenience and Context : Vertical Position Soil Systems, Inc. Provenience Elevation Reference Coding Sheet none
AVERAGE_BEGINNING_ELEVATION The average beginning elevation of a PD unit prior to excavation. All measurements are in meters. See the ELEVATION_REFERENCE column for the reference point (measured below datum, measured below ground surface, etc) for each elevation measurement.
DOUBLE  Measurement (meter) Provenience and Context : Vertical Position none none
SITE The ASM number of the site under investigation.
VARCHAR  Uncoded Value Provenience and Context : Site none none
DATE_OPENED The date that a given PD unit was opened.
VARCHAR  Uncoded Value Provenience and Context : Other none none
DATE_CLOSED The date that a given PD unit was closed.
VARCHAR  Uncoded Value Provenience and Context : Other none none
RECORDER The initials of the individual(s) who documented and conducted data recovery in a given PD unit.
VARCHAR  Uncoded Value Provenience and Context : Recovery Method none none
LEVEL The number designation assigned to a level in a collection unit. Levels in a collection unit are numbered from 1 to n. The modern ground surface is designated level 0. Backhoe trenches, shovel skimming, backdirt, and stripping are also coded as level 0. For non-burial subfeatures, levels are designated as separate levels in that subfeature, and not as the level of the feature it is in. For burial features, levels are designated as separate levels in the burial pit and are numbered from 1 to n. This level designation system holds even in burial pits that contain multiple burials (and thus have subfeature numbers) in a single pit.
BIGINT  Uncoded Value Provenience and Context : Vertical Position none none
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
INTEGRITY A general assessment of the types and severity of disturbance that have impacted a given PD unit and associated cultural contexts. Please refer to Soil Systems, Inc. Provenience Integrity Coding Sheet for a list of available integrity descriptions.
BIGINT  Coded Value Provenience and Context : Context Soil Systems, Inc. Provenience Integrity Coding Sheet none
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
CONTEXT The archaeological context (i.e., cultural deposit) of a PD unit. The variable predominantly describes the vertical location of a PD unit (its stratigraphic position relative to cultural features). Please refer to Soil Systems, Inc. Context Coding Sheet for a list of all available context types.
BIGINT  Coded Value Provenience and Context : Context Soil Systems, Inc. Context Coding Sheet none
COLLECTION_UNIT_TYPE The type of collection unit (CU) from which a given artifact sample was taken. CU types include surface units (SU), Test Unit (TU), Excavation Unit (XU), Backhoe Trench (BHT), etc. Please refer to Soil Systems, Inc. Collection Unit Type Coding Sheet for a complete list of unit types.
BIGINT  Coded Value Provenience and Context : Horizontal Location Soil Systems, Inc. Collection Unit Type Coding Sheet none
COLLECTION_UNIT_SIZE The size (area in meters) of a given collection unit. Please refer to Soil Systems, Inc. Collection Unit Size Coding Sheet for a list of SSI's standardized collection unit sizes.
BIGINT  Coded Value Provenience and Context : Horizontal Location Soil Systems, Inc. Collection Unit Size Coding Sheet none
COLLECTION_METHOD The method used to collect artifact samples from a given collection unit. Please refer to Soil Systems, Inc. Collection Unit Method Coding Sheet for a list of all available collection methods.
BIGINT  Coded Value Provenience and Context : Recovery Method Soil Systems, Inc. Collection Unit Method Coding Sheet none

Keywords


Spatial Coverage

min long: -112.002; min lat: 33.444 ; max long: -111.975; max lat: 33.467 ;

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

General Note: The PD data from this project should be directly compatible with the PD 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 PD 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_pd_data.xlsx 13.72kb Feb 4, 2013 11:37:53 AM Public
Translated version 98-02-dmb-utility-trnch-monitor_pd_data_translated.xls (25.50kb)
Data column(s) in this dataset have been associated with coding sheet(s) and translated:
Arizona State University The Andrew W. Mellon Foundation National Science Foundation National Endowment for the Humanities Society for American Archaeology Archaeological Institute of America