Pular para o conteúdo principal

st_geomfromewkb function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 17.1 and above check marked yes Lakehouse//RT

nota

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

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​

SQL
-- Simple example.
> SELECT st_asewkt(st_geomfromewkb(X'0101000060E6100000000000000000244000000000000041400000000000003740'));
SRID=4326;POINT M (10 34 23)