SqlGeography 클래스

SQL Server 2012

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

System.Object
  Microsoft.SqlServer.Types.SqlGeography

네임스페이스:  Microsoft.SqlServer.Types
어셈블리:  Microsoft.SqlServer.Types(Microsoft.SqlServer.Types.dll)

[SerializableAttribute]
[SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered = false, 
	MaxByteSize = , IsFixedLength = false)]
[CLSCompliantAttribute(true)]
public sealed class SqlGeography : INullable, 
	IBinarySerialize, ISqlSpatialGridIndexable

SqlGeography 유형에서 다음 멤버를 표시합니다.

  이름설명
공용 메서드SqlGeographyInitializes a new instance of the SqlGeography class.
맨 위로 이동

  이름설명
공용 속성HasMReturns true if at least one point in a spatial object contains value M; otherwise returns false. This property is read-only.
공용 속성HasZReturns true if at least one point in a spatial object contains value Z; otherwise returns false. This property is read-only.
공용 속성IsNullDetermines whether the SqlGeography instance is null.
공용 속성LatReturns the latitude property of the geography instance.
공용 속성LongReturns the longitude property of the geography instance.
공용 속성MReturns the M (measure) value of the geography instance.
공용 속성정적 멤버NullReturns a read-only property providing a null instance of the SqlGeography type.
공용 속성STSridGets or sets id is an integer representing the Spatial Reference Identifier (SRID) of the instance.
공용 속성ZGets the Z (elevation) value of the instance. The semantics of the elevation value are user-defined.
맨 위로 이동

  이름설명
