Bing Maps Beta - How do I create an HTTP link to bring up the address on a Bing Map?

Question

I am trying to create a button in Intuit's Quickbase that creates a URL link to a Bing Map address based upon the Address field in the table.

I am using a formula field to place the address into the correct Bing format for creating the map address, but can't get it to work correctly.  I just need a simple formula created that puts the address fields in the correct place for Bing to recognize the city/state/zip.  Any help would be appreciated.

I have successfully implemented this with Google Maps using the following formula:

"http://maps.google.com/maps?q=" & URLEncode([Asset Address]& " " & [Zip]) & "&rls=com.microsoft:*&oe=UTF-8&startIndex=&startPage=1%3B&rlz=1I7GGLL_en&um=1&ie=UTF-8&sa=N&hl=en&tab=wl"

Answer 1

You need to pass the address in using the where1 parameter in the URL string, like this:

http://www.bing.com/maps/?v=2&where1=10 downing street, london

---

Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290

Answer 2

Thank you for your quick and accurate response.  That worked very well. 

Do you know if there are any additional parameters that I can use (maybe a list somewhere) to provide greater customization of the URL string?

Your help is greatly appreciated!

Tony

Answer 3

You can change the style of the map by passing the sty parameter. a = aerial, r = road, h = hybrid, b = birdseye, c = London street map, s = OS Map

So, try:
http://www.bing.com/maps/?v=2&where1=10 downing street, london&sty=b

---

Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290

Answer 4

That worked perfectly!  Thank you!  Do you know of a link I can go to that has this information for future reference?

Thanks Again!

Answer 5

http://help.live.com/Help.aspx?market=en-US&project=WL_Local&querytype=topic&query=WL_LOCAL_PROC_BuildURL.htm

Answer 6

Thank you Jonathan!

Answer 7

Hi:

Do you know if it is possible to show multiple pushpins from a URL like this? So something like:

http://www.bing.com/maps/?v=2&where1=10 downing street, london&where2=12 downing street, london

?

Answer 8

No, you can only specify a single pushpin in the URL on which the map is centred.
 
You can plot multiple pushpins that using an embedded static map in an iframe though. See here for an example:
http://social.msdn.microsoft.com/Forums/en-US/vemapcontroldev/thread/2c841380-1d0d-4804-bf75-654f4b742f43

---

Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290

Answer 9

You can change the style of the map by passing the sty parameter. a = aerial, r = road, h = hybrid, b = birdseye, c = London street map, s = OS Map

So, try:
http://www.bing.com/maps/?v=2&where1=10 downing street, london&sty=b

---

Beginning Spatial with SQL Serverhttp://www.apress.com/book/view/1430218290

Finally got it, I've got the same problem.Thanks!