# SqlGeography Class

**SQL Server 2016**

The SqlGeography type represents data in a geodetic (round earth) coordinate system.

**Namespace:**Microsoft.SqlServer.Types

**Assembly:**Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Name | Description | |
---|---|---|

SqlGeography() | Initializes a new instance of the SqlGeography class. |

Name | Description | |
---|---|---|

HasM | Returns | |

HasZ | Returns | |

IsNull | Determines whether the SqlGeography instance is null. | |

Lat | Returns the latitude property of the geography instance. | |

Long | Returns the longitude property of the geography instance. | |

M | Returns the M (measure) value of the geography instance. | |

Null | Returns a read-only property providing a null instance of the SqlGeography type. | |

STSrid | Gets or sets id is an integer representing the Spatial Reference Identifier (SRID) of the instance. | |

Z | Gets the Z (elevation) value of the instance. The semantics of the elevation value are user-defined. |

Name | Description | |
---|---|---|

AsBinaryZM() | Returns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a SqlGeography instance augmented with any Z (elevation) and M (measure) values carried by the instance. | |

AsGml() | Returns the Geography Markup Language (GML) representation of a SqlGeography instance. | |

AsTextZM() | Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeography instance augmented with any Z (elevation) and M (measure) values carried by the instance. | |

BufferWithCurves(Double) | Returns a SqlGeography instance that represents the set of all points whose distance from the calling SqlGeography instance is less than or equal to the | |

BufferWithTolerance(Double, Double, Boolean) | Returns a geometric object representing the union of all point values whose distance from a SqlGeography instance is less than or equal to a specified value, allowing for a specified tolerance. | |

CurveToLineWithTolerance(Double, Boolean) | Returns a polygonal approximation of a SqlGeography instance that contains circular arc segments. | |

Deserialize(SqlBytes) | Returns a constructed SqlGeometry from an internal SQL Server format for spatial data. Can be used for sending spatial data over the network or reading them from files. | |

EnvelopeAngle() | Returns the maximum angle between the point returned by EnvelopeCenter and a point in the SqlGeography instance in degrees. | |

EnvelopeCenter() | Returns a point that can be used as the center of a bounding circle for the geography instance. | |

Equals(Object) | (Inherited from Object.) | |

Filter(SqlGeography) | Offers a fast, index-only intersection method to determine if a geography instance intersects another SqlGeography instance, assuming an index is available. | |

GeomFromGml(SqlXml, Int32) | Constructs a SqlGeography instance given a representation in the SQL Server subset of the Geography Markup Language (GML). | |

GetHashCode() | (Inherited from Object.) | |

GetType() | (Inherited from Object.) | |

InstanceOf(String) | Tests if the SqlGeography instance is the same as the specified type. | |

IsValidDetailed() | Returns a message to help identify validity issues with a spatial object. | |

MakeValid() | Converts a | |

MinDbCompatibilityLevel() | Returns the minimum database compatibility that accepts the SqlGeography type. | |

NumRings() | Returns the total number of rings in a | |

Parse(SqlString) | Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation. | |

Point(Double, Double, Int32) | Constructs a SqlGeography instance representing a Point instance from its x and y values and a spatial reference ID (SRID). | |

Populate(IGeographySink) |
| |

Populate(IGeographySink110) | Applies a | |

Read(BinaryReader) | Reads a binary representation of a | |

Reduce(Double) | Returns an approximation of the given geography instance produced by running the Douglas-Peucker algorithm on the instance with the given tolerance. | |

ReorientObject() | Returns a | |

RingN(Int32) | Returns the specified ring of the SqlGeography instance: 1 ≤ n ≤ NumRings(). | |

Serialize() | Used for sending spatial data across the network. | |

ShortestLineTo(SqlGeography) | Returns the shortest distance between the two SqlGeographyinstances. | |

STArea() | Returns the total surface area of a SqlGeography instance. | |

STAsBinary() | Returns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a SqlGeography instance. | |

STAsText() | Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeography instance. | |

STBuffer(Double) | Returns a geography object that represents the union of all points whose distance from a SqlGeography instance is less than or equal to a specified value. | |

STContains(SqlGeography) | Specifies whether the calling SqlGeography instance spatially contains the SqlGeography instance passed to the method. | |

STConvexHull() | Returns an object that represents the convex hull of a SqlGeography instance. | |

STCurveN(Int32) | Returns the curve specified from a SqlGeography instance that is a | |

STCurveToLine() | Returns a polygonal approximation of a SqlGeography instance that contains circular arc segments. | |

STDifference(SqlGeography) | Returns an object representing the points from one SqlGeography instance that do not lie within another SqlGeography instance. | |

STDimension() | Returns the maximum dimension of a SqlGeography instance | |

STDisjoint(SqlGeography) | Determines whether the calling SqlGeography instance is spatially disjoint from the specified SqlGeography instance. | |

