Highlights

International Journal of Government Auditing – Autumn 2016

Graphic:  Six images (layers).
Figure 1: Schema of GIS Layers (Source: www.noaa.gov).

USING GIS TO MONITOR PUBLIC WORKS

INTRODUCTION

This article presents an alternative model for auditing public works through intensive use of Information Technology (IT). The model is based on the use of Geographic Information Systems (GIS) for collecting, processing and analyzing data; producing tables, graphs and thematic maps; allowing remote monitoring of a large number of constructions; and providing a quick overview of the audited area.

To develop the model, literature reviews, interviews with experts, technical meetings, workshops, on- site inspections and experimental research were conducted. A case study with sewage public works was performed with experimental applications in 399 municipalities of the Brazilian Northeast, involving 142 contracts, totaling $300 million (Federal Court of Accounts of Brazil (TCU), 2015).

GIS IN GOVERNMENT AUDITS

Geospatial information pertains to a specifi location, associating each entity or phenomenon to an exact location on Earth. These computer tools allow you to store, integrate, maintain, visualize and analyze data from various sources and create geo-referenced databases and thematic maps (in which a great deal of information can be overlaid and interpreted). Figure 1 illustrates a schematic view of GIS layers.

GIS can play an important role in every stage of an audit, including selecting research areas and communicating audit results. Rentenaar and Williams-Bridgers (2006), Jongsma and Graaf (2008) and Musa (2012) presented practical GIS applications in audits connected to disaster-related aid, money laundering and the environment, and they highlighted the important contributions of GIS for more effective control, especially by performing complex analyses through linking data layers and overlaying different datasets.

The International Organization of Supreme Audit Institutions (INTOSAI) published International Standards of Supreme Audit Institutions (ISSAI) 5540, concerning the use of geospatial information in auditing disaster management and disaster-related aid. The purpose of ISSAI 5540, to explain the benefits of using geospatial information in audit works, introduces GIS as an audit tool and encourages auditors to improve the use of geospatial information in their work (INTOSAI, 2013).

When analyzing the Brazilian Courts of Accounts, it was observed that roughly 50% of the courts systematically use, or are preparing to use, GIS in auditing public works. This information considered 28 Brazilian courts, 27 state courts and the federal court.

GIS FOR REMOTE MONITORING OF PUBLIC WORKS

Developing methods to use government databases is featured due to the increasingly available amount of data. TCU has been intensively working to use IT resources, particularly public administration databases. The use of IT enables obtaining information about audited objects in a remote fashion to include highlighting audit findings through automated tests.

These systems are important in monitoring public works, as they allow for data treatment, integration and spatial analysis. Figure 2 shows a scheme of the developed model, which can be divided into four steps:

  1. Datacollection: to collect data mainly from public information systems;
  2. Data processing: to standardize data, correct errors and integrate databases;
  3. Use of GIS: to organize information in a unique database and produce tables, graphs and maps;
  4. Monitoring of public works: GIS enables obtaining information about a large number of constructions, allows virtual monitoring, with a quick overview of the research area.

Graphic:  Four graphics with label arranged in a circle.  Data collection points to data processing, which points to graphic information system, which poins to monitoring of public works, which points back to graphic information systems.
Figure 2: GIS for Remote Monitoring of Public Works

Thematic maps are an option to support decision-making processes related to the external control of public works. They enable (1) detection of areas with higher or lower occurrence of certain phenomena, (2) geographic pattern identification, and (3) predictive and correlation analyses.

AUDITING SEWAGE PUBLIC WORKS

Between May 2014 and March 2015, TCU audited an area of 399 municipalities in the Brazilian Northeast, involving 142 contracts, totaling $300 million. The goal was to improve public works sewage governance in the region through the diagnosis and analysis of conditions associated with sewage construction, as well as identifying problems and bottlenecks related to projects never reaching conclusion (TCU, 2015).

The municipalities selected were those that would greatly benefit from Brazilian Federal Government projects. One such example is the São Francisco River Integration Project (PISF), involving the construction of two main channels for river basin incorporation.

