O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

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

Defining Space with Well-Known Text

Shapes are projected onto spatial models using vector objects—which are collections of points, lines, and polygons (closed shapes). Both the geometry and geography data types support the same Well-Known Text (WKT) markup language, which is a convention that expresses the vector objects that you define using a syntax governed by the OGC.

Table 9-1 shows some examples of WKT strings.

Table 9-1. examples of WKT Strings

WKT String

Description

POINT(6 10)

A single point at xy-coordinates 6, 10

POINT(-111.06687 45.01188)

A single point on the earth (longitude/latitude coordinates)

LINESTRING(3 4,10 50,20 25)

A two-part line, drawn between three points specified as xy-coordinates

POLYGON((

-75.17031 39.95601, -75.16786 39.95778, ...

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