Guy, You would use the ST_Transform function. I see two Lambert 72 in my database (31300 and 31370). I assume one of them is right for you, but if not -- use http://spatialreference.org to find the right one
SELECT * FROM spatial_ref_sys where srtext ilike '%Lambert 72%' WGS 84 has an SRID of 4326 so to transform a table you would do something like SELECT ST_Transform(the_geom, 4326) FROM sometable If you brought your data in with SRID = -1 or the wrong SRID, then you would need to do SELECT ST_Transform(ST_SetSRID(the_geom, 31300), 4326) As the_geom_wgs84 FROM sometable Hope that helps, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Guy Thomas Sent: Tuesday, April 28, 2009 8:39 AM To: [email protected] Subject: [postgis-users] Lambert72 to WGS84 1. Which postGis methods do I use for converting Lambert72 coordinates to WGS84 coordinates and vice-versa? 2. Does anybody know of a Java library that implements this conversion or which I can use to implement it? -- Guy Thomas [email protected] fks bvba - Formal and Knowledge Systems http://www.fks.be/ Stationsstraat 108 Tel: ++32-(0)11-21 49 11 B-3570 ALKEN Fax: ++32-(0)11-22 04 19 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
