aodn / public-schema

Shared schema specifications for data exchange (WFS, CSV, etc...)
GNU General Public License v3.0
1 stars 0 forks source link

Update filters for BGC plankton products #32

Closed leonardolaiolo closed 2 years ago

leonardolaiolo commented 2 years ago

Claire requested to update filters for BGC and CPR products, here relevant parts of the email exchange:

'% f.%', '%var.% are allowed and should not be filtered out as they are defined and accepted species
ALL_phytoplankton_abundance_species -> 'spp.', '%cf.%', '%/%', '%complex%', '%type%', '%cyst%'
ALL_zooplankton_abundance_non_copepods_data -> 'spp.', '%cf.%', '%/%', '%grp%', '%complex%'
ALL_zooplankton_abundance_copepods_data.sql ->  ‘spp.', '%cf.%', '%/%', '%grp%', '%complex%'
These should be the same as for the NRS & CPR products.
The lists apply to NRS and CPR and every product that is looking at species level.
Only .cf needs to be filtered out of the genus products and this again is NRS and CPR, zoop and phyto.

Furthermore: this branch includes updates on bgc_trip_metadata, bgc_zooplankton_map and bgc_phytoplankton_map consistently with product specs and updates in CSIRO Geoserver