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?"}]}]