#
# Test of OGR SQL JOIN support via MapServer.  
#
# A joined field is used for the EXPRESSION used to classify the returned 
# polygons.
#   
# REQUIRES: INPUT=OGR OUTPUT=PNG INPUT=SDE
#
MAP

STATUS ON
EXTENT 113.157997 -35.132000 129.003204 -13.735800
SIZE 400 300

IMAGETYPE png

DEBUG ON
PROJECTION
'init=epsg:4283'
END #PROJECTION

LAYER
  NAME shppoly
  TYPE polygon
  CONNECTIONTYPE SDE
  CONNECTION "smoke.hobu.net,5151,sde,sde,osgeo"
  DATA "SDE.BUG_2072,SHAPE,SDE.DEFAULT"
  STATUS default
  DEBUG 3
  PROCESSING "CLOSE_CONNECTION=DEFER"
  DUMP TRUE
  UNITS DD

METADATA            
"wms_title"	"CALM - CALM_REGIONS (SDE)"            
"wms_name" "shppoly"
"wms_srs"	"epsg:4283 epsg:4326 epsg:28349 epsg:28350 epsg:28351"            
"ows_include_items" "all"        
END
        
PROJECTION            
'init=epsg:4283'        
END #PROJECTION

  CLASS
    NAME "selected"
    COLOR 0 0 255
    OUTLINECOLOR 255 0 0
  END
END

END