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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301725' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301725.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301736' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301736.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301782' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301782.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301784' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301784.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301785' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301785.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301786' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301786.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301787' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301787.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301788' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301788.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301801' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301801.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301810' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301810.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301811' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301811.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301812' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301812.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301814' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301814.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1301816' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1301816.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1501724' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1501724.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1501780' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1501780.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1801670' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1801670.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1801673' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1801673.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1801675' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1801675.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1801676' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1801676.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1801777' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1801777.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1801778' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1801778.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='1801853' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-1801853.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='2801968' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-2801968.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='2802008' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-2802008.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='2802080' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-2802080.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='2802100' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-2802100.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='2802157' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-2802157.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='2802158' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-2802158.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='2802159' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-2802159.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='2802160' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-2802160.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='3801571' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-3801571.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='3801575' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-3801575.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='3801702' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-3801702.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4100538' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4100538.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4101523' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4101523.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4101728' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4101728.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4201523' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4201523.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4401584' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4401584.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4401590' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4401590.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4701561' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4701561.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4801771' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4801771.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4802582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4802582.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4802633' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4802633.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4802637' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4802637.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4803997' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4803997.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4804003' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4804003.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='4804120' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-4804120.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='5801978' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-5801978.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='5802019' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-5802019.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='5802026' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-5802026.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='5802050' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-5802050.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='5802095' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-5802095.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203615' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203615.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203642' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203642.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203656' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203656.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203830' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203830.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203831' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203831.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203832' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203832.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203837' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203837.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203849' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203849.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6203861' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6203861.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6204613' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6204613.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6301582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6301582.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6402617' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6402617.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6402634' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6402634.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6402635' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6402635.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6402636' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6402636.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6402637' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6402637.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6402638' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6402638.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6801771' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6801771.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='6801907' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-6801907.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7801571' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7801571.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7801697' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7801697.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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_151417_15148941/drifting-buoys-7801698.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7801699' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7801699.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810292' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810292.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810293' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810293.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810295' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810295.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810297' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810297.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810298' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810298.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810310' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810310.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810313' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810313.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810314' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810314.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810315' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810315.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810316' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810316.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810317' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810317.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810318' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810318.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810319' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810319.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810320' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810320.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810321' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810321.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810328' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810328.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810379' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810379.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7810380' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7810380.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7811001' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7811001.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('30/11/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/11/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='7811002' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151417_15148941/drifting-buoys-7811002.csv; -measure_qc=12578