list_publ: List publications in the EPD

Description Usage Arguments Value Examples

View source: R/EPDr-list_functions.R

Description

This function looks into the database and returns all combined information in the PUBLENT and PUBL tables (see documentation of the EPD: http://www.europeanpollendatabase.net/data/downloads/image/pollen-database-manual-20071011.doc). This information refers to the original publications in which entities were described. Because the function returns a whole table, only a valid connection to the database is mandatory. However, the list of publications can be further restricted to specific entities, countries, administrative regions, sites, or a geographical region defined by geographical coordinates (longitude and latitude) of its corners.

Usage

1
2
list_publ(connection, e_ = NULL, country = NULL, region = NULL,
  site = NULL, coords = NULL)

Arguments

connection

PostgreSQLConnection Object of class PostgreSQLConnection as returned by function connect_to_epd.

e_

numeric Numeric vector indicating the desired entities identification number.

country

character Character vector indicating the three letters code or the full name of the desired countries.

region

character Character vector indicating two digit integer code or the full name of the desired regions.

site

numeric Vector indicating the desired sites. Sites can be defined by the site identification number, the site code, or the site name.

coords

numeric Vector of four numeric values, indicating the spatial extent in decimal degrees. The extent should be specified using the following format c(xmin, xmax, ymin, ymax). Where x represents longitude and y represents latitude.

Value

Data frame with 5 columns:

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
## Not run: 
epd.connection <- connect_to_epd(host = "localhost", database = "epd",
                                 user = "epdr", password = "epdrpw")
list_publ(epd.connection)
list_publ(epd.connection, e_ = 1)
list_publ(epd.connection, site = "1")
list_publ(epd.connection, country = "ESP", site = 1)
list_publ(epd.connection, country = "Spain", region = "01")
str(list_publ(epd.connection))
list_publ(epd.connection, coords = c(2.5, 22, 45.5, 53.5))
str(list_publ(epd.connection, coords = c(2.5, 22, 45.5, 53.5)))

## End(Not run)

dinilu/EPDr documentation built on Jan. 13, 2018, 9:03 p.m.