Partager via

Classe SqlGeography

  • Article

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

Hiérarchie d'héritage

System.Object
  Microsoft.SqlServer.Types.SqlGeography

Espace de noms :  Microsoft.SqlServer.Types
Assembly :  Microsoft.SqlServer.Types (en Microsoft.SqlServer.Types.dll)

Syntaxe

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

Le type SqlGeography expose les membres suivants.

Constructeurs

  Nom Description
Méthode publique SqlGeography Initializes a new instance of the SqlGeography class.

Haut de la page

Propriétés

  Nom Description
Propriété publique HasM Returns true if at least one point in a spatial object contains value M; otherwise returns false. This property is read-only.
Propriété publique HasZ Returns true if at least one point in a spatial object contains value Z; otherwise returns false. This property is read-only.
Propriété publique IsNull Determines whether the SqlGeography instance is null.
Propriété publique Lat Returns the latitude property of the geography instance.
Propriété publique Long Returns the longitude property of the geography instance.
Propriété publique M Returns the M (measure) value of the geography instance.
Propriété publiqueMembre statique Null Returns a read-only property providing a null instance of the SqlGeography type.
Propriété publique STSrid Gets or sets id is an integer representing the Spatial Reference Identifier (SRID) of the instance.
Propriété publique Z Gets the Z (elevation) value of the instance. The semantics of the elevation value are user-defined.

Haut de la page

Méthodes

  Nom Description
