Skip to main content

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
Read in English Edit
Twitter LinkedIn Facebook Email

OGC Methods on Geometry Instances

  • Article
  • 02/28/2023

In this article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

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

For more information on OGC specifications, see the following:

  • 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

  • STCurveN (geometry Data Type)

  • STCurveToLine (geometry Data Type)

  • STDifference

  • STDimension

  • STDisjoint

  • STDistance

  • STEndpoint

  • STEnvelope

  • STEquals

  • STExteriorRing

  • STGeometryN

  • STGeometryType

  • STInteriorRingN

  • STIntersection

  • STIntersects

  • STIsClosed

  • STIsEmpty

  • STIsRing

  • STIsSimple

  • STIsValid

  • STLength

  • STNumCurves (geometry Data Type)

  • STNumGeometries

  • STNumInteriorRing

  • STNumPoints

  • STOverlaps

  • STPointN

  • STPointOnSurface

  • STRelate

  • STSrid

  • STStartPoint

  • STSymDifference

  • STTouches

  • STUnion

  • STWithin

  • STX

  • STY

See Also

Extended Methods on Geometry Instances
OGC Static Geometry Methods
Extended Static Geometry Methods


Additional resources

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023

Additional resources

In this article

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023