• Skip to main content
Alaska Vegetation Plots Database

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.

  • Home
  • Queries
    • Project Data
    • Site Data
    • Foliar Cover
    • Environment Data
  • Taxonomic Standard
    • Comprehensive Checklist
    • Vascular Plant Checklist
    • Bryophyte Checklist
    • Lichen Checklist
    • About the Checklist
  • Resources
    • Plant Associations
    • Database Schema
    • Data Dictionary
    • Vegetation Plot Map
    • Programmatic Access
  • Help

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.

© 2019 Alaska Center for Conservation Science.This website was designed and is maintained by the University of Alaska Anchorage-Alaska Center for Conservation Science (UAA-ACCS). The University of Alaska Anchorage is accredited by the Northwest Commission on Colleges and Universities. UA is an AA/EO employer and educational institution and prohibits illegal discrimination against any individual: UA Non-discrimination Policy.

Contact Website Administrator | Sitemap

Main Menu

  • Home
  • Queries
    • Project Data
    • Site Data
    • Foliar Cover
    • Environment Data
  • Taxonomic Standard
    • Comprehensive Checklist
    • Vascular Plant Checklist
    • Bryophyte Checklist
    • Lichen Checklist
    • About the Checklist
  • Resources
    • Plant Associations
    • Database Schema
    • Data Dictionary
    • Vegetation Plot Map
    • Programmatic Access
  • Help

Dynamic title for modals

Are you sure?

Please confirm deletion. There is no undo!