get_taxonomy_epd: Query the taxonomy table of the EPD

In dinilu/EPDr: Interact with the European Pollen Database (EPD)

Description

The function queries the whole taxonomy of the database by combining information from the P_VARS and P_GROUP tables. Because it queries all the records in the database it only requires a valid connection to the database server as parameter.

Usage

get_taxonomy_epd(connection)

Arguments

connection

PostgreSQLConnection. Object of class PostgreSQLConnection as returned by function connect_to_epd.

Details

Some users may find this function useful but it has been mainly implemented to be used by other functions in the EPDr package.

Value

data.frame The function return a data.frame with the combined information from P_VARS and P_GROUP tables of the database (see documentation of the EPD: http://www.europeanpollendatabase.net/data/downloads/image/pollen-database-manual-20071011.doc).

Examples

## Not run: 
epd.connection <- connect_to_epd(host = "localhost", database = "epd",
                              user = "epdr", password = "epdrpw")
epd.taxonomy <- get_taxonomy_epd(epd.connection)
epd.taxonomy

## End(Not run)

dinilu/EPDr documentation built on Aug. 22, 2019, 1:03 p.m.