ForIT_DataBase {ForIT}

'ForIT'-package Database - Ver.2

Description

The package exposes 5 tightly interconnected tibbles:

INFCspecies, INFCcatalog, Quantities, INFCparam, INFCf_domains

Usage

INFCspecies

INFCcatalog

Quantities

INFCparam

INFCf_domains

Format

An object of class tbl_df (inherits from tbl, data.frame) with 44 rows and 3 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 26 rows and 4 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 5 rows and 2 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 130 rows and 5 columns.

An object of class tbl_df (inherits from tbl, data.frame) with 617 rows and 4 columns.

Details

Tables columns

INFCspecies

• EPPOcode [PK]: species code, adopting EPPO database

• pag: section page number in the original reference (Tabacchi et al., 2011a)

• PrefName: EPPO preferred name for the species

INFCcatalog

• pag [PK]: section page number in the original reference (Tabacchi et al., 2011a)

• n_oss: number of sample trees for the section

• n_par: number of parameters in the equations for the section

• section: section name (species or species group)

Quantities

• quantity [PK]: code of the estimated quantity

• quantity_definition: estimated quantity definition and measurement units

INFCparam

• pag [PK]: section page number in the original reference (Tabacchi et al., 2011a)

• quantity [PK]: code of the estimated quantity (see Quantities)

• wrv: weighted residual variance

• bm: functions coefficients (a list of arrays)

• vcm: variance-covariance matrices (a list of 'dspMatrix')

INFCf_domains

• pag [PK]: section page number in the original reference (Tabacchi et al., 2011a)

• htot.m [PK]: tree height class [m] (class width 1 m)

• dbh.min: minimum tree diameter class [cm] (class width 1 cm)

• dbh.max: maximum tree diameter class [cm] (class width 1 cm)

Columns bm and vcm are lists, the dimensions of the arrays and matrices they store vary depending on n_par.
Matrices in vcm are symmetric, stored as "dspMatrix" class objects.
Database schema is defined, verified and illustrated using package dm

library(dm)
ForIT_DB <- dm(INFCcatalog,
               INFCspecies,
               Quantities,
               INFCparam,
               INFCf_domains) %>%
  dm_add_pk(INFCcatalog, pag, check = TRUE) %>%

  dm_add_pk(INFCspecies, EPPOcode, check = TRUE) %>%
  dm_add_fk(INFCspecies, pag, INFCcatalog, check = TRUE) %>%

  dm_add_pk(Quantities, quantity, check = TRUE) %>%

  dm_add_pk(INFCparam, c(pag, quantity), check = TRUE) %>%
  dm_add_fk(INFCparam, pag, INFCcatalog, check = TRUE) %>%
  dm_add_fk(INFCparam, quantity, Quantities, check = TRUE) %>%

  dm_add_pk(INFCf_domains, c(pag, htot.m), check = TRUE) %>%
  dm_add_fk(INFCf_domains, pag, INFCcatalog, check = TRUE)

dm_examine_constraints(ForIT_DB)

dm_draw(ForIT_DB, rankdir = "BT", view_type = "all", column_types = T)