From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | dgross(at)lri(dot)fr |
Cc: | Postgres Interfaces Mailing List <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: [INTERFACES] postgres for spatial data |
Date: | 1998-07-11 14:09:16 |
Message-ID: | 35A7720C.B254F09@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> I'm looking for a graphical interface that can display the
> geometric types like polygon,...
Don't know about pre-built utilities for graphical display of geometric
objects. Let us know what you discover.
> I'm also looking for SQL extension in order to make
> spatial queries (for example, a function that tells if a point
> belongs to the interior of a polygon)
There are already some operators available; for example, the "@"
operator is for "on or inside":
postgres=> select '(0,0)'::point
postgres-> @ '((0,1),(1,0),(0,-1),(-1,0))'::polygon;
?column?
--------
t
(1 row)
Look in the hardcopy or html doc set which is included in v6.3.x. You
need to do a "make install" from the doc directory to get them unpacked.
Good luck...
- Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Davies | 1998-07-12 04:53:21 | Re: [INTERFACES] postgres for spatial data |
Previous Message | Billy G. Allie | 1998-07-11 04:23:18 | Re: [INTERFACES] Character mode forms designer |