37 Mapserver technology supports the Data Warehouse of Actions and Investments of the Brazilian Ministry for Social Development and Fight Against Hunger This presentation will show the solution to represent the information about the Brazilian Ministry for Social Development and Fight Against Hunger Actions, such as the amount of investments and beneficiaries of the Social Programs. There are more than twenty actions all over the country with more than eight million beneficiaries under the Ministry programs. Our challenges were to develop a way to show all this information in an easy way to the society and to the managers of the programs. To solve that we used an open source technology to develop a centralized data warehouse and than a GIS tool to show the results. The MAPServer and PHP Script were the best tools that we found to perform all the activities required, such as gathering the data all over our ministry as well as from other ministries (sites), analyzing and loading the information to the Data Warehouse and showing up the queries results in spreadsheet, maps and graphics form. The GIS framework accepts all kind of data, because it does not depend on the Data Warehouse structure to update the results. The solution shows the maps without changing any element, being shape file, legend information or map file. The framework can analyze the database tables and show the maps and graphics. The solution is based in a set of shape files stored in PosgreSQL/PostGis database, and there is another database that stores all information about the Social Program Investments and Actions. There are shape files about the Brazilian states, cities and detailed information about some cities counties. The framework retrieves the themes from a special structure that carries the SQL statement that shows the map information, map title, units of the information and the SQL statement that shows the graphics. The software developed calculates the values to build the legend sharing the frequency of the distribution in quartile. It is possible to get the information about the geographic area (state or city) that the user can select with a mouse click over the map. The detailed information about the geographic area can be the value of the variable or the indicator of a chosen theme. It is also possible to show the graphic of this variable or indicator throughout the year depending on the social program. The map themes are stored in SQL statement form, so when the database is updated the map is automatically updated too. For some social programs it is possible to show the beneficiaries addresses in a map. Our solution can retrieve the information about the families and about the county in order to compare the distribution of the investment with the social status of the county. We built a tool to assemble some special areas formed by cities, such as the cities influenced by Sao Francisco river or Indian communities, and the framework shows the variables or indicators over these areas. FOSS4G2006 - Free And Open Source Software for Geoinformatics Session 8 : Use - FOSS and NONFOSS Caio Nakashima caionakashima@gmail.com Roberto Wagner Silva roberto.wagner@mds.gov.br Caio Nakashima caionakashima@gmail.com <MaKaC.conference.ContributionType object at 0xb4934f2c> Use - FOSS anf NONFOSS