PostGIS
Description
Creates a point with X, Y and M (measure) coordinates.
Use ST_MakePoint to make points with XY, XYZ, or XYZM coordinates.
|
Examples
Create point with unknown SRID.
SELECT ST_AsEWKT( ST_MakePointM(-71.1043443253471, 42.3150676015829, 10) );
st_asewkt
-----------------------------------------------
POINTM(-71.1043443253471 42.3150676015829 10)Create point with a measure in the WGS 84 geodetic coordinate system.
SELECT ST_AsEWKT( ST_SetSRID( ST_MakePointM(-71.104, 42.315, 10), 4326));
st_asewkt
---------------------------------------------------------
SRID=4326;POINTM(-71.104 42.315 10)Get measure of created point.
SELECT ST_M( ST_MakePointM(-71.104, 42.315, 10) );
result
-------
10