<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>I'm just trying to
assess the suitability of using PostGIS for one of our projects and have the
following questions;</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>Assuming that we are
storing point, line and polygon data....</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>Given an irregular
closed polygon can we perform SQL statements along the lines of "give me all the
points that reside within the polygon?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>Given the same
polygon can we obtain all the lines that intersect the polygon?
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>For the above are
the coordinates of the intersection points calculated and
obtainable?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>Can we obtain all
the points within a certain radius of a specified points?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>Can we obtain all
the lines that reside entirely (without intersecting the boundary) within a
circle or an ellipse?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>Is it possible to
specify the segments of a polygon as being either a straight line, a rhumb line
or a great circle? This is necessary to avoid problems to do with the curvature
of the earth.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=928524709-19022004>Any feedback would
be greatly appreciated.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004>Brgrds</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004>Chris</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=928524709-19022004></SPAN></FONT> </DIV></BODY></HTML>