Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!news1.optus.net.au!optus!snewsf0.syd.ops.aspac.uu.net!nnrp1.ozemail.com.au!53ab2750!not-for-mail From: jess Newsgroups: comp.databases.oracle.tools Subject: help with query thanks Message-ID: X-Newsreader: Forte Free Agent 1.92/32.572 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 8 Date: Mon, 05 May 2003 22:23:52 +1000 NNTP-Posting-Host: 63.12.145.215 X-Trace: nnrp1.ozemail.com.au 1052137463 63.12.145.215 (Mon, 05 May 2003 22:24:23 EST) NNTP-Posting-Date: Mon, 05 May 2003 22:24:23 EST Xref: core-easynews comp.databases.oracle.tools:58784 X-Received-Date: Mon, 05 May 2003 05:23:53 MST (news.easynews.com) I have a long list of locations each with a latitude and longitude and I wish to select all that fall within an odd shaped boundary defined by lat and long points. I can select all within a radius of a point or all within a rectangle (the simple ones I guess) but need to select all within an odd shaped polygon such as as meandering river basin or a locality boundry. I will be using an sqlplus query to extract the locations. If OT please suggest a relavent group. I tried uk.education.maths but drew a blank.Thanks.