under laid layer does not diplay

Gagan Bansal gagan.bansal at RELIANCEADA.COM
Thu Nov 22 01:38:49 PST 2007


Hi

I am displaying many layers with different classes inside the layers.
the data I am accessing from oracle spatial.
I am not able to display the under laid layers only top layer is getting 
displayed.

enclosed is the sample map file.

 thanks

Gagan

-------------- next part --------------
MAP
#
# Start of map file
#
# Sample map file for a chameleon app.
#
NAME DEMO
STATUS ON
SIZE 1200 900
SYMBOLSET ../etc/symbols.sym
#EXTENT 270000 2100000 279000  2110000
EXTENT -197273 789426 2735369 4103591 
UNITS METERS
SHAPEPATH "../data1"
IMAGECOLOR 255 255 255
FONTSET ../etc/fonts.txt
TRANSPARENT OFF

OUTPUTFORMAT
  NAME png24
  DRIVER "GD/PNG"
  MIMETYPE "image/png"
  IMAGEMODE RGB
  EXTENSION "png"  
END
#
# Start of web interface definition
#
WEB
  #MINSCALE 2000000
  #MAXSCALE 50000000
  MAXSCALE 16125993
#
# On Windows systems, /tmp and /tmp/ms_tmp/ should be created at the root 
# of the drive where the .MAP file resides.
#
  IMAGEPATH "/ms4w/tmp/ms_tmp/" 
  IMAGEURL "/ms_tmp/"
#  LOG "/tmp/gmap.log"
  METADATA
  END
END

#
# Start of reference map
#
REFERENCE
   IMAGE images/keymap.gif
   EXTENT 270000 2100000 279000  2110000
   STATUS ON
  COLOR -1 -1 -1
  OUTLINECOLOR 255 0 0
  SIZE 120 90      
END

PROJECTION
   "init=epsg:32643"
END

# Start of layer definitions
#----------------Building-------#
LAYER
  GROUP "Polygon"
  NAME "build_utm"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  #DATA building
  DATA "GEOM FROM BUILD_UTM USING UNIQUE OBJECTID SRID 32643 VERSION 10g"  
  #DATA "GEOM FROM (select t.geom,t.objectid,t.bldgname from build_utm t where SDO_WITHIN_DISTANCE(t.geom, SDO_GEOMETRY(2001,32643,SDO_POINT_TYPE( 273977.776, 2104464.25,NULL),NULL,NULL), 'distance =1000 querytype=FILTER') = 'TRUE') USING UNIQUE OBJECTID SRID 32643 VERSION 10g"  
  METADATA
    "DESCRIPTION"   "building"
    "RESULT_FIELDS" "BLDGNAME"
    "GROUP" "Polygon"
    "LAYER" "build_utm"
    "QUERYABLE" "TRUE"
    "SEARCHFIELD" "OBJECTID"
  END
  TYPE POLYGON
  STATUS OFF
  
  CLASS
    NAME "BUILDING"
    COLOR 200 255 0
    OUTLINECOLOR 120 120 120
    TEMPLATE "C:/ttt_query1.html"
  END
  TOLERANCE 5

 END # Layer
##########LAYER States ##############
LAYER
  GROUP "Polygon"
  NAME "states_utm"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  DATA "GEOM FROM states_utm USING UNIQUE OBJECTID SRID 32643 VERSION 10g"  
 
  METADATA
    "DESCRIPTION"   "States"
    "RESULT_FIELDS" "STATENAME"
    "GROUP" "Polygon"
    "LAYER" "states_utm"
    "QUERYABLE" "TRUE"
    "SEARCHFIELD" "OBJECTID"
  END
  TYPE POLYGON
  STATUS ON
  
  CLASS
    NAME "States"
    COLOR 255 255 190
    OUTLINECOLOR 0 0 0 
    #OUTLINEWIDTH 0.40
    TEMPLATE "C:/ttt_query1.html"
  END
  TOLERANCE 5

 END # Layer

##########LAYER ##############
##########LAYER City ##############
LAYER
  GROUP "Polygon"
  NAME "city_utm"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  DATA "GEOMPG FROM city_UTM USING UNIQUE OBJECTID SRID 32643 VERSION 10g"  
 
  METADATA
    "DESCRIPTION"   "City"
    "RESULT_FIELDS" "CITY"
    "GROUP" "Polygon"
    "LAYER" "city_utm"
    "QUERYABLE" "TRUE"
    "SEARCHFIELD" "OBJECTID"
  END
  TYPE POLYGON
  STATUS ON
  
  CLASS
    NAME "City"
    COLOR 255 255 240
    OUTLINECOLOR 0 0 0 
    TEMPLATE "C:/ttt_query1.html"
  END
  TOLERANCE 5

 END # Layer
##########LAYER LandUse###############
LAYER
  GROUP "Polygon"
  NAME "LU_MUM_UTM"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  DATA "GEOM FROM LU_MUM_UTM USING UNIQUE Type SRID 32643 VERSION 10g"  
  CLASSITEM "TYPE"
 
  METADATA
    "DESCRIPTION"   "Landuse"
  
    "GROUP" "Polygon"
    "LAYER" "LU_MUM_UTM"
    "QUERYABLE" "FALSE"
  END
  TYPE POLYGON
  STATUS ON

  CLASS
    
    NAME "Water Pools"
    EXPRESSION "Ponds / Swimming"
    COLOR 151 219 242
    OUTLINECOLOR 151 219 242
    
  END
  
  CLASS
    
    NAME "Water Bodies"
    EXPRESSION /Canal|Drains|Forest|Hydrology - Others|Lakes|River|Reservoir/
    COLOR 151 219 242
    OUTLINECOLOR 151 219 242
    
  END

  CLASS
    
    NAME "Parks"
    EXPRESSION /Golf Course|Park/
    COLOR 163 215 115
    OUTLINECOLOR 163 255 115
    
  END

  CLASS
    
    NAME "Open Space"
    EXPRESSION "Open Space"
    COLOR 255 234 201
    OUTLINECOLOR 255 234 201
    
  END


  CLASS
    
    NAME "Sandy Area - Beach"
    EXPRESSION "Sandy Area / Beach"
    COLOR 225 225 225
    OUTLINECOLOR 225 225 225
    
  END

  CLASS
    
    NAME "Plantations"
    EXPRESSION "Plantations"
    COLOR 115 178 115
    OUTLINECOLOR 115 178 115
    
  END

  CLASS
    
    NAME "Play Ground Sports Complex"
    EXPRESSION /Play Ground|Sports Complex/
    COLOR 239 228 190
    OUTLINECOLOR 239 228 190
    
  END

  CLASS
    
    NAME "Rocky Area"
    EXPRESSION "Rocky Area"
    COLOR 168 112 0
    OUTLINECOLOR 168 112 0
    
  END

  CLASS
    
    NAME "Swampy-Marshy"
    EXPRESSION "Swampy/Marshy"
    COLOR 238 241 160
    OUTLINECOLOR 238 241 160
    
  END

  CLASS
    
    NAME "Traffic Islands"
    EXPRESSION "Traffic Islands"
    COLOR 156 156 156
    OUTLINECOLOR 156 156 156
    
  END

  TOLERANCE 5

 END # Layer
##########LAYER Railway##############

LAYER
  GROUP "Line"
  NAME "railway_utm"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  DATA "GEOM FROM railway_utm"  
#"GEOM FROM railway_utm USING UNIQUE OBJECTID SRID 32643 VERSION 10g"
  METADATA
    "DESCRIPTION"   "railways"
    "RESULT_FIELDS" "OBJECTID"
    "GROUP" "Line"
    "LAYER" "Railway"
  END
  TYPE Line
  STATUS ON

  CLASS
   SYMBOL "cartoline"
   color 154 154 154
   size 2
  END

  TOLERANCE 5

 END # Layer
