THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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) and leader of the SQL User Group in Adelaide, Australia. Rob is also a Director of PASS, and runs 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 http://pivot.lobsterpot.com.au/flickr – by selecting a tag, you can get a new bunch of images.

A couple of images that were taken in Iceland.

pivot_iceland

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

pivot_tyneside

And some from around Big Ben in London.

pivot_bigben2

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 04, 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

Comments

 

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:

Hi

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

Thanks,

Sri

February 14, 2013 12:59 AM
 

Rob Farley said:

Hi Sri,

Email me to discuss. rob at LobsterPot.com.au

February 14, 2013 1:06 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement