Partilhar via

Classe SqlGeography

  • Artigo

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

Hierarquia de herança

System.Object
  Microsoft.SqlServer.Types.SqlGeography

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

Sintaxe

'Declaração
<SerializableAttribute> _
<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered := False,  _
    MaxByteSize := , IsFixedLength := False)> _
<CLSCompliantAttribute(True)> _
Public NotInheritable Class SqlGeography _
    Implements INullable, IBinarySerialize, ISqlSpatialGridIndexable
'Uso
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

O tipo SqlGeography expõe os membros a seguir.

Construtores

  Nome Descrição
Método público SqlGeography Initializes a new instance of the SqlGeography class.

Início

Propriedades

  Nome Descrição
Propriedade 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.
Propriedade 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.
Propriedade pública IsNull Determines whether the SqlGeography instance is null.
Propriedade pública Lat Returns the latitude property of the geography instance.
Propriedade pública Long Returns the longitude property of the geography instance.
Propriedade pública M Returns the M (measure) value of the geography instance.
Propriedade públicaMembro estático Null Returns a read-only property providing a null instance of the SqlGeography type.
Propriedade pública STSrid Gets or sets id is an integer representing the Spatial Reference Identifier (SRID) of the instance.
Propriedade pública Z Gets the Z (elevation) value of the instance. The semantics of the elevation value are user-defined.

Início

Métodos

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

Início

Implementações de interfaces explícitas

  Nome Descrição
Implementações de interfaces explícitasMétodo privado ISqlSpatialGridIndexable.BufferForDistanceQuery Returns the buffer for distance query for the SQL Geography.
Implementações de interfaces explícitasMétodo privado ISqlSpatialGridIndexable.GetBoundingBoxCorners Returns a value for the bounding box corners for the SQL Geography.
Implementações de interfaces explícitasMétodo privado ISqlSpatialGridIndexable.GetGridCoverage Returns the grid coverage of the SQL Geography.
Implementações de interfaces explícitasMétodo privado ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Gets the interior buffer for distance query for the SQL Geography.

Início

Comentários

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.

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.

Consulte também

Referência

Namespace Microsoft.SqlServer.Types