open db sequoia; select raster.data.clip(ClosedPolygon ("-1704753 -581511, -1604753 -581511, -1604753 -481829, -1704753 -481829")), raster.time from raster where raster.freq = 5 order by time; select average (raster.data.clip(ClosedPolygon ("-1704753 -581511, -1604753 -581511, -1604753 -481829, -1704753 -481829"))) from raster where raster.time = 1; create table rasterFoo(time "Int4Adt", freq "Int4Adt", data "RasterAdt") key (data); insert into rasterFoo select raster.time, raster.freq, raster.data.clip(ClosedPolygon ("-1704753 -581511, -1604753 -581511, -1604753 -481829, -1704753 -481829")).lower_res(8) from raster where raster.time = 1 and raster.freq = 5; select * from point where point.name = "Abadi Creek"; create table polygonFoo (landuse "Int4Adt", shape "ClosedPolygonAdt") key (landuse); insert into polygonFoo select * from polygon where polygon.shape overlaps ClosedPolygon ("-1704753 -581511, -1604753 -581511, -1604753 -481829, -1704753 -481829"); select shape.area (), landuse from polygon where polygon.shape < Circle (Point (-1704753, -581511), 3170) and polygon.shape.area() > 1014420.0; select polygon.shape, polygon.landuse from polygon, point where point.name = "Zaca Ridge" and polygon.shape overlaps point.location.makeBox(50000); select polygon.shape, raster.data.clip(polygon.shape) from polygon, raster where polygon.landuse = 91 and raster.freq = 5 and raster.time = 1; drop table rasterFoo; drop table polygonFoo; close db sequoia; QUIT;