Condividi tramite

Classe SqlGeometry

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

Gerarchia di ereditarietà

System.Object
  Microsoft.SqlServer.Types.SqlGeometry

Spazio dei nomi  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Sintassi

'Dichiarazione
<SerializableAttribute> _
<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered := False,  _
    MaxByteSize := , IsFixedLength := False)> _
<CLSCompliantAttribute(True)> _
Public NotInheritable Class SqlGeometry _
    Implements INullable, IBinarySerialize, ISqlSpatialGridIndexable
'Utilizzo
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

Nel tipo SqlGeometry sono esposti i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico SqlGeometry Initializes a new instance of the SqlGeometry class.

In alto

Proprietà

  Nome Descrizione
Proprietà pubblica HasM Returns true if at least one point in a spatial object contains value M; otherwise returns false. This property is read-only.
Proprietà pubblica HasZ Returns true if at least one point in a spatial object contains value Z; otherwise returns false. This property is read-only.
Proprietà pubblica IsNull Gets a value that indicates whether the SqlGeometry object is null.
Proprietà pubblica M Gets the M (measure) value of the SqlGeometry instance. The semantics of the measure value are user-defined.
Proprietà pubblicaMembro statico Null Gets a read-only property providing a null instance of the SqlGeometry type.
Proprietà pubblica STSrid Gets or sets an integer that represents the Spatial Reference Identifier (SRID) of the instance.
Proprietà pubblica STX Gets the X-coordinate property of a Point instance.
Proprietà pubblica STY Gets the Y-coordinate property of a Point instance.
Proprietà pubblica Z Gets the Z (elevation) value of the instance. The semantics of the elevation value are user-defined.

In alto

Metodi

  Nome Descrizione
