# NSW Roads Traffic Volume Counts API **URL:** \ **Category:** Datasets\ **Created:** [July 28, 2017, 1:26am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988 "2017-07-28T01:26:33Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/opendataforum.transport.nsw.gov.au/system/32/313_2.png) [@system](https://opendataforum.transport.nsw.gov.au/u/system)\ **Post date:** [July 28, 2017, 1:26am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/1 "2017-07-28T01:26:33Z")
RMS has permanent and temporary roadside collection devices which continuously collect traffic information data. Through the Traffic Volume Counts API, traffic count data from 2006 is available. * * * This is a companion discussion topic for the original entry at [https://opendata.transport.nsw.gov.au/dataset/nsw-roads-traffic-volume-counts-api](https://opendata.transport.nsw.gov.au/dataset/nsw-roads-traffic-volume-counts-api) ---
**Author:** ![jeremythorpe](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jeremythorpe](https://opendataforum.transport.nsw.gov.au/u/jeremythorpe)\ **Post date:** [March 23, 2020, 9:42pm UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/3 "2020-03-23T21:42:03Z")
Any updates on when this will be back on line? This is really important COVID19-related information! ---
**Author:** ![eneida.raya](https://avatars.discourse-cdn.com/v4/letter/e/76d3ee/32.png) [@eneida.raya](https://opendataforum.transport.nsw.gov.au/u/eneida.raya)\ **Post date:** [March 23, 2020, 10:40pm UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/4 "2020-03-23T22:40:15Z")
Hi @jeremythorpe. Thank you for post. Updates to the data are currently not available and we are working to resolve this. Currently, there is no timeline of when this will be ready. We will keep you posted on this Forum when it becomes available. We understand how important data is at this time. How will you use this data for COVID-19? Just wondering if there’s other data sets in our catalogue that could be helpful in the interim. ---
**Author:** ![jeremythorpe](https://avatars.discourse-cdn.com/v4/letter/j/c67d28/32.png) [@jeremythorpe](https://opendataforum.transport.nsw.gov.au/u/jeremythorpe)\ **Post date:** [March 23, 2020, 11:52pm UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/5 "2020-03-23T23:52:56Z")
The RBA Governor in a recent speech used Chinese traffic data as an indicator of the economic slowdown and then pickup. Interesting that we can get Chinese data but cannot get Sydney data! ---
**Author:** ![eneida.raya](https://avatars.discourse-cdn.com/v4/letter/e/76d3ee/32.png) [@eneida.raya](https://opendataforum.transport.nsw.gov.au/u/eneida.raya)\ **Post date:** [April 2, 2020, 4:48am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/6 "2020-04-02T04:48:57Z")
Hi @jeremythorpe. Our Traffic Volume Counts API is now up to date on our Open Data Hub: [Explore API - Traffic Volume Counts API | TfNSW Open Data Hub and Developer Portal](https://opendata.transport.nsw.gov.au/node/2171/exploreapi) We are having some teething issues with the data that we are currently looking into, but it should be a good start. ---
**Author:** ![blaganie](https://avatars.discourse-cdn.com/v4/letter/b/ec9cab/32.png) [@blaganie](https://opendataforum.transport.nsw.gov.au/u/blaganie)\ **Post date:** [April 20, 2020, 6:53am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/7 "2020-04-20T06:53:03Z")
Hi @eneida.raya. I am trying to extract volume data for 2020 year to date but can only see records for month “2” (February) in the database. Is this consistent with the remaining teething issues mentioned above? Many thanks! ---
**Author:** ![eneida.raya](https://avatars.discourse-cdn.com/v4/letter/e/76d3ee/32.png) [@eneida.raya](https://opendataforum.transport.nsw.gov.au/u/eneida.raya)\ **Post date:** [April 21, 2020, 4:13am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/8 "2020-04-21T04:13:23Z")
Hi @blaganie. We are investigating this and will get back to you shortly! ---
**Author:** ![sw12](https://avatars.discourse-cdn.com/v4/letter/s/c2a13f/32.png) [@sw12](https://opendataforum.transport.nsw.gov.au/u/sw12)\ **Post date:** [April 29, 2020, 4:43am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/9 "2020-04-29T04:43:12Z")
Hi @eneida.raya how often is this data updated? Ie. is data inputted daily, weekly or monthly? ---
**Author:** ![eneida.raya](https://avatars.discourse-cdn.com/v4/letter/e/76d3ee/32.png) [@eneida.raya](https://opendataforum.transport.nsw.gov.au/u/eneida.raya)\ **Post date:** [April 29, 2020, 5:25am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/10 "2020-04-29T05:25:20Z")
Hi @sw12. It is updated monthly. ---
**Author:** ![nic.reb](https://avatars.discourse-cdn.com/v4/letter/n/50afbb/32.png) [@nic.reb](https://opendataforum.transport.nsw.gov.au/u/nic.reb)\ **Post date:** [April 30, 2020, 12:29am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/11 "2020-04-30T00:29:17Z")
Hello, thanks for your work on this resource. I’m sure that many people are finding it invaluable at the moment. I’m having trouble locating some values of `station_key` from the `road_traffic_counts_hourly_permanent` table in the `road_traffic_counts_station_reference` table. One example is `18479652` but I count a total of 46 such instances recorded on the day `2019-01-01`. ---
**Author:** ![eneida.raya](https://avatars.discourse-cdn.com/v4/letter/e/76d3ee/32.png) [@eneida.raya](https://opendataforum.transport.nsw.gov.au/u/eneida.raya)\ **Post date:** [April 30, 2020, 4:43am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/12 "2020-04-30T04:43:38Z")
Hi @nic.reb, could you send us the query you are using? ---
**Author:** ![nic.reb](https://avatars.discourse-cdn.com/v4/letter/n/50afbb/32.png) [@nic.reb](https://opendataforum.transport.nsw.gov.au/u/nic.reb)\ **Post date:** [April 30, 2020, 5:27am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/13 "2020-04-30T05:27:46Z")
Just using the online API, this query gives results `select * from road_traffic_counts_hourly_permanent where year = 2019 and month = 1 and station_key = 18479652` But this does not `select * from road_traffic_counts_station_reference where station_key = 18479652` ---
**Author:** ![PaulTF](https://avatars.discourse-cdn.com/v4/letter/p/8baadc/32.png) [@PaulTF](https://opendataforum.transport.nsw.gov.au/u/PaulTF)\ **Post date:** [November 4, 2020, 10:18pm UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/14 "2020-11-04T22:18:13Z")
Hello, Do you have an expected date when the next tranche of data (October 2020) will be released? Cheers, Paul ---
**Author:** ![PaulTF](https://avatars.discourse-cdn.com/v4/letter/p/8baadc/32.png) [@PaulTF](https://opendataforum.transport.nsw.gov.au/u/PaulTF)\ **Post date:** [November 5, 2020, 10:14pm UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/15 "2020-11-05T22:14:05Z")
Looks like it is up. Thanks! ---
**Author:** ![mrenison](https://avatars.discourse-cdn.com/v4/letter/m/ed8c4c/32.png) [@mrenison](https://opendataforum.transport.nsw.gov.au/u/mrenison)\ **Post date:** [March 14, 2022, 8:52pm UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/16 "2022-03-14T20:52:44Z")
I’m still getting familiar with the road traffic volume counts datasets and notice that there are some days with no counts even if the station is permanent. For example, when filter on station\_key = 57108 and year \>= 2019, I notice that 2019/01/23 to 2019/01/31 are all missing. Is there a specific reason for this? ---
**Author:** ![davidchristie](https://avatars.discourse-cdn.com/v4/letter/d/a9adbd/32.png) [@davidchristie](https://opendataforum.transport.nsw.gov.au/u/davidchristie)\ **Post date:** [June 24, 2022, 2:26am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/17 "2022-06-24T02:26:02Z")
Hi, In the road\_traffic\_counts\_hourly\_permanent table do null hourly count values represent 0, or missing data? Example with null hourly counts: SELECT \* FROM road\_traffic\_counts\_hourly\_permanent WHERE station\_key = 57140 ORDER BY date DESC LIMIT 100 ---
**Author:** ![dataeg](https://avatars.discourse-cdn.com/v4/letter/d/f19dbf/32.png) [@dataeg](https://opendataforum.transport.nsw.gov.au/u/dataeg)\ **Post date:** [August 10, 2022, 11:18pm UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/18 "2022-08-10T23:18:36Z")
Hi team, We have come across stations where the station key exists in the road\_traffic\_counts\_hourly\_permanent table but does not exist in the road\_traffic\_counts\_station\_reference table. Can you please look into this and provide an update? Example queries below: SELECT \* FROM road\_traffic\_counts\_hourly\_permanent where station\_key = 18479661 and year = 2022 SELECT \* FROM road\_traffic\_counts\_station\_reference where station\_key = 18479661 ---
**Author:** ![dataeg](https://avatars.discourse-cdn.com/v4/letter/d/f19dbf/32.png) [@dataeg](https://opendataforum.transport.nsw.gov.au/u/dataeg)\ **Post date:** [January 29, 2023, 11:50pm UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/19 "2023-01-29T23:50:54Z")
Hi Team, The traffic data has not been updated since August 2022 but we have come across an unofficial endpoint where it provides latest data (from December): [https://rms-uat.carto.com/api/v2/sql?q=SELECT](https://rms-uat.carto.com/api/v2/sql?q=SELECT) \* FROM ds\_aadt\_permanent\_hourly\_data Is that endpoint maintained by Transport for NSW? We were not able to find the link and the table in the official documentation. This table already has December 2022 data while the official table (road\_traffic\_counts\_hourly\_permanent) latest data is from August 2022. Can you please provide more information about this? Best regards, ---
**Author:** ![Marcie](https://avatars.discourse-cdn.com/v4/letter/m/a5b964/32.png) [@Marcie](https://opendataforum.transport.nsw.gov.au/u/Marcie)\ **Post date:** [February 8, 2023, 1:35am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/20 "2023-02-08T01:35:28Z")
Hi All, please be advised we have rectified two issues identified by @dataeg. For station keys existing in hourly permanent table but NOT station reference table; the queries for the station reference table were set up originally to dismiss any stations that had any missing details. The team will be seeking approval to modify these scripts. For traffic data not updating; there were technical issues with the database but these have now been fixed. Data should be updated to Jan 2023. Thanks for your patience all 🙂 ---
**Author:** ![MC.PP](https://avatars.discourse-cdn.com/v4/letter/m/22d042/32.png) [@MC.PP](https://opendataforum.transport.nsw.gov.au/u/MC.PP)\ **Post date:** [May 11, 2023, 3:49am UTC](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988/21 "2023-05-11T03:49:11Z")
@Marcie Hi Marcie, out of curiosity, has RMS stopped traffic counting on SHB, SHT and surrounding major roads? Noticed SHB data hasn’t been updated since 2016. [Next page](https://opendataforum.transport.nsw.gov.au/t/nsw-roads-traffic-volume-counts-api/988.md?page=2)