Excel copy of the Top 100 highest risk intersections

Tony Randle made this Official Information request to New Zealand Transport Agency

The request was successful.

From: Tony Randle

Dear New Zealand Transport Agency,

In 2014, the NZTA published a list of the "Top 100 Highest Risk Intersections". This is available in PDF format: https://www.nzta.govt.nz/assets/resource...

The PDF appears to be a read-only version of an original Excel Spreadsheet version of this information. While useful, further analysis of this information is difficult because the data in the PDF version must be manually turned back into Excel and this will involve significant work and will likely be prone to transcribing errors.

Can the NZTA please provide a copy of the Top 100 Highest Risk Intersections in Excel Spreadsheet format ?

Yours faithfully,

Tony Randle

Link to this

From: Info@nzta.govt.nz
New Zealand Transport Agency

Thank you for contacting the NZ Transport Agency.  This is an auto-reply
message to confirm that we have received your email.


Currently we are experiencing high demand and we may not be able to
respond within our normal 3 working day timeframe.   If your enquiry is
urgent please call us on


·         Motor vehicle licensing 0800 108 809

·         Driver licensing 0800 822 422

·         Overseas +64 6 9536200


If you need to report a State Highway issue that requires urgent
attention, please call our 24/7 highway information team on 0800 444 449.


Find the latest transport news, information, and advice on our website:


show quoted sections


Visible links
1. http://www.nzta.govt.nz/

Link to this

From: Official Correspondence
New Zealand Transport Agency

Attachment image001.jpg
2K Download

Attachment image002.jpg
1K Download

Attachment image003.jpg
0K Download

Attachment image004.jpg
1K Download

Hi Tony


Thank you for your request.


A copy of the Top 100 Highest Risk Intersections in Excel format is
available on our website at point 3 under the heading "Browse
section/chapter" at:





_________  _____________________________________________   


Andrew Martin / Manager, Official Information

Official Correspondence Unit

Strategy, Communications & Performance Group


DDI 64 4 894 6153

E [2][email address] / w [3]nzta.govt.nz

National Office / Victoria Arcade, 50 Victoria Street,
Private Bag 6995, Wellington 6141, New Zealand 

_________  _____________________________________________   


            [5]cid:image002.jpg@01CF322A.4C836B10 [6]cid:image003.jpg@01CF322A.4C836B10 [7]cid:image004.jpg@01CF322A.4C836B10  




show quoted sections

Link to this

From: Tony Randle

Dear Official Correspondence,


FYI I was using Google search to find the spreadsheet compatible version and couldn't find the page you provided. Even with adding the term "Excel" in the search Google didn't find this page (Google only kept showing the PFD version).

Yours sincerely,

Tony Randle

Link to this

W SHIH left an annotation ()

The excel file is listed as a CSV file format on the site Martin provided.
"High risk intersections (CSV) — 1 pages, 9.1 KB"

Link to this

Things to do with this request

New Zealand Transport Agency only: