<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE type=text/css>DIV {
MARGIN: 0px
}
</STYLE>
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>Not quite sure what you are asking. For this kind of
stuff, I usually create a view and use that for google maps if I have a lot of
apps that need it or you could alternatively just write the sql of the view each
time you need it. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>Would be something like this</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>CREATE VIEW vwbusstopsgoogle As</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2> select x(transform(east_north, 4326)) As
lon, y(transform(east_north,4326)) As lat, [other fields you need go
here]</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN
class=541583120-18072007> <FONT
face=Arial color=#0000ff size=2>FROM bus_stops1</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>The to use</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>SELECT lon, lat from vwbusstopsgoogle</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>To transform back it would be</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>INSERT INTO bus_stops1(east_north)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>
values(transform(setsrid(makepoint([lon],[lat]), 4326),
27700))</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2>WHERE [lon], [lat] you replace with the x y you get from
google.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=541583120-18072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Alan
Cunnane<BR><B>Sent:</B> Wednesday, July 18, 2007 4:28 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> [postgis-users] Transforming
Coordinates<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV
style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<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>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>