Injecting configuration and compiling...
Injecting scraper and running...
(node:17) Warning: Setting the NODE_TLS_REJECT_UNAUTHORIZED environment variable to '0' makes TLS connections and HTTPS requests insecure by disabling certificate verification.
(Use `node --trace-warnings ...` to show where the warning was created)
[
{
council_reference: 'DA-2024-105',
address: '218 Risby Road, Middleton',
description: 'Change of use from ancillary dwelling to visitor accommodation',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-105-218-Risby-Road-Middleton.pdf',
date_scraped: '2024-05-06T03:36:33.055Z',
on_notice_from: '2024-05-01',
on_notice_to: '2024-05-14',
more_info: '[]'
},
{
council_reference: 'DA-2024-5',
address: '20 Mertonvale Circuit, Kingston',
description: 'Warehouses and office',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-5-00-20-Mertonvale-Circuit-Kingston.pdf',
date_scraped: '2024-05-06T03:36:33.088Z',
on_notice_from: '2024-05-01',
on_notice_to: '2024-05-14',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-5-01-Planning-Submission-Planning-Report.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-5-02-Traffic-Impact-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-5-03-Arborist-Report.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-5-04-Noise-Assessment-Report.pdf"]'
},
{
council_reference: 'DA-2023-449',
address: '2 Elandra Road, Taroona',
description: 'Addition and alteration to dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-449-2-Elandra-Road-Taroona.pdf',
date_scraped: '2024-05-06T03:36:33.088Z',
on_notice_from: '2024-05-01',
on_notice_to: '2024-05-14',
more_info: '[]'
},
{
council_reference: 'DA-2023-415',
address: '10 James Avenue, Kingston Beach',
description: 'Conjoined carport and storeroom and associated works',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-415-00-10-James-Avenue-Kingston-Beach.pdf',
date_scraped: '2024-05-06T03:36:33.090Z',
on_notice_from: '2024-05-01',
on_notice_to: '2024-05-14',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-415-01-Statement-of-Compliance-Heritage-Precinct.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-415-02-Landslide-Assessment-Report.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-415-03-Foundation-Assessment-Report.pdf"]'
},
{
council_reference: 'DA-2024-103',
address: '62 Redwood Road, Kingston',
description: 'Outbuilding (garage) and associated works',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-103-62-Redwood-Road-Kingston.pdf',
date_scraped: '2024-05-06T03:36:33.091Z',
on_notice_from: '2024-05-01',
on_notice_to: '2024-05-14',
more_info: '[]'
},
{
council_reference: 'DA-2024-54',
address: '6 Waldie Drive, Lower Snug',
description: 'Extension and alterations to dwelling and temporary caravan',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-54-6-Waldie-Drive-Lower-Snug.pdf',
date_scraped: '2024-05-06T03:36:33.092Z',
on_notice_from: '2024-05-01',
on_notice_to: '2024-05-14',
more_info: '[]'
},
{
council_reference: 'DA-2023-228',
address: '300 Llantwit Road, Woodbridge',
description: 'Extension and alterations to dwelling, outbuilding (garage), fences and demolition (re-advertised)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-228-300-Llantwit-Road-Woodbridge.pdf',
date_scraped: '2024-05-06T03:36:33.092Z',
on_notice_from: '2024-04-27',
on_notice_to: '2024-05-10',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-228-Bushfire-Advice.pd"]'
},
{
council_reference: 'DA-2023-409',
address: '510 Snug Tiers Road, Snug',
description: 'Alterations to dwelling and retrospective buildings',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-409-510-Snug-Tiers-Road-Snug.pdf',
date_scraped: '2024-05-06T03:36:33.093Z',
on_notice_from: '2024-04-24',
on_notice_to: '2024-05-08',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-409-Bushfire-Hazard-Assessment.pdf"]'
},
{
council_reference: 'DA-2024-72',
address: '30 Roslyn Avenue, Kingston Beach',
description: 'Studio',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-72-30-Roslyn-Avenue-Kingston-Beach.pdf',
date_scraped: '2024-05-06T03:36:33.093Z',
on_notice_from: '2024-04-20',
on_notice_to: '2024-05-06',
more_info: '[]'
},
{
council_reference: 'DA-2024-45',
address: '2 James Avenue, Kingston Beach',
description: 'Alterations to dwelling (deck)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-45-2-James-Avenue-Kingston-Beach.pdf',
date_scraped: '2024-05-06T03:36:33.094Z',
on_notice_from: '2024-04-20',
on_notice_to: '2024-05-06',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-45-Historic-Heritage-response-1.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-45-Historic-Heritage-response-2.pdf"]'
},
{
council_reference: 'DA-2024-36',
address: '203 Old Station Road, Lower Snug',
description: 'Outbuilding (retrospective)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-36-203-Old-Station-Road-Lower-Snug.pdf',
date_scraped: '2024-05-06T03:36:33.094Z',
on_notice_from: '2024-04-20',
on_notice_to: '2024-05-06',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2024-36-Tree-Assessment.pdf"]'
},
{
council_reference: 'DA-2023-400',
address: '23 Cleburne Street, Kingston',
description: 'Two multiple dwellings (one existing) including extension to existing dwelling and carport',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-400-23-Cleburne-Street-Kingston.pdf',
date_scraped: '2024-05-06T03:36:33.095Z',
on_notice_from: '2024-04-20',
on_notice_to: '2024-05-06',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-400-23-Cleburne-Street-Kingston-Stormwater-Management-Report.pdf"]'
},
{
council_reference: 'DA-2023-317',
address: '20 Hazell Street, Blackmans Bay',
description: 'Proposed two visitor accommodations (one new visitor accommodation unit and one existing dwelling subject to change of use to visitor accommodation)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/04/DA-2023-317-20-Hazell-Street-Blackmans-Bay.pdf',
date_scraped: '2024-05-06T03:36:33.095Z',
on_notice_from: '2024-04-20',
on_notice_to: '2024-05-06',
more_info: '[]'
}
]
.then | createQuery: CREATE TABLE IF NOT EXISTS data (council_reference TEXT PRIMARY KEY, address TEXT, description TEXT, info_url TEXT, date_scraped TEXT, on_notice_from TEXT, on_notice_to TEXT, more_info TEXT)
insertQuery | insertQuery: INSERT OR REPLACE INTO data (council_reference, address, description, info_url, date_scraped, on_notice_from, on_notice_to, more_info) VALUES (?, ?, ?, ?, ?, ?, ?, ?)