Online Spatial Database Clouds - SQL Azure

Online Spatial Database Clouds - SQL Azure
(spatial database support coming due to demand of user feedback)


Using a Spatial database (SQL Azure) to find Gas (petrol) Stations along a route.
New Functionality - Azure Spatial Database Support using cloud computing related topic - http://en.wikipedia.org/wiki/SQL_Azure


Last Wednesday (March 17th), Dave Robinson of the SQL Azure Team announced upcoming support for spatial data in SQL Azure. You can view the announcement at the MIX Conference in the video of Dave’s presentation, Building Web Applications with Microsoft SQL Azure (go to 18:40 on the timeline for the start of the spatial data portion of his talk).

Spatial buffering a polyline - but across the web (not local database) - Windows SQL Azure will have spatial capabilities - to be released April 2010.

"SQL Azure provides a highly available and scalable relational database engine in the cloud. In this demo-intensive and interactive session, learn how to quickly build web applications with SQL Azure Databases and familiar web technologies. We demonstrate how you can quickly provision, build and populate a new SQL Azure database directly from your web browser. Also, see firsthand several new enhancements we are adding to SQL Azure based on the feedback we’ve received from the community since launching the service earlier this year."

This uses the same technology as Microsoft SQL 2008 Server
basically it supports latitude and longitude.

A "Flat Earth" (GEOMETRY or planar) data type represents geospatial data which has been projected from its native, spherical, coordinate system into a plane.
A "Round Earth" data type (GEOGRAPHY) uses an ellipsoidal model in which the Earth is defined as a single continuous entity.

source:
Video
http://live.visitmix.com/MIX10/Sessions/SVC07 (46.45) jump to 18.36if have no time.

Related blog
http://blogs.msdn.com/edkatibah/archive/2010/03/21/spatial-data-support-coming-to-sql-azure.aspx

SQL Azure Labs
http://blogs.msdn.com/sqlazure/archive/2010/03/19/9981936.aspx

Weather.com goes into the 'Future' (Bing Maps)

Weather.com goes into the 'Future' (Bing Maps)


The new 'Future' button starts moving into a predicted mode using 'trupoint' technology at 15 minute intervals up to 6 hours into the future.

http://www.weather.com/weather/map/interactive/30004?from=36hr_maps&zoom=8&interactiveMapLayer=radar

"The Weather Channel's unique TruPoint^SM technology delivers the most accurate weather reports and forecasts - for more locations - than any other weather provider.

NEW: TruPoint technology is now available on weather.com interactive maps! See exactly where storms are forecasted for up to the next six hours so you can better plan and prepare for any activity."

Summary of TruePoint Technology

A highly localized weather forecast; accurate down to a one-square mile area.

Allows you to zero in on specific places such as schools and parks.

Available every 15 minutes across a 6 hour period.

Available only within the 48 contiguous United States.

A proprietary technology developed and used exclusively by The Weather Channel.

Full details on the technology here:
http://www.weather.com/encyclopedia/trupoint.html?from=hrly_trupointlogo

source:
http://www.bing.com/community/blogs/maps/archive/2009/11/01/weather-com-adds-futures-on-bing-maps.aspx