dbRequest: Connect to the gbif4crest database

In mchevalier2/crestr: A Probabilistic Approach to Reconstruct Past Climates Using Palaeoecological Datasets

Connect to the gbif4crest database

Description

Connect to the gbif4crest_02 database by accessing the server on Amazon.

Usage

dbRequest(request, dbname = "gbif4crest_02")

Arguments

request	A SQL request to be executed.
dbname	The name of the data source database.

Value

The result of the request.

Examples

## Not run: 
  # Extracting the number of taxa recorded in the database
  dbRequest("SELECT count(*) FROM taxa")

  # Extracting all the taxa that have at least one occurrence in South Africa.
  southAfricaTaxa <- dbRequest(paste0(
    "SELECT DISTINCT taxa.* ",
    "FROM taxa, distrib_qdgc, geo_qdgc ",
    "WHERE taxa.taxonid=distrib_qdgc.taxonid ",
    "AND   distrib_qdgc.latitude=geo_qdgc.latitude ",
    "AND   distrib_qdgc.longitude=geo_qdgc.longitude ",
    "AND geo_qdgc.countryname='South Africa'"
  ))
  head(southAfricaTaxa)

## End(Not run)

mchevalier2/crestr documentation built on Feb. 14, 2025, 6:31 p.m.