Retrieves the maximum X coordinate value of a geometry.
Syntaxgeometry-expression.ST_XMax() ReturnsDOUBLE Returns the maximum X coordinate value of the geometry-expression.
RemarksReturns the maximum X coordinate value of the geometry-expression. This is computed by comparing the X attribute of all points in the geometry.
Note that for geographic spatial reference systems, the returned value corresponds to the first coordinate in the axis order. If the axis order is lat/lon/a/m, the minimum value corresponds to the western boundary of the geometry-expression as returned by ST_LongWest and the maximum value corresponds to the eastern boundary of geometry-expression as returned by ST_LongEast. In round-Earth model, this means that if geometry-expression crosses the date line, the minimum value will be greater than the maximum value. If the axis order is lon/lat/z/m, the minimum value corresponds to southernmost point of geometry-expression as returned by ST_LatSouth and the maximum value corresponds to the northernmost point of geometry-expression as returned by ST_LatNorth.
If the geometry-expression is an empty geometry (ST_IsEmpty()=1), then this method returns NULL.
By default, ST_XMax uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.
See also Standards and compatibilitySQL/MM (ISO/IEC 13249-3: 2006) Vendor extension
ExampleThe following example returns the result 5.
SELECT NEW ST_LineString( 'LineString ZM( 1 2 3 4, 5 6 7 8 )' ).ST_XMax() |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |