Re: [UMN_MAPSERVER-USERS] One shapefile, many countries, many colors?

[Pascal Ehlert]

That's great, thank you for the example.. Makes it a lot clearer :)

As an example I am usually using something similar like this:

LAYER
        NAME "Countries"      
        GROUP "Africa"
        TYPE POLYGON
        STATUS ON
  CONNECTIONTYPE postgis
  CONNECTION "user=me password=none dbname=africa host=localhost"
  DATA "the_geom from (select the_geom, countryname, area, gid from
africa_countries) as temp using unique gid using SRID=4326"
  # SRID 4326 is when using decimal degrees, replace with the correct SRID

for your data CLASSITEM "countryname"

        CLASS
                NAME "EGYPT"
                COLOR 153 204 143
                EXPRESSION ([countryname]=EGYPT)
        END
        CLASS
                NAME "LYBIA"
                COLOR 252 141 50
                EXPRESSION ([countryname]=LYBIA)
        END
        CLASS
                NAME "MADAGASCAR"
                COLOR 255 190 232
                EXPRESSION ([countryname]=MADAGASCAR)
        END     
END

Cheers
Karsten