Changes between Version 84 and Version 85 of server/bdqueimadas


Ignore:
Timestamp:
10/07/16 07:51:47 (10 years ago)
Author:
jean.souza
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • server/bdqueimadas

    v84 v85  
    17201720  * SQL: 
    17211721{{{ 
    1722 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 
     1722select 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_hora 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 
    17231723}}} 
    17241724 
    17251725  * Selecione: Guess parameters from SQL 
    17261726  * Remover a validação de expressão regular para todos os campos. 
    1727   * Para os campos begin e end, colocar na coluna "Default value" o valor: 1970-01-01 
     1727  * Para o campo begin, colocar na coluna "Default value" o valor: 1970-01-01 00:00:00 
     1728  * Para o campo end, colocar na coluna "Default value" o valor: 1970-01-01 23:59:59 
    17281729  * 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' 
    17291730  * Para o campo biomes,  colocar na coluna "Default value" o valor: !'', null, 'Amazonia', 'Caatinga', 'Cerrado', 'Mata Atlantica', 'Pampa', 'Pantanal' 
    … …  
    17411742  * SQL: 
    17421743{{{ 
    1743 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%) 
     1744select 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_hora 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%) 
    17441745}}} 
    17451746  * Selecione: Guess parameters from SQL 
    17461747  * Remover a validação de expressão regular para todos os campos. 
    1747   * Para os campos begin e end, colocar na coluna "Default value" o valor: 1970-01-01 
     1748  * Para o campo begin, colocar na coluna "Default value" o valor: 1970-01-01 00:00:00 
     1749  * Para o campo end, colocar na coluna "Default value" o valor: 1970-01-01 23:59:59 
    17481750  * Para o campo countries,  colocar na coluna "Default value" o valor: 0 
    17491751  * 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' 
    … …  
    17621764  * SQL: 
    17631765{{{ 
    1764 select a.geom as geom, a.name_2 as municipio, coalesce(b.count, 0) as count from (select municipio, count(municipio) as count from public.focos where data between '%begin%' and '%end%' and satelite in (%satellites%) and bioma_brasileiro in (%biomes%) and estado in (%statesnames%) group by municipio) b right outer join dados_geo.municipios a on (unaccent(lower(a.name_2)) = unaccent(lower(b.municipio))) where substr(complete_id, 1, 7) in (%states%) 
     1766select a.geom as geom, a.name_2 as municipio, coalesce(b.count, 0) as count from (select municipio, count(municipio) as count from public.focos where data_hora between '%begin%' and '%end%' and satelite in (%satellites%) and bioma_brasileiro in (%biomes%) and estado in (%statesnames%) group by municipio) b right outer join dados_geo.municipios a on (unaccent(lower(a.name_2)) = unaccent(lower(b.municipio))) where substr(complete_id, 1, 7) in (%states%) 
    17651767}}} 
    17661768  * Selecione: Guess parameters from SQL 
    17671769  * Remover a validação de expressão regular para todos os campos. 
    1768   * Para os campos begin e end, colocar na coluna "Default value" o valor: 1970-01-01 
     1770  * Para o campo begin, colocar na coluna "Default value" o valor: 1970-01-01 00:00:00 
     1771  * Para o campo end, colocar na coluna "Default value" o valor: 1970-01-01 23:59:59 
    17691772  * Para os campos states e statesnames,  colocar na coluna "Default value" o valor: !'' 
    17701773  * 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' 
    … …  
    17831786  * SQL: 
    17841787{{{ 
    1785 select a.geom as geom, a.nome as biome, sum(coalesce(b.count, 0)) as count from (select bioma_brasileiro, count(bioma_brasileiro) as count from public.focos where data between '%begin%' and '%end%' and satelite in (%satellites%) and bioma_brasileiro in (%biomes%) group by bioma_brasileiro) b right outer join dados_geo.biomas_brasileiros a on (unaccent(lower(a.nome)) = unaccent(lower(b.bioma_brasileiro))) where 33 in (%countries%) group by a.nome, a.geom order by a.nome 
     1788select a.geom as geom, a.nome as biome, sum(coalesce(b.count, 0)) as count from (select bioma_brasileiro, count(bioma_brasileiro) as count from public.focos where data_hora between '%begin%' and '%end%' and satelite in (%satellites%) and bioma_brasileiro in (%biomes%) group by bioma_brasileiro) b right outer join dados_geo.biomas_brasileiros a on (unaccent(lower(a.nome)) = unaccent(lower(b.bioma_brasileiro))) where 33 in (%countries%) group by a.nome, a.geom order by a.nome 
    17861789}}} 
    17871790  * Selecione: Guess parameters from SQL 
    17881791  * Remover a validação de expressão regular para todos os campos. 
    1789   * Para os campos begin e end, colocar na coluna "Default value" o valor: 1970-01-01 
     1792  * Para o campo begin, colocar na coluna "Default value" o valor: 1970-01-01 00:00:00 
     1793  * Para o campo end, colocar na coluna "Default value" o valor: 1970-01-01 23:59:59 
    17901794  * 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' 
    17911795  * Para o campo biomes,  colocar na coluna "Default value" o valor: !'', null, 'Amazonia', 'Caatinga', 'Cerrado', 'Mata Atlantica', 'Pampa', 'Pantanal'