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
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
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)
invalid_latlong_reason text YES
is_invalid_latlong integer YES Are coordinates an impossible terrestrial value (out of range or in water)?
is_new smallint YES [Internal use]
latlong_text text YES Concatenated decimal latitude and longitude as text
taxonobservation_id bigint NO Integer primary key. Uniquely identifies each record in this table.
observation_type character varying YES Type of observation (specimen, plot, trait, etc.) 'checklist occurrence', 'human observation', 'l… MORE
plot_metadata_id bigint YES Foreign key to table plot_metadata
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
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)
locality text YES Verbatim locality description
latlong_verbatim text YES Verbatim latitude and longitude
latitude numeric YES Decimal latitude
longitude numeric YES Decimal longitude
geodeticdatum text YES Geodetic datum of coordinates, if known
coord_uncertainty_m double precision YES Coordinate uncertain in m
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
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
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
project_id text YES [internal use]
project_contributors ARRAY YES Persons associated with or contributing to the project
location_id text YES [internal use]
plot_name text YES Plot name or code. Unique within a given dataset.
subplot text YES Subplot code, if applicable
is_location_cultivated boolean YES [Internal use]
locationevent_id integer YES [internal use]
event_date_verbatim text YES Verbatim date of observation
event_date date YES Date of observation
event_date_accuracy text YES Level of accuracy with which original date was specified: day, month or year.
elevation_verbatim text YES Verbatim elevation
elevation_m numeric YES Elevation in m. Midpoint if elevation_verbatim is a range.
elevation_min_m numeric YES Minimum elevation in m, if range.
elevation_max_m numeric YES Maximum elevation in m, if range.
slope_aspect_deg numeric YES Slope aspect in degrees
slope_gradient_deg numeric YES Slope gradient in degrees
plot_area_ha double precision YES Plot area in ha
sampling_protocol text YES Plot sampling protocol, if applicable (semi-standardized description)
temperature_c numeric YES Mean annual temperature in C
precip_mm numeric YES Total annual precipitation in mm
stratum_name text YES Plot stratum code, if applicable
vegetation_verbatim text YES Verbatim description of vegetation or habitat
community_concept_name ARRAY YES Vegetation classification (classification used varies by source database)
observation_contributors ARRAY YES Persons who contributed to collecting data in the field
custodial_institution_codes text YES Standard code(s) of institution(s) holding specimen or duplicate specimen
collection_code text YES http://rs.tdwg.org/dwc/terms/#collectionCode
catalog_number text YES DwC term. In BIEN, the unique identifier from the original dataset. Unique within a given dataset.
occurrence_id text YES [internal use]
recorded_by text YES Collector of a specimen, or primary data collector of a plot
record_number text YES Collection number of a specimen
date_collected_verbatim text YES Verbatim date of collection
date_collected date YES Date of collection
date_collected_accuracy text YES Level of accuracy with which date of collection was specified (day, month, year).
identified_by text YES Person(s) who provided the most recent idenfication
date_identified_verbatim text YES Verbatim date of identification
date_identified date YES Date of identification
date_identified_accuracy text YES Level of accuracy with which original date of identification was specified (day, month, year).
identification_remarks text YES Comments on the identification
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
verbatim_family text YES Verbatim taxon name
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
fk_tnrs_id bigint YES Foreign key to table 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
tnrs_warning text YES TNRS warnings, if any. 'No match', 'NULL', 'Partial match', 'TNRS resu… 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
higher_plant_group text YES Major higher plant group, not necessarily monophyletic (added by BIEN) 'Algae', 'Bacteria', 'bryophytes', 'ferns and a… 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 accepted taxon name 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'.
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'.
reproductive_condition text YES Reproductive condition (flowering, fruiting, sterile, etc.). Vocabulary not currently standardized.
occurrence_remarks text YES Any additional remarks accompanying observation. For specimens, this will be the description of the specimen.
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]
plantobservation_id integer YES [internal use]
aggregate_organism_observation_id text YES [internal use]
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)
stem_height_m numeric YES Stem height in m
cover_percent numeric YES Percent cover of this taxon (aggregate cover observations only)
cites text YES Current CITES listing for this taxon
iucn text YES IUCN Red List endangered status for this taxon.
usda_federal text YES USDA federal threatened & endangered status for this taxon, if applicable
usda_state text YES USDA state threatened & endangered status for this taxon, if applicable
is_embargoed_observation smallint YES Is locality information for this records hidden due to endangered status of taxon? '1', 'NULL' MORE
geom USER-DEFINED YES Spatial object
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 smallint YES Is taxon known to be cultivated in declared political division? (NSR) '0', 'NULL' MORE
is_cultivated_taxon smallint YES Is taxon primarily cultivated? (NSR) '0', '1', 'NULL' MORE
is_cultivated_observation smallint 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
citation_verbatim text YES Citation for this observation (verbatim)
citation text YES Citation for this observation (bibtex)