#
# 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 
#

# Capabilities
# RUN_PARMS: sde_wms_cap.xml [MAPSERV] QUERY_STRING="map=[MAPFILE]&SERVICE=WMS&VERSION=1.1.0&REQUEST=GetCapabilities" > [RESULT_DEVERSION]
#
# Layer description
# RUN_PARMS: sde_wms_describe.xml [MAPSERV] QUERY_STRING="map=[MAPFILE]&SERVICE=WMS&VERSION=1.1.0&REQUEST=DescribeLayer&LAYERS=shppoly" > [RESULT]
#
# Draw a map with a single polygon layer.
# RUN_PARMS: sde_wms_get_map_polygon.png [MAPSERV] QUERY_STRING="map=[MAPFILE]&SERVICE=WMS&VERSION=1.1.0&REQUEST=GetMap&SRS=EPSG:4326&BBOX=2018000,-73300,3410396,647400&FORMAT=image/png&WIDTH=400&HEIGHT=300&STYLES=&LAYERS=shppoly" > [RESULT_DEMIME]
#
#
MAP

WEB
  METADATA
    "wms_title"            "Test simple wms"
    "wms_onlineresource"   "http://localhost/path/to/wms_simple?"
    "wms_srs"              "EPSG:42304 EPSG:42101 EPSG:4269 EPSG:4326"
    "ows_schemas_location" "http://ogc.dmsolutions.ca"
  END
END

PROJECTION
"init=epsg:4326"
END

STATUS ON
EXTENT 1283364.000001 457670.968990 1330430.374999 495313.843989

SIZE 400 300

IMAGETYPE png

DEBUG ON

LAYER
  NAME shppoly
  TYPE polygon
  CONNECTIONTYPE SDE
  CONNECTION "smoke.hobu.net,5151,sde,sde,osgeo"
  DATA "SDE.JOINTESTLAYER,SHAPE,SDE.DEFAULT"
  STATUS default
  DEBUG 3
  PROCESSING "JOINTABLE=SDE.JOINTESTTABLE"
  PROCESSING "JOINFROMFIELD=AQ_TAG"
  PROCESSING "JOINTOFIELD=AQ_TAG"
  FILTER "WHERE JOINTESTTABLE.AQ_TAG=JOINTESTLAYER.AQ_TAG"
  CLASSITEM "SDE.JOINTESTTABLE.VAL"
  CLASS
    NAME "selected"
    COLOR 0 0 255
    OUTLINECOLOR 255 0 0
    EXPRESSION "val1"
  END
  CLASS
    NAME "normal"
    COLOR 0 255 0
    OUTLINECOLOR 255 0 0
  END
END

END