[postgis-users] Decoding canonical text of geometry(POINT) data

Dmitry Dzhus dima at dzhus.org
Tue Jul 1 05:30:26 PDT 2014


I have a database table with a `geometry(POINT, 4326)` column.

I need to decode its canonical text representation in the form of

0101000020E61000008B20297D7CBF5440B2A19BFD81834B40

into its components 82.9919732, 55.0274045 *without* calling PostGIS
functions like `st_x` and `st_y` (this is a limitation of the codebase
I'm working with — canonical text is all I have).
Could someone point me to any docs about the encoding details so
that I could reimplement it?


More information about the postgis-users mailing list