st_geomfromgeojson function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Preview

This feature is in Public Preview.

nota

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