otherchirps / cairns

Cairns Regional Council Development Applications


Development applications for PlanningAlerts.

Contributors otherchirps

Last run completed successfully .

Console output of last run

Injecting configuration and compiling...  -----> Python app detected -----> Installing python-2.7.6  $ pip install -r requirements.txt  Collecting lxml==3.4.4 (from -r requirements.txt (line 1))  /app/.heroku/python/lib/python2.7/site-packages/pip-8.1.2-py2.7.egg/pip/_vendor/requests/packages/urllib3/util/ssl_.py:318: SNIMissingWarning: An HTTPS request has been made, but the SNI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can cause validation failures. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#snimissingwarning.  SNIMissingWarning  /app/.heroku/python/lib/python2.7/site-packages/pip-8.1.2-py2.7.egg/pip/_vendor/requests/packages/urllib3/util/ssl_.py:122: InsecurePlatformWarning: A true SSLContext object is not available. This prevents urllib3 from configuring SSL appropriately and may cause certain SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.  InsecurePlatformWarning  Downloading lxml-3.4.4.tar.gz (3.5MB)  Collecting scraperwiki==0.4.1 (from -r requirements.txt (line 2))  Downloading scraperwiki-0.4.1.tar.gz  Collecting Scrapy==0.24.6 (from -r requirements.txt (line 3))  Downloading Scrapy-0.24.6-py2-none-any.whl (444kB)  Collecting service-identity==14.0.0 (from -r requirements.txt (line 4))  Downloading service_identity-14.0.0-py2.py3-none-any.whl  Collecting requests (from scraperwiki==0.4.1->-r requirements.txt (line 2))  Downloading requests-2.11.0-py2.py3-none-any.whl (514kB)  Collecting sqlalchemy (from scraperwiki==0.4.1->-r requirements.txt (line 2))  Downloading SQLAlchemy-1.0.14.tar.gz (4.8MB)  Collecting alembic (from scraperwiki==0.4.1->-r requirements.txt (line 2))  Downloading alembic-0.8.7.tar.gz (968kB)  Collecting pyOpenSSL (from Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading pyOpenSSL-16.0.0-py2.py3-none-any.whl (45kB)  Collecting w3lib>=1.8.0 (from Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading w3lib-1.15.0-py2.py3-none-any.whl  Collecting Twisted>=10.0.0 (from Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading Twisted-16.3.0.tar.bz2 (2.9MB)  Collecting queuelib (from Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading queuelib-1.4.2-py2.py3-none-any.whl  Collecting six>=1.5.2 (from Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading six-1.10.0-py2.py3-none-any.whl  Collecting cssselect>=0.9 (from Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading cssselect-0.9.2-py2.py3-none-any.whl  Collecting pyasn1-modules (from service-identity==14.0.0->-r requirements.txt (line 4))  Downloading pyasn1_modules-0.0.8-py2.py3-none-any.whl  Collecting characteristic>=14.0.0 (from service-identity==14.0.0->-r requirements.txt (line 4))  Downloading characteristic-14.3.0-py2.py3-none-any.whl  Collecting pyasn1 (from service-identity==14.0.0->-r requirements.txt (line 4))  Downloading pyasn1-0.1.9-py2.py3-none-any.whl  Collecting Mako (from alembic->scraperwiki==0.4.1->-r requirements.txt (line 2))  Downloading Mako-1.0.4.tar.gz (574kB)  Collecting python-editor>=0.3 (from alembic->scraperwiki==0.4.1->-r requirements.txt (line 2))  Downloading python-editor-1.0.1.tar.gz  Collecting cryptography>=1.3 (from pyOpenSSL->Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading cryptography-1.4.tar.gz (399kB)  Collecting zope.interface>=3.6.0 (from Twisted>=10.0.0->Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading zope.interface-4.2.0.tar.gz (146kB)  Collecting MarkupSafe>=0.9.2 (from Mako->alembic->scraperwiki==0.4.1->-r requirements.txt (line 2))  Downloading MarkupSafe-0.23.tar.gz  Collecting idna>=2.0 (from cryptography>=1.3->pyOpenSSL->Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading idna-2.1-py2.py3-none-any.whl (54kB)  Collecting enum34 (from cryptography>=1.3->pyOpenSSL->Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading enum34-1.1.6-py2-none-any.whl  Collecting ipaddress (from cryptography>=1.3->pyOpenSSL->Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading ipaddress-1.0.16-py27-none-any.whl  Collecting cffi>=1.4.1 (from cryptography>=1.3->pyOpenSSL->Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading cffi-1.7.0-cp27-cp27m-manylinux1_x86_64.whl (386kB)  Collecting pycparser (from cffi>=1.4.1->cryptography>=1.3->pyOpenSSL->Scrapy==0.24.6->-r requirements.txt (line 3))  Downloading pycparser-2.14.tar.gz (223kB)  Installing collected packages: lxml, requests, sqlalchemy, MarkupSafe, Mako, python-editor, alembic, scraperwiki, six, idna, pyasn1, enum34, ipaddress, pycparser, cffi, cryptography, pyOpenSSL, w3lib, zope.interface, Twisted, queuelib, cssselect, Scrapy, pyasn1-modules, characteristic, service-identity  Running setup.py install for lxml: started  Running setup.py install for lxml: still running...  Running setup.py install for lxml: finished with status 'done'  Running setup.py install for sqlalchemy: started  Running setup.py install for sqlalchemy: finished with status 'done'  Running setup.py install for MarkupSafe: started  Running setup.py install for MarkupSafe: finished with status 'done'  Running setup.py install for Mako: started  Running setup.py install for Mako: finished with status 'done'  Running setup.py install for python-editor: started  Running setup.py install for python-editor: finished with status 'done'  Running setup.py install for alembic: started  Running setup.py install for alembic: finished with status 'done'  Running setup.py install for scraperwiki: started  Running setup.py install for scraperwiki: finished with status 'done'  Running setup.py install for pycparser: started  Running setup.py install for pycparser: finished with status 'done'  Running setup.py install for cryptography: started  Running setup.py install for cryptography: finished with status 'done'  Running setup.py install for zope.interface: started  Running setup.py install for zope.interface: finished with status 'done'  Running setup.py install for Twisted: started  Running setup.py install for Twisted: finished with status 'done'  Successfully installed Mako-1.0.4 MarkupSafe-0.23 Scrapy-0.24.6 Twisted-16.3.0 alembic-0.8.7 cffi-1.7.0 characteristic-14.3.0 cryptography-1.4 cssselect-0.9.2 enum34-1.1.6 idna-2.1 ipaddress-1.0.16 lxml-3.4.4 pyOpenSSL-16.0.0 pyasn1-0.1.9 pyasn1-modules-0.0.8 pycparser-2.14 python-editor-1.0.1 queuelib-1.4.2 requests-2.11.0 scraperwiki-0.4.1 service-identity-14.0.0 six-1.10.0 sqlalchemy-1.0.14 w3lib-1.15.0 zope.interface-4.2.0   ! Hello! It looks like your application is using an outdated version of Python.  ! This caused the security warning you saw above during the 'pip install' step.  ! We recommend 'python-2.7.12', which you can specify in a 'runtime.txt' file.  ! -- Much Love, Heroku.   -----> Discovering process types  Procfile declares types -> scraper Injecting scraper and running... 2016-08-15 02:27:01+0000 [planningalerts] INFO: Searching for requests between 2016-08-01 and 2016-08-31 2016-08-15 02:27:23+0000 [planningalerts] INFO: Saved 7187/2016 2016-08-15 02:27:23+0000 [planningalerts] INFO: Saved 7178/2016 2016-08-15 02:27:24+0000 [planningalerts] INFO: Saved 7171/2016 2016-08-15 02:27:24+0000 [planningalerts] INFO: Saved 7156/2016 2016-08-15 02:27:24+0000 [planningalerts] INFO: Saved 7169/2016 2016-08-15 02:27:24+0000 [planningalerts] INFO: Saved 7161/2016 2016-08-15 02:27:24+0000 [planningalerts] INFO: Saved 7185/2016 2016-08-15 02:27:24+0000 [planningalerts] INFO: Saved 7152/2016 2016-08-15 02:27:26+0000 [planningalerts] INFO: Saved 7170/2016 2016-08-15 02:27:27+0000 [planningalerts] INFO: Saved 7159/2016 2016-08-15 02:27:27+0000 [planningalerts] INFO: Saved 7176/2016 2016-08-15 02:27:28+0000 [planningalerts] INFO: Saved 7180/2016 2016-08-15 02:27:28+0000 [planningalerts] INFO: Saved 7186/2016 2016-08-15 02:27:28+0000 [planningalerts] INFO: Saved 7181/2016 2016-08-15 02:27:28+0000 [planningalerts] INFO: Saved 7158/2016 2016-08-15 02:27:28+0000 [planningalerts] INFO: Saved 7179/2016 2016-08-15 02:27:29+0000 [planningalerts] INFO: Saved 7182/2016 2016-08-15 02:27:33+0000 [planningalerts] INFO: Saved 7149/2016 2016-08-15 02:27:33+0000 [planningalerts] INFO: Saved 7157/2016 2016-08-15 02:27:34+0000 [planningalerts] INFO: Saved 7183/2016 2016-08-15 02:27:35+0000 [planningalerts] INFO: Saved 7177/2016 2016-08-15 02:27:36+0000 [planningalerts] INFO: Saved 7162/2016 2016-08-15 02:27:36+0000 [planningalerts] INFO: Saved 7160/2016 2016-08-15 02:27:36+0000 [planningalerts] INFO: Saved 7174/2016 2016-08-15 02:27:37+0000 [planningalerts] INFO: Saved 7173/2016 2016-08-15 02:27:44+0000 [planningalerts] INFO: Saved 7184/2016 2016-08-15 02:27:44+0000 [planningalerts] INFO: Saved 7167/2016 2016-08-15 02:27:45+0000 [planningalerts] INFO: Saved 7164/2016 2016-08-15 02:27:47+0000 [planningalerts] INFO: Saved 7175/2016 2016-08-15 02:27:48+0000 [planningalerts] INFO: Saved 7163/2016 2016-08-15 02:27:48+0000 [planningalerts] INFO: Saved 7165/2016 2016-08-15 02:27:48+0000 [planningalerts] INFO: Saved 7168/2016 2016-08-15 02:27:48+0000 [planningalerts] INFO: Closing spider (finished) 2016-08-15 02:27:48+0000 [planningalerts] INFO: Dumping Scrapy stats: {'downloader/request_bytes': 19773, 'downloader/request_count': 34, 'downloader/request_method_count/GET': 34, 'downloader/response_bytes': 547302, 'downloader/response_count': 34, 'downloader/response_status_count/200': 34, 'finish_reason': 'finished', 'finish_time': datetime.datetime(2016, 8, 15, 2, 27, 48, 868601), 'item_scraped_count': 32, 'memdebug/gc_garbage_count': 0, 'memdebug/live_refs/PlanningalertsSpider': 1, 'memusage/max': 45568000, 'memusage/startup': 45568000, 'request_depth_max': 2, 'response_received_count': 34, 'scheduler/dequeued': 34, 'scheduler/dequeued/memory': 34, 'scheduler/enqueued': 34, 'scheduler/enqueued/memory': 34, 'start_time': datetime.datetime(2016, 8, 15, 2, 26, 52, 224598)} 2016-08-15 02:27:48+0000 [planningalerts] INFO: Spider closed (finished)

