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

Table Information: az_paleopoints_SHAPE_Index

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

Table Information: az_paleosites

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

Table Information: az_paleosites_SHAPE_Index

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

Table Information: GDB_AnnoSymbols

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

Table Information: GDB_AttrRules

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

Table Information: GDB_CodedDomains

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

Table Information: GDB_ColumnInfo

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

Table Information: GDB_DatabaseLocks

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

Table Information: GDB_DefaultValues

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

Table Information: GDB_Domains

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

Table Information: GDB_EdgeConnRules

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

Table Information: GDB_ExtensionDatasets

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

Table Information: GDB_Extensions

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

Table Information: GDB_FeatureClasses

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

Table Information: GDB_FeatureDataset

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

Table Information: GDB_FieldInfo

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

Table Information: GDB_GeomColumns

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

Table Information: GDB_JnConnRules

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

Table Information: GDB_ObjectClasses

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

Table Information: GDB_RangeDomains

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

Table Information: GDB_RasterCatalogs

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

Table Information: GDB_RelClasses

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

Table Information: GDB_ReleaseInfo

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

Table Information: GDB_RelRules

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

Table Information: GDB_ReplicaDatasets

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

Table Information: GDB_ReplicaLog

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

Table Information: GDB_Replicas

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

Table Information: GDB_ReplicasEx

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

Table Information: GDB_SpatialRefs

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

Table Information: GDB_Subtypes

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

Table Information: GDB_Toolboxes

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

Table Information: GDB_TopoClasses

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

Table Information: GDB_Topologies

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

Table Information: GDB_TopoRules

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

Table Information: GDB_UserMetadata

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

Table Information: GDB_ValidRules

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

Table Information: SelectedObjects

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

Table Information: Selections

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

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