InstanceOf (geography Data Type)
Tests if the geography instance is the same as the specified type.
.InstanceOf ( 'geography_type')
Is an nvarchar(4000) string specifying one of 16 types exposed in the geography type hierarchy.
SQL Server return type: bit
CLR return type: SqlBoolean
Returns 1 if the type of a geography instance is the same as the specified type, or if the specified type is an ancestor of the instance type; otherwise, returns 0.
This geography data type method supports FullGlobe instances or spatial instances that are larger than a hemisphere.
The input for the method must be one of the following: Geometry, Point, Curve, LineString,CircularString, Surface, Polygon, CurvePolygon, GeometryCollection, MultiSurface, MultiPolygon, MultiCurve, MultiLineString, MultiPoint, or FullGlobe.
This method throws an
ArgumentException if any other strings are used for the input.
This method is not precise.
The following example creates a
MultiPoint instance and uses
InstanceOf() to see whether the instance is a
DECLARE @g geography; SET @g = geography::STGeomFromText('MULTIPOINT(-122.360 47.656, -122.343 47.656)', 4326); SELECT @g.InstanceOf('GEOMETRYCOLLECTION');