United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

geography (Transact-SQL)

geography Data Type Method Reference

OGC Methods on Geography Instances

STArea (geography Data Type)

STAsBinary (geography Data Type)

STAsText (geography Data Type)

STBuffer (geography Data Type)

STDifference (geography Data Type)

STDimension (geography Data Type)

STDisjoint (geography Data Type)

STDistance (geography Data Type)

STEndpoint (geography Data Type)

STEquals (geography Data Type)

STGeometryN (geography Data Type)

STGeometryType (geography Data Type)

STIntersection (geography Data Type)

STIntersects (geography Data Type)

STIsClosed (geography Data Type)

STIsEmpty (geography Data Type)

STLength (geography Data Type)

STNumGeometries (geography Data Type)

STNumPoints (geography Data Type)

STPointN (geography Data Type)

STSrid (geography Data Type)

STStartPoint (geography Data Type)

STSymDifference (geography Data Type)

STUnion (geography Data Type)

Minimize

1 out of 1 rated this helpful - Rate this topic

OGC Methods on Geography Instances

SQL Server 2008

SQL Server 2008 supports the Open Geospatial Consortium (OGC) methods on geography instances.

For more information on OGC specifications, see the following resources:

OGC Specifications, Simple Feature Access Part 1 - Common Architecture

OGC Specifications, Simple Feature Access Part 2 – SQL Options

In This Section

Other Resources

Extended Methods on Geography Instances

OGC Static Geography Methods

Extended Static Geography Methods

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.