SQL Server 2008 introduces powerful new data types to store, query, and manipulate spatial data. These new data types,
geography, are designed to represent spatial data in accordance with the Open Geospatial Consortium (OGC) XML-based Geography Markup Language standard (GML). In this chapter, I will discuss the GML features of these new
geography data types.
geography data types are designed to store spatial data. In its simplest form spatial data is two-dimensional, consisting of a coordinate pair representing a point on a flat grid or, in more complex applications, a point on an ellipsoidal surface, like the earth's surface, as shown in Figure 11-1.
Figure 11-1. Latitude ...