From: | "Josi Perez (3T Systems)" <josiperez3t(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Point inside/outside area constructed by an expanded path |
Date: | 2010-10-14 19:00:55 |
Message-ID: | AANLkTim6gLxH5G37N+==6Lija4DnNYmb-d6FWED9-R7s@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I use postgreSQL.8.4.2 and don't have postGIS installed.
I have a geometric type polygon and I know that it is possible to determine
if a point it is inside or not of this polygon, using anything like that:
select
polygon('(-23.5672,-46.6510),(-23.5670,-46.65095),(-23.5672,-46.6508),(-23.5672,-46.6510)')
@> point('-23.567534,-46.64942')
The question:
Anyone knows an algorithm or have ideas how to determine if a point it is
inside an area constructed by geometric type path expanded for a known
distance?
Graphically:
the path
x=========x=======x
the path expanded by a distance
| | A |
| | |
-------x=========x=======x------- C
| | |
B | | |
the points A and B are inside and the point C are outside .
Suggestions are welcome.
Thanks in advance,
Josi Perez
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2010-10-14 19:16:09 | Re: Point inside/outside area constructed by an expanded path |
Previous Message | Devrim GÜNDÜZ | 2010-10-14 18:12:11 | Re: pgcluster |