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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301571' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301571.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301575' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301575.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301619' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301619.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301718' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301718.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301735.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301767' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301767.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301769' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301769.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301771' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301771.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301773' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301773.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301778' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301778.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301791' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301791.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301793' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301793.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301794' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301794.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301798' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301798.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301803' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301803.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1301804' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1301804.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1501725' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1501725.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1801671' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1801671.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1801674' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1801674.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1801678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1801678.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1801735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1801735.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='1801759' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-1801759.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='2801988' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-2801988.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='2802075' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-2802075.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='2802076' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-2802076.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='2802077' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-2802077.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='3101515' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-3101515.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='3801550' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-3801550.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='3801569' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-3801569.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='3801592' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-3801592.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='3801596' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-3801596.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='3801676' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-3801676.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='3801710' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-3801710.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101541' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101541.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101542' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101542.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101559' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101559.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101656' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101656.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101665' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101665.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101696' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101696.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101721' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101721.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101724' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101724.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101729' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101729.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101743' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101743.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101753' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101753.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101755' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101755.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101845' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101845.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101858' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101858.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101884' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101884.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4101885' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4101885.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4102559' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4102559.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4102669' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4102669.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402565' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402565.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402609' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402609.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402613' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402613.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402618' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402618.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402656' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402656.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402663' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402663.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402721' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402721.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402726' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402726.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402729' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402729.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402730' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402730.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402731' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402731.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402732' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402732.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402733' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402733.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402735.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402736' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402736.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402737' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402737.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402739' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402739.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402741' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402741.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402742' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402742.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402743' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402743.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402744' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402744.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402747' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402747.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402749' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402749.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402750' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402750.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402751' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402751.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402752' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402752.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402753' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402753.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402878' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402878.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402879' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402879.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402881' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402881.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4402882' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4402882.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4403568' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4403568.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4403569' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4403569.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4601782' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4601782.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4802506' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4802506.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4802602' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4802602.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='4803978' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-4803978.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='5301666' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-5301666.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='5501572' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-5501572.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='5801972' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-5801972.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='5801975' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-5801975.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='5801976' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-5801976.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='5801983' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-5801983.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='5802034' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-5802034.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6202597' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6202597.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6202598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6202598.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6202637' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6202637.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6202639' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6202639.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203516' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203516.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203607' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203607.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203612' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203612.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203632' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203632.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203634' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203634.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203639' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203639.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203651' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203651.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203741' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203741.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203753' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203753.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203773' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203773.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203778' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203778.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203784' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203784.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203795' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203795.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203797' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203797.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203807' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203807.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203823' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203823.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203824' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203824.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203825' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203825.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203826' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203826.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203839' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203839.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203844' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203844.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203845' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203845.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203846' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203846.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203854' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203854.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203864' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203864.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6203865' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6203865.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6204603' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6204603.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6204610' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6204610.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6204612' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6204612.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6301575' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6301575.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6301624' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6301624.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6401583' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6401583.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6401584' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6401584.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6401592' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6401592.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6401598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6401598.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6401759' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6401759.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6402587' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6402587.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6402619' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6402619.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6402621' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6402621.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6402729' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6402729.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6402733' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6402733.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6402734' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6402734.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6402739' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6402739.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6801790' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6801790.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6801791' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6801791.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='6801878' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-6801878.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='7801552' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-7801552.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='7801588' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-7801588.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='7801591' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-7801591.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='7801653' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-7801653.csv; -measure_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('29/02/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/02/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-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 <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-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='7801698' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_150849_15148892/drifting-buoys-7801698.csv; -measure_qc=12578