MAP
  NAME Victoria
  EXTENT 1158000 374000 1209000 410000 # victoria full map extents
#  EXTENT 0 0 5 5 # test map extents
  SIZE 550 550
  SHAPEPATH "data/"
  UNITS meters
  FONTSET "fonts/fonts.lst"
  SYMBOLSET "symbols.sym"
  IMAGECOLOR 224 224 224
  IMAGETYPE png
  PROJECTION
    "proj=aea"
    "ellps=GRS80"
    "lon_0=-126"
    "lat_0=45"
    "lat_1=50"
    "lat_2=58.5"
    "x_0=1000000"
  END

  WEB
    TEMPLATE "htdocs/template.html"
    IMAGEPATH "htdocs/tmp/"
    IMAGEURL "http://office.refractions.net/chodgson/MUM/htdocs/tmp/"
  END

  LEGEND
    STATUS ON
    LABEL
      TYPE TRUETYPE
      FONT arial
      COLOR 0 0 0
      SIZE 12
      ANTIALIAS TRUE
    END
  END

  SCALEBAR
    STATUS ON
    INTERVALS 4
    SIZE 200 2
    COLOR 0 0 0
    OUTLINECOLOR 0 0 0
    UNITS kilometers
    LABEL
      COLOR 0 0 0
      SIZE small
    END
  END

  LAYER
    NAME "test"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "geom from test"
    STATUS ON
    TYPE line
    CLASS
      COLOR 0 0 0
    END
  END

  LAYER
    NAME "elections"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "the_geom from elections"
    TYPE POLYGON
    STATUS ON
    PROJECTION
      "proj=aea"
      "ellps=GRS80"
      "lon_0=-126"
      "lat_0=45"
      "lat_1=50"
      "lat_2=58.5"
      "x_0=1000000"
    END
    CLASS
      OUTLINECOLOR 0 0 0
      COLOR 255 255 200
    END
  END

  LAYER
    NAME "elections_themed"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "the_geom from (SELECT gid, the_geom, vtotal::REAL / vregist::REAL AS percent FROM elections) as foo using srid=-1 using unique gid"
    TYPE POLYGON
    STATUS ON
    PROJECTION
      "proj=aea"
      "ellps=GRS80"
      "lon_0=-126"
      "lat_0=45"
      "lat_1=50"
      "lat_2=58.5"
      "x_0=1000000"
    END
    CLASSITEM percent
    CLASS
      EXPRESSION ([percent] < 0.30)
      OUTLINECOLOR 0 0 0
      COLOR 0 64 0
    END
    CLASS
      EXPRESSION ([percent] < 0.50 AND [percent] >= 0.30)
      OUTLINECOLOR 0 0 0
      COLOR 0 128 0
    END
    CLASS
      EXPRESSION ([percent] < 0.65 AND [percent] >= 0.50)
      OUTLINECOLOR 0 0 0
      COLOR 0 192 0
    END
    CLASS
      EXPRESSION ([percent] < 0.80 AND [percent] >= 0.65)
      OUTLINECOLOR 0 0 0
      COLOR 0 255 0
    END
    CLASS
      EXPRESSION ([percent] >= 0.80)
      OUTLINECOLOR 0 0 0
      COLOR 128 255 128
    END
  END

  LAYER
    NAME "roads"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "the_geom from roads"
    TYPE LINE
    STATUS ON
    PROJECTION
      "proj=aea"
      "ellps=GRS80"
      "lon_0=-126"
      "lat_0=45"
      "lat_1=50"
      "lat_2=58.5"
      "x_0=1000000"
    END
    CLASS
      COLOR 0 0 0
    END
  END

  LAYER
    NAME "roads_themed"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "the_geom from (SELECT roads.the_geom AS the_geom, roads.oid AS oid, min(distance(roads.the_geom, hospitals.the_geom)) AS dist FROM roads, hospitals GROUP BY roads.oid, roads.the_geom) as foo using srid=-1 using unique oid"
    TYPE LINE
    STATUS ON
    PROJECTION
      "proj=aea"
      "ellps=GRS80"
      "lon_0=-126"
      "lat_0=45"
      "lat_1=50"
      "lat_2=58.5"
      "x_0=1000000"
    END
    CLASSITEM dist
    CLASS
      EXPRESSION ([dist] < 1000)
      COLOR 0 255 0
    END
    CLASS
      EXPRESSION ([dist] >= 1000 AND [dist] < 2000)
      COLOR 255 255 0
    END
    CLASS
      EXPRESSION ([dist] >= 2000 AND [dist] < 4000)
      COLOR 192 192 0
    END
    CLASS
      EXPRESSION ([dist] >= 4000)
      COLOR 255 0 0
    END
  END
  
  LAYER
    NAME "road_labels"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "the_geom from (SELECT roads.gid as gid, roads.the_geom as the_geom, roads_attr.street FROM roads LEFT JOIN roads_attr ON roads.gid = roads_attr.gid) as foo using SRID=-1, using unique gid"
    TYPE ANNOTATION
    STATUS ON
    PROJECTION
      "proj=aea"
      "ellps=GRS80"
      "lon_0=-126"
      "lat_0=45"
      "lat_1=50"
      "lat_2=58.5"
      "x_0=1000000"
    END
    MAXSCALE 20000
    LABELITEM "street"
    SYMBOLSCALE 100000
    CLASS
      LABEL
        ANGLE AUTO
        SIZE 8
        MINSIZE 6
        MAXSIZE 8
        OFFSET -6 -6
        COLOR 0 128 64
        TYPE TRUETYPE
        FONT arial
        BUFFER 4
      END
    END
  END

  LAYER
    NAME "road_labels_grouped"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "the_geom from (SELECT street, collect(the_geom) as the_geom FROM roads GROUP BY street) as foo using SRID=-1 using unique street"
    TYPE ANNOTATION
    STATUS ON
    PROJECTION
      "proj=aea"
      "ellps=GRS80"
      "lon_0=-126"
      "lat_0=45"
      "lat_1=50"
      "lat_2=58.5"
      "x_0=1000000"
    END
    MAXSCALE 20000
    LABELITEM "street"
    SYMBOLSCALE 100000
    CLASS
      LABEL
        ANGLE AUTO
        SIZE 8
        MINSIZE 6
        MAXSIZE 8
        OFFSET -6 -6
        COLOR 0 128 64
        TYPE TRUETYPE
        FONT arial
        BUFFER 4
      END
    END
  END

  LAYER
    NAME "hospitals"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "the_geom from hospitals using srid=-1"
    TYPE point
    STATUS default
    PROJECTION
      "proj=aea"
      "ellps=GRS80"
      "lon_0=-126"
      "lat_0=45"
      "lat_1=50"
      "lat_2=58.5"
      "x_0=1000000"
    END
    CLASS
      SYMBOL star
      SIZE 7
      COLOR 0 0 255
    END
  END

  LAYER
    NAME "ocean"
    CONNECTIONTYPE postgis
    CONNECTION "host=hydra port=6543 dbname=mum user=chodgson"
    DATA "the_geom from ocean"
    TYPE POLYGON
    STATUS ON
    PROJECTION
      "proj=aea"
      "ellps=GRS80"
      "lon_0=-126"
      "lat_0=45"
      "lat_1=50"
      "lat_2=58.5"
      "x_0=1000000"
    END
    CLASS
      OUTLINECOLOR 0 0 0
      COLOR 192 224 255
    END
  END

END