get_data_theme_OC {PublicWorksFinanceIT} | R Documentation |
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 |
cod_reg |
character. The ISTAT regional code is used to filter data based on one or more specific regions of interest. (See |
cod_prov |
character. The ISTAT province code is used to filter data based on one or more specific provinces of interest. (See |
cod_mun |
character. The ISTAT municipality code is used to specify one or more municipalities of interest within the region(s) of interest. (See |
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 |
soil_defense |
Logical, default set to |
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
Examples
data <- get_data_theme_OC("AMBIENTE", start = "2022-01-01", end = "2022-12-31")