ST_Densify

ST_Densify takes a geometry column and a numeric max_segment_length value and returns a geometry column. This function adds vertices along linestrings or polygons such that every segment within the geometry is no longer than max_segment_length, using planar distance calculation. The max_segment_length parameter is in the same units as the input geometry and should be greater than zero. For example, if your input geometry is in a spatial reference that uses meters, you should specify the max_segment_length in meters.

To densify geometry using geodesic distance calculation, use ST_GeodesicDensify.

Function	Syntax
Python	`densify(geometry1, max_segment_length)`
SQL	`ST_Densify(geometry1, max_segment_length)`

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

Examples

Python

SQL

Use dark colors for code blocksCopy
from geoanalytics.sql import functions as ST

df = spark.createDataFrame([("LINESTRING (0 0, 10 0)",)], ['wkt']) \
        .withColumn("line", ST.line_from_text("wkt"))

df.select(ST.densify("line", 2.5).alias("densified")).show(truncate = False)

Result
Use dark colors for code blocksCopy
+------------------------------------------------+
|densified                                       |
+------------------------------------------------+
|{"paths":[[[0,0],[2.5,0],[5,0],[7.5,0],[10,0]]]}|
+------------------------------------------------+

Version table

Release	Notes
1.1.0	Function introduced

ST_Densify

Examples

Version table

Related topics