[AccessD] Google maps

[John Colby]

Folks, I have written an Access app which allows me to enter business
addresses into a location table, then select one or many locations into a
list control, move the locations up and down until I have a route I like,
then map it using google maps.  Currently I use edge to open the map.  The
following is an 11 stop trip.

microsoft-edge:https://www.google.com/maps/dir/1904 Morganton Blvd, Lenoir
NC 28645/1311 East Main Street, Chattanooga TN 37404/439 Allied Drive,
Nashville TN 37211/561 Metroplex Drive, Nashville TN 37211/7720 Highway
222, Stanton TN 38069/1605 East 5th Street, Little Rock AR 72114/1645
Industrial Place, Fayetteville AR 72701/513 South Trenton Avenue, Tulsa OK
74120/6900 North Bryant Avenue, Oklahoma City OK 73121/3720 WestRobinson
Street, Norman OK 73072/1093 Trend Drive, Carrollton TX 75006/1850 Diplomat
Drive, Farmers Branch TX 25234/1101 West 70th Street, Shreveport LA
71104/1904 Morganton Blvd, Lenoir NC 28645

Assuming that the addresses are real, Edge opens, loads google maps and
maps the route.  The resulting url is all of the above plus stuff like this:

+USA/@33.7833331,-100.138283,5z/data=!3m1!4b1!4m85!4m84!1m5!1m1!1s0x8850df210764f599:0x1890534ac0d476fe!2m2!1d-81.5563861!2d35.8980049!1m5!1m1!1s0x88605de42289d723:0x334525ec2d71c973!2m2!1d-85.2870449!2d35.029023!1m5!1m1!1s0x88646f7df48bd7b9:0xf3817765e325957a!2m2!1d-86.7413824!2d36.0952999!1m5!1m1!1s0x88646f03c20fef25:0x78b24be6800aa42f!2m2!1d-86.7050854!2d36.0940434!1m5!1m1!1s0x887f1d1e5c3261c7:0x3fff8bfaf5691f4f!2m2!1d-89.4107763!2d35.3900544!1m5!1m1!1s0x87d2bc714d58da8f:0xa184eeea32b88249!2m2!1d-92.2488223!2d34.7590136!1m5!1m1!1s0x87c968c5e5bcaddb:0xb381eb628fbc09fe!2m2!1d-94.140341!2d36.0457588!1m5!1m1!1s0x87b6ec893f661f03:0x60f00634a8eae4ab!2m2!1d-95.968677!2d36.1536158!1m5!1m1!1s0x87b21868883e7edf:0x84a3b0f9df88cca4!2m2!1d-97.4568984!2d35.5421001!1m5!1m1!1s0x87b2696e92fdb379:0x20bdf4982e39ac83!2m2!1d-97.4959264!2d35.2306545!1m5!1m1!1s0x864c26eb90bf0147:0x8fc2eac09ce514e8!2m2!1d-96.8615869!2d32.9549524!1m5!1m1!1s0x864c27d66d3052bf:0x1eafcd1696323129!2m2!1d-96.919033!2d32.926122!1m5!1m1!1s0x8636d2fbfed6663b:0xd39d56cd5c33187a!2m2!1d-93.7788302!2d32.4414515!1m5!1m1!1s0x8850df210764f599:0x1890534ac0d476fe!2m2!1d-81.5563861!2d35.8980049?entry=ttu

So...
1) does anyone have a source to use to interpret that part of the url?
2) does anyone know how to generate that entire thing, start to fdinish,
without dumping the address part into google maps and letting the browser
based app "interpret" it?
3) Does anyone know how to get this stuff back out of google maps into
Access?

My desire is to build out my app such that an employee of the company can
create the address string of many stops, then generate that google string,
and then message that google map url out to a phone such that a driver has
a google map of the rout to follow without the driver having to go through
all of that work.  Drivers don't have the tools to do this easily, although
if you want to do so you can enter the addresses into the (android) google
map app and get the same thing.

I am pretty far down the line making this work, but getting that finished
url out of the browser based google map app is the show stopper for me.

BTW I have found mutterings that say I can then run the google map stuff
through something and feed it to an app for garmin that uploads it into a
garmin device. Garmine knows "truck safe" routes with bridge heights and
weights and such.
-- 
John W. Colby
Colby Consulting