| Lists: | pgus-general |
|---|
| From: | "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com> |
|---|---|
| To: | "pgus-general(at)postgresql(dot)org" <pgus-general(at)postgresql(dot)org> |
| Subject: | PostgreSQL 9.3.4/PostGIS 2.1.1 function |
| Date: | 2014-12-04 18:59:52 |
| Message-ID: | 3BBE635F64E28D4C899377A61DAA9FE0451CB4D6@NBSVR-MAIL01.radiantblue.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg와이즈 토토SQL |
Is there a Postgis function available that will retrieve all the points of a Polygon, and return them in lat/long from decimal degree?
Thanks
| From: | "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com> |
|---|---|
| To: | "pgus-general(at)postgresql(dot)org" <pgus-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 9.3.4/PostGIS 2.1.1 function |
| Date: | 2014-12-04 19:10:50 |
| Message-ID: | 3BBE635F64E28D4C899377A61DAA9FE0451CB4ED@NBSVR-MAIL01.radiantblue.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgus-general |
Can you send me the code/template, if you have a custom function that meets this requirement.
Thanks
________________________________
From: Burgess, Freddie
Sent: Thursday, December 04, 2014 1:59 PM
To: pgus-general(at)postgresql(dot)org
Subject: PostgreSQL 9.3.4/PostGIS 2.1.1 function
Is there a Postgis function available that will retrieve all the points of a Polygon, and return them in lat/long from decimal degree?
Thanks
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com>, "pgus-general(at)postgresql(dot)org" <pgus-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 9.3.4/PostGIS 2.1.1 function |
| Date: | 2014-12-04 19:12:15 |
| Message-ID: | 5480B20F.80603@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg스포츠 토토SQL |
On 12/04/2014 11:10 AM, Burgess, Freddie wrote:
> Can you send me the code/template, if you have a custom function that
> meets this requirement.
"All the points in a polygon"? How would that work exactly? Do you
mean "all the vertices"? Or something else?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
| From: | "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com>, "pgus-general(at)postgresql(dot)org" <pgus-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 9.3.4/PostGIS 2.1.1 function |
| Date: | 2014-12-04 19:30:35 |
| Message-ID: | 3BBE635F64E28D4C899377A61DAA9FE0451CB520@NBSVR-MAIL01.radiantblue.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgus-general |
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.
thanks
________________________________________
From: Josh Berkus [josh(at)agliodbs(dot)com]
Sent: Thursday, December 04, 2014 2:12 PM
To: Burgess, Freddie; pgus-general(at)postgresql(dot)org
Subject: Re: [pgus-general] PostgreSQL 9.3.4/PostGIS 2.1.1 function
On 12/04/2014 11:10 AM, Burgess, Freddie wrote:
> Can you send me the code/template, if you have a custom function that
> meets this requirement.
"All the points in a polygon"? How would that work exactly? Do you
mean "all the vertices"? Or something else?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
| From: | "Jonathan S(dot) Katz" <jonathan(dot)katz(at)excoventures(dot)com> |
|---|---|
| To: | "Burgess, Freddie" <FBurgess(at)Radiantblue(dot)com> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, "pgus-general(at)postgresql(dot)org" <pgus-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 9.3.4/PostGIS 2.1.1 function |
| Date: | 2014-12-04 23:06:53 |
| Message-ID: | EE69FF27-3A4A-4EB7-A239-50E75F629994@excoventures.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgus-general |
(apologies for top-posting)
Hi Freddie,
You should probably check out the PostGIS user mailing list for answers to your questions, as they will have more expertise / info in this area - you can subscribe to their list here: http://postgis.net/support
Best,
Jonathan
On Dec 4, 2014, at 1:30 PM, Burgess, Freddie <FBurgess(at)Radiantblue(dot)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.
>
> thanks
> ________________________________________
> From: Josh Berkus [josh(at)agliodbs(dot)com]
> Sent: Thursday, December 04, 2014 2:12 PM
> To: Burgess, Freddie; pgus-general(at)postgresql(dot)org
> Subject: Re: [pgus-general] PostgreSQL 9.3.4/PostGIS 2.1.1 function
>
> On 12/04/2014 11:10 AM, Burgess, Freddie wrote:
>> Can you send me the code/template, if you have a custom function that
>> meets this requirement.
>
> "All the points in a polygon"? How would that work exactly? Do you
> mean "all the vertices"? Or something else?
>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com
>
>
> --
> Sent via pgus-general mailing list (pgus-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgus-general