SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_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/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901734' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-1901734.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='2903774' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-2903774.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901212' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3901212.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901215' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3901215.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901298' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3901298.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901476' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3901476.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901478' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3901478.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901900' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3901900.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901904' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3901904.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901906' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3901906.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3902326' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3902326.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3902327' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3902327.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3902468' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3902468.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3902469' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-3902469.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903639' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-4903639.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4903640' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-4903640.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5902371' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5902371.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5902383' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5902383.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5902384' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5902384.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5902438' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5902438.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5902440' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5902440.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904198' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5904198.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904437' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5904437.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904806' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5904806.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905034' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905034.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905035' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905035.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905098' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905098.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905185' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905185.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905186' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905186.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905216' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905216.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905267' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905267.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905279' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905279.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905318' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905318.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905380' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905380.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905383' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905383.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905443' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905443.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905678' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905678.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905680' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905680.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905781' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905781.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905782' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905782.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905783' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905783.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905982' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905982.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905993' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905993.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905994' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905994.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5905995' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5905995.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906217' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906217.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906225' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906225.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906227' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906227.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906248' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906248.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906312' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906312.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906495' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906495.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906498' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906498.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906499' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906499.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906541' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906541.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906544' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906544.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906560' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906560.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906561' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906561.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906562' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906562.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5906909' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-5906909.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901987' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6901987.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901988' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6901988.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901993' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6901993.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902892' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6902892.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902894' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6902894.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902979' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6902979.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903049' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903049.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903052' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903052.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903211' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903211.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903212' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903212.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903213' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903213.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903223' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903223.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903232' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903232.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903251' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903251.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903253' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903253.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903254' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903254.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903255' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903255.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903767' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903767.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903769' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903769.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6903771' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6903771.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6904091' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6904091.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6904092' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6904092.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6904093' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6904093.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6990502' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-6990502.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900205' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900205.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900210' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900210.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900211' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900211.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900212' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900212.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900213' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900213.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900300' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900300.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900302' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900302.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900304' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900304.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900531' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900531.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900540' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900540.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900626' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900626.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900668' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900668.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900675' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900675.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900676' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900676.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900680' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900680.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900804' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900804.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900971' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900971.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900979' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900979.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900981' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900981.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900982' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900982.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900983' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900983.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900984' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900984.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900987' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900987.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900988' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900988.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900994' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900994.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900996' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900996.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7900997' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7900997.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7901010' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/argo-trajectory-7901010.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1601701' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-1601701.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701531' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-1701531.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/drifting-buoys-1701582.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701617' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-1701617.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1701713' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-1701713.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301580' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-3301580.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301657' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-3301657.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301658' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-3301658.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301702' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-3301702.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301703' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-3301703.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3301704' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-3301704.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3401635' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-3401635.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/drifting-buoys-5401667.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/drifting-buoys-5401751.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401752' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-5401752.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/drifting-buoys-5401754.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5401762' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-5401762.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/drifting-buoys-5401774.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/drifting-buoys-5401775.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501594' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-5501594.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/drifting-buoys-5501658.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5501667' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-5501667.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601601' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-5601601.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5601646' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-5601646.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/drifting-buoys-5601682.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='7101592' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/drifting-buoys-7101592.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/tsg-DBBE.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='DBBT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240927_050253_15076678/tsg-DBBT.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/tsg-FAJ7028.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/tsg-FAJ7648.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/tsg-FAJ8114.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/tsg-FMNB.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('27/09/2023 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('27/08/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 <= -47.979 AND cl.lat_max >= -73.487 AND ((cl.long_min <= -32.667 AND cl.long_max >= -92.483) OR (cl.long_min <= MOD(-32.667+360, 360) AND cl.long_max >= MOD(-92.483+360, 360)) OR (cl.long_min <= MOD(-32.667-360, 360) AND cl.long_max >= MOD(-92.483-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -47.979 AND l.latitude >= -73.487 AND ((l.longitude <= -32.667 AND l.longitude >= -92.483) OR (l.longitude <= MOD(-32.667+360, 360) AND l.longitude >= MOD(-92.483+360, 360)) OR (l.longitude <= MOD(-32.667-360, 360) AND l.longitude >= MOD(-92.483-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_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_050253_15076678/tsg-WDM5414.nc;