Login | Datasets | Logout
 

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 VegBank Fields Here

«previous  | 1 | 2 | 3 | page 4 | 5 | 6 |  next»
records 31 through 40 of 55

Show field labels | Show database names

DB Table Name coverMethod
Table Cover Method
Notes This table associates a cover scale recognized by the plot data collectors with a set of coverclasses specified in the coverIndex table. This table, together with the coverIndex table, defines a coverclass method.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID COVERMETHOD_ID no serial PK no Database generated identifier assigned to each unique coverclass methodology.
Reference reference_ID no Integer FK no Foreign Key into the reference table, linking the defining reference to a cover method.
Cover Type coverType required varchar (30) n/a no Name of the coverclass method (e.g., Braun-Blanquet, Barkman, Domin, Daubenmire, Carolina Vegetation Survey, etc.).
Cover Estimation Method coverEstimationMethod no varchar (80) n/a closed The way that cover is estimated on the observation.
Accession Code accessionCode no varchar (100) n/a no Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).

 

DB Table Name definedValue
Table Defined Value
Notes This table stores the values of user-defined variables.
Description This table stores values associated with specific user-defined variables identified in the userDefined table.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID DEFINEDVALUE_ID no serial PK no Database generated identifier assigned to each unique defined value.
User Defined USERDEFINED_ID required Integer FK no Link to a specific user-defined variable defined in the userDefined table.
Table Record tableRecord_ID required Integer n/a no The numeric value of the record number (primary key) that this user-defined value would have if it were in the table identified by USERDEFINED_ID.
Defined Value definedValue required text n/a no The value of the user-defined variable.

 

DB Table Name disturbanceObs
Table Disturbance Observation
Notes This table stores plot observation information pertaining to observer estimation of the disturbance history of the plot.
Description disturbanceObs is a child of observation; a plot might experience many types of disturbance unique to different observation events.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID disturbanceObs_ID no serial PK no Database generated identifier assigned to each unique disturbance observation..
Observation OBSERVATION_ID required Integer FK no Link to the observation event with which this report of a disturbance event is associated.
Disturbance Type disturbanceType required varchar (30) n/a closed The type of disturbance being reported
Disturbance Intensity disturbanceIntensity no varchar (30) n/a closed Intensity or degree of the disturbance.
Disturbance Age disturbanceAge no Float n/a no Estimated time in years since the disturbance event.
Disturbance Extent disturbanceExtent no Float n/a no Percent of the plot that experienced the event.
Disturbance Comment disturbanceComment no text n/a no Text description of details of the disturbance and its impact on the vegetation.

 

DB Table Name graphic
Table Graphic
Notes This table stores information about graphical files related to vegetation plot observations
Description Graphical files can include, among other formats: gif, jpeg, and tif file formats. Because many graphical files, especially remote sensing digital photographs, may be too large to be stored within the database, a graphicLocation may be given as an alternative. Current Business rules cap graphic size at 5M per plot. Graphics of modest size should be included rather than referenced by external address.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID GRAPHIC_ID no serial PK no Database generated identifier assigned to each unique graphic idem.
Observation OBSERVATION_ID required Integer FK no Link from a graphic file to a specific plot observation.
Graphic Name graphicName no varchar (30) n/a no Name of the graphic file.
Graphic Location graphicLocation no text n/a no Where the graphic is located, if not in the database
Graphic Description graphicDescription no text n/a no Description of the graphical file and associated metadata such as contributor, author, sensor, etc.
Graphic Type graphicType no varchar (20) n/a no The type of the graphical file format (e.g. gif, tif, ,jpeg).
Graphic Date graphicDate no Date n/a no Date that the graphic was produced.
Graphic Data graphicData no oid n/a no The graphical file data. - Max = 5 M total per plot
Accession Code accessionCode no varchar (100) n/a no Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).

 

DB Table Name namedPlace
Table Named Place
Notes This tables stores information about the various 'named places' that a plot may have been located within. Such places could include geographic regions, study sites, ownership units, managed units, any placename in the USGS glossary (http://www-nmd.usgs.gov/www/gnis/), or equivalent glossary.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID NAMEDPLACE_ID no serial PK no Database generated identifier assigned to each unique named place.
Place System placeSystem no varchar (50) n/a closed Name of the system of names. These can be treated as points as with place names, or as a coverage or set of polygons (e.g., geographic area names, HUC codes, Ecoregions, Quadrangles).
Place Name placeName required varchar (100) n/a no The name of a place in or at which a plot is located. The system "Geographic Name" is an open list defined within this table. The other systems are generally closed lists constrained by aux_tables. These include at least USGSQuad, Continent, Country, State, County, HUC, and Ecoregion.
Place Description placeDescription no text n/a no This is the description of a named place.
Place Code placeCode no varchar (15) n/a no Optional code for location identification
Owner owner no varchar (100) n/a no Although somewhat redundant with the owner information contained in observationContributor with roleCode of owner, this allows the program to provide ownership information automatically. The ownership field supercedes this field in priority.
Reference reference_ID no Integer FK no Link to a reference that contains further information on the named place.
Accession Code accessionCode no varchar (100) n/a no Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).

 

DB Table Name namedPlaceCorrelation
Table Named Place Correlation
Notes Stores information about how different named places related to one another.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
  NAMEDPLACECORRELATION_ID required serial PK no Primary Key.
Parent Place PARENTPLACE_ID required Integer FK no Link to a parent geographical region.
Child Place CHILDPLACE_ID required Integer FK no Link to a child geographical region.
Place Convergence placeConvergence required varchar (20) n/a closed This is the descriptive attribute that is used to relate the congruence between two places, Parent [convergence value] child (generally greater than).

 

DB Table Name commStatus
Table Community Status
Notes This table store the status of a community concept as perceived by a party at a time.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID COMMSTATUS_ID no serial PK no Database assigned value to each unique record in the commStatus table.
Community Concept COMMCONCEPT_ID required Integer FK no Foreign key to identify the concept to which a party assigns a status
Reference reference_ID no Integer FK no Link to a reference where the status was reported
Community Concept Status commConceptStatus required varchar (20) n/a closed Status of the concept by the party (accepted, not accepted, undetermined)
Community Parent commParent_ID no Integer FK no The commParent is a recursive key to the concept of the parent level in the classification hierarchy. For example, if this concept were at the association level, the parentClass would be a concept that is the parent alliance type.
Community Level commLevel no varchar (80) n/a closed The commLevel attribute specifies a level in the taxonomic hierarchy to which a class belongs. Field commLevel is an open list with the possible values defined by the classification system employed. If the party responsible for the record in the commStatus table is using the U.S. National Vegetation Classification, the acceptable levels are defined in the Vegetation Classification Standard of the Federal Geographic Data Committee as adopted June 1997. The standard is available at http://biology.usgs.gov/fgdc.veg/standards/vegstd.htm and the allowable entries for each of the physiognomic levels are listed in the appendix (see http://www.fgdc.gov/standards/documents/standards/vegetation/tables19-41.pdf). If the Braun-Blanquet classification system is employed, the acceptable values are defined in the International Code of Phytosociological Nomenclature (Weber, H.E., Moravec, J. Theurillat, J.-P. 2000. Journal of Vegetation Science. 11: 739-769).
Start Date startDate required Date n/a no This is the date for which the status assignment by the party started.
Stop Date stopDate no Date n/a no This is the date for which the status assignment by the party ended.
Community Party Comments commPartyComments no text n/a no Comments by party providing rationale for status assignment
Party PARTY_ID required Integer FK no Foreign key that identifies the party that made the status assignment
Accession Code accessionCode no varchar (100) n/a no Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).

 

DB Table Name commUsage
Table Community Usage
Notes This table links a community name with a concept.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID COMMUSAGE_ID no serial PK no Database assigned value to each unique record in the communityUsage table.
Community Name COMMNAME_ID required Integer FK no This field is the foreign key into the commName table.
Usage Start usageStart no Date n/a no This is the date on which the party applied the name to the concept.
Usage Stop usageStop no Date n/a no This is the date on which the party ceased to apply the name to the concept.
Community Name Status commNameStatus no varchar (20) n/a closed This field shows the status of the application of the name to the concept by the party (standard, not standard, undetermined).
Class System classSystem no varchar (50) n/a open This is the name of the classification system wherein the name is applied (e.g., Scientific, Spanish common).
Comm Status COMMSTATUS_ID no Integer FK no Comm Status which applies to this commUsage.

 

DB Table Name plantConcept
Table Plant Concept
Notes This table store the concepts that are linked to plant names through the plantUsage table.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID PLANTCONCEPT_ID no serial PK no Database assigned value to each unique record in the commConcept table.
Plant Name PLANTNAME_ID required Integer FK no This is a foreign key into the plant name list, the entry in which when combined with a reference constitutes a concept.
Reference reference_ID required Integer FK no This is a foreign key to the reference in which the name was used, thereby defining a concept.
Plant Description plantDescription no text n/a no The plantDescription is a description of the plantConcept by the party contributing the plantConcept.
Accession Code accessionCode no varchar (100) n/a no Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number).

 

DB Table Name plantCorrelation
Table Plant Correlation
Notes This table correlates multiple plant concepts as they change through time.
Field DB Field Name Req'd? Data Type Misc Flag List? Definition
ID PLANTCORRELATION_ID no serial PK no Database assigned value to each unique record in the plantCorrelation table.
Plant Status PLANTSTATUS_ID required Integer FK no This is the foreign key into the plantStatus table "pointing" to a concept no longer viewed as standard by the party.
Plant Concept PLANTCONCEPT_ID required Integer FK no This is the foreign key into the plantConcept table "pointing" to a concept recognized by the party as a "standard" concept.
Plant Convergence plantConvergence required varchar (20) n/a closed This is the descriptive attribute that is used to relate the congruence between two concepts. The concept that is represented in the party perspective, via the Status_ID field is [this field, i.e. <,>,=] the concept represented in Concept_ID field. As normally used, (no Longer Valid Concept) [convergence] (Valid Concept). For example, if a concept is split, the convergence would be 'greater than' (The old concept is 'greater than' the new concept).
Correlation Start correlationStart required Date n/a no This is the start date for recognition by a party of a correlation between two concepts.
Correlation Stop correlationStop no Date n/a no This is the stop date for recognition by a party of a correlation between two concepts.

 


«previous  | 1 | 2 | 3 | page 4 | 5 | 6 |  next»
records 31 through 40 of 55