Pular para o conteúdo principal

st_asewkb function

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

Preview

This feature is in Public Preview.

Returns the input GEOMETRY value in Extended WKB (EWKB) format using the specified endianness, if provided. If the endianness is not specified, the returned value is little-endian encoded.

Syntax​

st_asewkb ( geoExpr[, endiannessExpr] )

Arguments​

  • geoExpr: A GEOMETRY value.
  • endiannessExpr: An optional STRING value, representing the endianness of the output WKB, 'NDR' for little-endian (default) or 'XDR' for big-endian.

Returns​

A value of type BINARY. The returned value is the Extended WKB (EWKB) description of the input GEOMETRY value using the specified endianness, if provided. If the endianness is not specified, the returned value is little-endian encoded.

The function returns NULL if any of the inputs is NULL.

Examples​

SQL
-- Export a 3DZ Cartesian point with SRID 4326 in EWKB format (default endianness).
> SELECT hex(st_asewkt(st_geomfromtext('POINT Z (1 2 100)', 4326)));
  01010000A0E6100000000000000000F03F00000000000000400000000000005940

-- Export a 3DZ Cartesian point with SRID 4326 in big-endianness EWKB format.
> SELECT hex(st_asewkt(st_geomfromtext('POINT Z (1 2 100)', 4326), 'XDR'));
  00A0000001000010E63FF000000000000040000000000000004059000000000000
Última atualização em