1 PACKAGE sdo_pc_pkg authid current_user AS
2 -- all tables as "schema.table" for simpler interface.
3 FUNCTION INIT(
4 basetable varchar2,
5 basecol varchar2,
6 blktable VARCHAR2,
7 ptn_params varchar2,
8 pc_extent sdo_geometry default null,
9 pc_tol NUMBER default 0.0000000000005,
10 pc_tot_dimensions NUMBER default 2,
11 pc_domain sdo_orgscl_type default null,
12 pc_val_attr_tables SDO_STRING_ARRAY default null,
13 pc_other_attrs SYS.XMLTYPE default null)
14 RETURN SDO_PC;
15
16 procedure create_liblas_pyramid(
17 pc in sdo_pc,
18 keepLevel1Intact in number);
19
20 PROCEDURE CREATE_PC(
21 inp sdo_pc,
22 inptable varchar2,
23 clstpcdatatbl varchar2 default null);
24
25 PROCEDURE ADD_TO_PC(
26 inp sdo_pc,
27 inptable varchar2);
28
29 FUNCTION HAS_PYRAMID(
30 inp sdo_pc)
31 return number;
32
33 FUNCTION PRESERVES_LEVEL1(
34 inp sdo_pc)
35 return number;
36
37 -- works as read if qry params are null
38 FUNCTION CLIP_PC(
39 inp sdo_pc,
40 ind_dim_qry sdo_geometry,
41 other_dim_qry sdo_mbr,
42 qry_min_res number,
43 qry_max_res number,
44 blkno number default null,
45 include_custom_dims number default 0)
46 RETURN MDSYS.SDO_PC_BLK_TYPE PIPELINED;
47
48 PROCEDURE DROP_DEPENDENCIES(basetable varchar2, col varchar2);
49
50 FUNCTION TO_GEOMETRY(pts BLOB, num_pts NUMBER,
51 pc_tot_dim NUMBER, srid NUMBER default null,
52 blk_domain sdo_orgscl_type default null,
53 get_ids NUMBER default NULL)
54 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
55
56 FUNCTION GET_PT_IDs(pts BLOB, num_pts NUMBER,
57 pc_tot_dim NUMBER,
58 blk_domain sdo_orgscl_type default null)
59 RETURN SDO_NUMBER_ARRAY DETERMINISTIC;
60
61 function tin_to_pc(
62 tin sdo_tin,
63 basetable varchar2,
64 basecol varchar2,
65 blktable varchar2)
66 return sdo_pc deterministic;
67
68 /*
69 PROCEDURE POPULATE_FROM_CLSTPCDATA(inp sdo_pc, clstpcdatatbl varchar2);
70
71 PROCEDURE WRITE_CLSTPCDATA(inp sdo_pc, clstpcdatatbl varchar2);
72 */
73
74
75 /*
76 -- works as read if qry is null
77 FUNCTION CLIP_PCAttrs(inp sdo_pc, qry sdo_geometry, blkno number default null)
78 RETURN ANYDATASET;
79 FUNCTION CLIP_PC_PtIds(inp sdo_pc, qry sdo_geometry, blkno number default null)
80 RETURN ANYDATASET;
81 */
82
83 function clip_pc_into_tin(
84 pc_inp sdo_pc,
85 pc_ind_dim_qry sdo_geometry,
86 pc_other_dim_qry sdo_mbr,
87 pc_qry_min_res number,
88 pc_qry_max_res number,
89 tin_basetable varchar2,
90 tin_basecol varchar2,
91 tin_blktable varchar2,
92 tin_ptn_params varchar2 default null,
93 tin_break_lines sdo_geometry default null,
94 tin_stop_lines sdo_geometry default null,
95 tin_void_rgns sdo_geometry default null,
96 tin_clstpcdatatbl varchar2 default null,
97 pc_blkno number default null)
98 return mdsys.sdo_tin;
99
100 function create_contour_geometries(
101 pc sdo_pc,
102 sampling_resolution number,
103 elevations sdo_ordinate_array,
104 region sdo_geometry)
105 return sdo_geometry_array;
106
107 function create_contour_geometries(
108 pc_flat_table varchar2,
109 srid number,
110 sampling_resolution number,
111 elevations sdo_ordinate_array,
112 region sdo_geometry)
113 return sdo_geometry_array;
114
115 /* This procedure takes a 2D Geometry as input and generates
116 two SQL strings which can be appended to a user cursor in the
117 where clause. */
118 PROCEDURE get_tile_sql ( geometry IN SDO_GEOMETRY,
119 sql_interior OUT VARCHAR2,
120 sql_boundary OUT VARCHAR2,
121 tolerance IN NUMBER DEFAULT 0.0000005,
122 sdo_level in NUMBER DEFAULT 4,
123 sdo_ntiles in NUMBER DEFAULT 100);
124
125 /* This function returns a REFCURSOR which can be queried by the client
126 side code to fetch rows from the base table. The columns are the columns
127 of the base table: only numberic and VARCHAR columns allowed.
128 Query Geometry is used to clip the points from the base table.
129 First two colums should be X and Y. SRID is assumed to be the same
130 as the one used in Geometry. */
131 FUNCTION clip_pc_flat (geometry IN SDO_GEOMETRY,
132 table_name IN VARCHAR2,
133 tolerance IN NUMBER,
134 other_dim_qry IN MDSYS.SDO_MBR DEFAULT NULL,
135 mask IN VARCHAR2 DEFAULT 'ANYINTERACT')
136
137 RETURN SYS_REFCURSOR;
138
139 /* Same as the above, but return the actual SQL statement instead of the
140 cursor. Users can add additional predicates or select list and
141 execute it. */
142 FUNCTION clip_pc_flat_string (geometry IN SDO_GEOMETRY,
143 table_name IN VARCHAR2,
144 tolerance IN NUMBER,
145 other_dim_qry IN MDSYS.SDO_MBR DEFAULT NULL,
146 mask IN VARCHAR2 DEFAULT 'ANYINTERACT',
147 dop IN INTEGER DEFAULT NULL,
148 sdo_level in number DEFAULT 4,
149 sdo_ntiles in number DEFAULT 100)
150 RETURN clob;
151
152 procedure import_las(
153 source_las_file varchar2,
154 source_las_file_id varchar2,
155 target_table varchar2,
156 add_columns number);
157
158 function hilbert_xy2d(
159 n number,
160 x number,
161 y number)
162 return number;
163
164 function get_blocking_method(
165 inp sdo_pc)
166 return varchar2;
167
168 function getNthHilbertValue(
169 table_name varchar2,
170 n number)
171 return number;
172
173 END sdo_pc_pkg;