[Home] [Help]
PACKAGE: MDSYS.SDO_TOPO
Source
1 package SDO_TOPO AUTHID current_user AS
2
3 -- In memory representation of USER_SDO_TOPO_INFO
4 TYPE topo_metadata IS RECORD
5 (
6 owner VARCHAR2(32),
7 topology VARCHAR2(20),
8 topology_id NUMBER,
9 tolerance NUMBER,
10 srid NUMBER,
11 table_schema VARCHAR2(64),
12 table_name VARCHAR2(62),
13 column_name VARCHAR2(32),
14 tg_layer_id NUMBER,
15 tg_layer_type VARCHAR2(10),
16 tg_layer_level NUMBER,
17 child_layer_id NUMBER
18 );
19
20 PROCEDURE create_topology (Topology IN varchar2, tolerance IN NUMBER,
21 SRID IN NUMBER default NULL,
22 node_table_storage in varchar2 DEFAULT NULL,
23 edge_table_storage in varchar2 DEFAULT NULL,
24 face_table_storage in varchar2 DEFAULT NULL,
25 history_table_storage in varchar2 DEFAULT NULL,
26 Digits_Right_Of_Decimal in number default 16,
27 Topology_ID in number default NULL );
28
29 PROCEDURE drop_topology (Topology IN varchar2);
30
31 PROCEDURE add_topo_geometry_layer (Topology IN varchar2,
32 Table_Name IN varchar2,
33 Column_Name IN varchar2,
34 Topo_Geometry_Layer_Type IN varchar2,
35 Relation_table_storage in varchar2 DEFAULT NULL,
36 Child_Layer_id in number DEFAULT NULL,
37 Layer_ID in number default NULL);
38
39 PROCEDURE delete_topo_geometry_layer (Topology IN varchar2,
40 Table_Name IN varchar2,
41 Column_Name IN varchar2);
42
43 PROCEDURE initialize_metadata (Topology IN varchar2);
44
45 PROCEDURE prepare_for_export (Topology IN varchar2);
46
47 PROCEDURE initialize_after_import (Topology IN varchar2,
48 tg_layer_owner IN varchar2 default NULL);
49
50 /*
51 --
52 -- For a given sdo_topo_geometry, this procedure gets its boundary and
53 -- interior.
54 --
55 PROCEDURE get_feature_properties
56 (
57 mtdt IN TOPO_METADATA,
58 tg_id IN NUMBER, --- feature id
59 tg_type IN NUMBER, --- feature type
60 nd_bdy OUT NOCOPY SDO_TOPO_NSTD_TBL, --- boundary nodes
61 nd_int OUT NOCOPY SDO_TOPO_NSTD_TBL, --- interior nodes
62 eg_bdy OUT NOCOPY SDO_TOPO_NSTD_TBL, --- boundary edges
63 eg_int OUT NOCOPY SDO_TOPO_NSTD_TBL, --- interior edges
64 fc_int OUT NOCOPY SDO_TOPO_NSTD_TBL --- interior faces
65 );
66
67 PROCEDURE get_topo_properties
68 (
69 Topology IN VARCHAR2,
70 topo_elem_array IN SDO_TOPO_OBJECT_ARRAY,
71 tg_type IN NUMBER, --- feature type
72 nd_bdy OUT NOCOPY SDO_TOPO_NSTD_TBL, --- boundary nodes
73 nd_int OUT NOCOPY SDO_TOPO_NSTD_TBL, --- interior nodes
74 eg_bdy OUT NOCOPY SDO_TOPO_NSTD_TBL, --- boundary edges
75 eg_int OUT NOCOPY SDO_TOPO_NSTD_TBL, --- interior edges
76 fc_int OUT NOCOPY SDO_TOPO_NSTD_TBL --- interior faces
77 );
78 */
79
80 FUNCTION get_interacting_tgids
81 (
82 base_layer_id IN NUMBER, --- base layer id
83 q_feature IN SDO_TOPO_GEOMETRY, --- the query feature
84 mask IN VARCHAR2 --- the query
85 )
86 RETURN SDO_LIST_TYPE DETERMINISTIC;
87
88 FUNCTION get_interacting_tgids
89 (
90 tp_id IN NUMBER, -- topology id
91 base_layer_id IN NUMBER, --- base layer id
92 topo_elem_array IN SDO_TOPO_OBJECT_ARRAY, --- the query topo elements
93 mask IN VARCHAR2 --- the query
94 )
95 RETURN SDO_LIST_TYPE DETERMINISTIC;
96
97 FUNCTION relate (
98 geom1 IN SDO_TOPO_GEOMETRY, geom2 IN SDO_TOPO_GEOMETRY, mask IN VARCHAR2
99 ) RETURN VARCHAR2 DETERMINISTIC;
100
101 FUNCTION relate (
102 geom IN SDO_TOPO_GEOMETRY, topo_elem_array IN SDO_TOPO_OBJECT_ARRAY,
103 mask IN VARCHAR2
104 ) RETURN VARCHAR2 DETERMINISTIC;
105
106 /*
107 -- an overloading version of relate
108 FUNCTION relate(
109 geom1 IN SDO_TOPO_GEOMETRY,
110 nd_bdy_2 IN SDO_TOPO_NSTD_TBL,
111 nd_int_2 IN SDO_TOPO_NSTD_TBL,
112 eg_bdy_2 IN SDO_TOPO_NSTD_TBL,
113 eg_int_2 IN SDO_TOPO_NSTD_TBL,
114 fc_int_2 IN SDO_TOPO_NSTD_TBL,
115 mask IN VARCHAR2
116 ) RETURN VARCHAR2 DETERMINISTIC;
117
118 -- an overloading version of relate
119 FUNCTION relate
120 (
121 mtdt IN TOPO_METADATA,
122 tg_id IN NUMBER,
123 tg_type IN NUMBER,
124 nd_bdy IN SDO_TOPO_NSTD_TBL, --- geom2: boundary nodes
125 nd_int IN SDO_TOPO_NSTD_TBL, --- interior nodes
126 eg_bdy IN SDO_TOPO_NSTD_TBL, --- boundary edges
127 eg_int IN SDO_TOPO_NSTD_TBL, --- interior edges
128 fc_int IN SDO_TOPO_NSTD_TBL, --- interior faces
129 mask IN VARCHAR2
130 ) RETURN VARCHAR2 DETERMINISTIC;
131
132 -- another overloading version of relate
133 FUNCTION relate (
134 tsname IN VARCHAR2, tabname IN VARCHAR2,
135 colname IN VARCHAR2, rowid IN VARCHAR2,
136 nd_bdy IN SDO_TOPO_NSTD_TBL, nd_int IN SDO_TOPO_NSTD_TBL,
137 eg_bdy IN SDO_TOPO_NSTD_TBL, eg_int IN SDO_TOPO_NSTD_TBL,
138 fc_int IN SDO_TOPO_NSTD_TBL, mask IN VARCHAR2
139 ) RETURN VARCHAR2 DETERMINISTIC;
140
141 */
142 -- another overloaded version of relate
143 FUNCTION relate (
144 feature1 IN sdo_topo_geometry, feature2 IN sdo_geometry, mask IN VARCHAR2
145 ) RETURN VARCHAR2 DETERMINISTIC;
146
147 FUNCTION get_face_boundary (Topology IN varchar2, face_id IN number,
148 All_Edges IN varchar2 DEFAULT 'FALSE')
149 RETURN SDO_LIST_TYPE DETERMINISTIC;
150
151 FUNCTION get_topo_objects(Topology IN varchar2,
152 topo_geometry_layer_id IN number,
153 topo_geometry_id IN number )
154 RETURN SDO_TOPO_OBJECT_ARRAY DETERMINISTIC;
155
156
157 FUNCTION get_topo_objects(Topology IN varchar2, geometry IN SDO_GEOMETRY)
158 RETURN SDO_TOPO_OBJECT_ARRAY DETERMINISTIC;
159
160 FUNCTION internal_get_tgids(Topology IN varchar2, geometry IN SDO_GEOMETRY,
161 in_tg_layer_id IN NUMBER DEFAULT NULL,
162 operator IN varchar2)
163 RETURN SDO_LIST_TYPE DETERMINISTIC;
164
165 FUNCTION internal_get_tgids(Topology IN varchar2,
166 q_tg_layer_id IN NUMBER, q_tg_id in number,
167 in_tg_layer_id IN NUMBER DEFAULT NULL,
168 operator IN varchar2)
169 RETURN SDO_LIST_TYPE DETERMINISTIC;
170
171 Function tg_insert_relation (topology varchar2, tg_layer_id number,
172 topo_ids SDO_TOPO_OBJECT_ARRAY, gtype number,
173 input_tg_id number, input_tg_attribute varchar2)
174 return NUMBER;
175
176 Function tg_insert_relation (topology varchar2, tg_layer_id number,
177 topo_ids SDO_TGL_OBJECT_ARRAY, gtype number,
178 input_tg_id number, input_tg_attribute varchar2,
179 child_lid number)
180 return NUMBER;
181
182 PROCEDURE sdo_topo_crt_rlids_view(Topology in varchar2, topo_id number);
183
184 PROCEDURE lockRow_UniverseFace(topologyid in number);
185
186 FUNCTION align_linear_geometry(geometry1 SDO_GEOMETRY, geometry2 SDO_GEOMETRY,
187 tolerance number )
188 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
189
190 FUNCTION align_edge_geometry(geometry1 SDO_GEOMETRY, geometry2 SDO_GEOMETRY,
191 tolerance number, dgts number)
192 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
193
194 FUNCTION align_point_geometry(geometry1 SDO_GEOMETRY, geometry2 SDO_GEOMETRY,
195 tolerance number)
196 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE ;
197
198 FUNCTION get_internal_geometry(geom sdo_geometry,
199 nodeIds sdo_number_array, dim sdo_dim_array)
200 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
201
202 END SDO_TOPO;