공용 메서드AsBinaryZMReturns 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.
공용 메서드AsGmlReturns the Geography Markup Language (GML) representation of a SqlGeography instance.
공용 메서드AsTextZMReturns 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.
공용 메서드BufferWithCurvesReturns 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.
공용 메서드BufferWithToleranceReturns 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.
공용 메서드CurveToLineWithToleranceReturns a polygonal approximation of a SqlGeography instance that contains circular arc segments.
공용 메서드정적 멤버DeserializeReturns 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.
공용 메서드EnvelopeAngleReturns the maximum angle between the point returned by EnvelopeCenter() and a point in the SqlGeography instance in degrees.
공용 메서드EnvelopeCenterReturns a point that can be used as the center of a bounding circle for the geography instance.
공용 메서드Equals (Object에서 상속됨)
공용 메서드FilterOffers a fast, index-only intersection method to determine if a geography instance intersects another SqlGeography instance, assuming an index is available.
공용 메서드정적 멤버GeomFromGmlConstructs a SqlGeography instance given a representation in the SQL Server subset of the Geography Markup Language (GML).
공용 메서드GetHashCode (Object에서 상속됨)
공용 메서드GetType (Object에서 상속됨)
공용 메서드InstanceOfTests if the SqlGeography instance is the same as the specified type.
공용 메서드IsValidDetailedReturns a message to help identify validity issues with a spatial object.
공용 메서드MakeValidConverts a geography instance that is not valid into a valid geography instance with a valid Open Geospatial Consortium (OGC) type.
공용 메서드MinDbCompatibilityLevelReturns the minimum database compatibility that accepts the SqlGeography type.
공용 메서드NumRingsReturns the total number of rings in a Polygon instance.
공용 메서드정적 멤버ParseReturns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation.
공용 메서드정적 멤버PointConstructs a SqlGeography instance representing a Point instance from its x and y values and a spatial reference ID (SRID).
공용 메서드Populate(IGeographySink) 더 이상 사용되지 않습니다. Applies a geography type call sequence to IGeographySink object. The call sequence is a set of figures, lines, and points for geography types.
공용 메서드Populate(IGeographySink110)Applies a geography type call sequence to IGeographySink object.
공용 메서드ReadReads a binary representation of a geography type into a SqlGeometry object.
공용 메서드ReduceReturns an approximation of the given geography instance produced by running the Douglas-Peucker algorithm on the instance with the given tolerance.
공용 메서드ReorientObjectReturns a geography instance with interchanged interior regions and exterior regions.
공용 메서드RingNReturns the specified ring of the SqlGeography instance: 1 ≤ n ≤ NumRings().
공용 메서드SerializeUsed for sending spatial data across the network.
공용 메서드ShortestLineToReturns the shortest distance between the two SqlGeographyinstances.
공용 메서드STAreaReturns the total surface area of a SqlGeography instance.
공용 메서드STAsBinaryReturns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a SqlGeography instance.
공용 메서드STAsTextReturns the Open Geospatial Consortium (OGC) Well-Known Text (WKT) representation of a SqlGeography instance.
공용 메서드STBufferReturns 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.
공용 메서드STContainsSpecifies whether the calling SqlGeography instance spatially contains the SqlGeography instance passed to the method.
공용 메서드STConvexHullReturns an object that represents the convex hull of a SqlGeography instance.
공용 메서드STCurveNReturns the curve specified from a SqlGeography instance that is a LineString, CircularString, or CompoundCurve.
공용 메서드STCurveToLineReturns a polygonal approximation of a SqlGeography instance that contains circular arc segments.
공용 메서드STDifferenceReturns an object representing the points from one SqlGeography instance that do not lie within another SqlGeography instance.
공용 메서드STDimensionReturns the maximum dimension of a SqlGeography instance
공용 메서드STDisjointDetermines whether the calling SqlGeography instance is spatially disjoint from the specified SqlGeography instance.
공용 메서드STDistanceReturns the shortest distance between a point in a SqlGeography instance and a point in another SqlGeography instance.
공용 메서드STEndPointReturns the end point of a SqlGeography instance.
공용 메서드STEqualsDetermines whether the specified SqlGeography instance has the same point set as the calling SqlGeography instance.
공용 메서드정적 멤버STGeomCollFromTextReturns 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.
공용 메서드정적 멤버STGeomCollFromWKBReturns a GeometryCollection instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
공용 메서드STGeometryNReturns a specified geography element in a GeometryCollection or one of its subtypes.
공용 메서드STGeometryTypeReturns the Open Geospatial Consortium (OGC) type name represented by a geography instance.
공용 메서드정적 멤버STGeomFromTextReturns 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.
공용 메서드정적 멤버STGeomFromWKBReturns a SqlGeography instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
공용 메서드STIntersectionReturns an object representing the points where a SqlGeography instance intersects another SqlGeography instance.
공용 메서드STIntersectsDetermines whether the current SqlGeography instance intersects with the specified SqlGeography.
공용 메서드STIsClosedDetermines whether the calling SqlGeography instance is closed.
공용 메서드STIsEmptyDetermines whether the SqlGeography instance is empty.
공용 메서드STIsValidSpecifies whether a geography instance is well-formed and recognized as a valid geography object based on its Open Geospatial Consortium (OGC) type.
공용 메서드STLengthReturns the total length of the elements in a SqlGeography instance or the SqlGeography instances within a GeometryCollection.
공용 메서드정적 멤버STLineFromTextReturns 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.
공용 메서드정적 멤버STLineFromWKBReturns 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.
공용 메서드정적 멤버STMLineFromTextReturns 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.
공용 메서드정적 멤버STMLineFromWKBReturns a SqlGeography MultiLineString instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
공용 메서드정적 멤버STMPointFromTextReturns 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.
공용 메서드정적 멤버STMPointFromWKBReturns a SqlGeography MultiPoint instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
공용 메서드정적 멤버STMPolyFromTextReturns 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.
공용 메서드정적 멤버STMPolyFromWKBReturns a SqlGeography MultiPolygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
공용 메서드STNumCurvesReturns the number of curves in a one-dimensional SqlGeography instance.
공용 메서드STNumGeometriesReturns the number of geometries that make up a SqlGeography instance.
공용 메서드STNumPointsReturns the total number of points in each of the figures in a SqlGeography instance
공용 메서드STOverlapsReturns 1 if a SqlGeography instance spatially overlaps another SqlGeography instance, or 0 if it does not.
공용 메서드정적 멤버STPointFromTextReturns 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.
공용 메서드정적 멤버STPointFromWKBReturns a SqlGeography Point instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
공용 메서드STPointNReturns the specified point in a SqlGeography instance.
공용 메서드정적 멤버STPolyFromTextReturns 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.
공용 메서드정적 멤버STPolyFromWKBReturns a SqlGeography Polygon instance from an Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation.
공용 메서드STStartPointReturns the start point of a SqlGeography instance.
공용 메서드STSymDifferenceReturns 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.
공용 메서드STUnionReturns an object representing the union of a SqlGeography instance with another SqlGeography instance.
공용 메서드STWithinReturns 1 if a SqlGeography instance is spatially within another SqlGeography instance; otherwise, returns 0.
공용 메서드ToStringReturns 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. (Object.ToString()을(를) 재정의함)
공용 메서드WriteWrites a SqlGeography object to a binary stream.
맨 위로 이동

  이름설명
명시적 인터페이스 구현전용 메서드ISqlSpatialGridIndexable.BufferForDistanceQueryReturns the buffer for distance query for the SQL Geography.
명시적 인터페이스 구현전용 메서드ISqlSpatialGridIndexable.GetBoundingBoxCornersReturns a value for the bounding box corners for the SQL Geography.
명시적 인터페이스 구현전용 메서드ISqlSpatialGridIndexable.GetGridCoverageReturns the grid coverage of the SQL Geography.
명시적 인터페이스 구현전용 메서드ISqlSpatialGridIndexable.InteriorBufferForDistanceQueryGets the interior buffer for distance query for the SQL Geography.
맨 위로 이동

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.

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

커뮤니티 추가 항목

추가
표시: