Query data and transform stats to SE by calling fetch.stats2se;

Function to query data from database for specific species and convert stat to SE

query.data(
  trait,
  spstr,
  con,
  extra.columns = paste("ST_X(ST_CENTROID(sites.geometry)) AS lon,",
    "ST_Y(ST_CENTROID(sites.geometry)) AS lat, "),
  store.unconverted = FALSE,
  ids_are_cultivars = FALSE,
  ...
)

Arguments

trait

trait to query from the database

spstr

IDs of species to query from, as a single comma-separated string

con

database connection

extra.columns

other query terms to pass in. If unspecified, retrieves latitude and longitude

store.unconverted

determines whether or not a copy of the mean and stat fields are returned with _unconverted appended to the column names

ids_are_cultivars

if TRUE, ids is a vector of cultivar IDs, otherwise they are species IDs

...

extra arguments

See also

used in query.trait.data; fetch.stats2se; transformstats performs transformation calculations

Author

David LeBauer, Carl Davidson