...
This table describes the characteristics of overstorey stratum (woody species). For the ingetion a new column called stratum_category needs to be created and filled with the correct stratum, in this case “overstorey” value.
Plant community and vegetation disturbance ingestion
The dataset for plant communities is spread across couple of tables for ingesting this data the folloing merge is needed
| Code Block |
|---|
select "PATCHID" , sv."VISITNR" , "VISITDATE" ,
"ISFIRESCARS" , "LASTFIREYEAR" , "ISFIREYRCERTAIN" ,
sv."STRFORMATIONNR", lstr."STRFORMATIONDESC",
lstr."STRLIFEFORMNR" ,lstr."PROJFOLCOVERNR"
from bdbsa.suvisit sv
join bdbsa.lustrformation lstr ON lstr."STRFORMATIONNR" = sv."STRFORMATIONNR" |
While all this variables will be ingested until review only the followin variables will be mapped:
LASTFIREYEAR
ISFIREYRCERTAIN
STRFORMATIONNR