SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='1801727' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-1801727.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='1801754' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-1801754.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1801755' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-1801755.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='1801756' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-1801756.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='2101687' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2101687.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2101689' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2101689.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='2802018' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2802018.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='2802028' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2802028.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2802040' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2802040.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='2802041' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2802041.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='2802043' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2802043.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2802053' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2802053.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2802054' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-2802054.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='3301535' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-3301535.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='3801614' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-3801614.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3801655' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-3801655.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='3801656' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-3801656.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3801664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-3801664.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4601776' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4601776.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4601802' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4601802.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4601805' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4601805.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4601856' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4601856.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4602528' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602528.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4602540' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602540.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602543' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602543.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4602577' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602577.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4602587' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602587.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4602609' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602609.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4602612' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602612.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4602622' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602622.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4602627' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602627.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4602629' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4602629.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4701527' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4701527.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4804047' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4804047.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4804048' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4804048.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4804056' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4804056.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4804089' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-4804089.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='5103554' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-5103554.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='5802013' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-5802013.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='5802023' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-5802023.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='5802024' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-5802024.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='5802031' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-5802031.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='5802032' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-5802032.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='5802046' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-5802046.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='5802047' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-5802047.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='6801820' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-6801820.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='6801848' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-6801848.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='6801849' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-6801849.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6801850' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-6801850.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6801858' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-6801858.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7801666' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-7801666.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7801678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-7801678.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7801679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-7801679.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7801680' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/drifting-buoys-7801680.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='C6YT4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/tsg-C6YT4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='DIGX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/tsg-DIGX2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='WTED' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/tsg-WTED.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='WTEE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/tsg-WTEE.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4600303' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-4600303.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='4600304' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-4600304.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46005' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46005.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46013' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46013.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46025' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46025.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46028' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46028.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46041' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46041.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46042' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46042.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46047' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46047.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46059' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46059.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46086' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46086.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46089' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46089.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46146' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46146.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46221' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46221.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46222' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46222.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46224' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46224.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46225' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46225.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46232' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46232.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46235' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46235.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46253' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46253.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46254' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46254.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46256' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46256.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46258' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46258.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46266' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46266.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46268' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46268.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='46269' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46269.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46274' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46274.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46275' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46275.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='46277' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-46277.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='BDXC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-BDXC1.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='CQUC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-CQUC1.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='CWQO3' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-CWQO3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='FPXC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-FPXC1.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/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('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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_213243_15078716/mooring-buoys-time-series-TDPC1.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('15/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('14/05/2023 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 49.352 AND cl.lat_max >= 28.767 AND ((cl.long_min <= -116.108 AND cl.long_max >= -131.323) OR (cl.long_min <= MOD(-116.108+360, 360) AND cl.long_max >= MOD(-131.323+360, 360)) OR (cl.long_min <= MOD(-116.108-360, 360) AND cl.long_max >= MOD(-131.323-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 49.352 AND l.latitude >= 28.767 AND ((l.longitude <= -116.108 AND l.longitude >= -131.323) OR (l.longitude <= MOD(-116.108+360, 360) AND l.longitude >= MOD(-131.323+360, 360)) OR (l.longitude <= MOD(-116.108-360, 360) AND l.longitude >= MOD(-131.323-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='TIQC1' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_213243_15078716/mooring-buoys-time-series-TIQC1.nc; -valid_qc=12578