• Home
  • About BIEN
  • SALVIAS
  • Data
  • Applications
  • Login
  • News
Botanical Information and Ecology Network

Botanical Information and Ecology Network

Menu

BIEN 4 Data Dictionary

BIEN 4 database tables and descriptions. Click on table name for column information.



Table Description
agg_traits Trait measurement of a taxon, with associated references. May or may not have associated locality information
analytical_stem Stem attributes (dbh, height, etc.) for individual-based plot observatsion, plus associated observation attributes from view_full_occurrence_individual
bien_metadata List of all BIEN database version numbers, their release dates and retirement dates.
bien_species_all Counts of number of observation per (validated) species in BIEN database.
bien_summary Select summary statistics for current and historical BIEN databases.
bien_taxonomy Tables of all unique taxon + author + morphospecies combinations in BIEN database, with foreign keys to standard taxa in table taxon.
cites CITES status for all BIEN species on CITES list
country Standard country names and abbreviations, from geonames database.
country_name Alternative country names (gnrs, adapted from geonames)
county_parish Standard county/parish names and abbreviations, from geonames database.
county_parish_name Alternative county/parish names (gnrs, adapted from geonames)
cultobs Raw cultivated observation validation results
data_contributors Structured list of all BIEN data providers and their attributes, for use on BIEN website. Subset of attributes in table datasource.
data_dictionary_columns BIEN data dictionary, column definitions
data_dictionary_rbien Data dictionary, RBIEN R package.
data_dictionary_values BIEN data dictionary, constrained value definitions
datasource Metadata for all BIEN data providers. Each record corresponds to one dataset, plus additional records for each aggregator or other secondary provider.
endangered_taxa CITES, IUCN and USDA status for all endangered taxa in BIEN database
genus_family Lookup table of genera and their family classifications.
gnrs Raw GNRS validation results, resolves verbatim political division names to standard names from geonames database.
ih Complete Index Herbariorum table ("database"), with additional columns of standardized political divisions, latitude and longitude.
iucn IUCN status for all BIEN species on IUCN list
ncbi_taxa All species and families from NCBI taxonomy, for filtering non-plant names.
nsr Raw NSR validation results. Check if submitted taxon native to declared political divisions.
observations_union All species in BIEN database, plus validated coordinates as geometry object (for mapping)
phylogeny Alternative phylogenies of BIEN taxa (currently, for BIEN 3.0 taxa only)
plot_metadata Metadata for all vegetation plots in bien database. One record per plot.
ranges Modeled species distributions
species All distinct species in BIEN database, plus integer ID.
species_by_political_division All unique combinations of species x political divisions in BIEN db.
state_province Standard state/province names, from geonames database.
state_province_name Alternative state/province names (gnrs, adapted from geonames)
taxon All unique taxa in BIEN database (no authors)
taxon_trait Mean values of all traits measurements for all taxa in BIEN database.
tnrs TNRS validation resultsbest matches only, after BIEN post-processing
tnrs_scrubbed Raw TNRS validation results, all matches.
trait_summary Units of measurement, number of species & records for all traits in BIEN db.
usda USDA Plants status for all BIEN species on USDA list
view_full_occurrence_individual Main observation analytical table. Each records is an observation of a taxon at a particular place and time.
world_geom Geospatial attributes of global political divisions and geographic objects from GADM database.
world_geom_country GADM country polygons and metadata, indexed for fast searching
world_geom_county GADM county-level polygons and metadata, indexed for fast searching
world_geom_gnrs Full GNRS validation results for political division names in table world_geom
world_geom_state GADM state-level polygons and metadata, indexed for fast searching
BIEN database current version: 4.1

Members

  • Log in

Pages

  • Home
  • About BIEN
  • SALVIAS
  • Data
    • Database Version Metadata
    • Data Use Policy
    • Embargoed Data Policy
    • BIEN 2
    • BIEN 3+
    • BIEN 4
      • BIEN 4 Data Dictionary
  • Data contributors
  • Applications & validations
  • Participants
  • Publications
  • Acknowledgments
  • Links

Search

Recent Posts

  • News

Botanical Information and Ecology Network 2021 | Powered by WordPress.