<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><div>Hopefully, this is an easy one.</div><div><br></div><div>I'm trying to build a scale sensitive .map file using points from postgis.</div><div><br></div><div>I can successfully draw the shapefile states with a single points layer from postgis.</div><div>However, if I add an additional points layer and attempt to draw it the layer comes up blank.</div><div>If I remove the leading postgis points layer from the .map file the new points layer will now display.</div><div>IE I can only draw the first occurrence of a postgis layer in the map file.</div><div><br></div><div>How do you define multiple postgis layers so that you can pick and choose layers for display?</div><div><br></div><div>LAYER</div><div> NAME states</div><div> DATA STATES</div><div> STATUS ON</div><div> TYPE Polygon</div><div> </div><div> CLASS</div><div> OUTLINECOLOR 255 255 255</div><div> COLOR 155 155 155</div><div> END # Class</div><div> END # Layer</div><div> </div><div><div> LAYER</div><div> CONNECTIONTYPE POSTGIS</div><div> NAME business_rd2</div><div> CONNECTION "host=localhost dbname=Business user=postgres password=wacadmin port=5432"</div><div> PROCESSING "CLOSE_CONNECTION=DEFER"</div><div> DATA "geom From business_rd2 as rd2 using unique id using srid=4326" </div><div> #MINSCALE 100000 </div><div><span class="Apple-tab-span" style="white-space: pre;"> </span>STATUS ON</div><div> TYPE POINT</div><div> CLASS</div><div> SYMBOL 'circle'</div><div> SIZE 2</div><div> COLOR 255 0 0 </div><div> END</div><div> END # Class</div><div> END # Layer</div></div><div><br></div><div> LAYER</div><div> CONNECTIONTYPE POSTGIS</div><div> NAME business_rd1</div><div> CONNECTION "host=localhost dbname=Business user=postgres password=wacadmin port=5432"</div><div> PROCESSING "CLOSE_CONNECTION=DEFER"</div><div> DATA "geom From business_rd1 as rd1 using unique id using srid=4326" </div><div> #MINSCALE 100000 </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>STATUS ON</div><div> TYPE POINT</div><div> CLASS</div><div> SYMBOL 'circle'</div><div> SIZE 2</div><div> COLOR 255 0 0 </div><div> END</div><div> END # Class</div><div> END # Layer</div><br>Michael McInnis
6033 44th Ave. N.E.
Seattle, WA 98115
206 517-4701 </div></body>
</html>