I have some data in a texfile where the coordinates are given in this format:
lat lon23S19.69 66W45.8724S01.73 66W55.61I already learned that it is some kind of WGS-84 with degree and decimal minutes. My goal is to save the coordinate in a point geometry. ST_MakePoint(lon, lat) does not work as this function expects double precision values. Is Postgis able to convert this format somehow or do I have to write some sort of script?
أكثر...
lat lon23S19.69 66W45.8724S01.73 66W55.61I already learned that it is some kind of WGS-84 with degree and decimal minutes. My goal is to save the coordinate in a point geometry. ST_MakePoint(lon, lat) does not work as this function expects double precision values. Is Postgis able to convert this format somehow or do I have to write some sort of script?
أكثر...