THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

Visually stunning maps and PivotViewer

One of the things about PivotViewer is that it runs in the Silverlight platform and can be extended recently. One of my guys at LobsterPot, Roger Noble, has used this to incorporate a Bing Maps layer, showing items which have  Latitude and Longitude values there. We’re already talking to a hospital about using this to allow them to browse their patient data, including showing the patients on a map according to which bed they’re in. Interesting times – this will involve having custom tiles instead of the ones from Bing Maps, but the idea is similar. Of course, we’ll be using Bing Maps to show where the patients live.

I should also mention that this is a work-in-progress still. Figuring out how to use PivotViewer isn’t trivial, and we’ve done quite a lot of experimenting to see how to get things working. If you find bugs, please feel free to let me know (rob_farley at hotmail will usually reach me), and we’ll add them to our list.

Here are some screenshots that I made recently using the collection at – by selecting a tag, you can get a new bunch of images.

A couple of images that were taken in Iceland.


Some from St Mary’s Lighthouse near Newcastle, UK.


And some from around Big Ben in London.


I’d recommend using either Firefox or Internet Explorer if you choose to browse this yourself. It seems the Chrome browser support for Silverlight doesn’t quite handle things as nicely as we’d all like.

I imagine that at some point, we may enhance the Flickr collection, to be able to search on more than tags, but as a sample collection, it seems to work quite well.

Published Tuesday, January 4, 2011 3:43 PM by Rob Farley
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Stacia Misner said:

It’s time for another T-SQL Tuesday, hosted this month by Jen McCown ( blog | twitter ), on the topic

January 11, 2011 1:15 PM

Rom said:

Hi, would it be possible to get a sample code of the way you implemented the map view on pivotViewer ? I'd love to try it on my application.

Many thanks,

May 26, 2011 3:09 PM

Rob Farley said:

Hi Rom,

Roger's planning a blog series on this kind of thing, so I'll probably leave it mostly up to him. It's quite involved, as I'm sure you can imagine. In the meantime, drop me a line and we can chat. You can find an email address for me in the right-hand panel of my blog.

May 26, 2011 9:23 PM

Sri said:


I need to implement the same kind of functionality in my current project.Can you please share the code (Map view).



February 14, 2013 12:59 AM

Rob Farley said:

Hi Sri,

Email me to discuss. rob at

February 14, 2013 1:06 AM

Leave a Comment


This Blog



News? Haven't you read my blog?

My Company

Can't find something?

Contact Me

Twitter: @rob_farley
Skype: rob_farley

MVP (SQL Server)


Adelaide SQL UG

Privacy Statement