<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Forwarded Message ----<BR>From: Win Myint Aung <wma108@yahoo.com><BR>To: mapserver-dev@lists.umn.edu<BR>Sent: Thursday, February 22, 2007 11:41:29 AM<BR>Subject: Filter some rows from table in PostGre<BR><BR>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">
<DIV>Dear Members,</DIV>
<DIV> </DIV>
<DIV>I am a newbie for development of MapServer application. I have a problem about to retrieve geo spatial data from PostGre to show on map. I want to show some rows from a table.</DIV>
<DIV> </DIV>
<DIV>for example, there are 100 rows with geospatial data in a table. I only want to show 10 rows on map without removing other rows. please suggest me.</DIV>
<DIV> </DIV>
<DIV>Please see the followings. I </DIV>
<DIV> </DIV>
<DIV>LAYER #Confidence<BR> CONNECTIONTYPE postgis<BR> NAME "firepoint"<BR> CONNECTION "user=postgres password=1234 dbname=hotspot_db host=localhost port=5432"<BR> DATA "the_geom from hotspot_tmp "<BR> TOLERANCE 3<BR> STATUS ON<BR> TYPE POINT<BR> CLASSITEM "f_posibl"<BR> TEMPLATE '/ms4w/projects/hotspot/htdocs/templates/HFVS.html'<BR> CLASS<BR> NAME "Low"<BR> EXPRESSION ([f_posibl] < 40)<BR> STYLE<BR> COLOR 255 255 0 <BR> SYMBOL "square"<BR> OUTLINECOLOR 0 0 0<BR> SIZE 5<BR> END<BR> END<BR> CLASS<BR> NAME "Moderate"<BR> EXPRESSION (([f_posibl] > 40) and ([f_posibl] < 70))<BR> STYLE<BR> COLOR 255 155
55 <BR> SYMBOL "square"<BR> OUTLINECOLOR 0 0 0<BR> SIZE 5<BR> END <BR> END<BR> CLASS<BR> NAME "High"<BR> EXPRESSION ([f_posibl] > 70)<BR> STYLE<BR> COLOR 255 0 0 <BR> SYMBOL "square"<BR> OUTLINECOLOR 0 0 0<BR> SIZE 5<BR> END <BR> END<BR>END</DIV>
<DIV> </DIV>
<DIV>Thanks.</DIV>
<DIV> </DIV>
<DIV>Win Myint Aung</DIV></DIV><BR>
<HR SIZE=1>
Now that's room service! <A href="http://travel.yahoo.com/hotelsearchpage;_ylc=X3oDMTFtaTIzNXVjBF9TAzk3NDA3NTg5BF9zAzI3MTk0ODEEcG9zAzIEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--" target=_blank rel=nofollow>Choose from over 150,000 hotels <BR>in 45,000 destinations on Yahoo! Travel</A> to find your fit.</DIV><BR></DIV></div><br>
<hr size=1>Everyone is raving about <a href="http://us.rd.yahoo.com/evt=45083/*http://advision.webevents.yahoo.com/mailbeta">the all-new Yahoo! Mail beta.</a></body></html>