Database and Analytics

T19 Geospatial Data Types in SQL Server


3:00pm - 4:15pm

Level: Introductory to Intermediate

Leonard Lobel



Sleek Technologies, Inc.

The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! And because they are implemented as CLR types, they can be used just the same in your .NET applications. In this session, you'll learn how to integrate location-awareness into your own database applications with the geometry and geography data types. You'll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use and build several spatial desktop and web applications. The demos in this session will show you how to integrate with Bing Maps, and how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. You'll also cover the latest geospatial enhancements in SQL Server 2012. Attend this session and embrace spatial programming today.

You will learn:

  • About the planar (flat earth) and geodetic (round earth) spatial models
  • How to leverage the geometry and geography data types to manipulate spatial data
  • How to integrate your own spatial data with Bing Maps