[Home] [Help]
PACKAGE: MDSYS.SDO_CS
Source
1 PACKAGE sdo_cs AUTHID current_user AS
2 /*
3 TYPE EPSG_IDS
4 IS TABLE OF NUMBER;
5 */
6 -- for TRANSFORM operator: trusted callout interface
7 FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
8 dim IN mdsys.sdo_dim_array,
9 to_srid IN NUMBER)
10 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
11 PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
12
13 FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,
14 dim IN mdsys.sdo_dim_array,
15 to_srid IN NUMBER)
16 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
17 PRAGMA restrict_references(transform_orig_with_arcs, wnds, rnps, wnps);
18
19 FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
20 tolerance IN number,
21 to_srid IN NUMBER)
22 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
23 PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
24
25 FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
26 to_srid IN NUMBER)
27 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
28 PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
29
30 FUNCTION transform_orig_with_arcs(geom IN mdsys.sdo_geometry,
31 to_srid IN NUMBER)
32 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
33 PRAGMA restrict_references(transform_orig_with_arcs, wnds, rnps, wnps);
34
35 FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
36 dim IN mdsys.sdo_dim_array,
37 to_srname IN VARCHAR2)
38 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
39 -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
40
41 FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
42 tolerance IN number,
43 to_srname IN VARCHAR2)
44 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
45 -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
46
47 FUNCTION transform_orig(geom IN mdsys.sdo_geometry,
48 to_srname IN VARCHAR2)
49 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
50 -- PRAGMA restrict_references(transform_orig, wnds, rnps, wnps);
51
52 PROCEDURE transform_layer( table_in IN VARCHAR2,
53 column_in IN VARCHAR2,
54 table_out IN VARCHAR2,
55 to_srid IN NUMBER );
56
57 PROCEDURE transform_layer_with_arcs( table_in IN VARCHAR2,
58 column_in IN VARCHAR2,
59 table_out IN VARCHAR2,
60 to_srid IN NUMBER );
61
62 FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,
63 to_srid IN NUMBER)
64 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
65 PRAGMA restrict_references(viewport_transform, wnds, rnps, wnps);
66 -- FUNCTION viewport_transform(geom IN mdsys.sdo_geometry,
67 -- to_srname IN VARCHAR2)
68 -- RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
69 -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
70 FUNCTION validate_wkt(srid in NUMBER)
71 RETURN varchar2;
72 PRAGMA restrict_references(validate_wkt, wnds, rnps, wnps);
73
74 FUNCTION intl_validate_wkt(srid in NUMBER)
75 RETURN varchar2;
76 PRAGMA restrict_references(intl_validate_wkt, wnds, rnps, wnps);
77
78 FUNCTION internal_read_proj_from_wkt(
79 wkt VARCHAR2)
80 RETURN VARCHAR2;
81 PRAGMA restrict_references(internal_read_proj_from_wkt, wnds, rnps, wnps);
82
83 PROCEDURE transform_layer(
84 table_in IN VARCHAR2,
85 column_in IN VARCHAR2,
86 table_out IN VARCHAR2,
87 use_plan IN TFM_PLAN);
88
89 PROCEDURE transform_layer(
90 table_in IN VARCHAR2,
91 column_in IN VARCHAR2,
92 table_out IN VARCHAR2,
93 use_case IN VARCHAR2,
94 to_srid IN NUMBER);
95
96 FUNCTION determine_default_chain(
97 source_srid IN NUMBER,
98 target_srid IN NUMBER)
99 RETURN SDO_SRID_CHAIN;
100
101 FUNCTION determine_chain(
102 transient_rule_set IN SDO_TRANSIENT_RULE_SET,
103 use_case IN VARCHAR2,
104 source_srid IN NUMBER,
105 target_srid IN NUMBER)
106 RETURN TFM_PLAN;
107
108 FUNCTION internal_det_chain_VARCHAR(
109 plan IN TFM_PLAN)
110 RETURN VARCHAR2;
111
112 FUNCTION internal_det_chain(
113 transient_rule_set IN SDO_TRANSIENT_RULE_SET,
114 use_case IN VARCHAR2,
115 source_srid IN NUMBER,
116 target_srid IN NUMBER,
117 explain IN BOOLEAN,
118 explanation OUT VARCHAR2)
119 RETURN TFM_PLAN;
120
121 FUNCTION internal_det_srid_wkt(
122 srid1 NUMBER)
123 RETURN VARCHAR2;
124
125 FUNCTION internal_epsg_param_to_legacy(
126 param_id NUMBER,
127 method_id NUMBER)
128 RETURN VARCHAR2;
129
130 FUNCTION map_oracle_srid_to_epsg(
131 legacy_srid NUMBER)
132 RETURN NUMBER;
133
134 FUNCTION map_epsg_srid_to_oracle(
135 epsg_srid NUMBER)
136 RETURN NUMBER;
137
138 PROCEDURE create_pref_concatenated_op(
139 op_id IN NUMBER,
140 op_name IN VARCHAR2,
141 use_plan IN TFM_PLAN,
142 use_case IN VARCHAR2);
143
144 PROCEDURE create_concatenated_op(
145 op_id IN NUMBER,
146 op_name IN VARCHAR2,
147 use_plan IN TFM_PLAN);
148
149 PROCEDURE delete_op(
150 op_id IN NUMBER);
151
152 PROCEDURE add_preference_for_op(
153 op_id IN NUMBER,
154 source_crs IN NUMBER DEFAULT NULL,
155 target_crs IN NUMBER DEFAULT NULL,
156 use_case IN VARCHAR2 DEFAULT NULL);
157
158 PROCEDURE revoke_preference_for_op(
159 op_id IN NUMBER,
160 source_crs IN NUMBER DEFAULT NULL,
161 target_crs IN NUMBER DEFAULT NULL,
162 use_case IN VARCHAR2 DEFAULT NULL);
163
164 PROCEDURE create_obvious_epsg_rules(
165 use_case IN VARCHAR2 DEFAULT NULL);
166
167 PROCEDURE delete_all_epsg_rules(
168 use_case IN VARCHAR2 DEFAULT NULL);
169
170 FUNCTION transform_to_base_unit(
171 value IN NUMBER,
172 source_unit_id IN NUMBER)
173 RETURN NUMBER;
174
175 FUNCTION transform_to_wkt_param_unit(
176 value IN NUMBER,
177 source_unit_id IN NUMBER,
178 target_unit_id_if_length IN NUMBER)
179 RETURN NUMBER;
180
181 PROCEDURE create_crs_using_legacy_proj(
182 epsg_srid IN NUMBER,
183 new_srid IN NUMBER);
184
185 ------------------------------------------------------------------------------
186
187 PROCEDURE internal_get_densification_res(
188 crs_srid IN NUMBER,
189 minimum IN NUMBER,
190 maximum IN NUMBER,
191 resolution OUT NUMBER,
192 num_steps OUT NUMBER);
193 PRAGMA restrict_references(internal_get_densification_res, wnds, rnps, wnps);
194
195 FUNCTION internal_densify_prior_to_tfm(
196 mbr SDO_GEOMETRY)
197 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
198 PRAGMA restrict_references(internal_densify_prior_to_tfm, wnds, rnps, wnps);
199
200 ------------------------------------------------------------------------------
201
202 FUNCTION transform(
203 geom IN MDSYS.SDO_GEOMETRY,
204 dim IN MDSYS.SDO_DIM_ARRAY,
205 to_srid IN NUMBER)
206 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
207 PRAGMA restrict_references(transform, wnds, rnps, wnps);
208
209 FUNCTION transform(
210 geom IN MDSYS.SDO_GEOMETRY,
211 tolerance IN NUMBER,
212 to_srid IN NUMBER)
213 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
214 PRAGMA restrict_references(transform, wnds, rnps, wnps);
215
216 FUNCTION transform(
217 geom IN MDSYS.SDO_GEOMETRY,
218 to_srid IN NUMBER)
219 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
220 PRAGMA restrict_references(transform, wnds, rnps, wnps);
221
222 FUNCTION transform_with_arcs(
223 geom IN MDSYS.SDO_GEOMETRY,
224 to_srid IN NUMBER)
225 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
226 PRAGMA restrict_references(transform_with_arcs, wnds, rnps, wnps);
227
228 FUNCTION transform_using_plan(
229 geom IN MDSYS.SDO_GEOMETRY,
230 use_plan IN TFM_PLAN)
231 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
232
233 FUNCTION transform(
234 geom IN MDSYS.SDO_GEOMETRY,
235 use_plan IN TFM_PLAN)
236 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
237
238 FUNCTION transform_orig_using_rules(
239 geom IN mdsys.sdo_geometry,
240 dim IN mdsys.sdo_dim_array,
241 use_case IN VARCHAR2,
242 tfmChain IN VARCHAR2,
243 to_srid IN NUMBER)
244 RETURN mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
245 PRAGMA restrict_references(transform_orig_using_rules, wnds, rnps, wnps);
246
247 FUNCTION transform_orig_using_rules(
248 geom IN MDSYS.SDO_GEOMETRY,
249 use_case IN VARCHAR2,
250 tfmChain IN VARCHAR2,
251 to_srid IN NUMBER)
252 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
253 PRAGMA restrict_references(transform_orig_using_rules, wnds, rnps, wnps);
254
255 FUNCTION transform_using_case_name(
256 geom IN MDSYS.SDO_GEOMETRY,
257 use_case IN VARCHAR2,
258 to_srid IN NUMBER)
259 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
260 PRAGMA restrict_references(transform_using_case_name, wnds, rnps, wnps);
261
262 FUNCTION transform(
263 geom IN MDSYS.SDO_GEOMETRY,
264 use_case IN VARCHAR2,
265 to_srid IN NUMBER)
266 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
267 PRAGMA restrict_references(transform, wnds, rnps, wnps);
268
269 FUNCTION transform(
270 geom IN MDSYS.SDO_GEOMETRY,
271 dim IN MDSYS.SDO_DIM_ARRAY,
272 to_srname IN VARCHAR2)
273 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
274 -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
275
276 FUNCTION transform(
277 geom IN MDSYS.SDO_GEOMETRY,
278 tolerance IN NUMBER,
279 to_srname IN VARCHAR2)
280 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
281 -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
282
283 FUNCTION transform(
284 geom IN MDSYS.SDO_GEOMETRY,
285 to_srname IN VARCHAR2)
286 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
287 -- PRAGMA restrict_references(transform, wnds, rnps, wnps);
288
289 ------------------------------------------------------------------------------
290
291 PROCEDURE convert_NADCON_to_XML(
292 LAA_CLOB IN CLOB,
293 LOA_CLOB IN CLOB,
294 xml_grid OUT XMLTYPE);
295
296 PROCEDURE convert_NTv2_to_XML(
297 NTv2_CLOB IN CLOB,
298 xml_grid OUT XMLTYPE);
299
300 PROCEDURE convert_XML_to_NADCON(
301 xml_grid IN XMLTYPE,
302 LAA_CLOB OUT CLOB,
303 LOA_CLOB OUT CLOB);
304
305 PROCEDURE convert_XML_to_NTv2(
306 xml_grid IN XMLTYPE,
307 NTv2_CLOB OUT CLOB);
308
309 PROCEDURE convert_XML_table_to_NTv2(
310 ntv2_file_id IN NUMBER,
311 NTv2_CLOB OUT CLOB);
312
313 PROCEDURE convert_NTv2_to_XML_table(
314 NTv2_CLOB IN CLOB,
315 ntv2_file_id OUT NUMBER);
316
317 PROCEDURE delete_NTv2_xml_data(
318 ntv2_file_id in number);
319
320 function determine_nadcon_coverage(
321 coord_op_id number)
322 return sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
323
324 FUNCTION find_geog_crs(
325 reference_srid IN NUMBER,
326 is_legacy IN VARCHAR2,
327 max_rel_num_difference IN NUMBER DEFAULT 0.000001)
328 RETURN SDO_SRID_LIST;
329
330 FUNCTION find_geog_crs(
331 reference_wkt IN VARCHAR2,
332 is_legacy IN VARCHAR2,
333 max_rel_num_difference IN NUMBER DEFAULT 0.000001)
334 RETURN SDO_SRID_LIST;
335
336 FUNCTION find_proj_crs(
337 reference_srid IN NUMBER,
338 is_legacy IN VARCHAR2,
339 max_rel_num_difference IN NUMBER DEFAULT 0.000001)
340 RETURN SDO_SRID_LIST;
341
342 FUNCTION find_proj_crs(
343 reference_wkt IN VARCHAR2,
344 is_legacy IN VARCHAR2,
345 max_rel_num_difference IN NUMBER DEFAULT 0.000001)
346 RETURN SDO_SRID_LIST;
347
348 FUNCTION get_epsg_data_version
349 RETURN VARCHAR2;
350
351 ------------------------------------------------------------------------------
352
353 FUNCTION from_OGC_SimpleFeature_SRS(
354 wkt VARCHAR2)
355 RETURN VARCHAR2;
356
357 FUNCTION to_OGC_SimpleFeature_SRS(
358 wkt VARCHAR2)
359 RETURN VARCHAR2;
360
361 ------------------------------------------------------------------------------
362
363 PROCEDURE intl_populate_datum_3params(
364 datum_id NUMBER,
365 op_id NUMBER);
366
367 PROCEDURE intl_populate_datum_7params(
368 datum_id NUMBER,
369 op_id NUMBER);
370
374 geom SDO_GEOMETRY,
371 ------------------------------------------------------------------------------
372
373 FUNCTION to_USNG(
375 accuracyInMeters NUMBER,
376 datum VARCHAR2 DEFAULT 'NAD83')
377 RETURN
378 VARCHAR2;
379
380 FUNCTION from_USNG(
381 usng VARCHAR2,
382 srid NUMBER,
383 datum VARCHAR2 DEFAULT 'NAD83')
384 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
385
386 ------------------------------------------------------------------------------
387
388 PROCEDURE update_wkts_for_all_epsg_crs;
389
390 PROCEDURE update_wkts_for_epsg_crs(
391 srid NUMBER);
392
393 PROCEDURE update_wkts_for_epsg_param(
394 coord_op_id NUMBER,
395 parameter_id NUMBER);
396
397 PROCEDURE update_wkts_for_epsg_op(
398 coord_op_id NUMBER);
399
400 PROCEDURE update_wkts_for_epsg_datum(
401 datum_id NUMBER);
402
403 PROCEDURE update_wkts_for_epsg_ellips(
404 ellipsoid_id NUMBER);
405
406 PROCEDURE update_wkts_for_epsg_pm(
407 prime_meridian_id NUMBER);
408
409 function disambiguate_proj_name(
410 srid number,
411 wkt varchar2)
412 return varchar2;
413
414 function disambiguate_proj_name(
415 srid number)
416 return varchar2;
417
418 ------------------------------------------------------------------------------
419
420 function is_within_tolerance(
421 a number,
422 b number,
423 rel_tolerance number)
424 return number;
425
426 FUNCTION lookup_epsg_param(
427 coord_op_id number,
428 parameter_id number)
429 return number;
430
431 PROCEDURE find_srid(
432 srid OUT NUMBER,
433 epsg_srid_geog IN NUMBER DEFAULT NULL,
434 epsg_srid_proj IN NUMBER DEFAULT NULL,
435 datum_id IN NUMBER DEFAULT NULL,
436 ellips_id IN NUMBER DEFAULT NULL,
437 pm_id IN NUMBER DEFAULT NULL,
438 proj_method_id IN NUMBER DEFAULT NULL,
439 coord_ref_sys_kind IN VARCHAR2 DEFAULT NULL,
440 semi_major_axis IN NUMBER DEFAULT NULL,
441 semi_minor_axis IN NUMBER DEFAULT NULL,
442 inv_flattening IN NUMBER DEFAULT NULL,
443 params IN MDSYS.epsg_params DEFAULT NULL);
444
445 PROCEDURE find_srid(
446 srid OUT NUMBER,
447 epsg_srid_geog IN NUMBER DEFAULT NULL,
448 epsg_srid_proj IN NUMBER DEFAULT NULL,
449 datum_id IN NUMBER DEFAULT NULL,
450 ellips_id IN NUMBER DEFAULT NULL,
451 pm_id IN NUMBER DEFAULT NULL,
452 proj_method_id IN NUMBER DEFAULT NULL,
453 proj_op_id IN NUMBER DEFAULT NULL,
454 coord_ref_sys_kind IN VARCHAR2 DEFAULT NULL,
455 semi_major_axis IN NUMBER DEFAULT NULL,
456 semi_minor_axis IN NUMBER DEFAULT NULL,
457 inv_flattening IN NUMBER DEFAULT NULL,
458 params IN MDSYS.epsg_params DEFAULT NULL,
459 max_rel_num_difference IN NUMBER DEFAULT 0.000001);
460
461 function fill_in_default_units(
462 params mdsys.epsg_params,
463 crs number)
464 return mdsys.epsg_params;
465
466 PROCEDURE sdo_cs_context_invalidate;
467
468 PROCEDURE find_epsg_params(
469 srid IN NUMBER,
470 epsg_srid_geog OUT NUMBER,
471 datum_id OUT NUMBER,
472 ellips_id OUT NUMBER,
473 pm_id OUT NUMBER,
474 proj_method_id OUT NUMBER,
475 proj_op_id OUT NUMBER,
476 coord_ref_sys_kind OUT VARCHAR2,
477 semi_major_axis OUT NUMBER,
478 semi_minor_axis OUT NUMBER,
479 inv_flattening OUT NUMBER,
480 params OUT MDSYS.epsg_params);
481
482 function make_3d(
483 geom2d in mdsys.sdo_geometry,
484 height in number default 0,
485 target_srid in number default null)
486 return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
487
488 function make_2d(
489 geom3d in mdsys.sdo_geometry,
490 target_srid in number default null)
491 return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
492
493 function convert_2d_to_3d(
494 geom2d mdsys.sdo_geometry,
495 height number default 0,
496 vert_id number default 9903,
497 ellipsoidal varchar2 default 'TRUE',
498 uom_id number default 9001)
499 return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
500
501 function convert_3d_srid_to_2d(
502 srid3d number)
503 return number DETERMINISTIC PARALLEL_ENABLE;
504
505 function convert_2d_srid_to_3d(
506 srid2d number,
507 vert_id number default 9903,
508 ellipsoidal varchar2 default 'TRUE',
509 uom_id number default 9001)
510 return number;
511
512 ------------------------------------------------
513
514 FUNCTION transform_across_dims(
518 PRAGMA restrict_references(transform_across_dims, wnds, rnps, wnps);
515 geom IN MDSYS.SDO_GEOMETRY,
516 to_srid IN NUMBER)
517 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
519
520 FUNCTION transform_across_dims_wa(
521 geom IN MDSYS.SDO_GEOMETRY,
522 to_srid IN NUMBER)
523 RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
524 PRAGMA restrict_references(transform_across_dims_wa, wnds, rnps, wnps);
525
526 PROCEDURE transform_layer_across_dims(
527 table_in IN VARCHAR2,
528 column_in IN VARCHAR2,
529 table_out IN VARCHAR2,
530 to_srid IN NUMBER);
531
532 PROCEDURE transform_layer_across_dims(
533 table_in IN VARCHAR2,
534 column_in IN VARCHAR2,
535 table_out IN VARCHAR2,
536 use_plan IN TFM_PLAN);
537
538 PROCEDURE transform_layer_across_dims(
539 table_in IN VARCHAR2,
540 column_in IN VARCHAR2,
541 table_out IN VARCHAR2,
542 use_case IN VARCHAR2,
543 to_srid IN NUMBER);
544
545 ------------------------------------------------
546
547 function reformat_gtype(
548 geom1 mdsys.sdo_geometry,
549 srid2 number)
550 return mdsys.sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
551
552 PROCEDURE register_SrsNameSpace ( SrsNameSpace IN varchar2,
553 SrsName IN varchar2, sdo_srid in number);
554 FUNCTION get_SRID_for_NameSpace( SrsNameSpace IN varchar2,
555 SrsName IN varchar2) return NUMBER;
556 FUNCTION get_SrsName_for_NameSpace( SrsNameSpace IN varchar2,
557 sdo_srid IN number) return varchar2;
558
559 function convert_mixed_axes_units(
560 srid number,
561 unitless_value number,
562 output_unit varchar2)
563 return number;
564
565 function get_3d_wkt(
566 srid number)
567 return varchar2;
568
569 function generate_crs_from_wkt(
570 wkt varchar2, -- Input WKT
571 proj_op_id number, -- ID of new proj operation, if required
572 proj_op_name varchar2, -- Name of new proj operation, if required
573 datum_tfm_op_id number, -- ID of new datum tfm operation, if required
574 datum_tfm_op_name varchar2, -- Name of new datum tfm operation, if required
575 exclude_existing_elems varchar2 default 'FALSE') -- Exclude elements that already exist in mdsys
576 return CLOB;
577
578 function generate_epsg_rule_for_3785(
579 source_srid number,
580 datum_tfm_op_id number,
581 concat_op_id number)
582 return CLOB;
583
584 function get_wkt_path(
585 wkt varchar2,
586 path varchar2,
587 default_value varchar2 default null)
588 return varchar2;
589 PRAGMA restrict_references(get_wkt_path, wnds, rnps, wnps);
590
591 function tfm_axis_orientation_to_wkt(
592 axis_orientation VARCHAR2)
593 return VARCHAR2;
594
595 procedure update_wkt_with_7_params(
596 params varchar2,
597 datum_name varchar2);
598
599 procedure update_wkts_with_hc_params;
600
601 procedure determine_srid_units(
602 srid in number,
603 uom_id1 out number,
604 uom_id2 out number,
605 uom_id3 out number);
606
607 function transform_ogc_cs_wkt_to_srs(
608 wktext varchar2)
609 return varchar2;
610
611 --------------------------------------------------------
612
613 function generate_script_from_uom_id(
614 uom_id number,
615 offset number default 0)
616 return clob;
617
618 function generate_script_from_cs_id(
619 cs_id number,
620 offset number default 0)
621 return clob;
622
623 function generate_script_from_op_id(
624 op_id number,
625 offset number default 0)
626 return clob;
627
628 function generate_script_from_pm_id(
629 pm_id number,
630 offset number default 0)
631 return clob;
632
633 function generate_script_from_ellips_id(
634 ellipsoid_id number,
635 offset number default 0)
636 return clob;
637
638 function generate_script_from_datum_id(
639 datum_id number,
640 offset number default 0)
641 return clob;
642
643 function generate_script_from_SRID(
644 srid number,
645 offset number default 0,
646 include_units number default 1)
647 return clob;
648
649 function validate_op(
650 op_id number)
651 return varchar2;
652
653 FUNCTION dms_to_decimal_degree(
654 lat_deg VARCHAR2,
655 lat_min VARCHAR2,
656 lat_sec VARCHAR2,
657 lat_dir CHAR,
658 lon_deg VARCHAR2,
659 lon_min VARCHAR2,
660 lon_sec VARCHAR2,
661 lon_dir CHAR,
662 srid NUMBER default 8307)
663 RETURN sdo_geometry DETERMINISTIC PARALLEL_ENABLE;
664
665 procedure decimal_degrees_to_dms(
666 dec_deg in number,
667 coord_deg out integer,
668 coord_min out integer,
672
669 coord_sec out number,
670 coord_dir out char)
671 DETERMINISTIC PARALLEL_ENABLE;
673 procedure decimal_degrees_to_dms(
674 lat in number,
675 lon in number,
676 lat_deg out integer,
677 lat_min out integer,
678 lat_sec out number,
679 lat_dir out char,
680 lon_deg out integer,
681 lon_min out integer,
682 lon_sec out number,
683 lon_dir out char)
684 DETERMINISTIC PARALLEL_ENABLE;
685
686 procedure load_epsg_matrix(
687 op_id number,
688 parameter_id number,
689 directory varchar2,
690 file_name varchar2)
691 DETERMINISTIC PARALLEL_ENABLE;
692
693 function validate_epsg_matrix(
694 method_id number,
695 parameter_id number,
696 matrix clob)
697 return varchar2
698 DETERMINISTIC PARALLEL_ENABLE;
699
700 function get_axis_order(
701 srid number)
702 return varchar2 DETERMINISTIC;
703
704 function reverse_axis_order(
705 srid number)
706 return number DETERMINISTIC;
707
708 END sdo_cs;