<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Query postGIS (ArcGIS shapefile) based on lat/lon position</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hi,</FONT>
<BR><FONT SIZE=2 FACE="Arial">I'm a new user of postgres/postGIS, (Win2000, postgres 8.0.3, postGIS 9.0.1) but I have managed to load the contents of an ArcGIS shapefile into postGIS and I'm able to query and retrieve records based on the table contents. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">What I'm struggling with is trying to formulate and execute a query based on a latitude/longitude position. I want to query and retrieve the one record that describes the shape that is positioned over a specific lat/lon position and I just don't know how to work with a lat/long position and the positions as described in the shape file. Can any one offer any suggestions as to how I can do this or where I may look for answers?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I appreciate any guidance that may be offered.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks,</FONT>
<BR><FONT SIZE=2 FACE="Arial">Courtney</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Courtney Greene</FONT>
<BR><FONT SIZE=2 FACE="Arial">Defence R&D Canada - Atlantic</FONT>
<BR><FONT SIZE=2 FACE="Arial">Integrated Signatures Management</FONT>
<BR><FONT SIZE=2 FACE="Arial">9 Grove Street (PO Box 1012)</FONT>
<BR><FONT SIZE=2 FACE="Arial">Dartmouth, Nova Scotia</FONT>
<BR><FONT SIZE=2 FACE="Arial">Tel: 902-426-3100, Ext. 258</FONT>
<BR><FONT SIZE=2 FACE="Arial">Email: Courtney.Greene@drdc-rddc.gc.ca</FONT>
</P>
<BR>
</BODY>
</HTML>