ST_LineFromGeoJSON

ST_LineFromGeoJSON takes a string column and returns a linestring column. The input string column must contain the GeoJSON representation of linestring geometries. You can optionally specify a spatial reference for the result linestring column. The sr parameter value must be a valid SRID or WKT string. If a linestring cannot be created from the input string the function will return null.

Function	Syntax
Python	`line_from_geojson(json_str,sr=None)`
SQL	`ST_LineFromGeoJson(json_str,sr)`

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

Examples

Python

SQL

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

line_geojson = '{"type": "LineString","coordinates": [[-7489594.84,5178779.67],[-7474281.07,5176558.51],[-7465977.43,5179778.83]]}'

df = spark.createDataFrame([(line_geojson,)],["geojson"])

df.select(ST.line_from_geojson("geojson", sr=8857).alias("line_from_geojson")).show(truncate=False)

Result
Use dark colors for code blocksCopy
+----------------------------------------------------------------------------------------+
|line_from_geojson                                                                       |
+----------------------------------------------------------------------------------------+
|{"paths":[[[-7489594.84,5178779.67],[-7474281.07,5176558.51],[-7465977.43,5179778.83]]]}|
+----------------------------------------------------------------------------------------+

Version table

Release	Notes
1.0.0	Function introduced

ST_LineFromGeoJSON

Examples

Version table

Related topics