STDistance(SqlGeography) | Returns the shortest distance between a point in a SqlGeography instance and a point in another SqlGeography instance. | |

STEndPoint() | Returns the end point of a SqlGeography instance. | |

STEquals(SqlGeography) | Determines whether the specified SqlGeography instance has the same point set as the calling SqlGeography instance. | |

STGeomCollFromText(SqlChars, Int32) | Returns a geography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation, augmented with any Z (elevation) and M (measure) values carried by the instance. | |

STGeomCollFromWKB(SqlBytes, Int32) | Returns a GeometryCollection instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation. | |

STGeometryN(Int32) | Returns a specified geography element in a GeometryCollection or one of its subtypes. | |

STGeometryType() | Returns the Open Geospatial Consortium (OGC) type name represented by a geography instance. | |

STGeomFromText(SqlChars, Int32) | Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation augmented with any Z (elevation) and M (measure) values carried by the instance. | |

STGeomFromWKB(SqlBytes, Int32) | Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation. | |

STIntersection(SqlGeography) | Returns an object representing the points where a SqlGeography instance intersects another SqlGeography instance. | |

STIntersects(SqlGeography) | Determines whether the current SqlGeography instance intersects with the specified SqlGeography. | |

STIsClosed() | Determines whether the calling SqlGeography instance is closed. | |

STIsEmpty() | Determines whether the SqlGeography instance is empty. | |

STIsValid() | Specifies whether a | |

STLength() | Returns the total length of the elements in a SqlGeography instance or the SqlGeography instances within a GeometryCollection. | |

STLineFromText(SqlChars, Int32) | Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation, augmented with any Z (elevation) and M (measure) values carried by the instance. | |

STLineFromWKB(SqlBytes, Int32) | Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation, augmented with any Z (elevation) and M (measure) values carried by the instance. | |

STMLineFromText(SqlChars, Int32) | Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation, augmented with any Z (elevation) and M (measure) values carried by the instance. | |

STMLineFromWKB(SqlBytes, Int32) | Returns a SqlGeography MultiLineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation. | |

STMPointFromText(SqlChars, Int32) | ||

STMPointFromWKB(SqlBytes, Int32) | Returns a SqlGeography MultiPoint instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation. | |

STMPolyFromText(SqlChars, Int32) | ||

STMPolyFromWKB(SqlBytes, Int32) | Returns a SqlGeography MultiPolygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation. | |

STNumCurves() | Returns the number of curves in a one-dimensional SqlGeography instance. | |

STNumGeometries() | Returns the number of geometries that make up a SqlGeography instance. | |

STNumPoints() | Returns the total number of points in each of the figures in a SqlGeography instance | |

STOverlaps(SqlGeography) | Returns 1 if a SqlGeography instance spatially overlaps another SqlGeography instance, or 0 if it does not. | |

STPointFromText(SqlChars, Int32) | ||

STPointFromWKB(SqlBytes, Int32) | Returns a SqlGeography Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation. | |

STPointN(Int32) | Returns the specified point in a SqlGeography instance. | |

STPolyFromText(SqlChars, Int32) | Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation augmented with any Z (elevation) and M (measure) values carried by the instance. | |

STPolyFromWKB(SqlBytes, Int32) | Returns a SqlGeography Polygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation. | |

STStartPoint() | Returns the start point of a SqlGeography instance. | |

STSymDifference(SqlGeography) | Returns an object representing all points that are either in one SqlGeography instance or another SqlGeography instance, but not those points that lie in both instances. | |

STUnion(SqlGeography) | Returns an object representing the union of a SqlGeography instance with another SqlGeography instance. | |

STWithin(SqlGeography) | Returns 1 if a SqlGeography instance is spatially within another SqlGeography instance; otherwise, returns 0. | |

ToString() | Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeography instance augmented with any Z (elevation) and M (measure) values carried by the instance.(Overrides Object.ToString().) | |

Write(BinaryWriter) | Writes a SqlGeography object to a binary stream. |

Name | Description | |
---|---|---|

ISqlSpatialGridIndexable.BufferForDistanceQuery(Double, Boolean) | Returns the buffer for distance query for the SQL Geography. | |

ISqlSpatialGridIndexable.GetBoundingBoxCorners(Double, Double, Double, Double) | Returns a value for the bounding box corners for the SQL Geography. | |

ISqlSpatialGridIndexable.GetGridCoverage(Boolean, Double, Double, Double, Double, Double, Double, Int32, Int32, Boolean[,], Boolean[,], Int32, Int32, Boolean, Boolean) | Returns the grid coverage of the SQL Geography. | |

ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery(Double) | Gets the interior buffer for distance query for the SQL Geography. |

SQL Server supports a set of methods for the geography spatial data type. These methods include methods on geography that are defined by the Open Geospatial Consortium (OGC) standard and a set of Microsoft extensions to that standard.

Any public static (**Shared** in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.