The Arizona Paleoindian Projectile Point Survey - Database

Creator(s): Saul L. Hedquist

Year: 2011

Summary

Database for the Arizona Paleoindian Projectile Point Survey

Cite this Record

The Arizona Paleoindian Projectile Point Survey - Database. Saul L. Hedquist. 2011 ( tDAR id: 380917) ; doi:10.6067/XCV8028R60

Data Set Structure

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

Table Information: az_paleopoints

Column Name Data Type Type Category Coding Sheet Ontology
northing UTM
BIGINT  Uncoded Value uncategorized none none
easting UTM
BIGINT  Uncoded Value uncategorized none none
point_type TEXT  Uncoded Value uncategorized none none
haynes_name TEXT  Uncoded Value uncategorized none none
haynes_number TEXT  Uncoded Value uncategorized none none
elevation m
BIGINT  Uncoded Value uncategorized none none
basal_width_broken BOOLEAN  Uncoded Value uncategorized none none
max_thickness_broken BOOLEAN  Uncoded Value uncategorized none none
max_width_broken BOOLEAN  Uncoded Value uncategorized none none
max_length_broken BOOLEAN  Uncoded Value uncategorized none none
basal_width mm
BIGINT  Uncoded Value uncategorized none none
maximum_thickness mm
BIGINT  Uncoded Value uncategorized none none
maximum_width mm
BIGINT  Uncoded Value uncategorized none none
max_length mm
BIGINT  Uncoded Value uncategorized none none
curation TEXT  Uncoded Value uncategorized none none
land_ownership TEXT  Uncoded Value uncategorized none none
material_source if known
TEXT  Uncoded Value uncategorized none none
material_color TEXT  Uncoded Value uncategorized none none
hydrologic_unit TEXT  Uncoded Value uncategorized none none
biotic_community Brown and Lowe (1980)
TEXT  Uncoded Value uncategorized none none
physiographic_region Colorado Plateau, Southern Basin and Range, Transition Zone
TEXT  Uncoded Value uncategorized none none
image BOOLEAN  Uncoded Value uncategorized none none
basal_edges_ground BOOLEAN  Uncoded Value uncategorized none none
fluted BOOLEAN  Uncoded Value uncategorized none none
point_complete BOOLEAN  Uncoded Value uncategorized none none
references TEXT  Uncoded Value uncategorized none none
year_first_documented if applicable
TEXT  Uncoded Value uncategorized none none
finder TEXT  Uncoded Value uncategorized none none
material_type TEXT  Uncoded Value uncategorized none none
locational_accuracy e.g. GPS, estimate from map/legal description, general vicinity
TEXT  Uncoded Value uncategorized none none
general_context e.g. primary/stratified; surface; mixed/later
TEXT  Uncoded Value uncategorized none none
county TEXT  Uncoded Value uncategorized none none
site_name if applicable
TEXT  Uncoded Value uncategorized none none
point_complex Clovis, Folsom, Fluted-Unknown, Midland, Plainview, Agate Basin, Cody
TEXT  Uncoded Value uncategorized none none
SHAPE BLOB  Uncoded Value uncategorized none none
OBJECTID BIGINT  Uncoded Value uncategorized none none

Table Information: az_paleopoints_SHAPE_Index

Column Name Data Type Type Category Coding Sheet Ontology
MaxGY BIGINT  Uncoded Value uncategorized none none
MaxGX BIGINT  Uncoded Value uncategorized none none
MinGY BIGINT  Uncoded Value uncategorized none none
MinGX BIGINT  Uncoded Value uncategorized none none
IndexedObjectId BIGINT  Uncoded Value uncategorized none none

Table Information: az_paleosites

