ianheggie-oaf / 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 mlandauer CloCkWeRX henare benrfairless jamezpolley

Last run completed successfully .

Console output of last run

Injecting configuration and compiling... [1G [1G-----> Ruby app detected [1G-----> Installing bundler 2.3.10 [1G-----> Removing BUNDLED WITH version in the Gemfile.lock [1G-----> Compiling Ruby [1G-----> Using Ruby version: ruby-3.2.2 [1G-----> Installing dependencies using bundler 2.3.10 [1G Running: BUNDLE_WITHOUT='development:test' BUNDLE_PATH=vendor/bundle BUNDLE_BIN=vendor/bundle/bin BUNDLE_DEPLOYMENT=1 bundle install -j4 [1G Fetching gem metadata from https://rubygems.org/......... [1G Fetching https://github.com/openaustralia/scraperwiki-ruby.git [1G Using bundler 2.4.10 [1G Fetching bigdecimal 4.1.2 [1G Fetching csv 3.3.6 [1G Fetching mini_mime 1.1.5 [1G Fetching mutex_m 0.3.0 [1G Installing mutex_m 0.3.0 [1G Installing mini_mime 1.1.5 [1G Installing csv 3.3.6 [1G Installing bigdecimal 4.1.2 with native extensions [1G Fetching sqlite3 2.2.0 (x86_64-linux-gnu) [1G Fetching httpclient 2.9.0 [1G Installing httpclient 2.9.0 [1G Installing sqlite3 2.2.0 (x86_64-linux-gnu) [1G Fetching sqlite_magic 0.0.6 [1G Installing sqlite_magic 0.0.6 [1G Using scraperwiki 3.0.1 from https://github.com/openaustralia/scraperwiki-ruby.git (at morph_defaults@fc50176) [1G Fetching multi_xml 0.9.1 [1G Installing multi_xml 0.9.1 [1G Fetching httparty 0.24.2 [1G Installing httparty 0.24.2 [1G Bundle complete! 11 Gemfile dependencies, 11 gems now installed. [1G Gems in the groups 'development' and 'test' were not installed. [1G Bundled gems are installed into `./vendor/bundle` [1G Post-install message from httparty: [1G When you HTTParty, you must party hard! [1G Bundle completed (9.93s) [1G Cleaning up the bundler cache. [1G Removing bundler (2.3.10) [1G-----> Detecting rake tasks [1G [1G [1G [1G-----> Discovering process types [1G Procfile declares types -> scraper Injecting scraper and running... Setting up search Saving 1-9934364952... Saving APP-0016710859... Saving APP-0016698407... Saving SR0001553933... Saving APP-0016691384... Saving APP-0016719876... Saving APP-0016696132... Saving SR0001554570... Saving APP-0016719751... Saving APP-0016690614... Saving APP-0016718309... Saving SR0001553485... Saving SR0001553482... Saving SR0001553530... Saving APP-0016719088... Saving SR0001553887... Saving SR0001554283... Saving APP-0016714584... Saving APP-0016717629... Saving SR0001553894... Saving APP-0016717848... Saving APP-0016700281... Saving SR0001554447... Saving 1-9933356979... Saving APP-0016717768... Saving APP-0016717665... Saving APP-0016718820... Saving SR0001554277... Saving APP-0016715393... Saving APP-0016717802... Saving APP-0016627143... Saving APP-0016718597... Saving 1-9933445502... Saving APP-0016691925... Saving 1-9933689052... Saving SR0001552966... Saving APP-0016717718... Saving 1-9933445530... Saving APP-0016710932... Saving 1-9933151232... Saving APP-0016699799... Saving SR0001554218... Saving 1-9933151272... Saving SR0001551438... Saving APP-0016713229... Saving SR0001553878... Saving SR0001553689... Saving SR0001554057... Saving SR0001552434... Saving SR0001554019... Saving APP-0016713255... Saving SR0001552432... Saving SR0001554033... Saving APP-0016671545... Saving APP-0016671301... Saving SR0001549683... Saving SR0001548708... Saving SR0001554055... Saving SR0001553813... Saving SR0001553739... Saving APP-0016713181... Saving APP-0016706260... Saving SR0001551614... Saving SR0001542632... Saving 1-9931853862... Saving SR0001551854... Saving SR0001553613... Saving SR0001553543... Saving SR0001553548... Saving SR0001553556... Saving SR0001553500... Saving APP-0016666966... Saving SR0001552656... Saving APP-0016711485... Saving SR0001553216... Saving APP-0016710690... Saving APP-0016711822... Saving SR0001553057... Saving APP-0016690873... Saving SR0001553725... Saving APP-0016707620... Saving APP-0016711349... Saving SR0001553194... Saving APP-0016708506... Saving APP-0016707455... Saving APP-0016708307... Saving SR0001553306... Saving APP-0016328514... Saving SR0001553527... Saving SR0001553443... Saving SR0001551298... Saving 1-9931025219... Saving 1-9929538692... Saving 1-9929439752... Saving APP-0016707952... Saving APP-0016706307... Saving SR0001551988... Saving 1-9929439913... Saving APP-0016707335... Saving 1-9929734512... Saving APP-0016623455... Saving APP-0016672742... Saving 1-9930329402... Saving APP-0016695509... Saving SR0001553257... Saving 1-9929219706... Saving APP-0016704934... Saving SR0001553161... Saving SR0001553253... Saving 1-9929811334... Saving APP-0016705828... Saving SR0001553164... Saving SR0001553308... Saving SR0001553314... Saving SR0001553321... Saving APP-0016695107... Saving APP-0016601660... Saving SR0001553322... Saving SR0001553054... Saving SR0001551920... Saving APP-0016704707... Saving SR0001378917... Saving APP-0016704010... Saving APP-0016703385... Saving SR0001552900... Saving SR0001552876... Saving APP-0016598786... Saving APP-0016701265... Saving APP-0016682242... Saving APP-0016698414... Saving APP-0016677997... Saving SR0001552603... Saving APP-0016695186... Saving APP-0016698224... Saving SR0001552602... Saving SR0001552324... Saving SR0001552217... Saving SR0001552407... Saving APP-0016696569... Saving APP-0016695043... Saving APP-0016694899... Saving APP-0016695622... Saving APP-0016687296... Saving APP-0016586793... Saving 1-9925829090... Saving 1-9926050213... Saving 1-9926464674... Saving APP-0016651726... Saving APP-0016642214... Saving APP-0016687763... Saving SR0001547807... Saving APP-0016683552... Saving SR0001552066... Saving 1-9925828942... Saving SR0001541909... Saving SR0001552202... Saving 1-9925797142... Saving SR0001552337... Saving SR0001552352... Saving APP-0016670957... Saving 1-9926050162... Saving APP-0016686948... Saving SR0001551457... Saving SR0001540079... Saving SR0001550828... Saving SR0001551992... Saving APP-0016690043... Saving SR0001547007... Saving SR0001551432... Saving APP-0016672199... Saving APP-0016692446... Saving SR0001551851... Saving APP-0016675090... Saving APP-0016663775... Saving SR0001551946... Saving APP-0016634766... Saving APP-0016692658... Saving APP-0016666262... Saving SR0001551741... Saving APP-0016643158... Saving APP-0016651798... Saving APP-0016686526... Saving SR0001551658... Saving APP-0016684052... Saving APP-0016424981... Saving SR0001550650... Saving SR0001551526... Saving SR0001548153... Saving SR0001549551... Saving APP-0016346886... Saving SR0001548601... Saving APP-0016686367... Saving SR0001551243... Saving SR0001550220... Saving APP-0016597178... Saving APP-0016553763... Saving APP-0016688507... Saving APP-0016683754... Saving APP-0016654135... Saving APP-0016683628... Saving SR0001551221... Saving SR0001550216... Saving SR0001551046... Saving APP-0016684109... Saving APP-0016635595... Saving APP-0016685150... Saving 1-9922056152... Saving SR0001551081... Saving 1-9922037592... Saving 1-9922037729... Saving APP-0016683219... Saving APP-0016674218... Saving APP-0016685047... Saving APP-0016678403... Saving SR0001551010... Saving SR0001551051... Saving 1-9922465901... Saving SR0001550082... Saving APP-0016681715... Saving APP-0016682633... Saving APP-0016681899... Saving APP-0016652626... Saving SR0001550779... Saving SR0001550787... Saving APP-0016680251... Saving SR0001550064... Saving SR0001550554... Saving SR0001550565... Saving APP-0016665129... Saving SR0001550682... Saving APP-0016674204... Saving APP-0016677099... Saving APP-0016677157... Saving SR0001550597... Saving APP-0016677297... Saving SR0001550510... Saving APP-0016367622... Saving APP-0016678324... Saving APP-0016677354... Saving APP-0016676585... Saving SR0001550588... Saving APP-0016676516... Saving SR0001550680... Saving APP-0016677721... Saving APP-0016675594... Saving APP-0016672245... Saving SR0001549481... Saving SR0001548303... Saving APP-0016581122... Saving 1-9919223452... Saving SR0001550283... Saving APP-0016648456... Saving SR0001550201... Saving APP-0016650484... Saving SR0001550235... Saving SR0001550413... Saving SR0001550424... Saving APP-0016666576... Saving SR0001550194... Saving APP-0016673735... Saving SR0001550205... Saving SR0001550170... Saving SR0001550420... Saving APP-0016664996... Saving APP-0016084732... Saving 1-9919232642... Saving SR0001550383... Saving SR0001550277... Saving SR0001550111... Saving APP-0016671136... Saving SR0001545697... Saving APP-0016671917... Saving APP-0016671205... Saving APP-0016668917... Saving SR0001549680... Saving APP-0016669559... Saving APP-0016670647... Saving APP-0016672007... Saving SR0001550125... Saving SR0001549225... Saving SR0001549059... Saving SR0001549888... Saving SR0001549723... Saving APP-0016648729... Saving SR0001549823... Saving APP-0016668990... Saving APP-0016491670... Saving SR0001549997... Saving APP-0016659799... Saving SR0001549484... Saving SR0001540540... Saving APP-0016665851... Saving 1-9916390982... Saving APP-0016667172... Saving APP-0016576006... Saving SR0001549654... Saving SR0001537938... Saving APP-0016667681... Saving APP-0016668665... Saving SR0001540259... Saving SR0001549081... Saving APP-0016552100... Saving SR0001549018... Saving SR0001549142... Saving 1-9885795382... Saving SR0001542267... Saving APP-0016662417... Saving APP-0016665035... Saving 1-9915681584... Saving APP-0016664042... Saving 1-9915022691... Saving APP-0016626348... Saving SR0001549052... Saving APP-0016663915... Saving SR0001549201... Saving APP-0016661164... Saving SR0001548856... Saving APP-0016660568... Saving APP-0016661031... Saving SR0001548873... Saving SR0001548101... Saving APP-0016656996... Saving APP-0016655875... Saving APP-0016634569... Saving APP-0016655933... Saving SR0001543899... Saving SR0001548665... Saving SR0001548056... Saving APP-0016655506... Saving APP-0016655162... Saving APP-0016587382... Saving SR0001541576... Saving SR0001542392... Saving SR0001548550... Saving SR0001547028... Saving SR0001548547... Saving APP-0016630919... Saving SR0001548525... Saving SR0001547548... Saving SR0001548431... Saving APP-0016576417... Saving APP-0016639869... Saving SR0001548326... Saving APP-0016506220... Saving 1-9912168852... Saving APP-0016650465... Saving 1-9912441915... Saving SR0001548261... Saving 1-9912441869... Saving SR0001548089... Saving 1-9912168696... Saving APP-0016564179... Saving SR0001547861... Saving APP-0016059038... Saving SR0001548210... Saving SR0001541966... Saving 1-9912441751... Saving 1-9912009208... Saving SR0001541274... Saving SR0001541275... Saving APP-0016651466... Saving SR0001545455... Saving SR0001545453... Saving APP-0016652504... Saving APP-0016558970... Saving SR0001548138... Saving APP-0016647752... Saving APP-0016648082... Saving 1-9910518762... Saving APP-0016649598... Saving 1-9909277332... Saving APP-0016650841... Saving 1-9910531934... Saving APP-0016648167... Saving SR0001547695... Saving APP-0016646435... Saving APP-0016649948... Saving SR0001547702... Saving 1-9910573069... Saving SR0001547993... Saving APP-0016649326... Saving SR0001547612... Saving SR0001547929... Saving APP-0016646045... Saving APP-0016648339... Saving SR0001547644... Saving APP-0016644493... Saving SR0001541010... Saving 1-9908028575... Saving APP-0016631866... Saving SR0001547284... Saving APP-0016544966... Saving APP-0016620531... Saving SR0001547549... Saving SR0001547275... Saving APP-0016556742... Saving APP-0016378595... Saving APP-0016638034... Saving APP-0016647261... Saving APP-0016628533... Saving SR0001547129... Saving SR0001547499... Saving APP-0016647009... Saving APP-0016646441... Saving APP-0016646916... Saving APP-0016642880... Saving APP-0016646411... Saving SR0001547555... Saving APP-0016622688... Saving 1-9909502694... Saving SR0001546990... Saving SR0001546960... Saving SR0001546672... Saving 1-9908052723... Saving APP-0016642928... Saving APP-0016642511... Saving SR0001546953... Saving APP-0016059770... Saving SR0001547011... Saving SR0001546965... Saving 1-9908267994... Saving 1-9908449642... Saving SR0001547053... Saving APP-0016643169... Saving APP-0016640758... Saving APP-0016640899... Saving APP-0016639903... Saving APP-0016640270... Saving APP-0016639844... Saving APP-0016639652... Saving APP-0016639698... Saving APP-0016620320... Saving APP-0016637589... Saving SR0001546686... Saving APP-0016637854... Saving APP-0016497219... Saving SR0001546570... Saving 1-9905893411... Saving SR0001544440... Saving SR0001540556... Saving SR0001546448... Saving APP-0016575495... Saving SR0001546410... Saving SR0001546580... Saving APP-0016620049... Saving SR0001546554... Saving SR0001546026... Saving SR0001546456... Saving SR0001545847... Saving APP-0016603477... Saving APP-0016611643... Saving SR0001540833... Saving APP-0016635588... Finished - added 453 records.

Data

Downloaded 157 times by ianheggie-oaf

To download data sign in with GitHub

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

rows 10 / 453

council_reference address description info_url date_scraped date_received on_notice_to latitude longitude
1-9934364952
59-63 Richmond Rd, BLACKTOWN NSW 2148
Vary extended trading authorisation - hotel
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/1-9934364952
2026-08-14
2026-08-14
2026-09-13
-33.764156
150.90279
APP-0016710859
GEOCENTRE, 160 CRYSTAL ST, BROKEN HILL NSW 2880
New licence - limited - special event
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/APP-0016710859
2026-08-14
2026-08-14
2026-08-28
-31.961124
141.46259
APP-0016698407
SHOP 10 8 FLETCHER ST, BYRON BAY NSW 2481
New licence - on premises - restaurant
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/APP-0016698407
2026-08-14
2026-08-14
2026-08-28
-28.642033
153.61403
SR0001553933
191 Argyle St, CAMDEN NSW 2570
Liquor licence transfer - with licensee consent - hotel
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/SR0001553933
2026-08-14
2026-08-14
2026-09-13
-34.054848
150.69345
APP-0016691384
HAWKESBURY SHOWGROUND, 40 RACECOURSE RD, CLARENDON NSW 2756
New licence - limited - single function
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/APP-0016691384
2026-08-14
2026-08-14
2026-08-28
-33.6103
150.78293
APP-0016719876
Reddall Reserve, Reddall Parade, LAKE ILLAWARRA NSW 2528
New licence - limited - special event
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/APP-0016719876
2026-08-14
2026-08-14
2026-08-28
-34.538982
150.86038
APP-0016696132
10 JOHN ST, LIDCOMBE NSW 2141
New licence - packaged liquor - bottle shop
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/APP-0016696132
2026-08-14
2026-08-14
2026-09-13
-33.86258
151.04431
SR0001554570
88 MAGELLAN ST, LISMORE NSW 2480
Change of premises boundaries - small bar
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/SR0001554570
2026-08-14
2026-08-14
2026-09-13
-28.809435
153.27765
APP-0016719751
SHOWGROUND, 116 ALEXANDRA PDE, NORTH LISMORE NSW 2480
New licence - limited - single function
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/APP-0016719751
2026-08-14
2026-08-14
2026-08-28
-28.797445
153.2754
APP-0016690614
WILKINSON PARK RESERVE, 6368 CANBELEGO-NYMAGEE RD, NYMAGEE NSW 2831
New licence - limited - single function
https://lngnoticeboard.onegov.nsw.gov.au/searchresult/details/APP-0016690614
2026-08-14
2026-08-14
2026-08-28
-32.045055
146.31383

Statistics

Average successful run time: less than a minute

Total run time: less than a minute

Total cpu time used: less than 5 seconds

Total disk space used: 4.92 MB

History

  • Manually ran revision c63348bb and completed successfully .
    453 records added in the database
  • Created on morph.io