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