testecluster.map
3.23 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
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