[postgis-users] POINT conversion

[Rafael Vidal Aroca]

    Thanks!

    Using x() and y() solved my problem, and i also found another 
possible solution using postgis classes for java, where we can make an 
instance of a point from the database and use getX and getY methods.

Rafael.

Paul Ramsey wrote:

> You're most of the way there.
> Use the X() and Y() functions to extract the ordinates back out of 
> your transformed point, and then write a reverse function to do from 
> DD.DDDD to DDMM.SS format.
> Paul
>
> Rafael Vidal Aroca wrote:
>
>>     Hello, i have 2 questions related to the POINT structure. One is 
>> about what i did, and another about what i'll do :-)
>>
>>     The problem:
>>     I have a table with 2 fields that keep historic GPS positions 
>> (latitude and longitude). This fields are stored in WGS84 format, 
>> DDMM.SS.
>>
>>     I need this data in SAD69/UTM format, but to convert the data i 
>> need these values to be in DD.MMSS
>>
>>
>>     What i did:
>>     I created a postgresql function that converts DDMM.SS to DD.MMSS 
>> and called this function inside a select with transform, and ok, i 
>> got the data in the format i need!
>>     But is this the best way to do it? Or is there another way of 
>> doing this that i am not aware of?
>>
>>
>>     What i'll do:
>>     The data i got is correct, but unsable, because the output is like:
>>
>>     SRID=X, POINT(xxxxx yyyyy)
>>
>>     but this is not of any help for me, because i need these two 
>> valeus in separeted fields of a table or view...or am i doing 
>> something wrong? Is there another way of dealing with these valeus? I 
>> have a servlet that reads a table and generates a xml output...
>>
>>     thanks
>>
>>     Rafael.
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users