teste.map
1.46 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
MAP
FONTSET "../symbols/fontes.txt"
SYMBOLSET "../symbols/simbolos.sym"
LAYER
CONNECTION ""
CONNECTIONTYPE POSTGIS
DATA "geom from (
SELECT
co_seq_id AS gid,
ST_MakePoint(tb_cep.long::numeric,tb_cep.lat::numeric) AS geom,
tb_cep.lat,
tb_cep.long,
ano_farm_pop_aqt AS ano,
mes_farm_pop_aqt AS mes,
nu_ddd_farmacia AS ddd,
nu_telefone_farmacia,
nu_cep_farmacia,
no_bairro_farmacia,
ds_endereco_farmacia,
no_farmacia,
dbgeral.tb_ibge.cidade_sem_acento,
dbgeral.tb_ibge.uf
FROM
dbacoes_saude.tb_farmacia_pop_aqt
INNER JOIN dbgeral.tb_cep ON dbacoes_saude.tb_farmacia_pop_aqt.nu_cep_farmacia = dbgeral.tb_cep.cep
INNER JOIN dbgeral.tb_ibge ON dbacoes_saude.tb_farmacia_pop_aqt.co_ibge = dbgeral.tb_ibge.ibge
WHERE
'm'||tb_farmacia_pop_aqt.mes_farm_pop_aqt||'a'||tb_farmacia_pop_aqt.ano_farm_pop_aqt = (SELECT 'm'||tb_farmacia_pop_aqt.mes_farm_pop_aqt||'a'||tb_farmacia_pop_aqt.ano_farm_pop_aqt
FROM dbacoes_saude.tb_farmacia_pop_aqt
ORDER BY tb_farmacia_pop_aqt.ano_farm_pop_aqt DESC, tb_farmacia_pop_aqt.mes_farm_pop_aqt DESC LIMIT 1)
AND
farmacia_apta not LIKE '%N%' AND
nu_cep_farmacia not LIKE '%-%'
) as foo using unique gid using srid=4674"
METADATA
"CLASSE" "SIM"
"TEMA" "loc"
"IDENTIFICA" "SIM"
END
NAME "teste"
STATUS DEFAULT
TYPE POINT
UNITS METERS
CLASS
NAME " "
STYLE
COLOR 255 0 0
SYMBOL "ponto"
SIZE 10
END
END
END
END