st_geogfromgeojson function

Applies to: Databricks Runtime 17.1 and above

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

Syntax

st_geogfromgeojson ( geojsonExpr )

Arguments

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

Returns

A value of type GEOGRAPHY(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

-- Simple example.
> SELECT st_astext(st_geogfromgeojson('{"type":"Point","coordinates":[1,2,3]}'));
  POINT Z (1 2 3)

Related functions

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