# Open Data Traffic Volume

**URL:** https://opendataforum.transport.nsw.gov.au/t/open-data-traffic-volume/5382
**Category:** Data updates
**Created:** [April 4, 2025, 3:50am UTC](https://opendataforum.transport.nsw.gov.au/t/open-data-traffic-volume/5382 "2025-04-04T03:50:47Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Shah](https://avatars.discourse-cdn.com/v4/letter/s/f4b2a3/32.png) [@Shah](https://opendataforum.transport.nsw.gov.au/u/Shah)
#### Post date: [April 4, 2025, 3:50am UTC](https://opendataforum.transport.nsw.gov.au/t/open-data-traffic-volume/5382/1 "2025-04-04T03:50:48Z")

</div>

Hi Team,  
We are trying to use Open Data Traffic Volume and identified some data is missing. Analytics team has conducted an investigation using the available CSV files from Open Data as of 03-02-2025. Below are the key observations:

1. **Road\_traffic\_counts\_hourly\_permanent (combined csvs): data updated on TfNSW - January 30, 2025**

- There are 532 permanent stations appeared in data from 2006 to 2021 but from 2022 to 2024, 307 stations found to be missing. Below summary is the summary of missing data:  
Top LGA’s missing: Wollongong (18), Blacktown (15), Hornsby(15), Newcastle(14), Lake Macquarie(13), Parramatta(13)  
Device missing the most: Trafficorder Loop Counter (203)
- 129 station\_keys (out of 661) did not map with station\_id from reference table
- Dates missing records from 2006, 2019, and 2022.

1. **road\_traffic\_counts\_yearly\_summary.csv: from data last updated - January 27, 2025**

- There are total 1,918 _station\_key/id_ which are more then the records in **road\_traffic\_counts\_station\_reference.csv**
- Total 1,783 records with same number of station\_key and station\_id in the **road\_traffic\_counts\_station\_reference.csv**

Furthermore, If we can get support in providing response on the below queries:

1. **what is best way to calculate the traffic volume by year using below datasets:**

- Road\_traffic\_counts\_station\_reference.csv
- road\_traffic\_counts\_yearly\_summary.csv

1. **what is the method to derive yearly summary of traffic volume from road\_traffic\_counts\_hourly\_permanent (combined csv) dataset to match road\_traffic\_counts\_yearly\_summary.csv**

Thanks

---

<div class="post-metadata">

### Author: ![Marcie](https://avatars.discourse-cdn.com/v4/letter/m/a5b964/32.png) [@Marcie](https://opendataforum.transport.nsw.gov.au/u/Marcie)
#### Post date: [July 11, 2025, 1:38am UTC](https://opendataforum.transport.nsw.gov.au/t/open-data-traffic-volume/5382/2 "2025-07-11T01:38:18Z")

</div>

Hi @Shah,

apologies for the delayed response. In response to the data quality side we have the following information from Transport:

_Transport is aware that the availability of Traffic Volume datasets has been experiencing issues in recent times. There is an initiative underway to rebuild this service, however this is an extensive task, and a timeline for completion has not yet been set. Transport will endeavour to provide updates on progress of this initiative when they become available._

I’ll get back to you regarding Q3 & Q4 shortly.