Alaska Vegetation Plots Database

Alaska Vegetation Plots Database (AKVEG) is a data repository for ecological and vegetation survey data from extensive, ground-based projects across Alaska.

Database Schema

The database schema is a tabular description of the structure, relationships, fields, and data types stored in AKVEG. For a list of all possible attribute values per constrained field, see the data dictionary.

ID Category Table Field Data Type Field Length Is Unique Is Key Required Link Table Description
ID Category Table Field Data Type Field Length Is Unique Is Key Required Link Table Description
1 environment disturbance disturbanceID smallint true true true Unique integer key value per disturbance.
2 environment disturbance disturbance varchar 50 true false true One to two word description of primary disturbance processes.
3 environment drainage drainageID smallint true true true Unique integer key value per drainage.
4 environment drainage drainage varchar 50 true false true One to two word description of water drainage regime.
5 environment environment environmentID serial true true true Unique integer key value per environmental site observation.
6 environment environment projectID smallint false true true project Foreign key value that links environmental observations to project.
7 environment environment siteID integer false true true site Foreign key value that links environmental observations to site.
8 environment environment envObserveDate date false false true Date of observation.
9 environment environment envObserverID smallint false true true personnel Foreign key value that identifies primary environmental observer.
10 environment environment soilObserverID smallint false true false personnel Foreign key value that identifies primary soils observer.