crestr (version 1.2.1)

dbRequest: Connect to the gbif4crest database

Description

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

Usage

dbRequest(request, dbname = "gbif4crest_02")

Value

The result of the request.

Arguments

request

A SQL request to be executed.

dbname

The name of the data source database.

Examples

if (FALSE) {
  # 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)
}