SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='1902722' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-1902722.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3901110' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-3901110.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3902125' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-3902125.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3902148' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-3902148.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3902202' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-3902202.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3902215' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-3902215.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3902241' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-3902241.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='4903267' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-4903267.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='5907135' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-5907135.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6901981' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-6901981.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6902994' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-6902994.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6904187' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-6904187.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='7902180' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-7902180.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='7902181' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/argo-trajectory-7902181.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='1501714' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-1501714.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='1501739' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-1501739.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='1701612' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-1701612.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='1701646' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-1701646.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='2802051' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-2802051.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='5300555' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-5300555.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6203814' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-6203814.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6203868' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-6203868.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6203884' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-6203884.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6203899' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-6203899.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6204501' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-6204501.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='7801672' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/drifting-buoys-7801672.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3EJF3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-3EJF3.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3EKH3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-3EKH3.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3EPL4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-3EPL4.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='3FZI8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-3FZI8.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='6AZCQND' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-6AZCQND.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='7TN5LMQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-7TN5LMQ.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='8CH7ABA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-8CH7ABA.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='9HA4777' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-9HA4777.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='9HA5063' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-9HA5063.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='CGF6VCT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-CGF6VCT.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='D5264' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-D5264.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='D5LH3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-D5LH3.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='DBLK' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-DBLK.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='GHM629S' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-GHM629S.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='H8EW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-H8EW.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='JKFA7QZ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-JKFA7QZ.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='LBXN94P' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-LBXN94P.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='LWQPWTY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-LWQPWTY.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='LXSQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-LXSQ.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='NXQN69F' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-NXQN69F.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='OZIB2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-OZIB2.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='QJLVJFW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-QJLVJFW.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='V7A5254' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-V7A5254.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='V7ZZ6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-V7ZZ6.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='VRDD9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-VRDD9.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='VRPY5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-VRPY5.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='VTHYFYA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-VTHYFYA.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='WLZ9WHS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-WLZ9WHS.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='XNDW39M' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/tsg-XNDW39M.csv; -measure_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('10/04/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('10/03/2025 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= -18.38 AND cl.lat_max >= -27.17 AND ((cl.long_min <= -24.57 AND cl.long_max >= -46.54) OR (cl.long_min <= MOD(-24.57+360, 360) AND cl.long_max >= MOD(-46.54+360, 360)) OR (cl.long_min <= MOD(-24.57-360, 360) AND cl.long_max >= MOD(-46.54-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= -18.38 AND l.latitude >= -27.17 AND ((l.longitude <= -24.57 AND l.longitude >= -46.54) OR (l.longitude <= MOD(-24.57+360, 360) AND l.longitude >= MOD(-46.54+360, 360)) OR (l.longitude <= MOD(-24.57-360, 360) AND l.longitude >= MOD(-46.54-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='31005' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250410_195118_15185214/mooring-buoys-time-series-31005.csv; -measure_qc=12578