Changes between Version 59 and Version 60 of server/bdqueimadas

Timestamp:

08/10/16 14:52:46 (10 years ago)

Author:

jean.souza

Comment:

--

server/bdqueimadas

@@ -1220 +1220 @@
   * Bounding Boxes / Lat/Lon Bounding Box
 
-**10.** Criar dois novos layers a partir de consultas:
+**10.** Criar três novos layers a partir de consultas:
 
 Para o primeiro layer:
@@ -1263 +1263 @@
   * Save
 
+
+Para o terceiro layer:
+  * Na opção Layers -> Add new resource -> Add layer from: queimadas:queimadas-dados-geo -> Consigure new SQL view...
+  * Nome: situacao_atual_municipios
+  * SQL:
+{{{
+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 (translate(lower(a.name_2), 'áàâãäåaaaÁÂÃÄÅAAAÀéèêëeeeeeEEEÉEEÈìíîïìiiiÌÍÎÏÌIIIóôõöoooòÒÓÔÕÖOOOùúûüuuuuÙÚÛÜUUUUçÇñÑýÝ', 'aaaaaaaaaAAAAAAAAAeeeeeeeeeEEEEEEEiiiiiiiiIIIIIIIIooooooooOOOOOOOOuuuuuuuuUUUUUUUUcCnNyY') = translate(lower(b.municipio), 'áàâãäåaaaÁÂÃÄÅAAAÀéèêëeeeeeEEEÉEEÈìíîïìiiiÌÍÎÏÌIIIóôõöoooòÒÓÔÕÖOOOùúûüuuuuÙÚÛÜUUUUçÇñÑýÝ', 'aaaaaaaaaAAAAAAAAAeeeeeeeeeEEEEEEEiiiiiiiiIIIIIIIIooooooooOOOOOOOOuuuuuuuuUUUUUUUUcCnNyY')) where substr(complete_id, 1, 7) in (%states%)
+}}}
+  * Selecione: Guess parameters from SQL
+  * 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 os campos states e statesnames,  colocar na coluna "Default value" o valor: !''
+  * 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
+  * Declared SRS: EPSG:4326
+  * Compute from data
+  * Compute from native bounds
+  * Aba Publishing => WMS Settings - Default Style: queimadas:Situação Atual
+  * Save
+
 == Aplicação Node.js ==