1 package SDO_GCDR AUTHID current_user as
2 procedure validateCountryRow( country VARCHAR2,
3 keys SDO_keywordArray);
4
5 -- used by country profile validation trigger, should not be documented
6 procedure validateInLineStreetTypeRow( country VARCHAR2,
7 pos VARCHAR2,
8 sep VARCHAR2,
9 out VARCHAR2,
10 keys SDO_keywordArray);
11
12 -- used by country profile validation trigger, should not be documented
13 procedure validateStreetTypeRow( country VARCHAR2,
14 pos VARCHAR2,
15 sep VARCHAR2,
16 out VARCHAR2,
17 keys SDO_keywordArray);
18
19 -- used by country profile validation trigger, should not be documented
20 procedure validateSecondUnitRow( country VARCHAR2,
21 pos VARCHAR2,
22 out VARCHAR2,
23 keys SDO_keywordArray);
24
25 -- used by country profile validation trigger, should not be documented
26 procedure validateStreetPrefixRow( country VARCHAR2,
27 out VARCHAR2,
28 keys SDO_keywordArray);
29
30 -- used by country profile validation trigger, should not be documented
31 procedure validateStreetSuffixRow( country VARCHAR2,
32 out VARCHAR2,
33 keys SDO_keywordArray);
34
35 -- used by country profile validation trigger, should not be documented
36 procedure validateRegionRow( country VARCHAR2,
37 out VARCHAR2,
38 keys SDO_keywordArray);
39
40 -- used by country profile validation trigger, should not be documented
41 procedure validateCityRow( country VARCHAR2,
42 out VARCHAR2,
43 keys SDO_keywordArray);
44
45 -- used by country profile validation trigger, should not be documented
46 procedure validateLocalityDictRow( country VARCHAR2,
47 out VARCHAR2,
48 keys SDO_keywordArray);
49
50 -- used by country profile validation trigger, should not be documented
51 procedure validateStreetDictRow( country VARCHAR2,
52 out VARCHAR2,
53 keys SDO_keywordArray);
54
55 -- used by country profile validation trigger, should not be documented
56 procedure validatePoBoxRow( country VARCHAR2,
57 out VARCHAR2,
58 keys SDO_keywordArray);
59
60 -- used by country profile validation trigger, should not be documented
61 procedure validatePlaceNameRow( country VARCHAR2,
62 out VARCHAR2);
63
64 -- create parser profile tables
65 procedure create_profile_tables ;
66
67 -- used by java geocoder client, should not be documented
68 function batch_geocode(address_list in varchar2, gc_username in varchar2, max_result_count number)
69 return sdo_keywordarray deterministic PARALLEL_ENABLE;
70
71 -- geocode an input address specified by address lines and return
72 -- the first matched address as a SDO_GEO_ADDR object
73 function geocode(
74 username varchar2,
75 addr_lines SDO_keywordArray,
76 country VARCHAR2,
77 match_mode VARCHAR2,
78 logging number default 0) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
79
80 -- geocode an input address specified by address lines and return
81 -- the the coordinates of the first matched address as sdo_geometry
82 function geocode_as_geometry(
83 username varchar2,
84 addr_lines SDO_keywordArray,
85 country VARCHAR2)
86 RETURN SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
87
88 -- geocode an input address specified by a SDO_GEO_ADDR object and return
89 -- the first matched address as a SDO_GEO_ADDR object
90 function geocode_addr(
91 gc_username varchar2,
92 address SDO_GEO_ADDR,
93 logging number default 0) return SDO_geo_Addr deterministic PARALLEL_ENABLE;
94
95 -- geocode an input address specified by a address lines and return all
96 -- matched addresses as a VARRAY of SDO_GEO_ADDR objects
97 function geocode_all(
98 gc_username varchar2,
99 addr_lines SDO_keywordArray,
100 country VARCHAR2,
101 match_mode varchar2,
102 max_res_num number default 4000) return SDO_ADDR_ARRAY deterministic PARALLEL_ENABLE;
103
104 -- geocode an input address specified by a SDO_GEO_ADDR object and return all
105 -- matched addresses as a VARRAY of SDO_GEO_ADDR objects
106 function geocode_addr_all(
107 gc_username varchar2,
108 address SDO_GEO_ADDR,
109 max_res_num number default 4000) return SDO_ADDR_ARRAY deterministic PARALLEL_ENABLE;
110
111 -- reverse-geocode a location specified by longitude and latitude into
112 -- address as a sdo_geo_addr object
113 function reverse_geocode(
114 username varchar2,
115 longitude number,
116 latitude number,
117 country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
118
119 -- reverse-geocode a location specified by longitude, latitude and srid into
120 -- address as a sdo_geo_addr object
121 function reverse_geocode(
122 username varchar2,
123 longitude number,
124 latitude number,
125 srid number DEFAULT -1,
126 country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
127
128 -- reverse-geocode a location specified by longitude and latitude into
129 -- address as a sdo_geo_addr object
130 function reverse_geocode(
131 username varchar2,
132 location sdo_geometry,
133 country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
134
135 -- reverse-geocode a location specified by longitude, latitude, into
136 -- address as a sdo_geo_addr object; address returned in lang
137 function reverse_geocode(
138 username varchar2,
139 longitude number,
140 latitude number,
141 language_ VARCHAR2,
142 country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
143
144 -- reverse-geocode a location specified by longitude, latitude, srid, into
145 -- address as a sdo_geo_addr object; address returned in lang
146 function reverse_geocode(
147 username varchar2,
148 longitude number,
149 latitude number,
150 srid number DEFAULT -1,
151 language_ VARCHAR2,
152 country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
153
154 -- reverse-geocode a location specified by geom into
155 -- address as a sdo_geo_addr object; address returned in lang
156 function reverse_geocode(
157 username varchar2,
158 location sdo_geometry,
159 language_ VARCHAR2,
160 country VARCHAR2) return SDO_GEO_Addr deterministic PARALLEL_ENABLE;
161
162 -- lists the countries available for geocoding. If more than one Geocoder is
163 -- installed, the UNION of countries available in each Geocoder is returned
164 FUNCTION list_countries RETURN SDO_STRING_ARRAY DETERMINISTIC PARALLEL_ENABLE;
165
166 -- lists the data version used for geocoding. If more than one Geocoder is
167 -- installed, all the gc_table_suffix-version combinations are listed
168 FUNCTION data_version RETURN SDO_STRING_ARRAY DETERMINISTIC PARALLEL_ENABLE;
169
170 end SDO_GCDR;