SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1600565' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-1600565.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601500' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-1601500.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601514' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-1601514.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601521' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-1601521.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601534' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-1601534.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3300906' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-3300906.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5100823' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5100823.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5100825' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5100825.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5102511' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5102511.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200509' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5200509.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5400552' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5400552.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401539' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5401539.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401623' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5401623.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401624' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5401624.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5500944' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5500944.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5500945' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5500945.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5500960' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5500960.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5500966' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5500966.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501507' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501507.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501523' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501523.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501527' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501527.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501528' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501528.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501530' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501530.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501533' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501533.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501534' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501534.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501536' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501536.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501564' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501564.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501566' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501566.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501570' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5501570.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601600' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-5601600.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7201508' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-7201508.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB02294' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB02294.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03227' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03227.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03263' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03263.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03271' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03271.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03283' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03283.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03290' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03290.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03334' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03334.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03337' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03337.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03339' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03339.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03343' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03343.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03350' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03350.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03354' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03354.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03356' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB03356.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB04608' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB04608.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB04619' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB04619.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05022' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05022.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05024' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05024.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05031' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05031.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05032' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05032.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05156' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05156.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05158' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05158.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05184' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05184.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05185' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05185.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05258' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05258.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05468' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05468.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05541' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB05541.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB06172' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB06172.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB06788' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB06788.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB06875' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB06875.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB06876' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB06876.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB06877' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB06877.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB06908' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB06908.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB06911' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB06911.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07339' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB07339.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07342' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB07342.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07343' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXB07343.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15794' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD15794.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15812' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD15812.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15841' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD15841.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15846' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD15846.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16091' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD16091.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16381' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD16381.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16423' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD16423.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16584' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD16584.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16640' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD16640.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16846' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD16846.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16931' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/drifting-buoys-EXD16931.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='A8MA9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/tsg-A8MA9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FJYC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/tsg-FJYC.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VLMJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/tsg-VLMJ.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VNAA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/tsg-VNAA.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VNCF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/tsg-VNCF.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VROJ8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/tsg-VROJ8.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52121' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-52121.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55027' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55027.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55028' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55028.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55029' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55029.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55030' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55030.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55031' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55031.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55032' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55032.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55033' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55033.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55035' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55035.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55036' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55036.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55037' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55037.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55038' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55038.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55045' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55045.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55046' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55046.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/06/2018 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/01/2018 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -10.269 AND cl.lat_max >= -44.906 AND ((cl.long_min <= 158.469 AND cl.long_max >= 140.491) OR (cl.long_min <= MOD(158.469+360, 360) AND cl.long_max >= MOD(140.491+360, 360)) OR (cl.long_min <= MOD(158.469-360, 360) AND cl.long_max >= MOD(140.491-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -10.269 AND l.latitude >= -44.906 AND ((l.longitude <= 158.469 AND l.longitude >= 140.491) OR (l.longitude <= MOD(158.469+360, 360) AND l.longitude >= MOD(140.491+360, 360)) OR (l.longitude <= MOD(158.469-360, 360) AND l.longitude >= MOD(140.491-360, 360)) ) AND (temp = 'Y' OR doxy = 'Y' OR chlo = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='55051' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_184025_15078262/mooring-buoys-time-series-55051.nc; -valid_qc=12578