ST_MPointFromShape takes a binary column and returns a multipoint column. The input binary column must contain the
shapefile representation of multipoint geometries. You can optionally specify a
spatial reference for the result multipoint column. The sr parameter value must be a valid SRID or WKT string.
If a multipoint cannot be created from the input binary the function will return null.
| Function | Syntax |
|---|---|
| Python | mpoint |
| SQL | ST |
| Scala | mpoint |
For more details, go to the GeoAnalytics for Microsoft Fabric API reference for mpoint_from_shape.
Examples
from geoanalytics_fabric.sql import functions as ST
mpoint_shape = bytearray(b'\x08\x00\x00\x00R\xb8\x1e%\xb4RH\xc1\xaeG\xe1zO\xe9^AH\xe1z\xf4z=G\xc1\x00\x00\x00\xf03>_A\x03\x00\x00\x00\xc3\xf5(\\\xc1\x1bH\xc1\x00\x00\x00\xf03>_AH\xe1z\xf4z=G\xc1\x00\x00\x00\xf03>_AR\xb8\x1e%\xb4RH\xc1\xaeG\xe1zO\xe9^A')
df = spark.createDataFrame([(mpoint_shape, )], ["shape"])
df.select(ST.mpoint_from_shape("shape", sr=54008).alias("mpoint_from_shape")).show(truncate=False)Result
+---------------------------------------------------------------------------------------+
|mpoint_from_shape |
+---------------------------------------------------------------------------------------+
|{"points":[[-3159938.72,8190159.75],[-3046133.91,8190159.75],[-3188072.29,8103229.92]]}|
+---------------------------------------------------------------------------------------+Version table
| Release | Notes |
|---|---|
1.0.0-beta | Python, SQL, and Scala functions introduced |