##########LAYER Road##############
LAYER
  GROUP "Line"
  NAME "road_utm"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  DATA "GEOM FROM MUM_RD_UTM USING UNIQUE OBJECTID SRID 32643 VERSION 10g"  
  CLASSITEM "SPEEDCLASS"
  LABELITEM "STREETNAME"
  METADATA
    "DESCRIPTION"   "Road"
    "RESULT_FIELDS" "OBJECTID"
    "GROUP" "Line"
    "LAYER" "Road"
  END
  TYPE Line
  STATUS ON
  TRANSPARENCY alpha
  CLASS
    NAME "HIGHWAY"
    #MAXSCALE 75000
    #MINSCALE 0
    EXPRESSION ([SPEEDCLASS] >= 50) 
    #style
     #SYMBOL 8
     #SIZE 8  
     #COLOR 0 0 0
    #end 
   style
    SYMBOL 8
    SIZE 7  
    COLOR 254 144 16
    ANTIALIAS true
   end
 
  END

  CLASS
    NAME "MAJOR-ROADS"
    MAXSCALE 75000
    MINSCALE 0
    EXPRESSION ([SPEEDCLASS] < 50 AND [SPEEDCLASS] >= 20)
    #style
     #SYMBOL 8
     #SIZE 6  
     #COLOR 0 0 0
    #end 
   style
    SYMBOL 8
    SIZE 5  
    COLOR 230 221 53
    ANTIALIAS true
   end 

  END

  CLASS
    NAME "MINOR-ROADS"
    MAXSCALE 15000
    MINSCALE 0
    EXPRESSION ([SPEEDCLASS] < 20)
    #style
     #SYMBOL 8
     #SIZE 5  
     #COLOR 0 0 0
    #end 
   style
    SYMBOL 8
    SIZE 2  
    COLOR 104 104 104
    ANTIALIAS true
   end 
  END
  TOLERANCE 5

 END # Layer

##########LAYER Landmarks#############
LAYER
  GROUP "Point"
  NAME "landmarks_utm1"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  DATA "GEOM FROM landmarks_utm USING UNIQUE OBJECTID SRID 32643 VERSION 10g"
  FILTER "DISPLAYCLA = 1"
 # CLASSITEM "DISPLAYCLA"
  CLASSITEM "SYMBOLID"
  LABELITEM "LANDMARKNA"
  MAXSCALE 35000   
  METADATA
    "DESCRIPTION"   "Landmarks"
    "RESULT_FIELDS" "LANDMARKNA"
    "GROUP" "Point"
    "LAYER" "Landmarks"
    "QUERYABLE" "TRUE"
    "SEARCHFIELD" "OBJECTID"
  END
  TYPE Point
  STATUS ON
  
CLASS
    NAME "garden"
    EXPRESSION "P303"
style
    SYMBOL "park2"
    Size 18  
    COLOR 0 166 57
end
style
    SYMBOL "park"
    Size 18  
    COLOR 157 79 33
end

    TEMPLATE "C:/ttt_query1.html"
  END
  CLASS
    NAME "petroleum"
    EXPRESSION  /P103|P452/
    SYMBOL "petrol"
    Size 18  
    COLOR 0 0 0
    #LABEL
     # COLOR  255 0 0
     # FONT fritqat-italic
     # TYPE truetype
     # SIZE 8
     # POSITION AUTO     
     # PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    #END 

    TEMPLATE "C:/ttt_query1.html"
  END

CLASS
    NAME "bus-depot"
    EXPRESSION "P174"
style
    SYMBOL "bus-depot2"
    Size 18  
    COLOR 255 255 255
end
style
    SYMBOL "bus-depot"
    Size 18  
    COLOR 0 56 147
end
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 8
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END 

    TEMPLATE "C:/ttt_query1.html"
