Changes between Version 11 and Version 12 of server/bdqueimadas

Timestamp:

05/10/16 14:59:18 (10 years ago)

Author:

gribeiro

Comment:

--

server/bdqueimadas

@@ -387 +387 @@
   * Na seção WMS, selecionar os estilos de cada camada
 
+**9.** Criar dois novos layers a partir de consultas:
+
+Para o primeiro layer:
+  * Na opção Layers -> Add new resource -> Add layer from: queimadas:queimadas -> Consigure new SQL view...
+  * Nome: situacao_atual_paises
+  * SQL:
+{{{
+select a.wkb_geometry as geom, a.name as country, sum(coalesce(b.count, 0)) as count from (select pais, count(pais) as count from public.focos_de_2016_04_01_a_2016_05_05 where data between %begin% and %end% and satelite like '%%satellite%%' group by pais) b right outer join public.paises_bdq c on (c.pais = b.pais) right outer join public.countries a on (a.ogc_fid = c.ogc_fid) group by a.name, a.wkb_geometry order by a.name
+}}}
+
+  * Selecione: Guess parameters from SQL
+  * Para o campo satellite remover a validação de expressão regular.
+  * Para os campos begin e end, colocar na coluna "Default value" o valor: 00000000
+  * Save
+  * Declared SRS: EPSG:4326
+  * Compute from data
+  * Compute from native bounds
+  * Aba Publishing => WMS Settings - Default Style: queimadas:Situacao Atual
+  * Save
+
+Para o segundo layer:
+  * Na opção Layers -> Add new resource -> Add layer from: queimadas:queimadas -> Consigure new SQL view...
+  * Nome: situacao_atual_estados
+  * SQL:
+{{{
+select a.geom as geom, a.name_1 as state, coalesce(b.count, 0) as count from (select uf, count(uf) as count from public.focos_de_2016_04_01_a_2016_05_05 where data between %begin% and %end% and satelite like '%%satellite%%' group by uf) b right outer join public.estados a on (a.nome_bdq = b.uf) where id_0 = %country%
+}}}
+  * Selecione: Guess parameters from SQL
+  * Para o campo satellite remover a validação de expressão regular.
+  * Para os campos begin e end, colocar na coluna "Default value" o valor: 00000000
+  * Para o campo country,  colocar na coluna "Default value" o valor: 33   (id do Brasil)
+  * Save
+  * Declared SRS: EPSG:4326
+  * Compute from data
+  * Compute from native bounds
+  * Aba Publishing => WMS Settings - Default Style: queimadas:Situacao Atual
+  * Save
+
+
+
+
+
+Nome: situacao_atual_estados
 
 ----