alertadengue/data

Data from the Infodengue project

AlertaDengue

This repository contains the main applications and services for the InfoDengue web portal.

InfoDengue is an early-warning system to all states of Brazil, the system is based on the continuous analysis of hybrid data generated through the research of climate and epidemiological data and social scraping.

For more information, please visit our website info.dengue.mat.br to visualize the current epidemiological situation in each state.

---

Sponsors

---

How to contribute with InfoDengue

You can find more information about Contributing on GitHub. Also check our Team page to see if there is a work oportunity in the project.

---

How data can be visualized

The Infodengue website is accessed by many people and it is common for us to receive news that this information is used in the definition of travel and other activities. All data is compiled, analyzed and generated in a national level with the support of the Brazilian Health Ministry, the weekly reports can be found in our website through graphics or downloaded in JSON and CSV files via API.

API

The InfoDengue API will provide the data contained in the reports compiled in JSON or CSV files, it also provides a custom range of time. If you don't know Python or R, please check the tutorials here.

Reports

If you are a member of a Municipal Health Department, or a citizen, and you have interest in detailed information on the transmission alerts of your municipality, just type the name of the city or state here.

---

Where the data comes from

• Dengue, Chikungunya and Zika data are provided by SINAN as a notification form that feeds a municipal database, which is then consolidated at the state level and finally, federally by the Ministry of Health. Only a fraction of these cases are laboratory confirmed, most receive final classification based on clinical and epidemiological criteria. From the notified cases, the incidence indicators that feed the InfoDengue are calculated.
• Weather and climate data are obtained from REDEMET in the airports all over Brazil.
• Epidemiological indicators require population size. Demographic data of Brazilian cities are updated each year in Infodengue using estimates IBGE.

---

Check out below the softwares we use in the project:

---

data's Issues

Inserir rotina de restore da base de dados no ciclerCI

Inserir no ciclerCI o processo de restore da base de dados para teste dos scripts.

Containerized database

• Automate postgresql installation and database demo configuration.
• Resolve git-lfs bandwidth problem.

ajustar base de dados demo

está faltando as views.

Modificar README

• Mencionar a forma de obter o dump dos dados antes de executar o script para restore.

Criar a Tabela: Municipio.Notificacao

Erro ao executar os test:

python AlertaDengue/manage.py test api

A tabela Municipio.Notificacao não está sendo criada:
https://github.com/AlertaDengue/AlertaDengue/blob/develop/notebooks/DB_DEMO.ipynb

A tabela: Municipio.Notificacao deve ser criada como vazia e não ser excluída da base de dados demo.

Script de criação da tabela:

-- Table: "Municipio"."Notificacao"

-- DROP TABLE "Municipio"."Notificacao";

CREATE TABLE "Municipio"."Notificacao"
(
  id bigserial NOT NULL,
  dt_notific date,
  se_notif integer,
  ano_notif integer,
  dt_sin_pri date,
  se_sin_pri integer,
  dt_digita date,
  bairro_nome text,
  bairro_bairro_id integer,
  municipio_geocodigo integer,
  nu_notific integer,
  cid10_codigo character varying(5),
  dt_nasc date,
  cs_sexo character varying(1),
  nu_idade_n integer,
  CONSTRAINT "Notificacao_pk" PRIMARY KEY (id),
  CONSTRAINT casos_unicos UNIQUE (nu_notific, dt_notific, cid10_codigo, municipio_geocodigo)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Municipio"."Notificacao"
  OWNER TO administrador;
GRANT ALL ON TABLE "Municipio"."Notificacao" TO administrador;
GRANT ALL ON TABLE "Municipio"."Notificacao" TO "Dengue";
COMMENT ON TABLE "Municipio"."Notificacao"
  IS 'Casos de notificacao de dengue';

-- Index: "Municipio"."Dengue_idx_data"

-- DROP INDEX "Municipio"."Dengue_idx_data";

CREATE INDEX "Dengue_idx_data"
  ON "Municipio"."Notificacao"
  USING btree
  (dt_notific DESC, se_notif DESC);

Insert new data into db_demo and automate the build for dockerhub

• Add synthetic data in dbdemo.
• Create a new stage to build the image for dbdemo and upload it to dockerhub.
• Add simple tests

Update readme with instructions

Add instructions to the README.md detailing the steps required to load the demo data into a suitable dev environment.