Chapter 11. Spatial Data and GML

SQL Server 2008 introduces powerful new data types to store, query, and manipulate spatial data. These new data types, geometry and 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 geometry and geography data types.

Spatial Data

The new geometry and 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 ...

Get Pro SQL Server 2008 XML 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.