Re: LAT / LONG GIS values in a table

In article <G81uKp.8oD_at_news.boeing.com>,   "Stephen Spence" <Stephen.Spence_at_Australia.Boeing.com> 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/