END
CLASS
    NAME "railway-station"
    EXPRESSION "P175"
style
    SYMBOL "bus-depot2"
    Size 18  
    COLOR 255 255 255
end
style
    SYMBOL "railway"
    Size 18  
    COLOR 0 56 147
end
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 6
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END     
    TEMPLATE "C:/ttt_query1.html"
END

  CLASS
    NAME "university"


    EXPRESSION "P201"
    SYMBOL "university"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "school"


    EXPRESSION "P202"
    SYMBOL "school"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "postofc"
    EXPRESSION "P251"
    SYMBOL "postofc"
    Size 18  
    COLOR 0 0 0
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 8
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "fire-station"


    EXPRESSION "P257"
    SYMBOL "fire-station"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "police"
    EXPRESSION /P259|P264/
    SYMBOL "police"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END



  CLASS
    NAME "cremation"
    EXPRESSION "P307"
    SYMBOL "cremation"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "cemetry"
    EXPRESSION "p308"
    SYMBOL "cemetry"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "mills"
    EXPRESSION "P407"
    SYMBOL "mills"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "gymkhana"
    EXPRESSION "P451"
    SYMBOL "gymkhana"
    Size 18  
    COLOR 168 0 255
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 8
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "temple"
    EXPRESSION "P458"
    SYMBOL "temple"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "church"
    EXPRESSION "P459"
    SYMBOL "church"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "mosque"
    EXPRESSION "P460"
    SYMBOL "mosque"
    Size 18  
    COLOR 0 200 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "convention"
    EXPRESSION "P463"
    SYMBOL "conventional-halls"
    Size 18  
    COLOR 168 0 255
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 8
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END
    TEMPLATE "C:/ttt_query1.html"
  END


  CLASS
    NAME "cinema"
    EXPRESSION "P464"
    SYMBOL "cinema"
    Size 18  
    COLOR 0 0 0
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 8
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "guruduara"
    EXPRESSION "P466"
    SYMBOL "guruduara"
    Size 18  
    COLOR 255 255 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "hospital"
    EXPRESSION "P501"
    SYMBOL "hospital"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "hotel"
    EXPRESSION "P504"
    SYMBOL "hotel"
    Size 18  
    COLOR 0 0 0
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 8
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "guest-house"
    EXPRESSION "P505"
    SYMBOL "hotel"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "medical-college"


    EXPRESSION "P507"
    SYMBOL "mcollege"
    Size 18  
    COLOR 0 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "stadium"
    EXPRESSION "P601"
    SYMBOL "stadium"
    Size 18  
    COLOR 168 0 255
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 8
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "science-museum"
    EXPRESSION "P654"
    SYMBOL "museum"
    Size 18  
    COLOR 168 0 255
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 8
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "bank"
    EXPRESSION "P7"
    SYMBOL "bank"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  TOLERANCE 5

 END # Layer

############################################
LAYER
  GROUP "Point"
  NAME "landmarks_utm2"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  DATA "GEOM FROM landmarks_utm USING UNIQUE OBJECTID SRID 32643 VERSION 10g"
  FILTER "DISPLAYCLA = 2"
 # CLASSITEM "DISPLAYCLA"
  CLASSITEM "SYMBOLID"
  LABELITEM "LANDMARKNA"
  MAXSCALE 15000   
  METADATA
    "DESCRIPTION"   "Landmarks"
    "RESULT_FIELDS" "LANDMARKNA"
    "GROUP" "Point"
    "LAYER" "Landmarks"
    "QUERYABLE" "TRUE"
    "SEARCHFIELD" "OBJECTID"
  END
  TYPE Point
  STATUS ON
  
 
CLASS
    NAME "garden"
    EXPRESSION "P303"
style
    SYMBOL "park2"
    Size 18  
    COLOR 0 166 57
end
style
    SYMBOL "park"
    Size 18  
    COLOR 157 79 33
