ForIT_DataBase: 'ForIT'-package Database - Ver.2

In npuletti/ForIT: Functions to estimate tree volume and phytomass in the Italian forest inventory 2005

Description

The package exposes 5 tightly interconnected tibbles:
INFCspecies, INFCcatalog, Quantities, INFCparam, INFCf_domains
Tables columns
INFCspecies

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

• pag: section page number

• 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

• 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

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

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

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

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

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, verivied 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)

npuletti/ForIT documentation built on Dec. 29, 2021, 7:50 a.m.