[postgis-users] Can't figure this out

[Doug Nebert]

Joao Brezolin wrote:
> 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...
> 

Convert it to decimal degrees for both latitude and
longitude first, then load it:

dd = deg + ( min/60 )

Doug.


> 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/
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
>