Data

Downloaded 3 times by MikeRalphson otherchirps

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (25 KB) Use the API

rows 10 / 61

date_received description date_scraped external_reference comment_url info_url address council_reference
2015-06-03
CP-Display Facilities (>500m2)
2015-06-17
8/7/3104
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206392/2015
196-202 Spence Street BUNGALOW QLD 4870
6392/2015
2015-06-11
Material Change of Use (Code) House Extension (Shed)
2015-06-17
8/7/3290 SEDA
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206402/2015
13-15 Peakviews Close REDLYNCH QLD 4870
6402/2015
2015-06-04
Material Change of Use (Impact) Educational Establishment
2015-06-17
8/8/1392 SEDA
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206393/2015
55-65 Poolwood Road KEWARRA BEACH QLD 4879
6393/2015
2015-06-02
Preliminary Approval for Building WOrk (Code) Extn to House
2015-06-17
8/7/3283
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206390/2015
7 Rhapis Court WHITFIELD QLD 4870
6390/2015
2015-06-11
Operational Work Operational Works Earthworks/Roadworks/Signage Vico St Gordonvale
2015-06-17
8/10/341
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206396/2015
Vico Street GORDONVALE QLD 4865
6396/2015
2015-06-12
Operational Work Operational Works Mountainview Estate Stage 11 Bulk Earthworks
2015-06-17
8/10/344 SEDA
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206401/2015
900L Petersen Road EDMONTON QLD 4869
6401/2015
2015-06-10
Material Change of Use (Code) Business Facilities and Caretaker's Residence
2015-06-17
8/7/3288
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206397/2015
94 Scott Street BUNGALOW QLD 4870
6397/2015
2015-06-10
Reconfiguring a Lot and Material Change or Use Reconfiguring a Lot, -Dual Occupancy and Business Facilities
2015-06-17
8/30/198 SEDA
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206399/2015
315 Pease Street EDGE HILL QLD 4870
6399/2015
2015-06-04
CP-Multi-Unit Housing (3 - 5 Units)
2015-06-17
8/7/3284
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206394/2015
586 Mulgrave Road WOREE QLD 4868586 Mulgrave Road EARLVILLE QLD 4870
6394/2015
2015-06-02
CP-Indoor Sport & Entertainment
2015-06-17
8/7/3282 SEDA
mailto:townplanner@cairns.qld.gov.au?subject=Development%20Application%20Enquiry%3A%206389/2015
318-324 Mulgrave Road WESTCOURT QLD 4870
6389/2015

Statistics

Average successful run time: 2 minutes

Total run time: 12 minutes

Total cpu time used: half a minute

Total disk space used: 57.4 KB

History

  • Manually ran revision 1db3f193 and completed successfully .
    32 records added in the database
  • Manually ran revision 1db3f193 and failed .
    nothing changed in the database
  • Manually ran revision 1db3f193 and completed successfully .
    3 records added in the database
    31 pages scraped
  • Manually ran revision 1db3f193 and completed successfully .
    nothing changed in the database
    28 pages scraped
  • Manually ran revision 1db3f193 and completed successfully .
    nothing changed in the database
    28 pages scraped
  • Manually ran revision 1db3f193 and completed successfully .
    26 records added in the database
    28 pages scraped
  • Created on morph.io

Scraper code

Python

cairns / scraper.py