_lparametrossql.map
2.5 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
MAP
FONTSET "../symbols/fontes.txt"
SYMBOLSET "../symbols/simbolosv6.sym"
LAYER
CONNECTION "user=postgres password=postgres dbname=i3geosaude host=localhost port=5432"
CONNECTIONTYPE POSTGIS
DATA "the_geom from /*SE*/(SELECT (j.valorcalculado) AS pop_res_tot, co_municipio,no_cidade,co_uf,sg_uf,area_territorial,nu_ano_instalacao,/*SG*/the_geom as the_geom /*SG*/ FROM i3geo_metaestat.municipios AS regiao INNER JOIN ( SELECT munic AS cod_regiao,sum(pop_res_tot) AS valorcalculado FROM ibge.populacao_residente WHERE ano IN ('ANO_DADOS')AND pop_res_tot IS NOT NULL /*FA*//*FA*/ /*FAT*//*FAT*/ GROUP BY cod_regiao ) AS j ON j.cod_regiao::text = regiao.co_municipio::text /*FR*//*FR*/ )/*SE*/ as foo using unique co_municipio using srid=4326"
METADATA
"METAESTAT_ID_MEDIDA_VARIAVEL" ""
"CLASSE" "SIM"
"permitekmz" "nao"
"METAESTAT_CODIGO_TIPO_REGIAO" ""
"permitedownload" "sim"
"PLUGINI3GEO" '{"plugin":"parametrossql","parametros":[{"titulo" : "Ano dos dados","chave" : "ANO_DADOS","tipo" : "select","valores" : "1970,1980,2000"},{"titulo" : "","chave" : "","tipo" : "","valores" : ""},{"titulo" : "","chave" : "","tipo" : "","valores" : ""},{"titulo" : "","chave" : "","tipo" : "","valores" : "undefined"}]}'
"metaestat" ""
"permiteogc" "sim"
"permitekml" "sim"
"TEMA" "Teste de plugin parametrossql"
END # METADATA
NAME "_lparametrossql"
PROCESSING "LABEL_NO_CLIP=True"
PROCESSING "POLYLINE_NO_CLIP=True"
STATUS OFF
TEMPLATE "none.htm"
TILEITEM "location"
TYPE POLYGON
UNITS METERS
CLASS
NAME "<= 6008"
EXPRESSION ([pop_res_tot]<=6008)
STYLE
COLOR 255 255 199
OUTLINECOLOR 255 255 255
OUTLINEWIDTH 6
SIZE 6
END # STYLE
END # CLASS
CLASS
NAME "> 6008 e <= 11531"
EXPRESSION (([pop_res_tot]>6008)and([pop_res_tot]<=11531))
STYLE
COLOR 235 235 210
OUTLINECOLOR 255 255 255
OUTLINEWIDTH 11
SIZE 11
END # STYLE
END # CLASS
CLASS
NAME "> 11531 e <= 22638"
EXPRESSION (([pop_res_tot]>11531)and([pop_res_tot]<=22638))
STYLE
COLOR 216 216 220
OUTLINECOLOR 255 255 255
OUTLINEWIDTH 16
SIZE 16
END # STYLE
END # CLASS
CLASS
NAME "> 22638"
EXPRESSION ([pop_res_tot]>22638)
STYLE
COLOR 196 196 230
OUTLINECOLOR 255 255 255
OUTLINEWIDTH 21
SIZE 21
END # STYLE
END # CLASS
END # LAYER
END # MAP