Re: Geographic coordinate values format conversion to DD (Decimal Degrees) format

2018-12-05 Thread Allan Kamau
Thank you very much Paul. Your suggestions and input have spared me many hours of trying to identify applications and functions to perform this transformation. I am now installing PostGIS. Allan. On Wed, Dec 5, 2018 at 1:25 AM Paul Ramsey wrote: > > On Dec 4, 2018, at 12:36 PM, Allan Kamau wr

Re: Geographic coordinate values format conversion to DD (Decimal Degrees) format

2018-12-04 Thread Paul Ramsey
> On Dec 4, 2018, at 12:36 PM, Allan Kamau > wrote: > > Does PostgreSQL (more specifically PostGIS) have functions for these types of > conversions. > > Below are examples of the geographic coordinates values I have coupled with > the resulting decimal degrees val

Geographic coordinate values format conversion to DD (Decimal Degrees) format

2018-12-04 Thread Allan Kamau
I have data that contains geographic coordinate values in various geographic coordinate system formats such as "degrees minutes seconds" and "degrees decimal minutes". I would like to convert these geographic coordinate values into decimal degrees format. Does PostgreSQL (more specifically PostGIS)