Duplicate GTS IDs in SOT metadata export

[anthoninlize]

Duplicated GTS-ID
C6YM7
VRCS2
VRPY7
VRDK7
VRLA6
WARL
V7UT7
C6AT2
ONIS
C6BQ8
9V2727
9V9726
VRKQ7
VRMM1
VRNY5
KLBO
VRJZ9
C6BQ4
9V3913
V7YW4
V7VY7
VRGG6
VRIZ5
V7IK7
3FKS5
VRNL8
VRYO9
3FMK7
VROH8
VRXL8
V7QJ5
MCMA3
C6YM5
C6AB9
WDJ4909
VRKX7
VROG7
VRZU4
VRCJ2
WDJ4009
7KHZ
VAAP
A8ZA9
S6NQ
VRIR7
KEBO
C6YM7
VRLT9
D5LJ2
3FFA5
V7HU7
9VHE2
A8ZA8
VROY7
VRLZ7
C6BW3
VRDN6
OWDW2
9VMU5
VRLX5
V7QJ9
VRYO7
VRNE6
VRMS3
VRLL2
VRDU9
VRPY5
VRIF9
9V2907
7JZJ
VRGP2

GMHQL8E
ZGFY4
TBWUK90

Originally posted by @jbcohuet in #27 (comment)

[anthoninlize]

GMHQL8E: double SOT ID allocation with 3DTM8TS. 3DTM8TS is already in WIGOS, so will be kept as the main SOT ID for referencing the station in OceanOPS and WIGOS, but GMHQL8E is the GTS ID at the moment. Station with SOT ID = GMHQL8E (OceanOPS reference) deleted.
ZGFY4: no issue, prev allocation by US and now by JP
TBWUK90: duplicate records (GEJKWMT and RVDDL2B). RVDDL2B will be kept, GEJKWMT deleted.

[MartinOceanOPS]

attention start date of remaining pft must be older than any other start date for this GTS ID

C6YM7 keep XJZWPUC merge all data delete other 5 ptfs
VRCS2 keep QWXVHBT merge all data delete 1 other ptf
VRPY7 keep PTTRRMC merge all data delete 2 other ptfs
VRDK7 keep EKUW6KU merge all data (mad) delete 1 other ptf
VRLA6 keep 6XFVWGY mad, delete1 ptf (del 1)
WARL keep QQT7NWN mad, del 1
V7UT7 keep XYF9ZMA mad, del 1
C6AT2 keep LFF27WL mad, del 1
ONIS keep PRNWGLT mad, del 3
C6BQ8 keep TLTCYZS mad, del 3
9V2727 keep UTH48AN mad, del 3
9V9726 keep XVW6ZJG mad, del 3
VRKQ7 keep JZRT63R mad, del 1
VRMM1 keep LGVQDDT mad, del 3
VRNY5 keep XVJQ26X mad, del 3
KLBO keep WBF742Q mad, del 2
VRJZ9 keep HGVBWBU mad, del 4
C6BQ4 keep RND2ATF mad, del 3
9V3913 keep 7CZUHXA mad, del 2
V7YW4 keep PBDD34C mad, del 3
V7VY7 keep GBEPLVG with data after 3 march 2019 and keep JQZWA9K (closed) with data before that date
VRGG6 keep RUWPHUL mad, del 1
VRIZ5 keep XVYWJHU mad, del 1
V7IK7 keep ZLSLSNY mad, del 1
3FKS5 keep EHHNBAG mad, del 3
VRNL8 keep FUDZFUR mad, del 3
VRYO9 keep JZE3Y3X with data after 28 March 2016 and keep 4MKX45G (closed) with data before that date, del 2
3FMK7 keep WQPTEDL mad, del 2
VROH8 keep 6XX47DX mad, del 2
VRXL8 keep XAQRYWT mad, del 3
V7QJ5 keep KGEPYGP mad, del 2
MCMA3 wait for feedback from DE, US (double recruit)
C6YM5 keep YVEGH3T mad, del 4
C6AB9 keep 4ZAB69W mad, del 2
WDJ4909 keep UGW4GUH mad, del 2
VRKX7 keep MPNXXCW mad, del 3
VROG7 keep UWUSN2V mad, del 3
VRZU4 keep LJK5UEH mad, del 2
VRCJ2 keep 5SY8AWT mad, del 2
WDJ4009 keep XATTY9V mad, del 2
7KHZ wait for feedback from JP, US (should go fully to JP)
VAAP check if there is a bug as website query also provides station with SOT ID; could be manned vos with call sign for US, AWS with SOT-ID for Canada
A8ZA9 keep PDGCRXN mad, del 4
S6NQ keep 3VY3U6Q mad, del 3
VRIR7 keep 3QXMUMB mad, del 1
KEBO keep RYVPNUT mad, del 2
C6YM7 keep NLV9QJK mad, del 5
VRLT9 keep HGE86UJ mad, del 2
D5LJ2 keep 9HEVB2Y mad, del 2
3FFA5 keep VUBSTAS mad, del 3
V7HU7 keep WRJP3QF mad, del 3
9VHE2 double recruit, wait feedback US/DE, should normally go to DE
A8ZA8 keep LHHDHCK mad, del 1
VROY7 keep FDYHQ7G mad, del 1
VRLZ7 keep 8NGK6WT mad, del 2
C6BW3 keep LEBQN2L mad, del 3
VRDN6 keep ZSJX68Z mad, del 3
OWDW2 keep CTP2WKE mad, del 1
9VMU5 keep PFGT8SL with data after 1 June 2004, keep HFB5P8N (closed) with data before that date, del 1
VRLX5 keep QCYS9MS mad, del 3
V7QJ9 double recruit US/Korea, should normally go to US, wait for feedback
VRYO7 keep QMAGHYB with data after 25 May 2016 and keep XBUA4BZ (closed) with data before that date, del 1
VRNE6 keep 5VB3T4W mad, del 1
VRMS3 keep 8KUWCQW mad, del 2
VRLL2 keep 9UYWTQT mad, del 1
VRDU9 keep YYGVADM mad, del 1
VRPY5 keep WWT8TZU mad, del 1
VRIF9 keep XHBBCQP mad, del 3
9V2907 keep 7JN5CPC mad, del 3
7JZJ double recruit US/JP, normally with JP, wait for feedback
VRGP2 keep 9TXU3BN mad, del 2

[anthoninlize]

C6YM7 keep XJZWPUC merge all data delete other 5 ptfs
VRCS2 keep QWXVHBT merge all data delete 1 other ptf
VRPY7 keep PTTRRMC merge all data delete 2 other ptfs
VRDK7 keep EKUW6KU merge all data (mad) delete 1 other ptf
VRLA6 keep 6XFVWGY mad, delete1 ptf (del 1)
WARL keep QQT7NWN mad, del 1
V7UT7 keep XYF9ZMA mad, del 1
C6AT2 keep LFF27WL mad, del 1
ONIS keep PRNWGLT mad, del 3
C6BQ8 keep TLTCYZS mad, del 3
9V2727 keep UTH48AN mad, del 3
9V9726 keep XVW6ZJG mad, del 3
VRKQ7 keep JZRT63R mad, del 1
VRMM1 keep LGVQDDT mad, del 3
VRNY5 keep XVJQ26X mad, del 3
KLBO keep WBF742Q mad, del 2
VRJZ9 keep HGVBWBU mad, del 4
C6BQ4 keep RND2ATF mad, del 3
9V3913 keep 7CZUHXA mad, del 2
V7YW4 keep PBDD34C mad, del 3
V7VY7 keep GBEPLVG with data after 3 march 2019 and keep JQZWA9K (closed) with data before that date
VRGG6 keep RUWPHUL mad, del 1
VRIZ5 keep XVYWJHU mad, del 1
V7IK7 keep ZLSLSNY mad, del 1
3FKS5 keep EHHNBAG mad, del 3
VRNL8 keep FUDZFUR mad, del 3
VRYO9 keep JZE3Y3X with data after 28 March 2016 and keep 4MKX45G (closed) with data before that date, del 2
3FMK7 keep WQPTEDL mad, del 2
VROH8 keep 6XX47DX mad, del 2
VRXL8 keep XAQRYWT mad, del 3
V7QJ5 keep KGEPYGP mad, del 2
C6YM5 keep YVEGH3T mad, del 4
C6AB9 keep 4ZAB69W mad, del 2
WDJ4909 keep UGW4GUH mad, del 2
VRKX7 keep MPNXXCW mad, del 3
VROG7 keep UWUSN2V mad, del 3
VRZU4 keep LJK5UEH mad, del 2
VRCJ2 keep 5SY8AWT mad, del 2
WDJ4009 keep XATTY9V mad, del 2
A8ZA9 keep PDGCRXN mad, del 4
S6NQ keep 3VY3U6Q mad, del 3
VRIR7 keep 3QXMUMB mad, del 1
KEBO keep RYVPNUT mad, del 2
VRLT9 keep HGE86UJ mad, del 2
D5LJ2 keep 9HEVB2Y mad, del 2
3FFA5 keep VUBSTAS mad, del 3
V7HU7 keep WRJP3QF mad, del 3
A8ZA8 keep LHHDHCK mad, del 1
VROY7 keep FDYHQ7G mad, del 1
VRLZ7 keep 8NGK6WT mad, del 2
C6BW3 keep LEBQN2L mad, del 3
VRDN6 keep ZSJX68Z mad, del 3
OWDW2 keep CTP2WKE mad, del 1
9VMU5 keep PFGT8SL with data after 1 June 2004, keep HFB5P8N (closed) with data before that date, del 1
VRLX5 keep QCYS9MS mad, del 3
VRYO7 keep QMAGHYB with data after 25 May 2016 and keep XBUA4BZ (closed) with data before that date, del 1
VRNE6 keep 5VB3T4W mad, del 1
VRMS3 keep 8KUWCQW mad, del 2
VRLL2 keep 9UYWTQT mad, del 1
VRDU9 keep YYGVADM mad, del 1
VRPY5 keep WWT8TZU mad, del 1
VRIF9 keep XHBBCQP mad, del 3
9V2907 keep 7JN5CPC mad, del 3
VRGP2 keep 9TXU3BN mad, del 2

C6YM7 keep NLV9QJK mad, del 5 : not treated, clashes with instruction (already processed):
C6YM7 keep XJZWPUC merge all data delete other 5 ptfs

VAAP check if there is a bug as website query also provides station with SOT ID; could be manned vos with call sign for US, AWS with SOT-ID for Canada
No bug, the SOT ID 2QDZMLH used VAAP in the past.
What to do? @MartinOceanOPS

@anthoninlize I requested feedback from US/CA last week; if we really have 2 stations here I do not want to look into the headers of each obs to identify the "owner" - most likely all data go to CA until the started with SOT-ID; from that date data submitted with call sign could go to US

Still pending feedback

MCMA3 wait for feedback from DE, US (double recruit)
7KHZ wait for feedback from JP, US (should go fully to JP)
9VHE2 double recruit, wait feedback US/DE, should normally go to DE
V7QJ9 double recruit US/Korea, should normally go to US, wait for feedback
7JZJ double recruit US/JP, normally with JP, wait for feedback