Condividi tramite

Classe SqlGeography

  • Articolo

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

Gerarchia di ereditarietà

System.Object
  Microsoft.SqlServer.Types.SqlGeography

Spazio dei nomi  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Sintassi

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

Nel tipo SqlGeography sono esposti i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico SqlGeography Initializes a new instance of the SqlGeography class.

In alto

Proprietà

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

In alto

Metodi

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

In alto

Implementazioni esplicite dell'interfaccia

  Nome Descrizione
Implementazione esplicita dell'interfacciaMetodo privato ISqlSpatialGridIndexable.BufferForDistanceQuery Returns the buffer for distance query for the SQL Geography.
Implementazione esplicita dell'interfacciaMetodo privato ISqlSpatialGridIndexable.GetBoundingBoxCorners Returns a value for the bounding box corners for the SQL Geography.
Implementazione esplicita dell'interfacciaMetodo privato ISqlSpatialGridIndexable.GetGridCoverage Returns the grid coverage of the SQL Geography.
Implementazione esplicita dell'interfacciaMetodo privato ISqlSpatialGridIndexable.InteriorBufferForDistanceQuery Gets the interior buffer for distance query for the SQL Geography.

In alto

Osservazioni

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.

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.

Vedere anche

Riferimento

Spazio dei nomi Microsoft.SqlServer.Types