Abstract The PublicWorksFinanceIT R package enables users to retrieve and analyze financial data related to public works in Italy. Specifically, it focuses on soil defence investments. The data are sourced from three distinct platforms: the OpenCoesione website, which draws its information from the Cohesion Policy, the OpenBDAP website, the Ministry of Economy and Finance’s open data platform, and the ReNDiS database, provided by ISPRA, which exclusively gathers information about interventions in soil defence. This package offers a user-friendly tool that eliminates the need for direct access to the aforementioned institutional platforms and ensures real-time updates. Additionally, all measurements, metadata, and accompanying analytical tools are provided in English, enhancing accessibility for both international and domestic users. The data records from these three sources are linked using the unique project code (CUP), ensuring that there is no duplication. Moreover, the data is geographically referenced, meaning that each financial investment is associated with a specific municipality within a particular Italian region. This allows to provide information on the region, province, and municipality of each dataset entry. Users can select to geo-reference the data by either the coordinates of the municipality’s centroid or by the polygon representing the municipality’s administrative boundaries. In addition to functions for data retrieval, the package includes functions for visualizing the collected data on maps. After providing a detailed explanation of the purpose and operation of the main commands, the paper presents two case studies illustrating the software’s application. These examples serve as a step-by-step guide to using the PublicWorksFinanceIT package.
Read full abstract