Freigeben über


SqlGeography-Klasse

The SqlGeography type represents data in a geodetic (round earth) coordinate system.

Vererbungshierarchie

System. . :: . .Object
  Microsoft.SqlServer.Types..::..SqlGeography

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Syntax

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

Der SqlGeography-Typ macht folgende Elemente verfügbar.

Konstruktoren

  Name Beschreibung
Öffentliche Methode SqlGeography Initializes a new instance of the SqlGeography class.

Zum Anfang

Eigenschaften

  Name Beschreibung
Öffentliche Eigenschaft IsNull Determines whether the SqlGeography instance is null.
Öffentliche Eigenschaft Lat Returns the latitude property of the geography instance.
Öffentliche Eigenschaft Long Returns the longitude property of the geography instance.
Öffentliche Eigenschaft M Returns the M (measure) value of the geography instance.
Öffentliche EigenschaftStatisches Element Null Returns a read-only property providing a null instance of the SqlGeography type.
Öffentliche Eigenschaft STSrid Gets or sets id is an integer representing the Spatial Reference Identifier (SRID) of the instance.
Öffentliche Eigenschaft Z Gets the Z (elevation) value of the instance. The semantics of the elevation value are user-defined.

Zum Anfang

Methoden

  Name Beschreibung
Öffentliche Methode AsGml Returns the Geography Markup Language (GML) representation of a SqlGeography instance.
Öffentliche Methode 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.
Öffentliche Methode 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.
Öffentliche Methode EnvelopeAngle Returns the maximum angle between the point returned by the EnvelopeCenter method and a point in the geography instance in degrees.
Öffentliche Methode EnvelopeCenter Returns a point that can be used as the center of a bounding circle for the geography instance.
Öffentliche Methode Equals (Geerbt von Object.)
Öffentliche Methode Filter Offers a fast, index-only intersection method to determine if a geography instance intersects another SqlGeography instance, assuming an index is available.
Geschützte Methode Finalize (Geerbt von Object.)
Öffentliche MethodeStatisches Element GeomFromGml Constructs a SqlGeography instance given a representation in the SQL Server subset of the Geography Markup Language (GML).
Öffentliche Methode GetHashCode (Geerbt von Object.)
Öffentliche Methode GetType (Geerbt von Object.)
Öffentliche Methode InstanceOf Tests if the SqlGeography instance is the same as the specified type.
Geschützte Methode MemberwiseClone (Geerbt von Object.)
Öffentliche Methode NumRings Returns the total number of rings in a Polygon instance.
Öffentliche MethodeStatisches Element Parse Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation.
Öffentliche MethodeStatisches Element Point Constructs a SqlGeography instance representing a Point instance from its x and y values and a spatial reference ID (SRID).
Öffentliche Methode Populate Applies a geography type call sequence to IGeographySink object. The call sequence is a set of figures, lines, and points for geography types.
Öffentliche Methode Read Reads a binary representation of a geography type into a SqlGeometry object.
Öffentliche Methode Reduce Returns an approximation of the given geography instance produced by running the Douglas-Peucker algorithm on the instance with the given tolerance.
Öffentliche Methode RingN Returns the specified ring of the SqlGeography instance: 1 ≤ n ≤ NumRings().
Öffentliche Methode STArea Returns the total surface area of a SqlGeography instance.
Öffentliche Methode STAsBinary Returns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a SqlGeography instance.
Öffentliche Methode STAsText Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeography instance.
Öffentliche Methode 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.
Öffentliche Methode STDifference Returns an object representing the points from one SqlGeography instance that do not lie within another SqlGeography instance.
Öffentliche Methode STDimension Returns the maximum dimension of a SqlGeography instance
Öffentliche Methode STDisjoint Determines whether the calling SqlGeography instance is spatially disjoint from the specified SqlGeography instance.
Öffentliche Methode STDistance Returns the shortest distance between a point in a SqlGeography instance and a point in another SqlGeography instance.
Öffentliche Methode STEndPoint Returns the end point of a SqlGeography instance.
Öffentliche Methode STEquals Determines whether the specified SqlGeography instance has the same point set as the calling SqlGeography instance.
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element STGeomCollFromWKB Returns a GeometryCollection instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Öffentliche Methode STGeometryN Returns a specified geography element in a GeometryCollection or one of its subtypes.
Öffentliche Methode STGeometryType Returns the Open Geospatial Consortium (OGC) type name represented by a geography instance.
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element STGeomFromWKB Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Öffentliche Methode STIntersection Returns an object representing the points where a SqlGeography instance intersects another SqlGeography instance.
Öffentliche Methode STIntersects Determines whether the current SqlGeography instance intersects with the specified SqlGeography.
Öffentliche Methode STIsClosed Determines whether the calling SqlGeography instance is closed.
Öffentliche Methode STIsEmpty Determines whether the SqlGeography instance is empty.
Öffentliche Methode STLength Returns the total length of the elements in a SqlGeography instance or the SqlGeography instances within a GeometryCollection.
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element STMLineFromWKB Returns a SqlGeography MultiLineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element STMPointFromWKB Returns a SqlGeography MultiPoint instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element STMPolyFromWKB Returns a SqlGeography MultiPolygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Öffentliche Methode STNumGeometries Returns the number of geometries that make up a SqlGeography instance.
Öffentliche Methode STNumPoints Returns the total number of points in each of the figures in a SqlGeography instance
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element STPointFromWKB Returns a SqlGeography Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Öffentliche Methode STPointN Returns the specified point in a SqlGeography instance.
Öffentliche MethodeStatisches Element 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.
Öffentliche MethodeStatisches Element STPolyFromWKB Returns a SqlGeography Polygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Öffentliche Methode STStartPoint Returns the start point of a SqlGeography instance.
Öffentliche Methode 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.
Öffentliche Methode STUnion Returns an object representing the union of a SqlGeography instance with another SqlGeography instance.
Öffentliche Methode 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. (Überschreibt Object. . :: . .ToString() () () ().)
Öffentliche Methode Write Writes a SqlGeography object to a binary stream.

Zum Anfang

Hinweise

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

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.