Traffic data average by hour by day—2023

datastore Error

URL: https://www.data.qld.gov.au/dataset/5334361b-3d7b-476d-9776-04dcd4a2d388/resource/d2428b1b-8e3c-4850-828a-f356c5387a0b/download/qld-traffic-data-average-by-hour-by-day-2023.xlsx

Average hourly traffic data by day and by site.

There are no views created for this resource yet.

Data Dictionary

Column Type Label Description
SITE_ID numeric

The unique identifier used by Transport and Main Roads for the location that the traffic data is collected at. The is the physical location of a traffic counting device. Sites are located at a specified Through Distance along a Road Section.

DESCRIPTION text

The descriptive details of the physical location of the traffic counting device

SITE_DISTANCE numeric

TDist or Through Distance in kilometres is the physical location of the traffic count site measured in kilometres from the beginning of the Road Section.

LONGITUDE numeric

Longitude of the location in decimal degrees (WGS Datum)

LATITUDE numeric

Latitude of the location in decimal degrees (WGS Datum)

RSECT_ID numeric

Is the Gazetted Road from which the traffic data is collected. Each Road Section is given a code allocated sequentially in Gazettal Direction. Larger roads are broken down into sections and identified by an ID code with a suffix for easier data collection and reporting (eg. 10A 10B 10C). Road Sections are then broken into AADT Segments which are determined by traffic volume.

ROAD_NAME text

The name of a gazetted road section within a major road. For example, the Bruce Highway is identified by the number 10 an alpha suffix is added to indicate the Road Section "10A" being Bruce Highway (Brisbane-Gympie).

TDIST_START numeric

Is the start through distance in kilometres of the segment the site is attached to for the road section.

TDIST_END numeric

Is the end through distance in kilometres of the segment the site is attached to for the road section.

GAZETTAL_DIRECTION text

The Gazettal Direction is the direction of the traffic flow. It can be easily recognised by referring to the name of the road eg. Road Section: 10A Brisbane - Gympie this notes that the gazettal direction is from Brisbane to Gympie.

HOURS text

Hour of the day for the traffic volume (data averaged over year).

MON numeric

Day of week of the traffic volume (data averaged over year).

TUE numeric

Day of week of the traffic volume (data averaged over year).

WED numeric

Day of week of the traffic volume (data averaged over year).

THU numeric

Day of week of the traffic volume (data averaged over year).

FRI numeric

Day of week of the traffic volume (data averaged over year).

SAT numeric

Day of week of the traffic volume (data averaged over year).

SUN numeric

Day of week of the traffic volume (data averaged over year).

WEEKDAY_AVERAGE numeric
WEEKEND_AVERAGE numeric

Additional Information

Field Value
Data last updated 8 November 2024
Metadata last updated 8 November 2024
Created 21 August 2024
Format XLSX
License Creative Commons Attribution 4.0
Size 7.4 MiB
Aligned with default data schema FALSE
Align default schemaFalse
Archiver{'resource_timestamp': None, 'status_id': 0, 'is_broken': False, 'reason': '', 'url_redirected_to': 'https://www.data.qld.gov.au/dataset/5334361b-3d7b-476d-9776-04dcd4a2d388/resource/d2428b1b-8e3c-4850-828a-f356c5387a0b/download/qld-traffic-data-average-by-hour-by-day-2023.xlsx', 'cache_filepath': 'resources/d2428b1b-8e3c-4850-828a-f356c5387a0b/qld-traffic-data-average-by-hour-by-day-2023.xlsx', 'cache_url': 'https://www.data.qld.gov.au/dataset/5334361b-3d7b-476d-9776-04dcd4a2d388/resource/d2428b1b-8e3c-4850-828a-f356c5387a0b/download/qld-traffic-data-average-by-hour-by-day-2023.xlsx', 'size': 8189051, 'mimetype': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'hash': '"57810b80791750613be5b7712a488299"', 'etag': None, 'last_modified': None, 'first_failure': None, 'last_success': '2024-08-21T02:57:47.240505', 'failure_count': 0, 'created': '2024-08-21T02:34:47.540858', 'updated': '2024-08-21T02:57:47.240505', 'status': 'Archived successfully', 'is_broken_printable': 'Downloaded OK'}
Datastore activeTrue
Datastore contains all records of source fileFalse
Has viewsFalse
Idd2428b1b-8e3c-4850-828a-f356c5387a0b
Mimetypeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Nature of changeedit-resource-with-no-new-data
Package id5334361b-3d7b-476d-9776-04dcd4a2d388
Position1
Qa{'resource_timestamp': None, 'archival_timestamp': '2024-08-21T02:57:47.240505', 'openness_score': 2, 'openness_score_reason': 'Content of file appeared to be format "XLSX" which receives openness score: 2.', 'format': 'XLSX', 'created': '2024-11-08T08:18:57.648733', 'updated': '2024-11-08T08:18:57.630698'}
Size7.4 MiB
Stateactive
Update frequencyannually
Update frequency days{"monthly": 30, "quarterly": 91, "half-yearly": 182, "annually": 365, "biennially": 730, "quadrennially": 1460}
Url typeupload
Data usability rating :
Contains proprietary format machine-readable open data.