Column Name Data Type Type Category Coding Sheet Ontology
northing UTM
BIGINT  Uncoded Value uncategorized none none
easting UTM
BIGINT  Uncoded Value uncategorized none none
elevation m
BIGINT  Uncoded Value uncategorized none none
land_ownership TEXT  Uncoded Value uncategorized none none
hydrologic_unit TEXT  Uncoded Value uncategorized none none
biotic_community Brown and Lowe (1980)
TEXT  Uncoded Value uncategorized none none
physiographic_region e.g. Colorado Plateau, Southern Basin and Range, Transition Zone
TEXT  Uncoded Value uncategorized none none
references TEXT  Uncoded Value uncategorized none none
year_first_documented if applicable
TEXT  Uncoded Value uncategorized none none
locational_accuracy e.g. GPS, estimate from map/legal description
TEXT  Uncoded Value uncategorized none none
county TEXT  Uncoded Value uncategorized none none
site_name if applicable
TEXT  Uncoded Value uncategorized none none
point_complex Clovis, Folsom, Fluted-Unknown, Midland, Plainview, Agate Basin, Cody
TEXT  Uncoded Value uncategorized none none
SHAPE BLOB  Uncoded Value uncategorized none none
OBJECTID BIGINT  Uncoded Value uncategorized none none

Table Information: az_paleosites_SHAPE_Index

Column Name Data Type Type Category Coding Sheet Ontology
MaxGY BIGINT  Uncoded Value uncategorized none none
MaxGX BIGINT  Uncoded Value uncategorized none none
MinGY BIGINT  Uncoded Value uncategorized none none
MinGX BIGINT  Uncoded Value uncategorized none none
IndexedObjectId BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_AnnoSymbols

Column Name Data Type Type Category Coding Sheet Ontology
Symbol BLOB  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_AttrRules

Column Name Data Type Type Category Coding Sheet Ontology
DomainName TEXT  Uncoded Value uncategorized none none
FieldName TEXT  Uncoded Value uncategorized none none
Subtype BIGINT  Uncoded Value uncategorized none none
RuleID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_CodedDomains

Column Name Data Type Type Category Coding Sheet Ontology
CodedValues BLOB  Uncoded Value uncategorized none none
DomainID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_ColumnInfo

Column Name Data Type Type Category Coding Sheet Ontology
columnFlags BIGINT  Uncoded Value uncategorized none none
FieldName TEXT  Uncoded Value uncategorized none none
TableName TEXT  Uncoded Value uncategorized none none

Table Information: GDB_DatabaseLocks

Column Name Data Type Type Category Coding Sheet Ontology
MachineName TEXT  Uncoded Value uncategorized none none
UserName TEXT  Uncoded Value uncategorized none none
LockType BIGINT  Uncoded Value uncategorized none none
LockID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_DefaultValues

Column Name Data Type Type Category Coding Sheet Ontology
DefaultString TEXT  Uncoded Value uncategorized none none
DefaultNumber DOUBLE  Uncoded Value uncategorized none none
Subtype BIGINT  Uncoded Value uncategorized none none
FieldName TEXT  Uncoded Value uncategorized none none
ClassID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_Domains

Column Name Data Type Type Category Coding Sheet Ontology
SplitPolicy BIGINT  Uncoded Value uncategorized none none
MergePolicy BIGINT  Uncoded Value uncategorized none none
FieldType BIGINT  Uncoded Value uncategorized none none
Description TEXT  Uncoded Value uncategorized none none
DomainType BIGINT  Uncoded Value uncategorized none none
DomainName TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_EdgeConnRules

Column Name Data Type Type Category Coding Sheet Ontology
Junctions BLOB  Uncoded Value uncategorized none none
ToSubtype BIGINT  Uncoded Value uncategorized none none
ToClassID BIGINT  Uncoded Value uncategorized none none
FromSubtype BIGINT  Uncoded Value uncategorized none none
FromClassID BIGINT  Uncoded Value uncategorized none none
RuleID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_ExtensionDatasets

Column Name Data Type Type Category Coding Sheet Ontology
DatasetType BIGINT  Uncoded Value uncategorized none none
Properties BLOB  Uncoded Value uncategorized none none
DatasetID BIGINT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
DatabaseName TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_Extensions

Column Name Data Type Type Category Coding Sheet Ontology
CLSID TEXT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_FeatureClasses

