From: robertboyle@my-deja.com 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 13:03:52 GMT Organization: Deja.com Lines: 47 Message-ID: <95eb7l$qcu$1@nnrp1.deja.com> References: <95blds$f0q$1@nnrp1.deja.com> NNTP-Posting-Host: 195.7.60.113 X-Article-Creation-Date: Fri Feb 02 13:03:52 2001 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) X-Http-Proxy: 1.1 x56.deja.com:80 (Squid/1.1.22) for client 195.7.60.113 X-MyDeja-Info: XMYDJUIDrobertboyle In article <95blds$f0q$1@nnrp1.deja.com>, Matthew Fuller wrote: > 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 ? > > > > Email preffered, > > Regards, > > Stephen > > Stephen, > > I suppose it depends on what you're doing with the values. Note that > if you have any intention of performing area (i.e. spatial) queries on > them, I can't imagine why you wouldn't use the SDO. > > We store lat/lon in the SDO_GEOMETRY datatype, but we also keep some > point values in other fields. We would probably have those in > SDO_GEOMETRY, but they are already part of composite datatypes in > nested tables, and since SDO_GEOMETRY is already an array structure, > Oracle won't allow it. In any event, I would suggest you create a > custom datatype (i.e. object) like "Global_Point" and have Lat/Lon in > it. Then you can stick the Global_Point datatype in your tables. We > store all of our spatial information numerically (i.e. min/sec as > decimal). > > Matt. > > Sent via Deja.com > http://www.deja.com/ > It really depends on what you want to use it for. We get positions in decimal/minutes format and convert them so we can display them on a map? Is it similar to this ? Sent via Deja.com http://www.deja.com/