Fw: Filter some rows from table in PostGre
Win Myint Aung
wma108 at YAHOO.COM
Wed Feb 21 22:37:26 PST 2007
----- Forwarded Message ----
From: Win Myint Aung <wma108 at yahoo.com>
To: mapserver-dev at lists.umn.edu
Sent: Thursday, February 22, 2007 11:41:29 AM
Subject: Filter some rows from table in PostGre
Dear Members,
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.
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.
Please see the followings. I
LAYER #Confidence
CONNECTIONTYPE postgis
NAME "firepoint"
CONNECTION "user=postgres password=1234 dbname=hotspot_db host=localhost port=5432"
DATA "the_geom from hotspot_tmp "
TOLERANCE 3
STATUS ON
TYPE POINT
CLASSITEM "f_posibl"
TEMPLATE '/ms4w/projects/hotspot/htdocs/templates/HFVS.html'
CLASS
NAME "Low"
EXPRESSION ([f_posibl] < 40)
STYLE
COLOR 255 255 0
SYMBOL "square"
OUTLINECOLOR 0 0 0
SIZE 5
END
END
CLASS
NAME "Moderate"
EXPRESSION (([f_posibl] > 40) and ([f_posibl] < 70))
STYLE
COLOR 255 155 55
SYMBOL "square"
OUTLINECOLOR 0 0 0
SIZE 5
END
END
CLASS
NAME "High"
EXPRESSION ([f_posibl] > 70)
STYLE
COLOR 255 0 0
SYMBOL "square"
OUTLINECOLOR 0 0 0
SIZE 5
END
END
END
Thanks.
Win Myint Aung
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
____________________________________________________________________________________
Want to start your own business?
Learn how on Yahoo! Small Business.
http://smallbusiness.yahoo.com/r-index
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070221/05676067/attachment.htm>
More information about the MapServer-users
mailing list