Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


VBscript Lat Long

Posted on 2012-08-13
Medium Priority
Last Modified: 2012-08-14
I have a SQL Server data table with physical addresses. I need Latitude and Longitude inserted into the table. Is there a handy script to do this?
Question by:webdork
LVL 54

Accepted Solution

Scott Fell,  EE MVE earned 2000 total points
ID: 38290364
You are looking for geocoding.  https://developers.google.com/maps/documentation/geocoding/  There is a sample here where you can simply view the source to see what is done.  http://gmaps-samples.googlecode.com/svn/trunk/geocoder/singlegeocode.html/.

I think if you read through the terms of service, you are not allowed to save the lat/lon data to your database.   There are plenty of third party services as well and they will typically charge you per hit.   http://www.melissadata.com/geocoder/geocoding.html


Author Closing Comment

ID: 38292614
Thanks for the Pathfinder tip

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question