This works, I could not see the trees because the forest was blocking my view. Thanks ______________________________________________________________ Gary L. Watry
GIS Coordinator Center for Ocean-Atmospheric Prediction Studies FSU / COAPS Johnson Building, RM 215 2035 East Paul Dirac Drive Tallahassee, Florida 32306-2840 E-Mail: [EMAIL PROTECTED] -----Original Message----- From: Pericles S. Nacionales [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 12:35 PM To: Gary Watry Cc: [email protected] Subject: Re: [UMN_MAPSERVER-USERS] Help Please on Map File Gary, You'll need to use logical expressions to use multiple fields from your table: LAYER #1 ... CLASS ... EXPRESSION ('[CATEGORY]' eq 'TS' and '[ENSOPHASE]' eq 'El Nino' and '[MAJOR]' eq 'Minor') END CLASS ... EXPRESSION ('[CATEGORY]' eq 'H2' and '[ENSOPHASE]' eq 'El Nino' and '[MAJOR]' eq 'Minor') END END # Layer 1 LAYER #2 ... CLASS ... EXPRESSION ('[CATEGORY]' eq 'H4' and '[ENSOPHASE]' eq 'La Nina' and '[MAJOR]' eq 'Major') END CLASS ... EXPRESSION ('[CATEGORY]' eq 'H3' and '[ENSOPHASE]' eq 'La Nina' and '[MAJOR]' eq 'Major') END END # Layer 2 More info on expressions here: http://mapserver.gis.umn.edu/docs/reference/mapfile/class Cheers! Perry On Friday 20 January 2006 10:56, Gary Watry wrote: > Here is what I have > I have a database with the following > Fields Values > Category 'TS' 'H1' 'H2' 'H3' 'H4' 'H5' > ENSOPhase 'El Nino' 'La Nina' 'Neutral' > Major 'Major' 'Minor' > > I know how to filter using the > > CLASSITEM "CATERGORY" > > CLASS > EXPRESSION /H1/ > > What I need to do is filter by ENSOPhase and Major as well as by Category > ie.layer #1 > 'TS' 'El Nino' 'Minor' > 'H2' 'El Nino' 'Minor' > > or layer #2 > 'H4' 'La Nina' 'Major' > 'H3' 'La Nina' 'Major' > > I build my symbology off the Category Column -- Pericles S. Nacionales Conservation Biology Program University of Minnesota e-mail: [EMAIL PROTECTED]
