Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

detailstratumdba_tabledescriptionwhere_tablenamestratum

VegBank Data Dictionary: Tables

Search for a VegBank Table (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Table >>

Search VegBank Fields Here

Show field labels | Show database names

DB Table Name	stratum
Table	Stratum Definition
Notes	This table stores collective information about strata defined within a plot observation.
Description	This table is used to record non-species-specific information about a stratum. Examples include total cover of the stratum and maximum height of the stratum.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition ID STRATUM_ID no serial PK no Database assigned value for a unique existence of a stratum within a plot observation. Observation OBSERVATION_ID required Integer FK no Link to the plot observation event with which this stratum observation is associated. Stratum Type STRATUMTYPE_ID required Integer FK no This attribute will link to the definition of the specific stratum observed. Stratum Method STRATUMMETHOD_ID no Integer FK no   Stratum Name stratumName no varchar (30) denorm no   Stratum Height stratumHeight no Float n/a no Average height to the top of the stratum in meters. Stratum Base stratumBase no Float n/a no Average height of the bottom of the stratum in meters. Stratum Cover stratumCover no Float n/a no Cover of the vegetation within the given stratum in percent.