LoveMyData / cowra

Cowra Development Applications


Cowra Council scraper

  • System - myhorizon from solorient
  • Cookie tracking - Yes
  • Clearly defined data within a row - Yes
  • XML - Yes

Setup MORPH_PERIOD for data recovery, available options are

  • thisweek (default)
  • thismonth
  • lastmonth
  • year (eg: 2017, minimum is 1961)

Enjoy

Contributors LoveMyData mlandauer

Last run failed with status code 1.

Console output of last run

Injecting configuration and compiling...  -----> Ruby app detected -----> Compiling Ruby -----> Using Ruby version: ruby-2.4.1 -----> Installing dependencies using bundler 1.15.2  Running: bundle install --without development:test --path vendor/bundle --binstubs vendor/bundle/bin -j4 --deployment  Fetching gem metadata from https://rubygems.org/......  Fetching version metadata from https://rubygems.org/.  Fetching https://github.com/LoveMyData/horizon_xml.git  Fetching https://github.com/openaustralia/scraperwiki-ruby.git  Using bundler 1.15.2  Fetching unf_ext 0.0.7.4  Fetching mime-types-data 3.2016.0521  Fetching net-http-digest_auth 1.4.1  Installing net-http-digest_auth 1.4.1  Fetching net-http-persistent 2.9.4  Installing mime-types-data 3.2016.0521  Installing net-http-persistent 2.9.4  Installing unf_ext 0.0.7.4 with native extensions  Fetching mini_portile2 2.3.0  Fetching ntlm-http 0.1.1  Installing mini_portile2 2.3.0  Installing ntlm-http 0.1.1  Fetching webrobots 0.1.2  Fetching httpclient 2.8.3  Installing webrobots 0.1.2  Fetching sqlite3 1.3.13  Installing httpclient 2.8.3  Installing sqlite3 1.3.13 with native extensions  Fetching mime-types 3.1  Installing mime-types 3.1  Fetching nokogiri 1.8.1  Installing nokogiri 1.8.1 with native extensions  Fetching unf 0.1.4  Installing unf 0.1.4  Fetching domain_name 0.5.20170404  Installing domain_name 0.5.20170404  Fetching http-cookie 1.0.3  Installing http-cookie 1.0.3  Fetching sqlite_magic 0.0.6  Installing sqlite_magic 0.0.6  Using scraperwiki 3.0.1 from https://github.com/openaustralia/scraperwiki-ruby.git (at morph_defaults@fc50176)  Fetching mechanize 2.7.5  Installing mechanize 2.7.5  Using horizon_xml 1.1.1 from https://github.com/LoveMyData/horizon_xml.git (at 1.1-stable@55cf6df)  Bundle complete! 2 Gemfile dependencies, 19 gems now installed.  Gems in the groups development and test were not installed.  Bundled gems are installed into ./vendor/bundle.  Bundle completed (25.47s)  Cleaning up the bundler cache. -----> Detecting rake tasks   -----> Discovering process types  Procfile declares types -> scraper Injecting scraper and running... /app/vendor/ruby-2.4.1/lib/ruby/2.4.0/net/http.rb:906:in `rescue in block in connect': Failed to open TCP connection to myhorizon.solorient.com.au:80 (No route to host - connect(2) for "myhorizon.solorient.com.au" port 80) (Errno::EHOSTUNREACH) from /app/vendor/ruby-2.4.1/lib/ruby/2.4.0/net/http.rb:903:in `block in connect' from /app/vendor/ruby-2.4.1/lib/ruby/2.4.0/timeout.rb:93:in `block in timeout' from /app/vendor/ruby-2.4.1/lib/ruby/2.4.0/timeout.rb:103:in `timeout' from /app/vendor/ruby-2.4.1/lib/ruby/2.4.0/net/http.rb:902:in `connect' from /app/vendor/ruby-2.4.1/lib/ruby/2.4.0/net/http.rb:887:in `do_start' from /app/vendor/ruby-2.4.1/lib/ruby/2.4.0/net/http.rb:882:in `start' from /app/vendor/bundle/ruby/2.4.0/gems/net-http-persistent-2.9.4/lib/net/http/persistent.rb:700:in `start' from /app/vendor/bundle/ruby/2.4.0/gems/net-http-persistent-2.9.4/lib/net/http/persistent.rb:631:in `connection_for' from /app/vendor/bundle/ruby/2.4.0/gems/net-http-persistent-2.9.4/lib/net/http/persistent.rb:994:in `request' from /app/vendor/bundle/ruby/2.4.0/gems/mechanize-2.7.5/lib/mechanize/http/agent.rb:274:in `fetch' from /app/vendor/bundle/ruby/2.4.0/gems/mechanize-2.7.5/lib/mechanize.rb:464:in `get' from /app/vendor/bundle/ruby/2.4.0/bundler/gems/horizon_xml-55cf6df5f910/lib/horizon_xml.rb:88:in `_execute' from /app/vendor/bundle/ruby/2.4.0/bundler/gems/horizon_xml-55cf6df5f910/lib/horizon_xml.rb:139:in `getRecords' from scraper.rb:10:in `<main>'

Data

Downloaded 1563 times by LoveMyData dcalde

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (1.12 MB) Use the API

rows 10 / 3725

council_reference address description info_url comment_url date_scraped date_received
DA 2017/149.1
Elouera Road COWRA 2794 NSW
New Building Rural Garage/Shed
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-13
DA 2017/148.1
85-87 Lyall Street COWRA 2794 NSW
New Building Residential Dwelling
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-13
DA 2017/147.1
102 Redfern Street COWRA 2794 NSW
New Building Residential Pergola/Awning/Patio
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-13
DA 2017/146.1
36 Gower Hardy Circuit COWRA 2794 NSW
New Building Residential Garage/Shed
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-13
DA 2017/145.1
75 Darling Street COWRA 2794 NSW
New Building Flats (Two or more residential units)
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-12
DA 2017/144.1
18 Bank Street GOOLOOGONG 2805 NSW
New Building Rural Garage/Shed
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-12
CDC 2017/39.1
603 Grenfell Road COWRA 2794 NSW
New Building Residential Swimming Pool
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-12
DA 2017/143.1
Clements Road WOODSTOCK 2793 NSW
Dwelling
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-11
CC 2017/143.1
Clements Road WOODSTOCK 2793 NSW
New Building Rural Dwelling
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-11
CDC 2017/38.1
16 East Street WOODSTOCK 2793 NSW
New Building Residential Swimming Pool
mailto:council@cowra.nsw.gov.au
2017-10-20
2017-10-11

Statistics

Average successful run time: less than a minute

Total run time: 1 day

Total cpu time used: 26 minutes

Total disk space used: 1.15 MB

History

  • Auto ran revision 8035d699 and failed .
    nothing changed in the database
  • Auto ran revision 8035d699 and failed .
    nothing changed in the database
  • Auto ran revision 8035d699 and failed .
    nothing changed in the database
  • Auto ran revision 8035d699 and failed .
    nothing changed in the database
  • Auto ran revision 8035d699 and failed .
    nothing changed in the database
  • ...
  • Created on morph.io

Show complete history

Scraper code

Ruby

cowra / scraper.rb