Union All

From NGDC Wiki
Jump to: navigation, search
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'GOESWINDS' dataset, 'Longitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start, to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN,  max(LATMAX) LATMAX, min(LONMIN) LONMIN,
max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE, count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
(case when abs(LONMAX - lag(LONMAX, 1) over (order by gdate)) >10 then 1 else null end) segment_start
from ri.nosa_spatial where granule = 'GOESWINDS_TSQP' and LONMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'GOESWINDS' dataset, 'Longitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end, min(LATMIN) LATMIN, 
max(LATMAX) LATMAX, min(LONMIN) LONMIN,  max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE, count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate)  segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMIN - lag(LONMIN, 1) over (order by gdate)) >10 then 1 else null end segment_start
from ri.nosa_spatial where granule = 'GOESWINDS_TSQP' and LONMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'GOESWINDS' dataset, 'Latitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end, min(LATMIN) LATMIN, 
max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE, count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMAX - lag(LATMAX, 1) over (order by  gdate)) >5 then 1 else null end segment_start
from ri.nosa_spatial where granule = 'GOESWINDS_TSQP' and LATMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'GOESWINDS' dataset, 'Latitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end, min(LATMIN) LATMIN, 
max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE, count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMIN - lag(LATMIN, 1) over (order by  gdate)) >10 then 1 else null end segment_start
from ri.nosa_spatial where granule = 'GOESWINDS_TSQP' and LATMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'MESONET' dataset, 'Longitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMAX - lag(LONMAX, 1) over (order by gdate)) >.2 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'MESONET_TSQP' and LONMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'MESONET' dataset, 'Longitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMIN - lag(LONMIN, 1) over (order by gdate)) >2 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'MESONET_TSQP' and LONMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'MESONET' dataset, 'Latitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMAX - lag(LATMAX, 1) over (order by gdate)) >1 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'MESONET_TSQP' and LATMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'MESONET' dataset, 'Latitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMIN - lag(LATMIN, 1) over (order by gdate)) >2 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'MESONET_TSQP' and LATMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'CWOP' dataset, 'Longitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMAX - lag(LONMAX, 1) over (order by gdate)) >.2 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'OAR_CWOP_TSQP' and LONMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'CWOP' dataset, 'Longitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMIN - lag(LONMIN, 1) over (order by gdate)) >.2 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'OAR_CWOP_TSQP' and LONMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'CWOP' dataset, 'Latitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMAX - lag(LATMAX, 1) over (order by gdate)) >10 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'OAR_CWOP_TSQP' and LATMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'CWOP' dataset, 'Latitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMIN - lag(LATMIN, 1) over (order by gdate)) >.2 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'OAR_CWOP_TSQP' and LATMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'VOS' dataset, 'Longitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMAX - lag(LONMAX, 1) over (order by gdate)) >10 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'NWS_VOS_TSQP' and LONMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'VOS' dataset, 'Longitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMIN - lag(LONMIN, 1) over (order by gdate)) >10 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'NWS_VOS_TSQP' and LONMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE,  number_of_granules
from (select 'VOS' dataset, 'Latitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMAX - lag(LATMAX, 1) over (order by gdate)) >13 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'NWS_VOS_TSQP' and LATMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'VOS' dataset, 'Latitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMIN - lag(LATMIN, 1) over (order by gdate)) >8 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'NWS_VOS_TSQP' and LATMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'HADS' dataset, 'Longitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMAX - lag(LONMAX, 1) over (order by gdate)) >10 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'NWS_HADS_TSQP' and LONMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'HADS' dataset, 'Longitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMIN - lag(LONMIN, 1) over (order by gdate)) >2 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'NWS_HADS_TSQP' and LONMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'HADS' dataset, 'Latitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMAX - lag(LATMAX, 1) over (order by gdate)) >1 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'NWS_HADS_TSQP' and LATMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'HADS' dataset, 'Latitude' parameter, 'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMIN - lag(LATMIN, 1) over (order by gdate)) >1 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'NWS_HADS_TSQP' and LATMIN <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'GPSMET' dataset, 'Longitude' parameter, 'Maximum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LONMAX - lag(LONMAX, 1) over (order by gdate)) >1 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'OAR_GPSMET_TSQP' and LONMAX <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'ENSO' dataset, 'Depth' parameter, 'SAMPLESIZE' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(SAMPLESIZE - lag(SAMPLESIZE, 1) over (order by gdate)) >500 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'OAR_ENSO_XBT_TSQP' and SAMPLESIZE <>0))
group by segment_counter
order by segment_counter nulls first)
union all
select dataset, parameter, statistic, segment_start, segment_end,
latmin, latmax, lonmin, lonmax, SAMPLESIZE, number_of_granules
from (select 'ENSO' dataset, 'Latitude' parameter,  'Minimum' statistic,
to_char(min(gdate),'DD-MON-YY') segment_start,
to_char(max(gdate),'DD-MON-YY') segment_end,
min(LATMIN) LATMIN, max(LATMAX) LATMAX, min(LONMIN) LONMIN, max(LONMAX) LONMAX, max(SAMPLESIZE) SAMPLESIZE,
count(*) number_of_granules
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
sum(segment_start) over (order by gdate) segment_counter
from (select granule, gdate, LATMIN, LATMAX, LONMIN, LONMAX, SAMPLESIZE,
case when abs(LATMIN - lag(LATMIN, 1) over (order by gdate)) >10 then 1 else null end segment_start
from ri.nosa_spatial
where granule = 'OAR_ENSO_XBT_TSQP' and LATMIN <>0))
group by segment_counter
order by segment_counter nulls first);

