Transport for NSW Real Time Vehicle Analytics, Live Camera Feed and Alerts 07-22-2019 02:26 AM

[BhaveshPatel]

This report is to show you the capabilities & possibities of Power BI as a data analytics toolset. It is pulling the realtime data for vehicle positions. This report is only refreshed 8 times per day due to Pro Licensing Limitations but it can be scaled to refresh near real time.

It is showing the real time vehicle positions, live camera feed across NSW, real time incidents, events and alerts related to Transport for NSW.

If you like my report, Please do not forget to give Kudos!

eyJrIjoiZjU0Mjc0N2EtOTVmNi00OWI1LTg0NTYtZjBiY2RhYmVlNzY3IiwidCI6IjJhODJhMmRmLWZiMjktNDRmYi1hNGNkLWYwZjc3MjNlY2RmYSJ9

[nitt]

Great work Bhavesh. would be please list the steps you used to connect through API. Thanks - nitt

[BhaveshPatel]

Hi @nitt ,

I have used the GTFS api from the Open Data Initiative TfNSW Portal.

You can access the api from the below link:

https://opendata.transport.nsw.gov.au/node/330/exploreapi#!/nswtrains/GetNSWTrains

Thanks

Bhavesh

[ltdane]

Did you use basic auth or an api key? if an api key how did you specify this?

[BhaveshPatel]

Hi @ltdane 

It is using API Key and the authentication is being handled using R httr library.

Thanks

Bhavesh

[nitt]

Thanks Bhavesh for the response