planningalerts-scrapers / nsw_office_of_liquor_gaming_and_racing

NSW Office of Liquor, Gaming and Racing - Liquor applications


NSW Office of Liquor, Gaming and Racing

This is a scraper that runs on Morph. To get started see the documentation

It scrapes liquor and gaming application notices posted in the last 28 days from the NSW Liquor & Gaming noticeboard.

Add any issues to https://github.com/planningalerts-scrapers/issues/issues

To run the scraper

bundle exec ruby scraper.rb

Expected output

Setting up search
Saving SR0001553543...
Saving SR0001553544...
...
Saving SR0001553601...
Finished - added 59 records

Execution time under a minute

To run style and coding checks

bundle exec rubocop

To run the tests

bundle exec rspec

To check for security updates

gem install bundler-audit
bundle-audit

Contributors henare CloCkWeRX jamezpolley mlandauer benrfairless ianheggie-oaf

Last run completed successfully .

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Setting up search Saving SR0001581657... Saving SR0001579128... Saving APP-0017033865... Saving SR0001582338... Saving APP-0016996400... Saving SR0001582356... Saving SR0001582295... Saving 1-10037309352... Saving 1-10037473729... Saving SR0001582129... Saving 1-10037175423... Saving 1-10037175472... Saving SR0001567538... Saving SR0001582184... Saving SR0001581978... Saving APP-0017034492... Saving SR0001582268... Saving APP-0016992182... Saving SR0001567840... Saving APP-0017033326... Saving APP-0016900202... Saving SR0001581987... Saving SR0001578404... Saving APP-0016865489... Saving APP-0016995750... Saving SR0001581787... Saving APP-0017014380... Saving APP-0017018106... Saving SR0001581760... Saving APP-0017024493... Saving SR0001581655... Saving SR0001581650... Saving APP-0016949398... Saving SR0001581031... Saving APP-0017026039... Saving APP-0017000626... Saving SR0001575875... Saving SR0001581656... Saving SR0001578912... Saving SR0001581484... Saving APP-0017011545... Saving SR0001581528... Saving APP-0017021582... Saving 1-10033823533... Saving APP-0017021344... Saving SR0001581465... Saving SR0001581441... Saving 1-10033823498... Saving APP-0017021881... Saving SR0001580795... Saving 1-10033823669... Saving 1-10034051864... Saving 1-10034051889... Saving SR0001581297... Saving APP-0016999518... Saving 1-10033504393... Saving SR0001581292... Saving 1-10033759991... Saving APP-0017014882... Saving SR0001581331... Saving 1-10034052052... Saving APP-0017021278... Saving 1-10034052012... Saving 1-10033483987... Saving SR0001580325... Saving APP-0017016452... Saving SR0001580594... Saving 1-10025326082... Saving APP-0016955463... Saving 1-10032087332... Saving SR0001581115... Saving SR0001581016... Saving SR0001580759... Saving SR0001581113... Saving 1-10032108187... Saving SR0001581124... Saving APP-0017008936... Saving SR0001580838... Saving APP-0017012726... Saving APP-0016968359... Saving APP-0017017632... Saving APP-0017016947... Saving SR0001578981... Saving SR0001578894... Saving 1-10031162122... Saving 1-10031162243... Saving 1-10030679596... Saving 1-10031034706... Saving SR0001580684... Saving SR0001580177... Saving SR0001580449... Saving SR0001579351... Saving 1-10031034906... Saving SR0001579651... Saving SR0001580632... Saving APP-0017016023... Saving SR0001580724... Saving APP-0016947533... Saving 1-10030652411... Saving APP-0017015774... Saving APP-0017009705... Saving APP-0017011095... Saving APP-0016934959... Saving SR0001580255... Saving 1-10029782874... Saving SR0001580145... Saving SR0001580313... Saving SR0001580122... Saving SR0001580099... Saving APP-0017010340... Saving 1-10029168691... Saving SR0001580261... Saving SR0001572298... Saving SR0001498205... Saving SR0001580310... Saving SR0001551422... Saving SR0001551420... Saving SR0001564974... Saving SR0001580270... Saving SR0001577075... Saving SR0001580076... Saving APP-0015952254... Saving APP-0017008551... Saving SR0001578328... Saving 1-10028720431... Saving APP-0017008447... Saving SR0001579953... Saving SR0001579294... Saving APP-0016889482... Saving APP-0017006272... Saving SR0001579824... Saving SR0001579823... Saving SR0001579812... Saving 1-10027011346... Saving SR0001578067... Saving SR0001575341... Saving SR0001577196... Saving SR0001579528... Saving 1-10026829850... Saving APP-0016995453... Saving APP-0016993604... Saving SR0001579507... Saving SR0001579297... Saving SR0001579488... Saving 1-10026829934... Saving SR0001579561... Saving APP-0016972270... Saving SR0001579695... Saving APP-0016948624... Saving APP-0017003277... Saving 1-10022553881... Saving SR0001579477... Saving 1-10025326209... Saving SR0001576336... Saving APP-0016978279... Saving 1-10025326002... Saving SR0001579287... Saving SR0001574874... Saving APP-0016987165... Saving SR0001579201... Saving SR0001578514... Saving SR0001579010... Saving SR0001579275... Saving SR0001579239... Saving APP-0016999203... Saving APP-0016996720... Saving APP-0016997461... Saving SR0001579229... Saving SR0001578849... Saving 1-10023999379... Saving 1-10024244836... Saving APP-0016995298... Saving SR0001578927... Saving SR0001578991... Saving SR0001578928... Saving APP-0016995536... Saving APP-0016995654... Saving APP-0016877591... Saving APP-0016993761... Saving SR0001577530... Saving APP-0016949135... Saving SR0001578958... Saving APP-0016994029... Saving SR0001577263... Saving APP-0016957317... Saving SR0001578918... Saving SR0001578898... Saving 1-10023964944... Saving SR0001579117... Saving APP-0016974366... Saving APP-0016990096... Saving 1-10022542402... Saving SR0001578697... Saving SR0001578553... Saving SR0001578537... Saving APP-0016989852... Saving SR0001578432... Saving 1-10022475241... Saving APP-0016971518... Saving SR0001578439... Saving APP-0016990739... Saving 1-10022533042... Saving 1-10023109892... Saving SR0001574526... Saving SR0001578277... Saving APP-0016976790... Saving 1-10022782601... Saving 1-10022737573... Saving 1-10022744382... Saving SR0001577226... Saving SR0001577896... Saving 1-10021412044... Saving APP-0016952183... Saving 1-10021542915... Saving 1-10021681057... Saving APP-0016986877... Saving 1-10021680711... Saving SR0001578174... Saving SR0001577799... Saving SR0001577883... Saving SR0001568762... Saving SR0001578016... Saving SR0001578030... Saving 1-10021542604... Saving APP-0016987238... Saving 1-10021543389... Saving APP-0016986709... Saving SR0001578063... Saving SR0001578084... Saving 1-10021124014... Saving APP-0016981387... Saving SR0001578180... Saving SR0001578021... Saving SR0001578323... Saving 1-10021123953... Saving SR0001578165... Saving SR0001577816... Saving SR0001577866... Saving APP-0016982751... Saving APP-0016985109... Saving SR0001577684... Saving SR0001577673... Saving SR0001577719... Saving APP-0016980464... Saving APP-0016979307... Saving APP-0016977018... Saving APP-0016978605... Saving SR0001577540... Saving APP-0016980270... Saving SR0001577358... Saving APP-0016978218... Saving SR0001575823... Saving 1-10018910673... Saving APP-0016979924... Saving 1-10019549402... Saving SR0001545095... Saving SR0001577446... Saving SR0001575976... Saving SR0001575990... Saving SR0001575988... Saving APP-0016976448... Saving APP-0016971981... Saving SR0001575340... Saving APP-0016926951... Saving SR0001575627... Saving SR0001576990... Saving 1-10017742043... Saving SR0001549250... Saving SR0001577050... Saving APP-0016974247... Saving SR0001575765... Saving SR0001577007... Saving SR0001575854... Saving SR0001575820... Saving SR0001575808... Saving SR0001576955... Saving SR0001576902... Saving SR0001577034... Saving SR0001571303... Saving SR0001575857... Saving SR0001563071... Saving SR0001576973... Saving 1-10017947202... Saving APP-0016959795... Saving APP-0016955089... Saving 1-10017757222... Saving APP-0016888523... Saving APP-0016834681... Saving SR0001576720... Saving 1-10018057841... Saving SR0001575816... Saving SR0001577101... Saving SR0001571184... Saving 1-10017470402... Saving SR0001576627... Saving SR0001575973... Saving SR0001575968... Saving SR0001576817... Saving SR0001575969... Saving 1-10013512411... Saving 1-10016222621... Saving SR0001576004... Saving APP-0016972541... Saving SR0001575901... Saving APP-0016972772... Saving SR0001575980... Saving SR0001575922... Saving SR0001575909... Saving SR0001576137... Saving SR0001576114... Saving SR0001575918... Saving SR0001575904... Saving SR0001575908... Saving SR0001576337... Saving SR0001576577... Saving SR0001575981... Saving SR0001575984... Saving SR0001575978... Saving SR0001574146... Saving 1-10015858640... Saving SR0001575989... Saving SR0001575992... Saving SR0001576481... Saving SR0001576549... Saving SR0001575985... Saving SR0001575987... Saving SR0001575972... Saving SR0001575902... Saving SR0001575903... Saving SR0001575958... Saving SR0001575957... Saving SR0001575944... Saving SR0001576502... Saving APP-0016968882... Saving SR0001576006... Saving SR0001576001... Saving SR0001576003... Saving APP-0016969629... Saving 1-10015858571... Saving 1-10015140952... Saving 1-10014816264... Saving APP-0016820606... Saving 1-10015116978... Saving 1-10014816242... Saving APP-0016964725... Saving 1-10015141164... Saving 1-10015012527... Saving SR0001576210... Saving SR0001576324... Saving SR0001576093... Saving APP-0016894761... Saving APP-0016945708... Saving 1-10014823382... Saving SR0001574265... Saving APP-0016969143... Saving APP-0016715428... Saving SR0001574436... Saving SR0001575841... Saving APP-0016954444... Saving APP-0016964409... Saving 1-10013698803... Saving SR0001575953... Saving SR0001572978... Saving APP-0016759198... Saving APP-0016962719... Saving SR0001575776... Saving APP-0016877578... Saving SR0001575700... Saving APP-0016945684... Saving SR0001568367... Saving SR0001575878... Saving SR0001575744... Saving 1-10013533270... Saving SR0001575819... Saving APP-0016952236... Saving SR0001575647... Saving APP-0016960736... Saving SR0001575673... Saving APP-0016962199... Saving APP-0016960564... Saving APP-0016946213... Saving APP-0016929210... Saving SR0001565425... Saving SR0001572220... Saving APP-0016948969... Saving APP-0016949163... Saving APP-0016956811... Saving SR0001575291... Saving APP-0016957196... Saving SR0001575313... Saving APP-0016891440... Saving SR0001574276... Saving SR0001574274... Saving APP-0016862539... Saving APP-0016943409... Saving 1-10009892223... Saving SR0001575045... Saving APP-0016951956... Saving 1-10009892347... Saving SR0001575144... Saving SR0001574916... Saving APP-0016952587... Saving 1-10010184661... Saving APP-0016949067... Saving 1-10009979834... Saving APP-0016951938... Saving APP-0016928766... Saving SR0001574072... Saving APP-0016952569... Saving APP-0016941140... Saving APP-0016953164... Saving 1-10010258762... Saving 1-10010258885... Saving 1-10009654895... Saving SR0001575030... Saving APP-0016895705... Saving SR0001574577... Saving APP-0016948206... Saving SR0001537244... Saving APP-0016948813... Saving APP-0016936848... Saving SR0001570692... Saving SR0001574404... Saving APP-0016950170... Saving APP-0016865494... Saving APP-0016945837... Saving SR0001574612... Saving SR0001574611... Saving SR0001574735... Saving 1-10008295791... Saving SR0001574600... Saving APP-0016947764... Saving APP-0016949175... Saving APP-0016949911... Saving SR0001574629... Saving SR0001574592... Saving SR0001573971... Saving 1-10007113216... Saving SR0001569045... Saving SR0001573347... Saving SR0001574255... Saving APP-0016933605... Saving 1-10007234304... Saving 1-10006841332... Saving SR0001574358... Saving APP-0016920258... Saving SR0001574205... Saving SR0001568963... Saving APP-0016942485... Saving APP-0016943572... Saving APP-0016944398... Saving APP-0016946076... Saving 1-10006853282... Saving SR0001554129... Saving APP-0016944528... Saving APP-0016941799... Saving SR0001574391... Saving 1-10007429636... Saving APP-0016943021... Saving SR0001574043... Saving SR0001573977... Saving SR0001574123... Saving 1-10005483352... Saving APP-0016935066... Saving SR0001574038... Saving 1-10005750902... Saving 1-10005800272... Saving APP-0016924371... Saving SR0001573936... Saving APP-0016940723... Saving APP-0016928720... Saving SR0001573946... Saving SR0001526331... Saving SR0001564356... Saving APP-0016933759... Saving SR0001566563... Saving SR0001573912... Finished - added 477 records.

