<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi guys<br><br>I have a table with easting northing coordinates and these points in a geom column. I have 15,000 points with an easting and a northing (brittish national grid) and created the geom column using these commands:<br><br>SELECT AddGeometryColumn( 'bus_stops1', 'east_north', 27700, 'POINT', 2 );<br>UPDATE bus_stops1 SET east_north = PointFromText('POINT(' || easting || ' ' || northing || ')',27700);<br><br>The table looks like this at the moment:<br><br> easting | northing | east_north<br>---------+----------+----------------------------------------------------<br> 226965 | 676038 | 0101000020346C000000000000A8B40B41000000008CA12441<br> 226761
| 675945 | 0101000020346C00000000000048AE0B4100000000D2A02441<br> 226696 | 675893 | 0101000020346C00000000000040AC0B41000000006AA02441<br> 226473 | 675777 | 0101000020346C00000000000048A50B4100000000829F2441<br> 226465 | 675731 | 0101000020346C00000000000008A50B4100000000269F2441<br> 226614 | 675611 | 0101000020346C000000000000B0A90B4100000000369E2441<br> 226603 | 675605 | 0101000020346C00000000000058A90B41000000002A9E2441<br> 226869 | 675621 | 0101000020346C000000000000A8B10B41000000004A9E2441<br> 226883 | 675630 | 0101000020346C00000000000018B20B41000000005C9E2441<br> 226544 | 674911 | 0101000020346C00000000000080A70B4100000000BE982441<br> 226767 | 675293 | 0101000020346C00000000000078AE0B4100000000BA9B2441<br> 226767 | 675303 |
0101000020346C00000000000078AE0B4100000000CE9B2441<br><br><br>Now what I want to be able to do is to add another column or two columns with X and Y values in WGS or the standard X and Y coordinates for entry into google maps. I dont want to transform the east_north column so that I get another long string as is shown above as I cannot then integrate them into google maps. Can this be done using PostgreSQL?<br><br>Also I would like to do the opposite too. Take x and y coordinates from google maps and transform them to easting northing as above. Thanks for your help again<br><br></div></div><br>
<hr size=1>
Yahoo! Mail is the world's favourite email. Don't settle for less, <a
href="http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html">sign up for your free
account today</a>.</body></html>