« Return to Thread: newbie postgis and google maps question

newbie postgis and google maps question

by Sam Boggess :: Rate this Message:

Reply to Author | View in Thread

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

 « Return to Thread: newbie postgis and google maps question