vulekamali home / Learning Resources / Guides / Infrastructure Projects Infrastructure Projects Overview Vulekamali has two sets of infrastructure project data. High level data of Public Private Partnership (PPP) projects and major projects by national departments, and rather detailed data on infrastructure projects by provincial departments.Learn more about these datasets:PPP & major national infrastructure projectsProvincial infrastructure projects PPP & major national infrastructure projects The Public Private Partnership and major national infrastructure projects data provides an overview of project budget, actual spending, timeline, and status. Provincial infrastructure projects The provincial infrastructure data provides details on project status, purpose, geographic location, budgets, and in-year spending data. This enables project spending to be tracked over the life of the project. Data provenance and purpose This data is extracted from the Infrastructure Reporting Model (IRM) maintained by National Treasury. Provincial departments regularly upload their infrastructure project data to the IRM database.The IRM is a monitoring and reporting tool along with a standardised approach to reporting on infrastructure projects. How to use this data Project snapshotsYou can download all the snapshots available of a specific project by clicking the Download button at the top-right of a project page:You can then open the downloaded Comma Separated Variable (CSV) file in a spreadsheet program like Excel to view all the snapshots - snapshots are uploaded quarterly - and see how the data has been updated in each snapshot:All projects and search resultsYou can download all projects at once, or just the projects matching your search filters, by clicking the Download projects button at the top of the search result project list:This will download the latest information for each project in your search results. You can open this in a spreadsheet program like Excel.You may need to convert the CSV data to multiple columns using the "Text to columns" feature under the "Data" menu if Excel chooses to interpret the data as plain text. Field definitions Primary funding source: The source of most of the money for this project. This might be conditional grants, equitable share, or othersNature of investment: This indicates whether the project is maintenance of existing infrastructure, new infrastructure, replacement, etc.Funding status: This indicates whether the project was included when the original budget was tabled at the start of the financial year.Department: The department undertaking the project.Budget programme: The budget programme of the department undertaking this project under which this project is carried out.Project status: A successful project goes through the following statuses in order:Pre - FeasibilityProject InitiationFeasibilityTenderDesignSite Handed - Over to ContractorConstruction 1% - 25%Construction 26% - 50%Construction 51% - 75%Construction 76% - 99%Practical Completion (100%)Final CompletionA project might get cancelled along the way and end with Terminated status.At any time during the life of a project, it may go into one of these statuses before returning to the normal flow of statuses:On Hold- OtherCompensation of EmployeesOther - Packaged Ongoing ProjectProject number: The reference used by the department to uniquely refer to the project. This is not standardised but ought to be unique within a department.Province: The province where the project is being implemented.Local Municipality: The local municipality in which the project is being delivered. This is left blank when the beneficiary area is larger than one local or metropolitan municipality.District Municipality: The district municipality in which the project is being delivered. This is left blank when the beneficiary area is larger than one district municipality.is larger than one local or metropolitan municipality.GPS Location: The coordinates to look up the project precisely on the map. This may be left blank when the project is across multiple locations.Programme Implementing agent: The programme implementing agent is responsible for appointing and managing project managers, assess feasibility, appoint and monitor performance of service providers, ensure compliance and report to the client. See Template 2T06 of the CIDB for more. Request from the department if not available.Principal agent: The principal agent is responsible for the leadership of the team and overall administration of all sections of the project and its service providers. Request from the department if not available.Main contractor: The contractor awarded the tender for the construction of the project. If they subcontract other contractors to do part of the work, they are referred to as the Main contractor. Request from the department if not available.Other service providers: Other service providers, e.g. additional contractors. Request from the department if not available.Estimated construction costs: The total cost for construction. This is an estimate updated during the project until it is completed, when it becomes the actual final cost.Estimated professional fees: The total cost for professional fees. This is an estimate updated during the project until it is completed, when it becomes the actual final cost.Total expenditure from previous years: The total actual expenditure in all financial years before the current. This field can be blank until the start of the second financial year in which the project is active.Construction costs from previous years: The actual expenditure on construction in all financial years before the current. This field can be blank until the start of the second financial year in which the project is active.Professional fees from previous years: The actual expenditure on professional fees in all financial years before the current. This field can be blank until the start of the second financial year in which the project is active.Variation orders: The total for variation orders to date. These are changes to the originally agreed scope of work, e.g. because the requirements are better understood. This field is zero until variations have been accepted by the Main Contractor and Programme Implementing Agent.Total (Main appropriation): The amount ringfenced for this project in the current financial year's original budget. This field may only be blank if the project was not part of the tabled original budget.Construction costs (Main appropriation): The amount ringfenced for construction costs for this project in the current financial year's original budget. This field may only be blank if the project was not part of the tabled original budget.Professional fees (main appropriation): The amount ringfenced for professional fees for this project in the current financial year's original budget. This field may only be blank if the project was not part of the tabled original budget.Quarter 1: The amount spent between April and June of this financial year. This field may only be blank until reporting for the quarter is concluded in the next quarter.Quarter 2: The amount spent between July and September of this financial year. Otherwise as Quarter 1.Quarter 3: The amount spent between October and December of this financial year. Otherwise as Quarter 1.Quarter 4: The amount spent between January and March of this financial year. Otherwise as Quarter 1.