30: -- the pixel's value of outGeoraster.
31: --
32: --
33: -- ARGUMENTS
34: -- inGeoRaster - The SDO_GEORASTER object to be applied with condition
35: -- condition - A boolean expression used to filter out pixels, the
36: -- syntax details are explained in GeoRaster Manual
37: -- storageParam - A string specifying storage parameters for the target
38: -- georaster object. The details are explained in GeoRaster
54: -- RETURNS
55: --
56: PROCEDURE findCells
57: (
58: inGeoRaster IN MDSYS.SDO_GEORASTER,
59: condition IN VARCHAR2,
60: storageParam IN VARCHAR2,
61: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
62: bgValues IN SDO_NUMBER_ARRAY DEFAULT NULL,
57: (
58: inGeoRaster IN MDSYS.SDO_GEORASTER,
59: condition IN VARCHAR2,
60: storageParam IN VARCHAR2,
61: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
62: bgValues IN SDO_NUMBER_ARRAY DEFAULT NULL,
63: nodata IN VARCHAR2 DEFAULT 'false',
64: parallelParam IN VARCHAR2 DEFAULT NULL
65: );
101: expression IN VARCHAR2,
102: rangeArray IN SDO_NUMBER_ARRAY,
103: valueArray IN SDO_NUMBER_ARRAY,
104: storageParam IN VARCHAR2,
105: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
106: nodata IN VARCHAR2 DEFAULT 'false',
107: nodataValue IN NUMBER default 0,
108: parallelParam IN VARCHAR2 DEFAULT NULL
109: );
139: -- RETURNS
140: --
141: PROCEDURE classify
142: (
143: inGeoRaster IN MDSYS.SDO_GEORASTER,
144: expression IN VARCHAR2,
145: rangeArray IN SDO_NUMBER_ARRAY,
146: valueArray IN SDO_NUMBER_ARRAY,
147: storageParam IN VARCHAR2,
144: expression IN VARCHAR2,
145: rangeArray IN SDO_NUMBER_ARRAY,
146: valueArray IN SDO_NUMBER_ARRAY,
147: storageParam IN VARCHAR2,
148: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
149: nodata IN VARCHAR2 DEFAULT 'false',
150: nodataValue IN NUMBER default 0,
151: parallelParam IN VARCHAR2 DEFAULT NULL
152: );
182: -- RETURNS
183: --
184: PROCEDURE classify
185: (
186: georArray IN SDO_GEORASTER_ARRAY,
187: expression IN VARCHAR2,
188: rangeArray IN SDO_NUMBER_ARRAY,
189: valueArray IN SDO_NUMBER_ARRAY,
190: storageParam IN VARCHAR2,
187: expression IN VARCHAR2,
188: rangeArray IN SDO_NUMBER_ARRAY,
189: valueArray IN SDO_NUMBER_ARRAY,
190: storageParam IN VARCHAR2,
191: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
192: nodata IN VARCHAR2 DEFAULT 'false',
193: nodataValue IN NUMBER default 0,
194: parallelParam IN VARCHAR2 DEFAULT NULL
195: );
203: -- and math operations, the target georaster object is stored
204: -- based on the parameter storageParam.
205: --
206: -- ARGUMENTS
207: -- inGeoRaster - The source SDO_GEORASTER object
208: -- operation - An array of varying length Oracle STRING,each STRING
209: -- is a valid expression, which is mapping to a target
210: -- band in the target georaster object, and specifies
211: -- how to calculate cell value based on source georaster
226: --
227: --
228: PROCEDURE rasterMathOp
229: (
230: inGeoRaster IN MDSYS.SDO_GEORASTER,
231: operation IN SDO_STRING2_ARRAY,
232: storageParam IN VARCHAR2,
233: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
234: nodata IN VARCHAR2 DEFAULT 'false',
229: (
230: inGeoRaster IN MDSYS.SDO_GEORASTER,
231: operation IN SDO_STRING2_ARRAY,
232: storageParam IN VARCHAR2,
233: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
234: nodata IN VARCHAR2 DEFAULT 'false',
235: nodataValue IN NUMBER default 0,
236: parallelParam IN VARCHAR2 DEFAULT NULL
237: );
271: (
272: inGeoRasters IN SYS_REFCURSOR,
273: operation IN SDO_STRING2_ARRAY,
274: storageParam IN VARCHAR2,
275: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
276: nodata IN VARCHAR2 DEFAULT 'false',
277: nodataValue IN NUMBER default 0,
278: parallelParam IN VARCHAR2 DEFAULT NULL
279: );
310: --
311: --
312: PROCEDURE rasterMathOp
313: (
314: georArray IN SDO_GEORASTER_ARRAY,
315: operation IN SDO_STRING2_ARRAY,
316: storageParam IN VARCHAR2,
317: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
318: nodata IN VARCHAR2 DEFAULT 'false',
313: (
314: georArray IN SDO_GEORASTER_ARRAY,
315: operation IN SDO_STRING2_ARRAY,
316: storageParam IN VARCHAR2,
317: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
318: nodata IN VARCHAR2 DEFAULT 'false',
319: nodataValue IN NUMBER default 0,
320: parallelParam IN VARCHAR2 DEFAULT NULL
321: );
354: --
355:
356: PROCEDURE rasterMathOp
357: (
358: georaster0 IN MDSYS.SDO_GEORASTER,
359: georaster1 IN MDSYS.SDO_GEORASTER,
360: constant IN NUMBER,
361: operator IN PLS_INTEGER,
362: storageParam IN VARCHAR2,
355:
356: PROCEDURE rasterMathOp
357: (
358: georaster0 IN MDSYS.SDO_GEORASTER,
359: georaster1 IN MDSYS.SDO_GEORASTER,
360: constant IN NUMBER,
361: operator IN PLS_INTEGER,
362: storageParam IN VARCHAR2,
363: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
359: georaster1 IN MDSYS.SDO_GEORASTER,
360: constant IN NUMBER,
361: operator IN PLS_INTEGER,
362: storageParam IN VARCHAR2,
363: outGeoraster IN OUT MDSYS.SDO_GEORASTER,
364: bgValues IN SDO_NUMBER_ARRAY DEFAULT NULL,
365: nodata IN VARCHAR2 DEFAULT 'false',
366: nodataValue IN NUMBER default 0,
367: parallelParam IN VARCHAR2 DEFAULT NULL
382: -- math expression.
383: --
384: --
385: -- ARGUMENTS
386: -- geoRaster - The SDO_GEORASTER object to be updated based on conditions
387: -- pyramidLevel - specifiy which pyramid level gets updated, if null, then all
388: -- pyramid levels get updated
389: -- condition - A array of boolean expressions to pick pixels, the
390: -- syntax details are explained in GeoRaster Manual
405: -- RETURNS
406: --
407: PROCEDURE rasterUpdate
408: (
409: geoRaster IN out MDSYS.SDO_GEORASTER,
410: pyramidLevel IN NUMBER,
411: conditions IN SDO_STRING2_ARRAY,
412: vals IN SDO_STRING2_ARRAYSET,
413: bgValues IN SDO_NUMBER_ARRAY DEFAULT NULL,
426: -- the model space if they are georeferenced
427: --
428: --
429: -- ARGUMENTS
430: -- geoRaster1 - The SDO_GEORASTER 1
431: -- geoRaster2 - The SDO_GEORASTER 2
432: -- tolerance - Specifies the tolerance used to decide if two pixels in cell space are
433: -- overlapped in the model spce. The value should be between 0
434: -- and 1 and is in pixel unit. for example, 0.5 means half pixel.
427: --
428: --
429: -- ARGUMENTS
430: -- geoRaster1 - The SDO_GEORASTER 1
431: -- geoRaster2 - The SDO_GEORASTER 2
432: -- tolerance - Specifies the tolerance used to decide if two pixels in cell space are
433: -- overlapped in the model spce. The value should be between 0
434: -- and 1 and is in pixel unit. for example, 0.5 means half pixel.
435: --
437: -- 'TRUE' if overlapped, otherwise 'FALSE'
438:
439: FUNCTION isOverlap
440: (
441: georaster1 IN MDSYS.SDO_GEORASTER,
442: georaster2 IN MDSYS.SDO_GEORASTER,
443: tolerance IN NUMBER default 0.5
444: )
445: RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
438:
439: FUNCTION isOverlap
440: (
441: georaster1 IN MDSYS.SDO_GEORASTER,
442: georaster2 IN MDSYS.SDO_GEORASTER,
443: tolerance IN NUMBER default 0.5
444: )
445: RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
446:
454: -- the model space if they are georeferenced
455: --
456: --
457: -- ARGUMENTS
458: -- geor_array - The SDO_GEORASTER array
459: -- tolerance - Specifies the tolerance used to decide if two pixels in cell space are
460: -- overlapped in the model spce. The value should be between 0
461: -- and 1 and is in pixel unit. for example, 0.5 means half pixel.
462: --
464: -- 'TRUE' if overlapped, otherwise 'FALSE'
465:
466: FUNCTION isOverlap
467: (
468: georArray IN SDO_GEORASTER_ARRAY,
469: tolerance IN NUMBER default 0.5
470: )
471: RETURN VARCHAR2 DETERMINISTIC PARALLEL_ENABLE;
472:
480: -- the model space if they are georeferenced
481: --
482: --
483: -- ARGUMENTS
484: -- geor_cur - The SDO_GEORASTER cursor
485: -- tolerance - Specifies the tolerance used to decide if two pixels in cell space are
486: -- overlapped in the model spce. The value should be between 0
487: -- and 1 and is in pixel unit. for example, 0.5 means half pixel.
488: --