list_regions: List (administrative) regions in the EPD

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

Description

This function looks into the database and returns all combined information in the POLDIV1 and POLDIV2 tables (see documentation of the EPD: http://www.europeanpollendatabase.net/data/downloads/image/pollen-database-manual-20071011.doc). Because the function returns a whole table, it only needs a parameter with a valid connection to the database. The list can be restricted to specific countries using parameter country.

Usage

list_regions(connection, country = NULL)

Arguments

connection	PostgreSQLConnection. Object of class PostgreSQLConnection as returned by function connect_to_epd.
country	Character vector indicating the three letters code or the full name of the desired countries.

Value

data.frame with four columns:

• "poldiv2"Region code consisting of two digit integer. This code is not a key field in the database and thus can be two regions with the same poldiv2 value. This field allows to differentiate regions within the same country.

• "poldiv1"Country code consisting of three capital letters. This code is unique for each country.

• "regionname"Region full name.

• "countryname"Country full name.

Examples

## Not run: 
epd.connection <- connect_to_epd(host = "localhost", database = "epd",
                              user = "epdr", password = "epdrpw")
list_regions(epd.connection)
list_regions(epd.connection, "ESP")
list_regions(epd.connection, "Spain")
list_regions(epd.connection, c("Spain", "France", "Germany"))

## End(Not run)

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