Compartir a través de

Clase SqlGeometry

  • Artículo

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

Jerarquía de herencia

System.Object
  Microsoft.SqlServer.Types.SqlGeometry

Espacio de nombres:  Microsoft.SqlServer.Types
Ensamblado:  Microsoft.SqlServer.Types (en Microsoft.SqlServer.Types.dll)

Sintaxis

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

El tipo SqlGeometry expone los siguientes miembros.

Constructores

  Nombre Descripción
Método público SqlGeometry Initializes a new instance of the SqlGeometry class.

Arriba

Propiedades

  Nombre Descripción
Propiedad pública HasM Returns true if at least one point in a spatial object contains value M; otherwise returns false. This property is read-only.
Propiedad pública HasZ Returns true if at least one point in a spatial object contains value Z; otherwise returns false. This property is read-only.
Propiedad pública IsNull Gets a value that indicates whether the SqlGeometry object is null.
Propiedad pública M Gets the M (measure) value of the SqlGeometry instance. The semantics of the measure value are user-defined.
Propiedad públicaMiembro estático Null Gets a read-only property providing a null instance of the SqlGeometry type.
Propiedad pública STSrid Gets or sets an integer that represents the Spatial Reference Identifier (SRID) of the instance.
Propiedad pública STX Gets the X-coordinate property of a Point instance.
Propiedad pública STY Gets the Y-coordinate property of a Point instance.
Propiedad pública Z Gets the Z (elevation) value of the instance. The semantics of the elevation value are user-defined.

Arriba

Métodos

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

Arriba

Implementaciones de interfaces explícitas

  Nombre Descripción
Implementación de interfaces explícitasMétodo privado ISqlSpatialGridIndexable.BufferForDistanceQuery Returns the buffer for distance query for the SQL Geometry.
Implementación de interfaces explícitasMétodo privado ISqlSpatialGridIndexable.GetBoundingBoxCorners Returns a value for the bounding box corners for the SQL Geometry.
Implementación de interfaces explícitasMétodo privado ISqlSpatialGridIndexable.GetGridCoverage Returns the grid coverage of the SQL Geometry.
Implementación de interfaces explícitasMétodo privado ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Gets the interior buffer for distance query for the SQL Geometry.

Arriba

Comentarios

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.

Seguridad para subprocesos

Cualquier miembro público static (Shared en Visual Basic) de este tipo es seguro para subprocesos. No se garantiza que los miembros de instancia sean seguros para subprocesos.

Vea también

Referencia

Espacio de nombres Microsoft.SqlServer.Types