• Artigo

Classe SqlGeography

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

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 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 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 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 EnvelopeAngle Returns the maximum angle between the point returned by the EnvelopeCenter method and a point in the geography 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 protegido Finalize (Herdado de Object.)
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 protegido MemberwiseClone (Herdado de Object.)
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 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 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 RingN Returns the specified ring of the SqlGeography instance: 1 ≤ n ≤ NumRings().
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 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 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 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ú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 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

Comentários

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.

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