SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='1901862' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-1901862.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='2903854' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-2903854.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5900261' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5900261.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5900785' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5900785.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901098' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5901098.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901242' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5901242.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901634' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5901634.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901635' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5901635.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901664' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5901664.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901671' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5901671.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5901694' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5901694.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902366' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5902366.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5902483' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5902483.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5903319' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5903319.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904441' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5904441.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904446' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5904446.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5904815' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5904815.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905169' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5905169.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905170' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5905170.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905199' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5905199.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905386' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5905386.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905467' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5905467.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905476' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5905476.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5905543' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/argo-profiles-5905543.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='A8HE4' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-A8HE4.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DFCW2' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-DFCW2.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DFCX2' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-DFCX2.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='ELYE9' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-ELYE9.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='HSB3403' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-HSB3403.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='JJVV' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-JJVV.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LADO6' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-LADO6.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LAEK7' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-LAEK7.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LAII7' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-LAII7.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LAKP7' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-LAKP7.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='LAPY7' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-LAPY7.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='NCPN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-NCPN.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='SHIP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-SHIP.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKCN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKCN.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKDA' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKDA.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLA' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKLA.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLD' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKLD.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLG' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKLG.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLI' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKLI.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLP' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKLP.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKML' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKML.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKMN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKMN.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKMQ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKMQ.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKNG' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKNG.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKPT' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VKPT.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VLKI' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VLKI.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VLNC' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VLNC.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VRDE7' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VRDE7.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VRDP4' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VRDP4.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VRDU8' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VRDU8.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VSXC4' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/xbt-profiles-VSXC4.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='A8HE4' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-A8HE4.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='A8IG9' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-A8IG9.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='A8KD7' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-A8KD7.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='CGAF' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-CGAF.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DFCW2' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-DFCW2.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DIDS' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-DIDS.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO12495' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-EXO12495.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXO12967' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-EXO12967.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='EXOC0189' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-EXOC0189.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='HSB3403' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-HSB3403.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='KAOU' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-KAOU.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='SHIP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-SHIP.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VJJF' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VJJF.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKCK' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKCK.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKCN' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKCN.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKDA' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKDA.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLD' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKLD.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLG' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKLG.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLI' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKLI.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKLP' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKLP.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKML' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKML.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKMN' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKMN.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKMQ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKMQ.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKNG' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKNG.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VKPT' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VKPT.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VLHJ' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VLHJ.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VLNC' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/ctd-profiles-VLNC.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='5801907' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/glider-profiles-5801907.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='58950' and cs.classification_code=4;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/glider-profiles-58950.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='DHSN' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/other-profiles-DHSN.csv;-time=iso -valid_qc=12578
SELECT s.station_id FROM CLASSIFICATION_STATION cs, (SELECT cs.STATION_ID from CLASSIFICATION_STATION cs,STATION s, (select platform_code from platform ) P WHERE S.platform_code = P.platform_code AND cs.classification_code IN (1, 2, 3, 4, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= -32 AND s.latitude >= -33 AND ((s.longitude <= 115.5 AND s.longitude >= 114) OR (s.longitude <= MOD(115.5+360, 360) AND s.longitude >= MOD(114+360, 360)) OR (s.longitude <= MOD(115.5-360, 360) AND s.longitude >= MOD(114-360, 360)) ) AND s.station_date <= TO_DATE('13/06/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('13/05/2000 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND EXISTS (SELECT P.profile_id FROM profile P WHERE P.physical_param_code in (35, 30) AND P.station_id = s.station_id) AND s.date_quality_code IN (1,2,5,7,8) AND s.position_quality_code IN (1,2,5,7,8) ) stationToDiff, STATION s, CLASSIFICATION_TYPE ct WHERE cs.station_id = stationToDiff.station_id AND s.station_id = cs.station_id AND ct.classification_code = cs.classification_code AND s.PLATFORM_CODE='VLSF' and cs.classification_code=9;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240613_181327_15039166/other-profiles-VLSF.csv;-time=iso -valid_qc=12578