SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301571' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1301571.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301773' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1301773.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301778' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1301778.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301794' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1301794.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301802' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1301802.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301803' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1301803.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1301813' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1301813.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1501725' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1501725.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1801803' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-1801803.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='180184' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-180184.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2802075' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-2802075.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2802077' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-2802077.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3801592' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-3801592.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101656' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4101656.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101743' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4101743.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101845' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4101845.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101851' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4101851.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101858' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4101858.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402613' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4402613.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402656' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4402656.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402726' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4402726.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402735' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4402735.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402736' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4402736.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402743' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4402743.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402885' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4402885.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4403569' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4403569.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4701555' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4701555.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4802592' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-4802592.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5801983' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-5801983.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5802094' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-5802094.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5802096' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-5802096.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202597' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6202597.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6202598.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202637' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6202637.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203660' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6203660.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203797' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6203797.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203807' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6203807.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203823' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6203823.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203825' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6203825.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203826' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6203826.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203844' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6203844.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6204612' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6204612.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6204614' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6204614.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401584' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6401584.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6401598.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402621' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6402621.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402729' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6402729.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6402733' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-6402733.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7801552' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-7801552.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7801588' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-7801588.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7801696' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-7801696.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_151045_15148895/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('31/05/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/05/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 70 AND cl.lat_max >= 30 AND ((cl.long_min <= 5 AND cl.long_max >= -60) OR (cl.long_min <= MOD(5+360, 360) AND cl.long_max >= MOD(-60+360, 360)) OR (cl.long_min <= MOD(5-360, 360) AND cl.long_max >= MOD(-60-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 70 AND l.latitude >= 30 AND ((l.longitude <= 5 AND l.longitude >= -60) OR (l.longitude <= MOD(5+360, 360) AND l.longitude >= MOD(-60+360, 360)) OR (l.longitude <= MOD(5-360, 360) AND l.longitude >= MOD(-60-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7801785' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_151045_15148895/drifting-buoys-7801785.csv; -measure_qc=12578