C H A P T E R  4

Creating Spatial Data

In the first three chapters of this book I introduced you to the main components necessary to define spatial data in SQL Server, namely, a set of coordinate locations, the spatial reference system in which those coordinates are defined, the type of geometry used to represent a feature, and the datatype in which that feature is stored.

In this chapter, we apply the knowledge you’ve gained so far in a practical context, by looking at the different methods you can use to create items of geometry or geography data. Every method requires those same key pieces of information: the spatial reference system, type of geometry, and datatype, together with the coordinates that define that instance.

The way in which ...

Get Pro Spatial with SQL Server 2012 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.