Mark Cave-Ayland wrote:
Peter Willis wrote:
Incidentally, PostGIS uses PostgreSQL polygon, point, and path
data types.
Errr... no it doesn't. PostGIS uses its own internal types to represent
all the different geometries, although it does provide a cast between
the existing PostgreSQL types
On Mon, Mar 23, 2009 at 2:13 PM, Peter Willis wrote:
> 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 INT
Hi Brent,
I am aware of PostGIS and already use it. My question was regarding
the entry format of PostgreSQL polygon data. There is a void
in the PostgreSQL documentation regarding this.
Incidentally, PostGIS uses PostgreSQL polygon, point, and path
data types.
Using PostGIS for simple , non-ge
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 03/24/09 10:35 AM >>>
Hello,
I would like to us
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
