SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2101595' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-2101595.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2101600' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-2101600.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2101660' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-2101660.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2101822' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-2101822.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201673' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-3201673.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201758' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-3201758.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201844' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-3201844.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201845' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-3201845.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201847' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-3201847.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301535' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-3301535.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601647' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601647.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601693' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601693.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601697' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601697.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601711' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601711.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601743' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601743.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601744' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601744.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601746' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601746.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601753' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601753.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601762' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601762.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601763' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601763.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601765' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601765.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601766' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601766.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601767' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601767.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601771' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601771.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601772' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601772.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601773' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601773.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601776' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601776.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601777' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601777.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601778' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601778.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601781' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601781.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601802' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601802.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601805' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601805.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601807' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601807.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601809' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601809.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601835' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601835.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601839' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601839.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601840' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601840.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601844' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4601844.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602517' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602517.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602527' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602527.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602528' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602528.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602529' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602529.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602530' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602530.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602531' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602531.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602532' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602532.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602534' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602534.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602551' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602551.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602553' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602553.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602555' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602555.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602557' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602557.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602612' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602612.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602613' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602613.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602614' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602614.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602615' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602615.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602616' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602616.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602617' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602617.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602618' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602618.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602619' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602619.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602620' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602620.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602707' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602707.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602714' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602714.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602715' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602715.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602717' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602717.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602718' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602718.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602738' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602738.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602741' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602741.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602743' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602743.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602746' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-4602746.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102534' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5102534.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102612' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5102612.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102615' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5102615.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102629' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5102629.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102777' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5102777.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103533' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103533.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103538' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103538.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103554' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103554.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103555' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103555.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103556' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103556.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103557' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103557.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103558' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103558.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103559' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103559.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103560' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103560.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103561' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103561.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103562' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103562.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103563' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103563.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103565' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103565.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5103568' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5103568.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201669' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5201669.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201677' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5201677.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5201679.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201694' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5201694.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5201726' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5201726.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5301550' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/drifting-buoys-5301550.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46011' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-46011.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46028' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-46028.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46042' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-46042.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46114' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-46114.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46239' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-46239.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46240' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-46240.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46259' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-46259.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46269' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-46269.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='51000' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-51000.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='51208' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-51208.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EAZC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-EAZC1.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EHSC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-EHSC1.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='ELQC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-ELQC1.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('07/12/2022 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/12/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 37 AND cl.lat_max >= 22 AND ((cl.long_min <= -121 AND cl.long_max >= -160) OR (cl.long_min <= MOD(-121+360, 360) AND cl.long_max >= MOD(-160+360, 360)) OR (cl.long_min <= MOD(-121-360, 360) AND cl.long_max >= MOD(-160-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 37 AND l.latitude >= 22 AND ((l.longitude <= -121 AND l.longitude >= -160) OR (l.longitude <= MOD(-121+360, 360) AND l.longitude >= MOD(-160+360, 360)) OR (l.longitude <= MOD(-121-360, 360) AND l.longitude >= MOD(-160-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='MLSC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250205_064219_15146438/mooring-buoys-time-series-MLSC1.csv; -measure_qc=12578