Data

Downloaded 48892 times by slav123 dcalde openaustralia AthleticoPrawn mlandauer jesse-a-reilly LoveMyData tkrikke JamesNWeb equivalentideas TheZepto horecaOZ repose-lecture 538digital wee3434 sufiyanirfan3 planometric-vic Nigel78 Joel-Tan_valocity Jedwards157 DevAppProject nadavalon2

To download data sign in with GitHub

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

rows 10 / 72722

date_scraped description info_url date_received council_reference address on_notice_to comment_url latitude longitude
2011-05-24
Porters Liquor Woronora Heights - Packaged liquor licence
2010-07-30
1-640005893
Shop 4/69 Warrangarree Drive, Woronora Heights 2233
2010-08-29
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-640005893
2011-05-24
The Castle Hill Tavern - Liquor licence transfer
2010-08-24
1-716489405
25 Victoria Avenue , Castle Hill 2154
2010-09-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-716489405
2011-05-24
Aubergine Restaurant - On-premises licence
2010-10-14
1-820699167
15 The Strand, Dee Why 2099
2010-11-13
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-820699167
2011-05-24
BWS - Beer Wine Spirits - Liquor licence transfer
2010-12-09
1-876220035
1 Beinda Street, Bomaderry 2541
2011-01-08
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-876220035
2011-05-24
Bartarmon - On-premises licence
2011-01-12
1-910958001
100 Hampden Road, Artarmon 2064
2011-02-11
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-910958001
2011-05-24
Imperial Hotel - Minors area authorisation
2011-01-24
1-918876691
183 John Street, Singleton 2330
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918876691
2011-05-24
Hunter River Hotel - Minors area authorisation
2011-01-24
1-918876708
110 Melbourne Street, East Maitland 2323
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918876708
2011-05-24
Sarah French Boutique Catering and Events - On-premises licence
2011-01-24
1-918741180
7 Gleeson Avenue, Sydenham 2044
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918741180
2011-05-24
Vaby's Mediteranean Grill Erina - Liquor licence transfer
2011-01-24
1-918872277
Shop R0809, Erina Shopping Centre Terrigal Drive, Erina 2250
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918872277
2011-05-24
St John's College Student's Club - Liquor licence transfer
2011-01-24
1-918713601
8a, Missenden Road, Camperdown 2050
2011-02-23
mailto:liquorapplications@olgr.nsw.gov.au?subject=Application%20Number:%201-918713601

Statistics

Average successful run time: 6 minutes

Total run time: 28 days

Total cpu time used: about 2 hours

Total disk space used: 32.9 MB

History

  • Auto ran revision ce48161c and completed successfully .
    477 records added, 472 records removed in the database
  • Auto ran revision ce48161c and completed successfully .
    472 records added, 454 records removed in the database
  • Auto ran revision ce48161c and completed successfully .
    459 records added, 455 records removed in the database
  • Auto ran revision 3fe940e3 and completed successfully .
    457 records added, 455 records removed in the database
  • Auto ran revision 3fe940e3 and completed successfully .
    474 records added, 465 records removed in the database
  • ...
  • Created on morph.io

Show complete history