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. ...
Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
