search

aodn / content

Tracks AODN Portal content and configuration issues
0 stars 0 forks source link

ABOS moorings location mistakes #375

Closed ggalibert closed 5 years ago

ggalibert commented 5 years ago

Just found some obvious mistakes in the location of the following ABOS sites:

Latitude is sometimes positive, sometimes negative:

select site_code, latitude, longitude from anmn_metadata.abos_all_map
where site_code = 'EAC0500'
site_code latitude longitude
EAC0500 27.32913 153.89885
EAC0500 -27.3291 153.8989
EAC0500 -27.3291 153.8989
... ... ...

An imos toolbox QC test can identify these typos early: https://github.com/aodn/imos-toolbox/wiki/QCProcedures#impossible-location-test---imosimpossiblelocationsetqc---compulsory

Also, looks like some deployments are missing a site_code global attribute. Some of which have -9999 for latitude and longitude.

ggalibert commented 5 years ago

The following deployments have positive latitudes:

EAC0500-2016-2018
EAC2000-2016-2018

Which impact the following files:

IMOS/ABOS/DA/EAC0500/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV01_EAC0500-2018-SBE37SMP-135_END-20180503T235852Z_C-20181024T032801Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV01_EAC0500-2018-SBE37SMP-200_END-20180503T235919Z_C-20181024T032804Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV01_EAC0500-2018-SBE37SMP-300_END-20180504T002909Z_C-20181024T032807Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV01_EAC0500-2018-SBE37SMP-40_END-20180504T003959Z_C-20181024T031118Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV01_EAC0500-2018-SBE37SMP-462_END-20180504T001857Z_C-20181024T032810Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV01_EAC0500-2018-SBE37SMP-80_END-20180504T003919Z_C-20181024T032742Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV00_EAC0500-2018-SBE37SMP-135_END-20180504T000001Z_C-20181024T032803Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV00_EAC0500-2018-SBE37SMP-200_END-20180504T000001Z_C-20181024T032805Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV00_EAC0500-2018-SBE37SMP-300_END-20180504T003001Z_C-20181024T032808Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV00_EAC0500-2018-SBE37SMP-40_END-20180504T004001Z_C-20181024T031120Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV00_EAC0500-2018-SBE37SMP-462_END-20180504T002001Z_C-20181024T032811Z.nc
IMOS/ABOS/DA/EAC0500/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC0500_FV00_EAC0500-2018-SBE37SMP-80_END-20180504T004001Z_C-20181024T032744Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC0500_FV01_EAC0500-2018-SBE39TP-100_END-20180504T003917Z_C-20181024T032646Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC0500_FV01_EAC0500-2018-SBE39TP-350_END-20180504T005834Z_C-20181024T032649Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/IMOS_ABOS-DA_TZ_20161101T000001Z_EAC0500_FV01_EAC0500-2018-SBE39TP-60_END-20180504T005016Z_C-20181024T032748Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC0500_FV01_EAC0500-2018-STARMON-MINI-170_END-20180503T224500Z_C-20181024T032633Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC0500_FV01_EAC0500-2018-STARMON-MINI-400_END-20180503T224500Z_C-20181024T032635Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC0500_FV00_EAC0500-2018-SBE39TP-100_END-20180504T004000Z_C-20181024T032647Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC0500_FV00_EAC0500-2018-SBE39TP-350_END-20180504T010000Z_C-20181024T032650Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000001Z_EAC0500_FV00_EAC0500-2018-SBE39TP-60_END-20180504T005001Z_C-20181024T032749Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC0500_FV00_EAC0500-2018-STARMON-MINI-170_END-20180503T224500Z_C-20181024T032635Z.nc
IMOS/ABOS/DA/EAC0500/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC0500_FV00_EAC0500-2018-STARMON-MINI-400_END-20180503T224500Z_C-20181024T032637Z.nc
IMOS/ABOS/DA/EAC0500/Velocity/IMOS_ABOS-DA_AETVZ_20160925T000002Z_EAC0500_FV01_EAC0500-2018-WORKHORSE-ADCP-119_END-20170602T033226Z_C-20181024T031925Z.nc
IMOS/ABOS/DA/EAC0500/Velocity/IMOS_ABOS-DA_AETVZ_20161025T000000Z_EAC0500_FV01_EAC0500-2018-WORKHORSE-ADCP-120_END-20161112T062229Z_C-20181024T031002Z.nc
IMOS/ABOS/DA/EAC0500/Velocity/IMOS_ABOS-DA_ETVZ_20161101T000000Z_EAC0500_FV01_EAC0500-2018-AQUADOPP-CURRENT-METER-460_END-20180503T055849Z_C-20181024T032716Z.nc
IMOS/ABOS/DA/EAC0500/Velocity/non-QC/IMOS_ABOS-DA_AETVZ_20160925T000002Z_EAC0500_FV00_EAC0500-2018-WORKHORSE-ADCP-119_END-20170602T033226Z_C-20181024T031948Z.nc
IMOS/ABOS/DA/EAC0500/Velocity/non-QC/IMOS_ABOS-DA_AETVZ_20161025T000000Z_EAC0500_FV00_EAC0500-2018-WORKHORSE-ADCP-120_END-20161112T062229Z_C-20181024T031008Z.nc
IMOS/ABOS/DA/EAC0500/Velocity/non-QC/IMOS_ABOS-DA_ETVZ_20161101T000000Z_EAC0500_FV00_EAC0500-2018-AQUADOPP-CURRENT-METER-460_END-20180503T060000Z_C-20181024T032719Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-1190_END-20180504T001002Z_C-20181024T030954Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-135_END-20180503T233016Z_C-20181024T031042Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-1811_END-20180503T234008Z_C-20181024T031045Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-200_END-20180503T235003Z_C-20181024T031040Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-300_END-20180503T234009Z_C-20181024T031037Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-40_END-20180504T001014Z_C-20181024T031121Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-485_END-20180503T235004Z_C-20181024T031034Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-610_END-20180504T001926Z_C-20181024T032739Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE37SMP-80_END-20180504T001845Z_C-20181024T031031Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-1190_END-20180504T001001Z_C-20181024T030956Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-135_END-20180503T233001Z_C-20181024T031044Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-1811_END-20180503T234001Z_C-20181024T031047Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-200_END-20180503T235001Z_C-20181024T031041Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-300_END-20180503T234001Z_C-20181024T031038Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-40_END-20180504T001001Z_C-20181024T031122Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-485_END-20180503T235001Z_C-20181024T031035Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-610_END-20180504T002001Z_C-20181024T032741Z.nc
IMOS/ABOS/DA/EAC2000/CTD_timeseries/non-QC/IMOS_ABOS-DA_STZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE37SMP-80_END-20180504T002001Z_C-20181024T031032Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-SBE39T-250_END-20180503T230846Z_C-20181024T032523Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-SBE39T-350_END-20180503T225838Z_C-20181024T032525Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-SBE39TP-1000_END-20180504T002333Z_C-20181024T032659Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-SBE39TP-100_END-20180504T020329Z_C-20181024T031111Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-SBE39TP-1500_END-20180503T232305Z_C-20181024T032710Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-SBE39TP-800_END-20180503T234341Z_C-20181024T032702Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T000001Z_EAC2000_FV01_EAC2000-2018-SBE39TP-60_END-20180504T013001Z_C-20181024T032750Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC2000_FV01_EAC2000-2018-STARMON-MINI-1300_END-20180503T222500Z_C-20181024T032627Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC2000_FV01_EAC2000-2018-STARMON-MINI-170_END-20180503T230000Z_C-20181024T032622Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC2000_FV01_EAC2000-2018-STARMON-MINI-1750_END-20180503T223500Z_C-20181024T032629Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC2000_FV01_EAC2000-2018-STARMON-MINI-400_END-20180503T224500Z_C-20181024T032624Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-SBE39T-250_END-20180503T231000Z_C-20181024T032524Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-SBE39T-350_END-20180503T230000Z_C-20181024T032526Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-SBE39TP-1000_END-20180504T002500Z_C-20181024T032701Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-SBE39TP-100_END-20180504T020500Z_C-20181024T031113Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-SBE39TP-1500_END-20180503T232500Z_C-20181024T032711Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-SBE39TP-800_END-20180503T234500Z_C-20181024T032704Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T000001Z_EAC2000_FV00_EAC2000-2018-SBE39TP-60_END-20180504T013001Z_C-20181024T032752Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC2000_FV00_EAC2000-2018-STARMON-MINI-1300_END-20180503T222500Z_C-20181024T032628Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC2000_FV00_EAC2000-2018-STARMON-MINI-170_END-20180503T230000Z_C-20181024T032623Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC2000_FV00_EAC2000-2018-STARMON-MINI-1750_END-20180503T223500Z_C-20181024T032630Z.nc
IMOS/ABOS/DA/EAC2000/Temperature/non-QC/IMOS_ABOS-DA_TZ_20161101T001000Z_EAC2000_FV00_EAC2000-2018-STARMON-MINI-400_END-20180503T224500Z_C-20181024T032626Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/IMOS_ABOS-DA_AETVZ_20160825T000059Z_EAC2000_FV01_EAC2000-2018-WORKHORSE-ADCP-120_END-20180506T212357Z_C-20181024T032102Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/IMOS_ABOS-DA_AETVZ_20160925T000100Z_EAC2000_FV01_EAC2000-2018-WORKHORSE-ADCP-120_END-20180506T075239Z_C-20181024T032342Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/IMOS_ABOS-DA_AETVZ_20161025T000000Z_EAC2000_FV01_EAC2000-2018-WORKHORSE-ADCP-650_END-20180506T080047Z_C-20181024T031423Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/IMOS_ABOS-DA_ETVZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-AQUADOPP-CURRENT-METER-1195_END-20180503T022823Z_C-20181024T032721Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/IMOS_ABOS-DA_ETVZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-AQUADOPP-CURRENT-METER-1500_END-20180503T015855Z_C-20181024T032725Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/IMOS_ABOS-DA_ETVZ_20161101T000000Z_EAC2000_FV01_EAC2000-2018-AQUADOPP-CURRENT-METER-1810_END-20180503T015858Z_C-20181024T030957Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/non-QC/IMOS_ABOS-DA_AETVZ_20160825T000059Z_EAC2000_FV00_EAC2000-2018-WORKHORSE-ADCP-120_END-20180506T213059Z_C-20181024T032126Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/non-QC/IMOS_ABOS-DA_AETVZ_20160925T000100Z_EAC2000_FV00_EAC2000-2018-WORKHORSE-ADCP-120_END-20180506T080324Z_C-20181024T032426Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/non-QC/IMOS_ABOS-DA_AETVZ_20161025T000000Z_EAC2000_FV00_EAC2000-2018-WORKHORSE-ADCP-650_END-20180506T081459Z_C-20181024T031444Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/non-QC/IMOS_ABOS-DA_ETVZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-AQUADOPP-CURRENT-METER-1195_END-20180503T023000Z_C-20181024T032723Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/non-QC/IMOS_ABOS-DA_ETVZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-AQUADOPP-CURRENT-METER-1500_END-20180503T020000Z_C-20181024T032727Z.nc
IMOS/ABOS/DA/EAC2000/Velocity/non-QC/IMOS_ABOS-DA_ETVZ_20161101T000000Z_EAC2000_FV00_EAC2000-2018-AQUADOPP-CURRENT-METER-1810_END-20180503T020000Z_C-20181024T031000Z.nc

I'm sending an email to Jenny today in this regard.

mhidas commented 5 years ago

Thanks @ggalibert !

mhidas commented 5 years ago

Jenny has uploaded new versions of all these files with the latitudes fixed.