p2r2uf1.map
1.67 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
MAP
FONTSET "../symbols/fontes.txt"
SYMBOLSET "../symbols/simbolos.sym"
LAYER
CONNECTION "user=postgres password=postgres dbname=pgutf8 host=localhost port=5432 options='-c client_encoding=LATIN1'"
CONNECTIONTYPE POSTGIS
DATA "the_geom FROM (select the_geom, sig_uf, totacidentes, gid FROM geo_br_estados as estados,(select comple,count(comple) as totacidentes FROM acidentes.acidente as a, acidentes.regiao as r WHERE r.tipo = 1 AND r.regiao = a.regiao group by comple )as contagem WHERE estados.sig_uf = contagem.comple) as foo USING UNIQUE gid USING SRID=4291"
METADATA
"CLASSE" "SIM"
"download" "SIM"
"permitekml" "sim"
"permiteogc" "sim"
"TEMA" "Total de acidentes por UF"
END
NAME "p2r2uf1"
STATUS OFF
TEMPLATE "none.htm"
TYPE POLYGON
UNITS METERS
CLASS
NAME "Quartil 1 (<=3)"
EXPRESSION ([totacidentes]<=3)
STYLE
ANGLE 360
COLOR 255 240 240
OPACITY 100
SYMBOL 0
END
END
CLASS
NAME "Quartil 2 (>3 e <=20)"
EXPRESSION (([totacidentes]>3)and([totacidentes]<=20))
STYLE
ANGLE 360
COLOR 255 230 230
OPACITY 100
SYMBOL 0
END
END
CLASS
NAME "Quartil 3 (>20 e <=89)"
EXPRESSION (([totacidentes]>20)and([totacidentes]<=89))
STYLE
ANGLE 360
COLOR 255 150 150
OPACITY 100
SYMBOL 0
END
END
CLASS
NAME "Quartil 4 (>89)"
EXPRESSION ([totacidentes]>89)
STYLE
ANGLE 360
COLOR 255 0 0
OPACITY 100
SYMBOL 0
END
END
END
END