Slide 22
Slide 22 text
23 Copyright © 2023, Oracle and/or its affiliates
ジオコーディングと逆ジオコーディングのための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?"}]}]