PublicWorksFinanceIT (version 0.2.0)

get_data_RENDIS: Retrieve data from the ReNDiS database on soil defense public works.

Description

The get_data_RENDIS function enables the retrieval of data from one or more region or type of intervention using associated 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_RENDIS(
  cod_reg,
  cod_prov = NULL,
  cod_mun = NULL,
  start = NULL,
  end = NULL,
  type = NULL,
  geo_ref = NULL
)

Value

Object of class tbl_df, tbl, data.frame showing 25 variables. Descriptive Variables:

• CUP (character)

• Intervention (character)

• Type (character)

Financial Variable:

• Finance (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:

• Feasibility Study Starting Date (character)

• Feasibility Study Ending Date (character)

• Preliminary Design Starting Date (character)

• Preliminary Design Ending Date (character)

• Definitive Design Starting Date (character)

• Definitive Design Ending Date (character)

• 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)

• Intervention Closed (character)

• Operability (character)

Arguments

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 specify one or more provinces of interest within the region(s) 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 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.

type

character. a character string on which type of intervetion data needs to be retrieved. To get information about type see get_type_RENDIS function.

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.

Author

Lorena Ricciotti

References

ReNDiS

Examples

data_12 <- get_data_RENDIS("12", cod_prov = c("258", "059"), geo_ref = "C")
#Data for the Lazio region filtering for Rome and Latina provinces with point georeferences.