ST_AsGeoJSON takes a geometry column and returns the GeoJSON representation of the geometry as a string column. Geometries that have an m-value and no z-coordinate will only return x,y coordinates.
| Function | Syntax |
|---|---|
| Python | as |
| SQL | ST |
| Scala | as |
For more details, go to the GeoAnalytics Engine API reference for as_geojson.
Examples
from geoanalytics.sql import functions as ST, Point
df = spark.createDataFrame([(Point(-178, -17),)], ["point"])
df.select(ST.as_geojson("point").alias("as_geojson")).show(truncate=False)Result
+----------------------------------------------------+
|as_geojson |
+----------------------------------------------------+
|{"type":"Point","coordinates":[-178,-17],"crs":null}|
+----------------------------------------------------+Version table
| Release | Notes |
|---|---|
1.0.0 | Python and SQL functions introduced |
1.5.0 | Scala function introduced |