Postgresql, Redshift, Etl, Transformation, Data Warehouse.
following SELECT ST_X(0101000000E538D293ADC651C0F3699A2254284540) latitude, ST_Y(0101000000E538D293ADC651C0F3699A2254284540) longitude; which gives us back the original latitude & longitude back. Conversions for Linestring will also work similarly. Here’s an example of getting all nodes from a