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

Summary

The Sun America Data Recovery and Burial Removal Photography Log (PHOTO) Data sheet contains basic information about the photographs taken during the Sun America data recovery effort at Pueblo Grande. The data set may be used to locate photographs for additional research. The Sun America Data Recovery photographs are curated at the Arizona State Museum.

Cite this Record

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

Data Set Structure

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

Table Information: PHOTODAT

Column Name Data Type Type Category Coding Sheet Ontology Search
PHOTOGRAPHER The initials of the person who took the photograph.
VARCHAR  Uncoded Value Photograph : Other none none true
PROJECT The SSI project number for which the photograph was taken.
VARCHAR  Uncoded Value Provenience and Context : Project none none true
ROLL_ID Identifies the roll of film on which a photo was taken. Letter ids (A, B, C, etc) were used to identify color rolls. Number ids (1,2,3, etc) were used to identify black/white rolls. It is important that the ROLL-ID # and the FRAME # remain associated in order to identify photographs. For each ROLL-ID, the FRAME #s range from 1 to the last frame number for that roll.
VARCHAR  Uncoded Value Photograph : Roll 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 ID/Number Soil Systems, Inc. Feature Type Coding Sheet none true
SUBJECT_CODE This is a coded value. However, unable to locate the coding form.
BIGINT  Uncoded Value Photograph : Subject none none true
FACING The direction that the camera was facing when the photograph was taken.
VARCHAR  Uncoded Value Photograph : Direction none none true
FILM The type of film (i.e., color or black/white) used to take the photograph.
VARCHAR  Uncoded Value Photograph : Film Type none none true
DATE The date that the photograph was taken.
VARCHAR  Uncoded Value Photograph : Other none none true
ARTIFACT_GROUP BIGINT  Uncoded Value uncategorized none none true
SUBJECT BIGINT  Uncoded Value Photograph : Subject none none true
FRAME The frame number for a given photograph. It is important that the ROLL-ID # and the FRAME # remain associated in order to identify photographs. For each ROLL-ID, the FRAME #s range from 1 to the last frame number for that roll.
BIGINT  Uncoded Value Photograph : Frame none none true
SITE The ASM number of the site where the photo was taken.
VARCHAR  Uncoded Value Provenience and Context : Site none none true
FS BIGINT  Uncoded Value uncategorized none none true
TRENCH_NUMBER The number of a given trench in a photograph.
BIGINT  Uncoded Value Provenience and Context : Horizontal Location none none true
FEATURE_NUMBER The number of a feature in a given photo. 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
OTHER_INFO A basic description of the the scene in the photograph. In general, the field contains a brief description of the context (e.g., portion of the site, unit area, and/or feature numbers) and the state of the items being photographed. "FINAL" designates a photograph of an excavated feature after all investigation has ended. "ROLL ID" designates a photo that identifies the roll.
VARCHAR  Uncoded Value Photograph : Subject none none true
PD BIGINT  Uncoded Value uncategorized none none true
OTHER_ARTIFACT_INFO BIGINT  Uncoded Value uncategorized none none true

Spatial Coverage

min long: -112.004; min lat: 33.428 ; max long: -111.965; max lat: 33.473 ;

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

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_photo_data.xlsx 148.36kb Feb 1, 2013 4:24:00 PM Public
  • Translated version 97-24-sun-america_photo_data_translated.xls (553.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