Injecting configuration and compiling...
Injecting scraper and running...
(node:18) 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-170',
address: 'Shop 1/34 Mertonvale Circuit, Kingston',
description: 'Change to exterior and signage',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-170-Shop-1-34-Mertonvale-Circuit-Kingston.pdf',
date_scraped: '2024-07-26T15:13:39.395Z',
on_notice_from: '2024-07-27',
on_notice_to: '2024-08-09',
more_info: '[]'
},
{
council_reference: 'DA-2023-389',
address: '68, 70 & 74 Beach Road, Kingston Beach',
description: 'Four multiple dwellings (one existing) at 70 Beach Road, access over 74 Beach Road and adjoining Council road reserve, and stormwater works over 68 Beach Road, Kingston Beach',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2023-389-00-68-70-74-Beach-Road-Kingston-Beach.pdf',
date_scraped: '2024-07-26T15:13:39.427Z',
on_notice_from: '2024-07-27',
on_notice_to: '2024-08-09',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2023-389-01-Tree-Management-Report.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2023-389-02-Landslide-Risk-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2023-389-03-Heritage-Statement-of-Compliance.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2023-389-04-Traffic-Impact-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2023-389-05-Site-Assessment-Report.pdf"]'
},
{
council_reference: 'DA-2024-173',
address: '40 Gumpits Road, Birchs Bay',
description: 'Extension and alterations to dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-173-40-Gumpits-Road-Birchs-Bay.pdf',
date_scraped: '2024-07-26T15:13:39.428Z',
on_notice_from: '2024-07-24',
on_notice_to: '2024-08-06',
more_info: '[]'
},
{
council_reference: 'DA-2024-162',
address: '46 Beach Road, Kingston Beach',
description: 'Extension and alterations to cabin',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-162-46-Beach-Road-Kingston-Beach.pdf',
date_scraped: '2024-07-26T15:13:39.430Z',
on_notice_from: '2024-07-24',
on_notice_to: '2024-08-06',
more_info: '[]'
},
{
council_reference: 'DA-2022-336',
address: '136 Manuka Road, Oyster Cove',
description: 'Outbuilding (carport/shed - retrospective) with partial demolition of shed lean-to, outbuilding (garage/deck - retrospective), outbuilding (4 car garage), extension to outbuilding (garage/studio) and associated works (retrospective)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2022-336-00-136-Manuka-Road-Oyster-Cove.pdf',
date_scraped: '2024-07-26T15:13:39.431Z',
on_notice_from: '2024-07-24',
on_notice_to: '2024-08-06',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2022-336-01-Environmental-Management-Plan.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2022-336-02-Natural-Values-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2022-336-03-Landslide-Risk-Assessment.pdf"]'
},
{
council_reference: 'DA-2024-79',
address: '1 Ascot Drive, Huntingfield',
description: 'Change o fuse to gym, signage, and external alterations',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-79-00-1-Ascot-Drive-Huntingfield.pdf',
date_scraped: '2024-07-26T15:13:39.432Z',
on_notice_from: '2024-07-20',
on_notice_to: '2024-08-02',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-79-01-Traffic-Impact-Assessment-Letter-of-Addendum-1.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-79-02-Town-Planning-Compliance-Review.pdf"]'
},
{
council_reference: 'DA-2024-240',
address: '28 Bloomsbury Lane, Kettering',
description: 'Change in operating hours',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-240-28-Bloomsbury-Lane-Kettering.pdf',
date_scraped: '2024-07-26T15:13:39.432Z',
on_notice_from: '2024-07-20',
on_notice_to: '2024-08-02',
more_info: '[]'
},
{
council_reference: 'DA-2024-198',
address: '4 Pybus Street, Snug',
description: 'Additions and alterations to dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-198-4-Pybus-Street-Snug.pdf',
date_scraped: '2024-07-26T15:13:39.433Z',
on_notice_from: '2024-07-20',
on_notice_to: '2024-08-02',
more_info: '[]'
},
{
council_reference: 'DAS-2022-30',
address: '180 Allens Rivulet Road, Allens Rivulet',
description: 'Subdivision creating two (2) lots',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DAS-2022-30-00-180-Allens-Rivulet-Road-Allens-Rivulet.pdf',
date_scraped: '2024-07-26T15:13:39.433Z',
on_notice_from: '2024-07-17',
on_notice_to: '2024-07-30',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DAS-2022-30-01-Bushfire-Hazard-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DAS-2022-30-02-Cover-Letter.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DAS-2022-30-03-Further-Information-Response-Letter.pdf"]'
},
{
council_reference: 'DA-2024-153',
address: '244 Coningham Road, Coningham',
description: 'Extension and alterations to dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-153-00-244-Coningham-Road-Coningham.pdf',
date_scraped: '2024-07-26T15:13:39.434Z',
on_notice_from: '2024-07-17',
on_notice_to: '2024-07-30',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2024-153-01-Bushfire-Hazard-Assessment.pdf"]'
},
{
council_reference: 'DA-2021-700',
address: '3643 Channel Highway, Birchs Bay',
description: 'Dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2021-700-00-3643-Channel-Highway-Birchs-Bay.pdf',
date_scraped: '2024-07-26T15:13:39.434Z',
on_notice_from: '2024-07-17',
on_notice_to: '2024-07-30',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2021-700-01-Arboricultural-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2021-700-02-Farm-Management-Plan.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2021-700-03-Bushfire-Hazard-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2021-700-04-Cover-Letter.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2024/07/DA-2021-700-05-Site-and-Soil-Evaluation-Report-Onsite-Wastewater-Assessment.pdf"]'
}
]
.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 (?, ?, ?, ?, ?, ?, ?, ?)