SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301579' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301579.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301718' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301718.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301719' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301719.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301720' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301720.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301721' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301721.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301723' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301723.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301725' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301725.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301726' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301726.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301731' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301731.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301765' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301765.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301768' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301768.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301778' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301778.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301781' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301781.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1301799' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1301799.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='1501742' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-1501742.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101541' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101541.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101548' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101548.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101557' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101557.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101702' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101702.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101717' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101717.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101719' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101719.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101720' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101720.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101721' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101721.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4101727' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4101727.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4400777' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4400777.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4401582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4401582.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='4402660' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-4402660.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='5501573' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-5501573.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203597' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203597.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203607' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203607.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203621' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203621.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203625' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203625.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203632' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203632.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203634' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203634.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203639' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203639.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203640' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203640.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203755' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203755.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203768' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203768.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203776' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203776.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203841' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203841.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203843' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203843.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203846' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203846.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203849' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203849.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203859' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203859.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6203861' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6203861.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6204561' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6204561.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6204562' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6204562.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6204564' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6204564.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6204573' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6204573.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6204597' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6204597.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6401597' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6401597.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6402618' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6402618.nc;
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/07/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/06/2022 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 31 AND cl.lat_max >= 20 AND ((cl.long_min <= -10 AND cl.long_max >= -30) OR (cl.long_min <= MOD(-10+360, 360) AND cl.long_max >= MOD(-30+360, 360)) OR (cl.long_min <= MOD(-10-360, 360) AND cl.long_max >= MOD(-30-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 31 AND l.latitude >= 20 AND ((l.longitude <= -10 AND l.longitude >= -30) OR (l.longitude <= MOD(-10+360, 360) AND l.longitude >= MOD(-30+360, 360)) OR (l.longitude <= MOD(-10-360, 360) AND l.longitude >= MOD(-30-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='6501699' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250414_161430_15190173/drifting-buoys-6501699.nc;