SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='1801699' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-1801699.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='4600280' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-4600280.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='4600281' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-4600281.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='4600282' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-4600282.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='4602634' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-4602634.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='6801804' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-6801804.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='6801949' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-6801949.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='7801670' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-7801670.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='7801768' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/drifting-buoys-7801768.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='2HDG2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-2HDG2.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='2HDG4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-2HDG4.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='3E3566' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-3E3566.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='4VKYNVK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-4VKYNVK.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='5LCZ4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-5LCZ4.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='5LFF5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-5LFF5.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='6QZJ45L' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-6QZJ45L.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='6WUKLPV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-6WUKLPV.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='7JDE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-7JDE.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='7JUL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-7JUL.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='7JUP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-7JUP.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='7JWH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-7JWH.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='8FRVR2C' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-8FRVR2C.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='8JC9EXU' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-8JC9EXU.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='8PRGBJL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-8PRGBJL.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9HA5073' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9HA5073.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9HA5844' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9HA5844.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9HA5997' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9HA5997.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9V2692' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9V2692.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9V7625' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9V7625.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9V7977' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9V7977.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9V9003' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9V9003.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9V9288' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9V9288.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9V9758' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9V9758.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9VBN2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9VBN2.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='9VFV5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-9VFV5.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='A8OR6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-A8OR6.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='A8XY5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-A8XY5.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='ARCGM3F' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-ARCGM3F.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='BKKH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-BKKH.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='BLHI' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-BLHI.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='BLHQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-BLHQ.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='C6AP3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-C6AP3.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='C6DL4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-C6DL4.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='C6EF4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-C6EF4.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='C6EI3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-C6EI3.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='C6EI4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-C6EI4.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='D5NC3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-D5NC3.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='D5XC4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-D5XC4.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='D5ZH9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-D5ZH9.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='KCOJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-KCOJ.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='KPSJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-KPSJ.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='LLW9X6U' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-LLW9X6U.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='MEDZ7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-MEDZ7.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='MJG835K' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-MJG835K.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='MPP7LPS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-MPP7LPS.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='ONIY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-ONIY.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='OULU2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-OULU2.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='OXSQ2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-OXSQ2.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='OYGS2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-OYGS2.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='RCLKYXB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-RCLKYXB.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='USS8SCM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-USS8SCM.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='V7PR9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-V7PR9.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='V7QK9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-V7QK9.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRID5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRID5.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRLZ3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRLZ3.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRME7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRME7.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRNY5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRNY5.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VROB9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VROB9.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VROO4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VROO4.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRQS2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRQS2.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRUX9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRUX9.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRVC3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRVC3.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRVI2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRVI2.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRVO3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRVO3.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRVO9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRVO9.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='VRVP3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-VRVP3.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='WSFABLK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-WSFABLK.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='WTEG' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-WTEG.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='XSPQWLM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-XSPQWLM.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='XYKWGQR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-XYKWGQR.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='YBBHE7D' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-YBBHE7D.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='ZGOK7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/tsg-ZGOK7.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46022' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46022.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46099' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46099.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46100' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46100.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46116' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46116.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46117' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46117.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46278' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46278.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46279' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46279.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46280' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46280.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46281' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46281.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='46282' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-46282.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='FFFC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-FFFC1.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='MLSC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-MLSC1.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='PBJW1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-PBJW1.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='SCQC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-SCQC1.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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='SLOO3' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_001512_15075986/mooring-buoys-time-series-SLOO3.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('27/09/2024 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 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_001512_15075986/mooring-buoys-time-series-TDPC1.nc; -valid_qc=12578