Lake George: Primary Project Documents - Access Database

Part of the Lake George Survey project

Creator(s): Dean Snow

Year: 1979

Summary

An Access database containing information related to sites investigated during the Lake George regional survey project.

Cite this Record

Lake George: Primary Project Documents - Access Database. Dean Snow. 1979 ( tDAR id: 371675) ; doi:10.6067/XCV8F18XP5

Data Set Structure

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

Table Information: Austin

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
Site Name TEXT  Uncoded Value uncategorized none none true
Site Number TEXT  Uncoded Value uncategorized none none true
Field Number TEXT  Uncoded Value uncategorized none none true
Catalog Number BIGINT  Uncoded Value uncategorized none none true
Control Number BIGINT  Uncoded Value uncategorized none none true
Quantity BIGINT  Uncoded Value uncategorized none none true
Type TEXT  Uncoded Value uncategorized none none true
Material TEXT  Uncoded Value uncategorized none none true
Object TEXT  Uncoded Value uncategorized none none true
Photo TEXT  Uncoded Value uncategorized none none true
Locus BIGINT  Uncoded Value uncategorized none none true
Excavation Unit TEXT  Uncoded Value uncategorized none none true
Level TEXT  Uncoded Value uncategorized none none true
Depth BIGINT  Uncoded Value uncategorized none none true
Coordinates TEXT  Uncoded Value uncategorized none none true
Quad TEXT  Uncoded Value uncategorized none none true
Feature TEXT  Uncoded Value uncategorized none none true
Date DATETIME  Uncoded Value uncategorized none none true
Excavator 1 TEXT  Uncoded Value uncategorized none none true
Excavator 2 TEXT  Uncoded Value uncategorized none none true
Comment TEXT  Uncoded Value uncategorized none none true

Table Information: Bacon Pond

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

Table Information: Clark

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
Site Name TEXT  Uncoded Value uncategorized none none true
Catalog Number BIGINT  Uncoded Value uncategorized none none true
Control Number BIGINT  Uncoded Value uncategorized none none true
Quantity BIGINT  Uncoded Value uncategorized none none true
Type TEXT  Uncoded Value uncategorized none none true
Material TEXT  Uncoded Value uncategorized none none true
Object TEXT  Uncoded Value uncategorized none none true
Photo TEXT  Uncoded Value uncategorized none none true
Locus BIGINT  Uncoded Value uncategorized none none true
Excavation Unit TEXT  Uncoded Value uncategorized none none true
Level TEXT  Uncoded Value uncategorized none none true
Coordinates TEXT  Uncoded Value uncategorized none none true
Quad TEXT  Uncoded Value uncategorized none none true
Feature TEXT  Uncoded Value uncategorized none none true
Date DATETIME  Uncoded Value uncategorized none none true
Excavator 1 TEXT  Uncoded Value uncategorized none none true
Excavator 2 TEXT  Uncoded Value uncategorized none none true
Comment TEXT  Uncoded Value uncategorized none none true
Depth TEXT  Uncoded Value uncategorized none none true
Field Number BIGINT  Uncoded Value uncategorized none none true
Site Number TEXT  Uncoded Value uncategorized none none true
BN TEXT  Uncoded Value uncategorized none none true

Table Information: Material

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

Table Information: Minor Lake George Assemblages

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
Field Number TEXT  Uncoded Value uncategorized none none true
Catalog Number BIGINT  Uncoded Value uncategorized none none true
Control Number BIGINT  Uncoded Value uncategorized none none true
Quantity BIGINT  Uncoded Value uncategorized none none true
Type TEXT  Uncoded Value uncategorized none none true
Photo TEXT  Uncoded Value uncategorized none none true
Locus BIGINT  Uncoded Value uncategorized none none true
Excavation Unit TEXT  Uncoded Value uncategorized none none true
Level TEXT  Uncoded Value uncategorized none none true
Coordinates TEXT  Uncoded Value uncategorized none none true
Quad TEXT  Uncoded Value uncategorized none none true
Feature TEXT  Uncoded Value uncategorized none none true
Date DATETIME  Uncoded Value uncategorized none none true
Excavator 1 TEXT  Uncoded Value uncategorized none none true
Excavator 2 TEXT  Uncoded Value uncategorized none none true
Comment TEXT  Uncoded Value uncategorized none none true
Material BIGINT  Uncoded Value uncategorized none none true
Object BIGINT  Uncoded Value uncategorized none none true
Site Name BIGINT  Uncoded Value uncategorized none none true
Site Number BIGINT  Uncoded Value uncategorized none none true
Depth TEXT  Uncoded Value uncategorized none none true

Table Information: Object

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

Table Information: Paste Errors

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
Site Name TEXT  Uncoded Value uncategorized none none true
Site Number TEXT  Uncoded Value uncategorized none none true
Field Number TEXT  Uncoded Value uncategorized none none true
Catalog Number BIGINT  Uncoded Value uncategorized none none true
Control Number BIGINT  Uncoded Value uncategorized none none true
Quantity BIGINT  Uncoded Value uncategorized none none true
Type TEXT  Uncoded Value uncategorized none none true
Material TEXT  Uncoded Value uncategorized none none true
Object TEXT  Uncoded Value uncategorized none none true
Photo TEXT  Uncoded Value uncategorized none none true
Locus BIGINT  Uncoded Value uncategorized none none true
Excavation Unit TEXT  Uncoded Value uncategorized none none true
Level TEXT  Uncoded Value uncategorized none none true
Depth TEXT  Uncoded Value uncategorized none none true
Coordinates TEXT  Uncoded Value uncategorized none none true
Quad TEXT  Uncoded Value uncategorized none none true
Feature TEXT  Uncoded Value uncategorized none none true
Date DATETIME  Uncoded Value uncategorized none none true
Excavator 1 TEXT  Uncoded Value uncategorized none none true
Excavator 2 TEXT  Uncoded Value uncategorized none none true
Comment TEXT  Uncoded Value uncategorized none none true

Table Information: Quadrangles

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

Table Information: Site File

Column Name Data Type Type Category Coding Sheet Ontology Search
ID BIGINT  Uncoded Value uncategorized none none true
Site Name TEXT  Uncoded Value uncategorized none none true
Site Number TEXT  Uncoded Value uncategorized none none true
Lab Location TEXT  Uncoded Value uncategorized none none true
Sample Cell BIGINT  Uncoded Value uncategorized none none true
Quadrangle BIGINT  Uncoded Value uncategorized none none true
OPRHP Number TEXT  Uncoded Value uncategorized none none true

Data Table Relationships:

Type Local Table Foreign Table Column Relationships
ONE_TO_MANY Site File Minor Lake George Assemblages ID Site Name
ONE_TO_MANY Quadrangles Site File ID Quadrangle
ONE_TO_MANY Object Minor Lake George Assemblages ID Object
ONE_TO_MANY Material Minor Lake George Assemblages ID Material

Spatial Coverage

min long: -73.916; min lat: 43.333 ; max long: -73.386; max lat: 43.662 ;

Individual & Institutional Roles

Principal Investigator(s): Dean Snow

File Information

  Name Size Creation Date Date Uploaded Access
lake-george-project.mdb 7.68mb Nov 4, 2011 9:33:07 AM Public