MDSYS.SDO_SAM dependencies on SDO_GEOMETRY

Line 52: -- geom geometry to be simplified. Datatype is MDSYS.sdo_geometry.

48: -- Syntax
49: -- Simplify_Geometry (geom, dim, pct_area_chang_limit)
50: --
51: -- Keywords and Paramters
52: -- geom geometry to be simplified. Datatype is MDSYS.sdo_geometry.
53: -- dim diminfo containing tolerance info.
54: -- Datatype is mdsys.sdo_dim_array.
55: -- pct_area_change_limit: Stops simplifying when area of resulting
56: -- geometry changes by at most this percentage.

Line 65: FUNCTION simplify_geometry(geom mdsys.sdo_geometry,

61: -- where b.table_name='POLY_4PT_TEMP' ;
62:
63:
64:
65: FUNCTION simplify_geometry(geom mdsys.sdo_geometry,
66: dim mdsys.sdo_dim_array,
67: pct_area_change_limit number default 2)
68: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
69:

Line 68: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

64:
65: FUNCTION simplify_geometry(geom mdsys.sdo_geometry,
66: dim mdsys.sdo_dim_array,
67: pct_area_change_limit number default 2)
68: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
69:
70: -- Tolerance as a parameter
71: FUNCTION simplify_geometry(geom mdsys.sdo_geometry,
72: tol number,

Line 71: FUNCTION simplify_geometry(geom mdsys.sdo_geometry,

67: pct_area_change_limit number default 2)
68: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
69:
70: -- Tolerance as a parameter
71: FUNCTION simplify_geometry(geom mdsys.sdo_geometry,
72: tol number,
73: pct_area_change_limit number default 2)
74: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
75:

Line 74: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;

70: -- Tolerance as a parameter
71: FUNCTION simplify_geometry(geom mdsys.sdo_geometry,
72: tol number,
73: pct_area_change_limit number default 2)
74: RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
75:
76:
77: -- Name
78: -- Simplify_Layer

Line 131: FUNCTION Intersection_Ratio(location mdsys.sdo_geometry,

127: -- select sdo_sam.intersection_ratio(a.geometry, b.geometry,
128: -- c.diminfo) from poly_4pt_temp a, tst b, user_sdo_geom_metadata c
129: -- where c.table_name = 'POLY_4PT_TEMP';
130:
131: FUNCTION Intersection_Ratio(location mdsys.sdo_geometry,
132: thematic_boundary mdsys.sdo_geometry,
133: dim mdsys.sdo_dim_array,
134: dist number default null,
135: units varchar2 default null)

Line 132: thematic_boundary mdsys.sdo_geometry,

128: -- c.diminfo) from poly_4pt_temp a, tst b, user_sdo_geom_metadata c
129: -- where c.table_name = 'POLY_4PT_TEMP';
130:
131: FUNCTION Intersection_Ratio(location mdsys.sdo_geometry,
132: thematic_boundary mdsys.sdo_geometry,
133: dim mdsys.sdo_dim_array,
134: dist number default null,
135: units varchar2 default null)
136: RETURN number PARALLEL_ENABLE;

Line 182: FUNCTION Bin_Geometry(geom mdsys.sdo_geometry, dim mdsys.sdo_dim_array,

178: -- select sdo_sam.bin_geometry(a.geometry, b.diminfo, 'BINTBL', 'GEOMETRY')
179: -- from poly_4pt a, user_sdo_geom_metadata b
180: -- where b.table_name='POLY_4PT' and a.gid=1;
181:
182: FUNCTION Bin_Geometry(geom mdsys.sdo_geometry, dim mdsys.sdo_dim_array,
183: bin_tablename varchar2, bin_colname in varchar2)
184: RETURN NUMBER PARALLEL_ENABLE;
185:
186:

Line 188: FUNCTION Bin_Geometry(geom mdsys.sdo_geometry, tol number,

184: RETURN NUMBER PARALLEL_ENABLE;
185:
186:
187: -- Signature using tolerance instead of dim
188: FUNCTION Bin_Geometry(geom mdsys.sdo_geometry, tol number,
189: bin_tablename varchar2, bin_colname in varchar2)
190: RETURN NUMBER PARALLEL_ENABLE;
191:
192: -- Name

Line 284: geom mdsys.sdo_geometry,

280: FUNCTION Aggregates_For_Geometry(theme_name varchar2,
281: theme_colname varchar2,
282: aggr_type_string varchar2,
283: aggr_col_string varchar2,
284: geom mdsys.sdo_geometry,
285: dst_spec varchar2 default null,
286: dst_offset number default null)
287: RETURN number ;
288: