SqlGeometry 类

The SqlGeometry type represents data in a Euclidean (flat) coordinate system.

继承层次结构

System.Object
  Microsoft.SqlServer.Types.SqlGeometry

命名空间:  Microsoft.SqlServer.Types
程序集:  Microsoft.SqlServer.Types(在 Microsoft.SqlServer.Types.dll 中)

语法

声明
<SerializableAttribute> _
<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered := False,  _
    MaxByteSize := , IsFixedLength := False)> _
<CLSCompliantAttribute(True)> _
Public NotInheritable Class SqlGeometry _
    Implements INullable, IBinarySerialize, ISqlSpatialGridIndexable
用法
Dim instance As SqlGeometry
[SerializableAttribute]
[SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered = false, 
    MaxByteSize = , IsFixedLength = false)]
[CLSCompliantAttribute(true)]
public sealed class SqlGeometry : INullable, 
    IBinarySerialize, ISqlSpatialGridIndexable
[SerializableAttribute]
[SqlUserDefinedTypeAttribute(Format::UserDefined, IsByteOrdered = false, 
    MaxByteSize = , IsFixedLength = false)]
[CLSCompliantAttribute(true)]
public ref class SqlGeometry sealed : INullable, 
    IBinarySerialize, ISqlSpatialGridIndexable
[<SealedAttribute>]
[<SerializableAttribute>]
[<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered = false, 
    MaxByteSize = , IsFixedLength = false)>]
[<CLSCompliantAttribute(true)>]
type SqlGeometry =  
    class 
        interface INullable 
        interface IBinarySerialize 
        interface ISqlSpatialGridIndexable 
    end
public final class SqlGeometry implements INullable, IBinarySerialize, ISqlSpatialGridIndexable

SqlGeometry 类型公开以下成员。

构造函数

  名称 说明
公共方法 SqlGeometry Initializes a new instance of the SqlGeometry class.

页首

属性

  名称 说明
公共属性 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 Gets a value that indicates whether the SqlGeometry object is null.
公共属性 M Gets the M (measure) value of the SqlGeometry instance. The semantics of the measure value are user-defined.
公共属性静态成员 Null Gets a read-only property providing a null instance of the SqlGeometry type.
公共属性 STSrid Gets or sets an integer that represents the Spatial Reference Identifier (SRID) of the instance.
公共属性 STX Gets the X-coordinate property of a Point instance.
公共属性 STY Gets the Y-coordinate property of a Point instance.
公共属性 Z Gets the Z (elevation) value of the instance. The semantics of the elevation value are user-defined.

页首

方法

  名称 说明
