ST_HexBin

ST_HexBin takes a geometry column and a numeric bin size and returns a bin column. The output column contains a single hexagonal bin for each record in the input column. The specified bin size determines the height of each bin and is in the same units as the input geometry. The centroid of the input geometry is guaranteed to intersect with the bin returned but is not necessarily coincident with the bin center. Use ST_BinGeometry to obtain the geometry of each result bin.

This function can also be called with a long column representing the ID of the bin (see ST_BinId). The bin ID will be cast to a bin column.

Function	Syntax
Python	`hex_bin(geometry, bin_size)`
SQL	`ST_HexBin(geometry, bin_size)`

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

Examples

Python

SQL

Use dark colors for code blocksCopy
# Example of hex_bin with a geometry column as input
from geoanalytics.sql import functions as ST, Polygon

data = [(Polygon([[[0,0],[0,10],[10,10],[10,0],[0,0]]]),),
    (Polygon([[[20,0],[30,20],[40,0],[20,0]]]),),
    (Polygon([[[20,30],[25,35],[30,30],[20,30]]]),)]

df = spark.createDataFrame(data,["polygon"]) \
          .withColumn("hex_bin", ST.hex_bin("polygon", 5)) \
          .withColumn("bin_geometry", ST.bin_geometry("hex_bin"))
df.select("hex_bin").show()

ax = df.st.plot("polygon", facecolor="none", edgecolor="red")
df.st.plot("bin_geometry", ax=ax, facecolor="none", edgecolor="blue")

Result
Use dark colors for code blocksCopy
+---------------+
|        hex_bin|
+---------------+
| bin#4294967296|
|bin#30064771073|
|bin#25769803782|
+---------------+

Plotting example for ST_HexBin — Plotted result for ST_HexBin with a geometry column as input.

Python

SQL

Use dark colors for code blocksCopy
# Example of hex_bin with a long column as input
from geoanalytics.sql import functions as ST

data = [(4294967296,), (30064771073,), (25769803782,)]
df = spark.createDataFrame(data, ["bin_id"]) \
          .withColumn("hex_bin", ST.hex_bin("bin_id", 5)) \
          .withColumn("bin_geometry", ST.bin_geometry("hex_bin"))

ax = df.st.plot("bin_geometry", facecolor="none", edgecolor="blue")

Version table

Release	Notes
1.0.0	Function introduced

ST_HexBin

Examples

Version table

Related topics