Latitude/Longitude handling in ORACLE?

Here at CSIRO fisheries we are building a fisheries database that requires forms processing of vessel positions in latitude/ longitude. They are entered in degrees/minutes/seconds and presumably will be stored internally as positive or negative decimal degrees (that's our current thinking, anyway).

There are some problems inherent in conversion and display of this type of data. If any of you Oracle netters have addressed this problem I would appreciate hearing from you.

Thanks

Jeff Stander

---


___________________________________________________________________________


Jeff.Stander_at_ml.csiro.au        _--_|\        Database Analyst
CSIRO Division Of Fisheries    /      \       Pelagic Fisheries Resources
GPO Box 1538, Hobart           \_.--._/       Tasmania 7001, Australia
Aus Tel: 002-206-206                 v        Intl Tel: +61-02-206-206
Aus Fax: 002-240-530                          Intl Fax: +61-02-240-530


___________________________________________________________________________