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

IOS UBC Duplicated variables Quality_Flag:Phos #15

Closed JessyBarrette closed 1 year ago

JessyBarrette commented 1 year ago

The following files present a duplicated variable Quality_Flag:Phos [IGOSS_flags]

from www.waterproperties.ca/osd_data_archive/UBC/6007/60070060.UBC

    $TABLE: CHANNELS
    ! No Name                 Units         Minimum        Maximum
    ! -- -------------------- ------------- -------------- --------------
       1 Depth                Metres        0              450
       2 Temperature          Degrees_C     8.17           12.41
       3 Quality_Flag:Temp    IGOSS_flags   1              1
       4 'Salinity: Pre-1978' PPT           25.74          30.63
       5 Quality_Flag:Sali    IGOSS_flags   1              1
       6 Oxygen               mg/l          4.299994       9.910007
       7 Quality_Flag:Oxyg    IGOSS_flags   1              1
       8 Phosphate            mmol/m**3     1.57           6.01
       9 Quality_Flag:Phos    IGOSS_flags   1              4
      10 Silicate             mmol/m**3     34             85
      11 Quality_Flag:Sili    IGOSS_flags   1              1
      12 Nitrite              mmol/m**3     0.1E-01        0.28
      13 Quality_Flag:Nitr    IGOSS_flags   1              1
      14 Phosphate(inorg)     mmol/m**3     0.69           5.23
      15 Quality_Flag:Phos    IGOSS_flags   0              0
      16 pH                   ' '           7.6            8.16
      17 Quality_Flag:pH      IGOSS_flags   1              1
    $END

The second flag column seems to be related to the Phosphate(inorg) variable.

www.waterproperties.ca/osd_data_archive/UBC/6007/60070060.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070061.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070062.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070063.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070065.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070069.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070070.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070071.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070072.UBC www.waterproperties.ca/osd_data_archive/UBC/6007/60070074.UBC www.waterproperties.ca/osd_data_archive/UBC/6011/60110001.UBC www.waterproperties.ca/osd_data_archive/UBC/6011/60110002.UBC www.waterproperties.ca/osd_data_archive/UBC/6011/60110003.UBC www.waterproperties.ca/osd_data_archive/UBC/6011/60110008.UBC www.waterproperties.ca/osd_data_archive/UBC/6011/60110009.UBC Detected issue in 15 files

JessyBarrette commented 1 year ago

We will rely on the first channel of the duplicated channels

JessyBarrette commented 1 year ago

This is already implemented as is. We can close that issue

guanlu129 commented 1 year ago

The second Quality_Flag:Phos should be for Phosphate(inorg).

JessyBarrette commented 1 year ago

Oh right! Thanks @guanlu129, that makes a lot of sense. I'm I'm not too sure how handle those then

JessyBarrette commented 1 year ago

This is ow resolved the second Quality_Flag:Phos column will be renamed Quality_Flag:Phosphate(inorg) if it is following the variable Phosphate(inorg)