Sewage infrastructure construction was among the predicted measures to maximize PISF benefits, a measure especially important for municipalities within the project’s Direct Influence Area (DIA), as raw sewage discharges could potentially damage water quality.

Figure 3 depicts the study area. The main audit findings were:

55% Percentage of sewage construction that was halted, in very slow construction rhythm or not even initiated.
39% Amount of sewage construction that was not concluded, yet the contracts had already expired.
30% Ratio of expired environmental licenses.
13% Number of hired construction companies that did not possess operational capabilities to execute the public works.
9%

Percentage contracts that had atypical financial transactions in bank accounts.


Map with legend including smaller map of which the map is a part.  The label for the small map that contains the map in the figure is --Polyconic projection;Datum SIRGAS; 2000; Sources:  IBGE, MI and TCU.
Figure 3: Study Area (Source: TCU, 2015)

There was also a risk of water pollution that existed from potential raw sewage discharges.

Regarding the project schedules in particular, “Figure 4: Sewage Public Works,” details realization conditions. The high percentage of unfinished and halted projects must be emphasized.

Pie chart with legend including 38% in execution or concluded; 18% Non-initiated; 11% Non-initiated--two years behind schedule; 6% In execution--very slow construction rhythm; 37% Halted.
Figure 4: Sewage Public Works (Source: TCU, 2015).

While there were many projects behind schedule and difficulties associated with project completion, there were also several undesired cases where new contracts were signed even prior to the conclusion of previous projects in the same municipality. The map in Figure 5 illustrates municipalities with three or more contracts for sewage constructions. In all of these municipalities, there were unfinished projects (some of them not even initiated and more than two years behind schedule). Additionally, there were projects that expected to be operational nearly 10 years prior, but as of the date of this study, were still under construction.

Map with legend including state's administrative divisions,
State's capitals, Receivers rivers, Channels, São Francisco river; Municipalities of the study area--no, yes; Direct Influence Area (DIA)--no, yes; Spatial concentration of halted public works, in very slow constuction rhythm or not even initiateid with more than two years behind schedule--low, medium, high; Quantity of contracts in each municipality--one or two, three or more.  Polyconic projection; Datum SIRGAS 2000; Sources:  IBGE, MI and TCU.
Figure 5: Quantity of Contracts in Each Municipality (Source: TCU, 2015).

When it comes to the risk of water pollution, it is important to note that the vast majority of municipalities located in the DIA do not provide appropriate sewage services. Moreover, 57% of those have no agreement in place to improve sewage collection and treatment. See Figure 6 for greater detail related to the municipalities’ situations within the DIA.

Pie chart with legend including 8% More than 50% of sewage collection and treatment index; 15% Contracts without audit findings; 20% Contracts with audit findings; 57% Without contract for sewage construction
Figure 6: Details of the Municipalities within Direct Influence Area (Source: TCU, 2015).

TCU provided copies of the audit report to more than 20 establishments, and federal institutions directly responsible for the public contracts are required to return an action plan to TCU that includes measures geared toward solving the various problems identified.

CONCLUSIONS AND FINAL RECOMMENDATIONS

GIS application made it possible to remotely monitor public works, allowing for analyses of multiple data points through graphs and thematic maps. Results of the experimental application were satisfactory, enabling the analysis of a large number of sewage constructions. Without IT resources, it would not have been possible to achieve the obtained results.

The  present model is an alternative to increase:

  • Effectiveness of Supreme Audit Institutions (SAIs), considering the possibility to monitor a large number of public works;
  • Audit quality, as information from various sources can be gathered and critically analyzed.

As final recommendations, some studies are required, particularly with respect to:

  • Experimental applications of the model in other types of constructions;
  • Algorithms for automatized analysis;
  • Development of risk indicators; and
  • Application of remote sensing.

The authors invite colleagues from other SAIs to provide examples of GIS uses in auditing public works. For additional information, please contact André Delgado de Souza, TCU,; at andre.delgado@tcu.gov.br