Sorry typos and such, try this again: select st_astext(st_setsrid(st_scale(geom,180.0/pi(),180.0/pi()),4326)) FROM table_containing_polygons;
Best, Steve On Fri, Dec 5, 2014 at 4:30 PM, Stephen Mather <[email protected]> wrote: > Hi Freddie, > > select st_astext(st_setsrid(st_scale('POINT(1 > 1)'::geometry,180.0/pi(),180.0/pi()),4326)) FROM table_containing_polygon; > > Best, > Steve > > > On Fri, Dec 5, 2014 at 3:33 PM, Burgess, Freddie <[email protected] > > wrote: > >> How would I do this on a polygon? >> >> Thanks >> ________________________________________ >> From: [email protected] [ >> [email protected]] on behalf of Paul Ramsey [ >> [email protected]] >> Sent: Thursday, December 04, 2014 6:51 PM >> To: PostGIS Users Discussion >> Subject: Re: [postgis-users] PostgreSQL 9.3.4/PostGIS 2.1.1 function >> >> I would think that scaling by 180/pi should do the trick in general? >> >> select st_astext(st_setsrid(st_scale('POINT(1 >> 1)'::geometry,180.0/pi(),180.0/pi()),4326)); >> >> P >> >> On Thu, Dec 4, 2014 at 3:24 PM, Burgess, Freddie >> <[email protected]> wrote: >> > Given a polygon geometry with no SRID, the vertices actually in >> radians, but >> > since the SRID is zero, it looks like Cartesian coordinates, I want the >> lat >> > long in degrees and not rads. >> > >> > Does anyone provide of a function/custom that will return lat/long in >> > degrees given the conditions described? >> > >> > thanks >> > >> > _______________________________________________ >> > postgis-users mailing list >> > [email protected] >> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