end
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 6
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END 

    TEMPLATE "C:/ttt_query1.html"
END
  CLASS
    NAME "petroleum"
    EXPRESSION  /P103|P452/
    SYMBOL "petrol"
    Size 18  
    COLOR 0 0 0
    #LABEL
     # COLOR  255 0 0
     # FONT fritqat-italic
     # TYPE truetype
     # SIZE 8
     # POSITION AUTO     
     # PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    #END 

    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "bus-depot"
    EXPRESSION "P174"
style
    SYMBOL "bus-depot2"
    Size 18  
    COLOR 255 255 255
end
style
    SYMBOL "bus-depot"
    Size 18  
    COLOR 0 56 147
end

    TEMPLATE "C:/ttt_query1.html"
  END
  CLASS
    NAME "railway-station"
    EXPRESSION "P175"
style
    SYMBOL "bus-depot2"
    Size 18  
    COLOR 255 255 255
end
style
    SYMBOL "railway"
    Size 18  
    COLOR 0 56 147
end
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "university"
    EXPRESSION "P201"
    SYMBOL "university"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "school"
    EXPRESSION "P202"
    SYMBOL "school"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "postofc"
    EXPRESSION "P251"
    SYMBOL "postofc"
    Size 18  
    COLOR 0 0 0
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 6
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END 
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "fire-station"
    EXPRESSION "P257"
    SYMBOL "fire-station"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "police"
    EXPRESSION /P259|P264/
    SYMBOL "police"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END


  CLASS
    NAME "cremation"
    EXPRESSION "P307"
    SYMBOL "cremation"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "cemetry"
    EXPRESSION "p308"
    SYMBOL "cemetry"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "mills"
    EXPRESSION "P407"
    SYMBOL "mills"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "gymkhana"
    EXPRESSION "P451"
    SYMBOL "gymkhana"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "temple"
    EXPRESSION "P458"
    SYMBOL "temple"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "church"
    EXPRESSION "P459"
    SYMBOL "church"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "mosque"
    EXPRESSION "P460"
    SYMBOL "mosque"
    Size 18  
    COLOR 0 200 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "convention"
    EXPRESSION "P463"
    SYMBOL "conventional-halls"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END


  CLASS
    NAME "cinema"
    EXPRESSION "P464"
    SYMBOL "cinema"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "guruduara"
    EXPRESSION "P466"
    SYMBOL "guruduara"
    Size 18  
    COLOR 255 255 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "hospital"
    EXPRESSION "P501"
    SYMBOL "hospital"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "hotel"
    EXPRESSION "P504"
    SYMBOL "hotel"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "guest-house"
    EXPRESSION "P505"
    SYMBOL "hotel"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "medical-college"
    EXPRESSION "P507"
    SYMBOL "mcollege"
    Size 18  
    COLOR 0 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "stadium"
    EXPRESSION "P601"
    SYMBOL "stadium"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "science-museum"
    EXPRESSION "P654"
    SYMBOL "museum"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "bank"
    EXPRESSION "P7"
    SYMBOL "bank"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  TOLERANCE 5

 END # Layer
###############################################

LAYER
  GROUP "Point"
  NAME "landmarks_utm3"
  CONNECTIONTYPE oraclespatial
  CONNECTION "scott/bigmaps at orcl"
  DATA "GEOM FROM landmarks_utm USING UNIQUE OBJECTID SRID 32643 VERSION 10g"
  FILTER "DISPLAYCLA = 3"
 # CLASSITEM "DISPLAYCLA"
  CLASSITEM "SYMBOLID"
  LABELITEM "LANDMARKNA"
  MAXSCALE 5000  
  METADATA
    "DESCRIPTION"   "Landmarks"
    "RESULT_FIELDS" "LANDMARKNA"
    "GROUP" "Point"
    "LAYER" "Landmarks"
    "QUERYABLE" "TRUE"
    "SEARCHFIELD" "OBJECTID"
  END
  TYPE Point
  STATUS ON
  
 
  CLASS
    NAME "garden"
    EXPRESSION "P303"