Column Name Data Type Type Category Coding Sheet Ontology
GraphID BIGINT  Uncoded Value uncategorized none none
GeomNetworkID BIGINT  Uncoded Value uncategorized none none
ShapeField TEXT  Uncoded Value uncategorized none none
GeometryType BIGINT  Uncoded Value uncategorized none none
FeatureType BIGINT  Uncoded Value uncategorized none none
ObjectClassID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_FeatureDataset

Column Name Data Type Type Category Coding Sheet Ontology
SRID BIGINT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
DatabaseName TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_FieldInfo

Column Name Data Type Type Category Coding Sheet Ontology
IsEditable BIGINT  Uncoded Value uncategorized none none
IsSubtypeFixed BIGINT  Uncoded Value uncategorized none none
IsRequired BIGINT  Uncoded Value uncategorized none none
DefaultValueNumber DOUBLE  Uncoded Value uncategorized none none
DefaultValueString TEXT  Uncoded Value uncategorized none none
DefaultDomainName TEXT  Uncoded Value uncategorized none none
ModelName TEXT  Uncoded Value uncategorized none none
AliasName TEXT  Uncoded Value uncategorized none none
ClassID BIGINT  Uncoded Value uncategorized none none
FieldName TEXT  Uncoded Value uncategorized none none

Table Information: GDB_GeomColumns

Column Name Data Type Type Category Coding Sheet Ontology
MHigh DOUBLE  Uncoded Value uncategorized none none
MLow DOUBLE  Uncoded Value uncategorized none none
ZHigh DOUBLE  Uncoded Value uncategorized none none
ZLow DOUBLE  Uncoded Value uncategorized none none
HasM BOOLEAN  Uncoded Value uncategorized none none
HasZ BOOLEAN  Uncoded Value uncategorized none none
SRID BIGINT  Uncoded Value uncategorized none none
IdxGridSize DOUBLE  Uncoded Value uncategorized none none
IdxOriginY DOUBLE  Uncoded Value uncategorized none none
IdxOriginX DOUBLE  Uncoded Value uncategorized none none
ExtentTop DOUBLE  Uncoded Value uncategorized none none
ExtentRight DOUBLE  Uncoded Value uncategorized none none
ExtentBottom DOUBLE  Uncoded Value uncategorized none none
ExtentLeft DOUBLE  Uncoded Value uncategorized none none
ShapeType BIGINT  Uncoded Value uncategorized none none
FieldName TEXT  Uncoded Value uncategorized none none
TableName TEXT  Uncoded Value uncategorized none none

Table Information: GDB_JnConnRules

Column Name Data Type Type Category Coding Sheet Ontology
IsDefault BIGINT  Uncoded Value uncategorized none none
JunctionMaxCard BIGINT  Uncoded Value uncategorized none none
JunctionMinCard BIGINT  Uncoded Value uncategorized none none
EdgeMaxCard BIGINT  Uncoded Value uncategorized none none
EdgeMinCard BIGINT  Uncoded Value uncategorized none none
JunctionSubtype BIGINT  Uncoded Value uncategorized none none
JunctionClassID BIGINT  Uncoded Value uncategorized none none
EdgeSubtype BIGINT  Uncoded Value uncategorized none none
EdgeClassID BIGINT  Uncoded Value uncategorized none none
RuleID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_ObjectClasses

Column Name Data Type Type Category Coding Sheet Ontology
SubtypeField TEXT  Uncoded Value uncategorized none none
DatasetID BIGINT  Uncoded Value uncategorized none none
EXTPROPS BLOB  Uncoded Value uncategorized none none
EXTCLSID TEXT  Uncoded Value uncategorized none none
CLSID TEXT  Uncoded Value uncategorized none none
ModelName TEXT  Uncoded Value uncategorized none none
AliasName TEXT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
DatabaseName TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_RangeDomains

Column Name Data Type Type Category Coding Sheet Ontology
MaxValue DOUBLE  Uncoded Value uncategorized none none
MinValue DOUBLE  Uncoded Value uncategorized none none
DomainID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_RasterCatalogs