公共方法 AsBinaryZM Returns the Elevation and Measure as a binary.
公共方法 AsGml Returns the Geography Markup Language (GML) representation of a SqlGeometry instance.
公共方法 AsTextZM Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeometry instance, augmented with any Z (elevation) and M (measure) values carried by the instance.
公共方法 BufferWithCurves Buffers the geometry objects with curves.
公共方法 BufferWithTolerance Returns a geometric object that represents the union of all point values whose distance from a SqlGeometry instance is less than or equal to a specified value, allowing for a specified tolerance.
公共方法 CurveToLineWithTolerance Returns a polygonal approximation of a SqlGeometry instance that contains circular arc segments.
公共方法静态成员 Deserialize Returns a constructed SqlGeometry from an internal SQL Server format for spatial data.
公共方法 Equals (从 Object 继承。)
公共方法 Filter Offers a fast, index-only intersection method to determine if a SqlGeometry instance intersects another SqlGeometry instance, assuming an index is available.
公共方法静态成员 GeomFromGml Constructs a SqlGeometry instance given a representation in the SQL Server subset of the Geography Markup Language (GML).
公共方法 GetHashCode (从 Object 继承。)
公共方法 GetType (从 Object 继承。)
公共方法 InstanceOf Tests if the SqlGeometry instance is the same as the specified type.
公共方法 IsValidDetailed Returns a message to help identify validity issues with a spatial object.
公共方法 MakeValid Converts an invalid SqlGeometry instance into a SqlGeometry instance with a valid Open Geospatial Consortium (OGC) type.
公共方法 MinDbCompatibilityLevel Returns the minimum database compatibility that accepts the SqlGeometry type.
公共方法静态成员 Parse Returns a SqlGeometry instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation.
公共方法静态成员 Point Constructs a SqlGeometry instance that represents a Point instance from its X and Y values and an SRID.
公共方法 Populate(IGeometrySink) 已过时。Applies a geometry type call sequence to an IGeometrySink object. The call sequence is a sequential set of figures, lines, and points. SqlGeometry
公共方法 Populate(IGeometrySink110) Applies a geometry type call sequence to IGeometrySink object.
公共方法 Read Reads a binary representation of a geometry type into a SqlGeometry object. SqlGeometry
公共方法 Reduce Returns an approximation of the given SqlGeometry instance produced by running the Douglas-Peucker algorithm on the instance with the given tolerance.
公共方法 Serialize Returns the bytes that represent an internal SQL Server format of SqlGeometry type.
公共方法 ShortestLineTo Returns the shortest distance between the two SqlGeometryinstances.
公共方法 STArea Returns the total surface area of a SqlGeometry instance.
公共方法 STAsBinary Returns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a SqlGeometry instance. This value will not contain any Z or M values carried by the instance.
公共方法 STAsText Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeometry instance. This text will not contain any Z (elevation) or M (measure) values carried by the instance.
公共方法 STBoundary Returns the boundary of a SqlGeometry instance.
公共方法 STBuffer Returns a geometric object that represents the union of all points whose distance from a SqlGeometry instance is less than or equal to a specified value.
公共方法 STCentroid Returns the geometric center of a SqlGeometry instance consisting of one or more polygons.
公共方法 STContains Specifies whether the calling SqlGeometry instance completely contains another SqlGeometry.
公共方法 STConvexHull Returns an object that represents the convex hull of a SqlGeometry instance.
公共方法 STCrosses Determines whether the calling SqlGeometry instance crosses the specified SqlGeometry instance.
公共方法 STCurveN Returns the curve specified from a SqlGeometry instance that is a LineString, CircularString, or CompoundCurve.
公共方法 STCurveToLine Returns a polygonal approximation of a SqlGeometry instance that contains circular arc segments.
公共方法 STDifference Returns an object that represents the points from one SqlGeometry instance that do not lie within another SqlGeometry instance.
公共方法 STDimension Returns the maximum dimension of a SqlGeometry instance.
公共方法 STDisjoint Determines whether the calling SqlGeometry instance is disjointed when compared against the specified SqlGeometry.
公共方法 STDistance Returns the shortest distance between a point in a SqlGeometry instance and a point in the specified SqlGeometry instance.
公共方法 STEndPoint Returns the end point of a SqlGeometry instance.
公共方法 STEnvelope Returns the minimum axis-aligned bounding rectangle of the instance.
公共方法 STEquals Determines whether the specified SqlGeometry has a point set identical to the calling SqlGeometry.
公共方法 STExteriorRing Returns the exterior ring of a SqlGeometry instance that is a polygon.
公共方法静态成员 STGeomCollFromText Returns a SqlGeometry 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 SqlGeometry collection instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
公共方法 STGeometryN Returns the specified SqlGeometry in a SqlGeometry collection.
公共方法 STGeometryType Returns the Open Geospatial Consortium (OGC) type name represented by a geometry instance. SqlGeometry
公共方法静态成员 STGeomFromText Returns a SqlGeometry 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 SqlGeometry instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
公共方法 STInteriorRingN Returns the specified interior ring of a Polygon SqlGeometry instance.
公共方法 STIntersection Returns an object that represents the points where a SqlGeometry instance intersects another SqlGeometry instance.
公共方法 STIntersects Determines whether the calling SqlGeometry instance intersects another SqlGeometry.
公共方法 STIsClosed Determines whether the start and end points of the calling SqlGeometry are the same.
公共方法 STIsEmpty Indicates whether the calling SqlGeometry instance is empty.
公共方法 STIsRing Determines whether the calling SqlGeometry instance is a ring.
公共方法 STIsSimple Determines whether the calling SqlGeometry instance is simple.
公共方法 STIsValid Determines whether the SqlGeometry instance is well-formed.
公共方法 STLength Returns the total length of the elements in a SqlGeometry instance.
公共方法静态成员 STLineFromText Returns a SqlGeometry 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 SqlGeometry LineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
公共方法静态成员 STMLineFromText Returns a SqlGeometry 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 SqlGeometry MultiLineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
公共方法静态成员 STMPointFromText Returns a SqlGeometry 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 SqlGeometry Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
公共方法静态成员 STMPolyFromText Returns a SqlGeometry instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation with any Z (elevation) and M (measure) values carried by the instance.
公共方法静态成员 STMPolyFromWKB Returns a SqlGeometry MultiPolygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
公共方法 STNumCurves Returns the number of curves in a one-dimensional SqlGeometry instance.
公共方法 STNumGeometries Returns the number of SqlGeometry that comprise a SqlGeometry instance.
公共方法 STNumInteriorRing Returns the number of interior rings of a Polygon SqlGeometry instance.
公共方法 STNumPoints Returns the sum of the number of points in each of the figures in a SqlGeometry instance.
公共方法 STOverlaps Determines whether the specified SqlGeometry overlaps the current SqlGeometry.
公共方法静态成员 STPointFromText Returns a SqlGeometry 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 SqlGeometry Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
公共方法 STPointN Returns a specified point in a SqlGeometry instance.
公共方法 STPointOnSurface Returns an arbitrary point located within the interior of a SqlGeometry instance.
公共方法静态成员 STPolyFromText Returns a SqlGeometry 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 SqlGeometry Polygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
公共方法 STRelate Determines whether the calling SqlGeometry is related to the specified SqlGeometry.
公共方法 STStartPoint Returns the start point of a SqlGeometry instance.
公共方法 STSymDifference Returns an object that represents all points that are either in one SqlGeometry instance or another SqlGeometry instance, but not those points that lie in both instances.
公共方法 STTouches Determines whether the specified SqlGeometry touches the current SqlGeometry.
公共方法 STUnion Returns an object that represents the union of a SqlGeometry instance with another SqlGeometry instance.
公共方法 STWithin Determines whether the current SqlGeometry is completely within the specified SqlGeometry instance.
公共方法 ToString Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeometry instance augmented with any Z (elevation) and M (measure) values carried by the instance. (覆盖 Object.ToString()。)
公共方法 Write Writes a SqlGeometry instance to a binary stream. SqlGeometry

页首

显式接口实现

  名称 说明
显式接口实现私有方法 ISqlSpatialGridIndexable.BufferForDistanceQuery Returns the buffer for distance query for the SQL Geometry.
显式接口实现私有方法 ISqlSpatialGridIndexable.GetBoundingBoxCorners Returns a value for the bounding box corners for the SQL Geometry.
显式接口实现私有方法 ISqlSpatialGridIndexable.GetGridCoverage Returns the grid coverage of the SQL Geometry.
显式接口实现私有方法 ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Gets the interior buffer for distance query for the SQL Geometry.

页首

注释

SQL Server 2012 supports a set of methods for the geometry spatial data type. These methods include methods on geometry 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 命名空间