Maping latitude and Longitude

Posted on 2011-10-17
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

    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    In this article I will describe the Copy Database Wizard 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.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now