SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901864' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-3901864.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901779' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4901779.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901809' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4901809.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901817' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4901817.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902117' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4902117.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902118' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4902118.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902119' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4902119.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902397' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4902397.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902450' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4902450.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902451' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-4902451.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903387' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-5903387.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903390' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-5903390.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903394' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-5903394.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904173' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-5904173.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5904176' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-5904176.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900429' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6900429.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901564' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6901564.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901719' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6901719.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901720' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6901720.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901723' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6901723.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902660' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902660.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902684' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902684.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902694' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902694.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902695' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902695.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902728' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902728.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902749' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902749.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902751' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902751.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902752' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902752.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902754' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902754.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902755' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902755.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902756' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902756.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902786' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902786.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902787' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902787.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902788' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902788.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902789' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902789.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902791' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902791.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902792' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902792.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902793' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902793.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902800' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/argo-trajectory-6902800.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101605' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4101605.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101624' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4101624.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101625' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4101625.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101626' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4101626.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101627' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4101627.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101663' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4101663.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4101664.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401565' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4401565.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401574' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4401574.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401786' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4401786.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401895' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4401895.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401897' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4401897.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401899' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4401899.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401901' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4401901.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402535' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4402535.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402537' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4402537.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402539' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4402539.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402540' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4402540.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402543' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4402543.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4402545' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4402545.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4700552' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4700552.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4800770' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-4800770.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5301764' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-5301764.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202658' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6202658.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202660' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6202660.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202661' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6202661.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202662' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6202662.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202664' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6202664.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202673' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6202673.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6202678.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6202679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6202679.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203553' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203553.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203558' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203558.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203564' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203564.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203566' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203566.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203569' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203569.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203571' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203571.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203572' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203572.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203574' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203574.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203576' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203576.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203578' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203578.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203579' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203579.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203582.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203583' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203583.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203584' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203584.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203588' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203588.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203603' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203603.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6203710' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6203710.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6301562' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6301562.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6301563' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6301563.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6301564' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6301564.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401505' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401505.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401531' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401531.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401546' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401546.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401563' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401563.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401572' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401572.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401701' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401701.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401704' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401704.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401705' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401705.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401706' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401706.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6401783' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-6401783.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05539' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-EXB05539.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07142' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-EXB07142.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07188' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-EXB07188.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07190' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-EXB07190.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07197' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-EXB07197.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB07500' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/drifting-buoys-EXB07500.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2019 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('1/01/2019 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 5, 6, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 68 AND cl.lat_max >= 58 AND ((cl.long_min <= -28 AND cl.long_max >= -45) OR (cl.long_min <= MOD(-28+360, 360) AND cl.long_max >= MOD(-45+360, 360)) OR (cl.long_min <= MOD(-28-360, 360) AND cl.long_max >= MOD(-45-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 68 AND l.latitude >= 58 AND ((l.longitude <= -28 AND l.longitude >= -45) OR (l.longitude <= MOD(-28+360, 360) AND l.longitude >= MOD(-45+360, 360)) OR (l.longitude <= MOD(-28-360, 360) AND l.longitude >= MOD(-45-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='OXYH2' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20241022_134540_15092860/tsg-OXYH2.nc; -valid_qc=12578