Latitude/Longitude data types and functions

[CSN]

I looked through the docs and contrib, but didn't see
anything related to storing and using latitude and
longitude values. I have data in the form of 12° 34'
N, 12° 34' W.

Would any of the geometric data types work well for
this type of data? Or just convert them to decimals?
Are there any functions for converting lat/long
to/from decimals/DDMMSS NSEW?

Thanks

__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Bruce Momjian]

Didn't /contrib/earthdistance help?

---------------------------------------------------------------------------

CSN wrote:

I looked through the docs and contrib, but didn't see
anything related to storing and using latitude and
longitude values. I have data in the form of 12° 34'
N, 12° 34' W.

Would any of the geometric data types work well for
this type of data? Or just convert them to decimals?
Are there any functions for converting lat/long
to/from decimals/DDMMSS NSEW?

Thanks

__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[CSN]

Ah, that should work.

The README for contrib/cube states:

To install the type, run
make
make install

For this to work, make sure that:
.. the cube source directory is in the postgres contrib
directory
.. the user running "make install" has postgres
administrative authority
.. this user's environment defines the PGLIB and PGDATA
variables and has
postgres binaries in the PATH.

So I did:
$ export PGLIB=/usr/lib/pgsql
$ export PGDATA=/var/lib/pgsql/data
$ make
$ make install
mkdir /usr/share/pgsql/contrib
make: *** [installdirs] Error 1

$ pg_config --configure
'--prefix=/usr' '--datadir=/usr/share/pgsql'
'--libdir=/usr/lib/pgsql'
'--includedir=/usr/include/pgsql'

Is PGLIB and/or PGDATA ignored? What should I do so
'make install' works?

Thanks,
CSN


--- Bruce Momjian <pg***@candle.pha.pa.us> wrote:

Didn't /contrib/earthdistance help?

---------------------------------------------------------------------------
CSN wrote:

I looked through the docs and contrib, but didn't

see

anything related to storing and using latitude and
longitude values. I have data in the form of 12°

34'

N, 12° 34' W.

Would any of the geometric data types work well

for

this type of data? Or just convert them to

decimals?

Are there any functions for converting lat/long
to/from decimals/DDMMSS NSEW?

Thanks

__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

---------------------------(end of

broadcast)---------------------------

TIP 2: you can get off all lists at once with the

unregister command

(send "unregister YourEmailAddressHere" to

ma*******@postgresql.org)

--
Bruce Momjian |
http://candle.pha.pa.us
pg***@candle.pha.pa.us | (610)
359-1001
+ If your life is a hard drive, | 13 Roberts
Road
+ Christ can be your backup. | Newtown
Square, Pennsylvania 19073

__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Tom Lane]

CSN <co*******************@yahoo.com> writes:

I looked through the docs and contrib, but didn't see
anything related to storing and using latitude and
longitude values.

I think you want to look at the PostGis project:
http://postgis.refractions.net

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Peter Eisentraut]

CSN wrote:

For this to work, make sure that:
. the cube source directory is in the postgres contrib
directory
. the user running "make install" has postgres
administrative authority
. this user's environment defines the PGLIB and PGDATA
variables and has
postgres binaries in the PATH.

These installation instructions are completely bogus. The new text that
I just committed reads:

The user running "make install" may need root access; depending on how
you configured the PostgreSQL installation paths.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Janko Richter]

CSN wrote:

I looked through the docs and contrib, but didn't see
anything related to storing and using latitude and
longitude values. I have data in the form of 12° 34'
N, 12° 34' W.

Would any of the geometric data types work well for
this type of data? Or just convert them to decimals?
Are there any functions for converting lat/long
to/from decimals/DDMMSS NSEW?

Thanks

Have a look at pgSphere
http://gborg.postgresql.org/project/...rojdisplay.php

It has no release yet, but I want to do it this summer.
Check it out and send me possible bug reports.

Regards,
Janko Richter

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings