O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

No longer are geospatial capabilities limited to the domain of sophisticated Geographic Information System applications. The power of spatial processing is now readily available to all developers using the new geometry and geography data types in SQL Server 2008. In this chapter, you learned how to use these types by creating geospatial applications that integrate location intelligence and mapping capabilities for our users. You also saw how easy it is to express and project coordinates against either the planar (flat-earth) or geodetic (round-earth) spatial models using Well-Known Text (WKT) syntax. Along the way, we examined some of the most common geospatial methods for performing intersection, length, area, and distance calculations. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required