Your original data is probably not 4326. Do you have any clue what
projection it is in? Where did you get it from?
P
On Jan 20, 2008, at 7:02 PM, Sam Boggess wrote:
>
> 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@...
>
http://postgis.refractions.net/mailman/listinfo/postgis-users_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users