Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

OGC Methods on Geometry Instances

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

For more information on Open Geospatial Consortium (OGC) specifications, see the following Open Geospatial Consortium Specifications:

OGC Specifications, Simple Feature Access Part 1 - Common Architecture

OGC Specifications, Simple Feature Access Part 2 – SQL Options

In This Section

  • STArea

  • STAsBinary

  • STAsText

  • STBoundary

  • STBuffer

  • STCentroid

  • STContains

  • STConvexHull

  • STCrosses

  • STDifference

  • STDimension

  • STDisjoint

  • STDistance

  • STEndpoint

  • STEnvelope

  • STEquals

  • STExteriorRing

  • STGeometryN

  • STGeometryType

  • STInteriorRingN

  • STIntersection

  • STIntersects

  • STIsClosed

  • STIsEmpty

  • STIsRing

  • STIsSimple

  • STIsValid

  • STLength

  • STNumGeometries

  • STNumInteriorRing

  • STNumPoints

  • STOverlaps

  • STPointN

  • STPointOnSurface

  • STRelate

  • STSrid

  • STStartPoint

  • STSymDifference

  • STTouches

  • STUnion

  • STWithin

  • STX

  • STY

See Also

Other Resources

Extended Methods on Geometry Instances

OGC Static Geometry Methods

Extended Static Geometry Methods


Additional resources


  • Last updated on 2010-10-01

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026