Postgresql, Redshift, Etl, Transformation, Data Warehouse.
from a latitude-longitude pair, we do the following, SELECT ST_MakePoint(-71.1043443253471, 42.3150676015829); which gives us the following output 0101000000E538D293ADC651C0F3699A2254284540 To extract latitude & longitude back from this string representation of a point, we’ll have to do the