SqlGeography Class
The SqlGeography type represents data in a geodetic (round earth) coordinate system.
Assembly: Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)
| Name | Description | |
|---|---|---|
![]() | SqlGeography() | Initializes a new instance of the SqlGeography class. |
| Name | Description | |
|---|---|---|
![]() | HasM | Returns true if at least one point in a spatial object contains value M; otherwise returns false. This property is read-only. |
![]() | HasZ | Returns true if at least one point in a spatial object contains value Z; otherwise returns false. This property is read-only. |
![]() | 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 distance parameter. |
![]() | 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 geography instance that is not valid into a valid geography instance with a valid Open Geospatial Consortium (OGC) type. |
![]() | MinDbCompatibilityLevel() | Returns the minimum database compatibility that accepts the SqlGeography type. |
![]() | NumRings() | Returns the total number of rings in a Polygon instance. |
![]() ![]() | 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^) | Obsolete. Applies a geography type call sequence to IGeographySink object. The call sequence is a set of figures, lines, and points for geography types. |
![]() | Populate(IGeographySink110^) | Applies a geography type call sequence to IGeographySink object. |
![]() | Read(BinaryReader^) | Reads a binary representation of a geography type into a SqlGeometry object. |
![]() | 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 geography instance with interchanged interior regions and exterior regions. |
![]() | 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 LineString, CircularString, or CompoundCurve. |
![]() | 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 geography instance is well-formed and recognized as a valid geography object based on its Open Geospatial Consortium (OGC) type. |
![]() | 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) | 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. |
![]() ![]() | STMPointFromWKB(SqlBytes^, Int32) | Returns a SqlGeography MultiPoint instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation. |
![]() ![]() | STMPolyFromText(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. |
![]() ![]() | 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) | 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. |
![]() ![]() | 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, array<Boolean, 2>^, array<Boolean, 2>^, 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.




