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
