get_data_OBDAP: Retrieve financial data on public works from the OpenBDAP...

In PublicWorksFinanceIT: Soil Defense Investments in Italy: Data Retrieval, Analysis, Visualization

Retrieve financial data on public works from the OpenBDAP data base.

Description

get_data_OBDAP function retrieves data from one or more Italian regions using ISTAT region codes. It allows filtering based on: municipality code, and the project's starting and/or ending dates. Additionally, it provides geospatial references.

Usage

get_data_OBDAP(
  cod_reg,
  cod_prov = NULL,
  cod_mun = NULL,
  start = NULL,
  end = NULL,
  geo_ref = NULL,
  soil_defense = FALSE,
  verbose = TRUE
)

Arguments

cod_reg	character vector. The ISTAT regional code is used to specify one or more regions of interest when retrieving data. (See get_codes function)
cod_prov	character vector. The ISTAT province code is used to specify one or more provinces of interest when retrieving data. (See get_codes function)
cod_mun	character vector The ISTAT municipal code is used to specify one or more municipalities of interest when retrieving data. (See get_codes function)
start	character (format YYYY-mm-dd). Effective starting date of design refers to the specific phase of a public project that marks the beginning of its design process. This date can be of interest for filtering and analyzing relevant data.
end	character (format YYYY-mm-dd). Effective ending date of design refers to the specific phase of a public project that marks the conclusion of its design process. This date can be of interest for filtering and analyzing relevant data.
geo_ref	character. The georeference data can be specified using the geo_ref argument. If set to A, the function returns shape polygons of each municipality. If set to C, it retrieves the coordinates of the centroids of each municipality.
soil_defense	logical. By default set to FALSE. If only soil defense data are of interest set the argument to TRUE.
verbose	Logic value (TRUE or FALSE). Toggle warnings and messages. If 'verbose = TRUE' (default) the function prints on the screen some messages describing the progress of the tasks. If 'verbose = FALSE' any message about the progression is suppressed.

Value

Object of class data.frame showing 22 variables.Descriptive Variables:

• Local Project Code (character)

• CUP (character)

• Intervention (character)

Financial Variables:

• State Funding (numeric)

• EU Funding (numeric)

• Local Authorities Funding (numeric)

• Private Funding (numeric)

• Other Funding (numeric)

Geographical References:

• DEN_REGION (character)

• DEN_PROVINCE (character)

• DEN_MUNICIPALITY (character)

• COD_REGION (character)

• COD_PROVINCE (character)

• COD_MUNICIPALITY (character)

• geom (character)

Legislative process main steps:

• Executive Design Starting Date (character)

• Executive Design Ending Date (character)

• Works Execution Starting Date (character)

• Works Execution Ending Date (character)

• Conclusion Starting Date (character)

• Conclusion Ending Date (character)

• Operability (character)

Author(s)

Lorena Ricciotti

References

Open BDAP

Examples

data <- get_data_OBDAP("14")
# Retrieve data for one region filtering for soil defense interventions.

PublicWorksFinanceIT documentation built on April 3, 2025, 6:11 p.m.