Méthode publique 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.
Méthode publique AsGml Returns the Geography Markup Language (GML) representation of a SqlGeography instance.
Méthode publique 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.
Méthode publique 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.
Méthode publique 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.
Méthode publique CurveToLineWithTolerance Returns a polygonal approximation of a SqlGeography instance that contains circular arc segments.
Méthode publiqueMembre statique 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.
Méthode publique EnvelopeAngle Returns the maximum angle between the point returned by EnvelopeCenter() and a point in the SqlGeography instance in degrees.
Méthode publique EnvelopeCenter Returns a point that can be used as the center of a bounding circle for the geography instance.
Méthode publique Equals (hérité de Object.)
Méthode publique Filter Offers a fast, index-only intersection method to determine if a geography instance intersects another SqlGeography instance, assuming an index is available.
Méthode publiqueMembre statique GeomFromGml Constructs a SqlGeography instance given a representation in the SQL Server subset of the Geography Markup Language (GML).
Méthode publique GetHashCode (hérité de Object.)
Méthode publique GetType (hérité de Object.)
Méthode publique InstanceOf Tests if the SqlGeography instance is the same as the specified type.
Méthode publique IsValidDetailed Returns a message to help identify validity issues with a spatial object.
Méthode publique MakeValid Converts a geography instance that is not valid into a valid geography instance with a valid Open Geospatial Consortium (OGC) type.
Méthode publique MinDbCompatibilityLevel Returns the minimum database compatibility that accepts the SqlGeography type.
Méthode publique NumRings Returns the total number of rings in a Polygon instance.
Méthode publiqueMembre statique Parse Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation.
Méthode publiqueMembre statique Point Constructs a SqlGeography instance representing a Point instance from its x and y values and a spatial reference ID (SRID).
Méthode publique Populate(IGeographySink) Obsolète. Applies a geography type call sequence to IGeographySink object. The call sequence is a set of figures, lines, and points for geography types.
Méthode publique Populate(IGeographySink110) Applies a geography type call sequence to IGeographySink object.
Méthode publique Read Reads a binary representation of a geography type into a SqlGeometry object.
Méthode publique Reduce Returns an approximation of the given geography instance produced by running the Douglas-Peucker algorithm on the instance with the given tolerance.
Méthode publique ReorientObject Returns a geography instance with interchanged interior regions and exterior regions.
Méthode publique RingN Returns the specified ring of the SqlGeography instance: 1 ≤ n ≤ NumRings().
Méthode publique Serialize Used for sending spatial data across the network.
Méthode publique ShortestLineTo Returns the shortest distance between the two SqlGeographyinstances.
Méthode publique STArea Returns the total surface area of a SqlGeography instance.
Méthode publique STAsBinary Returns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a SqlGeography instance.
Méthode publique STAsText Returns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeography instance.
Méthode publique 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.
Méthode publique STContains Specifies whether the calling SqlGeography instance spatially contains the SqlGeography instance passed to the method.
Méthode publique STConvexHull Returns an object that represents the convex hull of a SqlGeography instance.
Méthode publique STCurveN Returns the curve specified from a SqlGeography instance that is a LineString, CircularString, or CompoundCurve.
Méthode publique STCurveToLine Returns a polygonal approximation of a SqlGeography instance that contains circular arc segments.
Méthode publique STDifference Returns an object representing the points from one SqlGeography instance that do not lie within another SqlGeography instance.
Méthode publique STDimension Returns the maximum dimension of a SqlGeography instance
Méthode publique STDisjoint Determines whether the calling SqlGeography instance is spatially disjoint from the specified SqlGeography instance.
Méthode publique STDistance Returns the shortest distance between a point in a SqlGeography instance and a point in another SqlGeography instance.
Méthode publique STEndPoint Returns the end point of a SqlGeography instance.
Méthode publique STEquals Determines whether the specified SqlGeography instance has the same point set as the calling SqlGeography instance.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique STGeomCollFromWKB Returns a GeometryCollection instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Méthode publique STGeometryN Returns a specified geography element in a GeometryCollection or one of its subtypes.
Méthode publique STGeometryType Returns the Open Geospatial Consortium (OGC) type name represented by a geography instance.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique STGeomFromWKB Returns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Méthode publique STIntersection Returns an object representing the points where a SqlGeography instance intersects another SqlGeography instance.
Méthode publique STIntersects Determines whether the current SqlGeography instance intersects with the specified SqlGeography.
Méthode publique STIsClosed Determines whether the calling SqlGeography instance is closed.
Méthode publique STIsEmpty Determines whether the SqlGeography instance is empty.
Méthode publique STIsValid Specifies whether a geography instance is well-formed and recognized as a valid geography object based on its Open Geospatial Consortium (OGC) type.
Méthode publique STLength Returns the total length of the elements in a SqlGeography instance or the SqlGeography instances within a GeometryCollection.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique STMLineFromWKB Returns a SqlGeography MultiLineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique STMPointFromWKB Returns a SqlGeography MultiPoint instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique STMPolyFromWKB Returns a SqlGeography MultiPolygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Méthode publique STNumCurves Returns the number of curves in a one-dimensional SqlGeography instance.
Méthode publique STNumGeometries Returns the number of geometries that make up a SqlGeography instance.
Méthode publique STNumPoints Returns the total number of points in each of the figures in a SqlGeography instance
Méthode publique STOverlaps Returns 1 if a SqlGeography instance spatially overlaps another SqlGeography instance, or 0 if it does not.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique STPointFromWKB Returns a SqlGeography Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Méthode publique STPointN Returns the specified point in a SqlGeography instance.
Méthode publiqueMembre statique 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.
Méthode publiqueMembre statique STPolyFromWKB Returns a SqlGeography Polygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
Méthode publique STStartPoint Returns the start point of a SqlGeography instance.
Méthode publique 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.
Méthode publique STUnion Returns an object representing the union of a SqlGeography instance with another SqlGeography instance.
Méthode publique STWithin Returns 1 if a SqlGeography instance is spatially within another SqlGeography instance; otherwise, returns 0.
Méthode publique 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. (remplace Object.ToString().)
Méthode publique Write Writes a SqlGeography object to a binary stream.

Haut de la page

Implémentations d'interfaces explicites

  Nom Description
Implémentation d'interface expliciteMéthode privée ISqlSpatialGridIndexable.BufferForDistanceQuery Returns the buffer for distance query for the SQL Geography.
Implémentation d'interface expliciteMéthode privée ISqlSpatialGridIndexable.GetBoundingBoxCorners Returns a value for the bounding box corners for the SQL Geography.
Implémentation d'interface expliciteMéthode privée ISqlSpatialGridIndexable.GetGridCoverage Returns the grid coverage of the SQL Geography.
Implémentation d'interface expliciteMéthode privée ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Gets the interior buffer for distance query for the SQL Geography.

Haut de la page

Notes

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.

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.

Voir aussi

Référence

Espace de noms Microsoft.SqlServer.Types