ST_AsEWKB - Amazon Redshift

ST_AsEWKB

ST_AsEWKB returns the extended well-known binary (EWKB) representation of an input geometry. For 3DZ, 3DM, and 4D geometries, ST_AsEWKB uses the Open Geospatial Consortium (OGC) standard value for the geometry type.

Syntax

ST_AsEWKB(geom)

Arguments

geom

A value of data type GEOMETRY or an expression that evaluates to a GEOMETRY type.

Return type

VARBYTE

If geom is null, then null is returned.

Examples

The following SQL returns the hexadecimal EWKB representation of a polygon.

SELECT ST_AsEWKB(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326));
st_asewkb -------------------------------- 0103000020E61000000100000005000000000000000000000000000000000000000000000000000000000000000000F03F000000000000F03F000000000000F03F000000000000F03F000000000000000000000000000000000000000000000000