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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
