Changes between Version 54 and Version 55 of server/bdqueimadas


Ignore:
Timestamp:
08/02/16 15:51:01 (10 years ago)
Author:
jean.souza
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • server/bdqueimadas

    v54 v55  
    282282              </ogc:PropertyIsLessThan> 
    283283            </ogc:And> 
     284          </ogc:Filter> 
     285          <PolygonSymbolizer> 
     286            <Fill> 
     287              <CssParameter name="fill">#A21C0D</CssParameter> 
     288            </Fill> 
     289            <Stroke> 
     290              <CssParameter name="stroke">#000000</CssParameter> 
     291              <CssParameter name="stroke-width">2</CssParameter> 
     292            </Stroke> 
     293          </PolygonSymbolizer> 
     294        </Rule> 
     295        <Rule> 
     296          <ogc:Filter> 
     297            <ogc:PropertyIsGreaterThan> 
     298              <ogc:PropertyName>count</ogc:PropertyName> 
     299              <ogc:Literal>50000</ogc:Literal> 
     300            </ogc:PropertyIsGreaterThan> 
    284301          </ogc:Filter> 
    285302          <PolygonSymbolizer> 
    … …  
    11431160  * SQL: 
    11441161{{{ 
    1145 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 
     1162select 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 
    11461163}}} 
    11471164 
    11481165  * Selecione: Guess parameters from SQL 
    11491166  * Remover a validação de expressão regular para todos os campos. 
    1150   * Para os campos begin e end, colocar na coluna "Default value" o valor: '1970-01-01' 
     1167  * Para os campos begin e end, colocar na coluna "Default value" o valor: 1970-01-01 
    11511168  * 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' 
    11521169  * Para o campo biomes,  colocar na coluna "Default value" o valor: !'', null, 'Amazonia', 'Caatinga', 'Cerrado', 'Mata Atlantica', 'Pampa', 'Pantanal' 
    … …  
    11631180  * SQL: 
    11641181{{{ 
    1165 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%) 
     1182select 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%) 
    11661183}}} 
    11671184  * Selecione: Guess parameters from SQL 
    11681185  * Remover a validação de expressão regular para todos os campos. 
    1169   * Para os campos begin e end, colocar na coluna "Default value" o valor: '1970-01-01' 
     1186  * Para os campos begin e end, colocar na coluna "Default value" o valor: 1970-01-01 
    11701187  * Para o campo countries,  colocar na coluna "Default value" o valor: 0 
    11711188  * 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'