testecluster.map
3.21 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
MAP
FONTSET "../symbols/fontes.txt"
SYMBOLSET "../symbols/simbolos.sym"
LAYER
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
"CLASSE" "SIM"
"permitekmz" "nao"
"permitedownload" "sim"
"permitekml" "sim"
"permiteogc" "sim"
"TEMA" "Cluster"
"IDENTIFICA" "SIM"
#"cache" "sim"
END
NAME "testecluster"
STATUS DEFAULT
TEMPLATE "none.htm"
TYPE POINT
UNITS METERS
CLUSTER
MAXDISTANCE 20 # in pixels
REGION "rectangle" # can be rectangle or ellipse
#GROUP (expression) # an expression to create separate groups for each value
#FILTER (expression) # a logical expression to specify the grouping condition
END
#CLASSITEM "Cluster_FeatureCount"
CLASS
NAME "= 1"
EXPRESSION ([Cluster:FeatureCount] = 1)
STYLE
COLOR 200 200 200
OUTLINECOLOR 200 200 200
SIZE 10
SYMBOL "ponto"
END
END
CLASS
NAME "> 1"
LABEL
FONT "arial"
SIZE 8
OFFSET 0 0
POSITION CC
TEXT "[Cluster:FeatureCount]"
TYPE TRUETYPE
END # LABEL
EXPRESSION (([Cluster:FeatureCount] > 1) AND ([Cluster:FeatureCount] <= 500))
STYLE
COLOR 230 230 230
OUTLINECOLOR 200 200 200
SIZE 20
SYMBOL "ponto"
END
END
CLASS
NAME "> 1"
LABEL
FONT "arial"
SIZE 8
OFFSET 0 0
POSITION CC
TEXT "[Cluster:FeatureCount]"
TYPE TRUETYPE
END # LABEL
EXPRESSION (([Cluster:FeatureCount] > 500) AND ([Cluster:FeatureCount] <= 1000))
STYLE
COLOR 240 240 240
OUTLINECOLOR 200 200 200
SIZE 28
SYMBOL "ponto"
END
END
CLASS
NAME "> 1"
LABEL
FONT "arial"
SIZE 8
OFFSET 0 0
POSITION CC
TEXT "[Cluster:FeatureCount]"
TYPE TRUETYPE
END # LABEL
EXPRESSION ([Cluster:FeatureCount] > 1000)
STYLE
COLOR 250 250 250
OUTLINECOLOR 200 200 200
SIZE 32
SYMBOL "ponto"
END
END
END
END