ST_PointM

ST_PointM takes three numeric columns or double values and returns a point column. The three numeric columns or values must contain the x,y coordinates and m-values of the point geometries. You can optionally specify a spatial reference for the result point column. The sr parameter value must be a valid SRID or WKT string.

To create point geometries without m-values or z-coordinates use ST_Point. To create point geometries with z-coordinates use ST_PointZ, ST_PointZM, or ST_MakePoint.

Function	Syntax
Python	`point_m(x,y,m,sr=None)`
SQL	`ST_PointM(x,y,m,sr)`

For more details, go to the GeoAnalytics Engine API reference for point_m.

Examples

Python

SQL

Use dark colors for code blocksCopy
from geoanalytics.sql import functions as ST

df = spark.createDataFrame([(-178.0, -17.0, 100)], ["longitude", "latitude", "m"])

df.select(ST.point_m("longitude","latitude","m", sr=4326).alias("point_m")).show(truncate=False)

Result
Use dark colors for code blocksCopy
+--------------------------+
|point_m                   |
+--------------------------+
|{"x":-178,"y":-17,"m":100}|
+--------------------------+

Version table

Release	Notes
1.0.0	Function introduced

ST_PointM

Examples

Version table

Related topics