MAP
  FONTSET "../symbols/fontes.txt"
  SYMBOLSET "../symbols/simbolos.sym"
  LAYER
    CLUSTER
      MAXDISTANCE 20
      REGION "rectangle"
    END # CLUSTER
    CONNECTION "host=10.1.2.25 port=5432 dbname=dbspo user=luiscrneves password=130670"
    CONNECTIONTYPE POSTGIS
    DATA "geom from (
SELECT
geom,
'1'::text AS cores,
dbacoes_saude.tb_cnes_estabelecimento.no_fantasia,
dbacoes_saude.tb_cnes_estabelecimento.no_logradouro,
dbacoes_saude.tb_cnes_estabelecimento.nu_endereco,
dbacoes_saude.tb_cnes_estabelecimento.no_bairro,
dbacoes_saude.tb_cnes_estabelecimento.nu_telefone,
dbacoes_saude.tb_cnes_estabelecimento.co_cep,
dbgeral.tb_ibge.uf,
dbgeral.tb_ibge.cidade,
dbacoes_saude.tb_ubs_det.ano_ubs_det,
dbacoes_saude.tb_ubs_det.mes_ubs_det,
dbgeral.tb_estab_geo.co_cnes as co_cnes
FROM
dbacoes_saude.tb_ubs_det
LEFT JOIN dbgeral.tb_estab_geo ON dbacoes_saude.tb_ubs_det.co_cnes = dbgeral.tb_estab_geo.co_cnes
LEFT JOIN dbacoes_saude.tb_cnes_estabelecimento ON dbacoes_saude.tb_cnes_estabelecimento.co_cnes = dbacoes_saude.tb_ubs_det.co_cnes
LEFT JOIN dbgeral.tb_ibge ON dbacoes_saude.tb_cnes_estabelecimento.co_ibge = dbgeral.tb_ibge.ibge
WHERE
dbacoes_saude.tb_ubs_det.func_total = 'S' and dbacoes_saude.tb_ubs_det.ano_ubs_det=2014 and dbacoes_saude.tb_ubs_det.mes_ubs_det=12    
    ) as foo using unique co_cnes using srid=4674"
    METADATA
      "METAESTAT_ID_MEDIDA_VARIAVEL"	""
      "CLASSE"	"SIM"
      "permitekmz"	"nao"
      "METAESTAT_CODIGO_TIPO_REGIAO"	""
      "permitedownload"	"nao"
      "metaestat"	""
      "permiteogc"	"nao"
      "permitekml"	"nao"
      "TEMA"	"Cluster"
      "IDENTIFICA"	"SIM"
    END # METADATA
    NAME "testecluster"
    STATUS DEFAULT
    TEMPLATE "none.htm"
    TILEITEM "location"
    TYPE POINT
    UNITS METERS
    CLASS
      NAME "= 1"
      EXPRESSION ([Cluster:FeatureCount] = 1)
      STYLE
        COLOR 200 200 200
        OUTLINECOLOR 200 200 200
        SIZE 10
        SYMBOL "ponto"
      END # STYLE
    END # CLASS
    CLASS
      NAME "> 1"
      EXPRESSION (([Cluster:FeatureCount] > 1) AND ([Cluster:FeatureCount] <= 500))
      LABEL
        FONT "arial"
        SIZE 8
        OFFSET 0 0
        POSITION CC
        SHADOWSIZE 1 1
        TEXT "[Cluster:FeatureCount]"
        TYPE TRUETYPE
      END # LABEL
      STYLE
        COLOR 230 230 230
        OUTLINECOLOR 200 200 200
        SIZE 20
        SYMBOL "ponto"
      END # STYLE
    END # CLASS
    CLASS
      NAME "> 1"
      EXPRESSION (([Cluster:FeatureCount] > 500) AND ([Cluster:FeatureCount] <= 1000))
      LABEL
        FONT "arial"
        SIZE 8
        OFFSET 0 0
        POSITION CC
        SHADOWSIZE 1 1
        TEXT "[Cluster:FeatureCount]"
        TYPE TRUETYPE
      END # LABEL
      STYLE
        COLOR 240 240 240
        OUTLINECOLOR 200 200 200
        SIZE 28
        SYMBOL "ponto"
      END # STYLE
    END # CLASS
    CLASS
      NAME "> 1"
      EXPRESSION ([Cluster:FeatureCount] > 1000)
      LABEL
        FONT "arial"
        SIZE 8
        OFFSET 0 0
        POSITION CC
        SHADOWSIZE 1 1
        TEXT "[Cluster:FeatureCount]"
        TYPE TRUETYPE
      END # LABEL
      STYLE
        COLOR 250 250 250
        OUTLINECOLOR 200 200 200
        SIZE 32
        SYMBOL "ponto"
      END # STYLE
    END # CLASS
  END # LAYER

END # MAP