st_geomfromgeojson function

Applies to: Databricks Runtime 17.1 and above

Preview

This feature is in Public Preview.

Parses the GeoJSON description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is 4326.

Syntax

st_geomfromgeojson ( geojsonExpr )

Arguments

• geojsonExpr: A STRING value, representing a geography in GeoJSON format.

Returns

A value of type GEOMETRY(4326), corresponding to the input GeoJSON description.

The function returns NULL if the input is NULL.

Error conditions

• If the value of geojsonExpr is an invalid GeoJSON description, the function returns GEOJSON_PARSE_ERROR.

Examples

SQL

-- Simple example.
> SELECT st_asewkt(st_geomfromgeojson('{"type":"Point","coordinates":[10,34,23]}'));
  SRID=4326;POINT Z (10 34 23)

Related functions

• st_asbinary function
• st_asewkb function
• st_asewkt function
• st_asgeojson function
• st_astext function
• st_geogfromgeojson function
• st_geogfromtext function
• st_geogfromwkb function
• st_geomfromewkb function
• st_geomfromtext function
• st_geomfromwkb function
• to_geography function
• to_geometry function
• try_to_geography function
• try_to_geometry function