In Chapter 10, I discussed the concepts associated with spatial data, which SQL Server implements using the GEOMETRY and GEOGRAPHY data types. In this chapter, I will examine how to work with these data types. First, I will discuss the methods that can be used to construct surfaces, before reviewing how to query spatial data. Finally, you will see how to design and create spatial indexes.
Caution
A geospatial object can be referred to as a geometry, with simple objects referred to as primitive geometries and collections of objects referred to as geometry collections. Because ...
