SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='1902717' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-1902717.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='2903797' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-2903797.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='2903898' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-2903898.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='3901830' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-3901830.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='5906993' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-5906993.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='5907088' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-5907088.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6903263' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6903263.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6903296' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6903296.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6903803' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6903803.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6903822' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6903822.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6903826' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6903826.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6904138' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6904138.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6904206' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6904206.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6990629' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6990629.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6990658' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-6990658.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='7901138' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/argo-trajectory-7901138.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='1601749' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/drifting-buoys-1601749.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='2801966' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/drifting-buoys-2801966.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='3301699' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/drifting-buoys-3301699.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='5802115' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/drifting-buoys-5802115.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='5802152' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/drifting-buoys-5802152.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='6801928' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/drifting-buoys-6801928.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='7801675' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/drifting-buoys-7801675.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='2HDF9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-2HDF9.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='3E2012' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-3E2012.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='3FIL' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-3FIL.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='3FWH8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-3FWH8.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='3PVPYGJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-3PVPYGJ.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='3WH466J' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-3WH466J.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='4FYMDBT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-4FYMDBT.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='5LJY5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-5LJY5.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='5LKN3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-5LKN3.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='7JYBKRJ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-7JYBKRJ.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='7NC9H6B' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-7NC9H6B.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='7WFBSAS' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-7WFBSAS.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9HA3777' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9HA3777.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9HA4974' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9HA4974.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9SYU6TM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9SYU6TM.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V2728' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V2728.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V5243' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V5243.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V5244' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V5244.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V5246' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V5246.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V6459' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V6459.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V6463' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V6463.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V7629' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V7629.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V8839' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V8839.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V9399' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V9399.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V9400' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V9400.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V9404' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V9404.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='9V9407' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-9V9407.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='A8NM6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-A8NM6.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='A8SI6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-A8SI6.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='A8VP8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-A8VP8.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='AHSBERV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-AHSBERV.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='AHXS2YR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-AHXS2YR.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='AZGM4MC' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-AZGM4MC.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='BJKUBKR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-BJKUBKR.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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_20250118_122747_15143770/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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='D5AD7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-D5AD7.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='DDGR99J' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-DDGR99J.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='ERFU9CD' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-ERFU9CD.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='ETWE69U' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-ETWE69U.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='FPX2GTE' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-FPX2GTE.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='FYMDBT' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-FYMDBT.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='GZU6L8G' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-GZU6L8G.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='H8XH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-H8XH.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='HJXQBFB' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-HJXQBFB.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='KBYV56K' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-KBYV56K.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='KEP23GP' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-KEP23GP.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='KHVEVKQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-KHVEVKQ.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='LAQN7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-LAQN7.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='LWHWD2N' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-LWHWD2N.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='NAXMCDF' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-NAXMCDF.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='OZJH2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-OZJH2.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='RLJY5YZ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-RLJY5YZ.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='SVBY3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-SVBY3.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='ULNEV2G' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-ULNEV2G.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='USCDJSG' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-USCDJSG.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='V7A2148' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-V7A2148.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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_20250118_122747_15143770/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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='V7A6509' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-V7A6509.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='V7HH2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-V7HH2.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='V7KD8' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-V7KD8.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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_20250118_122747_15143770/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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRIR7' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRIR7.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRJT5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRJT5.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRLQ4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRLQ4.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRME6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRME6.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VROL6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VROL6.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VROX2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VROX2.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRPE6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRPE6.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRQL9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRQL9.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRQX5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRQX5.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRRI5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRRI5.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRTU3' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRTU3.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRTU5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRTU5.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRTV2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRTV2.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRUY5' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRUY5.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRVC6' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRVC6.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRVC9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRVC9.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRVK9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRVK9.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='VRVR2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-VRVR2.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='WMKA' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-WMKA.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='WMKN' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-WMKN.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='WQJ6LZH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-WQJ6LZH.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='WTV282A' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-WTV282A.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='YLKET8R' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-YLKET8R.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='YPGWNMH' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-YPGWNMH.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='YRCXNBW' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-YRCXNBW.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='ZSSS5XX' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/tsg-ZSSS5XX.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='EXMY2092' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/mooring-buoys-time-series-EXMY2092.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='EXMY2122' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/mooring-buoys-time-series-EXMY2122.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='EXMY2886' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/mooring-buoys-time-series-EXMY2886.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('18/01/2025 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('18/12/2024 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 40 AND cl.lat_max >= -36 AND ((cl.long_min <= 21 AND cl.long_max >= 15) OR (cl.long_min <= MOD(21+360, 360) AND cl.long_max >= MOD(15+360, 360)) OR (cl.long_min <= MOD(21-360, 360) AND cl.long_max >= MOD(15-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 40 AND l.latitude >= -36 AND ((l.longitude <= 21 AND l.longitude >= 15) OR (l.longitude <= MOD(21+360, 360) AND l.longitude >= MOD(15+360, 360)) OR (l.longitude <= MOD(21-360, 360) AND l.longitude >= MOD(15-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='EXMY2935' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250118_122747_15143770/mooring-buoys-time-series-EXMY2935.csv; -measure_qc=12578