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. cds Centroid Detection Service (CDS) coordinate geovalidation results cites CITES status for all BIEN species on CITES list cods_keyword Cultivated Observation Detection Service (CODS) keyword validation results cods_proximity Cultivated Observation Detection Service (CODS) proximity-to-botanical-garden validation results 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) 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. range_model_data_metadata Metadata for BIEN range model observation data range_model_data_raw Raw observation input for BIEN range models 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. species_observation_counts Counts of observations remaining after cumulative application of numbered WHERE subclauses. Subclauses are described in 'species_observation_counts_filters' species_observation_counts_crosstab Same as 'species_observation_counts' but arranged as crosstab, with species as row headers and subclauses as column headers. species_observation_counts_filters Details of WHERE subclauses used in 'species_observation_counts' and 'species_observation_counts_crosstab' species_observation_counts_sep Counts of observations remaining after separate application of numbered WHERE subclauses. Subclauses are described in 'species_observation_counts_sep_filters' species_observation_counts_sep_crosstab Same as 'species_observation_counts_sep' but arranged as crosstab, with species as row headers and subclauses as column headers. species_observation_counts_sep_filters Details of WHERE subclauses used in 'species_observation_counts_SEP' and 'species_observation_counts_sep_crosstab' 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_status Summary of taxonomic status of all species names (scrubbed_species _binomial + author) in BIEN 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. tnrs_submitted Verbatim and final taxon names submitted to the TNRS. In some cases these differ due to stripping of special characters. Backup for joining to table tnrs. 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_state GADM state-level polygons and metadata, indexed for fast searching