Content Comparison

...

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 these variables will be ingested until review only the followin following variables will be mapped:

...

The data for plant functional type is on a single table, suplantassemb and has , with only two parameters. This table does not need pre-processing.

Voucher ingestion

Vouchered specimens are in the suvoucher sheet. The following is necessary:

1. Filter to only voucher containing AD in the museumherbmnr column

2. Generate unique record number (http://rs.tdwg.org/dwc/terms/recordNumber ) using prefix and vouchernr.

3. create specimen_holder column. Value is State Herbarium of South Australia

4. museumherbmnr corresponds to state catalogue number. ALA use also this field, but adds a space between alphabetic and numeric characters

5. Scientific name is the concatenation of following flsp columns fl."GENUS",fl."SP",
   fl."ISP1RANK" , fl."ISP1" , fl."SPAUTHOR"

6. Get values from DETERMINERNR1 for determiner column

7. NOTICE that DETERMINEDATE is not the same as the collection date that happened during VISITDATE

See code below for guidance

select sp."SITEID", sp."QUADSITE", sp."PATCHID", sv."VISITNR", sv."VISITDATE", 
 svo."PREFIX", svo."VOUCHERNR",--unique identifiers
 svo."MUSEUMHERBMNR", --used by ALA
-- svo."VOUCHERTYPE",svo."SPSEQNR", spp."SPECIESNR", 
 fl."GENUS",fl."SP",
 fl."ISP1RANK" , fl."ISP1" , fl."SPAUTHOR", 
 svo."DETERMINERNR1" , --svo."DETERMINERNR2", determiner 2 is not used
 svo."DETERMINEDATE", svo."ACCURACYCODE",--this is for the voucher?
 svo."VOUCHERCOMM" 
 from bdbsa.suvoucher svo
 join bdbsa.suspecies spp on spp."SPSEQNR" =svo."SPSEQNR" and spp."VISITNR" = svo."VISITNR" 
 join bdbsa.flsp fl on spp."SPECIESNR" = fl."SPECIESNR"
 join bdbsa.suvisit sv on sv."VISITNR" =svo."VISITNR" 
 join bdbsa.supatch sp on sp."PATCHID" = sv."PATCHID" 
 where substring("MUSEUMHERBMNR" , '[A-Z]{1,}') = 'AD'
 order by "VOUCHERTYPE"