[postgis-users] Degrees to meters

[marco vieira]

Kevin:

select *,transform(the_geom,4326) as new_the_geom into newtable from
tablesrid4803;
after (if you want):
insert into geometry_coluns
values('','schema','newtable','new_the_geom',2,4326,'POINT');

If the original table is not in geometry_columns using 4803 you can use
transform(setsrid(the_geom,4803),4326).

regards.

2006/6/14, Kevin martins <martins506 at hotmail.com>:
>
> Hi List,
> I am new in this list, but i've allready got a problem :-) ...
> I have a table with data in meters using the srid:4803 and I want to
> put  a new point(in degrees, using srid:4326) in the table how can I do
> it???
> Cheers,
> Kevin Martins
>
> _________________________________________________________________
> Veja mais. Compartilhe mais. Experimente gratuitamente a versão beta do
> Windows Live Messenger
>
> http://ideas.live.com/programpage.aspx?versionId=0eccd94b-eb48-497c-8e60-c6313f7ebb73_______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Marco Vieira
+55 21 9499-6800
e-mail: maovieira at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060614/a43a22ff/attachment.html>