Re: [INTERFACES] postgres for spatial data

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

Browse pgsql-interfaces by date

  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