Data on the number of reviews and waivers of the camera-detected-speeding fines

Back to dataset

Download URL: https://uatweb.datansw.links.com.au/data/dataset/be766026-4174-4e3e-88b4-ef7d67acd32f/resource/a9bf1a9c-82dd-43fc-ad73-76515d09ac95/download/fa29-speeding-cautions-categories.xlsx

"1. Please state the total number of camera-detected speeding infringements issued in NSW in 2014 that were replaced by a caution based on good driving record, broken down to a.) fixed cameras, b.) mobile cameras, c.) safety/intersection cameras for speed only. 2. Please state the total number of camera-detected speeding infringements issued in NSW in 2014 were subject to reviews, broken down to a.) fixed cameras, b.) mobile cameras, c.) safety/intersection cameras for speed only. 3. Please state the total number of camera-detected speeding infringements issued in NSW in 2014 were subject to reviews that were later withdrawn or converted to cautions, broken down to a.) fixed cameras, b.) mobile cameras, c.) safety/intersection cameras for speed only. 4. For those offences subject to referred to in 4.), please give category of reason why the infringement was withdrawn. Please state reasons, such as medical emergency or speedometer accuracy. 5. Please state the total number of camera-detected speeding infringements issued in NSW in 2014 that were taken to court and then withdrawn following a court order, broken down to a.) fixed cameras, b.) mobile cameras, c.) safety/intersection cameras for speed only.

There are no views created for this resource yet.

Additional Information

Field	Value
Title	Data on the number of reviews and waivers of the camera-detected-speeding fines
Data last updated	18/01/2017
Metadata last updated	18/01/2017
Format	XLSX
License	Creative Commons Attribution

Data Dictionary

Label	Type	Description
Camera Type	text
Penalty notices issued	text
Request for review	text
Court elected	text

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": "a9bf1a9c-82dd-43fc-ad73-76515d09ac95",
  "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: 'a9bf1a9c-82dd-43fc-ad73-76515d09ac95',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "a9bf1a9c-82dd-43fc-ad73-76515d09ac95",
  "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="a9bf1a9c-82dd-43fc-ad73-76515d09ac95",
    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 = 'a9bf1a9c-82dd-43fc-ad73-76515d09ac95',
        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": "a9bf1a9c-82dd-43fc-ad73-76515d09ac95",
  "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: 'a9bf1a9c-82dd-43fc-ad73-76515d09ac95', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "a9bf1a9c-82dd-43fc-ad73-76515d09ac95",
  "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="a9bf1a9c-82dd-43fc-ad73-76515d09ac95",
    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='a9bf1a9c-82dd-43fc-ad73-76515d09ac95', 
        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=a9bf1a9c-82dd-43fc-ad73-76515d09ac95&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=a9bf1a9c-82dd-43fc-ad73-76515d09ac95&q=jones