<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" 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)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{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";
mso-believe-normal-left:yes;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<![if mso 9]>
<style>
p.MsoNormal
{margin-left:3.0pt;}
</style>
<![endif]>
</head>
<body lang=EN-US link=blue vlink=blue style='margin-left:3.0pt;margin-top:3.0pt;
margin-right:3.0pt;margin-bottom:.75pt'>
<div class=Section1>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>We are just getting our feet wet with
PostGIS, running Mapserver as CGI on IIS6. We have a basic
question. Below is an example of our layer from the mapfile.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>LAYER<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> NAME
"testlayer"<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> TYPE
POLYGON <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> CONNECTIONTYPE
POSTGIS<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> CONNECTION
"dbname=mydb user=myuser password=mypw host=myserver port=5432"<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> DATA
"wkb_geometry from (select * from
getcounty(-122.4419846666667,47.250942883333)) As myTable USING UNIQUE ogc_fid
using SRID=32767" <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> STATUS
default<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> TRANSPARENCY
50<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> LABELITEM
"population" <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> CLASS
<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> EXPRESSION
([population] > 0)<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> COLOR
255 245 220<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> MINSCALE
0<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> MAXSCALE
100000000 <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> STYLE<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> OUTLINECOLOR
25 25 45<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> SYMBOL
'cartoline'<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> SIZE
1<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> END<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> LABEL
<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> FONT
"Arialbd"<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> TYPE
TRUETYPE<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> ANTIALIAS
TRUE<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> COLOR
0 0 0<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> OUTLINECOLOR
255 255 220<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> SIZE
8<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> MINDISTANCE
300<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> END<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> END<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> PROJECTION<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> "init=epsg:4269"<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> END<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:5.0pt;margin-right:3.0pt;
margin-bottom:5.0pt;margin-left:3.0pt'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>END # postGIS test<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The question is, when the user clicks on
the map, how do we pass the location of that click into PostGIS as a
parameter. Thanks in advance for your help.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Chip <st1:City w:st="on"><st1:place w:st="on">Taylor</st1:place></st1:City><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
</div>
</div>
</body>
</html>