Fines issued in relation to the speeding limits at the Cross City Tunnel

Back to dataset

Download URL: https://uatweb.datansw.links.com.au/data/dataset/9ee89e69-fdf3-4c2f-bd04-1f2b4cfc54e8/resource/5f6e440a-c823-4588-a342-69771cca360e/download/fa42.xlsx

"1. The usual speed limit in the Cross City Tunnel is 80km/h but there are variable speed signgs. Please state how many of the 12,032 fines were recorded when a speed limit less than 80km/h was in force in the 2014-15 period.

Please provide a print out of time and date of each speeding infringement recorded when a speed limit less than 80km/h was applied in the 20 14-15 financial year period. Please include the speed limit enforced, speed recorded and the time and date of offence.
Please state how many speeding offences were recorded in the Cross City Tunnel in the period July 1, 2015 to September 30, 2015 where a speed limit less than 80km/h was in force.
Please provide a print out of time and date of each speeding infringement recorded in the period between July 1, 2015 to September 30, 2015 when a speed limit less than 80km/h was applied. Please include the speed limit enforced, speed recorded and the time and date of offence. "

There are no views created for this resource yet.

Additional Information

Field	Value
Title	Fines issued in relation to the speeding limits at the Cross City Tunnel
Data last updated	18/01/2017
Metadata last updated	18/01/2017
Format	XLSX
License	Creative Commons Attribution

download Download XLSX

Updates
Last updated	18/01/2017
Date Created	18/01/2017
File format	XLSX

Licence
Creative Commons Attribution

CKAN Data API

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Code examples:

curl JavaScript PowerShell Python R

Querying

Get 5 results containing "jones" in any field:

curl https://uatweb.datansw.links.com.au/data/api/action/datastore_search \
  -H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "5f6e440a-c823-4588-a342-69771cca360e",
  "limit": 5,
  "q": "jones"
}'

const resp = await fetch(`https://uatweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: '5f6e440a-c823-4588-a342-69771cca360e',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "5f6e440a-c823-4588-a342-69771cca360e",
  "limit": 5,
  "q": "jones"
}
'@
$response = Invoke-RestMethod https://uatweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

(using the ckanapi client library)

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://uatweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="5f6e440a-c823-4588-a342-69771cca360e",
    limit=5,
    q="jones",
)
print(result['records'])

library(httr2)

req <- request("https://uatweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = '5f6e440a-c823-4588-a342-69771cca360e',
        limit = 5,
        q = 'jones'))
    req_perform %>% 
    resp_body_json

Get results with either "watershed" or "survey" as subject and "active" as its stage:

curl https://uatweb.datansw.links.com.au/data/api/action/datastore_search \
-H"Authorization:$API_TOKEN" -d '
{
"resource_id": "5f6e440a-c823-4588-a342-69771cca360e",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}'

const resp = await fetch(`https://uatweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({resource_id: '5f6e440a-c823-4588-a342-69771cca360e', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "5f6e440a-c823-4588-a342-69771cca360e",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}
'@
$response = Invoke-RestMethod https://uatweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://uatweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="5f6e440a-c823-4588-a342-69771cca360e",
    filters={
      "subject": ["watershed", "survey"],
      "stage": "active",
    },
)
print(result['records'])

library(httr2)

req <- request("https://uatweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id='5f6e440a-c823-4588-a342-69771cca360e', 
        filters = list(
            subject = list("watershed", "survey"), 
            stage = "active")))
    req_perform %>% 
    resp_body_json

Using the API with this Web Browser

Some API endpoints may be accessed using a GET query string.

Query example (first 5 results)

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=5f6e440a-c823-4588-a342-69771cca360e&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=5f6e440a-c823-4588-a342-69771cca360e&q=jones