populateLFMC: Populate LFMC data

In spif-ctfc/LFMC: Live Fuel Moisture Content Data Management and Analysis

Populate LFMC data

Description

Fills LFMC records from a data frame

Usage

populateLFMC(
  lfmc,
  dateIni = NULL,
  dateFin = NULL,
  dateFormat = "%Y-%m-%d",
  varmapping = c(Date = "DATA", SamplingSiteCode = "CODI_PARCELA", SpeciesCode =
    "CODI_ESPECIE", SampleCode = "NUM_MOSTRA", FreshMass = "PES_FRESC", DryMass =
    "PES_SEC", DryStem = "PES_TIGES", DryLeaf = "PES_FULLES", PhenologyCode =
    "fenologia", Notes = "Observacions"),
  overwrite = FALSE,
  outlierSearch = F
)

Arguments

lfmc	The data frame from which LFMC records are to be read.
dateIni	String to indicate the earliest date to import (using format in dateFormat).
dateFin	String to indicate the latest date to import (using format in dateFormat).
dateFormat	String with date format (see as.Date).
varmapping	Named vector of variable mappings (see details).
overwrite	Whether or not to overwrite existing records. LFMC records are uniquely identified with field 'SampleCode'.
outlierSearch	Logical to indicate if outliers search routine is run

Details

Mapping should be provided at least for 'Date', 'SamplingSiteCode', 'SampleCode' and 'SpeciesCode'. Variables 'LFMC' and 'LeafStemRatio' are by default calculated from imported values. Variable for 'Date' can be of class Date or a string. In the latter case date strings are expected to be in dateFormat.

Records with missing 'SampleCode' are discarded. Records already existing in the database (i.e. records corresponding to existing 'SampleCode' values) are also discarded, unless overwrite = TRUE. This allows adding only new records even if the input data frame contains records already existing in the database.

Examples

## Not run: 
# Initiate data base

initDB("../lfmc", overwrite = T)

# Parse records from file "2019.xlsx"

lfmc = openxlsx::read.xlsx("../LFMC_spif/2019.xlsx")
lfmc$DATA = openxlsx::convertToDate(lfmc$DATA)
populate_lfmc(lfmc)


# Parse records from another file using another (identity) mapping
varmapping2 = c("Date" = "DATA", "SamplingSiteCode"  = "CODI_PARCELA",
                "SampleCode" = "NUM_MOSTRA", "SpeciesCode" = "CODI_ESPECIE",
                "FreshMass" = "PES_FRESC", "DryMass" = "PES_SEC",
                "DryStem" = "PES_TIGES", "DryLeaf" = "PES_FULLES",
                "Notes" = "Observacions")
lfmc2 = openxlsx::read.xlsx("../LFMC_spif/2019.xlsx")
lfmc2$Date = openxlsx::convertToDate(lfmc2$Date)
populateLFMC(lfmc2, varmapping = varmapping2)

## End(Not run)

spif-ctfc/LFMC documentation built on Sept. 29, 2022, 2:21 a.m.