DATASET   PARAMETER STATISTIC  SEGMENT_S SEGMENT_E     LATMIN     LATMAX     LONMIN     LONMAX SAMPLESIZE  NUMBER_OF_GRANULES
--------- --------- ---------- --------- --------- ---------- ---------- ---------- ---------- ----------  ------------------
GOESWINDS Longitude Maximum    26-APR-05 13-JUN-05   -49.6923    61.7781  -179.9998   179.9992      32796                   8
GOESWINDS Longitude Maximum    27-JUN-05 25-JUL-05   -48.9002 61.5449004  -126.1005   -17.8221      21895                   5
GOESWINDS Longitude Maximum    01-AUG-05 01-AUG-05 -.97979984 61.6076001  -179.9903   179.9437      20576                   1
GOESWINDS Longitude Maximum    08-AUG-05 22-AUG-05   -49.7789 61.6609002  -178.9998   -18.0137      33596                   3
GOESWINDS Longitude Maximum    29-AUG-05 12-SEP-05   -49.6029    61.6481  -179.9969   179.9953      35121                   3
GOESWINDS Longitude Maximum    19-SEP-05 17-OCT-05   -49.3494    61.6319  -178.9898   -18.3794      33671                   2
GOESWINDS Longitude Maximum    24-OCT-05 22-MAY-06   -49.7897 61.7725005  -179.9998   179.9995      38929                  28
GOESWINDS Longitude Maximum    29-MAY-06 05-JUN-06    -49.518 61.6214997  -178.9973   -17.7174      33026                   2
GOESWINDS Longitude Maximum    12-JUN-06 10-JUL-06   -49.5867 61.7224995  -179.9957   179.9978      32976                   5
GOESWINDS Longitude Maximum    17-JUL-06 24-JUL-06   -44.8319    61.5719  -178.9968   -18.1709      31961                   2
GOESWINDS Longitude Maximum    31-JUL-06 14-AUG-06   -49.6874 61.6685999  -179.9941   179.9998      36088                   3
GOESWINDS Longitude Maximum    21-AUG-06 21-AUG-06   -49.3455 61.2828998  -178.9974   -17.6976      35728                   1
GOESWINDS Longitude Maximum    28-AUG-06 28-AUG-06   -45.0193 61.7823003  -179.9992   179.9786      26852                   1
GOESWINDS Longitude Maximum    04-SEP-06 04-SEP-06   -49.7049 61.5675005  -178.9975   -17.8042      33236                   1
GOESWINDS Longitude Maximum    11-SEP-06 11-SEP-06    -49.401 61.2814001  -179.9718   179.9876      37571                   1
GOESWINDS Longitude Maximum    18-SEP-06 18-SEP-06   -49.7219 61.4573999  -178.9663   -18.3162      33636                   1
GOESWINDS Longitude Maximum    25-SEP-06 09-OCT-06    -49.541 61.7076001  -179.9935   179.9927      37154                   3
GOESWINDS Longitude Maximum    16-OCT-06 23-OCT-06     -49.56    61.5131  -178.9996   -18.1872      32672                   2
GOESWINDS Longitude Maximum    30-OCT-06 30-OCT-06   -49.4665 61.6573003  -179.9718   179.9385      33582                   1
GOESWINDS Longitude Maximum    06-NOV-06 06-NOV-06   -49.5652 61.2461004  -126.7146   -18.0073      19383                   1
GOESWINDS Longitude Maximum    13-NOV-06 13-NOV-06   -49.7655 61.2593995  -179.9999    179.999      30844                   1
GOESWINDS Longitude Maximum    20-NOV-06 20-NOV-06   -49.5633 61.5542999  -178.9906   -17.8965      31127                   1
GOESWINDS Longitude Maximum    27-NOV-06 24-APR-07   -49.7883 61.7923999  -179.9998   179.9997      40045                  68
GOESWINDS Longitude Maximum    24-APR-07 24-APR-07 -.99979984 55.0916003  -126.9226    -17.977       9383                   1
GOESWINDS Longitude Maximum    24-APR-07 02-MAY-07   -49.9455      61.79  -179.9998   179.9999      35476                  60
GOESWINDS Longitude Maximum    02-MAY-07 02-MAY-07   -49.5605 61.2092004  -126.5098   -18.0073      17826                   1
GOESWINDS Longitude Maximum    02-MAY-07 19-MAY-07   -49.8685 61.7952002  -179.9999   179.9999      36690                 129
GOESWINDS Longitude Maximum    19-MAY-07 19-MAY-07   -48.1383 60.9959002  -127.1429   -18.4565      23210                   1
GOESWINDS Longitude Maximum    19-MAY-07 20-MAY-07    -49.836 61.2326997   -179.992   179.9852      30913                   2
GOESWINDS Longitude Maximum    20-MAY-07 20-MAY-07   -49.3415 60.8728998  -126.7768    -18.194      20580                   1
GOESWINDS Longitude Maximum    20-MAY-07 21-MAY-07   -49.6547 61.5245001  -179.9985   179.9999      35259                  14
GOESWINDS Longitude Maximum    22-MAY-07 22-MAY-07 -.92380004 54.4397998  -123.4208   -17.9045      12790                   1
GOESWINDS Longitude Maximum    22-MAY-07 27-MAY-07    -49.896    61.7938  -179.9998   179.9993      36831                  39
GOESWINDS Longitude Maximum    27-MAY-07 27-MAY-07   -49.3558 61.1543995  -178.9987   -17.9095      32362                   2
GOESWINDS Longitude Maximum    27-MAY-07 27-MAY-07   -44.6707 60.7938996  -178.9966   -85.4903      11777                   1
GOESWINDS Longitude Maximum    27-MAY-07 02-JUN-07    -49.863 61.7892999       -179   -17.7337      36372                  51
GOESWINDS Longitude Maximum    03-JUN-07 03-JUN-07   -49.4223 61.7838996  -179.9964   179.9997      32053                   6
GOESWINDS Longitude Maximum    03-JUN-07 03-JUN-07 -.91289982 54.7030004  -126.1642   -17.8042      13403                   1
GOESWINDS Longitude Maximum    04-JUN-07 04-JUN-07   -49.4362 61.7811004  -179.9961   179.9958      32959                   4
GOESWINDS Longitude Maximum    04-JUN-07 04-JUN-07   -48.8632 61.2952997  -126.0359   -18.3096      17998                   1
GOESWINDS Longitude Maximum    04-JUN-07 11-JUN-07   -49.7628      61.79  -179.9994   179.9999      36398                  52
GOESWINDS Longitude Maximum    11-JUN-07 13-JUN-07   -49.6474 61.4395997       -179   -18.1348      31503                  11
GOESWINDS Longitude Maximum    13-JUN-07 09-JUL-07   -49.8396 61.7940002  -179.9999   179.9999      34413                 205
GOESWINDS Longitude Maximum    09-JUL-07 11-JUL-07   -49.5129 61.7833001       -179   -17.8737      33221                  11
GOESWINDS Longitude Maximum    11-JUL-07 14-JUL-07   -49.7381 61.7871002  -179.9996   179.9999      35085                  27
GOESWINDS Longitude Maximum    14-JUL-07 17-JUL-07   -49.6738 61.7892004  -178.9998   -17.8632      35050                  22
GOESWINDS Longitude Maximum    17-JUL-07 17-JUL-07   -43.9102 61.5502002  -178.9692   -87.6741      11324                   1
GOESWINDS Longitude Maximum    17-JUL-07 19-JUL-07    -49.806 61.7892004  -178.9986   -17.8038      31323                  12
GOESWINDS Longitude Maximum    19-JUL-07 22-JUL-07   -49.6633 61.7830004  -179.9999   179.9999      33761                  24
GOESWINDS Longitude Maximum    22-JUL-07 24-JUL-07   -49.7332 61.7756005  -178.9996   -17.8989      34622                  19
GOESWINDS Longitude Maximum    24-JUL-07 24-JUL-07   -44.6972 61.5974995  -178.9987   -52.7214      15189                   1
GOESWINDS Longitude Maximum    24-JUL-07 27-JUL-07   -49.6529 61.7923999  -178.9998   -17.8093      34026                  25
GOESWINDS Longitude Maximum    27-JUL-07 29-JUL-07   -49.8335 61.7833001  -179.9991   179.9986      32384                  10
GOESWINDS Longitude Maximum    29-JUL-07 29-JUL-07 -.91629954 55.0733997  -126.6529   -18.3143      11257                   1
GOESWINDS Longitude Maximum    29-JUL-07 31-JUL-07   -49.5921 61.7942999  -179.9998   179.9999      33667                  21
GOESWINDS Longitude Maximum    31-JUL-07 03-AUG-07     -49.72 61.7873999  -178.9999   -17.8038      32073                  18
GOESWINDS Longitude Maximum    03-AUG-07 08-AUG-07   -49.7766 61.7940002  -179.9999   179.9997      34952                  46
GOESWINDS Longitude Maximum    08-AUG-07 11-AUG-07   -49.6704 61.7828002  -178.9995   -17.7174      34659                  24
GOESWINDS Longitude Maximum    11-AUG-07 26-AUG-07   -50.0165 61.7947003  -179.9996   179.9997      37133                 111
GOESWINDS Longitude Maximum    26-AUG-07 26-AUG-07   -48.0028    59.9412  -126.3444   -18.1132      14365                   1
GOESWINDS Longitude Maximum    26-AUG-07 28-AUG-07   -49.7039 61.5940998  -179.9992   179.9998      34922                  17
GOESWINDS Longitude Maximum    28-AUG-07 28-AUG-07   -49.4721    61.1369  -126.9722   -18.8379      18019                   1
GOESWINDS Longitude Maximum    28-AUG-07 28-AUG-07   -51.5256 61.0118004   -179.994   179.9301      29919                   2
GOESWINDS Longitude Maximum    28-AUG-07 28-AUG-07 -.99610038 55.0564001  -126.7488   -18.3179      13239                   1
GOESWINDS Longitude Maximum    29-AUG-07 29-AUG-07   -49.8668 61.3571998  -179.9942   179.9987      29749                   5
GOESWINDS Longitude Maximum    29-AUG-07 06-SEP-07   -50.0461 61.7907996  -178.9999   -17.7279      32971                  64
GOESWINDS Longitude Maximum    06-SEP-07 08-SEP-07   -49.8322 61.7885003  -179.9992   179.9999      32056                  15
GOESWINDS Longitude Maximum    08-SEP-07 08-SEP-07 -1.0254999 60.4390998  -179.3965   -18.5976      11539                   1
GOESWINDS Longitude Maximum    08-SEP-07 09-SEP-07   -46.2389 61.7864001  -179.9994 179.997501      23376                   6
GOESWINDS Longitude Maximum    09-SEP-07 09-SEP-07 -1.0138996 54.5006005  -125.6027   -18.2399       8689                   1
GOESWINDS Longitude Maximum    09-SEP-07 10-SEP-07   -45.6213 61.7885003  -179.9989   179.9997      26074                  10
GOESWINDS Longitude Maximum    10-SEP-07 10-SEP-07   -47.9919    60.7281  -126.7676   -18.3769      18962                   1
GOESWINDS Longitude Maximum    10-SEP-07 11-SEP-07   -49.4802 61.5538996  -179.9789   179.9899      33267                   2
GOESWINDS Longitude Maximum    11-SEP-07 11-SEP-07    -49.154 61.6173003  -126.5554   -18.2988      18213                   1
GOESWINDS Longitude Maximum    11-SEP-07 13-SEP-07   -49.7094 61.7859002  -179.9995   179.9999      33759                  16
GOESWINDS Longitude Maximum    13-SEP-07 13-SEP-07      -49.7 60.0452002  -126.6085   -18.7005      16924                   1
GOESWINDS Longitude Maximum    13-SEP-07 17-SEP-07   -50.0721 61.7912995  -179.9998   179.9999      37242                  32
GOESWINDS Longitude Maximum    17-SEP-07 17-SEP-07   -50.2945 61.0197003  -179.2877   -18.0909      21730                   1
GOESWINDS Longitude Maximum    17-SEP-07 18-SEP-07   -49.4874 61.3228002  -179.9924   179.9989      35088                   7
GOESWINDS Longitude Maximum    18-SEP-07 24-SEP-07   -50.1136 61.7895997  -178.9996   -17.7933      35241                  44
GOESWINDS Longitude Maximum    24-SEP-07 24-SEP-07    -49.379 61.7833001  -179.9932   179.9979      25159                   3
GOESWINDS Longitude Maximum    24-SEP-07 24-SEP-07   -49.9071 61.3245997  -178.2915   -18.5688      21536                   1
GOESWINDS Longitude Maximum    24-SEP-07 25-SEP-07   -49.7153 61.7043995  -179.9964   179.9891      34701                   4
GOESWINDS Longitude Maximum    25-SEP-07 25-SEP-07   -49.8522    61.0781  -126.9299   -18.3328      19334                   1
GOESWINDS Longitude Maximum    25-SEP-07 26-SEP-07   -49.7264 61.7900996   -179.999   179.9991      31578                   9
GOESWINDS Longitude Maximum    26-SEP-07 26-SEP-07   -49.7417 59.6652002  -126.4126 -18.432501      17076                  1
GOESWINDS Longitude Maximum    26-SEP-07 29-SEP-07   -49.7717 61.7842999  -179.9996   179.9974      34778                  23
GOESWINDS Longitude Maximum    29-SEP-07 02-OCT-07 -49.787501 61.7816999  -178.9993   -17.8508      33968                  24
GOESWINDS Longitude Maximum    02-OCT-07 10-OCT-07    -50.027    61.7938  -179.9995   179.9991      35373                  68
GOESWINDS Longitude Maximum    10-OCT-07 10-OCT-07    -49.245    61.4288  -126.1683   -18.4313      22482                   1
GOESWINDS Longitude Maximum    11-OCT-07 11-OCT-07   -49.5341 61.5580004  -179.9929   179.9422      35208                   1
GOESWINDS Longitude Maximum    11-OCT-07 11-OCT-07    -49.442 60.9130004  -126.8711   -18.5057      19968                   1
GOESWINDS Longitude Maximum    11-OCT-07 13-OCT-07   -49.9615      61.79  -179.9991   179.9986      35079                  18
GOESWINDS Longitude Maximum    13-OCT-07 13-OCT-07   -49.2862 59.8978002  -127.6307   -19.7011      16076                   1
GOESWINDS Longitude Maximum    13-OCT-07 14-OCT-07   -49.8302 61.7821998  -179.9995   179.9987      34870                  11
GOESWINDS Longitude Maximum    15-OCT-07 18-OCT-07   -49.9048 61.7942999  -178.9993   -18.1982      34842                  27
GOESWINDS Longitude Maximum    18-OCT-07 18-OCT-07 .805499899 61.6054999  -178.9758   -86.7337       8604                   1
GOESWINDS Longitude Maximum    18-OCT-07 24-OCT-07   -49.7935 61.7923999  -178.9993   -18.2042      34923                  45
GOESWINDS Longitude Maximum    24-OCT-07 04-NOV-07   -51.1366 61.7935003  -179.9999   179.9999      35592                  89
GOESWINDS Longitude Maximum    04-NOV-07 04-NOV-07   -48.1632 60.9790998  -126.1068   -18.1934      15614                   1
GOESWINDS Longitude Maximum    04-NOV-07 04-NOV-07   -49.4683 61.2499004  -179.9974   179.9887      29600                   3
GOESWINDS Longitude Maximum    04-NOV-07 04-NOV-07   -47.8717 61.1073003   -126.371   -18.1601      19682                   1
GOESWINDS Longitude Maximum    04-NOV-07 05-NOV-07   -49.5446 61.0543995  -179.9956   179.9997      31618                   3
GOESWINDS Longitude Maximum    05-NOV-07 05-NOV-07   -48.1734 60.9966003  -126.4984   -18.0023      15089                   1
GOESWINDS Longitude Maximum    05-NOV-07 07-NOV-07   -49.8041 61.7933001  -179.9998   179.9997      34308                  21
GOESWINDS Longitude Maximum    08-NOV-07 08-NOV-07   -49.5548 61.0928002  -126.9437   -18.1934      20062                   1
GOESWINDS Longitude Maximum    08-NOV-07 19-NOV-07    -49.774 61.7952002  -179.9995   179.9999      37895                  88
GOESWINDS Longitude Maximum    19-NOV-07 19-NOV-07   -47.8282 60.5481996  -126.5592   -18.8121      14746                  1
GOESWINDS Longitude Maximum    19-NOV-07 28-NOV-07   -49.8794 61.7873999  -179.9999   179.9998      35295                  71
GOESWINDS Longitude Maximum    28-NOV-07 28-NOV-07    -47.902 61.1802002  -127.1292   -17.9433      16538                   1
GOESWINDS Longitude Maximum    28-NOV-07 29-NOV-07   -49.5494 61.7919996  -179.9973   179.9998      33399                  13
GOESWINDS Longitude Maximum    30-NOV-07 30-NOV-07   -49.4872 61.1928002  -126.9951   -17.9669      18267                   1
GOESWINDS Longitude Maximum    30-NOV-07 01-DEC-07   -49.6579 61.2728998  -179.9969   179.9972      33391                   9
GOESWINDS Longitude Maximum    01-DEC-07 01-DEC-07   -47.5821 59.3459002  -126.6375   -18.2649      15441                   1
GOESWINDS Longitude Maximum    01-DEC-07 03-DEC-07   -49.7606 61.6907001  -179.9998   179.9993      33384                  18
GOESWINDS Longitude Minimum    26-APR-05 13-JUN-05   -49.6923    61.7781  -179.9998   179.9992      32796                   8
GOESWINDS Longitude Minimum    27-JUN-05 25-JUL-05   -48.9002 61.5449004  -126.1005   -17.8221      21895                   5
GOESWINDS Longitude Minimum    01-AUG-05 01-AUG-05 -.97979984 61.6076001  -179.9903   179.9437      20576                   1
GOESWINDS Longitude Minimum    08-AUG-05 08-AUG-05   -49.7789 61.3423003   -126.958   -18.6198      20574                   1
GOESWINDS Longitude Minimum    15-AUG-05 30-OCT-06   -49.7897 61.7823003  -179.9998   179.9998      38929                  58
GOESWINDS Longitude Minimum    06-NOV-06 06-NOV-06   -49.5652 61.2461004  -126.7146   -18.0073      19383                   1
GOESWINDS Longitude Minimum    13-NOV-06 24-APR-07   -49.7883 61.7923999  -179.9999   179.9997      40045                  70
GOESWINDS Longitude Minimum    24-APR-07 24-APR-07 -.99979984 55.0916003  -126.9226    -17.977       9383                   1
GOESWINDS Longitude Minimum    24-APR-07 02-MAY-07   -49.9455      61.79  -179.9998   179.9999      35476                  60
GOESWINDS Longitude Minimum    02-MAY-07 02-MAY-07   -49.5605 61.2092004  -126.5098   -18.0073      17826                   1
GOESWINDS Longitude Minimum    02-MAY-07 19-MAY-07   -49.8685 61.7952002  -179.9999   179.9999      36690                 129
GOESWINDS Longitude Minimum    19-MAY-07 19-MAY-07   -48.1383 60.9959002  -127.1429   -18.4565      23210                   1
GOESWINDS Longitude Minimum    19-MAY-07 20-MAY-07    -49.836 61.2326997   -179.992   179.9852      30913                   2
GOESWINDS Longitude Minimum    20-MAY-07 20-MAY-07   -49.3415 60.8728998  -126.7768    -18.194      20580                   1
GOESWINDS Longitude Minimum    20-MAY-07 21-MAY-07   -49.6547 61.5245001  -179.9985   179.9999      35259                  14
GOESWINDS Longitude Minimum    22-MAY-07 22-MAY-07 -.92380004 54.4397998  -123.4208   -17.9045      12790                   1
GOESWINDS Longitude Minimum    22-MAY-07 01-JUN-07    -49.896    61.7938  -179.9998   179.9993      36831                  82
GOESWINDS Longitude Minimum    01-JUN-07 01-JUN-07   -49.7332 61.3249004  -125.6739   -18.1617      20120                   1
GOESWINDS Longitude Minimum    01-JUN-07 01-JUN-07   -49.6018 61.3333001  -178.9835   -18.0658      32730                   1
GOESWINDS Longitude Minimum    01-JUN-07 01-JUN-07   -47.7044 61.1378002  -126.7559   -18.4241      21871                   1
GOESWINDS Longitude Minimum    01-JUN-07 03-JUN-07   -49.4223 61.7838996  -179.9964   179.9997      32053                  14
GOESWINDS Longitude Minimum    03-JUN-07 03-JUN-07 -.91289982 54.7030004  -126.1642   -17.8042      13403                   1
GOESWINDS Longitude Minimum    04-JUN-07 04-JUN-07   -49.4362 61.7811004  -179.9961   179.9958      32959                   4
GOESWINDS Longitude Minimum    04-JUN-07 04-JUN-07   -48.8632 61.2952997  -126.0359   -18.3096      17998                   1
GOESWINDS Longitude Minimum    04-JUN-07 29-JUL-07   -49.8396 61.7940002  -179.9999   179.9999      36398                 420
GOESWINDS Longitude Minimum    29-JUL-07 29-JUL-07 -.91629954 55.0733997  -126.6529   -18.3143      11257                   1
GOESWINDS Longitude Minimum    29-JUL-07 10-AUG-07   -49.7766 61.7942999  -179.9999   179.9999      34952                  96
GOESWINDS Longitude Minimum    10-AUG-07 10-AUG-07    -48.061 60.2147003  -127.2871   -17.7174      18091                   1
GOESWINDS Longitude Minimum    10-AUG-07 26-AUG-07   -50.0165 61.7947003  -179.9996   179.9997      37133                 123
GOESWINDS Longitude Minimum    26-AUG-07 26-AUG-07   -48.0028    59.9412  -126.3444   -18.1132      14365                   1
GOESWINDS Longitude Minimum    26-AUG-07 28-AUG-07   -49.7039 61.5940998  -179.9992   179.9998      34922                  17
GOESWINDS Longitude Minimum    28-AUG-07 28-AUG-07   -49.4721    61.1369  -126.9722   -18.8379      18019                   1
GOESWINDS Longitude Minimum    28-AUG-07 28-AUG-07   -51.5256 61.0118004   -179.994   179.9301      29919                   2
GOESWINDS Longitude Minimum    28-AUG-07 28-AUG-07 -.99610038 55.0564001  -126.7488   -18.3179      13239                   1
GOESWINDS Longitude Minimum    29-AUG-07 03-SEP-07   -50.0461 61.7907996  -179.9942   179.9987      32971                  48
GOESWINDS Longitude Minimum    04-SEP-07 04-SEP-07   -49.4303 61.6583997  -126.4236   -17.8845      20388                   3
GOESWINDS Longitude Minimum    04-SEP-07 09-SEP-07   -49.8987 61.7885003  -179.9994   179.9999      32574                  40
GOESWINDS Longitude Minimum    09-SEP-07 09-SEP-07 -1.0138996 54.5006005  -125.6027   -18.2399       8689                   1
GOESWINDS Longitude Minimum    09-SEP-07 10-SEP-07   -45.6213 61.7885003  -179.9989   179.9997      26074                  10
GOESWINDS Longitude Minimum    10-SEP-07 10-SEP-07   -47.9919    60.7281  -126.7676   -18.3769      18962                   1
GOESWINDS Longitude Minimum    10-SEP-07 11-SEP-07   -49.4802 61.5538996  -179.9789   179.9899      33267                   2
GOESWINDS Longitude Minimum    11-SEP-07 11-SEP-07    -49.154 61.6173003  -126.5554   -18.2988      18213                   1
GOESWINDS Longitude Minimum    11-SEP-07 13-SEP-07   -49.7094 61.7859002  -179.9995   179.9999      33759                  16
GOESWINDS Longitude Minimum    13-SEP-07 13-SEP-07      -49.7 60.0452002  -126.6085   -18.7005      16924                   1
GOESWINDS Longitude Minimum    13-SEP-07 18-SEP-07   -50.2945 61.7912995  -179.9998   179.9999      37242                  40
GOESWINDS Longitude Minimum    18-SEP-07 18-SEP-07   -49.5991 60.9954999  -127.2246   -18.0714      17192                   2
GOESWINDS Longitude Minimum    18-SEP-07 22-SEP-07   -49.7892 61.7895997  -178.9996   -17.8038      33885                  28
GOESWINDS Longitude Minimum    22-SEP-07 22-SEP-07     -49.91 59.7923999  -125.6655    -18.212      17804                   2
GOESWINDS Longitude Minimum    22-SEP-07 25-SEP-07   -50.1136 61.7833001  -179.9964   179.9979      35241                  20
GOESWINDS Longitude Minimum    25-SEP-07 25-SEP-07   -49.8522    61.0781  -126.9299   -18.3328      19334                   1
GOESWINDS Longitude Minimum    25-SEP-07 26-SEP-07   -49.7264 61.7900996   -179.999   179.9991      31578                   9
GOESWINDS Longitude Minimum    26-SEP-07 26-SEP-07   -49.7417 59.6652002  -126.4126 -18.432501      17076                   1
GOESWINDS Longitude Minimum    26-SEP-07 10-OCT-07    -50.027    61.7938  -179.9996   179.9991      35373                 115
GOESWINDS Longitude Minimum    10-OCT-07 10-OCT-07    -49.245    61.4288  -126.1683   -18.4313      22482                   1
GOESWINDS Longitude Minimum    11-OCT-07 11-OCT-07   -49.5341 61.5580004  -179.9929   179.9422      35208                   1
GOESWINDS Longitude Minimum    11-OCT-07 11-OCT-07    -49.442 60.9130004  -126.8711   -18.5057      19968                   1
GOESWINDS Longitude Minimum    11-OCT-07 13-OCT-07   -49.9615      61.79  -179.9991   179.9986      35079                  18
GOESWINDS Longitude Minimum    13-OCT-07 13-OCT-07   -49.2862 59.8978002  -127.6307   -19.7011      16076                   1
GOESWINDS Longitude Minimum    13-OCT-07 14-OCT-07   -49.8302 61.7821998  -179.9995   179.9987      34870                  11
GOESWINDS Longitude Minimum    15-OCT-07 15-OCT-07   -49.4467 61.0049004  -127.1814   -19.0442      20331                   1
GOESWINDS Longitude Minimum    15-OCT-07 16-OCT-07   -49.9048 61.7806005  -178.9993   -18.1982      34042                   9
GOESWINDS Longitude Minimum    16-OCT-07 16-OCT-07   -48.8367 54.6952002  -126.9537   -19.0399      10565                   1
GOESWINDS Longitude Minimum    16-OCT-07 04-NOV-07   -51.1366 61.7942999  -179.9999   179.9999      35592                 151
GOESWINDS Longitude Minimum    04-NOV-07 04-NOV-07   -48.1632 60.9790998  -126.1068   -18.1934      15614                   1
GOESWINDS Longitude Minimum    04-NOV-07 04-NOV-07   -49.4683 61.2499004  -179.9974   179.9887      29600                   3
GOESWINDS Longitude Minimum    04-NOV-07 04-NOV-07   -47.8717 61.1073003   -126.371   -18.1601      19682                   1
GOESWINDS Longitude Minimum    04-NOV-07 05-NOV-07   -49.5446 61.0543995  -179.9956   179.9997      31618                   3
GOESWINDS Longitude Minimum    05-NOV-07 05-NOV-07   -48.1734 60.9966003  -126.4984   -18.0023      15089                   1
GOESWINDS Longitude Minimum    05-NOV-07 07-NOV-07   -49.8041 61.7933001  -179.9998   179.9997      34308                  21
GOESWINDS Longitude Minimum    08-NOV-07 08-NOV-07   -49.5548 61.0928002  -126.9437   -18.1934      20062                   1
GOESWINDS Longitude Minimum    08-NOV-07 19-NOV-07    -49.774 61.7952002  -179.9995   179.9999      37895                  88
GOESWINDS Longitude Minimum    19-NOV-07 19-NOV-07   -47.8282 60.5481996  -126.5592   -18.8121      14746                   1
GOESWINDS Longitude Minimum    19-NOV-07 28-NOV-07   -49.8794 61.7873999  -179.9999   179.9998      35295                  71
GOESWINDS Longitude Minimum    28-NOV-07 28-NOV-07    -47.902 61.1802002  -127.1292   -17.9433      16538                   1
GOESWINDS Longitude Minimum    28-NOV-07 29-NOV-07   -49.5494 61.7919996  -179.9973   179.9998      33399                  13
GOESWINDS Longitude Minimum    30-NOV-07 30-NOV-07   -49.4872 61.1928002  -126.9951   -17.9669      18267                   1
GOESWINDS Longitude Minimum    30-NOV-07 01-DEC-07   -49.6579 61.2728998  -179.9969   179.9972      33391                   9
GOESWINDS Longitude Minimum    01-DEC-07 01-DEC-07   -47.5821 59.3459002  -126.6375   -18.2649      15441                   1
GOESWINDS Longitude Minimum    01-DEC-07 03-DEC-07   -49.7606 61.6907001  -179.9998   179.9993      33384                  18
GOESWINDS Latitude  Maximum    26-APR-05 13-JUN-05   -49.6923    61.7781  -179.9998   179.9992      32796                   8
GOESWINDS Latitude  Maximum    27-JUN-05 11-JUL-05 -.99439952 54.9364997  -126.1005   -18.1904      13333                   3
GOESWINDS Latitude  Maximum    18-JUL-05 18-JUL-05   -48.9002 61.5449004  -125.5178   -18.2428      21895                   1
GOESWINDS Latitude  Maximum    25-JUL-05 25-JUL-05 -.97979984 54.8640002  -123.8641   -17.8221      11930                   1
GOESWINDS Latitude  Maximum    01-AUG-05 24-APR-07   -49.7897 61.7923999  -179.9999   179.9998      40045                 131
GOESWINDS Latitude  Maximum    24-APR-07 24-APR-07 -.99979984 55.0916003  -126.9226    -17.977       9383                   1
GOESWINDS Latitude  Maximum    24-APR-07 21-MAY-07   -49.9455 61.7952002  -179.9999   179.9999      36690                 208
GOESWINDS Latitude  Maximum    22-MAY-07 22-MAY-07 -.92380004 54.4397998  -123.4208   -17.9045      12790                   1
GOESWINDS Latitude  Maximum    22-MAY-07 03-JUN-07    -49.896    61.7938  -179.9998   179.9997      36831                  99
GOESWINDS Latitude  Maximum    03-JUN-07 03-JUN-07 -.91289982 54.7030004  -126.1642   -17.8042      13403                   1
GOESWINDS Latitude  Maximum    04-JUN-07 29-JUL-07   -49.8396 61.7940002  -179.9999   179.9999      36398                 425
GOESWINDS Latitude  Maximum    29-JUL-07 29-JUL-07 -.91629954 55.0733997  -126.6529   -18.3143      11257                   1
GOESWINDS Latitude  Maximum    29-JUL-07 29-JUL-07    -49.576 61.7942999  -179.9998   179.9999      32247                   5
GOESWINDS Latitude  Maximum    29-JUL-07 29-JUL-07    -44.706 55.0142004  -179.9959   179.9826      17227                   1
GOESWINDS Latitude  Maximum    30-JUL-07 28-AUG-07   -51.5256 61.7947003  -179.9999   179.9998      37133                 235
GOESWINDS Latitude  Maximum    28-AUG-07 28-AUG-07 -.99610038 55.0564001  -126.7488   -18.3179      13239                   1
GOESWINDS Latitude  Maximum    29-AUG-07 09-SEP-07   -50.0461 61.7907996  -179.9994   179.9999      32971                  91
GOESWINDS Latitude  Maximum    09-SEP-07 09-SEP-07 -1.0138996 54.5006005  -125.6027   -18.2399       8689                   1
GOESWINDS Latitude  Maximum    09-SEP-07 22-SEP-07   -50.2945 61.7912995  -179.9998   179.9999      37242                 101
GOESWINDS Latitude  Maximum    22-SEP-07 16-OCT-07   -50.1136    61.7938  -179.9996   179.9991      35373                 191
GOESWINDS Latitude  Maximum    16-OCT-07 16-OCT-07   -48.8367 54.6952002  -126.9537   -19.0399      10565                   1
GOESWINDS Latitude  Maximum    16-OCT-07 03-DEC-07   -51.1366 61.7952002  -179.9999   179.9999      37895                 385
GOESWINDS Latitude  Minimum    26-APR-05 30-MAY-05   -49.6923    61.7781  -179.9998   179.9992      32796                   6
GOESWINDS Latitude  Minimum    06-JUN-05 11-JUL-05 -.99439952    61.7266  -179.9997   179.9827      22413                   5
GOESWINDS Latitude  Minimum    18-JUL-05 18-JUL-05   -48.9002 61.5449004  -125.5178   -18.2428      21895                   1
GOESWINDS Latitude  Minimum    25-JUL-05 01-AUG-05 -.97979984 61.6076001  -179.9903   179.9437      20576                   2
GOESWINDS Latitude  Minimum    08-AUG-05 26-JUN-06   -49.7897 61.7725005  -179.9998   179.9995      38929                  41
GOESWINDS Latitude  Minimum    03-JUL-06 03-JUL-06 -.96780024 60.6930004  -179.9942    179.975      20396                   1
GOESWINDS Latitude  Minimum    10-JUL-06 10-JUL-06   -44.5782 60.9909998  -179.9913   179.9474      29182                   1
GOESWINDS Latitude  Minimum    17-JUL-06 17-JUL-06 -1.0223003 61.1166003  -178.9968   -18.1709      18875                   1
GOESWINDS Latitude  Minimum    24-JUL-06 21-APR-07   -49.7883 61.7923999  -179.9999   179.9998      40045                  63
GOESWINDS Latitude  Minimum    21-APR-07 22-APR-07 -.98560048 61.5974995  -179.9996   179.9684      18225                   3
GOESWINDS Latitude  Minimum    22-APR-07 23-APR-07   -49.7766 61.7897003  -179.9996   179.9962      32790                  14
GOESWINDS Latitude  Minimum    24-APR-07 24-APR-07 -1.0021998 60.8809998  -179.9953 179.997501      18968                   2
GOESWINDS Latitude  Minimum    24-APR-07 24-APR-07    -49.627 61.6193995  -179.9968   179.9997      28642                   4
GOESWINDS Latitude  Minimum    24-APR-07 24-APR-07 -.99979984 55.0916003  -126.9226    -17.977       9383                   1
GOESWINDS Latitude  Minimum    24-APR-07 03-MAY-07   -49.9455 61.7942999  -179.9998   179.9999      36690                  72
GOESWINDS Latitude  Minimum    04-MAY-07 04-MAY-07 -1.0047998    61.5862  -179.9846    179.994      19711                   2
GOESWINDS Latitude  Minimum    04-MAY-07 04-MAY-07   -49.6954 61.7940002  -179.9982   179.9952      33361                   5
GOESWINDS Latitude  Minimum    04-MAY-07 04-MAY-07   -23.7437 60.9790998  -179.9747    179.989      21713                   1
GOESWINDS Latitude  Minimum    05-MAY-07 05-MAY-07      -1.01 60.9754999  -179.9513   179.9814      20235                   2
GOESWINDS Latitude  Minimum    05-MAY-07 05-MAY-07     -49.56    61.7881  -179.9952   179.9904      30939                   4
GOESWINDS Latitude  Minimum    05-MAY-07 06-MAY-07 -1.0042999     61.605  -179.9618   179.9929      20120                   4
GOESWINDS Latitude  Minimum    06-MAY-07 10-MAY-07   -49.6386 61.7919996  -179.9996   179.9992      34264                  37
GOESWINDS Latitude  Minimum    10-MAY-07 10-MAY-07    -24.346 61.5580004  -179.9883   179.9529      19765                   1
GOESWINDS Latitude  Minimum    11-MAY-07 11-MAY-07 -1.0171998 60.8785999  -179.9953    179.998      17995                   2
GOESWINDS Latitude  Minimum    11-MAY-07 13-MAY-07   -49.6874 61.7868004  -179.9999   179.9994      31751                  22
GOESWINDS Latitude  Minimum    14-MAY-07 14-MAY-07 -.98280024 61.0414001  -179.9989    179.997      18768                   2
GOESWINDS Latitude  Minimum    14-MAY-07 16-MAY-07   -49.5573 61.7952002  -179.9978   179.9997      32822                   7
GOESWINDS Latitude  Minimum    16-MAY-07 16-MAY-07 -1.0078002 61.5316999  -179.9204   179.9929      17364                   1
GOESWINDS Latitude  Minimum    16-MAY-07 21-MAY-07    -49.836 61.7723999  -179.9992   179.9999      36141                  46
GOESWINDS Latitude  Minimum    22-MAY-07 22-MAY-07 -1.0085999 59.7866003  -179.9798   179.9769      19386                   2
GOESWINDS Latitude  Minimum    22-MAY-07 23-MAY-07   -49.7257 61.7871002  -179.9995   179.9993      36831                  12
GOESWINDS Latitude  Minimum    23-MAY-07 24-MAY-07  -.9995001 61.0314001  -179.9818   179.9896      19618                   3
GOESWINDS Latitude  Minimum    24-MAY-07 31-MAY-07    -49.896    61.7938  -179.9998    179.999      36471                  61
GOESWINDS Latitude  Minimum    31-MAY-07 01-JUN-07 -1.0104003 61.0214001  -178.9992   -18.0915      19648                   3
GOESWINDS Latitude  Minimum    01-JUN-07 03-JUN-07   -49.7332 61.7838996  -179.9964   179.9997      32730                  19
GOESWINDS Latitude  Minimum    03-JUN-07 03-JUN-07 -.91289982 54.7030004  -126.1642   -17.8042      13403                   1
GOESWINDS Latitude  Minimum    04-JUN-07 05-JUN-07   -49.7628 61.7818004  -179.9984   179.9995      36398                  16
GOESWINDS Latitude  Minimum    06-JUN-07 06-JUN-07 -1.0140998    61.5719  -179.9937   179.9984      21438                   2
GOESWINDS Latitude  Minimum    06-JUN-07 16-JUN-07   -49.8065      61.79  -179.9994   179.9999      32711                  78
GOESWINDS Latitude  Minimum    16-JUN-07 17-JUN-07 -.98680044 61.7021002  -179.9959   179.9993      19400                   4
GOESWINDS Latitude  Minimum    17-JUN-07 20-JUN-07   -49.7794 61.7940002  -179.9999   179.9999      32358                  25
GOESWINDS Latitude  Minimum    21-JUN-07 21-JUN-07 -1.0140998 61.5643995  -179.9994   179.9995      18354                   2
GOESWINDS Latitude  Minimum    21-JUN-07 24-JUN-07   -49.6143 61.7802997  -179.9996   179.9999      33163                  30
GOESWINDS Latitude  Minimum    25-JUN-07 25-JUN-07 -.99540032 61.6123003  -179.9969   179.9968      19830                   2
GOESWINDS Latitude  Minimum    25-JUN-07 26-JUN-07   -49.6138 61.6814001  -179.9994   179.9997      31926                   7
GOESWINDS Latitude  Minimum    26-JUN-07 26-JUN-07  -.9854999 61.0338996  -179.9189    179.972      19117                   1
GOESWINDS Latitude  Minimum    26-JUN-07 29-JUN-07   -49.7545 61.7926001  -179.9998   179.9999      33481                  28
GOESWINDS Latitude  Minimum    29-JUN-07 30-JUN-07 -1.0119996 61.4697003  -179.9886   179.9852      19979                   2
GOESWINDS Latitude  Minimum    30-JUN-07 01-JUL-07   -49.8396 61.7902997  -179.9999   179.9999      32338                  15
GOESWINDS Latitude  Minimum    02-JUL-07 02-JUL-07 -.98260008 60.9276997  -179.9822   179.9635      19248                   1
GOESWINDS Latitude  Minimum    02-JUL-07 03-JUL-07   -49.5743 61.7921998  -179.9996   179.9994      32124                   8
GOESWINDS Latitude  Minimum    03-JUL-07 03-JUL-07 -.98590022 60.9724995  -179.9934   179.9692      17934                   1
GOESWINDS Latitude  Minimum    03-JUL-07 03-JUL-07   -24.3008 61.7862995  -179.9994   179.9974      21597                   1
GOESWINDS Latitude  Minimum    03-JUL-07 08-JUL-07   -49.8285 61.7861004  -179.9995   179.9997      34413                  42
GOESWINDS Latitude  Minimum    08-JUL-07 09-JUL-07 -1.0187005 61.5869996  -179.9917   179.9957      19251                   2
GOESWINDS Latitude  Minimum    09-JUL-07 09-JUL-07   -49.6529    61.7781  -179.9974   179.9997      32877                   7
GOESWINDS Latitude  Minimum    10-JUL-07 10-JUL-07    -1.0231 60.9135003       -179    -20.303      18735                   1
GOESWINDS Latitude  Minimum    10-JUL-07 10-JUL-07   -49.5129 61.7833001  -178.9989   -17.9188      33221                   5
GOESWINDS Latitude  Minimum    10-JUL-07 11-JUL-07 -1.0111004 61.5657996  -178.9987   -18.8723      20556                   3
GOESWINDS Latitude  Minimum    11-JUL-07 11-JUL-07   -49.6067 61.5669996  -179.9995   179.9963      35085                   6
GOESWINDS Latitude  Minimum    12-JUL-07 12-JUL-07 -1.0083001 60.9473999  -179.9975   179.9959      21352                   2
GOESWINDS Latitude  Minimum    12-JUL-07 18-JUL-07    -49.806 61.7892004  -179.9996   179.9999      35050                  53
GOESWINDS Latitude  Minimum    18-JUL-07 19-JUL-07 -.99959968 60.9878998  -179.9999   179.9965      19100                   4
GOESWINDS Latitude  Minimum    19-JUL-07 21-JUL-07   -49.6633 61.7830004  -179.9999   179.9999      33761                  14
GOESWINDS Latitude  Minimum    21-JUL-07 21-JUL-07 -1.0095001 60.9245997  -179.9821   179.9906      17974                   1
GOESWINDS Latitude  Minimum    21-JUL-07 21-JUL-07   -49.5184 61.5804999  -179.9988   179.9947      23728                   3
GOESWINDS Latitude  Minimum    21-JUL-07 21-JUL-07 -1.0049004 61.6123003  -179.9845   179.9882      16426                   2
GOESWINDS Latitude  Minimum    21-JUL-07 25-JUL-07   -49.7332 61.7804003  -179.9966   179.9947      34622                  25
GOESWINDS Latitude  Minimum    25-JUL-07 25-JUL-07 .695099578 60.8897998   -178.992   -17.9172      13692                   1
GOESWINDS Latitude  Minimum    25-JUL-07 25-JUL-07   -23.3522 61.5533997  -178.9988   -18.1244      22071                   1
GOESWINDS Latitude  Minimum    25-JUL-07 26-JUL-07   -49.3071    61.6681  -178.9968   -17.9633      31886                   6
GOESWINDS Latitude  Minimum    26-JUL-07 26-JUL-07 -.98889962 61.6785003  -178.9937   -18.6445      18676                   1
GOESWINDS Latitude  Minimum    26-JUL-07 26-JUL-07   -24.5905 61.6700996  -178.9814   -18.6634      21341                   1
GOESWINDS Latitude  Minimum    26-JUL-07 28-JUL-07   -49.8335 61.7923999  -179.9991   179.9986      34026                  21
GOESWINDS Latitude  Minimum    29-JUL-07 29-JUL-07 -.99280024 60.9066999  -179.9985   179.9967      18824                   2
GOESWINDS Latitude  Minimum    29-JUL-07 03-AUG-07     -49.72 61.7942999  -179.9998   179.9999      33667                  45
GOESWINDS Latitude  Minimum    03-AUG-07 03-AUG-07 -1.0154003 61.6097003  -179.9931   179.9997      20558                   1
GOESWINDS Latitude  Minimum    04-AUG-07 04-AUG-07   -48.0432 60.8964001  -179.9881   179.9978      22917                   1
GOESWINDS Latitude  Minimum    04-AUG-07 04-AUG-07 -.98389962 61.4416999  -179.9978   179.9906      20078                   1
GOESWINDS Latitude  Minimum    04-AUG-07 07-AUG-07   -49.7766 61.7940002  -179.9999   179.9996      34952                  29
GOESWINDS Latitude  Minimum    07-AUG-07 08-AUG-07 -1.0242999 61.5716999  -179.9986    179.994      20199                   3
GOESWINDS Latitude  Minimum    08-AUG-07 10-AUG-07   -49.6704 61.7828002  -179.9999   179.9928      33436                  22
GOESWINDS Latitude  Minimum    11-AUG-07 11-AUG-07 -1.0047998 61.4592004  -178.9975   -19.1505      18759                    2
GOESWINDS Latitude  Minimum    11-AUG-07 13-AUG-07   -49.6601 61.7821002  -179.9992    179.998      36220                  21
GOESWINDS Latitude  Minimum    13-AUG-07 14-AUG-07 -1.0009002 61.7843995  -179.9974     179.99      20529                   2
GOESWINDS Latitude  Minimum    14-AUG-07 16-AUG-07   -49.7681 61.7947003  -179.9996    179.999      37133                  21
GOESWINDS Latitude  Minimum    16-AUG-07 16-AUG-07   -24.5379 59.4078998  -179.9878   179.9782      21268                   1
GOESWINDS Latitude  Minimum    17-AUG-07 17-AUG-07 -1.0045997 60.1502997  -179.9866   179.9947      19259                   1
GOESWINDS Latitude  Minimum    17-AUG-07 18-AUG-07   -49.7436 61.7883001  -179.9971   179.9994      34332                   6
GOESWINDS Latitude  Minimum    18-AUG-07 18-AUG-07  -.9835003 60.1064001  -179.9751   179.9763      19906                   1
GOESWINDS Latitude  Minimum    18-AUG-07 28-AUG-07   -51.5256 61.7942999  -179.9995   179.9998      36997                  84
GOESWINDS Latitude  Minimum    28-AUG-07 28-AUG-07 -.99610038 55.0564001  -126.7488   -18.3179      13239                   1
GOESWINDS Latitude  Minimum    29-AUG-07 08-SEP-07   -50.0461 61.7907996  -179.9992   179.9999      32971                  83
GOESWINDS Latitude  Minimum    08-SEP-07 08-SEP-07 -1.0254999 61.5506005  -179.9977   179.9758      16142                   2
GOESWINDS Latitude  Minimum    08-SEP-07 09-SEP-07   -46.2389 61.7864001  -179.9994 179.997501      23376                   6
GOESWINDS Latitude  Minimum    09-SEP-07 09-SEP-07 -1.0252002 61.5933001  -179.9427   179.2554      12456                   2
GOESWINDS Latitude  Minimum    09-SEP-07 10-SEP-07   -45.6213 61.7885003  -179.9989   179.9997      26074                   6
GOESWINDS Latitude  Minimum    10-SEP-07 10-SEP-07 -1.0057996 61.0611004  -179.9217   179.9792      17394                   2
GOESWINDS Latitude  Minimum    10-SEP-07 21-SEP-07   -50.2945 61.7912995  -179.9998   179.9999      37242                  89
GOESWINDS Latitude  Minimum    21-SEP-07 22-SEP-07 -1.0254003 60.9459998  -178.9991   -17.8792      19545                   3
GOESWINDS Latitude  Minimum    22-SEP-07 25-SEP-07   -50.1136 61.7833001  -179.9964   179.9991      35241                   27
GOESWINDS Latitude  Minimum    25-SEP-07 25-SEP-07 -1.0140002 60.8326997  -179.9892   179.9293      16038                   1
GOESWINDS Latitude  Minimum    25-SEP-07 18-OCT-07    -50.027 61.7942999  -179.9996   179.9991      35373                 180
GOESWINDS Latitude  Minimum    18-OCT-07 18-OCT-07  -.9830004 61.6235999  -178.9842    -19.473      18921                    2
GOESWINDS Latitude  Minimum    18-OCT-07 19-OCT-07    -49.351 61.7809998  -178.9971   -18.9192      24208                   7
GOESWINDS Latitude  Minimum    19-OCT-07 19-OCT-07 -.99090022 61.5561004   -178.983   -18.9762      19094                   1
GOESWINDS Latitude  Minimum    19-OCT-07 03-DEC-07   -51.1366 61.7952002  -179.9999   179.9999      37895                 359
MESONET   Longitude Maximum    26-APR-05 08-AUG-05  -44.48917    87.1161    -177.36      176.2      18123                  96
MESONET   Longitude Maximum    09-AUG-05 16-NOV-05   -45.8379     71.323    -177.36   176.4905      18569                  94
MESONET   Longitude Maximum    17-NOV-05 23-NOV-05   -45.8379     71.323    -177.36   176.7528      18693                   7
MESONET   Longitude Maximum    24-NOV-05 19-MAY-06   -45.9863     71.323    -177.36     177.65      19822                 164
MESONET   Longitude Maximum    20-MAY-06 29-NOV-07      -63.4     71.323    -177.36   178.0102      20903                 166
MESONET   Longitude Minimum    26-APR-05 26-MAY-05  -44.48917     71.323    -170.72      176.2      17016                  28
MESONET   Longitude Minimum    27-MAY-05 29-NOV-07      -63.4    87.1161    -177.36   178.0102      20903                 499
MESONET   Latitude  Maximum    26-APR-05 10-JUL-05  -44.48917     71.323    -177.36      176.2      17332                  71
MESONET   Latitude  Maximum    12-JUL-05 21-JUL-05  -44.48917    87.1161    -177.36      176.2      18123                  10
MESONET   Latitude  Maximum    22-JUL-05 29-NOV-07      -63.4     71.323    -177.36   178.0102      20903                 446
MESONET   Latitude  Minimum    26-APR-05 28-JUN-06   -45.9863    87.1161    -177.36   178.0102      19822                 401
MESONET   Latitude  Minimum    29-JUN-06 29-NOV-07      -63.4     71.323    -177.36   178.0102      20903                 126
CWOP      Longitude Maximum    26-APR-05 27-JUL-05  -44.48917       68.2  -158.5391      176.2       3582                  14
CWOP      Longitude Maximum    03-AUG-05 09-NOV-05  -44.48917       68.2  -158.5391  176.49049       3948                  14
CWOP      Longitude Maximum    16-NOV-05 16-NOV-05  -44.48917       68.2  -158.5391  176.75282       3993                   1
CWOP      Longitude Maximum    23-NOV-05 19-JUL-06    -45.212    3377983   -7187617  177.64999       4804                  31
CWOP      Longitude Maximum    26-JUL-06 30-AUG-06      -46.3   69.95533  -171.7372  177.40911       4985                   6
CWOP      Longitude Maximum    06-SEP-06 28-NOV-07      -46.3   69.95533  -171.7372  176.91051       6072                  65
CWOP      Longitude Minimum    26-APR-05 01-FEB-06  -44.48917   69.95533  -158.5391  177.64999       4174                  38
CWOP      Longitude Minimum    15-FEB-06 03-MAY-06    -45.212    3377983   -169.373  177.64999       4570                  11
CWOP      Longitude Minimum    10-MAY-06 10-MAY-06    -45.212   69.95533   -7187617  177.64999       4539                   1
CWOP      Longitude Minimum    17-MAY-06 17-MAY-06    -45.212   69.95533   -169.373  177.64999       4585                   1
CWOP      Longitude Minimum    24-MAY-06 28-NOV-07      -46.3   69.95533  -171.7372  177.64999       6072                  80
CWOP      Latitude  Maximum    26-APR-05 15-MAR-06    -45.212   69.95533   -169.373  177.64999       4490                  42
CWOP      Latitude  Maximum    22-MAR-06 22-MAR-06    -45.212    3377983   -169.373  177.64999       4532                   1
CWOP      Latitude  Maximum    29-MAR-06 28-NOV-07      -46.3   69.95533   -7187617  177.64999       6072                  88
CWOP      Latitude  Minimum    26-APR-05 25-MAY-05  -44.48917       68.2  -158.5391      176.2       3364                   5
CWOP      Latitude  Minimum    01-JUN-05 01-JUN-05  -43.86267       68.2  -158.5391      176.2       3341                   1
CWOP      Latitude  Minimum    08-JUN-05 01-FEB-06  -44.48917   69.95533  -158.5391  177.64999       4174                  32
CWOP      Latitude  Minimum    15-FEB-06 23-AUG-06    -45.212    3377983   -7187617  177.64999       4985                  27
CWOP      Latitude  Minimum    30-AUG-06 28-NOV-07      -46.3   69.95533  -171.7372  177.40911       6072                  66
VOS       Longitude Maximum    26-APR-05 23-JAN-06      -74.4       89.1     -636.3        180       1586                  35
VOS       Longitude Maximum    30-JAN-06 30-JAN-06      -74.2         88     -179.6      199.7       1255                   1
VOS       Longitude Maximum    06-FEB-06 06-FEB-06      -71.5         88     -179.8      389.1       1331                   1
VOS       Longitude Maximum    13-FEB-06 13-MAR-06      -77.6       88.1     -179.9      179.9       1297                   4
VOS       Longitude Maximum    27-MAR-06 27-MAR-06      -69.6       87.3     -179.7      297.6       1340                   1
VOS       Longitude Maximum    03-APR-06 03-APR-06      -67.7       87.4     -178.7      190.6       1422                   1
VOS       Longitude Maximum    10-APR-06 10-APR-06      -55.2       87.7     -179.8        530       1564                   1
VOS       Longitude Maximum    17-APR-06 17-APR-06        -58       88.1     -179.8      354.1       1498                    1
VOS       Longitude Maximum    24-APR-06 29-MAY-06      -54.4       88.8     -550.5      179.3       1719                   5
VOS       Longitude Maximum    12-JUN-06 12-JUN-06      -42.4       71.6     -179.4      263.8       1019                   1
VOS       Longitude Maximum    19-JUN-06 02-OCT-06      -69.9       89.9     -877.2      179.8       1602                  16
VOS       Longitude Maximum    09-OCT-06 09-OCT-06        -65       81.7     -340.9      271.2       1546                   1
VOS       Longitude Maximum    16-OCT-06 23-OCT-06      -63.8       82.7     -179.9      179.8       1647                   2
VOS       Longitude Maximum    30-OCT-06 30-OCT-06      -61.1       82.6     -178.7        252       1562                   1
VOS       Longitude Maximum    06-NOV-06 01-JAN-07      -74.2       83.9       -180      179.9       1529                   9
VOS       Longitude Maximum    08-JAN-07 08-JAN-07      -77.8       89.1     -179.9      199.7       1437                   1
VOS       Longitude Maximum    15-JAN-07 01-OCT-07      -77.7       88.5     -790.4        180       1873                  37
VOS       Longitude Maximum    08-OCT-07 08-OCT-07      -70.1       93.6     -178.4      706.8       1851                   1
VOS       Longitude Maximum    15-OCT-07 03-DEC-07        -70       84.3     -179.7      179.9       1915                   8
VOS       Longitude Minimum    26-APR-05 25-JUL-05      -60.9       89.1     -179.9      179.9       1586                  14
VOS       Longitude Minimum    01-AUG-05 08-AUG-05      -53.6       87.1     -636.3      178.5       1310                   2
VOS       Longitude Minimum    15-AUG-05 08-MAY-06      -77.6       88.8       -180        530       1564                  32
VOS       Longitude Minimum    15-MAY-06 15-MAY-06        -51       88.1     -550.5      179.1       1719                   1
VOS       Longitude Minimum    29-MAY-06 24-JUL-06      -69.9         88     -179.9      263.8       1569                   8
VOS       Longitude Minimum    31-JUL-06 31-JUL-06      -68.1       76.8     -877.2      179.8       1602                   1
VOS       Longitude Minimum    07-AUG-06 02-OCT-06      -62.9       89.9       -180      179.8       1590                   9
VOS       Longitude Minimum    09-OCT-06 09-OCT-06        -65       81.7     -340.9      271.2       1546                   1
VOS       Longitude Minimum    16-OCT-06 07-MAY-07      -77.8       89.1       -180        252       1781                   29
VOS       Longitude Minimum    14-MAY-07 14-MAY-07      -46.1       88.4     -713.7      179.1       1761                   1
VOS       Longitude Minimum    21-MAY-07 13-AUG-07      -64.7       88.5     -179.9        180       1873                  13
VOS       Longitude Minimum    20-AUG-07 20-AUG-07      -42.1       87.5     -790.4      178.9       1707                   1
VOS       Longitude Minimum    27-AUG-07 27-AUG-07        -48       86.6     -179.9      179.8       1651                   1
VOS       Longitude Minimum    03-SEP-07 03-SEP-07      -53.1       87.8     -231.3      179.8       1852                   1
VOS       Longitude Minimum    10-SEP-07 03-DEC-07      -70.1       93.6       -180      706.8       1915                  13
VOS       Latitude  Maximum    26-APR-05 29-MAY-06      -77.6       89.1     -636.3        530       1719                  50
VOS       Latitude  Maximum    12-JUN-06 03-JUL-06      -65.4       76.3     -179.7      263.8       1569                   4
VOS       Latitude  Maximum    10-JUL-06 31-JUL-06      -69.9         88     -877.2      179.8       1602                   4
VOS       Latitude  Maximum    07-AUG-06 03-DEC-07      -77.8       93.6     -790.4      706.8       1915                  69
VOS       Latitude  Minimum    26-APR-05 16-MAY-05      -60.9       89.1     -179.9      179.8       1476                   4
VOS       Latitude  Minimum    23-MAY-05 17-OCT-05      -60.6       88.8     -636.3      179.9       1586                  18
VOS       Latitude  Minimum    24-OCT-05 31-OCT-05      -64.3       85.7     -179.7      179.7       1489                   2
VOS       Latitude  Minimum    07-NOV-05 28-NOV-05      -57.4         86     -179.9        180       1478                   4
VOS       Latitude  Minimum    05-DEC-05 12-DEC-05      -69.4       86.4     -179.9        180       1455                   2
VOS       Latitude  Minimum    19-DEC-05 03-APR-06      -77.6       88.1       -180      389.1       1422                  13
VOS       Latitude  Minimum    10-APR-06 01-MAY-06        -58       88.8       -180        530       1564                   4
VOS       Latitude  Minimum    08-MAY-06 15-MAY-06      -54.4       88.7     -550.5      179.1       1719                   2
VOS       Latitude  Minimum    29-MAY-06 12-JUN-06      -42.8       87.2     -179.9      263.8       1426                   2
VOS       Latitude  Minimum    19-JUN-06 28-AUG-06      -69.9       89.9     -877.2      179.8       1602                  11
VOS       Latitude  Minimum    04-SEP-06 13-NOV-06      -65.8       86.8     -340.9      271.2       1647                  11
VOS       Latitude  Minimum    20-NOV-06 27-NOV-06      -55.2       83.1     -179.9      179.9       1522                   2
VOS       Latitude  Minimum    04-DEC-06 07-MAY-07      -77.8       89.1       -180      199.7       1781                  22
VOS       Latitude  Minimum    14-MAY-07 28-MAY-07      -46.1       88.5     -713.7      179.9       1873                   3
VOS       Latitude  Minimum    04-JUN-07 11-JUN-07      -52.8       88.5     -179.9        180       1823                   2
VOS       Latitude  Minimum    18-JUN-07 18-JUN-07      -64.7       88.4     -179.4      179.8       1767                  1
VOS       Latitude  Minimum    25-JUN-07 25-JUN-07      -53.1       88.3     -179.3      179.6       1754                  1
VOS       Latitude  Minimum    02-JUL-07 03-SEP-07      -53.5       88.3     -790.4      179.8       1864                 10
VOS       Latitude  Minimum    10-SEP-07 22-OCT-07      -70.1       93.6       -180      706.8       1859                  7
VOS       Latitude  Minimum    29-OCT-07 03-DEC-07      -66.9       83.5     -179.7      179.9       1915                  6
HADS      Longitude Maximum    26-APR-05 05-MAY-05      -45.9     71.321   -167.089    108.317      11521                  9
HADS      Longitude Maximum    06-MAY-05 12-MAY-05      11.84     71.321   -167.089    -64.781      11507                  7
HADS      Longitude Maximum    13-MAY-05 17-MAY-05      11.84     71.321   -167.089    108.301      11513                  3
HADS      Longitude Maximum    18-MAY-05 19-MAY-05      11.84     71.321   -167.089    -64.781      11521                  2
HADS      Longitude Maximum    20-MAY-05 23-MAY-05      11.84     71.321   -167.089    108.824      11531                  4
HADS      Longitude Maximum    24-MAY-05 16-AUG-05    -34.883 71.3213889 -167.08944 -64.624444      11700                 78
HADS      Longitude Maximum    17-AUG-05 18-AUG-05 11.8402778 71.3213889 -167.08944 107.794722      11716                  2
HADS      Longitude Maximum    19-AUG-05 30-AUG-05 11.8402778 71.3213889 -167.08944 -64.624444      11738                 12
HADS      Longitude Maximum    31-AUG-05 09-SEP-05 11.8402778 71.3213889 -167.08944 103.352222      11755                 10
HADS      Longitude Maximum    22-SEP-05 12-OCT-05 11.8402778 71.3213889 -167.08944 -64.624444      11839                 15
HADS      Longitude Maximum    13-OCT-05 14-OCT-05 11.8402778 71.3213889 -167.08944 110.001111      11838                  2
HADS      Longitude Maximum    15-OCT-05 10-FEB-06 11.8402778 71.3213889 -170.21194 -64.624444      12009                109
HADS      Longitude Maximum    11-FEB-06 13-FEB-06 11.8402778 71.3213889 -170.21194 118.675833      12009                  3
HADS      Longitude Maximum    14-FEB-06 03-MAR-06 11.8402778 71.3213889 -170.21194 -64.624444      12009                 14
HADS      Longitude Maximum    04-MAR-06 08-MAR-06 11.8402778 71.3213889 -170.21194 87.7458333      12039                  5
HADS      Longitude Maximum    09-MAR-06 11-APR-06 11.8402778 71.3213889 -170.21194 -64.624444      12086                 30
HADS      Longitude Maximum    12-APR-06 12-APR-06 11.8402778 71.3213889 -170.21194 94.4908333      12088                  1
HADS      Longitude Maximum    13-APR-06 02-JUN-06 11.8402778 71.3213889 -170.21194 -64.624444      12138                 48
HADS      Longitude Maximum    07-JUN-06 20-JUN-06 11.8402778 71.3213889 -170.21194 96.8961111      12155                 14
HADS      Longitude Maximum    21-JUN-06 10-AUG-06 11.8402778 71.3213889 -170.21194 -64.624444      12252                 49
HADS      Longitude Maximum    11-AUG-06 11-AUG-06 11.8402778 71.3213889 -170.21194    89.7975      12253                  1
HADS      Longitude Maximum    12-AUG-06 17-AUG-06 11.8402778 71.3213889 -170.21194 -64.624444      12256                  6
HADS      Longitude Maximum    18-AUG-06 05-SEP-06 11.8402778 71.3213889 -170.21194 90.0972222      12278                 19
HADS      Longitude Maximum    06-SEP-06 24-OCT-06 11.8402778 71.3213889 -170.21194 -64.624444      12374                 46
HADS      Longitude Maximum    25-OCT-06 26-OCT-06 11.8402778 71.3213889 -170.21194 90.0308333      12375                  2
HADS      Longitude Maximum    27-OCT-06 28-OCT-06 11.8402778 71.3213889 -170.21194 -64.624444      12384                  2
HADS      Longitude Maximum    29-OCT-06 01-NOV-06 11.8402778 71.3213889 -170.21194 90.0838889      12393                  4
HADS      Longitude Maximum    02-NOV-06 08-NOV-06 11.8402778 71.3213889 -170.21194 -64.624444      12402                  7
HADS      Longitude Maximum    09-NOV-06 13-NOV-06 11.8402778 71.3213889 -170.21194 119.181111      12406                  5
HADS      Longitude Maximum    14-NOV-06 30-NOV-06 11.8402778 71.3213889 -170.21194 -64.624444      12406                 17
HADS      Longitude Maximum    01-DEC-06 06-DEC-06 11.8402778 71.3213889 -170.21194 118.881389      12404                  5
HADS      Longitude Maximum    07-DEC-06 17-APR-07 11.8402778 71.3213889 -170.21194 -64.624444      12553                128
HADS      Longitude Maximum    18-APR-07 02-MAY-07 11.8402778 71.3213889 -170.21194 109.352222      12626                 15
HADS      Longitude Maximum    03-MAY-07 22-MAY-07 11.8402778 71.3213889 -170.21194      -1.13      12650                 19
HADS      Longitude Maximum    23-MAY-07 01-JUN-07 11.8402778 71.3213889 -170.21194 123.218333      12662                 10
HADS      Longitude Maximum    02-JUN-07 03-AUG-07 11.8402778 71.3213889 -170.21194 -64.624444      12720                 61
HADS      Longitude Maximum    04-AUG-07 07-AUG-07 -43.034722 71.3213889 -170.21194 -15.718333      12739                  4
HADS      Longitude Maximum    08-AUG-07 09-AUG-07 11.8402778 71.3213889 -170.21194 -64.624444      12765                  2
HADS      Longitude Maximum    10-AUG-07 16-AUG-07 11.8402778 71.3213889 -170.21194 89.5963889      12790                  7
HADS      Longitude Maximum    17-AUG-07 11-SEP-07 11.8402778 71.3213889 -170.21194 -64.624444      12820                 26
HADS      Longitude Maximum    12-SEP-07 14-SEP-07 11.8402778 71.3213889 -170.21194 90.5102778      12820                  3
HADS      Longitude Maximum    15-SEP-07 26-SEP-07 11.8402778 71.3213889 -170.21194 -64.624444      12845                 12
HADS      Longitude Maximum    27-SEP-07 27-SEP-07 11.8402778 71.3213889 -170.21194 94.5461111      12845                  1
HADS      Longitude Maximum    28-SEP-07 27-NOV-07 11.8402778 71.3213889 -170.21194 -64.624444      12939                 60
HADS      Longitude Maximum    28-NOV-07 28-NOV-07 11.8402778 71.3213889 -170.21194   121.5675      12939                  1
HADS      Longitude Maximum    29-NOV-07 03-DEC-07 11.8402778 71.3213889 -170.21194 -64.624444      12955                  5
HADS      Longitude Minimum    26-APR-05 28-OCT-05      -45.9 71.3213889 -167.08944 110.001111      11866                158
HADS      Longitude Minimum    29-OCT-05 03-DEC-07 -43.034722 71.3213889 -170.21194 123.218333      12955                728
HADS      Latitude  Maximum    26-APR-05 03-DEC-07      -45.9 71.3213889 -170.21194 123.218333      12955                886
HADS      Latitude  Minimum    26-APR-05 03-MAY-05      11.84     71.321   -167.089    104.627      11521                  8
HADS      Latitude  Minimum    05-MAY-05 05-MAY-05      -45.9     71.321   -167.089    108.317      11495                  1
HADS      Latitude  Minimum    06-MAY-05 09-JUN-05      11.84     71.321   -167.089    108.824      11582                 33
HADS      Latitude  Minimum    10-JUN-05 14-JUN-05    -34.883     71.321   -167.089    -64.781      11595                  5
HADS      Latitude  Minimum    15-JUN-05 03-AUG-07      11.84 71.3213889 -170.21194 123.218333      12720                717
HADS      Latitude  Minimum    04-AUG-07 06-AUG-07 -43.034722 71.3213889 -170.21194 -15.718333      12739                  3
HADS      Latitude  Minimum    07-AUG-07 03-DEC-07 11.8402778 71.3213889 -170.21194   121.5675      12955                118
GPSMET    Longitude Maximum    26-APR-05 07-NOV-05 -14.326096 71.3228954 -170.72243 -66.642337        385                 25
GPSMET    Longitude Maximum    14-NOV-05 26-DEC-05 -14.326096 71.3228954 -170.72243 -64.696272        403                  7
GPSMET    Longitude Maximum    09-JAN-06 08-OCT-07 -14.326096 71.3228954 -170.72243 -52.677748        436                 87
GPSMET    Longitude Maximum    15-OCT-07 03-DEC-07 -14.326096 71.3228954 -170.72243      59.79        441                  8
ENSO      Depth     SAMPLESIZE 26-APR-05 18-JUL-05        -77       59.5       -180     179.99      10729                 12
ENSO      Depth     SAMPLESIZE 25-JUL-05 25-JUL-05        -90       59.5       -180     179.99      26549                  1
ENSO      Depth     SAMPLESIZE 01-AUG-05 19-DEC-05        -90       59.5       -180     179.99      27656                 18
ENSO      Depth     SAMPLESIZE 26-DEC-05 20-FEB-06        -90       59.5       -180        180      31992                  8
ENSO      Depth     SAMPLESIZE 06-MAR-06 17-APR-06        -90       59.5       -180        180      32687                  6
ENSO      Depth     SAMPLESIZE 01-MAY-06 23-OCT-06        -90       59.5       -180        180      38516                 24
ENSO      Depth     SAMPLESIZE 30-OCT-06 03-DEC-07        -90       59.5       -180        180      44666                 57
ENSO      Latitude  Minimum    26-APR-05 18-JUL-05        -77       59.5       -180     179.99      10729                 12
ENSO      Latitude  Minimum    25-JUL-05 03-DEC-07        -90       59.5       -180        180      44666                114

481 rows selected.



Spatial_Extents_Queries