...
Preingestion processing of targeted tables
The SUSPECIES table combines three different FOI’s and data types for plants:
survey based data for plant species which are observed on plots
opportunistic samples of plant occurrences which are plot-less
Because of this the data will be separated on two tables for processing.
Survey columns
Select data for survey only
| Code Block |
|---|
bdbsa.supatch."SITETYPE" = 'SU' |
2. Separate “PLANTEDRELEASED” and species_name columns into “PLANTEDRELEASED_tree” and “species_name_tree”
| Code Block |
|---|
"DBH" is not null |
and “PLANTEDRELEASED_population” and “species_name_population”
| Code Block |
|---|
"DBH" is null |