Name

st_x — Retrieves the x coordinate of a geometry.

Synopsis

st_x ( in g any );

Description

Retrieves the x coordinate of a geometry.

Parameters

g

Geometry point

Return Types

Returns double precision.

Examples

Example24.137.Simple Use

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

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

callret-0
ANY
_______________________________
 -139.2666625976562
 -153.8333282470703
 -163
 -170.8000030517578
 -142.1759033203125
 -142.2581024169922
 -85.03309631347656
 -142.6853942871094
 -143.6544952392578
 -143.8195037841797
No. of rows in result: 10