ST_SquareBin

ST_SquareBin takes a geometry column and a numeric bin size and returns a bin column. The output column contains a single square 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	`square_bin(geometry, bin_size)`
SQL	`ST_SquareBin(geometry, bin_size)`

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

Examples

Python

SQL

Use dark colors for code blocksCopy
# Example of square_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]]]),),
        (Polygon([[[20,0],[30,20],[40,0]]]),),
        (Polygon([[[20,30],[25,35],[30,30]]]),)]

df = spark.createDataFrame(data,["polygon"]) \
          .withColumn("square_bin", ST.square_bin("polygon", 5)) \
          .withColumn("bin_geometry", ST.bin_geometry("square_bin"))
df.select("square_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
+---------------+
|     square_bin|
+---------------+
|          bin#0|
|bin#25769803777|
|bin#21474836486|
+---------------+

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

Python

SQL

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

data = [(0,), (25769803777,), (21474836486,)]
df = spark.createDataFrame(data, ["bin_id"]) \
          .withColumn("square_bin", ST.square_bin("bin_id", 5)) \
          .withColumn("bin_geometry", ST.bin_geometry("square_bin"))

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

Plotting example for ST_SquareBin with a long column as input — Plotted result for ST_SquareBin with a long column as input.

Version table

Release	Notes
1.0.0	Function introduced

ST_SquareBin

Examples

Version table

Related topics