list_publ: List publications 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 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

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:

• "publ_"Publication identification number.

• "e_"Entity identification number.

• "acc_"Short integers for local library accession number

• "yearofpubl"Year of publication.

• "citation"Complete bibliographic reference in the style of the journal "Ecology".

Examples

## 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 Aug. 22, 2019, 1:03 p.m.