O'Reilly logo

Pro Spatial with SQL Server 2012 by Alastair Aitchison

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

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

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