From: Harry Boswell Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Subject: Re: LAT / LONG GIS values in a table Date: Fri, 02 Feb 2001 17:21:08 GMT Organization: Deja.com Lines: 29 Message-ID: <95eq9o$8of$1@nnrp1.deja.com> References: NNTP-Posting-Host: 205.144.230.29 To: Stephen.Spence@Australia.Boeing.com X-Article-Creation-Date: Fri Feb 02 17:21:08 2001 GMT X-Http-User-Agent: Mozilla/4.73 [en] (WinNT; U) X-Http-Proxy: 1.0 x59.deja.com:80 (Squid/1.1.22) for client 205.144.230.29 X-MyDeja-Info: XMYDJUIDstarmaster7 In article , "Stephen Spence" wrote: > All, > > What would be the best way to store lat/long (without using the spacial > cart.) in a table. > > e.g. store degrees/min/sec as a decimal and convert when wanting to be > displayed ? > Anybody got an example / ideas of this ? > Hi Stephen, A simplistic way is to store the three values (degrees, minutes, seconds) in separate columns. You can then concatenate them for simple reporting, or use simple algorithms to convert to decimal degrees and then concatenate. It's not elegant, but it's plenty functional. Harry -- There's no sig here Sent via Deja.com http://www.deja.com/