data on the red light camera activation at Sackville Street and Canley Vale Road - "The revenue raised by the red light camera at the intersection of Sackville Street and Canley Vale Road Canley Vale NSW"

"The revenue raised by the red light camera at the intersection of Sackville Street and Canley Vale Road Canley Vale NSW"

Download URL: https://uatweb.datansw.links.com.au/data/dataset/ac63c4e9-fc6f-4377-bb00-a4d85a2747e2/resource/c5c06da1-2255-46da-83de-71ed1c5e6740/download/fa68.xlsx

The revenue raised by the red light camera, which is placed at the intersection of Sackville Street and Canley Vale Road Canley Vale NSW during the year 2006 for each individual month of the year, so I can compare the revenues raised by the camera for each month.

Details
Last updated	18/01/2017
Date Created	18/01/2017
File format	XLSX
Licence	Creative Commons Attribution

Table

fullscreen Fullscreen

This resource view is not available at the moment. Click here for more information.

Download resource

Additional Information

Field	Value
Title	"The revenue raised by the red light camera at the intersection of Sackville Street and Canley Vale Road Canley Vale NSW"
Data last updated	18/01/2017
Metadata last updated	18/01/2017
Format	XLSX
License	Creative Commons Attribution

Data Dictionary

Label	Type	Description
Year	text
Month	text
Penalties	text
Face Value ($)	numeric

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": "c5c06da1-2255-46da-83de-71ed1c5e6740",
  "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: 'c5c06da1-2255-46da-83de-71ed1c5e6740',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "c5c06da1-2255-46da-83de-71ed1c5e6740",
  "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="c5c06da1-2255-46da-83de-71ed1c5e6740",
    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 = 'c5c06da1-2255-46da-83de-71ed1c5e6740',
        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": "c5c06da1-2255-46da-83de-71ed1c5e6740",
  "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: 'c5c06da1-2255-46da-83de-71ed1c5e6740', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "c5c06da1-2255-46da-83de-71ed1c5e6740",
  "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="c5c06da1-2255-46da-83de-71ed1c5e6740",
    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='c5c06da1-2255-46da-83de-71ed1c5e6740', 
        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=c5c06da1-2255-46da-83de-71ed1c5e6740&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=c5c06da1-2255-46da-83de-71ed1c5e6740&q=jones