SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from 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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901450' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901450.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901487' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901487.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901489' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901489.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901499' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901499.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901504' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901504.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901529' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901529.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901531' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901531.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901668' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901668.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901672' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901672.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901675' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901675.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901681' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901681.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901683' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901683.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901687' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901687.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901689' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901689.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901713' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901713.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901717' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901717.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901731' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901731.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1901806' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-1901806.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3901043' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-3901043.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901059' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901059.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901060' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901060.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901212' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901212.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901280' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901280.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901478' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901478.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901481' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901481.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901483' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901483.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901484' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901484.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901581' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901581.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901582' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901582.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901623' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901623.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901624' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901624.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4901713' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4901713.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4902061' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-4902061.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903132' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-5903132.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903133' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-5903133.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5903282' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-5903282.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900533' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6900533.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900534' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6900534.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900535' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6900535.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900723' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6900723.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6900915' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6900915.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901018' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901018.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901446' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901446.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901449' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901449.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901509' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901509.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901553' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901553.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901590' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901590.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901598' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901598.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901612' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901612.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901622' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901622.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901624' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901624.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901626' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901626.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901702' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901702.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901706' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901706.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6901737' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6901737.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902573' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902573.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902574' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902574.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902575' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902575.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902576' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902576.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902606' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902606.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902608' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902608.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902609' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902609.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902610' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902610.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902612' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902612.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902613' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902613.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902652' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902652.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902658' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902658.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902675' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902675.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='6902676' and cl.classification_code=11;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/argo-trajectory-6902676.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1300517' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1300517.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1300523' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1300523.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1300525' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1300525.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1300531' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1300531.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1300589' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1300589.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1300600' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1300600.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13531' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-13531.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13566' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-13566.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500549' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500549.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500605' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500605.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500684' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500684.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500686' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500686.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500689' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500689.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500690' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500690.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500691' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500691.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500694' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500694.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1500954' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1500954.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='1501501' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-1501501.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100515' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-3100515.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100517' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-3100517.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100545' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-3100545.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100701' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-3100701.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100702' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-3100702.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100706' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-3100706.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100983' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-3100983.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31507' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-31507.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31701' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-31701.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31983' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-31983.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4100552' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4100552.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4100638' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4100638.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4100707' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4100707.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4100708' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4100708.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101704' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4101704.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4101740' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4101740.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401525' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4401525.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401527' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4401527.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='4401533' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-4401533.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00773' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB00773.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01339' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB01339.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01348' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB01348.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01523' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB01523.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB02152' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB02152.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB02255' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB02255.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB04455' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB04455.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05089' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB05089.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05127' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB05127.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05132' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB05132.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05137' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB05137.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05138' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB05138.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB05140' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXB05140.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15438' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD15438.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15441' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD15441.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15458' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD15458.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15605' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD15605.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15730' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD15730.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15849' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD15849.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16210' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD16210.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16460' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD16460.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16511' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD16511.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD16935' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/drifting-buoys-EXD16935.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='9HXD9' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-9HXD9.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='C6YT4' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-C6YT4.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXEI0017' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-EXEI0017.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXEI0029' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-EXEI0029.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMCY' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-FMCY.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNAV' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-FNAV.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNCM' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-FNCM.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNHO' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-FNHO.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNUR' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-FNUR.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='LXSQ' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-LXSQ.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='WDE9586' and cl.classification_code=13;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/tsg-WDE9586.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMCY' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/bottles-FMCY.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNAV' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/bottles-FNAV.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNCM' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/bottles-FNCM.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FNHO' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/bottles-FNHO.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='LXSQ' and cl.classification_code=14;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/bottles-LXSQ.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='13009' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-13009.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31001' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-31001.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='31002' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-31002.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100218' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-3100218.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='3100219' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-3100219.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='41026' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-41026.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='42087' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-42087.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='42088' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-42088.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMF0044' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-EXMF0044.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMF0045' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-EXMF0045.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMF0046' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-EXMF0046.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXMF0047' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-EXMF0047.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXSH0049' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-EXSH0049.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXSH0080' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-EXSH0080.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='IF000372' and cl.classification_code=15;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/mooring-buoys-time-series-IF000372.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='FMCY' and cl.classification_code=19;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/other-time-series-or-trajectories-FMCY.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/2016 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2015 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (1, 2, 3, 4, 6, 9, 11, 12, 13, 14, 15, 19) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 14 AND cl.lat_max >= -7 AND ((cl.long_min <= -33 AND cl.long_max >= -61) OR (cl.long_min <= MOD(-33+360, 360) AND cl.long_max >= MOD(-61+360, 360)) OR (cl.long_min <= MOD(-33-360, 360) AND cl.long_max >= MOD(-61-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 14 AND l.latitude >= -7 AND ((l.longitude <= -33 AND l.longitude >= -61) OR (l.longitude <= MOD(-33+360, 360) AND l.longitude >= MOD(-61+360, 360)) OR (l.longitude <= MOD(-33-360, 360) AND l.longitude >= MOD(-61-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='PWAN' and cl.classification_code=19;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20250206_161648_15151171/other-time-series-or-trajectories-PWAN.nc; -valid_qc=12578