Slide 20
Slide 20 text
20 Copyright © 2023, Oracle and/or its affiliates
Oracle Spatial Features for Geocoding Address Data and Reverse
Geocoding Location Data
ジオコーディングと逆ジオコーディングのためのOracle Spatial機能
Oracle Spatialのジオコーディング（住所→緯度/経度)、逆ジオコーディング(緯度/経度データ→住所）機能のファンク
ションを利用することができるようになりました。Autonomous Databaseではホストされたジオコーディング・サービスを利用
するため、参照データのロードは不要です。※ジオコーディングは中国、日本、韓国に対応していません
2023/4
Documentation: 16 Using Oracle Spatial with Autonomous Database
blog: Now available: Geocoding API in Oracle Autonomous Database (Shared)
--住所→緯度/経度の例
SQL> select sdo_gcdr.eloc_geocode('123 Beacon St,Boston MA,02116,US') from dual;
SDO_GCDR.ELOC_GEOCODE('123BEACONST,BOSTONMA,02116,US')
--------------------------------------------------------------------------------
[{"id":"0","matchCount":"1","matches":[{"sequence":"0","x":-
71.07355166666666,"y":42.355174166666664,"houseNumber":"123","street":"Beacon St","settlement":"Bost
on","municipality":"Suffolk","region":"MA","postalCode":"02116","country":"US","language":"ENG","name
":"","edgeId":946710796,"percent":0.08333333333333333,"side":"R","matchCode":1,"matchVector":"???1010
1010??000?"}]}]
--緯度/経度→住所の例
SQL> select sdo_gcdr.eloc_geocode(-71.073551,42.355174) from dual;
SDO_GCDR.ELOC_GEOCODE(-71.073551,42.355174)
-------------------------------------------------------------------------------
[{"id":"0","matchCount":"1","matches":[{"sequence":"0","x":-
71.07355109772594,"y":42.35517433341787,"houseNumber":"123","street":"Beacon St","settlement":"Bosto
n","municipality":"Suffolk","region":"MA","postalCode":"02116","country":"US","language":"ENG","name"
:"","edgeId":946710796,"percent":0.08431426223078922,"side":"R","matchCode":1,"matchVector":"???14141
414??404?"}]}]