Customer service requests, with resolution time

Requests for service logged by members of the public relating to waste, graffiti, parking,

roads and traffic, parks and trees and assets in a public space.

REQUEST_STATUS - The current status of the request. This can be a combination of: CLOSED (completed/resolved), WIP (work in progress), REASSIGNED (This request has been moved to another work unit), NEW (This request has been logged and will be allocated to the appropriate officer), ACTIONED (The work has been assigned to a unit).

DATE_RECEIVED - The date that the customer service request was received.

DATE_COMPLETED - The date that the request was finalized/resolved.

SUBURB - The suburb of the request (confidential requests have been removed). Some suburb values will be blank because they do not have a location assigned.

CATEGORY - The high level category of the request.

SERVICE_DESC - A more detailed description of the request.

DAYS_TO_COMPLETE - Indicates numbers of days between DATE_RECEIVED and DATE_COMPLETED. This does not include time taken when referring to other authorities or waiting for more information from the customer.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"melbourne-vic-gov-au/customer-service-requests-with-resolution-time-ht4h-vqbu\".\"customer_service_requests_with_resolution_time\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.