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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='2900191' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-2900191.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900062' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900062.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900068' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900068.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900095' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900095.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900096' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900096.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900097' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900097.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900098' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900098.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900099' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900099.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900101' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900101.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900102' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900102.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900103' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900103.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900104' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900104.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900105' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900105.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900106' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900106.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900107' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900107.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900108' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900108.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900118' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900118.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900119' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900119.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900151' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900151.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900152' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900152.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900153' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900153.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900159' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900159.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900161' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900161.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900162' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900162.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900163' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900163.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900164' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900164.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900165' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900165.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3900166' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-3900166.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='39033' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-39033.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='39034' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-39034.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='39048' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-39048.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='4900313' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-4900313.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='4900314' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-4900314.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='4900315' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-4900315.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='4900333' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-4900333.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='4900334' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-4900334.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='4900335' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-4900335.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900070' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900070.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900083' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900083.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900087' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900087.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900089' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900089.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900128' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900128.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900130' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900130.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900132' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900132.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900202' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900202.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900203' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900203.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900208' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900208.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900209' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900209.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900210' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900210.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900211' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900211.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900212' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900212.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900213' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900213.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900232' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900232.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900263' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900263.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900268' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900268.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900273' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900273.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900274' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900274.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900275' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900275.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900282' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900282.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900283' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900283.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900284' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900284.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900285' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900285.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900286' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900286.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900287' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900287.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900288' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900288.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900289' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900289.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900290' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900290.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900300' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900300.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900301' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900301.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900302' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900302.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900303' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900303.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900304' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900304.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900312' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900312.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900313' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900313.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900324' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900324.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900325' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900325.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900327' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900327.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900329' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900329.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900352' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900352.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900354' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900354.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900358' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900358.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900359' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900359.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900360' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900360.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900361' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900361.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900362' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900362.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900363' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900363.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900364' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900364.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900365' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900365.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900366' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900366.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900367' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900367.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900368' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900368.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900386' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900386.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900404' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900404.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900405' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900405.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900406' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900406.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900407' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900407.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900408' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900408.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900430' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900430.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900431' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900431.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900432' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900432.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900433' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900433.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900434' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900434.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900435' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900435.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900436' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900436.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900437' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900437.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900438' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900438.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900439' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900439.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900440' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900440.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900441' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900441.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900442' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900442.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='5900451' and cs.classification_code=1;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/argo-profiles-5900451.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='3EZI6' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-3EZI6.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='9VRA' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-9VRA.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='A8BT5' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-A8BT5.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='DDGY' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-DDGY.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='ELVX4' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-ELVX4.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='ELVZ6' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-ELVZ6.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='ELYT5' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-ELYT5.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='ELZT3' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-ELZT3.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='GZKA' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-GZKA.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='H9TO' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-H9TO.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JGQH' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-JGQH.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JLOJ' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-JLOJ.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JNSR' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-JNSR.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JPBN' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-JPBN.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JSVY' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-JSVY.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='NFBS' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-NFBS.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='NTLW' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-NTLW.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='OWKF2' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-OWKF2.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='OYYK2' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-OYYK2.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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_20250302_172640_15162881/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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='V2CA2' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-V2CA2.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='V2FA2' and cs.classification_code=2;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/xbt-profiles-V2FA2.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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_20250302_172640_15162881/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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='9VRA' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-9VRA.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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_20250302_172640_15162881/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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='CGAL' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-CGAL.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='DDGY' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-DDGY.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXO12385' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXO12385.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXO12756' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXO12756.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXO12982' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXO12982.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXO12991' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXO12991.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXO13004' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXO13004.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXO13161' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXO13161.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXOC0131' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXOC0131.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXOC0254' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXOC0254.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXOC0256' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXOC0256.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXOC0271' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXOC0271.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXOC0272' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXOC0272.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXOC0284' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXOC0284.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='EXOC1238' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-EXOC1238.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JGQH' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-JGQH.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JHPO' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-JHPO.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JIFH' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-JIFH.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JNSR' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-JNSR.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='JPBN' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-JPBN.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='MIHO' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-MIHO.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='NFBS' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-NFBS.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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_20250302_172640_15162881/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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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_20250302_172640_15162881/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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='WTDK' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-WTDK.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='WTEC' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-WTEC.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, 6, 9) AND (cs.restriction = 'P' or cs.restriction is null) AND cs.station_id = s.station_id AND s.latitude <= 7.786 AND s.latitude >= -9.58 AND ((s.longitude <= -70.522 AND s.longitude >= 141.568) OR (s.longitude <= MOD(-70.522+360, 360) AND s.longitude >= MOD(141.568+360, 360)) OR (s.longitude <= MOD(-70.522-360, 360) AND s.longitude >= MOD(141.568-360, 360)) ) AND s.station_date <= TO_DATE('01/12/2003 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND s.station_date >= TO_DATE('01/01/2003 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 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='WTEU' and cs.classification_code=3;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250302_172640_15162881/ctd-profiles-WTEU.csv;-time=iso -valid_qc=12578