共用方式為


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 命名空間