Project

General

Profile

data requests

To obtain data from BIEN3, please follow our data request instructions.

The following extracts have been requested:

Request ID Requirements
date requester project view columns filters DISTINCT ON public needed by
2013-4-24 John Donoghue range modeling range_modeling_input
provider_count
-species, lat/long; in aggregated list: source, first publisher- geovalid, observation_is_plant, range_model_include most recent reobservation N -
2013-7-10 Naia geographic variation in the importance of species range limiting factors 2013-7-10.Naia. range_limiting_factors occurrenceID (numeric OK), "species (TNRS scrubbed), Latitude and Longitude" not cultivated, geovalid, lat/long uncertainty <= 10 km occurrence N -
2013-11-5 Brian E BIEN app bien_app "1) genus, specific_epithet, 2) family, 3) growth habit, 4) the GPS coordinates (lat/long) of the center of the gridded map square at sufficient resolution" ("on a 100 km2 grid") geovalid "Each species may have multiple rows to cover its occurrence in multiple squares" N -
completed
2015-1-16 Bob Peet sPlot 2015-1-16.Bob_Peet.sPlot "
PlotName
locationevent_ID; a primary key/GUID indicating distinct plots
Plot.Area (sq. m; need to multiply the current values in ha by 10,000 to obtain in units of m2)
decimalLatitude
decimalLongitude
coordinateUncertaintyInMeters
Scrubbed_taxon_name_no_author: Species name
coverPercent
EventDate
ElevationInMeters
SlopeGradient
SlopeAspect
Country
CommunityConcept.Name
"
"Include only plots from source databases: CVS, VegBank, Salvias" "ViewFullOccurrence" Y "end of January [2015]"
2014-11-16 Ana Maria Csergo demography and habitat suitability 2014-11-16.Ana_Maria_Csergo. demography_and_habitat.public
2014-11-16.Ana_Maria_Csergo. demography_and_habitat.private
"geographic coordinates of the species of interest (not vegetation data), together with taxonomic, location uncertainty and data provider information", "in a separate column the datasources whose data IS NOT OPEN" [will provide separate public and private extracts instead], "
datasource
country
locality
latitude
longitude
coord_uncertainty_m
georef_sources
georef_protocol
is_geovalid
is_new_world
is_location_cultivated
custodial_institution_codes
collection_code
catalog_number
recorded_by
date_collected
verbatim_family
verbatim_scientific_name
identified_by
date_identified
identification_remarks
family_matched
name_matched
name_matched_author
taxonomic_status
scrubbed_family
scrubbed_genus
scrubbed_specific_epithet
scrubbed_species_binomial
scrubbed_taxon_name_no_author
scrubbed_author
scrubbed_taxon_name_with_author
is_cultivated
"
"exclude GBIF data" - Y -
2014-10-18 Jürgen Dengler sPlot 2014-10-18.Juergen_Dengler. sPlot "
Minimum requirements
1. Full species list with importance values (cover or abundance) per species
2. Geographic coordinates: latitude and longitude
3. Information on cover scale (or other performance measure) that allows us transformation to a common standard (%) [we provide cover %]
4. Indication whether certain species groups are not recorded (e.g. all terricolous species, only vascular plant species, only trees above a certain dbh) [our datasources don't provide this]
5. Precision of the geographic coordinates (either in meters/kilometers or on ordinate scale [...])
6. Naturalness (assigned to one of the following 3 categories: natural; semi-natural; anthropogenic) [our datasources don't provide this]
7. Formation ([eg.] forest, shrubland, grassland, wetland, sparsely vegetated [...]) [this is the community]
[...]
Highly desirable
- Plot size (m2)
- Date of recording [...]
- Country (or ISO country code)
- Slope inclination (°) and aspect (°)
- Altitude (m a.s.l.)
- Height of vegetation (of the highest layer) (m) [we have this by stem instead]
- Total cover of vegetation(%) [cover %]
- Type and frequency of land use (e.g. mowing, grazing, burning, wood extraction [...]) [our datasources don't provide this]
[...]
Metadata required per vegetation-plot database [see e-mail addressing these]
- Description of sampling approach and scope of the database: is there any special focus?
- Taxonomic reference list for species (which source(s) did you use? [...])
- Brief description of each header field (if available)
- Ownership of the database
- Contact data
- Specification of a custodian [...]
- GIVD number (if available) [...]
"
plots only stem [for height] Y "Oct 28 [2014]"
2013-3-1 Ramona traits taxon_trait "a file that lists the traits [occurrences] used by BIEN" - trait occurrence N -
2013-8-30 Brian E traits taxon_trait "[csv] of these data [BIEN2 trait occurrences in BIEN3] as well as a summary of the number (and names) of traits that we have" - trait occurrence N -
2013-10-18 Brian E Canadensys plant ranges 2013-10-18.Brian_Enquist. Canadensys "geographic coordinates, species" not cultivated, geovalid, specific species - N -
2013-11-14 Brian E traits taxon_trait "filter taxon_trait table to include only geovalid and TNRS-valid records" (2013-11-14 conference call) geovalid, TNRS-valid trait occurrence N -
2014-3-11 Jeff Ott climatic determinants of species ranges 2014-3-11.Jeff_Ott. climatic_range_determinants "decimalLatitude, decimalLongitude, higherPlantGroup, family, genus, speciesBinomial, scientificName"; "datasource" "geovalid, isNewWorld, cultivated"; "okay to include the restricted access sources" - N "mid-June [2014]"
2014-6-12 Jeff Ott climatic determinants of species ranges 2014-6-12.Jeff_Ott. climatic_range_determinants + "isIntroduced [not available for most datasources, and Jeff OK without it], coordinateIncertaintyInMeters, and observationDate"; "most recent sampling date"; "geovalid" +"all occurrences over time"; "coordinate fuzziness only to the extent that the radius of fuzziness is larger than my pixel size (currently 10x10km)"; "geovalid field with both null and non-null values"; "coordinates within the New World [as opposed to country names]" - N "mid-June [2014]"
2014-6-4 Iara Lacher reserve prioritization by niche breadth 2014-6-4.Iara_Lacher. reserve_prioritization "
country
date of collection
type of collection (herbarium, observation, record, etc)
original data source (the specific herbarium, university, etc)
species information [for accepted name] (family, genus only, genus and species, subspecies [by itself in a field], synonym [not needed b/c only including accepted names]; [not necessary to include the taxon name author])
• functional trait information (C4 vs C3, nitrogen fixing, etc) [DBH, height]
Life form (tree, shrub, annual, perennial, etc)
protection status (IUCN, nature serve, or by other organization ranking system - global, national, state) [purpose: "I need it in order to classify the species by vulnerability"]
"
"
georeferenced species occurrence data
South America, no Central American countries
Only flora [by including only records with a scrubbed taxon name] - if possible to filter I only need: native flora and terrestrial not aquatic
";
only accepted names
- N "July 1st [2014]"
2014-8-8 Bob Peet analytical table extracts viewFullOccurrence_CVS
viewFullOccurrence_VegBank
viewFullOccurrence_NCU
(all) "5000 lines from each of the datasets I care about (CVS, VegBank, NCU)" viewFullOccurrence N "in time for the Monday meeting" [2014-8-11]
2014-8-19 Brad native status resolver native_status_resolver "
id: a unique identifier that will allow you to join the records back to BIEN after I am finished. This can be whatever format or data type you want, it will be preserved exactly as provided
family
genus
species_binomial : not null
country
stateProvince
county
"
"
isGeovalid=true
isNewWorld=true
species_binomial IS NOT NULL
"; country IS NOT NULL
"a SELECT DISTINCT" N -
postponed
2014-1-16 general use species co-occurrences plot_cooccurrence plot ID, plot area, species A, species B not cultivated, in a plot, plot small enough to be considered co-occurrence species presence CROSS JOIN species N -
cooccurrence_dist species A, lat/long, species B, distance to & occurrenceID of nearest species B (if 0, use lat/long uncertainty, or plot area from plot_cooccurrence), is co-occurrence? not cultivated, geovalid occurrence CROSS JOIN species N -
cooccurrence_freq species A, species B, co-occurrence %, total # occurrences # co-occurrences > 0 species CROSS JOIN species N -

progress: 12 of 15 (80%) done

missing

  1. trait info (join to analytical_stem)
  2. is native
  3. is terrestrial
  4. grid-cell center coords: truncate degrees to # digits that will create the desired grid-cell spacing
  5. removal of cultivated outliers
  6. removal of reobservations from those datasources that have them
  7. range modeling filters
  8. co-occurrence views

see also