does GIS DMS data type already exist? - Mailing list pgsql-general

From vandewal@dhc.net
Subject does GIS DMS data type already exist?
Date
Msg-id XFMail.991113115610.vandewal@dhc.net
Whole thread Raw
Responses Re: [GENERAL] does GIS DMS data type already exist?  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
List pgsql-general
Hey,

I am builing a system that is going to be dealing with a large
amount of GIS (geographic) data from USGS.  Some of their data
provides lattitude and longitude in the DMS (degrees minnutes seconds)
format, other provides lat/lon in decimal format.  The decimal is
obviously not a problem for postgres, but the DMS is.  I am going to
need to be doing queries based on the DMS data, and will need it
treated as numeric instead of just a text string.

Soooo (to get to my question already!) what I want to know is
whether anyone else has already coded up a data type to do this
kind of thing or whether I just have to do it myself.

I search around but didn't find one.

Thanks for you time.

dv


// David E. Vandewalle          | The best diplomat I know is a fully
// vandewal@skyblue.com         | activated phaser bank.
// david.e.vandewalle@lmco.com  |     -- Scotty

pgsql-general by date:

Previous
From: Bruce Elrick
Date:
Subject: Re: Composite Keys
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] does GIS DMS data type already exist?