Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Api call to Census to get Latitude and Longitude

new learnerJan 6 2016 — edited Jan 6 2016

Hello ,

  i have the Following Address in a table for which i have to make a api call to census(Welcome to Geocoder) to get the latitude and longitude.

  can some one please direct me/explain how to achieve this

Examples

ID    ADDRESS(House_no ||' '|| Street_name ||','|| City ||','|| State ||','|| postal_code)

1    218 DIVISION,KING CITY,CA,93930

2    1475 TERRI LYNN,GILROY,CA,95020

3    3724 TERNEUZEN,MODESTO,CA,95356

4    930 THE ALAMEDA,BERKELEY,CA,94707

5    11260 TERRACERIDGE,MOORPARK,CA,93021

6    196 TERRY,WATSONVILLE,CA,95076

7    3243 TERZILLA,LOS ANGELES,CA,90065

8    679 TERRA,CORONA,CA,92879

9    863 TERRACE,DIAMOND BAR,CA,91765

10   2814 TERRACE PINE,SAN DIEGO,CA,92173

thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2016
Added on Jan 6 2016
4 comments
923 views