Поделиться через

Класс 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> _
<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered := False,  _
    MaxByteSize := , IsFixedLength := False)> _
<CLSCompliantAttribute(True)> _
Public NotInheritable Class SqlGeography _
    Implements INullable, IBinarySerialize, ISqlSpatialGridIndexable
'Применение
Dim instance As SqlGeography

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

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

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

public final class SqlGeography implements INullable, IBinarySerialize, ISqlSpatialGridIndexable

Тип SqlGeography обеспечивает доступ к следующим элементам.

Конструкторы

  Имя Описание
Открытый метод SqlGeography Initializes a new instance of the SqlGeography 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 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.

В начало

Методы

  Имя Описание
Открытый метод AsBinaryZM Returns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a SqlGeography instance augmented with any Z (elevation) and M (measure) values carried by the instance.
Открытый метод 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.
Открытый метод BufferWithCurves Returns a SqlGeography instance that represents the set of all points whose distance from the calling SqlGeography instance is less than or equal to the distance parameter.
Открытый метод 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.
Открытый метод CurveToLineWithTolerance Returns a polygonal approximation of a SqlGeography instance that contains circular arc segments.
Открытый методСтатический элемент Deserialize Returns a constructed SqlGeometry from an internal SQL Server format for spatial data. Can be used for sending spatial data over the network or reading them from files.
Открытый метод EnvelopeAngle Returns the maximum angle between the point returned by EnvelopeCenter() and a point in the SqlGeography 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.
Открытый методСтатический элемент 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.
Открытый метод IsValidDetailed Returns a message to help identify validity issues with a spatial object.
Открытый метод MakeValid Converts a geography instance that is not valid into a valid geography instance with a valid Open Geospatial Consortium (OGC) type.
Открытый метод MinDbCompatibilityLevel Returns the minimum database compatibility that accepts the SqlGeography type.
Открытый метод 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(IGeographySink) Устарело. Applies a geography type call sequence to IGeographySink object. The call sequence is a set of figures, lines, and points for geography types.
Открытый метод Populate(IGeographySink110) Applies a geography type call sequence to IGeographySink object.
Открытый метод 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.
Открытый метод ReorientObject Returns a geography instance with interchanged interior regions and exterior regions.
Открытый метод RingN Returns the specified ring of the SqlGeography instance: 1 ≤ n ≤ NumRings().
Открытый метод Serialize Used for sending spatial data across the network.
Открытый метод ShortestLineTo Returns the shortest distance between the two SqlGeographyinstances.
Открытый метод 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.
Открытый метод STContains Specifies whether the calling SqlGeography instance spatially contains the SqlGeography instance passed to the method.
Открытый метод STConvexHull Returns an object that represents the convex hull of a SqlGeography instance.
Открытый метод STCurveN Returns the curve specified from a SqlGeography instance that is a LineString, CircularString, or CompoundCurve.
Открытый метод STCurveToLine Returns a polygonal approximation of a SqlGeography instance that contains circular arc segments.
Открытый метод 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.
Открытый метод STIsValid Specifies whether a geography instance is well-formed and recognized as a valid geography object based on its Open Geospatial Consortium (OGC) type.
Открытый метод 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.
Открытый метод STNumCurves Returns the number of curves in a one-dimensional SqlGeography instance.
Открытый метод 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
Открытый метод STOverlaps Returns 1 if a SqlGeography instance spatially overlaps another SqlGeography instance, or 0 if it does not.
Открытый методСтатический элемент 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.
Открытый метод STWithin Returns 1 if a SqlGeography instance is spatially within another SqlGeography instance; otherwise, returns 0.
Открытый метод 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.

В начало

Явные реализации интерфейса

  Имя Описание
Явная реализация интерфейсаЗакрытый метод ISqlSpatialGridIndexable.BufferForDistanceQuery Returns the buffer for distance query for the SQL Geography.
Явная реализация интерфейсаЗакрытый метод ISqlSpatialGridIndexable.GetBoundingBoxCorners Returns a value for the bounding box corners for the SQL Geography.
Явная реализация интерфейсаЗакрытый метод ISqlSpatialGridIndexable.GetGridCoverage Returns the grid coverage of the SQL Geography.
Явная реализация интерфейсаЗакрытый метод ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Gets the interior buffer for distance query for the SQL Geography.

В начало

Замечания

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

Безопасность многопоточности

Любые открытые статический (Shared в Visual Basic) элементы этого типа потокобезопасны. Потокобезопасность с элементами экземпляров не гарантируется.

См. также

Справочник

Пространство имен Microsoft.SqlServer.Types