MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




SQL2008 + VE + SpatialPoint = Superbowl Coverage Map

This is a discussion on SQL2008 + VE + SpatialPoint = Superbowl Coverage Map within the Virtual Earth Blogs forums, part of the Blogs category; Longtime MapPoint/Virtual Earth gurus SpatialPoint released a radio coverage application the other day to help you find a station in ...


Go Back   MapPoint Forums > Blogs > Virtual Earth Blogs

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  2 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 01-19-2008
Senior Member
Blue Belt
 
Join Date: Sep 2007
Posts: 161
SQL2008 + VE + SpatialPoint = Superbowl Coverage Map

Longtime MapPoint/Virtual Earth gurus SpatialPoint released a radio coverage application the other day to help you find a station in your area broadcasting the Superbowl making it easy to tune in to hear how the Giants do against the Pats wherever you live. I've seen a bunch of RF coverage applications using Virtual Earth technology in the past (National Public Radio has a really nice one) but what stands out here is SpatialPoint's use of SQL Server 2008. Using SQL makes it much easier to do things like query for all of the stations along a long route so that as you drive out of one coverage area you know what station to tune next. You could calculate this on your own given the route geometry, but asking SQL to do this is much easier and architecturally cleaner. Check out the cool tune-list generated by the application for a trip from Seattle to Chicago:

You can tune in station KJR-AM (950) broadcasting out of SEATTLE immediately. Coverage should last for about 40.11 miles. Depart on I-5 Express Ln (South) (2.26 mi)

1 Turn LEFT onto Ramp (0.18 mi)

2 Turn LEFT (North-East) onto Cherry St, then immediately turn RIGHT (South) onto 6th Ave (0.21 mi)

3 Keep LEFT onto Ramp (0.43 mi)

4 Keep LEFT to stay on Ramp (0.05 mi)

5 Take Ramp (LEFT) onto I-90 (479.24 mi)

You will lose station KJR-AM (950) broadcasting out of SEATTLE at about mile 40.11.

You can tune in station KWIQ-AM (1020) broadcasting out of MOSES LAKE NORTH at about mile 166.22. Coverage should last for about 27.90 miles.

You will lose station KWIQ-AM (1020) broadcasting out of MOSES LAKE NORTH at about mile 194.11.

. . .

Of course, displaying the RF coverage shapes in Virtual Earth from SQL server is a breeze:




Click here to view the full post.

Last edited by Eric Frost; 01-19-2008 at 07:12 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/sql2008-ve-spatialpoint-superbowl-coverage-map-7023.html

Posted By For Type Date
Latitude / Longitude DMS -> Decimal Converter - MP2K Magazine This thread Refback 01-24-2008 11:52 AM
The Magazine for MapPoint - MP2K Magazine This thread Refback 01-19-2008 02:12 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
SpatialPoint Technology Enhances Choice Hotels’ Sales Process Eric Frost Press Releases 0 06-19-2007 08:39 AM
SpatialPoint Survey for MapPoint Users Eric Frost News and Announcements 0 04-05-2007 10:46 PM
Coverage of 2006? jtowell MapPoint 2006/2009 Discussion 1 03-19-2006 09:02 AM
Reporting service coverage by zip code and radius jjmmbb MapPoint 2006/2009 Discussion 0 07-05-2004 05:13 PM
can anyone help me build gps for 911 coverage in africa Anonymous MapPoint 2006/2009 Discussion 4 05-24-2004 11:41 AM


All times are GMT -5. The time now is 11:02 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Cheap flights to Naples
The Neapolitan Riviera is the home of pizza and with cheap flights to Naples it can be the home of your holiday too. Book with Holiday Hypermarket.

Italy Holidays
Find and book Italy Holidays with Travel Counsellors. Holiday destinations around the world including Italy.

Thailand Holidays
Thailand Holidays can suit your budget when you book with dealchecker.co.uk. If you are strapped for cash, visit online to find the deal for you.

Holidays to Cancun
The Holiday Place has special offers on holidays to Cancun during the month of September. Book a late summer holiday with us!

Morocco
Gain insight on your holiday destination with the ULookUBook travel guides. Find out about Morocco and its customs online. Make an informed decision when you make a booking.

Bargain Holidays
To plan your holidays at bargain prices, use Travel.co.uk to explore all the possibilities.

Cheap Holidays to Fuerteventura
Don't do it the expensive way! Get information on cheap holidays to Fuerteventura at On The Beach, and enjoy the Canary Islands' best!


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51