st_geogfromgeojson function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Preview

This feature is in Public Preview.

note

This feature is not available on Databricks SQL Classic warehouses. To learn more about Databricks SQL warehouses, see SQL warehouse types

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

SQL

-- 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