201248 nagle, darien microsoft spatial roadmap in the box and in the cloud
DESCRIPTION
Presentation from NT Spatial 2012: Northern Exposure "Science and Applications"TRANSCRIPT
![Page 1: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/1.jpg)
Microsoft Spatial Roadmapin the Box and In the Cloud
Darien NagleApplication Platform Solution Specialist
Microsoft [email protected]
![Page 2: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/2.jpg)
Agenda
• Microsoft’s Spatial Tools• What’s New in Spatial for SQL Server 2012 • Spatial in the Cloud – A Scenario• Summary and Questions
![Page 3: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/3.jpg)
Microsoft Spatial BI Tools
• Microsoft Office− Visio
− Create spatial diagrams− Connect diagram objects to data
− Excel− Query and Edit Spatial Data
• Bing Maps− Geocoding− Spatial “tiles”− Rich APIs for custom development
• SQL Server− Spatial data types− Maps and reports in SQL Server Reporting Services (SSRS)
• Interactive - Silverlight/HTML 5
![Page 4: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/4.jpg)
Spatial Tools
• Build your own content using Visio− Spatial context inherent in
the diagram− Connect elements to data
![Page 5: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/5.jpg)
Excel 2010 Reporting
![Page 6: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/6.jpg)
Reporting in SharePoint 2010
![Page 7: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/7.jpg)
Reporting in SharePoint 2010Excel Services
![Page 8: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/8.jpg)
![Page 9: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/9.jpg)
Spatial Tools
![Page 10: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/10.jpg)
![Page 11: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/11.jpg)
![Page 12: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/12.jpg)
Other “Spatial Intelligence” Examples
![Page 13: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/13.jpg)
Other “Spatial Intelligence” Examples
![Page 14: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/14.jpg)
![Page 15: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/15.jpg)
![Page 16: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/16.jpg)
Agenda
• Microsoft’s Spatial Tools• What’s New in Spatial for SQL Server 2012 • Spatial in the Cloud – A Scenario• Summary and Questions
![Page 17: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/17.jpg)
Spatial Data Types
• Geography (Geodetic)• Geometry (Planar)
2 Spatial Datatypes
• Ellipsoidal coordinate support only (e.g. WGS 84)• Core set of geospatial methods• No OGC/ISO standards compliance (though many standards components are there)
• Geospatial index• Designed as a simple, straight-forward geospatial implementation
Geography
• Planar coordinate support only (georeferenced and non-georeferenced)
• Complete set of spatial methods• OGC/ISO standards compliance (OGC SFS v1.1, ISO 19125)• Spatial index• Comprehensive spatial/geospatial offering supporting 2D planimetric
applications
Geometry
![Page 18: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/18.jpg)
POINT MULTIPOINT
LINESTRINGMULTILINESTRING
CIRCULARSTRING
COMPOUNDCURVE
POLYGON MULTIPOLYGON
CURVEPOLYGONGEOMETRYCOLLECTION
FULLGLOBE
Spatial Data Classes
![Page 19: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/19.jpg)
Vector Data
![Page 20: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/20.jpg)
Complex Geometry
![Page 21: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/21.jpg)
Operations on Complex 2KM Buffer
![Page 22: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/22.jpg)
Planar vs. Round Earth
What is the distance from Anchorage to Tokyo?
![Page 23: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/23.jpg)
Overview of New Spatial Features in SQL Server 2012
• Spatial Index Improvements
• Spatial Type Improvements
• Performance Improvements
• Other Spatial Improvements
![Page 24: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/24.jpg)
Circular Arcs
• New Keywords: CircularStrings CompoundCurves CurvePolygons
• Supported in WKT, WKB and GML
• Supported in both geometry and geography types
• Based on SQL MM Spatial (Part 3) Standard
![Page 25: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/25.jpg)
Circular ArcsGeography Type Considerations
LINESTRING (0 50, 90 50, 180 50, 270 50, 0 50)
CIRCULARSTRING (0 50, 90 50, 180 50, 270 50, 0 50)
Linestring segments in the geography type define theminimum distance path on theunderlying ellipsoid.
Circularstring segments in the geography type define a circularpath. A good example is a latitude parallel.
![Page 26: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/26.jpg)
Circular ArcsGeography Type Considerations
CIRCULARSTRING (0 50, 90 50, 180 50, 270 50, 0 50)
CURVEPOLYGON (CIRCULARSTRING (0 50, 90 50, 180 50, 270 50, 0 50))
If a circular linestring is closed, a curve polygon can be created
Coordinate pair order is importantfor the geography type. This setof coordinates is ordered accordingto the “left foot rule” for exteriorrings.
![Page 27: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/27.jpg)
New Methods for Circular Arcs
BufferWithCurves()
DECLARE @g GEOGRAPHY = GEOGRAPHY::STGeomFromText('CIRCULARSTRING(0 50, 45 50, 90 50)',4326)DECLARE @b GEOGRAPHY = @g.BufferWithCurves(500000)SELECT @b.STNumPoints()--Number of vertices: 11
DECLARE @g GEOGRAPHY = GEOGRAPHY::STGeomFromText('CIRCULARSTRING(0 50, 45 50, 90 50)',4326)DECLARE @b GEOGRAPHY = @g.STBuffer(500000)SELECT @b.STNumPoints()--Number of vertices: 257
This method will construct theresulting polygon with circular arcs, often resulting in a dramatically smaller spatialobject.
![Page 28: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/28.jpg)
Existing Methods And Circular Arcs
All existing method work on circular arcs
STIntersects() example
![Page 29: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/29.jpg)
Improved precision
All constructions and relations are now done with 48 bits of precision in SQL Server 2012, compared to 27 bits used in SQL Server 2008 and 2008 R2.
For example, consider the following coordinate which was processed using the STUnion() method in SQL Server 2008
-82.339025999885052 29.662144999951124 -82.339026 29.661245
Original Coordinate New Coordinate
In Denali, the greater numerical precision typically maintains the precision of the original coordinates. Here is the result of the same STUnion() method in Denali, as above
82.339026 29.661245 -82.339026 29.661245
Original Coordinate New Coordinate
![Page 30: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/30.jpg)
FullGlobe Data Capture Platform/DeviceThe Groupama 3 Trimaran
On March 20, 2010, the trimaran, Groupama 3, became the fastest boat to circumnavigate the Earth non-stop, ever (including power boats)… in 48 days, 7 hours and 44 minutes…
…and of course, it’s GPS-equipped…
![Page 31: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/31.jpg)
GPS Track Line
![Page 32: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/32.jpg)
200KM Buffer
![Page 33: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/33.jpg)
200KM Buffer
![Page 34: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/34.jpg)
200KM Buffer
![Page 35: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/35.jpg)
Simple Distance Query
DECLARE @t GEOGRAPHY = (SELECT Track FROM Groupama_Track7)SELECT TOP 16 CNTRY_NAME, SOVEREIGN, POP_CNTRY, @t.STDistance(Geography) AS [DISTANCE FROM TRACK] FROM Countries ORDER BY @t.STDistance(Geography)
CNTRY_NAME SOVEREIGN POP_CNTRY DISTANCE FROM TRACKFrance France 57757060 0New Zealand New Zealand 3528197 7115.41609170632Chile Chile 1377271015409.5690252515Spain Spain 3926778037144.5519830663Portugal Portugal 9625516 57621.7065806319Argentina Argentina 33796870106198.966899358United Kingdom United Kingdom 56420180158636.063519451Cape Verde Cape Verde 413573 165226.105053976Guernsey United Kingdom 62920177654.285742873Jersey United Kingdom 87848 189169.527892158Brazil Brazil 151525400 205920.063533954Falkland Is. United Kingdom 2136 237487.364201179Fr. So. & Ant. Lands France -99999397707.475465133Ireland Ireland 5015975 416683.669375291Australia Australia 17827520418237.701906367South Africa South Africa 40634126430605.825881581
![Page 36: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/36.jpg)
Spatial Helper Stored Procedures
Two new helper methods are available:
• sp_help_spatial_geography_histogram• sp_help_spatial_geometry_histogram They can be used for investigating spatial index efficiency or analyzing spatial data in general. The histograms could be also shown on a SSMS map.
The data can be used for external visualization:
![Page 37: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/37.jpg)
Agenda
• Microsoft’s Spatial Tools• What’s New in Spatial for SQL Server 2012 • Spatial in the Cloud – A Scenario• Summary and Questions
![Page 38: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/38.jpg)
A Open-Government Cloud Scenario
Visualisation
Mobile Applications
Results published to Cloud-based Open Government Data Feed (OGDI)
“Big Data” analytics via HPC/Hadoop in the cloud
Combined with “flat” “Big Data”
On Premises SQL Server Spatial Repository
![Page 39: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/39.jpg)
SQL Server Spatial Summary
• 2 Spatial Data Types (CLR UDT)• Comprehensive set of Spatial Methods• High Performance Spatial Indexes• Spatial Industry Standards Support• Spatial Library•Management Studio Integration• Cloud-enabled
SUMMARY FEATURES
• 2D Vector Data Support• Open Geospatial Consortium Simple Features for SQL compatible• Supported By Major GIS Vendors ESRI, Intergraph, Autodesk, Pitney Bowes, Safe, etc.
• Standard feature in all SQL Server Editions• Support for very large spatial objects (2GB)• Supported in SS Reporting Services• Redistributable Spatial Library
DETAILS• Geography data type for geodetic data• Geometry data type for planar data• Standard spatial methods STIntersects, STBuffer, STLength, STArea, etc.
• Standard spatial format support (WKT, WBK, GML)
• Multiple spatial indexes per column• Multiple spatial columns per table• Create new CLR-based spatial functions with the Sink/Builder APIs• SQL Azure Spatial support• Support for circular (curve) spatial objects• Support for full globe geography objects• Optimized performance for the sphere
Ed Katibah, SQL Server, July 1, 2008
![Page 40: 201248 Nagle, Darien Microsoft Spatial Roadmap in the Box and in the Cloud](https://reader036.vdocuments.us/reader036/viewer/2022081412/5447b584b1af9f4a228b4ada/html5/thumbnails/40.jpg)
© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after
the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.