[postgis-users] Can't figure this out

[Joao Brezolin]

Hello all!

I'm trying to figure this:

i got GPS coordenates such as "30º 56" and i need to
store this coordenates and create a representation for
that using mapserver...

In my database i need to store somthing like this:

ID  |Name        | GeomField
1   |Road 1      | 'LINESTRING('30 º65, 30 º56)

where
 ID is serial , Name is Varchar, and GeomField is a
geom .

and then in mapserver do somthing like
DATA "geom from roads"

to draw this roads in the web browser

is this possible? 
if is not how can i convert this data to cartesian
coordinates?

Thanks to all
João.

  

_______________________________________________________________________
Yahoo! Encontros
O lugar certo para você encontrar aquela pessoa que falta na sua vida. Cadastre-se hoje mesmo!
http://br.encontros.yahoo.com/