ST_AsBinary takes a geometry column and returns the well-known binary (WKB) representation of the geometry as a binary column.
| Function | Syntax |
|---|---|
| Python | as |
| SQL | ST |
| Scala | as |
For more details, go to the GeoAnalytics for Microsoft Fabric API reference for as_binary.
This function implements the OpenGIS Simple Features Implementation Specification for SQL 1.2.1
Examples
from geoanalytics_fabric.sql import functions as ST, Point
df = spark.createDataFrame([(Point(-178, -17),)], ["point"])
df.select(ST.as_binary("point").alias("as_binary")).show(truncate=False)Result
+----------------------------------------------------------------+
|as_binary |
+----------------------------------------------------------------+
|[01 01 00 00 00 00 00 00 00 00 40 66 C0 00 00 00 00 00 00 31 C0]|
+----------------------------------------------------------------+Version table
| Release | Notes |
|---|---|
1.0.0-beta | Python, SQL, and Scala functions introduced |