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




Column Data Type Null Description Values
verbatim_scientific_name text YES Verbatim taxon name
verbatim_family text YES Verbatim taxon name
vegetation_verbatim text YES Verbatim description of vegetation or habitat
usda_state text YES USDA state threatened & endangered status for this taxon, if applicable
usda_federal text YES USDA federal threatened & endangered status for this taxon, if applicable
tnrs_warning text YES TNRS warnings, if any. 'No match', 'NULL', 'Partial match', 'TNRS resu… MORE
tnrs_name_matched_score numeric YES Overall TNRS name match score
temperature_c numeric YES Mean annual temperature in C
taxonobservation_id bigint NO Integer primary key. Uniquely identifies each record in this table.
taxon_observation_id text YES [internal use] NOT the same as taxonobservation_id. DO NOT USE.
taxon_name_usage_concept_author_code text YES [internal use]
taxon_id bigint YES Foreign key to table taxon
subplot text YES Subplot code, if applicable
stratum_name text YES Plot stratum code, if applicable
stem_height_m numeric YES Stem height in m
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
slope_gradient_deg numeric YES Slope gradient in degrees
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 accepted taxon name resolved by TNRS. If no accepted name, author of matched name is used if matched_taxonomic_status='No opinion'.
sampling_protocol text YES Plot sampling protocol, if applicable (semi-standardized description)
reproductive_condition text YES Reproductive condition (flowering, fruiting, sterile, etc.). Vocabulary not currently standardized.
recorded_by text YES Collector of a specimen, or primary data collector of a plot
record_number text YES Collection number of a specimen
project_id text YES [internal use]
location_id text YES [internal use]
locality text YES Verbatim locality description
latlong_verbatim text YES Verbatim latitude and longitude
latitude numeric YES Decimal latitude
iucn text YES IUCN Red List endangered status for this taxon.
is_new_world smallint YES Is country in western hemisphere? '0', '1', 'NULL' MORE
is_location_cultivated boolean YES [Internal use]
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_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_embargoed_observation smallint YES Is locality information for this records hidden due to endangered status of taxon? '1', 'NULL' 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', 'NULL' MORE
is_centroid smallint YES 1=point is a centroid; 0=point not a centroid
individual_organism_observation_id text YES [internal use]
individual_id text YES Verbatim identifier or code for a unique individual within a plot. Optional.
individual_count integer YES Number of individuals represented by this observation (individual observations only)
identified_by text YES Person(s) who provided the most recent idenfication
identification_remarks text YES Comments on the identification
higher_plant_group text YES Higher plant group of final resolved name (scrubbed_species_binomial) 'Algae', 'Bacteria', 'bryophytes', 'ferns and a… MORE
growth_form 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'.
georef_sources text YES Georeferencing sources, if applicable (from original data)
georef_protocol text YES Georeferencing protocol, if applicable
geom USER-DEFINED YES Spatial object
geodeticdatum text YES Geodetic datum of coordinates, if known
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)
event_date_verbatim text YES Verbatim date of observation
event_date_accuracy text YES Level of accuracy with which original date was specified: day, month or year.
event_date date YES Date of observation
elevation_verbatim text YES Verbatim elevation
elevation_min_m numeric YES Minimum elevation in m, if range.
elevation_max_m numeric YES Maximum elevation in m, if range.
elevation_m numeric YES Elevation in m. Midpoint if elevation_verbatim is a range.
date_identified_verbatim text YES Verbatim date of identification
date_identified_accuracy text YES Level of accuracy with which original date of identification was specified (day, month, year).
date_identified date YES Date of identification
date_collected_verbatim text YES Verbatim date of collection
date_collected_accuracy text YES Level of accuracy with which date of collection was specified (day, month, year).
date_collected date YES Date of collection
datasource_id bigint YES Foreign key to table datasource
datasource text YES Unique code for the person, institution or project that provided the data to BIEN. Consists of one or more datasets.
dataset text YES Identifies a group of plots, specimens or trait measurements from a single data owner or group of owner. The lowest unit of grouping of data in BIEN.
dataowner text YES Primary owner of the dataset or primary contact
custodial_institution_codes text YES Standard code(s) of institution(s) holding specimen or duplicate specimen
cover_percent numeric YES Percent cover of this taxon (aggregate cover observations only)
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_uncertainty_m double precision YES Coordinate uncertain in m
coord_max_uncertainty_km numeric YES Maximum coordinate uncertainty in km
community_concept_name ARRAY YES Vegetation classification (classification used varies by source database)
collection_code text YES http://rs.tdwg.org/dwc/terms/#collectionCode
cites text YES Current CITES listing for this taxon
citation_verbatim text YES Citation for this observation (verbatim)
citation text YES Citation for this observation (bibtex)
centroid_max_uncertainty numeric YES Distance from centroid to further point on shape perimeter
centroid_poldiv text YES Political division of which point is most likely to be centroid
centroid_dist_relative numeric YES Relative distance to centroid
catalog_number text YES DwC term. In BIEN, the unique identifier from the original dataset. Unique within a given dataset.
bien_taxonomy_id bigint YES Foreign key to table bien_taxonomy
aggregate_organism_observation_id text YES [internal use]
centroid_type text YES [not currently used]
project_contributors ARRAY YES Persons associated with or contributing to the project
precip_mm numeric YES Total annual precipitation in mm
poldiv_full text YES [internal use]
plot_name text YES Plot name or code. Unique within a given dataset.
plot_metadata_id bigint YES Foreign key to table plot_metadata
plot_area_ha double precision YES Plot area in ha
plantobservation_id integer YES [internal use]
occurrence_remarks text YES Any additional remarks accompanying observation. For specimens, this will be the description of the specimen.
occurrence_id text YES [internal use]
observation_type text YES Type of observation (specimen, plot, trait, etc.) 'checklist occurrence', 'human observation', 'l… MORE
observation_contributors ARRAY YES Persons who contributed to collecting data in the field
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
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
longitude numeric YES Decimal longitude
locationevent_id integer YES [internal use]
slope_aspect_deg numeric YES Slope aspect in degrees