Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 1 of 1

SQL2008 + VE + SpatialPoint = Superbowl Coverage Map

This is a discussion on SQL2008 + VE + SpatialPoint = Superbowl Coverage Map within the Bing Maps Blogs & Tweets 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 ...

  1. #1
    VE Team is offline Senior Member Blue Belt
    Join Date
    Sep 2007
    Posts
    185

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 06-19-2007, 08:39 AM
  2. SpatialPoint Survey for MapPoint Users
    By Eric Frost in forum News and Announcements
    Replies: 0
    Last Post: 04-05-2007, 10:46 PM
  3. Coverage of 2006?
    By jtowell in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-19-2006, 09:02 AM
  4. Reporting service coverage by zip code and radius
    By jjmmbb in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-05-2004, 05:13 PM
  5. can anyone help me build gps for 911 coverage in africa
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 05-24-2004, 11:41 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91