The National Infrastructure Pipeline is produced by Te Waihanga and is a compilation of infrastructure project information collected from many contributing organisations. The data is released under a creative commons Attribution 4.0 International licence (CC BY 4.0).
Users of this data are required to credit “National Infrastructure Pipeline – produced by Te Waihanga” as the data source. Note that data is subject to change, including but not limited to, the structure, the data format, the file format, or the detail provided.
Data definitions - Metadata
| No | Column Name | Title and Label Used in the Pipeline | Type | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | N/A - not displayed. | Text. Constrained to 10 characters. | Alphanumeric code assigned to the project by Te Waihanga. Does not change if the project changes its name and remains essentially the same project in scope. ParentProjectIDs are retired permanently and not re-used if a project is cancelled. |
| 2 | DateUpdated | Date updated. | Datetime year, month and day in YYYY-MM-DD format. | Date of the latest update to the project. |
| 3 | ProcuringOrganisation | Organisation | Text. Enclosed in standard double-quotes as some organisation names may include commas; comma is used as the delimiter in the CSV for download. | Full legal name of the organisation managing the procurement process for infrastructure projects. |
| 4 | ProjectName | Project | Text. Enclosed in standard double-quotes as some names may include commas; comma is used as the delimiter in the CSV for download. | Project name as supplied by the procuring organisation. May have been modified slightly by Te Waihanga to expand on acronyms or abbreviations that may be unfamiliar outside the procuring organisation. |
| 5 | ProjectShortDescription | N/A - displayed without a label on project detail pages. | Text. Enclosed in standard double-quotes as some descriptions may include commas; comma is used as the delimiter in the CSV for download. | Short paragraph supplied by the procuring organisation. |
| 6 | ParentProjectID | N/A - not displayed. | Text. Constrained to 10 characters. | If a project or programme of work has sub-projects the PrimaryKey of the parent project will be identified in this column. |
| 7 | ProjectStatus | Project status | Text. | Options are: Early Planning; In Planning; In Procurement; Under Construction; Complete. |
| 8 | FundingStatus | N/A - not displayed. | Text. | Options are: Funded for delivery, Funding source to be confirmed, Funding source confirmed |
| 9 | ProcurementType | N/A - not displayed. | Text. | Options are: To be determined, Open, Selective, Limited, Direct |
| 10 | ProcurementMethod | Procurement method | Text. | Options are: To be determined; Design and construct; Construct only; Public Private Partnership; Other. |
| 11 | ProjectRegion | Region | Text. | Regions as defined by local government authorities. The Nationwide option is selected if a project spans multiple regions. Options are: Nationwide; Northland; Auckland; Waikato; Bay of Plenty; Gisborne; Hawkes Bay; Taranaki; Manawatu - Whanganui; Wellington; Marlborough; Tasman; West Coast; Canterbury; Otago; Southland; Other (not in NZ territory). |
| 12 | ProjectSector | Sector | Text. | Sector terms have been chosen by Te Waihanga. |
| 13 | EstimatedProjectValueRange | Cost range | Text. | Options are: < 5 Million; 5 - 25 Million; 25 - 50 Million; 50 - 100 Million; 100 - 250 Million; 250 - 500 Million; 500 Million - 1 Billion; 1 Billion +. |
| 14 | EstimatedQuarterBusinessCaseStart | Business case (est) | Text. Format YYYY-Q#. | Alphanumeric to allow sorting in year YYYY- then quarter Q# order. Quarters relate to the calendar not fiscal (government financial) year. Q1 is from 1 January to 31 March; Q2 from 1 April to 30 June; Q3 from 1 July to 30 September; and Q4 from 1 October to 31 December. Value will be null (empty) if a procuring organisation is not yet able to break down the project dates for the three phases. |
| 15 | EstimatedQuarterBusinessCaseCompletion | Business case (est) | Text. Format YYYY-Q#. | Alphanumeric to allow sorting in year YYYY- then quarter Q# order. Quarters relate to the calendar not fiscal (government financial) year. Q1 is from 1 January to 31 March; Q2 from 1 April to 30 June; Q3 from 1 July to 30 September; and Q4 from 1 October to 31 December. Value will be null (empty) if a procuring organisation is not yet able to break down the project dates for the three phases. |
| 16 | EstimatedQuarterProcurementStart | Procurement (est) | Text. Format YYYY-Q#. | Alphanumeric to allow sorting in year YYYY- then quarter Q# order. Quarters relate to the calendar not fiscal (government financial) year. Q1 is from 1 January to 31 March; Q2 from 1 April to 30 June; Q3 from 1 July to 30 September; and Q4 from 1 October to 31 December. Value will be null (empty) if a procuring organisation is not yet able to break down the project dates for the three phases. |
| 17 | EstimatedQuarterProcurementCompletion | Procurement (est) | Text. Format YYYY-Q#. | Alphanumeric to allow sorting in year YYYY- then quarter Q# order. Quarters relate to the calendar not fiscal (government financial) year. Q1 is from 1 January to 31 March; Q2 from 1 April to 30 June; Q3 from 1 July to 30 September; and Q4 from 1 October to 31 December. Value will be null (empty) if a procuring organisation is not yet able to break down the project dates for the three phases. |
| 18 | EstimatedQuarterConstructionStart | Construction (est) | Text. Format YYYY-Q#. | Alphanumeric to allow sorting in year YYYY- then quarter Q# order. Quarters relate to the calendar not fiscal (government financial) year. Q1 is from 1 January to 31 March; Q2 from 1 April to 30 June; Q3 from 1 July to 30 September; and Q4 from 1 October to 31 December. Value will be null (empty) if a procuring organisation is not yet able to break down the project dates for the three phases. |
| 19 | EstimatedQuarterConstructionCompletion | Construction (est) | Text. Format YYYY-Q#. | Alphanumeric to allow sorting in year YYYY- then quarter Q# order. Quarters relate to the calendar not fiscal (government financial) year. Q1 is from 1 January to 31 March; Q2 from 1 April to 30 June; Q3 from 1 July to 30 September; and Q4 from 1 October to 31 December. Value will be null (empty) if a procuring organisation is not yet able to break down the project dates for the three phases. |
| 20 | EstimatedQuarterProjectRangeStart | Phases undetermined (est) | Text. Format YYYY-Q#. | Alphanumeric to allow sorting in year YYYY- then quarter Q# order. Quarters relate to the calendar not fiscal (government financial) year. Q1 is from 1 January to 31 March; Q2 from 1 April to 30 June; Q3 from 1 July to 30 September; and Q4 from 1 October to 31 December. Value will be null (empty) if a procuring organisation has been able to break down the project dates into three phases. |
| 21 | EstimatedQuarterProjectRangeCompletion | Phases undetermined (est) | Text. Format YYYY-Q#. | Alphanumeric to allow sorting in year YYYY- then quarter Q# order. Quarters relate to the calendar not fiscal (government financial) year. Q1 is from 1 January to 31 March; Q2 from 1 April to 30 June; Q3 from 1 July to 30 September; and Q4 from 1 October to 31 December. Value will be null (empty) if a procuring organisation has been able to break down the project dates into three phases. |
| 22 | ProjectInfoURL | Project info URL | Text. | URI or URL supplied by a procuring organisation for more information about either a. the specific project, b. the organisation's infrastructure and procurement plans or c. the procuring organisation. |
| 23 | EstimatedProjectValueNote | N/A - not displayed. | Text. | A procuring organisation may supply information to explain why a project value fits within a particular range. |
