MAP
  EXTENT -180 -90 180 90
  FONTSET "fonts/fonts.txt"
  IMAGECOLOR 191 220 228
  IMAGETYPE png24
  SYMBOLSET "symbols/symbols.sym"
  SIZE 800 600
  STATUS ON
  UNITS DD
  NAME "internet"

  OUTPUTFORMAT
    NAME "png24"
    MIMETYPE "image/png"
    DRIVER "GD/PNG"
    EXTENSION "png"
    IMAGEMODE "RGB"
    TRANSPARENT FALSE
  END

  PROJECTION
    "init=epsg:4326"
  END
  LEGEND
    IMAGECOLOR 227 227 227
    KEYSIZE 20 15
    KEYSPACING 5 5
    LABEL
      SIZE SMALL
      TYPE BITMAP
      BACKGROUNDSHADOWSIZE 4 4
      BUFFER 0
      COLOR 0 0 0
      FORCE FALSE
      MINDISTANCE -1
      MINFEATURESIZE -1
      OFFSET 0 0
      PARTIALS FALSE
      SHADOWSIZE 4 4
    END
    POSITION LL
    STATUS ON
    TEMPLATE "ttt"
  END

  QUERYMAP
    COLOR 255 255 0
    SIZE -1 -1
    STATUS OFF
    STYLE HILITE
  END

  REFERENCE
    COLOR -1 -1 -1
    EXTENT -180 -90 180 90
    IMAGE "../images/worldkeymap.png"
    OUTLINECOLOR 255 0 0
    SIZE 200 150
    STATUS OFF
      MARKER 0
      MARKERSIZE 0
      MINBOXSIZE 3
      MAXBOXSIZE 0
  END

  SCALEBAR
    BACKGROUNDCOLOR 0 0 0
    COLOR 255 255 255
    IMAGECOLOR 255 255 255
    INTERVALS 3
    LABEL
      SIZE SMALL
      TYPE BITMAP
      BUFFER 0
      COLOR 0 0 0
      FORCE FALSE
      MINDISTANCE -1
      MINFEATURESIZE -1
      OFFSET 0 0
      PARTIALS TRUE
    END
    OUTLINECOLOR 0 0 0
    POSITION LL
    SIZE 250 5
    STATUS ON
    STYLE 0
    UNITS MILES
  END

  WEB
    IMAGEPATH "/ms4w/apps/ka-map/ka-cache/images/"
    IMAGEURL "/ka-map/ka-cache/images/"
    QUERYFORMAT text/html
    LEGENDFORMAT text/html
    BROWSEFORMAT text/html
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2005 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2005"
    METADATA
      "year"	"2005"
      "indicator"	"internet"
      "level"	"countries"
    END
    NAME ".internet.2005"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2004 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2004"
    METADATA
      "year"	"2004"
      "indicator"	"internet"
      "level"	"countries"
    END
    NAME ".internet.2004"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2003 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2003"
    METADATA
      "year"	"2003"
      "indicator"	"internet"
      "level"	"countries"
    END
    NAME ".internet.2003"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2002 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2002"
    METADATA
      "year"	"2002"
      "indicator"	"internet"
      "level"	"countries"
    END
    NAME ".internet.2002"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2001 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2001"
    METADATA
      "year"	"2001"
      "indicator"	"internet"
      "level"	"countries"
    END
    NAME ".internet.2001"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2005 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2005"
    METADATA
      "year"	"2005"
      "indicator"	"internet"
      "level"	"subregions"
    END
    NAME ".internet.2005"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2004 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2004"
    METADATA
      "year"	"2004"
      "indicator"	"internet"
      "level"	"subregions"
    END
    NAME ".internet.2004"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2003 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2003"
    METADATA
      "year"	"2003"
      "indicator"	"internet"
      "level"	"subregions"
    END
    NAME ".internet.2003"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2002 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2002"
    METADATA
      "year"	"2002"
      "indicator"	"internet"
      "level"	"subregions"
    END
    NAME ".internet.2002"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2001 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2001"
    METADATA
      "year"	"2001"
      "indicator"	"internet"
      "level"	"subregions"
    END
    NAME ".internet.2001"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2005 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2005"
    METADATA
      "year"	"2005"
      "indicator"	"internet"
      "level"	"regions"
    END
    NAME ".internet.2005"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2004 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2004"
    METADATA
      "year"	"2004"
      "indicator"	"internet"
      "level"	"regions"
    END
    NAME ".internet.2004"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2003 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2003"
    METADATA
      "year"	"2003"
      "indicator"	"internet"
      "level"	"regions"
    END
    NAME ".internet.2003"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2002 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2002"
    METADATA
      "year"	"2002"
      "indicator"	"internet"
      "level"	"regions"
    END
    NAME ".internet.2002"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( select g.gid, the_geom, value FROM  g LEFT JOIN ind_internet i ON g.code = i.code WHERE i.year = 2001 ) as foo using unique gid using srid=4326"
    GROUP ".internet.2001"
    METADATA
      "year"	"2001"
      "indicator"	"internet"
      "level"	"regions"
    END
    NAME ".internet.2001"
    STATUS OFF
    TOLERANCE 5
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([value]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 255 255 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from geo_countries using unique gid using  srid=4326"
    GROUP "always_on"
    NAME "always_on"
    STATUS ON
    TOLERANCE 5
    OPACITY ALPHA
    TYPE LINE
    UNITS METERS
    CLASS
      NAME "##legend.politicalBoundaries##"
      STYLE
        ANGLE 360
        OPACITY 100
        OUTLINECOLOR 255 255 0
        SYMBOL 0
      END
      TEMPLATE "ttt"
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from (select gid, the_geom, ((y2.value - y1.value) - 1)*100 as diff from geo_%level% g LEFT JOIN ind_%indicator% y1 JOIN ind_%indicator% y2 ON y1.code = y2.code ON g.code = y1.code and g.code = y2.code WHERE y1.year = %year1% and y2.year = %year2% ) as foo using unique gid using  srid=4326"
    GROUP "analysis"
    METADATA
      "tile_source"	"nocache"
    END
    NAME "analysis"
    STATUS OFF
    TOLERANCE 5
    OPACITY ALPHA
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "##legend.noValue##"
      EXPRESSION (length([diff]) = 0)
      STYLE
        ANGLE 360
        COLOR 200 200 200
        OPACITY 100
        OUTLINECOLOR 200 200 200
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME "<= -100%"
      EXPRESSION ([diff] <= -100)
      STYLE
        ANGLE 360
        COLOR 255 255 245
        OPACITY 100
        OUTLINECOLOR 255 255 245
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME "> -100%, <= -75%"
      EXPRESSION ([diff] > -100 AND [diff] <= -75)
      STYLE
        ANGLE 360
        COLOR 255 255 205
        OPACITY 100
        OUTLINECOLOR 255 255 205
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME "> -75%, <= -50%"
      EXPRESSION ([diff] > -75 AND [diff] <= -50)
      STYLE
        ANGLE 360
        COLOR 255 255 165
        OPACITY 100
        OUTLINECOLOR 255 255 165
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME "> -50%, <= -25%"
      EXPRESSION ([diff] > -50 AND [diff] <= -25)
      STYLE
        ANGLE 360
        COLOR 255 255 125
        OPACITY 100
        OUTLINECOLOR 255 255 125
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME "> -25%, < 0%"
      EXPRESSION ([diff] > -25 AND [diff] < 0)
      STYLE
        ANGLE 360
        COLOR 255 255 85
        OPACITY 100
        OUTLINECOLOR 255 255 85
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME "##legend.noChange##"
      EXPRESSION ([diff] = 0)
      STYLE
        ANGLE 360
        COLOR 100 100 100
        OPACITY 100
        OUTLINECOLOR 100 100 100
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME "> 0, <= 25%"
      EXPRESSION ([diff] > 0 AND [diff] =< 50)
      STYLE
        ANGLE 360
        COLOR 255 85 255
        OPACITY 100
        OUTLINECOLOR 255 85 255
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME ">= 25%, < 50%"
      EXPRESSION ([diff] >= 25 AND [diff] < 50)
      STYLE
        ANGLE 360
        COLOR 255 125 255
        OPACITY 100
        OUTLINECOLOR 255 125 255
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME ">= 50%, < 75%"
      EXPRESSION ([diff] >= 50 AND [diff] < 75)
      STYLE
        ANGLE 360
        COLOR 255 165 255
        OPACITY 100
        OUTLINECOLOR 255 165 255
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME ">= 75%, < 100%"
      EXPRESSION ([diff] >= 75 AND [diff] < 100)
      STYLE
        ANGLE 360
        COLOR 255 205 255
        OPACITY 100
        OUTLINECOLOR 255 205 255
        SIZE 6
        SYMBOL 0
      END
    END
    CLASS
      NAME ">= 100%"
      EXPRESSION ([diff] >= 100)
      STYLE
        ANGLE 360
        COLOR 255 255 255
        OPACITY 100
        OUTLINECOLOR 255 245 255
        SIZE 6
        SYMBOL 0
      END
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from geo_cities using unique gid using  srid=4326"
    GROUP "cities"
    METADATA
      "tile_source"	"redraw"
      "redraw_interval"	"1800"
    END
    NAME "cities"
    STATUS ON
    TOLERANCE 5
    OPACITY ALPHA
    TYPE POINT
    UNITS METERS
    CLASS
      NAME "##legend.cities##"
      STYLE
        ANGLE 360
        COLOR 0 163 240
        OPACITY 100
        SIZE 9
        SYMBOL "circle"
      END
      STYLE
        ANGLE 360
        OPACITY 100
        SYMBOL 0
      END
      TEMPLATE "ttt"
    END
  END

  LAYER
    CONNECTION "host=localhost dbname=atlas user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom FROM (SELECT gid, centroid(the_geom) as the_geom, %currentLocale% as locale from geo_%level%) as foo using unique gid using  srid=4326"
    GROUP "labels"
    LABELITEM "locale"
    METADATA
      "HIDEFROMLEGEND"	"TRUE"
      "tile_source"	"nocache"
    END
    NAME "labels"
    STATUS OFF
    TOLERANCE 5
    OPACITY ALPHA
    TYPE ANNOTATION
    UNITS METERS
    CLASS
      NAME "labels"
      LABEL
        ANGLE 0.000000
        ANTIALIAS TRUE
        FONT "sans"
        MAXSIZE 256
        MINSIZE 4
        SIZE 10
        TYPE TRUETYPE
        BUFFER 5
        COLOR 102 102 102
        FORCE FALSE
        MINDISTANCE 500
        MINFEATURESIZE 15
        OFFSET 0 0
        OUTLINECOLOR 242 236 230
        PARTIALS FALSE
        POSITION CC
        WRAP '*'
      END
    END
  END

END