SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21538' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21538.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21597' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21597.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21598.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21599' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21599.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21600' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21600.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21637' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21637.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21679.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21704' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21704.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21927' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21927.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='21973' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-21973.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22530' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22530.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22537' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22537.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22573' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22573.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22577' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22577.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22579' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22579.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22581' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22581.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22582' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22582.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22583' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22583.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22584' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22584.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22596' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22596.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22600' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22600.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22623' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22623.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22683' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22683.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22684' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22684.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='22692' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-22692.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5100535' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5100535.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='51535' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-51535.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200598.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200617' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200617.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200667' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200667.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200668' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200668.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200669' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200669.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200673' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200673.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200805' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200805.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200843' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200843.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5200917' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5200917.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52514' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52514.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52595' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52595.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52598' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52598.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52609' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52609.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52613' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52613.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52615' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52615.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52616' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52616.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52665' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52665.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52667' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52667.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52668' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52668.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52678' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52678.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52679.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52815' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52815.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52837' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52837.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52843' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52843.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='52917' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-52917.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5300567' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5300567.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5300600' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5300600.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5300905' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5300905.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='5300906' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-5300906.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53524' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53524.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53525' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53525.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53565' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53565.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53566' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53566.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53567' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53567.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53568' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53568.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53574' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53574.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53577' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53577.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53579' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53579.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53581' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53581.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53583' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53583.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53595' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53595.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53600' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53600.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53608' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53608.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53609' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53609.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53901' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53901.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53904' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53904.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53905' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53905.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='53906' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-53906.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00649' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00649.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00652' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00652.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00655' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00655.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00668' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00668.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00670' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00670.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00671' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00671.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00676' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00676.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00679' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00679.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00681' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00681.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00682' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00682.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00683' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00683.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00685' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00685.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00687' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00687.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00713' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00713.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00783' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00783.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00817' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00817.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00848' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00848.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00875' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00875.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00876' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00876.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00877' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00877.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00906' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00906.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00940' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00940.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00959' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00959.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB00999' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB00999.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01005' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01005.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01010' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01010.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01151' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01151.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01158' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01158.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01162' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01162.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01163' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01163.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01166' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01166.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01167' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01167.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01168' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01168.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01214' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01214.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01215' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01215.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01229' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01229.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01230' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01230.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01234' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01234.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01237' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01237.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01302' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01302.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB01914' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB01914.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXB03910' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXB03910.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13085' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD13085.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD13090' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD13090.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD14286' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD14286.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD14287' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD14287.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD14553' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD14553.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15070' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15070.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15234' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15234.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15235' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15235.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15270' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15270.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15281' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15281.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15283' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15283.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15313' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15313.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15323' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15323.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15326' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15326.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15328' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15328.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15336' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15336.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15340' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15340.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15361' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15361.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15380' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15380.nc; -valid_qc=12578
SELECT l.location_id FROM LOCATION l, (SELECT l.location_id, cl.classification_location_id from classification_location cl,location l, (select platform_code from platform ) P WHERE cl.platform_code = P.platform_code AND cl.on_day <= TO_DATE('31/12/2013 23:59:59', 'DD/MM/YYYY HH24:MI:SS') AND cl.on_day >= TO_DATE('01/01/2013 00:00:00', 'DD/MM/YYYY HH24:MI:SS') AND cl.classification_code IN (12) AND (cl.restriction = 'P' or cl.restriction is null) AND cl.lat_min <= 35.203 AND cl.lat_max >= 23.611 AND ((cl.long_min <= 132.446 AND cl.long_max >= 119.554) OR (cl.long_min <= MOD(132.446+360, 360) AND cl.long_max >= MOD(119.554+360, 360)) OR (cl.long_min <= MOD(132.446-360, 360) AND cl.long_max >= MOD(119.554-360, 360)) ) AND l.platform_code = cl.platform_code AND l.location_date >= on_day AND l.location_date < cl.on_day + 1 AND l.latitude <= 35.203 AND l.latitude >= 23.611 AND ((l.longitude <= 132.446 AND l.longitude >= 119.554) OR (l.longitude <= MOD(132.446+360, 360) AND l.longitude >= MOD(119.554+360, 360)) OR (l.longitude <= MOD(132.446-360, 360) AND l.longitude >= MOD(119.554-360, 360)) ) ) locationToDiff,CLASSIFICATION_LOCATION cl, CLASSIFICATION_TYPE ct WHERE l.location_id = locationToDiff.location_id AND cl.classification_location_id = locationToDiff.classification_location_id AND ct.classification_code = cl.classification_code AND l.PLATFORM_CODE='EXD15461' and cl.classification_code=12;/home1/datawork/co_exp/coriolis_exp/spool/co05/co0501/tmp/DataSelection_20240518_064919_15024326/drifting-buoys-EXD15461.nc; -valid_qc=12578