Changes between Version 47 and Version 48 of server/bdqueimadas

Timestamp:

07/19/16 11:15:03 (10 years ago)

Author:

jean.souza

Comment:

--

server/bdqueimadas

@@ -1143 +1143 @@
   * 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 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
+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%) and bioma in (%biomes%) 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 satellites remover a validação de expressão regular.
+  * Para os campos satellites e biomes 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 satellites,  colocar na coluna "Default value" o valor: select distinct satelite from public.focos (query que retorna a listagem de satélites existentes)
+  * Para o campo biomes,  colocar na coluna "Default value" o valor: '', null, 'Amazonia', 'Caatinga', 'Cerrado', 'Mata Atlantica', 'Pampa', 'Pantanal'
   * Save
   * Declared SRS: EPSG:4326
@@ -1162 +1163 @@
   * SQL:
 {{{
-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%)
+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%) and bioma in (%biomes%) 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 os campos satellites e countries remover a validação de expressão regular.
+  * Para os campos satellites, biomes 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: 0
   * 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)
+  * Para o campo biomes,  colocar na coluna "Default value" o valor: '', null, 'Amazonia', 'Caatinga', 'Cerrado', 'Mata Atlantica', 'Pampa', 'Pantanal'
   * Save
   * Declared SRS: EPSG:4326