SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='1801755' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-1801755.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='2101689' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-2101689.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='2802040' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-2802040.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='2802053' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-2802053.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='2802054' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-2802054.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='3801655' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-3801655.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='3801664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-3801664.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='4601856' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-4601856.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='4602543' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-4602543.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='4602627' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-4602627.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='4804089' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-4804089.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='6801850' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-6801850.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='6801858' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-6801858.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='7801666' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-7801666.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='7801678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-7801678.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='7801679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-7801679.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='7801680' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/drifting-buoys-7801680.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46013' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46013.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46014' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46014.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46026' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46026.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46027' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46027.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46029' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46029.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46041' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46041.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46050' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46050.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46053' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46053.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46054' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46054.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46069' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46069.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46087' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46087.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46088' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46088.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46089' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46089.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46097' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46097.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46098' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46098.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46211' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46211.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46213' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46213.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46214' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46214.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46215' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46215.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46218' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46218.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46219' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46219.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46229' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46229.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46237' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46237.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46243' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46243.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46244' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46244.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46248' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46248.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46251' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46251.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46267' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46267.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='46276' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-46276.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='BDXC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-BDXC1.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='BVQW1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-BVQW1.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='CHQO3' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-CHQO3.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='CPXC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-CPXC1.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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_20240927_001619_15075987/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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='EVMC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-EVMC1.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='HBXC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-HBXC1.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='MBXC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-MBXC1.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='PBLW1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-PBLW1.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='RYEC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-RYEC1.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='SEFO3' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-SEFO3.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='SETO3' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-SETO3.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('21/05/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('21/05/2023 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 <= 48.979 AND cl.lat_max >= 32.422 AND ((cl.long_min <= -119.483 AND cl.long_max >= -128.582) OR (cl.long_min <= MOD(-119.483+360, 360) AND cl.long_max >= MOD(-128.582+360, 360)) OR (cl.long_min <= MOD(-119.483-360, 360) AND cl.long_max >= MOD(-128.582-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 48.979 AND l.latitude >= 32.422 AND ((l.longitude <= -119.483 AND l.longitude >= -128.582) OR (l.longitude <= MOD(-119.483+360, 360) AND l.longitude >= MOD(-128.582+360, 360)) OR (l.longitude <= MOD(-119.483-360, 360) AND l.longitude >= MOD(-128.582-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = '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='TDPC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001619_15075987/mooring-buoys-time-series-TDPC1.nc; -valid_qc=12578