PACKAGE: MDSYS.SDO_TIN_PKG

Source

1 PACKAGE sdo_tin_pkg authid current_user AS
2   -- all tables as "schema.table" for simpler interface.
3   FUNCTION INIT(basetable varchar2, basecol varchar2,
4        blktable varchar2,
5        ptn_params varchar2 default null,
6        tin_extent            sdo_geometry default null,
7        tin_tol               NUMBER default 0.000000000000005,
8        tin_tot_dimensions    NUMBER default 2,
9        tin_domain            sdo_orgscl_type default null,
10        tin_break_lines       SDO_GEOMETRY default null,
11        tin_stop_lines        SDO_GEOMETRY default null,
12        tin_void_rgns         SDO_GEOMETRY default null,
13        tin_val_attr_tables   SDO_STRING_ARRAY default null,
14        tin_other_attrs       SYS.XMLTYPE default null)
15     RETURN SDO_TIN ;
16 
17   PROCEDURE CREATE_TIN(inp sdo_tin, inptable varchar2,
18                        clstpcdatatbl varchar2 default null);
19 
20   -- works as read if qry is null
21   FUNCTION CLIP_TIN(inp sdo_tin,
22                    qry sdo_geometry, qry_min_res number, qry_max_res number,
23                    blkno number default null)
24     RETURN MDSYS.SDO_TIN_BLK_TYPE PIPELINED ;
25 
26   PROCEDURE DROP_DEPENDENCIES(basetable varchar2, col varchar2);
27 
28   FUNCTION TO_GEOMETRY(pts BLOB, trs BLOB,
29                        num_pts NUMBER, num_trs NUMBER,
30                        tin_ind_dim NUMBER,
31                        tin_tot_dim NUMBER, srid number default null,
32                        blk_domain sdo_orgscl_type default null,
33                        get_ids NUMBER default NULL)
34     RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
35 
36   PROCEDURE TO_DEM(
37     tin                 IN     sdo_tin,
38     dem                 IN OUT sdo_georaster,
39     blocksize           IN     NUMBER,
40     crs_units_per_pixel IN     NUMBER);
41 --  PRAGMA RESTRICT_REFERENCES(to_geometry, WNDS, WNPS, RNPS);
42 
43 /*
44 
45   -- works as read if qry is null
46   FUNCTION CLIP_Pts(inp sdo_tin,
47                     qry sdo_geometry,
48                     qry_min_res number, qry_max_res number,
49                     blkno number default null)
50     RETURN ANYDATASET;
51   FUNCTION CLIP_PtIds(inp sdo_tin,
52                     qry sdo_geometry,
53                     qry_min_res number, qry_max_res number)
54     RETURN ANYDATASET;
55 
56   -- works as read if qry is null
57   FUNCTION CLIP_Triangles(inp sdo_tin, qry sdo_geometry,
58                     qry_min_res number, qry_max_res number,
59                     blkno number default null)
60     RETURN ANYDATASET;
61   FUNCTION CLIP_TriangleIds(inp sdo_tin, qry sdo_geometry,
62                     qry_min_res number, qry_max_res number,
63                     blkno number default null)
64     RETURN ANYDATASET;
65 */
66 
67   function clip_tin_into_pc(
68     tin_inp         sdo_tin,
69     tin_qry         sdo_geometry,
70     tin_qry_min_res number,
71     tin_qry_max_res number,
72     pc_basetable    varchar2,
73     pc_basecol      varchar2,
74     pc_blktable     varchar2,
75     pc_ptn_params   varchar2 default null,
76     tin_blkno       number   default null)
77       return mdsys.sdo_pc;
78 
79   function project_ordinates_onto_tin(
80     ordinates2d sdo_ordinate_array,
81     tin         sdo_tin)
82       return sdo_ordinate_array deterministic;
83 
84   function get_surface_of_tin(
85     tin    sdo_tin,
86     geom2d sdo_geometry)
87       return number deterministic;
88 
89   function get_surface_of_tin_footprint(
90     tin    sdo_tin,
91     geom2d sdo_geometry)
92       return number deterministic;
93 
94   function get_volume_under_tin(
95     tin         sdo_tin,
96     geom2d      sdo_geometry,
97     base_height number)
98       return number deterministic;
99 
100 END sdo_tin_pkg;