get_data_theme_OC {PublicWorksFinanceIT}

Retrieve Data from OpenCoesione Database by Theme's Project

Description

The get_data_theme_OC function allows users to fetch data from the OpenCoesione database based on specific themes related to projects.

Usage

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

Arguments

themes

character. Vector specifying one or more theme of interest. To get information about the codes associated to each theme use the function get_info_OC.

cod_reg

character. The ISTAT regional code is used to filter data based on one or more specific regions of interest. (See get_codes function)

cod_prov

character. The ISTAT province code is used to filter data based on one or more specific provinces of interest. (See get_codes function)

cod_mun

character. The ISTAT municipality code is used to specify one or more municipalities of interest within the region(s) of interest. (See get_codes function)

start

character (format YYYY-mm-dd). Effective starting date of the project. This date can be of interest for filtering and analyzing relevant data.

end

character (format YYYY-mm-dd). Effective ending date of the project. 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, 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 classe data.frame showing 42 variables: Descriptive Variables:

• Local Project Code (character)

• CUP (character)

• Intervention (character)

Financial Variable:

• EU Funding (numeric)

• FESR EU Funding (numeric)

• FSE EU Funding (numeric)

• FEASR EU Funding (numeric)

• FEAMP EU Funding (numeric)

• IOG EU Funding (numeric)

• Fondo di Rotazione ITA (numeric)

• FSC ITA Funding (numeric)

• PAC ITA Funding (numeric)

• Completamenti ITA Funding (numeric)

• Other Measures ITA Funding (numeric)

• Region Funding (numeric)

• Province Funding (numeric)

• Municipality Funding (numeric)

• Released Resources (logic)

• Other Public Funding (numeric)

• Foreign State Funding (numeric)

• Private Funding (numeric)

• Total Public Funding (numeric)

• Total Funding (numeric)

Geographical References:

• DEN_MUNICIPALITY (character)

• DEN_REGION (character)

• DEN_PROVINCE (character)

• COD_REGION (character)

• COD_PROVINCE (character)

• COD_MUNICIPALITY (character)

• geom (character)

Legislative process main steps:

• Feasibility Study Starting Date (integer)

• Feasibility Study Ending Date (integer)

• Preliminary Design Starting Date (integer)

• Preliminary Design Ending Date (integer)

• Definitive Design Starting Date (integer)

• Definitive Design Ending Date (integer)

• Executive Design Starting Date (integer)

• Executive Design Ending Date (integer)

• Works Execution Starting Date (integer)

• Works Execution Ending Date (integer)

• Conclusion Starting Date (character)

• Conclusion Ending Date (character)

Author(s)

Lorena Ricciotti

References

Open Coesione

Examples

data <- get_data_theme_OC("AMBIENTE", start = "2022-01-01", end = "2022-12-31")