Greater Sydney Regional Housing activity

Department of Planning, Industry and Environment

Back to dataset

Download URL: https://uatweb.datansw.links.com.au/data/dataset/97020a5b-83bb-4081-8ac0-72e48866b46f/resource/058e4f0b-06b8-4ab0-a444-6fe65c23e4f6/download/dpie-nsw-sydney-housing-activity.structured.data.june2021.xlsx

Description: This dataset contains • the latest available numbers of monthly dwelling approvals by District and Local Government Area (LGA) since July 1991, • the latest available numbers of quarterly net dwelling completions by District and LGA since July 2012 and net completions for Greater Newcastle by financial year from 2013-14, • the number of net dwelling completions for the Greater Sydney Region by financial year since 1949-50, and • the number of gross dwelling completions for New South Wales by quarter since September 1984.

Data Sources

The Department collects data from the Australian Bureau of Statistics, Sydney Water Corporation, Hunter Water Corporation, as well as the Central Coast and Shoalhaven Councils. The Department then prepares, analyses and reports on these data as part of its commitment to monitor residential dwelling approvals and completions. These data may be revised retrospectively.

Geographic coverage

These data are for the Greater Sydney, Central Coast, and Illawarra-Shoalhaven Regions and the Greater Newcastle area. These comprise the LGAs of Bayside, Blacktown, Blue Mountains, Burwood, Camden, Campbelltown, Canada Bay, Canterbury-Bankstown, Central Coast, Cessnock, Cumberland, Fairfield, Georges River, Hawkesbury, Hornsby, Hunters Hill, Inner West, Kiama, Ku-ring-gai, Lake Macquarie, Lane Cove, Liverpool, Maitland, Mosman, Newcastle, North Sydney, Northern Beaches, Parramatta, Penrith, Port Stephens, Randwick, Ryde, Shellharbour, Shoalhaven, Strathfield, Sutherland Shire, Sydney, The Hills Shire, Waverley, Willoughby, Wollondilly, Wollongong and Woollahra. On 21 September 2017, the Greater Sydney Region Districts were revised to form Central City, Eastern City, North, South and Western City (Environmental Planning and Assessment Order 2017). Previously the Greater Sydney Region Districts included Central, Central West, North, South, South West and West.

There are no views created for this resource yet.

Additional Information

Field	Value
Title	Greater Sydney Regional Housing Activity
Data last updated	20/09/2021
Metadata last updated	20/09/2021
Format	excel (.xlsx)
License	Creative Commons Attribution
Size	544.91 KB

download Download EXCEL (.XLSX)

Updates
Last updated	20/09/2021
Date Created	16/11/2018
File format	excel (.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": "058e4f0b-06b8-4ab0-a444-6fe65c23e4f6",
  "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: '058e4f0b-06b8-4ab0-a444-6fe65c23e4f6',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "058e4f0b-06b8-4ab0-a444-6fe65c23e4f6",
  "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="058e4f0b-06b8-4ab0-a444-6fe65c23e4f6",
    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 = '058e4f0b-06b8-4ab0-a444-6fe65c23e4f6',
        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": "058e4f0b-06b8-4ab0-a444-6fe65c23e4f6",
  "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: '058e4f0b-06b8-4ab0-a444-6fe65c23e4f6', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "058e4f0b-06b8-4ab0-a444-6fe65c23e4f6",
  "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="058e4f0b-06b8-4ab0-a444-6fe65c23e4f6",
    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='058e4f0b-06b8-4ab0-a444-6fe65c23e4f6', 
        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=058e4f0b-06b8-4ab0-a444-6fe65c23e4f6&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=058e4f0b-06b8-4ab0-a444-6fe65c23e4f6&q=jones