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