https://ternaus.atlassian.net/wiki/spaces/BDBSA/pages/2450096182/2022-05-30+Meeting+notes
separate suspecies table into opportunistic- and survey- based records for processing
https://ternaus.atlassian.net/wiki/spaces/BDBSA/pages/2477719596/2022-07-05+Meeting+notes
No need to ingest soil and geology data
will need to take Fauna holistically
We will ingest 4-5 sites for each of the project to make it easier to test during the development phase
https://ternaus.atlassian.net/wiki/spaces/BDBSA/pages/2475425815/2022-07-12+Meeting+notes
Do not add flsp."LIFESPAN"
suvisageclass won’t be included
DOMINSPCODE legacy data not to be ingested with plant community
Dropping OSTOREYSPECHTNR, SHRUBSPECHTNR,GROUNDSPECHTNR frmo suvisit as >99% of rows empty
suplantassemb to be ingested
exclude suupstorey and suovermeasures tables
https://ternaus.atlassian.net/wiki/spaces/BDBSA/pages/2514845697/2022-08-16+Meeting+notes
separate NUMOBSERVED variables into presence and number of individuals observed
RECSTATUS to not be ingested
https://ternaus.atlassian.net/wiki/spaces/BDBSA/pages/2484273160/2022-08-18+Meeting+notes
presence to CV with two values (none observed and present)
Only record prepend with “AD” is used in herbarium specimens
NUMOBSERVED as a string as it contains range values (e.g. a single observation can be “100-1000”)
NUMBER of traps values to be sum at the site level across (“A” and “B” values)
Morphometrics values are assumed to come from single animals including fish
Filter all records by ISCERTAIN = Y