Changes between Version 37 and Version 38 of server/bdqueimadas

Timestamp:

07/13/16 14:53:24 (10 years ago)

Author:

jean.souza

Comment:

--

server/bdqueimadas

@@ -1106 +1106 @@
 
 Para o primeiro layer:
-  * Na opção Layers -> Add new resource -> Add layer from: queimadas:queimadas -> Consigure new SQL view...
+  * Na opção Layers -> Add new resource -> Add layer from: queimadas:queimadas-dados-geo -> 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
+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 where data between %begin% and %end% and satelite in (%satellites%) group by pais) b right outer join dados_geo.paises_bdq c on (c.pais = b.pais) right outer join dados_geo.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
+  * Para os campos begin e end, colocar na coluna "Default value" o valor: 19700101
   * Save
   * Declared SRS: EPSG:4326
@@ -1124 +1124 @@
 
 Para o segundo layer:
-  * Na opção Layers -> Add new resource -> Add layer from: queimadas:queimadas -> Consigure new SQL view...
+  * Na opção Layers -> Add new resource -> Add layer from: queimadas:queimadas-dados-geo -> 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%
+select a.geom as geom, a.name_1 as state, coalesce(b.count, 0) as count from (select uf as estado, count(uf) as count from public.focos where data between %begin% and %end% and satelite in (%satellites%) group by estado) b right outer join dados_geo.estados a on (a.nome_bdq = b.estado) where id_0 in (%countries%)
 }}}
   * 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)
+  * Para os campos satellites e countries remover a validação de expressão regular.
+  * Para os campos begin e end, colocar na coluna "Default value" o valor: 19700101
+  * Para o campo countries,  colocar na coluna "Default value" o valor: 33 (id do Brasil)
+  * Para o campo satellites,  colocar na coluna "Default value" o valor: select distinct satelite from public.focos (query que retorna a listagem de satélites existentes)
   * Save
   * Declared SRS: EPSG:4326