Metodo pubblico AsBinaryZM Returns the Elevation and Measure as a binary.
Metodo pubblico AsGml Returns the Geography Markup Language (GML) representation of a SqlGeometry instance.
Metodo pubblico 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.
Metodo pubblico BufferWithCurves Buffers the geometry objects with curves.
Metodo pubblico 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.
Metodo pubblico CurveToLineWithTolerance Returns a polygonal approximation of a SqlGeometry instance that contains circular arc segments.
Metodo pubblicoMembro statico Deserialize Returns a constructed SqlGeometry from an internal SQL Server format for spatial data.
Metodo pubblico Equals Ereditato da Object.
Metodo pubblico Filter Offers a fast, index-only intersection method to determine if a SqlGeometry instance intersects another SqlGeometry instance, assuming an index is available.
Metodo pubblicoMembro statico GeomFromGml Constructs a SqlGeometry instance given a representation in the SQL Server subset of the Geography Markup Language (GML).
Metodo pubblico GetHashCode Ereditato da Object.
Metodo pubblico GetType Ereditato da Object.
Metodo pubblico InstanceOf Tests if the SqlGeometry instance is the same as the specified type.
Metodo pubblico IsValidDetailed Returns a message to help identify validity issues with a spatial object.
Metodo pubblico MakeValid Converts an invalid SqlGeometry instance into a SqlGeometry instance with a valid Open Geospatial Consortium (OGC) type.
Metodo pubblico MinDbCompatibilityLevel Returns the minimum database compatibility that accepts the SqlGeometry type.
Metodo pubblicoMembro statico Parse Returns a SqlGeometry instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation.
Metodo pubblicoMembro statico Point Constructs a SqlGeometry instance that represents a Point instance from its X and Y values and an SRID.
Metodo pubblico Populate(IGeometrySink) Obsoleto. Applies a geometry type call sequence to an IGeometrySink object. The call sequence is a sequential set of figures, lines, and points. SqlGeometry
Metodo pubblico Populate(IGeometrySink110) Applies a geometry type call sequence to IGeometrySink object.
Metodo pubblico Read Reads a binary representation of a geometry type into a SqlGeometry object. SqlGeometry
Metodo pubblico Reduce Returns an approximation of the given SqlGeometry instance produced by running the Douglas-Peucker algorithm on the instance with the given tolerance.
Metodo pubblico Serialize Returns the bytes that represent an internal SQL Server format of SqlGeometry type.
Metodo pubblico ShortestLineTo Returns the shortest distance between the two SqlGeometryinstances.
Metodo pubblico STArea Returns the total surface area of a SqlGeometry instance.
Metodo pubblico 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.
Metodo pubblico 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.
Metodo pubblico STBoundary Returns the boundary of a SqlGeometry instance.
Metodo pubblico 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.
Metodo pubblico STCentroid Returns the geometric center of a SqlGeometry instance consisting of one or more polygons.
Metodo pubblico STContains Specifies whether the calling SqlGeometry instance completely contains another SqlGeometry.
Metodo pubblico STConvexHull Returns an object that represents the convex hull of a SqlGeometry instance.
Metodo pubblico STCrosses Determines whether the calling SqlGeometry instance crosses the specified SqlGeometry instance.
Metodo pubblico STCurveN Returns the curve specified from a SqlGeometry instance that is a LineString, CircularString, or CompoundCurve.
Metodo pubblico STCurveToLine Returns a polygonal approximation of a SqlGeometry instance that contains circular arc segments.
Metodo pubblico STDifference Returns an object that represents the points from one SqlGeometry instance that do not lie within another SqlGeometry instance.
Metodo pubblico STDimension Returns the maximum dimension of a SqlGeometry instance.
Metodo pubblico STDisjoint Determines whether the calling SqlGeometry instance is disjointed when compared against the specified SqlGeometry.
Metodo pubblico STDistance Returns the shortest distance between a point in a SqlGeometry instance and a point in the specified SqlGeometry instance.
Metodo pubblico STEndPoint Returns the end point of a SqlGeometry instance.
Metodo pubblico STEnvelope Returns the minimum axis-aligned bounding rectangle of the instance.
Metodo pubblico STEquals Determines whether the specified SqlGeometry has a point set identical to the calling SqlGeometry.
Metodo pubblico STExteriorRing Returns the exterior ring of a SqlGeometry instance that is a polygon.
Metodo pubblicoMembro statico 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.
Metodo pubblicoMembro statico STGeomCollFromWKB Returns a SqlGeometry collection instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Metodo pubblico STGeometryN Returns the specified SqlGeometry in a SqlGeometry collection.
Metodo pubblico STGeometryType Returns the Open Geospatial Consortium (OGC) type name represented by a geometry instance. SqlGeometry
Metodo pubblicoMembro statico 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.
Metodo pubblicoMembro statico STGeomFromWKB Returns a SqlGeometry instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Metodo pubblico STInteriorRingN Returns the specified interior ring of a Polygon SqlGeometry instance.
Metodo pubblico STIntersection Returns an object that represents the points where a SqlGeometry instance intersects another SqlGeometry instance.
Metodo pubblico STIntersects Determines whether the calling SqlGeometry instance intersects another SqlGeometry.
Metodo pubblico STIsClosed Determines whether the start and end points of the calling SqlGeometry are the same.
Metodo pubblico STIsEmpty Indicates whether the calling SqlGeometry instance is empty.
Metodo pubblico STIsRing Determines whether the calling SqlGeometry instance is a ring.
Metodo pubblico STIsSimple Determines whether the calling SqlGeometry instance is simple.
Metodo pubblico STIsValid Determines whether the SqlGeometry instance is well-formed.
Metodo pubblico STLength Returns the total length of the elements in a SqlGeometry instance.
Metodo pubblicoMembro statico 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.
Metodo pubblicoMembro statico STLineFromWKB Returns a SqlGeometry LineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Metodo pubblicoMembro statico 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.
Metodo pubblicoMembro statico STMLineFromWKB Returns a SqlGeometry MultiLineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Metodo pubblicoMembro statico 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.
Metodo pubblicoMembro statico STMPointFromWKB Returns a SqlGeometry Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Metodo pubblicoMembro statico 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.
Metodo pubblicoMembro statico STMPolyFromWKB Returns a SqlGeometry MultiPolygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Metodo pubblico STNumCurves Returns the number of curves in a one-dimensional SqlGeometry instance.
Metodo pubblico STNumGeometries Returns the number of SqlGeometry that comprise a SqlGeometry instance.
Metodo pubblico STNumInteriorRing Returns the number of interior rings of a Polygon SqlGeometry instance.
Metodo pubblico STNumPoints Returns the sum of the number of points in each of the figures in a SqlGeometry instance.
Metodo pubblico STOverlaps Determines whether the specified SqlGeometry overlaps the current SqlGeometry.
Metodo pubblicoMembro statico 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.
Metodo pubblicoMembro statico STPointFromWKB Returns a SqlGeometry Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Metodo pubblico STPointN Returns a specified point in a SqlGeometry instance.
Metodo pubblico STPointOnSurface Returns an arbitrary point located within the interior of a SqlGeometry instance.
Metodo pubblicoMembro statico 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.
Metodo pubblicoMembro statico STPolyFromWKB Returns a SqlGeometry Polygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Metodo pubblico STRelate Determines whether the calling SqlGeometry is related to the specified SqlGeometry.
Metodo pubblico STStartPoint Returns the start point of a SqlGeometry instance.
Metodo pubblico 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.
Metodo pubblico STTouches Determines whether the specified SqlGeometry touches the current SqlGeometry.
Metodo pubblico STUnion Returns an object that represents the union of a SqlGeometry instance with another SqlGeometry instance.
Metodo pubblico STWithin Determines whether the current SqlGeometry is completely within the specified SqlGeometry instance.
Metodo pubblico 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. Esegue l'override di Object.ToString().
Metodo pubblico Write Writes a SqlGeometry instance to a binary stream. SqlGeometry

In alto

Implementazioni esplicite dell'interfaccia

  Nome Descrizione
Implementazione esplicita dell'interfacciaMetodo privato ISqlSpatialGridIndexable.BufferForDistanceQuery Returns the buffer for distance query for the SQL Geometry.
Implementazione esplicita dell'interfacciaMetodo privato ISqlSpatialGridIndexable.GetBoundingBoxCorners Returns a value for the bounding box corners for the SQL Geometry.
Implementazione esplicita dell'interfacciaMetodo privato ISqlSpatialGridIndexable.GetGridCoverage Returns the grid coverage of the SQL Geometry.
Implementazione esplicita dell'interfacciaMetodo privato ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Gets the interior buffer for distance query for the SQL Geometry.

In alto

Osservazioni

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.

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Types

  • Last updated on