ST_PolyFromGeoJSON takes a string column and returns a polygon column. The input string column must contain the
GeoJSON representation of polygon geometries.
You can optionally specify a spatial reference for the result polygon column.
The sr parameter value must be a valid SRID or WKT string.
If a polygon cannot be created from the input string the function will return null.
| Function | Syntax |
|---|---|
| Python | poly |
| SQL | ST |
| Scala | poly |
For more details, go to the GeoAnalytics Engine API reference for poly_from_geojson.
Examples
from geoanalytics.sql import functions as ST
poly_geojson = '{"type":"Polygon","coordinates":[[[20,30],[22,35],[18,28],[20,30]]],"crs":null}'
df = spark.createDataFrame([(poly_geojson, )], ["geojson"])
df.select(ST.poly_from_geojson("geojson", sr=4326).alias("poly_from_geojson")).show(truncate=False)Result
+---------------------------------------------+
|poly_from_geojson |
+---------------------------------------------+
|{"rings":[[[20,30],[18,28],[22,35],[20,30]]]}|
+---------------------------------------------+Version table
| Release | Notes |
|---|---|
1.0.0 | Python and SQL functions introduced |
1.5.0 | Scala function introduced |