Spatial Instance Types

IN SQL Server 2008, the GEOMETRY and GEOGRAPHY data types supported seven spatial type classes that you can create and work with in a database:

Image POINTA POINT is an exact location and is defined in terms of an X and Y pair of coordinates, as well as optionally by Z (elevation) and M (measure) coordinates. It does not have a length or any area associated with it. These instance types are used as the fundamental building blocks of more complex spatial types.

Image MULTIPOINTA MULTIPOINT is a collection of zero or more points.

Get Microsoft® SQL Server 2012 Unleashed 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.