planningalerts-scrapers / nsw_office_of_liquor_gaming_and_racing

NSW Office of Liquor, Gaming and Racing - Liquor applications

README.md

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

Last run completed successfully .

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Setting up search Saving APP-0016795558... Saving SR0001555720... Saving SR0001561766... Saving 1-9959551572... Saving SR0001561810... Saving 1-9959209972... Saving APP-0016795752... Saving APP-0016785814... Saving SR0001561893... Saving APP-0016755212... Saving SR0001561862... Saving SR0001561830... Saving APP-0016795729... Saving SR0001559777... Saving SR0001561890... Saving APP-0016796513... Saving 1-9959209822... Saving SR0001561586... Saving SR0001561625... Saving APP-0016792880... Saving APP-0016772787... Saving APP-0016793460... Saving SR0001561508... Saving APP-0016755257... Saving APP-0016790085... Saving APP-0016790130... Saving APP-0016684192... Saving 1-9956857912... Saving SR0001561346... Saving SR0001561293... Saving APP-0016735539... Saving SR0001561230... Saving APP-0016785491... Saving 1-9957153222... Saving 1-9956858053... Saving APP-0016786256... Saving SR0001561243... Saving SR0001561261... Saving SR0001561194... Saving APP-0016781154... Saving APP-0016733565... Saving APP-0016783400... Saving APP-0016692982... Saving SR0001560767... Saving SR0001560859... Saving SR0001555815... Saving APP-0016785803... Saving SR0001560609... Saving SR0001559903... Saving APP-0016783572... Saving APP-0016783989... Saving APP-0016704074... Saving SR0001560858... Saving SR0001560860... Saving APP-0016784973... Saving APP-0016783940... Saving APP-0016736369... Saving 1-9955584973... Saving APP-0016487608... Saving APP-0016784719... Saving APP-0016785992... Saving SR0001560195... Saving SR0001560787... Saving 1-9955589399... Saving APP-0016705680... Saving SR0001560986... Saving SR0001560666... Saving APP-0016781722... Saving SR0001560621... Saving SR0001560557... Saving APP-0016774280... Saving APP-0016540867... Saving SR0001536419... Saving SR0001560071... Saving SR0001560560... Saving SR0001560442... Saving SR0001560567... Saving APP-0016778264... Saving APP-0016762704... Saving SR0001560353... Saving APP-0016780100... Saving 1-9954730611... Saving SR0001554405... Saving 1-9954297412... Saving APP-0016782119... Saving 1-9954529643... Saving SR0001560525... Saving APP-0016777206... Saving APP-0016750809... Saving APP-0016765251... Saving APP-0016776804... Saving 1-9952817385... Saving 1-9953035692... Saving APP-0016778511... Saving APP-0016766160... Saving SR0001559626... Saving SR0001559971... Saving APP-0016776522... Saving SR0001560004... Saving 1-9951817290... Saving SR0001560164... Saving APP-0016759629... Saving 1-9952193852... Saving SR0001558445... Saving 1-9952280819... Saving APP-0016542636... Saving SR0001559778... Saving SR0001557506... Saving 1-9951935100... Saving APP-0016771876... Saving 1-9951988695... Saving APP-0016773514... Saving APP-0016740126... Saving APP-0016729656... Saving 1-9951934861... Saving SR0001559595... Saving SR0001559714... Saving SR0001535774... Saving APP-0016775089... Saving SR0001559419... Saving 1-9951480868... Saving APP-0016771235... Saving 1-9949573491... Saving APP-0016770798... Saving APP-0016770446... Saving APP-0016769317... Saving APP-0016768500... Saving SR0001559039... Saving APP-0016764410... Saving APP-0016763296... Saving SR0001558996... Saving 1-9949321112... Saving SR0001557331... Saving SR0001558987... Saving APP-0016762505... Saving APP-0016764060... Saving 1-9949337409... Saving 1-9949350413... Saving 1-9949350705... Saving SR0001558957... Saving APP-0016619641... Saving SR0001559020... Saving SR0001557188... Saving 1-9949351311... Saving SR0001556077... Saving SR0001556692... Saving SR0001558658... Saving SR0001558425... Saving 1-9949321146... Saving APP-0016758438... Saving APP-0016760409... Saving SR0001557900... Saving APP-0016761692... Saving SR0001558627... Saving 1-9948340664... Saving APP-0016762853... Saving SR0001556731... Saving 1-9948388804... Saving 1-9948577861... Saving SR0001556143... Saving SR0001558787... Saving APP-0016759283... Saving SR0001557797... Saving APP-0016664894... Saving APP-0016756365... Saving 1-9946693113... Saving APP-0016749264... Saving SR0001558494... Saving 1-9947063512... Saving SR0001558509... Saving SR0001468087... Saving SR0001557528... Saving 1-9946692802... Saving 1-9947009442... Saving SR0001558416... Saving SR0001558378... Saving SR0001558407... Saving SR0001558486... Saving APP-0016757668... Saving APP-0016759280... Saving 1-9947088405... Saving SR0001557214... Saving SR0001556075... Saving SR0001558335... Saving APP-0016733198... Saving 1-9946931944... Saving SR0001558129... Saving APP-0016757836... Saving SR0001557201... Saving 1-9945539151... Saving 1-9945229022... Saving SR0001557280... Saving APP-0016753507... Saving SR0001557700... Saving APP-0016753984... Saving SR0001557984... Saving APP-0016752037... Saving APP-0016714091... Saving APP-0016737788... Saving 1-9945550562... Saving SR0001555286... Saving APP-0016673914... Saving SR0001557659... Saving APP-0016753579... Saving SR0001557794... Saving SR0001557753... Saving 1-9945247242... Saving APP-0016750378... Saving 1-9945212921... Saving 1-9945807312... Saving APP-0016752832... Saving APP-0016741127... Saving APP-0016755389... Saving SR0001557645... Saving APP-0016753949... Saving APP-0016755397... Saving APP-0016552295... Saving APP-0016594652... Saving APP-0016739697... Saving 1-9943821252... Saving 1-9944028550... Saving 1-9944028789... Saving APP-0016751946... Saving APP-0016749554... Saving APP-0016733708... Saving SR0001555205... Saving SR0001557291... Saving SR0001557296... Saving SR0001557217... Saving APP-0016751036... Saving SR0001556935... Saving SR0001556973... Saving SR0001556929... Saving APP-0016747665... Saving APP-0016747712... Saving SR0001554999... Saving APP-0016746544... Saving APP-0016655441... Saving APP-0016742811... Saving SR0001556693... Saving APP-0016743349... Saving 1-9941614242... Saving SR0001556063... Saving SR0001555929... Saving SR0001556474... Saving SR0001555535... Saving 1-9941636489... Saving APP-0016738600... Saving APP-0016729561... Saving APP-0016744063... Saving 1-9941654643... Saving 1-9942087373... Saving 1-9941654731... Saving APP-0016740441... Saving SR0001556635... Saving 1-9941801025... Saving 1-9941563321... Saving APP-0016740670... Saving APP-0016742452... Saving APP-0016735064... Saving SR0001555873... Saving SR0001541694... Saving SR0001551878... Saving SR0001556228... Saving SR0001556310... Saving SR0001556359... Saving 1-9940581100... Saving SR0001556283... Saving APP-0016629716... Saving APP-0016646452... Saving APP-0016736525... Saving SR0001556339... Saving APP-0016739264... Saving APP-0016739301... Saving APP-0016738976... Saving SR0001556204... Saving APP-0016721933... Saving SR0001556271... Saving APP-0016725962... Saving APP-0016603947... Saving SR0001548240... Saving SR0001556016... Saving SR0001556021... Saving SR0001556029... Saving SR0001556033... Saving SR0001554574... Saving SR0001556093... Saving SR0001556156... Saving APP-0016733737... Saving APP-0016728289... Saving APP-0016735408... Saving APP-0016735592... Saving SR0001554005... Saving APP-0016733623... Saving APP-0016733770... Saving APP-0016735470... Saving 1-9939113349... Saving 1-9939266429... Saving 1-9939266459... Saving SR0001555687... Saving APP-0016653239... Saving SR0001554838... Saving APP-0016730871... Saving SR0001555528... Saving SR0001555507... Saving APP-0016731052... Saving APP-0016733276... Saving APP-0016731249... Saving APP-0016730362... Saving APP-0016383454... Saving APP-0016729115... Saving SR0001554936... Saving APP-0016695726... Saving APP-0016730071... Saving APP-0016694840... Saving SR0001555624... Saving SR0001555500... Saving APP-0016730734... Saving SR0001555324... Saving APP-0016721298... Saving SR0001555119... Saving APP-0016726558... Saving SR0001552562... Saving SR0001555335... Saving 1-9936769432... Saving 1-9936769714... Saving 1-9936769934... Saving SR0001554803... Saving APP-0016710163... Saving SR0001555271... Saving SR0001553617... Saving 1-9936770244... Saving APP-0016729007... Saving 1-9936697321... Saving APP-0016710328... Saving SR0001555143... Saving APP-0016728662... Saving APP-0016706114... Saving APP-0016729323... Saving SR0001555103... Saving SR0001555190... Saving APP-0016726464... Saving 1-9936971571... Saving APP-0016706099... Saving SR0001555004... Saving APP-0016606816... Saving SR0001554974... Saving APP-0016717509... Saving APP-0016725325... Saving APP-0016723992... Saving APP-0016724034... Saving APP-0016723420... Saving APP-0016711705... Saving APP-0016724474... Saving SR0001554644... Saving SR0001554855... Saving SR0001554789... Saving APP-0016724031... Saving APP-0016696132... Saving APP-0016719751... Saving SR0001554570... Saving APP-0016721498... Saving SR0001554413... Saving APP-0016694875... Saving SR0001554688... Saving SR0001553933... Saving APP-0016698407... Saving APP-0016710859... Saving APP-0016722151... Saving 1-9934364952... Saving APP-0016719088... Saving APP-0016720284... Saving APP-0016690614... Saving APP-0016718422... Saving SR0001553530... Saving APP-0016718309... Saving SR0001551844... Saving APP-0016719876... Saving SR0001553485... Saving SR0001553482... Saving APP-0016691384... Saving SR0001554629... Saving 1-9934591355... Saving 1-9935040496... Saving SR0001554671... Saving SR0001554447... Saving 1-9933356979... Saving SR0001553894... Saving APP-0016717629... Saving APP-0016627143... Saving APP-0016714584... Saving SR0001553887... Saving APP-0016710932... Saving APP-0016691925... Saving SR0001552966... Saving 1-9933445530... Saving 1-9933151232... Saving 1-9933151272... Saving SR0001554218... Saving APP-0016699799... Saving 1-9933689052... Saving APP-0016717768... Saving APP-0016717665... Saving APP-0016718820... Saving SR0001554277... Saving APP-0016715393... Saving APP-0016717848... Saving APP-0016700281... Saving SR0001554283... Saving APP-0016718597... Saving APP-0016717802... Saving APP-0016717718... Saving 1-9933445502... Saving APP-0016713255... Saving APP-0016706260... Saving SR0001552432... Saving SR0001554033... Saving SR0001553739... Saving SR0001549683... Saving APP-0016671301... Saving SR0001548708... Saving SR0001553813... Saving APP-0016713229... Saving SR0001551438... Saving SR0001553689... Saving APP-0016671545... Saving SR0001554019... Saving SR0001552434... Saving SR0001554057... Saving 1-9931853862... Saving APP-0016713181... Saving SR0001542632... Saving SR0001551614... Saving SR0001554055... Saving SR0001553878... Saving SR0001553500... Saving APP-0016666966... Saving SR0001553216... Saving SR0001552656... Saving APP-0016711485... Saving SR0001553543... Saving SR0001553556... Saving SR0001551854... Saving SR0001553613... Saving APP-0016708307... Saving 1-9931025219... Saving APP-0016328514... Saving SR0001553306... Saving APP-0016711822... Saving SR0001553443... Saving SR0001551298... Saving APP-0016711349... Saving SR0001553548... Saving SR0001553527... Saving APP-0016710690... Saving APP-0016690873... Saving SR0001553057... Saving SR0001553725... Saving APP-0016707620... Saving SR0001553194... Saving APP-0016707455... Saving APP-0016708506... Saving 1-9929439913... Saving 1-9929734512... Saving APP-0016623455... Saving APP-0016672742... Saving 1-9930329402... Saving 1-9929219706... Saving SR0001553161... Saving APP-0016705828... Saving APP-0016695509... Saving APP-0016707335... Saving APP-0016706307... Saving SR0001551988... Saving 1-9929538692... Saving SR0001553054... Saving SR0001553322... Saving SR0001553164... Saving SR0001553308... Saving SR0001553314... Saving SR0001553321... Saving SR0001551920... Saving APP-0016707952... Saving APP-0016704707... Saving APP-0016695107... Saving 1-9929811334... Saving SR0001553253... Saving APP-0016601660... Saving 1-9929439752... Saving SR0001553257... Saving APP-0016704934... Finished - added 491 records.

Data

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

To download data sign in with GitHub

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

rows 10 / 71576

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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-640005893-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-716489405-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-820699167-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-876220035-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-910958001-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918876691-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918876708-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918741180-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918872277-Notice.pdf
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
http://www.olgr.nsw.gov.au/liquor_applications/docs/1-918713601-Notice.pdf
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.5 MB

History

  • Auto ran revision 86296e05 and completed successfully .
    491 records added, 474 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    480 records added, 474 records removed in the database
  • Auto ran revision 3a946b5f and completed successfully .
    476 records added, 473 records removed in the database
  • Auto ran revision 3a946b5f and completed successfully .
    480 records added, 462 records removed in the database
  • Auto ran revision 3a946b5f and completed successfully .
    492 records added, 470 records removed in the database
  • ...
  • Created on morph.io

Show complete history