From: | "Brent Wood" <b(dot)wood(at)niwa(dot)co(dot)nz> |
---|---|
To: | <peterw(at)borstad(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Proper entry of polygon type data |
Date: | 2009-03-24 23:22:06 |
Message-ID: | 49CA21EE0200007B0001A028@gwia1.ham.niwa.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi Peter,
If you want to use Postgres to store/manage/query spatial data, I strongly recommend you look at PostGIS, & not the native Postgres geometry types.
Brent Wood
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
>>> Peter Willis <peterw(at)borstad(dot)com> 03/24/09 10:35 AM >>>
Hello,
I would like to use 'polygon' type data and am wondering about
the entry format of the vertex coordinates.
Are the coordinates of the polygon type to be entered one
entry per polygon vertex, or one entry per polygon edge segment?
For example:
I have a triangle with vertex corners A, B, C.
One entry per vertex format suggests
INSERT INTO my_table (my_polygon_column)
VALUES ( ((Ax,Ay),(Bx,By),(Cx,Cy)) );
One entry per edge format suggests
INSERT INTO my_table (my_polygon_column)
VALUES ( ((Ax,Ay),(Bx,By),(Bx,By),(Cx,Cy),(Cx,Cy),(Ax,Ay)) );
Which entry format is the correct one?
If per vertex format is the correct one, do I need to
'close' the path by entering the first vertex again at the end of the
list?
ie:
INSERT INTO my_table (my_polygon_column)
VALUES ( ((Ax,Ay),(Bx,By),(Cx,Cy),(Ax,Ay)) );
Thanks,
Peter
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2009-03-24 23:24:50 | Re: Last modification time of a database? |
Previous Message | Raymond O'Donnell | 2009-03-24 22:46:48 | Re: Res: Case sensitivity problems with user name |
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-03-24 23:52:42 | improving concurrent transactin commit rate |
Previous Message | Greg Stark | 2009-03-24 23:09:51 | Re: DTrace probes broken in HEAD on Solaris? |