Help Please on Map File

[Gary Watry]

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: watry at coaps.fsu.edu


-----Original Message-----
From: Pericles S. Nacionales [mailto:naci0002 at umn.edu] 
Sent: Friday, January 20, 2006 12:35 PM
To: Gary Watry
Cc: MAPSERVER-USERS at lists.umn.edu
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: naci0002 at umn.edu