Table Columns

If the column has constrained values they are listed under values on the far right. Click on MORE to see full list and description of constrained values.
Back to table listings

  Sort columns ordinally
  Sort columns alphabetically

Columns in table "bien_taxonomy"




Column Data Type Null Description Values
trait_measurements integer YES [not used]
taxon_id bigint YES Foreign key to table taxon
superorder text YES Taxonomic superorder (APG III)
subclass text YES Taxonomic subclass (APG III)
species_taxon_id bigint YES Foreign key to taxon_id of species in table taxon
scrubbed_taxonomic_status text YES Taxonomic status of final taxon name resolved by TNRS. In most cases will be accepted; if not accepted name will use matched name if matched_taxonomic_status='No opinion' 'Accepted', 'illegitimate', 'No opinion', 'NULL' MORE
scrubbed_taxon_name_with_author text YES Final accepted taxon name + author resolved by TNRS. If no accepted name, matched name is used if matched_taxonomic_status='No opinion'.
scrubbed_taxon_name_no_author text YES Final accepted taxon name resolved by TNRS. If no accepted name, matched name is used, but only if matched_taxonomic_status='No opinion'.
scrubbed_taxon_canonical text YES Final taxon name resolved by TNRS, omitting infraspecific indicators such as var., subsp., etc.
scrubbed_specific_epithet text YES Epithet of final accepted species resolved by TNRS. If no accepted name, epithet of matched species is used, but only if matched_taxonomic_status='No opinion'..
scrubbed_species_binomial_with_morphospecies text YES Final species binomial resolved by TNRS, with unmatched terms, if any, appended to end. If no accepted name, matched name is used if matched_taxonomic_status='No opinion'.
scrubbed_species_binomial text YES Accepted species resolved by TNRS. If no accepted name, matched species is used, but only if matched_taxonomic_status='No opinion'.
scrubbed_genus text YES Genus of accepted name resolved by TNRS. If no accepted name, matched name is used if matched_taxonomic_status='No opinion'..
scrubbed_family text YES Family of accepted taxon name resolved by TNRS. If no accepted name, family of matched name is used, but only if matched_taxonomic_status='No opinion'.
scrubbed_author text YES Author of final taxon resolved by TNRS. If no accepted name, author of matched name is used if matched_taxonomic_status='No opinion'.
order text YES Taxonomic order (APG III)
observations integer YES [not used]
higher_plant_group text YES Higher plant group of final resolved name (scrubbed_species_binomial) 'bryophytes', 'ferns and allies', 'flowering pl… MORE
genus_taxon_id bigint YES Foreign key to taxon_id of genus in table taxon
family_taxon_id bigint YES Foreign key to taxon_id of family in table taxon
division text YES Taxonomic division (APG III)
class text YES Taxonomic class (APG III)
bien_taxonomy_id_txt text YES [internal use]
bien_taxonomy_id bigint NO Integer primary key. Uniquely identifies each record in this table.
taxon_rank text YES Taxonomic rank 'family', 'genus', 'hybrid genus', 'hybrid spec… MORE