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-2022-465',
address: '265 Channel Highway, Taroona',
description: 'Dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2022-465-265-Channel-Highway-Taroona.pdf',
date_scraped: '2023-12-03T01:18:22.486Z',
on_notice_from: '2023-12-02',
on_notice_to: '2023-12-15',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2022-465-265-Channel-Highway-Taroona-Arboricultural-Impact-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2022-465-265-Channel-Highway-Taroona-Bushfire-Hazard-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2022-465-265-Channel-Highway-Taroona-Geo-Environmental-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2022-465-265-Channel-Highway-Taroona-Landslide-Risk-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2022-465-265-Channel-Highway-Taroona-Natural-Values-Assessment-Environmental-Management-Plan.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2022-465-265-Channel-Highway-Taroona-Stormwater-Design-Proposal.pdf"]'
},
{
council_reference: 'DA-2023-358',
address: "'Calvin Christian School', 32 Maranoa Road, Kingston",
description: 'Change from temporary to permanent classrooms',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-358-Calvin-Christian-School-32-Maranoa-Road-Kingston.pdf',
date_scraped: '2023-12-03T01:18:22.519Z',
on_notice_from: '2023-12-02',
on_notice_to: '2023-12-15',
more_info: '[]'
},
{
council_reference: 'DA-2023-256',
address: '110 Benbows Road, Oyster Cove and Crown Lease Agreement 132402',
description: 'Oyster Farming and Processing (resource development and resource processing) including retrospective approval for infrastructure and works (stormwater and power, concrete washdown, driveway and dock areas)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-256-110-Benbows-Road-Oyster-Cove-.pdf',
date_scraped: '2023-12-03T01:18:22.520Z',
on_notice_from: '2023-12-02',
on_notice_to: '2023-12-15',
more_info: '[]'
},
{
council_reference: 'DA-2023-372',
address: '180 Coningham Road, Coningham',
description: 'Alterations and additions to dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-372-180-Coningham-Road-Coningham.pdf',
date_scraped: '2023-12-03T01:18:22.521Z',
on_notice_from: '2023-12-02',
on_notice_to: '2023-12-15',
more_info: '[]'
},
{
council_reference: 'DA-2023-377',
address: '1888 Channel Highway, Margate',
description: 'Addition and alterations to dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-377-1888-Channel-Highway-Margate.pdf',
date_scraped: '2023-12-03T01:18:22.522Z',
on_notice_from: '2023-12-02',
on_notice_to: '2023-12-15',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-377-1888-Channel-Highway-Margate-Bushfire-Hazard-Report.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-377-1888-Channel-Highway-Margate-Biodiversity-Values-Assessment.pdf"]'
},
{
council_reference: 'DA-2023-186',
address: "4 D'Entrecasteaux Drive, North Bruny",
description: 'Dwelling and associated works',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-186-4-DEntrecasteaux-Drive-North-Bruny.pdf',
date_scraped: '2023-12-03T01:18:22.523Z',
on_notice_from: '2023-12-02',
on_notice_to: '2023-12-15',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-186-4-DEntrecasteaux-Drive-North-Bruny-Natural-Values-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-186-4-DEntrecasteaux-Drive-North-Bruny-Geo-Environmental-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-186-4-DEntrecasteaux-Drive-North-Bruny-Bushfire-Hazard-Report.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-186-4-DEntrecasteaux-Drive-North-Bruny-Arboricultural-Impact-Assessment.pdf"]'
},
{
council_reference: 'DA-2023-203',
address: 'Unit 2/2 Browns Road, Kingston',
description: 'Six multiple dwellings (five existing)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-203-Unit-2-2-Browns-Road-Kingston.pdf',
date_scraped: '2023-12-03T01:18:22.524Z',
on_notice_from: '2023-11-29',
on_notice_to: '2023-12-12',
more_info: '[]'
},
{
council_reference: 'DA-2023-300',
address: '155 Fehres Road, Margate',
description: 'Demolition, additions and alterations (deck and carport)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-300-155-Fehres-Road-Margate.pdf',
date_scraped: '2023-12-03T01:18:22.524Z',
on_notice_from: '2023-11-25',
on_notice_to: '2023-12-08',
more_info: '[]'
},
{
council_reference: 'DA-2022-499',
address: "'Channel Heritage Museum', 1755 Channel Highway, Margate",
description: 'Extension to Museum storage',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2022-499-Channel-Heritage-Museum-1755-Channel-Highway-Margate.pdf',
date_scraped: '2023-12-03T01:18:22.525Z',
on_notice_from: '2023-11-25',
on_notice_to: '2023-12-08',
more_info: '[]'
},
{
council_reference: 'DA-2023-303',
address: '5 John Street, Kingston and Lot 21 Pardalote Parade, Kingston',
description: 'Intensification of use (from 4 to 6 consulting rooms)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-303-5-John-Street-Kingston-and-Lot-21-Pardalote-Parade-Kingston.pdf',
date_scraped: '2023-12-03T01:18:22.525Z',
on_notice_from: '2023-11-25',
on_notice_to: '2023-12-08',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-303-5-John-Street-Kingston-and-Lot-21-Pardalote-Parade-Kingston-Traffic-Assessment-Report.pdf"]'
},
{
council_reference: 'DA-2023-368',
address: '88 Redwood Road, Kingston',
description: 'Extension to dwelling',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-368-88-Redwood-Road-Kingston.pdf',
date_scraped: '2023-12-03T01:18:22.526Z',
on_notice_from: '2023-11-22',
on_notice_to: '2023-12-05',
more_info: '[]'
},
{
council_reference: 'DA-2023-371',
address: '25 Incana Road, Margate',
description: 'Extension to dwelling and retrospective extension to outbuilding (carport)',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-371-25-Incana-Road-Margate.pdf',
date_scraped: '2023-12-03T01:18:22.526Z',
on_notice_from: '2023-11-22',
on_notice_to: '2023-12-05',
more_info: '[]'
},
{
council_reference: 'DA-2023-340',
address: '17 Apolline Drive, Kingston',
description: 'Two multiple dwellings',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-340-17-Apolline-Drive-Kingston.pdf',
date_scraped: '2023-12-03T01:18:22.527Z',
on_notice_from: '2023-11-22',
on_notice_to: '2023-12-05',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-340-17-Apolline-Drive-Kingston-Bushfire-Hazard-Report.pdf"]'
},
{
council_reference: 'DA-2023-174',
address: '112, 116 & 120 Tinderbox Road, Blackmans Bay',
description: 'Recycled water treatment plant',
info_url: 'https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay.pdf',
date_scraped: '2023-12-03T01:18:22.528Z',
on_notice_from: '2023-11-18',
on_notice_to: '2023-12-15',
more_info: '["https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Planning-Report.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Natural-Values-Report-Environmental-Mangement-Plan.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Environmental-Monitoring-Plan-Amendment-.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Tree-Selection-and-Planting-.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Stormwater-Quality-Design-Memorandum-.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Sightlines-from-90-106-108-Tinderbox-Road.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Recycled-Water-Quality-Management-Plan-.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Noise-Assessment-.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Irrigation-and-Environmental-Management-Plan-Arm-End.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Environmental-Monitoring-Plan.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Environmental-Effects-Report-EER.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Environmental-Effects-Report-EER-APPENDIX-A-PLANS.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Coastal-Vulnerability-Assessment-Landslide-Risk-Assessment-.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Arboricultural-Assessment.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Arboricultural-Assessment-Addendum.pdf","https://www.kingborough.tas.gov.au/wp-content/uploads/2023/11/DA-2023-174-112-116-120-Tinderbox-Road-Blackmans-Bay-Tree-Protection-Plan.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 (?, ?, ?, ?, ?, ?, ?, ?)