Roads Traffic Volume Counts anomolies

App development
1

Hey all,
Thanks for opening up the Roads Traffic Volume Counts API

Thought I’d pass on a few things I’ve noticed

  1. The documentation for this data points to the Traffic Volume Viewer as a sample application. However it appears that that application hits different services than the open data API so that’s perhaps not the best example :slight_smile:

  2. It also seems that data availability in road_traffic_counts_yearly_summary is lacking for 2019
    For example
    SELECT NAME, LGA, SUBURB, ROAD_FUNCTIONAL_HIERARCHY, WGS84_LATITUDE AS LATITUDE, WGS84_LONGITUDE AS LONGITUDE, SUMM.TRAFFIC_COUNT, SUMM.CLASSIFICATION_TYPE FROM road_traffic_counts_station_reference REF JOIN road_traffic_counts_yearly_summary SUMM ON REF.STATION_KEY=SUMM.STATION_KEY WHERE YEAR IN ('2019') AND PERIOD='ALL DAYS' AND TRAFFIC_DIRECTION_SEQ='2'

2015 returns 560 rows
2016 returns 404 rows
2017 returns 564 rows
2018 returns 577 rows
2019 returns 30 rows
2020 returns 383 rows

Anyway thanks again - hoping to put this data to good use
Rowan

2

Hi @rowanwins, thank you for your detailed feedback! We are aware of some issues with this API and looking into this (please refer to thread: NSW Roads Traffic Volume Counts API - #3 by jeremythorpe). We will advise when this has been resolved.

3

Hi @rowanwins The data has been refreshed and the figures appear to have been repopulated. Please advise if you are still experiencing issues with this.