Column Name Data Type Type Category Coding Sheet Ontology
IsRasterDataset BIGINT  Uncoded Value uncategorized none none
RasterField TEXT  Uncoded Value uncategorized none none
ObjectClassID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_RelClasses

Column Name Data Type Type Category Coding Sheet Ontology
DatasetID BIGINT  Uncoded Value uncategorized none none
DestForeignKey TEXT  Uncoded Value uncategorized none none
OriginForeignKey TEXT  Uncoded Value uncategorized none none
DestPrimaryKey TEXT  Uncoded Value uncategorized none none
OriginPrimaryKey TEXT  Uncoded Value uncategorized none none
IsAttributed BIGINT  Uncoded Value uncategorized none none
IsComposite BIGINT  Uncoded Value uncategorized none none
Notification BIGINT  Uncoded Value uncategorized none none
Cardinality BIGINT  Uncoded Value uncategorized none none
BackwardLabel TEXT  Uncoded Value uncategorized none none
ForwardLabel TEXT  Uncoded Value uncategorized none none
DestClassID BIGINT  Uncoded Value uncategorized none none
OriginClassID BIGINT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
DatabaseName TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_ReleaseInfo

Column Name Data Type Type Category Coding Sheet Ontology
Bugfix BIGINT  Uncoded Value uncategorized none none
Minor BIGINT  Uncoded Value uncategorized none none
Major BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_RelRules

Column Name Data Type Type Category Coding Sheet Ontology
DestMaxCard BIGINT  Uncoded Value uncategorized none none
DestMinCard BIGINT  Uncoded Value uncategorized none none
DestSubtype BIGINT  Uncoded Value uncategorized none none
OriginMaxCard BIGINT  Uncoded Value uncategorized none none
OriginMinCard BIGINT  Uncoded Value uncategorized none none
OriginSubtype BIGINT  Uncoded Value uncategorized none none
RuleID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_ReplicaDatasets

Column Name Data Type Type Category Coding Sheet Ontology
ParentDB TEXT  Uncoded Value uncategorized none none
ParentOwner TEXT  Uncoded Value uncategorized none none
DatasetID BIGINT  Uncoded Value uncategorized none none
DatasetType BIGINT  Uncoded Value uncategorized none none
ReplicaID BIGINT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_ReplicaLog

Column Name Data Type Type Category Coding Sheet Ontology
TargetGen BIGINT  Uncoded Value uncategorized none none
SourceEndGen BIGINT  Uncoded Value uncategorized none none
SourceBeginGen BIGINT  Uncoded Value uncategorized none none
LogDate DATETIME  Uncoded Value uncategorized none none
ErrorCode BIGINT  Uncoded Value uncategorized none none
Event BIGINT  Uncoded Value uncategorized none none
ReplicaID BIGINT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_Replicas

Column Name Data Type Type Category Coding Sheet Ontology
Role BIGINT  Uncoded Value uncategorized none none
RepCInfo TEXT  Uncoded Value uncategorized none none
RepGuid TEXT  Uncoded Value uncategorized none none
DefQuery BLOB  Uncoded Value uncategorized none none
RepDate DATETIME  Uncoded Value uncategorized none none
ParentID BIGINT  Uncoded Value uncategorized none none
Version TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_ReplicasEx

Column Name Data Type Type Category Coding Sheet Ontology
DProps BLOB  Uncoded Value uncategorized none none
RProps BLOB  Uncoded Value uncategorized none none
ReplicaID BIGINT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_SpatialRefs

Column Name Data Type Type Category Coding Sheet Ontology
MTolerance DOUBLE  Uncoded Value uncategorized none none
ZTolerance DOUBLE  Uncoded Value uncategorized none none
XYTolerance DOUBLE  Uncoded Value uncategorized none none
IsHighPrecision BIGINT  Uncoded Value uncategorized none none
MUnits DOUBLE  Uncoded Value uncategorized none none
FalseM DOUBLE  Uncoded Value uncategorized none none
ZUnits DOUBLE  Uncoded Value uncategorized none none
FalseZ DOUBLE  Uncoded Value uncategorized none none
XYUnits DOUBLE  Uncoded Value uncategorized none none
FalseY DOUBLE  Uncoded Value uncategorized none none
FalseX DOUBLE  Uncoded Value uncategorized none none
SRTEXT TEXT  Uncoded Value uncategorized none none
SRID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_Subtypes

