postgis.map
2.03 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
MAP
FONTSET "../symbols/fontes.txt"
SYMBOLSET "../symbols/simbolos.sym"
LAYER
CONNECTION "user=postgres dbname=dbspo host=localhost port=5432 password=postgres"
CONNECTIONTYPE POSTGIS
DATA "cg_regiao from (SELECT public.tb_regiao.cg_regiao, gid, info.qtd, info.co_ibge_central FROM public.tb_regiao, (SELECT dbacoes_saude.tb_samu_192.amb_habilit_usb AS qtd, dbacoes_saude.tb_samu_192.co_ibge_central FROM dbacoes_saude.tb_samu_192 INNER JOIN dbacoes_saude.tb_samu_cod ON dbacoes_saude.tb_samu_192.co_samu = dbacoes_saude.tb_samu_cod.co_samu WHERE dbacoes_saude.tb_samu_192.mes_inclusao_samu = 3 AND dbacoes_saude.tb_samu_192.ano_inclusao_samu = 2011 AND dbacoes_saude.tb_samu_cod.mes_samu = 3 AND dbacoes_saude.tb_samu_cod.ano_samu = 2011 GROUP BY dbacoes_saude.tb_samu_192.co_ibge_central, dbacoes_saude.tb_samu_192.amb_habilit_usb ) AS info WHERE info.co_ibge_central = tb_regiao.ibge) as aids using unique gid using srid=4291"
METADATA
"CLASSE" "SIM"
"itemcegonha" "7"
"permitekmz" "nao"
"grupocegonha" "samu_cb"
"permitedownload" "sim"
"permiteogc" "sim"
"permitekml" "sim"
"TEMA" "Centrais do SAMU - Unidades Básicas"
"IDENTIFICA" "SIM"
END
NAME "postgis"
STATUS DEFAULT
TYPE POLYGON
UNITS METERS
CLASS
NAME "Sem informação"
EXPRESSION ([qtd]=0)
STYLE
ANGLE 360
COLOR 249 220 169
SYMBOL 0
WIDTH 1
END
END
CLASS
NAME "Entre 1 e 2"
EXPRESSION ([qtd]>=1 and [qtd]<=2)
STYLE
ANGLE 360
COLOR 225 220 109
SYMBOL 0
WIDTH 1
END
END
CLASS
NAME "Entre 3 e 9"
EXPRESSION ([qtd]>=3 and [qtd]<=9)
STYLE
ANGLE 360
COLOR 200 220 49
SYMBOL 0
WIDTH 1
END
END
CLASS
NAME "Acima de 9"
EXPRESSION ([qtd]>9)
STYLE
ANGLE 360
COLOR 155 211 0
SYMBOL 0
WIDTH 1
END
END
END
END