style
    SYMBOL "park2"
    Size 18  
    COLOR 0 166 57
end
style
    SYMBOL "park"
    Size 18  
    COLOR 157 79 33
end

    TEMPLATE "C:/ttt_query1.html"
  END
  CLASS
    NAME "petroleum"
    EXPRESSION  /P103|P452/
    SYMBOL "petrol"
    Size 18  
    COLOR 0 0 0
    #LABEL
     # COLOR  255 0 0
     # FONT fritqat-italic
     # TYPE truetype
     # SIZE 8
     # POSITION AUTO     
     # PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    #END 

    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "bus-depot"
    EXPRESSION "P174"
style
    SYMBOL "bus-depot2"
    Size 18  
    COLOR 255 255 255
end
style
    SYMBOL "bus-depot"
    Size 18  
    COLOR 0 56 147
end

    TEMPLATE "C:/ttt_query1.html"
  END
  CLASS
    NAME "railway-station"


    EXPRESSION "P175"
style
    SYMBOL "bus-depot2"
    Size 18  
    COLOR 255 255 255
end
style
    SYMBOL "railway"
    Size 18  
    COLOR 0 56 147
end
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "university"
    EXPRESSION "P201"
    SYMBOL "university"
    Size 18  
    COLOR 168 0 255
    LABEL
      COLOR  0 0 0
      FONT fritqat-italic
      TYPE truetype
      SIZE 6
      POSITION AUTO     
      PARTIALS FALSE
     #OUTLINECOLOR 255 255 255      
    END 
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "school"


    EXPRESSION "P202"
    SYMBOL "school"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "postofc"

    EXPRESSION "P251"
    SYMBOL "postofc"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "fire-station"


    EXPRESSION "P257"
    SYMBOL "fire-station"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "police"


    EXPRESSION /P259|P264/
    SYMBOL "police"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END



  CLASS
    NAME "cremation"


    EXPRESSION "P307"
    SYMBOL "cremation"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "cemetry"


    EXPRESSION "p308"
    SYMBOL "cemetry"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "mills"


    EXPRESSION "P407"
    SYMBOL "mills"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "gymkhana"


    EXPRESSION "P451"
    SYMBOL "gymkhana"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "temple"


    EXPRESSION "P458"
    SYMBOL "temple"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "church"


    EXPRESSION "P459"
    SYMBOL "church"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "mosque"


    EXPRESSION "P460"
    SYMBOL "mosque"
    Size 18  
    COLOR 0 200 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "convention"


    EXPRESSION "P463"
    SYMBOL "conventional-halls"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END


  CLASS
    NAME "cinema"


    EXPRESSION "P464"
    SYMBOL "cinema"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "guruduara"


    EXPRESSION "P466"
    SYMBOL "guruduara"
    Size 18  
    COLOR 255 255 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "hospital"


    EXPRESSION "P501"
    SYMBOL "hospital"
    Size 18  
    COLOR 168 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "hotel"


    EXPRESSION "P504"
    SYMBOL "hotel"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "guest-house"


    EXPRESSION "P505"
    SYMBOL "hotel"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "medical-college"


    EXPRESSION "P507"
    SYMBOL "mcollege"
    Size 18  
    COLOR 0 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "stadium"


    EXPRESSION "P601"
    SYMBOL "stadium"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "science-museum"


    EXPRESSION "P654"
    SYMBOL "museum"
    Size 18  
    COLOR 168 0 255
    TEMPLATE "C:/ttt_query1.html"
  END

  CLASS
    NAME "bank"


    EXPRESSION "P7"
    SYMBOL "bank"
    Size 18  
    COLOR 0 0 0
    TEMPLATE "C:/ttt_query1.html"
  END

  TOLERANCE 5

 END # Layer


END # Map File



More information about the MapServer-users mailing list