Column Name Data Type Type Category Coding Sheet Ontology
SubtypeName TEXT  Uncoded Value uncategorized none none
SubtypeCode BIGINT  Uncoded Value uncategorized none none
ClassID BIGINT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_Toolboxes

Column Name Data Type Type Category Coding Sheet Ontology
HelpContext BIGINT  Uncoded Value uncategorized none none
HelpFile TEXT  Uncoded Value uncategorized none none
Alias TEXT  Uncoded Value uncategorized none none
DisplayName TEXT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
DatabaseName TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_TopoClasses

Column Name Data Type Type Category Coding Sheet Ontology
EventsOnAnalyze BIGINT  Uncoded Value uncategorized none none
ZRank BIGINT  Uncoded Value uncategorized none none
XYRank BIGINT  Uncoded Value uncategorized none none
Weight DOUBLE  Uncoded Value uncategorized none none
TopologyID BIGINT  Uncoded Value uncategorized none none
ClassID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_Topologies

Column Name Data Type Type Category Coding Sheet Ontology
Properties BLOB  Uncoded Value uncategorized none none
DatasetID BIGINT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
DatabaseName TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_TopoRules

Column Name Data Type Type Category Coding Sheet Ontology
RuleGUID TEXT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
TopologyRuleType BIGINT  Uncoded Value uncategorized none none
AllDestSubtypes BIGINT  Uncoded Value uncategorized none none
DestSubtype BIGINT  Uncoded Value uncategorized none none
DestClassID BIGINT  Uncoded Value uncategorized none none
AllOriginSubtypes BIGINT  Uncoded Value uncategorized none none
OriginSubtype BIGINT  Uncoded Value uncategorized none none
OriginClassID BIGINT  Uncoded Value uncategorized none none
RuleID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_UserMetadata

Column Name Data Type Type Category Coding Sheet Ontology
Xml BLOB  Uncoded Value uncategorized none none
DatasetType BIGINT  Uncoded Value uncategorized none none
Name TEXT  Uncoded Value uncategorized none none
Owner TEXT  Uncoded Value uncategorized none none
DatabaseName TEXT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: GDB_ValidRules

Column Name Data Type Type Category Coding Sheet Ontology
HelpString TEXT  Uncoded Value uncategorized none none
RuleCategory BIGINT  Uncoded Value uncategorized none none
ClassID BIGINT  Uncoded Value uncategorized none none
RuleType BIGINT  Uncoded Value uncategorized none none
ID BIGINT  Uncoded Value uncategorized none none

Table Information: SelectedObjects

Column Name Data Type Type Category Coding Sheet Ontology
ObjectID BIGINT  Uncoded Value uncategorized none none
SelectionID BIGINT  Uncoded Value uncategorized none none

Table Information: Selections

Column Name Data Type Type Category Coding Sheet Ontology
TargetName TEXT  Uncoded Value uncategorized none none
SelectionID BIGINT  Uncoded Value uncategorized none none

Temporal Coverage

Radiocarbon Date: 11500 to 8000 (BP)

Spatial Coverage

min long: -115.598; min lat: 30.827 ; max long: -108.545; max lat: 37.283 ;

Individual & Institutional Roles

Contact(s): Saul L. Hedquist

Notes

General Note: Those interested in contributing information to the statewide database are encouraged to visit http://azpaleosurvey.pidba.org/ and http://pidba.utk.edu/arizona.htm, or email questions, comments, and/or suggestions to azpaleosurvey@gmail.com. Researchers interested in using statewide and continental Paleoindian projectile point databases to reconstruct human colonization are referred to the PIDBA website, available at http://pidba.utk.edu/main.htm.

File Information

  Name Size Creation Date Date Uploaded Access
az-paleoindian-point-survey.mdb 19.15mb Jan 12, 2013 10:20:05 PM Public