[postgis-users] PostgreSQL 9.3.4/PostGIS 2.1.1 function

[Stephen Mather]

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 <stephen at smathermather.com>
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 <FBurgess at radiantblue.com
> > wrote:
>
>> How would I do this on a polygon?
>>
>> Thanks
>> ________________________________________
>> From: postgis-users-bounces at lists.osgeo.org [
>> postgis-users-bounces at lists.osgeo.org] on behalf of Paul Ramsey [
>> pramsey at cleverelephant.ca]
>> 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
>> <FBurgess at radiantblue.com> 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
>> > postgis-users at lists.osgeo.org
>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141205/03244894/attachment.html>