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




Column Data Type Null Description Values
centroid_dist_km numeric YES Absolute distance in km from observation to known centroid
centroid_likelihood numeric YES 1-centroid_dist_relative
cods_keyword_id integer YES Foreign key to table cods_keyword
cods_proximity_id integer YES Foreign key to table cods_proximity
continent character varying YES Standard continent / major geographic region name (GNRS)
coordinate_inherent_uncertainty_m numeric YES Uncertainty in m due to number of decimal places
fk_cds_id integer YES Foreign key to table CDS
geom USER-DEFINED YES Spatial representation of observation point postgis spatial object (wkt, projection=4326).
gid_0 text YES GADM identifier for admin level 0 (country) political unit (GNRS)
gid_1 text YES GADM identifier for admin level 1 (state) political unit (GNRS)
gid_2 text YES GADM identifier for admin level 2 (county) political unit GNRS)
id_verbatim integer YES [internal use]
invalid_latlong_reason text YES Reason is_invalid_latlong=1 (TRUE)
is_invalid_latlong integer YES Are coordinates an impossible terrestrial value (out of range or in water)?
latlong_text text YES Concatenated decimal latitude and longitude as text
id bigint NO Integer primary key. Uniquely identifies each record in this table.
traits_id integer YES Legacy ID from previous version of traits table
bien_taxonomy_id bigint YES Foreign key to table bien_taxonomy
taxon_id bigint YES Foreign key to table taxon
family_taxon_id bigint YES Foreign key to taxon_id of family in table taxon
genus_taxon_id bigint YES Foreign key to taxon_id of genus in table taxon
species_taxon_id bigint YES Foreign key to taxon_id of species in table taxon
fk_tnrs_id bigint YES Foreign key to table tnrs
verbatim_family text YES Verbatim family name, if provided
verbatim_scientific_name text YES Verbatim taxon name
name_submitted text YES Name submitted to TNRS; usually = verbatim_family + verbatim_scientific_name, with corrections for characters not handled by TNRS
family_matched text YES Family matched by the TNRS (if family submitted)
name_matched text YES Taxon name matched by the TNRS
name_matched_author text YES Standard of of the taxon name matched by the TNRS
tnrs_name_matched_score numeric YES Overall TNRS name match score
higher_plant_group text YES Major higher plant group, not necessarily monophyletic (added by BIEN) 'bryophytes', 'ferns and allies', 'flowering pl… MORE
tnrs_warning text YES TNRS warnings, if any. 'No match', 'NULL', 'Partial match' MORE
matched_taxonomic_status text YES Taxonomic status of name matched by TNRS 'Accepted', 'Illegitimate', 'Invalid', 'No opin… MORE
match_summary text YES Summary of match completeness for this name. 'Exact match', 'Fuzzy match', 'No match', 'NULL… MORE
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', 'No opinion', 'NULL' MORE
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_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_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 text YES Accepted species resolved by TNRS. If no accepted name, matched species is used, but only 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_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'.
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_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'.
trait_name text YES Name of the trait measured
trait_value text YES The trait measurement value
unit text YES Units of the trait measurement
method text YES Narrative summary of trait measurement methods
region text YES Geographic region
country_verbatim text YES Verbatim country, as submitted
state_province_verbatim text YES Verbatim state/province, as submitted.
county_verbatim text YES Verbatim county/parish, as submitted
poldiv_full text YES [internal use]
fk_gnrs_id bigint YES Foreign key to table gnrs
country text YES Standard country name from geonames database (GNRS)
state_province text YES Standard state/province name from geonames database (GNRS)
county text YES Standard county/parish name from geonames database (GNRS)
is_centroid integer YES 1=point is a centroid; 0=point not a centroid
centroid_dist_relative numeric YES Relative distance to centroid (Absolute distance divided by distance from centroid to farthest point on perimiter).
centroid_poldiv text YES Political division of which point is most likely to be centroid
centroid_type text YES Centroid of shape of this type
is_in_country integer YES Are coordinates in declared (standard) country (Geovalidation) '0', '1', 'NULL' MORE
is_in_state_province integer YES Are coordinates in declared (standard) state/province (Geovalidation) '0', '1', 'NULL' MORE
is_in_county integer YES Are coordinates in declared (standard) county/parish (Geovalidation) '0', '1', 'NULL' MORE
locality_description text YES Verbatim locality description
latlong_verbatim text YES Verbatim latitude and longitude
latitude numeric YES Decimal latitude
min_latitude numeric YES Maximum value of decimal latitude (if range)
max_latitude numeric YES Maximum value of decimal latitude (if range)
longitude numeric YES Decimal longitude
min_longitude numeric YES Maximum value of decimal longitude (if range)
max_longitude numeric YES Maximum value of decimal longitude (if range)
coord_uncertainty_verbatim text YES Verbatim statement of coordinate error
coord_max_uncertainty_km numeric YES Maximum coordinate uncertainty in km
georef_sources text YES Georeferencing sources, if applicable (from original data)
georef_protocol text YES Georeferencing protocol, if applicable 'NULL' MORE
is_geovalid smallint YES Do coordinates fall within all declared political divisions? (BIEN validation 'geovalidation') '0', '1', 'NULL' MORE
is_new_world smallint YES Is country in western hemisphere? '0', '1', 'NULL' MORE
elevation_verbatim text YES Verbatim elevation
elevation_m integer YES Elevation in m. Midpoint if elevation_verbatim is a range.
elevation_min_m integer YES Minimum elevation in m, if range.
elevation_max_m integer YES Maximum elevation in m, if range.
source text YES Legacy information from previous iterations
url_source text YES Url for this source
source_citation text YES Text version of the citation associated with the trait.
source_id text YES Legacy information from previous iterations
visiting_date_verbatim text YES The date the data were extracted from the source publication or database.
visiting_date date YES A standardized form of the visiting date
visiting_date_accuracy text YES Accuracy-level to which verbatim visiting date was recorded (day, month, or year)
reference_number text YES Legacy information from previous iterations
access text YES Is the record publicly accessible, private, or publicly accessible with conditions?
project_pi text YES [internal use]
project_pi_contact text YES Contact email for project principal investigator
observation text YES Additional information that may be relevent when utilizing the trait data.
authorship text YES [internal use] Who entered the trait information in the BIEN database?
authorship_contact text YES [internal use] Email address of the person who entered the trait information in the BIEN database.
citation_bibtex text YES Citation for this observation (bibtex)
plant_trait_files text YES [internal use]
is_experiment smallint YES Is trait measurement from an experiment? '0', '1', 'NULL' MORE
observation_context text YES What was the context in which the study was conducted? E.g. "field", "glasshouse", "growth chamber" ' ', 'field', 'field ', 'field and herbarium', … MORE
observation_date_verbatim text YES Verbatim date of observation, as in original database
observation_date date YES Date of observation
observation_date_accuracy text YES Accuracy-level to which verbatim date recorded (day, month, or year)
source_locality text YES Text describing the location of the source population the individual was drawn from. Especially relevant for introductions or experiments.
is_individual_trait smallint YES Is the measurement a trait of an individual organism (e.g. height, leaf area?) '0', '1', 'NULL' MORE
is_species_trait smallint YES Is the measurement a trait of a species (e.g. range size, measures of genetic diversity)? '0', '1', 'NULL' MORE
is_trait_value_valid smallint YES [not yet implemented] Does the trait value fall within the range of accepted values? 'NULL' MORE
temporary_taxonobservation_id text YES [internal use]
taxonobservation_id bigint YES Foreign key to PK of table view_full_occurrence_individual
is_individual_measurement smallint YES Does the trait represent a single measurement (1), or a summary (e.g. mean, median) of multiple measurements (0)? '0', '1', 'NULL' MORE
is_embargoed_observation smallint YES Is locality information for this records hidden due to endangered status of taxon? '0', '1' MORE
nsr_id bigint YES Foreign key to table nsr.
native_status_country text YES Native status in country (NSR) 'A', 'I', 'Ie', 'N', 'Ne', 'NULL', 'P' MORE
native_status_state_province text YES Native status in state/province (NSR) 'I', 'Ie', 'N', 'Ne', 'NULL', 'P' MORE
native_status_county_parish text YES Native status in sounty/parish (NSR) 'I', 'Ie', 'NULL' MORE
native_status text YES Native status of taxon in lowest political division for which checklist information available (NSR) 'A', 'I', 'Ie', 'N', 'Ne', 'NULL', 'P', 'UNK' MORE
native_status_reason text YES Reason overall native status assigned (NSR) 'Absent from all checklists for region', 'Endem… MORE
native_status_sources text YES Checklist sources used to assign native status (NSR)
is_introduced smallint YES Is taxon introduced in declared political division? Final NSR assessment based on native_status (0,1,NULL). '0', '1', 'NULL' MORE
is_cultivated_in_region text YES Is taxon known to be cultivated in declared political division? (NSR) '0', '1', 'NULL' MORE
is_cultivated_taxon text YES Is taxon primarily cultivated? (NSR) '0', '1', 'NULL' MORE
is_cultivated_observation integer YES Is observation of an individual cultivated plant (0,1,NULL) '0', '1', 'NULL' MORE
is_cultivated_observation_basis text YES Reason for assignment of is_cultivated_observation status. 'Keywords in locality', 'NULL', 'Proximity to h… MORE