Procedure to return route calculation between coordinates via the Googlemaps API

Asked

Viewed 77 times

0

I need to create all the business rules of a system within the database and allow other applications for the purpose of being only a graphical user interface to freely utilize all the functions available in the database through stored procedures.

Among them, I need to create a protocol that given start coordinates and destination coordinates, it accesses GOOGLEMAPS and RETURN the distance EN ROUTE (not in a straight line).

It is possible?

  • First of all, what a bunch of data are you using?

  • 1 pair of varchar for the SOURCE coordinate and 1 pair of varchar for the DESTINATION coordinate, and applications accessing this precedent will receive a VARCHAR value as well... I don’t have any code written because I don’t know if it is possible for SQL SERVER to access a URL through a SP...

  • First of all, what a bunch of data are you using?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.