SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601635' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-1601635.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701530' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-1701530.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-1701582.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201637' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201637.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201738' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201738.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201829' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201829.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201881' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201881.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201882' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201882.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201883' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201883.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201884' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201884.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201885' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201885.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201886' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201886.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201887' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201887.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201888' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201888.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201889' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201889.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201890' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201890.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201891' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201891.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201892' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201892.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201893' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201893.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201894' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201894.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201895' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201895.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201896' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201896.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201897' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201897.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201898' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201898.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3201899' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3201899.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3202500' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3202500.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3202501' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3202501.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3202502' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3202502.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3202503' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3202503.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3202504' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3202504.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3401572' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3401572.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3401628' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3401628.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3401634' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-3401634.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401536' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401536.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401583' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401583.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401586' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401586.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401667' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401667.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401673' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401673.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401676' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401676.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401683' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401683.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401695' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401695.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401696' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401696.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401697' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401697.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401748' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401748.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401751' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401751.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401754' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401754.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401755' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401755.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401756' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401756.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401759' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401759.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401774' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401774.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401775' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5401775.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501567' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5501567.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501611' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5501611.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501658' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5501658.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501846' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5501846.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601512' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5601512.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601638' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5601638.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601639' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5601639.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601645' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5601645.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601682' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-5601682.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7301552' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/drifting-buoys-7301552.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9VHF2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-9VHF2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='C6YT4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-C6YT4.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='D5LS3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-D5LS3.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DBBE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-DBBE.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DIGX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-DIGX2.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FAJ7028' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-FAJ7028.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FAJ7648' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-FAJ7648.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FAJ8114' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-FAJ8114.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMNB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-FMNB.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='VRRX9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-VRRX9.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='WDM5414' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/tsg-WDM5414.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/09/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -12.519 AND cl.lat_max >= -52.908 AND ((cl.long_min <= -64.207 AND cl.long_max >= -94.695) OR (cl.long_min <= MOD(-64.207+360, 360) AND cl.long_max >= MOD(-94.695+360, 360)) OR (cl.long_min <= MOD(-64.207-360, 360) AND cl.long_max >= MOD(-94.695-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -12.519 AND l.latitude >= -52.908 AND ((l.longitude <= -64.207 AND l.longitude >= -94.695) OR (l.longitude <= MOD(-64.207+360, 360) AND l.longitude >= MOD(-94.695+360, 360)) OR (l.longitude <= MOD(-64.207-360, 360) AND l.longitude >= MOD(-94.695-360, 360)) ) AND (temp = 'Y' OR psal = 'Y' OR doxy = 'Y' OR not 1=1)) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='32ST0' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_034633_15076566/mooring-buoys-time-series-32ST0.nc; -valid_qc=12578