SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901641' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-1901641.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901089' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-3901089.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901670' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-3901670.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902574' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-4902574.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902721' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-6902721.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902799' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-6902799.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902934' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-6902934.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903054' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-6903054.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903055' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-6903055.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903056' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-6903056.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900546' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/argo-trajectory-7900546.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301560' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/drifting-buoys-1301560.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301564' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/drifting-buoys-1301564.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301734' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/drifting-buoys-1301734.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1501625' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/drifting-buoys-1501625.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07523' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/drifting-buoys-EXB07523.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2ICI4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-2ICI4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HA4987' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9HA4987.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HA5077' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9HA5077.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V3736' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9V3736.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V5244' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9V5244.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V5246' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9V5246.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V5247' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9V5247.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V6459' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9V6459.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V6463' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9V6463.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V7754' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9V7754.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9V9408' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-9V9408.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='A8RH6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-A8RH6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='ALBARO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-ALBARO.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='AZGM4MC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-AZGM4MC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='BFHM5UQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-BFHM5UQ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='CJUPDZS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-CJUPDZS.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DBBH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-DBBH.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FBLSEKE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-FBLSEKE.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNFP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-FNFP.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='GAZ35FF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-GAZ35FF.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='GWBWFCJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-GWBWFCJ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='KSKM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-KSKM.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='MRVWWQV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-MRVWWQV.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='S6AN5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-S6AN5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7HH2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-V7HH2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7IY5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-V7IY5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7JD2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-V7JD2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7QJ5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-V7QJ5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7UU5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-V7UU5.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='V7ZZ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-V7ZZ6.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRDG3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/tsg-VRDG3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('16/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('31/12/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -4 AND cl.lat_max >= -10 AND ((cl.long_min <= 14 AND cl.long_max >= 9) OR (cl.long_min <= MOD(14+360, 360) AND cl.long_max >= MOD(9+360, 360)) OR (cl.long_min <= MOD(14-360, 360) AND cl.long_max >= MOD(9-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -4 AND l.latitude >= -10 AND ((l.longitude <= 14 AND l.longitude >= 9) OR (l.longitude <= MOD(14+360, 360) AND l.longitude >= MOD(9+360, 360)) OR (l.longitude <= MOD(14-360, 360) AND l.longitude >= MOD(9-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNFP' and cl.classification_code=19;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250416_071317_15190547/other-time-series-or-trajectories-FNFP.nc; -valid_qc=12578