Changes between Version 58 and Version 59 of server/bdqueimadas

Timestamp:

08/09/16 11:07:27 (10 years ago)

Author:

jean.souza

Comment:

--

server/bdqueimadas

@@ -1227 +1227 @@
   * 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%) and bioma_brasileiro 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
+select a.geom as geom, a.name_0 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_brasileiro in (%biomes%) group by pais) b right outer join dados_geo.paises a on (a.nome_bdq = b.pais) where a.id_0 in (%countries%) group by a.name_0, a.geom order by a.name_0
 }}}
 
@@ -1235 +1235 @@
   * Para o campo satellites,  colocar na coluna "Default value" o valor: null, !'', ' 14:45', '1', '12', '13:25', '18.1', '19.3', '21.2', '3-09-10', '5.0       ', 'AQUA-M', 'AQUA-MEX', 'AQUA-T', 'AQUA_M-M', 'AQUA_M-T', 'ATSR', 'DSA_novoformato', 'GOES-08', 'GOES-10', 'GOES-12', 'GOES-13', 'METEOSAT-02', 'NOAA-12', 'NOAA-12D', 'NOAA-14', 'NOAA-15', 'NOAA-15D', 'NOAA-16', 'NOAA-16N', 'NOAA-17', 'NOAA-18', 'NOAA-18D', 'NOAA-19', 'NOAA-19D', 'NPP', 'NPP_375', 'TERRA-M', 'TERRA-MEX', 'TERRA-T', 'TERRA_M-M', 'TERRA_M-T', 'TRMM'
   * Para o campo biomes,  colocar na coluna "Default value" o valor: !'', null, 'Amazonia', 'Caatinga', 'Cerrado', 'Mata Atlantica', 'Pampa', 'Pantanal'
+  * Para o campo countries,  colocar na coluna "Default value" o valor: select id_0 from dados_geo.paises
   * Save
   * Declared SRS: EPSG:4326