Geocoding - Know of any good Walkthroughs? RRS feed

  • Question

  • A few years ago I used this book "Beginning Spatial with SQL Server 2008" to geocode some of our customer addresses. My boss wants me to do some more work in this area, this time for Sales Reps and their territories, Dealers and their locations. Looking at this book again, and what Bing Maps is "now", I see it's gone from SOAP to REST.

    Can anyone get me started in the right direction? Are there any good walkthroughs on geocoding? I have data (Addresses) that I need to geocode in bulk.

    I was thinking I would 

    1) create an assembly for SQL that calls a geocoding webservice.

    2) write a CURSOR that will call the assembly and update each record with geocodes.

    Am I going in the right direction?

    Thank you,


    Wednesday, January 16, 2013 7:14 PM