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

Maping latitude and Longitude

My unit is starting to utilize the Geography Data Type in SQL 2008. I was able to obtain the latitude and longitude coordinates for certan zip codes which in turn has allowed us to map out certain agent locations. And now this work has taken on a huge interest with my management. What I now need to do is obtain latitude and longitude coordinates for a specific address (as opposed to a zip code). For the zip codes I found a number of web sites that supply the data, my question is; Does anyone know how I can obtain latitude and longitude coordinates for a given address. I have a database loaded with address and needs the coordinates such that I can then calculate the GeoRef (Geography data type).
1 Solution
You might want to check out this link:
SSIS GeoCoding thru Google

I am trying to find some spare time to check out the etchnique myself. ;-)
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

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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