Building location aware applications with the sql server spatial library l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 14

Building Location-Aware Applications with the SQL Server Spatial Library. PowerPoint PPT Presentation


  • 269 Views
  • Uploaded on
  • Presentation posted in: General

SVR33. Building Location-Aware Applications with the SQL Server Spatial Library. Ed Katibah, Torsten Grabs and Olivier Meyer SQL Server Microsoft Corporation. SQL Server 2008 Spatial Summary. OVERVIEW. FEATURES. 2 Spatial Data Types (CLR UDT) Comprehensive set of Spatial Methods

Download Presentation

Building Location-Aware Applications with the SQL Server Spatial Library.

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Building location aware applications with the sql server spatial library l.jpg

SVR33

Building Location-Aware Applications with the SQL Server Spatial Library.

Ed Katibah, Torsten Grabs and Olivier Meyer

SQL Server

Microsoft Corporation


Slide2 l.jpg

SQL Server 2008 Spatial Summary

OVERVIEW

FEATURES

  • 2 Spatial Data Types (CLR UDT)

  • Comprehensive set of Spatial Methods

  • High Performance Spatial Indexes

  • Spatial Library

  • Sink/Builder APIs

  • Management Studio Integration

  • 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 SQL Server

  • Express, Workgroup, Web, Standard, Enterprise and

  • Developer

  • Support for very large spatial objects

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, WKB and GML

  • Multiple spatial indexes per column

  • Create new CLR-based spatial methods

  • with the Builder API

  • Redistributable Spatial Library

  • SQLSysClrTypes


Sql server spatial library resources l.jpg

SQL Server Spatial Library Resources

SQL SERVER SPATIAL LIBRARY

Microsoft SQL Server System CLR Types

The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server 2008 R2. This component can be installed separately from the server to allow client applications to use these types outside of the server.

X86 Package(SQLSysClrTypes_x86.msi) – 3,342 KBX64 Package (SQLSysClrTypes._x64msi) – 3,459 KBIA64 Package(SQLSysClrTypes_ia64.msi) – 5,352 KB

Search for: Microsoft SQL Server 2008 Feature Pack, October 2008

---

CODEPLEX SQL Server Spatial Tools

Code Samples Utilizing the SQL Server Spatial Library

SQL Server Spatial Tools– including source code for tools

Search for: Codeplex SQL Server Spatial Tools


Future spatial library improvements candidate enhancements l.jpg

Future Spatial Library ImprovementsCandidate Enhancements

  • 2D Enhancements

    • Aggregates, Validation Methods, etc.

  • Full Globe Support

    • New Methods, Relaxation of Validity Constraints

  • Terrain Mesh

    • Support for viewsheds, slope / aspect aggregates, etc.

      All are subject to change.


Excel spatial spreadsheet l.jpg

Excel Spatial Spreadsheet

demo

Olivier Meyer

Senior Program Manager

SQL Server


Streaminsight goes spatial l.jpg

StreamInsight™ Goes Spatial

demo

Torsten Grabs

Senior Program Manager Lead

SQL Server


What is cep l.jpg

What is CEP?

Event

Complex Event Processing (CEP) is the continuous and incremental processing of event streams from multiple sources based on declarative query and pattern specifications with near-zero latency.

request

output stream

input stream

response


Shuttle tracker l.jpg

Shuttle Tracker

519,000+ data points, covering 1 day of operation


Other resources l.jpg

Other Resources

  • Blogs

    • http://blogs.msdn.com/edkatibah

    • http://blogs.msdn.com/streaminsight

    • http://blogs.msdn.com/oliviermeyer

  • Forums

    • http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/

    • http://social.msdn.microsoft.com/Forums/en-US/streaminsight

  • Books

    • Beginning Spatial with SQL Server 2008, Apress.

    • Inside SQL Server 2008:T-SQL Programming, MSPress.


Slide11 l.jpg

YOUR FEEDBACK IS IMPORTANT TO US!

Please fill out session evaluation forms online at

MicrosoftPDC.com


Learn more on channel 9 l.jpg

Learn More On Channel 9

  • Expand your PDC experience through Channel 9.

  • Explore videos, hands-on labs, sample code and demos through the new Channel 9 training courses.

    channel9.msdn.com/learn

Built by Developers for Developers….


  • Login