O'Reilly logo

Pro SQL Server 2008 XML by Michael Coles

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

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 ...

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