list_countries: List countries in the EPD

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

Description

This function looks into the database and returns all information in the POLDIV1 table (see documentation of the EPD: http://www.europeanpollendatabase.net/data/downloads/image/pollen-database-manual-20071011.doc). This belong to the country level in political and administrative level. Because the function returns a whole table, it only needs a parameter with a valid connection to the database.

Usage

list_countries(connection)

Arguments

connection

PostgreSQLConnection Object of class PostgreSQLConnection as returned by function connect_to_epd.

Value

data.frame The function returns a data frame with two columns: poldiv1 and name.

• "poldiv1" is a three letter code for each country.

• "name" is the full country name.

Examples

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

## End(Not run)

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