MAP
  FONTSET "../symbols/fontes.txt"
  SYMBOLSET "../symbols/simbolosv6.sym"
  LAYER
    CONNECTION "user=postgres password=postgres dbname=geosaude host=localhost port=5432"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from ( SELECT to_date(ano||'-01-01','YYYY') as ano,d.gid,d.pop_res_tot,d.co_municipio,g.no_cidade,g.co_uf,g.sg_uf,g.area_territorial,g.nu_ano_instalacao,st_setsrid(g.the_geom,4326) as the_geom FROM (SELECT * FROM ibge.populacao_residente  ) as d, i3geo_metaestat.municipios as g WHERE  d.co_municipio::text = g.co_municipio::text   ) as foo using unique co_municipio using srid=4326"
    FILTER (ano = '1970-01-01') #necessario para usar como mapfile normal
    METADATA
      "METAESTAT_ID_MEDIDA_VARIAVEL"	""
      "wms_enable_request"	"*"
      "CLASSE"	"SIM"
      "permitekmz"	"nao"
      "iconetema"	""
      "wms_timeitem"	"ano"
      "METAESTAT_CODIGO_TIPO_REGIAO"	""
      "wms_timeextent"	"1970,1980,1991,2000"
      "permitedownload"	"sim"
      "METAESTAT"	""
      "wms_timedefault"	"1970" #necessario quando e um WMS sem requisicao TIME
      "permiteogc"	"sim"
      "permitekml"	"sim"
      "TEMA"	"População total (pol) Município Teste de WMS Time"
      "wms_title"	"População total (pol) Município Teste de WMS Time"
    END # METADATA
    NAME "_lwmstime"
    STATUS DEFAULT
    TEMPLATE "none.htm"
    TILEITEM "location"
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "<= 6008"
      EXPRESSION ([pop_res_tot]<=6008)
      STYLE
        ANGLE 0
        COLOR 255 255 255
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 2
      END # STYLE
    END # CLASS
    CLASS
      NAME "> 6008 e <= 11531"
      EXPRESSION (([pop_res_tot]>6008)and([pop_res_tot]<=11531))
      STYLE
        ANGLE 0
        COLOR 207 207 255
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 2
      END # STYLE
    END # CLASS
    CLASS
      NAME "> 11531 e <= 22638"
      EXPRESSION (([pop_res_tot]>11531)and([pop_res_tot]<=22638))
      STYLE
        ANGLE 0
        COLOR 160 160 255
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 2
      END # STYLE
    END # CLASS
    CLASS
      NAME "> 22638"
      EXPRESSION ([pop_res_tot]>22638)
      STYLE
        ANGLE 0
        COLOR 114 114 255
        OFFSET 0 0
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 2
      END # STYLE
    END # CLASS
  END # LAYER

END # MAP