SQL2008 + VE + SpatialPoint = Superbowl Coverage Map

<p>Longtime MapPoint/Virtual Earth gurus <a href="http://www.spatialpoint.com/" target="_blank">SpatialPoint</a> released a radio coverage application the other day to help you <a href="http://www.followthegame.com/" target="_blank">find a station in your area broadcasting the Superbowl</a> 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 (<a href="http://www.npr.org/stations/" target="_blank">National Public Radio</a> 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: <p><i>You can tune in station <b>KJR-AM (950) broadcasting out of SEATTLE</b> immediately. Coverage should last for about 40.11 miles. </i>Depart on I-5 Express Ln (South) (2.26 mi) <p><b>1 </b>Turn LEFT onto Ramp (0.18 mi) <p><b>2 </b>Turn LEFT (North-East) onto Cherry St, then immediately turn RIGHT (South) onto 6th Ave (0.21 mi) <p><b>3 </b>Keep LEFT onto Ramp (0.43 mi) <p><b>4 </b>Keep LEFT to stay on Ramp (0.05 mi) <p><b>5 </b>Take Ramp (LEFT) onto I-90 (479.24 mi) <p><i>You will lose station <b>KJR-AM (950) broadcasting out of SEATTLE</b> at about mile 40.11.</i> <p><i>You can tune in station <b>KWIQ-AM (1020) broadcasting out of MOSES LAKE NORTH</b> at about mile 166.22. Coverage should last for about 27.90 miles.</i> <p><i>You will lose station <b>KWIQ-AM (1020) broadcasting out of MOSES LAKE NORTH</b> at about mile 194.11.</i> <p><em>. . .</em> <p>Of course, displaying the RF coverage shapes in Virtual Earth from SQL server is a breeze: <p><a href="http://www.followthegame.com/" target="_blank">
http://xax3ia.bay.livefilestore.com/y1p511BmElsGQ0mwXXxdcC5vPrZNEgwGf0knbnXbXvbWxxVWGO E8P7gdrYYv_gwEgu_QUQlU6LbWrxaFzAqegm67A?PARTNER=WR ITER</a> <div style="padding-right:0px;display:inline;padding-left:0px;padding-bottom:0px;margin:0px;padding-top:0px">Technorati tags: <a href="http://technorati.com/tags/Superbowl" rel=tag>Superbowl</a>, <a href="http://technorati.com/tags/SpatialPoint" rel=tag>SpatialPoint</a>, <a href="http://technorati.com/tags/RF Coverage" rel=tag>RF Coverage</a></div><img src="http://c.services.spaces.live.com/CollectionWebService/c.gif?cid=3151506992847969176&page=RSS%3a+SQL2008+%2b+VE+%2b+SpatialPoint+%3d+Su perbowl+Coverage+Map&referrer=" width="1px" height="1px" border="0" alt=""><img style="position:absolute" alt="" width="0px" height="0px" src="http://c.live.com/c.gif?NC=31263&NA=1149&PI=73329&RF=&DI=3919&PS=85545&TP=virtualearth.spaces.live.com&GT1=virtualearth">

Click here to view the full post. (http://virtualearth.spaces.live.com/Blog/cns!2BBC66E99FDCDB98!10983.entry)