pg.ddx.io pgus-general@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL 9.3.4/PostGIS 2.1.1 function
5+ messages / 3 participants
[nested] [flat]
* PostgreSQL 9.3.4/PostGIS 2.1.1 function
@ 2014-12-04 18:59 Burgess, Freddie <FBurgess@Radiantblue.com>
0 siblings, 1 reply; 5+ messages in thread
From: Burgess, Freddie @ 2014-12-04 18:59 UTC (permalink / raw)
To: pgus-general
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL 9.3.4/PostGIS 2.1.1 function
@ 2014-12-04 19:10 Burgess, Freddie <FBurgess@Radiantblue.com>
parent: Burgess, Freddie <FBurgess@Radiantblue.com>
0 siblings, 1 reply; 5+ messages in thread
From: Burgess, Freddie @ 2014-12-04 19:10 UTC (permalink / raw)
To: 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@postgresql.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL 9.3.4/PostGIS 2.1.1 function
@ 2014-12-04 19:12 Josh Berkus <josh@agliodbs.com>
parent: Burgess, Freddie <FBurgess@Radiantblue.com>
0 siblings, 1 reply; 5+ messages in thread
From: Josh Berkus @ 2014-12-04 19:12 UTC (permalink / raw)
To: Burgess, Freddie <FBurgess@Radiantblue.com>; pgus-general
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgus-general
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL 9.3.4/PostGIS 2.1.1 function
@ 2014-12-04 19:30 Burgess, Freddie <FBurgess@Radiantblue.com>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Burgess, Freddie @ 2014-12-04 19:30 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; 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@agliodbs.com]
Sent: Thursday, December 04, 2014 2:12 PM
To: Burgess, Freddie; pgus-general@postgresql.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgus-general
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: PostgreSQL 9.3.4/PostGIS 2.1.1 function
@ 2014-12-04 23:06 Jonathan S. Katz <jonathan.katz@excoventures.com>
parent: Burgess, Freddie <FBurgess@Radiantblue.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jonathan S. Katz @ 2014-12-04 23:06 UTC (permalink / raw)
To: Burgess, Freddie <FBurgess@Radiantblue.com>; +Cc: Josh Berkus <josh@agliodbs.com>; 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@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.
>
> thanks
> ________________________________________
> From: Josh Berkus [josh@agliodbs.com]
> Sent: Thursday, December 04, 2014 2:12 PM
> To: Burgess, Freddie; pgus-general@postgresql.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgus-general
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2014-12-04 23:06 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-12-04 18:59 PostgreSQL 9.3.4/PostGIS 2.1.1 function Burgess, Freddie <FBurgess@Radiantblue.com>
2014-12-04 19:10 ` Burgess, Freddie <FBurgess@Radiantblue.com>
2014-12-04 19:12 ` Josh Berkus <josh@agliodbs.com>
2014-12-04 19:30 ` Burgess, Freddie <FBurgess@Radiantblue.com>
2014-12-04 23:06 ` Jonathan S. Katz <jonathan.katz@excoventures.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox