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
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 |
|