SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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_052006_15146076/drifting-buoys-2101595.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-2101600.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-2101660.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-2101822.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-3201673.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-3201758.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-3201844.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-3201845.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-3201847.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-3301535.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601647.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601693.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601697.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601711.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601743.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601744.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601746.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601753.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601762.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601763.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601765.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601766.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601767.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601771.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601772.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601773.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601776.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601777.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601778.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601781.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601802.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601805.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601807.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601809.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601835.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601839.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601840.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4601844.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602517.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602527.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602528.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602529.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602530.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602531.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602532.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602534.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602551.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602553.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602555.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602557.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602612.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602613.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602614.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602615.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602616.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602617.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602618.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602619.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602620.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602707.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602714.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602715.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602717.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602718.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602738.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602741.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602743.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-4602746.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5102534.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5102612.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5102615.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5102629.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5102777.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103533.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103538.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103554.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103555.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103556.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103557.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103558.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103559.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103560.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103561.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103562.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103563.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103565.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5103568.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5201669.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5201677.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5201679.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5201694.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5201726.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/drifting-buoys-5301550.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-46011.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-46028.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-46042.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-46114.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-46239.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-46240.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-46259.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-46269.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-51000.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-51208.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-EAZC1.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-EHSC1.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-ELQC1.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('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_052006_15146076/mooring-buoys-time-series-MLSC1.nc; -valid_qc=12578