Prev Up Next
st_x Home st_distance

Name

st_y — Retrieves the y coordinate of a geometry.

Synopsis

st_y ( in g any );

Description

Retrieves the y coordinate of a geometry.

Parameters

g

Geometry

Return Types

Returns double precision.

Examples

Example24.138.Simple Use 

SQL>SELECT st_y( st_point (10, 20));
callret
VARCHAR
_______________________________
 20
No. of rows in result: 1

SQL>SPARQL
SELECT DISTINCT (bif:st_y(?geo ))
WHERE
   {
     ?m geo:geometry ?geo .
   }
LIMIT 10;

callret-0
ANY
_______________________________
 -90
 -86.96666717529297
 -85.41666412353516
 -85.11666870117188
 -85.05999755859375
 -85.04779815673828
 -85.03780364990234
 -85.03070068359375
 -84.99210357666016
 -84.98509979248047
No. of rows in result: 10

Prev Up Next
st_x Home st_distance