...
Because of this and rows in the mapping have a 1:1 relationship with an FoI (i.e. a parameter cannot belong to more than one FoI), the data will be separated into three tables for processing: survey-plant population, survey-plant individual and opportunistic-plant occurrence.
Columns from other tables shared across FOI’s
suplantlfstage has to be join to the suspecies table
| Code Block |
|---|
join bdbsa.suplantlfstage s on s."SPSEQNR"= spp."SPSEQNR" and s."VISITNR" = sv."VISITNR" |
This table contains two parameters that are shared across plant opportunistic, population and individual FOI’s.
Notice that the following columns need to be created for occurrence, individuals and populations
“LIFESTAGECODE”, “SPECIESTYPE”
Survey columns individuals
...