ST_PointFromBinary

ST_PointFromBinary takes a binary column and returns a point column. The input binary column must contain the well-known binary (WKB) representation of 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. If a point cannot be created from the input binary the function will return null.

For more details, go to the GeoAnalytics for Microsoft Fabric API reference for point_from_binary.

This function implements the OpenGIS Simple Features Implementation Specification for SQL 1.2.1

Examples

1
2
3
4
5
6
7
8
9
from geoanalytics_fabric.sql import functions as ST

point_binary = bytearray(b'\x01\x01\x00\x00\x00\x00\x00\x00\x00\x00@f\xc0\x00\x00\x00\x00\x00\x001\xc0')

df = spark.createDataFrame([(point_binary,)], ["wkb"])

df.select(ST.point_from_binary("wkb", sr=4326).alias("point_from_binary")).show()

1
2
3
4
5
+------------------+
| point_from_binary|
+------------------+
|{"x":-178,"y":-17}|
+------------------+

Version table

Related topics

• SQL functions
• Data sources
• Coordinate systems and transformations