SqlGeography 类

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

继承层次结构

System. . :: . .Object
  Microsoft.SqlServer.Types..::..SqlGeography

命名空间：  Microsoft.SqlServer.Types
程序集：  Microsoft.SqlServer.Types（在 Microsoft.SqlServer.Types.dll 中）

语法

声明
<SerializableAttribute> _
<CLSCompliantAttribute(True)> _
<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered := False,  _
    MaxByteSize := , IsFixedLength := False)> _
Public NotInheritable Class SqlGeography _
    Implements INullable, IBinarySerialize
用法
Dim instance As SqlGeography

[SerializableAttribute]
[CLSCompliantAttribute(true)]
[SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered = false, 
    MaxByteSize = , IsFixedLength = false)]
public sealed class SqlGeography : INullable, 
    IBinarySerialize

[SerializableAttribute]
[CLSCompliantAttribute(true)]
[SqlUserDefinedTypeAttribute(Format::UserDefined, IsByteOrdered = false, 
    MaxByteSize = , IsFixedLength = false)]
public ref class SqlGeography sealed : INullable, 
    IBinarySerialize

[<SealedAttribute>]
[<SerializableAttribute>]
[<CLSCompliantAttribute(true)>]
[<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered = false, 
    MaxByteSize = , IsFixedLength = false)>]
type SqlGeography =  
    class
        interface INullable
        interface IBinarySerialize
    end

public final class SqlGeography implements INullable, IBinarySerialize

SqlGeography 类型公开以下成员。

构造函数

	名称	说明
	SqlGeography	Initializes a new instance of the SqlGeography class.

页首

属性

	名称	说明
	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.

页首

方法

	名称	说明
	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.
	BufferWithTolerance	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.
	EnvelopeAngle	Returns the maximum angle between the point returned by the EnvelopeCenter method and a point in the geography instance in degrees.
	EnvelopeCenter	Returns a point that can be used as the center of a bounding circle for the geography instance.
	Equals	（从 Object 继承。）
	Filter	Offers a fast, index-only intersection method to determine if a geography instance intersects another SqlGeography instance, assuming an index is available.
	Finalize	（从 Object 继承。）
	GeomFromGml	Constructs a SqlGeography instance given a representation in the SQL Server subset of the Geography Markup Language (GML).
	GetHashCode	（从 Object 继承。）
	GetType	（从 Object 继承。）
	InstanceOf	Tests if the SqlGeography instance is the same as the specified type.
	MemberwiseClone	（从 Object 继承。）
	NumRings	Returns the total number of rings in a Polygon instance.
	Parse	Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation.
	Point	Constructs a SqlGeography instance representing a Point instance from its x and y values and a spatial reference ID (SRID).
	Populate	Applies a geography type call sequence to IGeographySink object. The call sequence is a set of figures, lines, and points for geography types.
	Read	Reads a binary representation of a geography type into a SqlGeometry object.
	Reduce	Returns an approximation of the given geography instance produced by running the Douglas-Peucker algorithm on the instance with the given tolerance.
	RingN	Returns the specified ring of the SqlGeography instance: 1 ≤ n ≤ NumRings().
	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	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.
	STDifference	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	Determines whether the calling SqlGeography instance is spatially disjoint from the specified SqlGeography instance.
	STDistance	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	Determines whether the specified SqlGeography instance has the same point set as the calling SqlGeography instance.
	STGeomCollFromText	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	Returns a GeometryCollection instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
	STGeometryN	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	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	Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
	STIntersection	Returns an object representing the points where a SqlGeography instance intersects another SqlGeography instance.
	STIntersects	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.
	STLength	Returns the total length of the elements in a SqlGeography instance or the SqlGeography instances within a GeometryCollection.
	STLineFromText	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	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	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	Returns a SqlGeography MultiLineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
	STMPointFromText	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	Returns a SqlGeography MultiPoint instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
	STMPolyFromText	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	Returns a SqlGeography MultiPolygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
	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
	STPointFromText	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	Returns a SqlGeography Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
	STPointN	Returns the specified point in a SqlGeography instance.
	STPolyFromText	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	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	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	Returns an object representing the union of a SqlGeography instance with another SqlGeography instance.
	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. （覆盖 Object. . :: . .ToString() () () ()。）
	Write	Writes a SqlGeography object to a binary stream.

页首

注释

SQL Server 2008 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.

线程安全

此类型的任何公共 static（在 Visual Basic 中为 Shared） 成员都是线程安全的。不保证所有实例成员都是线程安全的。

请参阅

参考

Microsoft.SqlServer.Types 命名空间