[postgis-users] newbie postgis and google maps question

[Sam Boggess]

Hello,

I'm new to PostGIS and this has to be a cakewalk for 
you experienced users, but your help would be greatly appreciated.  I 
have a PostGIS enabled database that contains polygon data from a 
shapefile using SRID 4326.  All I want to do at this point is mark the 
centers of all of my polygons in Google Maps.  I've written my 
query, and it works great: 

select astext(centroid(poly)) 
from zones 

returns (a bunch of): 
POINT(-13057223.7425678 6208110.75868711) 

However, I have no idea what to do with this point data.  Google maps
expects lat and long; how can i convert this?  In another forum a user
suggested dividing by 10, but that's a point in Northern Canada, this point
should be in NE Washington State.

Any Help would be greatly appreciated
-- 
View this message in context: http://www.nabble.com/newbie-postgis-and-google-maps-question-tp14989995p14989995.html
Sent from the PostGIS - User mailing list archive at Nabble.com.