Latitude/Longitude data types and functions

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 majordomo@postgresql.org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@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

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 <pgman@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

majordomo@postgresql.org)

-- 
Bruce Momjian                        | 
http://candle.pha.pa.us
pgman@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

CSN <cool_screen_name90001@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

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/

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/pgsphere/projdisplay.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

Janko Richter wrote:

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/pgsphere/projdisplay.php

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

pgSphere looks interesting, for spherical coordinate systems. Does
anyone know of a similar module or project for cartesian coordinate systems?

Andrew Ayers
Phoenix, Arizona

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.

Andrew Ayers wrote:

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

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

pgSphere looks interesting, for spherical coordinate systems. Does
anyone know of a similar module or project for cartesian coordinate systems?

Sure, PostGIS: http://postgis.refractions.net

Paul