GeoCode with Bing Using an SP/Function

  • Does anyone have or know of a SP/Function for using MS Bing to bulk geocode a table of addresses? I've seen the geocode script for Google, but Bing is different and I can't figure out the best way to do it. What I would like is a SP/Function that I can run as data is added to my database that inserts the lat/long as well as the corrected address and the confidence level. I have scripts that will do this on the front-end of a web application but my DB doesn't have a front-end and we ingest 100,000+ address per day. Thanks in advance.

  • So far as I know, MS Bing is not native to SQL Server, so does not have any procs designed for it. If there's an add-on or extended proc that you can create from scratch, I'm unaware of it.

    Perhaps you should check with TechNet on Microsoft's site. Or check codeplex. Someone may have come up with a CLR or a script.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply