ST_GeomFromEWKB

Constructs a geometry from Extended Well-Known Binary (EWKB).

Usage

geometry ST_GeomFromEWKB(ewkb: binary)

Arguments

• ewkb (binary)

Description

Parses an EWKB binary value and returns a geometry. EWKB extends the WKB format to include SRID information in the binary header and is useful for PostGIS compatibility.

Examples

SELECT ST_GeomFromEWKB(x'0101000000000000000000f03f0000000000000040');

┌──────────────────────────────────────────────────────────────────────────┐
│ st_geomfromewkb(Binary("1,1,0,0,0,0,0,0,0,0,0,240,63,0,0,0,0,0,0,0,64")) │
│                                  struct                                  │
╞══════════════════════════════════════════════════════════════════════════╡
│ {item: POINT(1 2), crs: }                                                │
└──────────────────────────────────────────────────────────────────────────┘