1 / 70

FOSS4G2006 - Free And Open Source Software for Geoinformatics Caio Nakashima September - 2006

M inistry of Social Development and Fight Against Hunger MDS. Mapserver technology supports the Data Warehouse of Actions and Investments of the Brazilian Ministry for Social Development and Fight Against Hunger. FOSS4G2006 - Free And Open Source Software for Geoinformatics Caio Nakashima

brie
Download Presentation

FOSS4G2006 - Free And Open Source Software for Geoinformatics Caio Nakashima September - 2006

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ministry of Social Development and Fight Against Hunger MDS Mapserver technology supports the Data Warehouse of Actions and Investments of the Brazilian Ministry for Social Development and Fight Against Hunger FOSS4G2006 - Free And Open Source Software for Geoinformatics Caio Nakashima September - 2006

  2. Agenda • Introduction to the Problems • Chosen path • Developed products • Used Technologies • Details of the solutions • Future Caio Nakashima

  3. MDS Current Scenario • MDS is an almagamation of previous separated Ministries • Low interoperability • Many stakeholders (banks, federation members, partners) • Formal Links (by law, contracts, agreements) • Need for na agile information to the public • Different paradigms (concepts, modus operandi) Caio Nakashima

  4. Scenario: Organizacional Aspects (Aspecto Organizacional) CEF DATAPREV SECEX-SecAdj-Gabinete NI NI CGI SENARC SNAS NI NI Cadunico CIf SAGI SAIP NI SESAN IBGE TSE CONAB ASA Caio Nakashima

  5. SIG SENARC Social Information Matrix DATA FLOW SIG SNAS SIG Social MI SESAN DW SIG SAIP Gabinete Sec Exec. SIG SAGI (M&A) SAGI Caio Nakashima

  6. P1 P2 Pn P Social Programs P Territory T T Program: xxxxx B1 nnnnnnnn add B2 nnnnnnnn add ............................. Bn nnnnnnnnn add Beneficiary B B Information Arquitecture Caio Nakashima

  7. P1 P2 Pn P Social Programs P Territory T T Program: xxxxx B1 nnnnnnnn add B2 nnnnnnnn add ............................. Bn nnnnnnnnnadd Beneficiary B B Subsystem Integration SOCIAL DATA DICTIONARY Caio Nakashima

  8. Benefits Reduced response time to queries from hours and days to minutes and seconds Information access comprehensive to the whole MDS Extracting Business Intelligence to help programs Managers Recording the historical data from the programs Registering knowledge to be used as information source Caio Nakashima

  9. Introduction to the Problems • The managers of the institution • Ministry, Secretaries, Directors • Majors, Congress people, Senators, Governors • Press, Civil Society • The need for information from MDS (Ministry of Social Development and Fight Against Hunger) • About Social Programs, Beneficiaries, Investments, and so on. Caio Nakashima

  10. Problems • There was not a solid information structure • Each department manage their own data, in their own way. • There was not a regular information flow between those departments. • The urgently need for management reports. Caio Nakashima

  11. Scenario Caixa Econômica Federal CONAB Tesouro Nacional PNUD IBGE Spreadsheet REPORTS DATAPREV TRE Caio Nakashima

  12. Chosen path • After much pressure and work in manual reports. • We developed a private data warehouse only for internal use. • External Help • Secretaries Support • Barriers • Pressure against changes Caio Nakashima

  13. Social Information Data Warehouse • Allows to retrieve information about the investments on Social Programs in each city. • With the following dimensions: • Search Items • Geographic Units • Territorial Limits • Population • IDH (Human Development Index) • Time Caio Nakashima

  14. First Screen

  15. Select the desired period Caio Nakashima

  16. Select the variable and Indicators Caio Nakashima

  17. Select the territory and other filter as Population and HDI Caio Nakashima

  18. Result in spreadsheet form Caio Nakashima

  19. Result in card form.Each card per municipality Caio Nakashima

  20. Another Way to Search Data • Viewing data through social program • Georeferenced Data • Graphics Caio Nakashima

  21. Bolsa Família coverage

  22. Caio Nakashima

  23. Map Viewer Structure Title (variable) Functionalities (invariable) Analysis Time (variable) Viewing Area (variable) Title (variable) Legend(variable) Number of registers (variable) Caio Nakashima

  24. Selection of a special area of some social program (Bolsa Familia Program in the area of Sao Francisco River)

  25. Caio Nakashima

  26. Some features of Map Engine

  27. Alow change the Interval Turn on or Turn off the Interval The Color of the Interval Legend and Layer Control Caio Nakashima

  28. Example of some changes Caio Nakashima

  29. Caio Nakashima

  30. The Color Pallete

  31. Map Color Border Color Label Color The Color Pallet Caio Nakashima

  32. Caio Nakashima

  33. Caio Nakashima

  34. Retrieve Spatial Information

  35. Box to bound the search Caio Nakashima

  36. Search Result • Show the selected geographic area • All geographic regions that touch or are inside the boundaries of the box. • It will open a window with all chosen geographic regions with: • The values used to build the map. • Link to details of the geographic information. • Link to graphic when applied • Link to find the location of the region in map. Caio Nakashima

  37. Caio Nakashima

  38. Search through the map

  39. Caio Nakashima

  40. Result of the search through the map • The chosen region is highlighted • It will open a link for the detail of the selected geographic region. • Link for the graphics, where they show the evolution of the variable or indicator presented along the time. • The values of thevariable or indicator of all cities on the borders of the chosen geographic area. Caio Nakashima

  41. Analysis through graphics Example: Values of the financial help and the amount of beneficiaries through the time of Bolsa Família

  42. List of all values that represented in map Caio Nakashima

  43. Amount of families (beneficiaries) of Bolsa Familia Amount of financial help. Caio Nakashima

  44. Graphic of financial help for each family Combination of two graphics Caio Nakashima

  45. Comparing two or more geographic areas • This feature allows a comparative analysis between up to three geographic regions. • The selection can be done through geographic bound or close analysis values. Caio Nakashima

  46. Comparing the amount of financial help Caio Nakashima

  47. Comparing the financial help for each family Caio Nakashima

  48. Financial Value Transferred to the cities of Bolsa Familia Program Histogram Caio Nakashima

  49. Mean value transferred to each family of Bolsa Familia Program in august 2006. Histogram Caio Nakashima

  50. Financial Value Transferred to the cities. Graphic of 100% of the distribution Pen Parade Graphic Caio Nakashima

More Related