<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Palatino Linotype";
panose-1:2 4 5 2 5 5 5 3 3 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Palatino Linotype";}
h1
{margin-top:24.0pt;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:0in;
page-break-after:avoid;
font-size:13.0pt;
font-family:Arial;
text-transform:uppercase;}
h2
{margin-top:16.0pt;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:0in;
page-break-after:avoid;
font-size:13.0pt;
font-family:Arial;}
h3
{margin-top:16.0pt;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:0in;
page-break-after:avoid;
font-size:11.0pt;
font-family:Arial;
color:black;}
h4
{margin-top:16.0pt;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:0in;
page-break-after:avoid;
font-size:11.0pt;
font-family:Arial;
color:black;
font-style:italic;}
h5
{margin-top:16.0pt;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:.25in;
page-break-after:avoid;
font-size:11.0pt;
font-family:Arial;}
h6
{margin-top:16.0pt;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:.25in;
page-break-after:avoid;
font-size:11.0pt;
font-family:Arial;
font-style:italic;}
p.MsoHeading7, li.MsoHeading7, div.MsoHeading7
{margin-top:16.0pt;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:0in;
page-break-after:avoid;
font-size:11.0pt;
font-family:"Palatino Linotype";
font-weight:bold;}
p.MsoHeading8, li.MsoHeading8, div.MsoHeading8
{margin-top:16.0pt;
margin-right:0in;
margin-bottom:12.0pt;
margin-left:0in;
page-break-after:avoid;
font-size:11.0pt;
font-family:"Palatino Linotype";
font-weight:bold;
font-style:italic;}
p.MsoHeading9, li.MsoHeading9, div.MsoHeading9
{margin-top:12.0pt;
margin-right:0in;
margin-bottom:3.0pt;
margin-left:0in;
text-indent:0in;
mso-list:l0 level9 lfo1;
font-size:11.0pt;
font-family:Arial;}
p.MsoToc1, li.MsoToc1, div.MsoToc1
{margin-top:6.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Palatino Linotype";
text-transform:uppercase;
font-weight:bold;}
p.MsoToc2, li.MsoToc2, div.MsoToc2
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:22.5pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Palatino Linotype";
text-transform:uppercase;}
p.MsoToc3, li.MsoToc3, div.MsoToc3
{margin-top:0in;
margin-right:-1.8pt;
margin-bottom:0in;
margin-left:49.5pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Palatino Linotype";}
p.MsoToc4, li.MsoToc4, div.MsoToc4
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:1.0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Palatino Linotype";}
p.MsoToc5, li.MsoToc5, div.MsoToc5
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:99.0pt;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Palatino Linotype";}
p.MsoToc7, li.MsoToc7, div.MsoToc7
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:66.0pt;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Times New Roman";}
p.MsoToc8, li.MsoToc8, div.MsoToc8
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:77.0pt;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Times New Roman";}
p.MsoNormalIndent, li.MsoNormalIndent, div.MsoNormalIndent
{margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.25in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Palatino Linotype";}
p.MsoHeader, li.MsoHeader, div.MsoHeader
{margin:0in;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Palatino Linotype";
font-style:italic;}
p.MsoFooter, li.MsoFooter, div.MsoFooter
{margin:0in;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Palatino Linotype";
font-style:italic;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.Dash1, li.Dash1, div.Dash1
{margin-top:6.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:.75in;
margin-bottom:.0001pt;
text-indent:0in;
mso-list:l1 level2 lfo4;
font-size:11.0pt;
font-family:"Palatino Linotype";}
p.Bullet1, li.Bullet1, div.Bullet1
{margin-top:6.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
text-indent:-.25in;
mso-list:l2 level1 lfo2;
font-size:11.0pt;
font-family:"Palatino Linotype";}
p.Bullet2, li.Bullet2, div.Bullet2
{margin-top:6.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:.75in;
margin-bottom:.0001pt;
text-indent:-.25in;
mso-list:l3 level1 lfo3;
font-size:11.0pt;
font-family:"Palatino Linotype";}
p.Bullet3, li.Bullet3, div.Bullet3
{margin-top:6.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:1.0in;
margin-bottom:.0001pt;
text-indent:-.25in;
mso-list:l1 level1 lfo4;
font-size:11.0pt;
font-family:"Palatino Linotype";}
span.EmailStyle20
{mso-style-type:personal-compose;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
p.section1, li.section1, div.section1
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
p.Dash2, li.Dash2, div.Dash2
{margin-top:6.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:1.0in;
margin-bottom:.0001pt;
text-indent:0in;
mso-list:l1 level2 lfo4;
font-size:11.0pt;
font-family:"Palatino Linotype";}
p.Dash3, li.Dash3, div.Dash3
{margin-top:6.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:1.25in;
margin-bottom:.0001pt;
text-indent:0in;
mso-list:l1 level2 lfo4;
font-size:11.0pt;
font-family:"Palatino Linotype";}
/* Page Definitions */
@page
{mso-endnote-separator:url("cid:header.htm\@01C85F7D.C1495B20") es;
mso-endnote-continuation-separator:url("cid:header.htm\@01C85F7D.C1495B20") ecs;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.2in 1.0in 1.2in;
mso-footer:url("cid:header.htm\@01C85F7D.C1495B20") f1;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:489558612;
mso-list-template-ids:870351120;}
@list l0:level1
{mso-level-reset-level:level1;
mso-level-tab-stop:.3in;
mso-level-number-position:left;
margin-left:.3in;
text-indent:-.3in;}
@list l0:level2
{mso-level-text:"%1\.%2";
mso-level-tab-stop:.4in;
mso-level-number-position:left;
margin-left:.4in;
text-indent:-.4in;}
@list l0:level3
{mso-level-text:"%1\.%2\.%3";
mso-level-tab-stop:.5in;
mso-level-number-position:left;
margin-left:.5in;
text-indent:-.5in;}
@list l0:level4
{mso-level-text:"%1\.%2\.%3\.%4";
mso-level-tab-stop:.6in;
mso-level-number-position:left;
margin-left:.6in;
text-indent:-.6in;}
@list l0:level5
{mso-level-text:"%1\.%2\.%3\.%4\.%5";
mso-level-tab-stop:.7in;
mso-level-number-position:left;
margin-left:.7in;
text-indent:-.7in;}
@list l0:level6
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6";
mso-level-tab-stop:.8in;
mso-level-number-position:left;
margin-left:.8in;
text-indent:-.8in;}
@list l0:level7
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7";
mso-level-tab-stop:.9in;
mso-level-number-position:left;
margin-left:.9in;
text-indent:-.9in;}
@list l0:level8
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8";
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
margin-left:1.0in;
text-indent:-1.0in;}
@list l0:level9
{mso-level-style-link:"Heading 9";
mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9";
mso-level-tab-stop:1.1in;
mso-level-number-position:left;
margin-left:1.1in;
text-indent:-1.1in;}
@list l1
{mso-list-id:561603655;
mso-list-type:hybrid;
mso-list-template-ids:466638720 -1101233956 1540783220 -266447652 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-style-link:"Bullet 3";
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:8.0pt;
mso-bidi-font-size:8.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-style-link:"Dash 1";
mso-level-text:\F02D;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:8.0pt;
mso-bidi-font-size:8.0pt;
font-family:Symbol;
mso-hide:none;
text-transform:none;
text-effect:none;
text-shadow:none;
text-effect:none;
text-effect:none;
mso-ansi-font-weight:normal;
mso-ansi-font-style:normal;
text-decoration:none;
text-line-through:none;
vertical-align:baseline;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\2013;
mso-level-tab-stop:1.45in;
mso-level-number-position:left;
margin-left:1.45in;
text-indent:-.2in;
mso-ansi-font-size:8.0pt;
mso-bidi-font-size:8.0pt;
font-family:Arial;
mso-bidi-font-family:"Times New Roman";
mso-hide:none;
text-transform:none;
text-effect:none;
text-shadow:none;
text-effect:none;
text-effect:none;
mso-ansi-font-weight:normal;
mso-ansi-font-style:normal;
text-decoration:none;
text-line-through:none;
vertical-align:baseline;}
@list l2
{mso-list-id:1184977693;
mso-list-type:hybrid;
mso-list-template-ids:16680572 -1569562056 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-style-link:"Bullet 1";
mso-level-text:\F0B7;
mso-level-tab-stop:.55in;
mso-level-number-position:left;
margin-left:.55in;
text-indent:.05in;
font-family:Symbol;
mso-hide:none;
text-transform:none;
text-effect:none;
text-shadow:none;
text-effect:none;
text-effect:none;
mso-ansi-font-weight:normal;
mso-ansi-font-style:normal;
text-decoration:none;
text-line-through:none;
vertical-align:baseline;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l3
{mso-list-id:1326857467;
mso-list-type:hybrid;
mso-list-template-ids:-983386244 -1571011738 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-style-link:"Bullet 2";
mso-level-text:\F0B7;
mso-level-tab-stop:.55in;
mso-level-number-position:left;
margin-left:.55in;
text-indent:.05in;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Symbol;
mso-hide:none;
text-transform:none;
text-effect:none;
text-shadow:none;
text-effect:none;
text-effect:none;
mso-ansi-font-weight:normal;
mso-ansi-font-style:normal;
text-decoration:none;
text-line-through:none;
vertical-align:baseline;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>I’m a new PostGIS/PostgreSQL user.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>I’ve successfully set up my database and uploaded a
few shapefiles to play with.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>I want to do some spatial queries and I’m having
some difficulty.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>I’d like to extract the polygon that a point
intersects – actually I really want to be able to intersect several
layers at once with a given point and return the values from a particular field
from each layer. But I decided to start with one layer. So the
table is called “r_zones” (it is an imported shapefile) and the
field I want information returned from is called “zone”. So
what I want is to know what “zone” the point falls within. I’m
using PgAdmin (v1.6.2) to query my database, Windows, Postgres8.2, PostGIS 1.3.1.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>So I’ve tried a basic query like this:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>SELECT the_geom, zone<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>FROM r_zones<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>WHERE GeomFromText('POINT(7644373.465626 687692.342075)',
2838)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>I know the WHERE statement is incorrect, I’ve tried
several variants looking at the docs (like using a distance based query and
others) but cannot make a successful query. Where am I going wrong?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Any help appreciated.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>-Thomas<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
</div>
</body>
</html>