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
method text YES Narrative summary of trait measurement methods
max_longitude numeric YES Maximum value of decimal longitude (if range)
centroid_max_uncertainty numeric YES Distance from centroid to further point on shape perimeter
max_latitude numeric YES Maximum value of decimal latitude (if range)
matched_taxonomic_status text YES Taxonomic status of name matched by TNRS 'Accepted', 'Illegitimate', 'Invalid', 'No opin… MORE
centroid_dist_relative numeric YES Relative distance to centroid
visiting_date_verbatim text YES The date the data were extracted from the source publication or database.
visiting_date_accuracy text YES Accuracy-level to which verbatim visiting date was recorded (day, month, or year)
visiting_date date YES A standardized form of the visiting date
verbatim_scientific_name text YES Verbatim taxon name
verbatim_family text YES Verbatim family name, if provided
url_source text YES Url for this source
unit text YES Units of the trait measurement
traits_id bigint YES Legacy ID from previous version of traits table
trait_value text YES The trait measurement value
trait_name text YES Name of the trait measured
tnrs_warning text YES TNRS warnings, if any. 'No match', 'NULL', 'Partial match' MORE
tnrs_name_matched_score numeric YES Overall TNRS name match score
temporary_taxonobservation_id text YES [internal use]
taxonobservation_id bigint YES Foreign key to PK of table view_full_occurrence_individual
taxon_id bigint YES Foreign key to table taxon
state_province_verbatim text YES Verbatim state/province, as submitted.
state_province character varying YES Standard state/province name from geonames database (GNRS)
species_taxon_id bigint YES Foreign key to taxon_id of species in table taxon
source_locality text YES Text describing the location of the source population the individual was drawn from. Especially relevant for introductions or experiments.
source_id text YES Legacy information from previous iterations
source_citation text YES Text version of the citation associated with the trait.
source text YES Legacy information from previous iterations
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_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'.
region text YES Geographic region
reference_number text YES Legacy information from previous iterations
project_pi_contact text YES Contact email for project principal investigator
project_pi text YES [internal use]
poldiv_full text YES [internal use]
plant_trait_files text YES [internal use]
observation_date_verbatim text YES Verbatim date of observation, as in original database
observation_date_accuracy text YES Accuracy-level to which verbatim date recorded (day, month, or year)
observation_date date YES Date of observation
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 text YES Additional information that may be relevent when utilizing the trait data.
nsr_id bigint YES Foreign key to table nsr.
native_status_state_province text YES Native status in state/province (NSR) 'I', 'Ie', 'N', 'Ne', 'NULL', 'P' MORE
native_status_sources text YES Checklist sources used to assign native status (NSR)
native_status_reason text YES Reason overall native status assigned (NSR) 'Absent from all checklists for region', 'Endem… MORE
native_status_county_parish text YES Native status in sounty/parish (NSR) 'I', 'Ie', 'NULL' MORE
native_status_country text YES Native status in country (NSR) 'A', 'I', 'Ie', 'N', 'Ne', 'NULL', 'P' 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
name_submitted text YES Name submitted to TNRS; usually = verbatim_family + verbatim_scientific_name, with corrections for characters not handled by TNRS
name_matched_author text YES Standard of of the taxon name matched by the TNRS
name_matched text YES Taxon name matched by the TNRS
min_longitude numeric YES Maximum value of decimal longitude (if range)
min_latitude numeric YES Maximum value of decimal latitude (if range)
match_summary text YES Summary of match completeness for this name. 'Exact match', 'Fuzzy match', 'No match', 'NULL… MORE
longitude numeric YES Decimal longitude
locality_description text YES Verbatim locality description
latlong_verbatim text YES Verbatim latitude and longitude
latitude numeric YES Decimal latitude
is_trait_value_valid smallint YES [not yet implemented] Does the trait value fall within the range of accepted values? '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_new_world smallint YES Is country in western hemisphere? '0', '1', 'NULL' MORE
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_individual_trait smallint YES Is the measurement a trait of an individual organism (e.g. height, leaf area?) '0', '1', 'NULL' MORE
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_in_state_province smallint YES Are coordinates in declared (standard) state/province (Geovalidation) '0', '1', 'NULL' MORE
is_in_county smallint YES Are coordinates in declared (standard) county/parish (Geovalidation) '0', '1', 'NULL' MORE
is_in_country smallint YES Are coordinates in declared (standard) country (Geovalidation) '0', '1', 'NULL' MORE
is_geovalid smallint YES Do coordinates fall within all declared political divisions? (BIEN validation 'geovalidation') '0', '1', 'NULL' MORE
is_experiment smallint YES Is trait measurement from an experiment? '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
is_cultivated_taxon smallint YES Is taxon primarily cultivated? (NSR) '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
is_cultivated_observation smallint YES Is observation of an individual cultivated plant (0,1,NULL) '0', '1', 'NULL' MORE
is_cultivated_in_region smallint YES Is taxon known to be cultivated in declared political division? (NSR) '0', '1', 'NULL' MORE
is_centroid smallint YES 1=point is a centroid; 0=point not a centroid
id bigint NO Integer primary key. Uniquely identifies each record in this table.
higher_plant_group text YES Higher plant group of final resolved name (scrubbed_species_binomial) 'bryophytes', 'ferns and allies', 'flowering pl… MORE
georef_sources text YES Georeferencing sources, if applicable (from original data)
georef_protocol text YES Georeferencing protocol, if applicable 'NULL' MORE
genus_taxon_id bigint YES Foreign key to taxon_id of genus in table taxon
fk_tnrs_id bigint YES Foreign key to table tnrs
fk_gnrs_id bigint YES Foreign key to table gnrs
fk_centroid_id bigint YES Foreign key to table centroid
family_taxon_id bigint YES Foreign key to taxon_id of family in table taxon
family_matched text YES Family matched by the TNRS (if family submitted)
elevation_verbatim text YES Verbatim elevation
elevation_min_m integer YES Minimum elevation in m, if range.
elevation_max_m integer YES Maximum elevation in m, if range.
elevation_m integer YES Elevation in m. Midpoint if elevation_verbatim is a range.
county_verbatim text YES Verbatim county/parish, as submitted
county character varying YES Standard county/parish name from geonames database (GNRS)
country_verbatim text YES Verbatim country, as submitted
country character varying YES Standard country name from geonames database (GNRS)
coord_uncertainty_verbatim text YES Verbatim statement of coordinate error
coord_max_uncertainty_km numeric YES Maximum coordinate uncertainty in km
citation_bibtex text YES Citation for this observation (bibtex)
centroid_type text YES Centroid of shape of this type
centroid_poldiv text YES Political division of which point is most likely to be centroid
bien_taxonomy_id bigint YES Foreign key to table bien_taxonomy
authorship_contact text YES [internal use] Email address of the person who entered the trait information in the BIEN database.
authorship text YES [internal use] Who entered the trait information in the BIEN database?
access text YES Is the record publicly accessible, private, or publicly accessible with conditions?