...
The following logic is required for fish
Code Block FROM bdbsa.suvisit sv JOIN bdbsa.supatch sp ON sv."PATCHID" = sp."PATCHID" join bdbsa.suspecies spp on sv."VISITNR" = spp."VISITNR" join bdbsa.vssp vs on vs."NSXCODE" = spp."NSXCODE" full join bdbsa.analyses_length_wide alw on alw."VISITNR"= spp."VISITNR" and alw."SPECIESTYPE"= spp."SPECIESTYPE" and alw."NSXCODE" =spp."NSXCODE" full join bdbsa.sutrap str on str."VISITNR" = sv."VISITNR" where (spp."SPECIESTYPE" = 'F')
The following variables will be ingested:`
species_name, NUMOBSERVED, total_length, disc_length, mantle_length, fork_length, lower_jaw_fork_length, SPCOMM, SEX, WEIGHT, ACTIVITY, PLANTEDRELEASED, FYKENETDUR, FYKENETNR, BAITTRAPHRS, BAITTRAPNUM
For Reptiles
There should be 131,147 records
The following logic/joins are required
Code Block FROM bdbsa.suvisit sv JOINfrom suspecies spp left join bdbsa.supatchsutrap spstr ONon svstr."PATCHIDVISITNR" = spspp."PATCHIDVISITNR" left join bdbsa.suspeciessuvisit sppsv on sv."VISITNR" = spp."VISITNR" joinJOIN bdbsa.vsspsupatch vssp onON vssp."NSXCODEPATCHID" = sppsv."NSXCODEPATCHID" full join bdbsa.analyses_length_wide alw on alw."VISITNR"= spp."VISITNR" and alw."SPECIESTYPE"= spp."SPECIESTYPE" and alw."NSXCODE" =spp."NSXCODE" full join bdbsa.sutrap str on str."VISITNR" = sv."VISITNR" where (spp."SPECIESTYPE" = 'R')where (spp."SPECIESTYPE" = 'R' and "LENGTH" is null and "WEIGHT" is null);
The following variables will be ingested:
STRATANR, METHODNR, MACROHABNR, MICROHABNR, MACROHABNR, species_name, NUMOBSERVED, total_length, tail_length, PRESENCE, SPCOMM, SEX, WEIGHT, ISGRAVID, PLANTEDRELEASED, NUMNIGHTS, NUMELLIOTTRAP, NUMELLIOTNIGHTS, NUMPITTRAP, NUMPITNIGHTS, NUMCAGETRAP, NUMCAGENIGHTS
...