Learn how to a build a cloud-first strategyRegister Now


Maping latitude and Longitude

Posted on 2011-10-17
Medium Priority
Last Modified: 2012-08-13
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).
Question by:SeTech
1 Comment
LVL 22

Accepted Solution

8080_Diver earned 2000 total points
ID: 36981901
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. ;-)

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

810 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