The ST_Surface type is a supertype for 2-dimensional geometry types. The ST_Surface type is not instantiable.
Syntax
ST_Surface type
Members
All members of the ST_Surface type, including all inherited members.
Members of ST_Surface:
-
ST_Area(VARCHAR(128)) –
Calculates the area of a surface in the specified units.
-
ST_Centroid() –
Returns the ST_Point value that is the mathematical centroid of the surface value.
-
ST_IsWorld() –
Test if the ST_Surface covers the entire space.
-
ST_Perimeter(VARCHAR(128)) –
Calculates the perimeter of a surface in the specified units.
-
ST_PointOnSurface() –
Returns an ST_Point value that is guaranteed to spatially intersect the ST_Surface value.
Members of ST_Geometry:
-
ST_Affine(DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE, DOUBLE) –
Returns a new geometry that is the result of applying the specified 3-D affine transformation.
-
ST_AsBinary(VARCHAR(128)) –
Returns the WKB representation of an ST_Geometry value.
-
ST_AsBitmap(INT, INT,
ST_Point
,
ST_Point
, VARCHAR(128)) –
Returns a LONG VARBIT that is a bitmap representing a geometry value.
-
ST_AsGeoJSON(VARCHAR(128)) –
Returns a string representing a geometry in JSON format.
-
ST_AsGML(VARCHAR(128)) –
Returns the GML representation of an ST_Geometry value.
-
ST_AsKML(VARCHAR(128)) –
Returns the KML representation of an ST_Geometry value.
-
ST_AsSVG(VARCHAR(128)) –
Returns an SVG figure representing a geometry value.
-
ST_AsSVGAggr(
ST_Geometry
, VARCHAR(128)) –
Returns a complete or partial SVG document which renders the geometries in a group.
-
ST_AsText(VARCHAR(128)) –
Returns the text representation of an ST_Geometry value.
-
ST_AsWKB(VARCHAR(128)) –
Returns the WKB representation of an ST_Geometry value.
-
ST_AsWKT(VARCHAR(128)) –
Returns the WKT representation of an ST_Geometry value.
-
ST_AsXML(VARCHAR(128)) –
Returns the XML representation of an ST_Geometry value.
-
ST_Boundary() –
Returns the boundary of the geometry value.
-
ST_Buffer(DOUBLE, VARCHAR(128)) –
Returns the ST_Geometry value that represents all points whose distance from any point of an ST_Geometry value is less than or equal to a specified distance in the given units.
-
ST_Contains(
ST_Geometry
) –
Tests if a geometry value spatially contains another geometry value.
-
ST_ContainsFilter(
ST_Geometry
) –
An inexpensive test if a geometry might contain another.
-
ST_ConvexHull() –
Returns the convex hull of the geometry value.
-
ST_ConvexHullAggr(
ST_Geometry
) –
Returns the convex hull for all of the geometries in a group
-
ST_CoordDim() –
Returns the number of coordinate dimensions stored with each point of the ST_Geometry value.
-
ST_CoveredBy(
ST_Geometry
) –
Tests if a geometry value is spatially covered by another geometry value.
-
ST_CoveredByFilter(
ST_Geometry
) –
An inexpensive test if a geometry might be covered by another.
-
ST_Covers(
ST_Geometry
) –
Tests if a geometry value spatially covers another geometry value.
-
ST_CoversFilter(
ST_Geometry
) –
An inexpensive test if a geometry might cover another.
-
ST_Crosses(
ST_Geometry
) –
Tests if a geometry value crosses another geometry value.
-
ST_Debug(VARCHAR(128)) –
Returns a LONG BINARY that is debug information for the object.
-
ST_Difference(
ST_Geometry
) –
Returns the geometry value that represents the point set difference of two geometries.
-
ST_Dimension() –
Returns the dimension of the ST_Geometry value. Points have dimension 0, lines have dimension 1, and surfaces have dimension 2. Any empty geometry has dimension -1.
-
ST_Disjoint(
ST_Geometry
) –
Test if a geometry value is spatially disjoint from another value.
-
ST_Distance(
ST_Geometry
, VARCHAR(128)) –
Returns the smallest distance between the geometry-expression and the specified geometry value.
-
ST_Distance_Spheroid(
ST_Geometry
, VARCHAR(128)) –
Calculates the linear distance between geometries on the surface of the Earth.
-
ST_Envelope() –
Returns the bounding rectangle for the geometry value.
-
ST_EnvelopeAggr(
ST_Geometry
) –
Returns the bounding rectangle for all of the geometries in a group
-
ST_Equals(
ST_Geometry
) –
Tests if an ST_Geometry value is spatially equal to another ST_Geometry value.
-
ST_EqualsFilter(
ST_Geometry
) –
An inexpensive test if a geometry is equal to another.
-
ST_GeometryType() –
Returns the name of the type of the ST_Geometry value.
-
ST_GeometryTypeFromBaseType(VARCHAR(128)) –
Parses a string defining the type string.
-
ST_GeomFromBinary(LONG BINARY, INT) –
Constructs a geometry from a binary string representation.
-
ST_GeomFromShape(LONG BINARY[, INT]) –
Parses a string containing an ESRI shape record and creates a geometry value of the appropriate type.
-
ST_GeomFromText(LONG VARCHAR, INT) –
Constructs a geometry from a character string representation.
-
ST_GeomFromWKB(LONG BINARY, INT) –
Parse a string containing a WKB or EWKB representation of a geometry and creates a geometry value of the appropriate type.
-
ST_GeomFromWKT(LONG VARCHAR, INT) –
Parses a string containing the WKT or EWKT representation of a geometry and create a geometry value of the appropriate type.
-
ST_Intersection(
ST_Geometry
) –
Returns the geometry value that represents the point set intersection of two geometries.
-
ST_IntersectionAggr(
ST_Geometry
) –
Returns the spatial intersection of all of the geometries in a group
-
ST_Intersects(
ST_Geometry
) –
Test if a geometry value spatially intersects another value.
-
ST_IntersectsFilter(
ST_Geometry
) –
An inexpensive test if the two geometries might intersect.
-
ST_IntersectsRect(
ST_Point
,
ST_Point
) –
Test if a geometry intersects a rectangle.
-
ST_Is3D() –
Determines if the geometry value has Z coordinate values.
-
ST_IsEmpty() –
Determines whether the geometry value represents an empty set.
-
ST_IsMeasured() –
Determines if the geometry value has associated measure values.
-
ST_IsSimple() –
Determines whether the geometry value is simple (containing no self intersections or other irregularities).
-
ST_IsValid() –
Determines whether the geometry is a valid spatial object.
-
ST_LatNorth() –
Retrieves the northernmost latitude of a geometry.
-
ST_LatSouth() –
Retrieves the southernmost latitude of a geometry.
-
ST_Length_Spheroid(VARCHAR(128)) –
Calculates the linear length of a curve/multicurve on the surface of the Earth.
-
ST_LinearHash() –
Returns a binary string that is a linear hash of the geometry.
-
ST_LinearUnHash(BINARY(32)[, INT]) –
Returns a geometry representing the index hash.
-
ST_LoadConfigurationData(VARCHAR(128)) –
Returns binary configuration data. For internal use only.
-
ST_LocateAlong(DOUBLE) –
Returns the subset of the geometry value that is associated with the given measure value.
-
ST_LocateBetween(DOUBLE, DOUBLE) –
Returns the subset of the geometry value that is between the specified start measure and end measure.
-
ST_LongEast() –
Retrieves the longitude of the eastern boundary of a geometry.
-
ST_LongWest() –
Retrieves the longitude of the western boundary of a geometry.
-
ST_MMax() –
Retrieves the maximum M coordinate value of a geometry.
-
ST_MMin() –
Retrieves the minimum M coordinate value of a geometry.
-
ST_OrderingEquals(
ST_Geometry
) –
Tests if a geometry is identical to another geometry.
-
ST_Overlaps(
ST_Geometry
) –
Tests if a geometry value overlaps another geometry value.
-
ST_Relate(
ST_Geometry
) –
Determines how a geometry value is spatially related to another geometry value by returning an intersection matrix. The ST_Relate method returns a 9-character string from the Dimensionally Extended 9 Intersection Model (DE-9IM) to describe the pair-wise relationship between two spatial data items. For example, the ST_Relate method determines if an intersection occurs between the geometries, and the geometry of the resulting intersection, if it exists.
-
ST_Reverse() –
Returns the geometry with the element order reversed.
-
ST_Segmentize(DOUBLE) –
Add points so that no line segment is longer than a specified distance.
-
ST_Simplify(DOUBLE) –
Remove points from curves so long as the maximum introduced error is less than a specified tolerance.
-
ST_SnapToGrid(
ST_Point
, DOUBLE, DOUBLE, DOUBLE, DOUBLE) –
Returns a copy of the geometry with all points snapped to the specified grid.
-
ST_SRID(INT) –
Changes the spatial reference system associated with the geometry without modifying any of the values.
-
ST_SRIDFromBaseType(VARCHAR(128)) –
Parses a string defining the type string.
-
ST_SymDifference(
ST_Geometry
) –
Returns the geometry value that represents the point set symmetric difference of two geometries.
-
ST_ToCircular() –
Convert the geometry to a circularstring
-
ST_ToCompound() –
Converts the geometry to a compound curve.
-
ST_ToCurve() –
Converts the geometry to a curve.
-
ST_ToCurvePoly() –
Converts the geometry to a curve polygon.
-
ST_ToGeomColl() –
Converts the geometry to a geometry collection.
-
ST_ToLineString() –
Converts the geometry to a linestring.
-
ST_ToMultiCurve() –
Converts the geometry to a multicurve value.
-
ST_ToMultiLine() –
Converts the geometry to a multilinestring value.
-
ST_ToMultiPoint() –
Converts the geometry to a multi-point value.
-
ST_ToMultiPolygon() –
Converts the geometry to a multi-polygon value.
-
ST_ToMultiSurface() –
Converts the geometry to a multi-surface value.
-
ST_ToPoint() –
Converts the geometry to a point.
-
ST_ToPolygon() –
Converts the geometry to a polygon.
-
ST_ToSurface() –
Converts the geometry to a surface.
-
ST_Touches(
ST_Geometry
) –
Tests if a geometry value spatially touches another geometry value.
-
ST_Transform(INT) –
Creates a copy of the geometry value transformed into the specified spatial reference system.
-
ST_Union(
ST_Geometry
) –
Returns the geometry value that represents the point set union of two geometries.
-
ST_UnionAggr(
ST_Geometry
) –
Returns the spatial union of all of the geometries in a group
-
ST_Within(
ST_Geometry
) –
Tests if a geometry value is spatially contained within another geometry value.
-
ST_WithinDistance(
ST_Geometry
, DOUBLE, VARCHAR(128)) –
Test if two geometries are within a specified distance of each other.
-
ST_WithinDistanceFilter(
ST_Geometry
, DOUBLE, VARCHAR(128)) –
An inexpensive of whether two geometries might be within a specified distance of each other.
-
ST_WithinFilter(
ST_Geometry
) –
An inexpensive test if a geometry might be within another.
-
ST_XMax() –
Retrieves the maximum X coordinate value of a geometry.
-
ST_XMin() –
Retrieves the minimum X coordinate value of a geometry.
-
ST_YMax() –
Retrieves the maximum Y coordinate value of a geometry.
-
ST_YMin() –
Retrieves the minimum Y coordinate value of a geometry.
-
ST_ZMax() –
Retrieves the maximum Z coordinate value of a geometry.
-
ST_ZMin() –
Retrieves the minimum Z coordinate value of a geometry.
Standards and compatibility
SQL/MM (ISO/IEC 13249-3: 2006) 8.1