search

cioos-siooc / cioos-pacific-erddap

CIOOS Pacific ERDDAP main repository used to maintain, develop and integrate ERDDAP datasets.
https://data.cioospacific.ca/erddap
2 stars 0 forks source link

UBC dataset oxygen data #9

Closed JessyBarrette closed 1 year ago

JessyBarrette commented 1 year ago

UBC Historical oxygen data is available for data in mg/L and others in mL/L

units n profiles associated
mg/L [1787](https://pac-dev2.cioos.org/erddap/tabledap/IOS_UBC_profiles.htmlTable?profile&time%3E=1951-05-16T15%3A42%3A00Z&time%3C=1989-12-20T06%3A40%3A00Z&DOXYZZ01_mg%3E=0&distinct()&orderByCount(%22%22))
mL/L [4961](https://pac-dev2.cioos.org/erddap/tabledap/IOS_UBC_profiles.htmlTable?profile&time%3E=1951-05-16T15%3A42%3A00Z&time%3C=1989-12-20T06%3A40%3A00Z&DOXYZZ01%3E=0&distinct()&orderByCount(%22%22))

The main issue is how do we address those different units which are both attached to the same BODC name DOXYZZ01 http://vocab.nerc.ac.uk/collection/P01/current/DOXYZZ01/

Two solutions come to my mind:

  1. Convert one of the two towards the other unit ex: mg/L -> mL/L (which is the same unit as other IOS datasets)
  2. Keep both separated into two different variables.

I split the two right now into two different variables just to present the extent of this issue.

related to HakaiInstitute/cioos-pacific-erddap-public#19

JessyBarrette commented 1 year ago

mg/L data will be converted to mL/L with the equation do_mgl*22.319/31.998 = do_ml_l