st_asgeojson function

Applies to: Databricks Runtime 17.1 and above

Returns the input GEOGRAPHY or GEOMETRY value in GeoJSON format.

Syntax

st_asgeojson ( geoExpr )

Arguments

• geoExpr: A GEOGRAPHY or GEOMETRY value.

Returns

A value of type STRING. The returned value is the GeoJSON description of the input GEOGRAPHY or GEOMETRY value.

The function returns NULL if the input is NULL.

Examples

-- Export a 3DZ Cartesian point, given in WKT format, in GeoJSON format.
> SELECT st_asgeojson(to_geometry('POINT Z (2.718281828 3.141592653 100)'))
  {"type":"Point","coordinates":[2.718281828,3.141592653,100]}

-- Export a 3DZ geographic point, given in WKT format, in GeoJSON format.
> SELECT st_asgeojson(to_geography('POINT Z (2.718281828 3.141592653 100)'))
  {"type":"Point","coordinates":[2.718281828,3.141592653,100]}

Related functions

• st_asbinary function
• st_asewkb function
• st_asewkt function
• st_astext function
• st_aswkb function
• st_aswkt function
• st_geogfromgeojson function
• st_geogfromtext function
• st_geogfromwkb function
• st_geogfromwkt function
• st_geomfromewkb function
• st_geomfromgeojson function
• st_geomfromtext function
• st_geomfromwkb function
• st_geomfromwkt function
• to_geography function
• to_geometry function
• try_to_geography function
• try_to_geometry function