Summary

Comprehensive artifact catalog for the Archaeological Study of Colonial Chesapeake Culture project, an NEH-funded comparative analysis of 18 early seventeenth-century archaeological sites in the Chesapeake region. The artifact catalog, composed of about 186,000 records, was created from the individual artifact catalogs for the 18 sites, combined and standardized into a single MS Access database.

The associated manual and coding conventions documents (below) explain in detail how to use the database effectively.

Linked to the Manual for the use of the comprehensive artifact catalog and to the Coding Conventions for the comprehensive artifact catalog.

More specific description or modifier (e.g., "felling" is a subtype of "axe")

TEXT

Uncoded Value

uncategorized

none

none

ObjectType

Description of the artifact

TEXT

Uncoded Value

uncategorized

none

none

WeightG

The weight of the artifacts identified, in grams

DOUBLE

Uncoded Value

uncategorized

none

none

WeightOz

The weight of the artifacts identified, in ounces

DOUBLE

Uncoded Value

uncategorized

none

none

ContextNumber

An arbitrary number often assigned by the original collection repository. The context number creates a relationship between the artifact and provenience information. The number often is given as a Lot number or Excavation Unit number

Value of the northwest corner coordinate of the excavation unit in meters from arbitrary datum

DOUBLE

Uncoded Value

uncategorized

none

none

GridNorthCoord

Value of the northwest corner coordinate of the excavation unit in meters from arbitrary datum

DOUBLE

Uncoded Value

uncategorized

none

none

CenterY

North coordinate used for distribution mapping, derived by determining the center point of the excavation unit

DOUBLE

Uncoded Value

uncategorized

none

none

CenterX

East coordinate used for distribution mapping, derived by determining the center point of the excavation unit

DOUBLE

Uncoded Value

uncategorized

none

none

ContextDescription

Original context description

TEXT

Uncoded Value

uncategorized

none

none

ShortTitle

Field used to standardize context descriptions

TEXT

Uncoded Value

uncategorized

none

none

DepositSubType

Field used to standardize context descriptions

TEXT

Uncoded Value

uncategorized

none

none

DepositType

Field used to standardize context descriptions

TEXT

Uncoded Value

uncategorized

none

none

ContextNumber

An arbitrary number often assigned by the original collection repository. The context number creates a relationship between the artifact and provenience information. The number often is given as a Lot number or Excavation Unit number

TEXT

Uncoded Value

uncategorized

none

none

SiteName

Site name

TEXT

Uncoded Value

uncategorized

none

none

Site

The official state site number

TEXT

Uncoded Value

uncategorized

none

none

NoOfArtifacts

Number of fragments associated with this provenience in artifact table

BIGINT

Uncoded Value

uncategorized

none

none

NoOfRecords

Number of records associated with this provenience in artifact table

BIGINT

Uncoded Value

uncategorized

none

none

KeyID

Arbitrary record number used for linking with other tables

BIGINT

Uncoded Value

uncategorized

none

none

Table Information: dbo_DepositTypes

Column Name

Data Type

Type

Category

Coding Sheet

Ontology

DepositSubType

TEXT

Uncoded Value

uncategorized

none

none

DepositType

TEXT

Uncoded Value

uncategorized

none

none

Table Information: ImageCategories

Column Name

Data Type

Type

Category

Coding Sheet

Ontology

PhotoType

Section of web site to which category is applied (Artifact Gallery, Artifact Distributions, or Midden Analysis)

TEXT

Uncoded Value

uncategorized

none

none

Category

Category name

TEXT

Uncoded Value

uncategorized

none

none

CategoryID

Category ID, primary key

BIGINT

Uncoded Value

uncategorized

none

none

Table Information: Images

Column Name

Data Type

Type

Category

Coding Sheet

Ontology

ID

Original ID number

BIGINT

Uncoded Value

uncategorized

none

none

OrigFileName

Original file name

TEXT

Uncoded Value

uncategorized

none

none

MainGalleryPage

Order to display on web site

TEXT

Uncoded Value

uncategorized

none

none

CreditLine

Credit line

TEXT

Uncoded Value

uncategorized

none

none

CxtObjNumber

Provenience

TEXT

Uncoded Value

uncategorized

none

none

PhotoDetailedCaption

Detailed caption

TEXT

Uncoded Value

uncategorized

none

none

PhotoCaption

Caption

TEXT

Uncoded Value

uncategorized

none

none

SidebarCaption

Caption to show in sidebar

TEXT

Uncoded Value

uncategorized

none

none

PhotoFileName

File name

TEXT

Uncoded Value

uncategorized

none

none

PhotoType

Section of web site to which category is applied (Artifact Gallery, Artifact Distributions, or Midden Analysis)

TEXT

Uncoded Value

uncategorized

none

none

SiteAbbrev

Site abbreviation

TEXT

Uncoded Value

uncategorized

none

none

ImageID

Auto-incremented ID number, primary key

BIGINT

Uncoded Value

uncategorized

none

none

Table Information: ImagesToImageCategories

Column Name

Data Type

Type

Category

Coding Sheet

Ontology

CategoryID

Category ID value from ImageCategories table, used for linking Images to ImageCategories

BIGINT

Uncoded Value

uncategorized

none

none

ImageID

Image ID value from Images table, used for linking Images to ImageCategories