dbpf_manual_obs_plot_xlsx: Import plot data and manual observations from XLS file into...

View source: R/dbpf_manual_obs_plot_xlsx.R

dbpf_manual_obs_plot_xlsxR Documentation

Import plot data and manual observations from XLS file into DB

Description

Tests and optionally inserts manual observations into DB.

Usage

dbpf_manual_obs_plot_xlsx(con, file_xlsx, mode = "test", overlap = "prevent")

Arguments

con

Database connection object, as returned by dbpf_con()

file_xlsx

file name of the xlsx workbook to be imported [character]

mode

Should data be inserted into DB? Defaults to 'test' so that only testing information is returned. To insert: 'insert'

overlap

Can be 'allow' or 'prevent' (default) and governs whether a new polygon can overlap an existing one.

Details

Data is checked for existence (or duplication) of sensor and location and feedback is returned. If this is the first time a plot is being added, the testing will return a warning that the plot location doesn't exist in the database.

Author(s)

Stephan Gruber <stephan.gruber@carleton.ca>

Examples

## Not run: 
con  <- dbpf_con()
dbpf_manual_obs_plot_xlsx(con, file_xlsx)
dbDisconnect(con)

## End(Not run)

geocryology/PermafrostDB documentation built on April 17, 2025, 11:54 a.m.