st_geogfromwkb function

Applies to: Databricks Runtime 17.1 LTS and above

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

Syntax

st_geogfromwkb ( wkbExpr )

Arguments

• wkbExpr: A BINARY value, representing a geography in WKB format.

Returns

A value of type GEOGRAPHY(4326), corresponding to the input WKB description.

The function returns NULL if the input is NULL.

Error conditions

• If the value of wkbExpr is an invalid WKB, the function returns WKB_PARSE_ERROR.

Examples

-- The input WKB is in little-endian format.
> SELECT st_astext(st_geogfromtext(X'01D1070000000000000000244000000000000041400000000000003740'))
  POINT M (10 34 23)

-- The input WKB is in big-endian format.
> SELECT st_astext(st_geogfromtext(X'00000007D1402400000000000040410000000000004037000000000000'));
  POINT M (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_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