• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 679
  • Last Modified:

VBscript Lat Long

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?
1 Solution
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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

webdorkAuthor Commented:
Thanks for the Pathfinder tip
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now