ES|QL ST_XMAX function
point-
Expression of type
geo_point,geo_shape,cartesian_pointorcartesian_shape. Ifnull, the function returnsnull.
Extracts the maximum value of the x coordinates from the supplied geometry. If the geometry is of type geo_point or geo_shape this is equivalent to extracting the maximum longitude value.
| point | result |
|---|---|
| cartesian_point | double |
| cartesian_shape | double |
| geo_point | double |
| geo_shape | double |
FROM airport_city_boundaries
| WHERE abbrev == "CPH"
| EVAL envelope = ST_ENVELOPE(city_boundary)
| EVAL xmin = ST_XMIN(envelope), xmax = ST_XMAX(envelope), ymin = ST_YMIN(envelope), ymax = ST_YMAX(envelope)
| KEEP abbrev, airport, xmin, xmax, ymin, ymax
| abbrev:keyword | airport:text | xmin:double | xmax:double | ymin:double | ymax:double |
|---|---|---|---|---|---|
| CPH | Copenhagen | 12.45299999602139 | 12.639799928292632 | 55.63179998192936 | 55.732699991203845 |