Login | Datasets | Logout

VegBank Data Dictionary: Tables

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

   Search VegBank Fields Here

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

Show table/field labels | Show database names

DB Table Name Table Notes Description Fields (Columns)
taxonObservation Taxon Observation This table contains the author's determination of a taxon and the overall cover of that taxon. This table stores information about the original identification by the author of the plot and the taxonomic authority used by that author (i.e. a name - citation pair constituting a taxonomic concept). The table also contains a record of cumulative cover (cover across all strata) of the taxon when not divided into strata. TAXONOBSERVATION_IDID  OBSERVATION_IDObservation  authorPlantNameAuthor Plant Name  reference_IDReference  taxonInferenceAreaTaxon Inference Area  accessionCodeAccession Code  
taxonAlt Taxon Alt This table shows alternate taxa that are to be grouped for a taxonInterpretation. When this table is used, the taxonInterpretation that is referenced here is interpreting the taxonObservation as the combination of all plantConcepts referenced in this table with the same taxonInterpretation_ID. TaxonInterpretation.groupType shows what type of group this is (one of, union, unknown). taxonAlt_IDID  taxonInterpretation_IDTaxon Interpretation  plantConcept_IDPlant Concept  taxonAltFitTaxon Fit  taxonAltConfidenceTaxon Confidence  taxonAltNotesTaxon Alt Notes  
telephone Telephone Telephone numbers for the various individuals and organizations in the party table.   TELEPHONE_IDID  PARTY_IDParty  phoneNumberPhone Number  phoneTypePhone Type  
userDefined User Defined This table contains the definitions of user-defined variables. The table structure stems from desire to keep the user-defined variables separate from the main body of the database. This table contains the definitions of user-defined variables. The table structure stems from desire to keep the user-defined variables separate from the main body of the database. USERDEFINED_IDID  userDefinedNameUser Defined Name  userDefinedMetadataUser Defined Metadata  userDefinedCategoryUser Defined Category  userDefinedTypeUser Defined Type  tableNameTable Name  accessionCodeAccession Code  
embargo Embargo on Plot Embargo of plot data.   embargo_IDEmbargo ID  plot_IDPlot ID  embargoReasonEmbargo Reason  embargoStartEmbargo Start  embargoStopEmbargo Stop  defaultStatusDefault Status  
revision Revision This table constitutes a log of changes in data deposited in the database. This table was designed to store as a single, stand-alone table information about attributes in any of the database tables. REVISION_IDID  tableNameTable Name  tableAttributeTable Attribute  tableRecordTable Record  revisionDateRevision Date  previousValueTextPrevious Value Text  previousValueTypePrevious Value Type  previousRevision_IDPrevious Revision  
soilObs Soil Observation This table stores observation on soil horizons made during the plot observation event. soilObs is child of observation in recognition of the fact that the horizons observed vary among plot observation events as a results of real change plus changes in investigators, methods and circumstances. SOILOBS_IDID  OBSERVATION_IDObservation  soilHorizonSoil Horizon  soilDepthTopSoil Depth Top  soilDepthBottomSoil Depth Bottom  soilColorSoil Color  soilOrganicSoil Organic  soilTextureSoil Texture  soilSandSoil Sand  soilSiltSoil Silt  soilClaySoil Clay  soilCoarseSoil Coarse  soilPHSoil PH  exchangeCapacityExchange Capacity  baseSaturationBase Saturation  soilDescriptionSoil Description  
soilTaxon Soil Taxon This table stores the valid soilTaxon records that may be used to describe the soil of a plot.   SOILTAXON_IDID  soilCodeSoil Code  soilNameSoil Name  soilLevelSoil Level  SOILPARENT_IDSoil Parent  soilFrameworkSoil Framework  accessionCodeAccession Code  
stemCount Stem Count This table is intended to store information about the abundance of tree stems of a specific size.   STEMCOUNT_IDID  TAXONIMPORTANCE_IDTaxon Importance  stemDiameterDBH  stemDiameterAccuracyDBH err  stemHeightHt.  stemHeightAccuracyHt. Err  stemCount#  stemTaxonAreaStem Taxon Area  
stemLocation Stem Location This table is intended to store location information about individual tree stems.   STEMLOCATION_IDID  STEMCOUNT_IDStem Count  stemCodeStem Code  stemXPositionStem X Position  stemYPositionStem Y Position  stemHealthStem Health  

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