st_geomfromewkb function

Applies to: Databricks Runtime 17.1 and above

Parses the Extended WKB (EWKB) description of a geometry and returns the corresponding GEOMETRY value. The SRID value of the returned GEOMETRY value is the one prescribed in the EWKB description, or 0 if there is no SRID value in the EWKB description.

Syntax

st_geomfromewkb ( ewkbExpr )

Arguments

• ewkbExpr: A BINARY value, representing a geometry in Extended WKB (EWKB) format.

Returns

A value of type GEOMETRY(ANY), corresponding to the input Extended WKB (EWKB) description.

The function returns NULL if the input is NULL.

Error conditions

• If the value of ewkbExpr is an invalid Extended WKB (EWKB) description, the function returns EWKB_PARSE_ERROR.

Examples

-- Simple example.
> SELECT st_asewkt(st_geomfromewkb(X'0101000060E6100000000000000000244000000000000041400000000000003740'))
  SRID=4326;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_geogfromwkb function
• st_geomfromgeojson function
• st_geomfromtext function
• st_geomfromwkb function
• to_geography function
• to_geometry function
• try_to_geography function
• try_to_geometry function