Changes between Version 53 and Version 54 of server/bdqueimadas

Timestamp:

07/25/16 16:42:07 (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%) 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
+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
 }}}
 
   * Selecione: Guess parameters from SQL
-  * 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)
+  * Remover a validação de expressão regular para todos os campos.
+  * Para os campos begin e end, colocar na coluna "Default value" o valor: '1970-01-01'
+  * 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'
   * Save
@@ -1163 +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%) 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%)
+select a.geom as geom, a.name_1 as state, coalesce(b.count, 0) as count from (select estado, count(estado) as count from public.focos where data between %begin% and %end% and satelite in (%satellites%) and bioma_brasileiro 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, 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
+  * Remover a validação de expressão regular para todos os campos.
+  * Para os campos begin e end, colocar na coluna "Default value" o valor: '1970-01-01'
   * 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 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'
   * Save