<div dir="ltr"><div><span style="font-size:12.7272720336914px">Hi Freddie,</span></div><div><span style="font-size:12.7272720336914px"><br></span></div><span style="font-size:12.7272720336914px">select st_astext(st_setsrid(st_scale(</span><span style="font-size:12.7272720336914px">'POINT(1</span><br style="font-size:12.7272720336914px"><span style="font-size:12.7272720336914px">1)'::geometry,180.0/pi(),180.</span><span style="font-size:12.7272720336914px">0/pi()),4326)) FROM table_containing_polygon;</span><br><div><span style="font-size:12.7272720336914px"><br></span></div><div><span style="font-size:12.7272720336914px">Best,</span></div><div><span style="font-size:12.7272720336914px">Steve</span></div><div><span style="font-size:12.7272720336914px"><br></span></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Dec 5, 2014 at 3:33 PM, Burgess, Freddie <span dir="ltr"><<a href="mailto:FBurgess@radiantblue.com" target="_blank">FBurgess@radiantblue.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">How would I do this on a polygon?<br>
<br>
Thanks<br>
________________________________________<br>
From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> [<a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a>] on behalf of Paul Ramsey [<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>]<br>
Sent: Thursday, December 04, 2014 6:51 PM<br>
To: PostGIS Users Discussion<br>
Subject: Re: [postgis-users] PostgreSQL 9.3.4/PostGIS 2.1.1 function<br>
<div class="HOEnZb"><div class="h5"><br>
I would think that scaling by 180/pi should do the trick in general?<br>
<br>
select st_astext(st_setsrid(st_scale('POINT(1 1)'::geometry,180.0/pi(),180.0/pi()),4326));<br>
<br>
P<br>
<br>
On Thu, Dec 4, 2014 at 3:24 PM, Burgess, Freddie<br>
<<a href="mailto:FBurgess@radiantblue.com">FBurgess@radiantblue.com</a>> wrote:<br>
> Given a polygon geometry with no SRID, the vertices actually in radians, but<br>
> since the SRID is zero, it looks like Cartesian coordinates, I want the lat<br>
> long in degrees and not rads.<br>
><br>
> Does anyone provide of a function/custom that will return lat/long in<br>
> degrees given the conditions described?<br>
><br>
> thanks<br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br></div>