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 ianheggie-oaf

Last run completed successfully .

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Setting up search Saving 1-10014816242... Saving SR0001576093... Saving APP-0016945708... Saving SR0001574265... Saving 1-10015012527... Saving 1-10014816264... Saving SR0001568367... Saving SR0001575700... Saving 1-10013698803... Saving APP-0016945684... Saving APP-0016964409... Saving SR0001575841... Saving SR0001574436... Saving SR0001572978... Saving APP-0016962719... Saving APP-0016759198... Saving SR0001575953... Saving APP-0016954444... Saving SR0001575819... Saving SR0001575878... Saving APP-0016877578... Saving SR0001575776... Saving SR0001575744... Saving 1-10013533270... Saving APP-0016962199... Saving APP-0016960564... Saving SR0001575673... Saving SR0001575647... Saving APP-0016952236... Saving APP-0016960736... Saving APP-0016946213... Saving APP-0016929210... Saving SR0001572220... Saving SR0001565425... Saving SR0001575313... Saving APP-0016891440... Saving SR0001574276... Saving SR0001574274... Saving APP-0016943409... Saving APP-0016862539... Saving APP-0016948969... Saving APP-0016949163... Saving APP-0016956811... Saving APP-0016957196... Saving SR0001575291... Saving APP-0016951956... Saving SR0001574072... Saving APP-0016941140... Saving APP-0016953164... Saving SR0001575045... Saving 1-10010258762... Saving 1-10009892223... Saving APP-0016951938... Saving APP-0016949067... Saving 1-10009979834... Saving APP-0016928766... Saving 1-10009892347... Saving SR0001575144... Saving 1-10010184661... Saving APP-0016952587... Saving SR0001574916... Saving SR0001575030... Saving 1-10009654895... Saving APP-0016952569... Saving 1-10010258885... Saving APP-0016895705... Saving SR0001574600... Saving SR0001574735... Saving 1-10008295791... Saving SR0001574611... Saving SR0001574612... Saving APP-0016945837... Saving APP-0016949175... Saving SR0001574629... Saving SR0001574592... Saving APP-0016949911... Saving SR0001573971... Saving SR0001537244... Saving APP-0016936848... Saving SR0001574577... Saving APP-0016948206... Saving APP-0016947764... Saving APP-0016865494... Saving APP-0016948813... Saving SR0001570692... Saving SR0001574404... Saving APP-0016950170... Saving APP-0016943572... Saving APP-0016944398... Saving SR0001569045... Saving APP-0016944528... Saving SR0001554129... Saving 1-10006853282... Saving APP-0016941799... Saving 1-10007113216... Saving SR0001573347... Saving SR0001574205... Saving SR0001568963... Saving APP-0016942485... Saving APP-0016920258... Saving SR0001574255... Saving 1-10006841332... Saving APP-0016933605... Saving 1-10007234304... Saving SR0001574358... Saving APP-0016946076... Saving 1-10007429636... Saving SR0001574391... Saving APP-0016943021... Saving 1-10005750902... Saving 1-10005800272... Saving APP-0016924371... Saving SR0001573936... Saving SR0001574038... Saving APP-0016935066... Saving SR0001566563... Saving SR0001573912... Saving APP-0016933759... Saving APP-0016928720... Saving APP-0016940723... Saving SR0001574123... Saving SR0001574043... Saving SR0001573977... Saving SR0001564356... Saving SR0001526331... Saving SR0001573946... Saving 1-10005483352... Saving 1-10004440527... Saving APP-0016939174... Saving SR0001573725... Saving SR0001573529... Saving 1-10004510831... Saving APP-0016826392... Saving SR0001573649... Saving SR0001572942... Saving SR0001573415... Saving SR0001573365... Saving 1-10003020371... Saving SR0001573337... Saving SR0001573489... Saving SR0001573492... Saving APP-0016933074... Saving APP-0016932528... Saving SR0001573314... Saving APP-0016934896... Saving APP-0016933502... Saving SR0001573498... Saving APP-0016931918... Saving APP-0016902420... Saving APP-0016871942... Saving APP-0016932762... Saving SR0001573400... Saving SR0001573322... Saving APP-0016930070... Saving SR0001573137... Saving SR0001573004... Saving APP-0016930268... Saving APP-0016930753... Saving APP-0016926034... Saving APP-0016929318... Saving SR0001571106... Saving SR0001573093... Saving 1-10001939512... Saving SR0001571091... Saving APP-0016930284... Saving SR0001572998... Saving SR0001572937... Saving APP-0016727629... Saving SR0001572370... Saving SR0001573122... Saving APP-0016930127... Saving SR0001573156... Saving SR0001571814... Saving SR0001558502... Saving SR0001571354... Saving SR0001572949... Saving APP-0016918796... Saving APP-0016899073... Saving APP-0016919965... Saving APP-0016923469... Saving SR0001572692... Saving APP-0016922000... Saving APP-0016926778... Saving APP-0016927450... Saving SR0001572117... Saving APP-0016927687... Saving 1-10000397425... Saving APP-0015476102... Saving SR0001572832... Saving APP-0016917313... Saving SR0001572555... Saving APP-0016596008... Saving APP-0016710021... Saving APP-0016926114... Saving SR0001570339... Saving APP-0016924566... Saving SR0001559629... Saving SR0001559648... Saving SR0001572727... Saving SR0001553068... Saving SR0001553073... Saving SR0001553075... Saving SR0001572630... Saving SR0001572466... Saving SR0001572515... Saving SR0001572168... Saving SR0001572240... Saving 1-9999392286... Saving SR0001572304... Saving APP-0016921677... Saving SR0001572166... Saving APP-0016868884... Saving SR0001572278... Saving 1-9999391869... Saving SR0001572413... Saving APP-0016919516... Saving 1-9999679949... Saving APP-0016924086... Saving APP-0016910030... Saving SR0001572224... Saving APP-0016921618... Saving SR0001571269... Saving SR0001571830... Saving SR0001572322... Saving SR0001571289... Saving APP-0016826051... Saving SR0001571835... Saving SR0001571798... Saving SR0001572036... Saving APP-0016919857... Saving 1-9998001422... Saving 1-9997656772... Saving 1-9997656801... Saving 1-9997656941... Saving APP-0016917432... Saving SR0001571807... Saving SR0001571844... Saving APP-0016919636... Saving SR0001572038... Saving 1-9997654830... Saving 1-9997833705... Saving APP-0016919520... Saving 1-9997657225... Saving SR0001571856... Saving APP-0016913769... Saving APP-0016910958... Saving APP-0016918834... Saving SR0001571806... Saving SR0001177183... Saving SR0001565799... Saving 1-9997657316... Saving 1-9998040416... Saving APP-0016917838... Saving 1-9998040523... Saving APP-0016914041... Saving SR0001571451... Saving APP-0016914937... Saving APP-0016913186... Saving APP-0016913341... Saving SR0001571489... Saving SR0001571381... Saving APP-0016531044... Saving APP-0016902721... Saving APP-0016815764... Saving SR0001570533... Saving SR0001571219... Saving SR0001571319... Saving SR0001571338... Saving APP-0016909953... Saving APP-0016878444... Saving SR0001571255... Saving SR0001571260... Saving 1-9995189321... Saving SR0001571227... Saving APP-0016905231... Saving SR0001571000... Saving SR0001571002... Saving APP-0016906626... Saving APP-0016877199... Saving 1-9993837405... Saving SR0001569301... Saving 1-9994039642... Saving SR0001571128... Saving SR0001571109... Saving APP-0016906276... Saving 1-9994342821... Saving SR0001534235... Saving SR0001534228... Saving APP-0016877440... Saving SR0001568626... Saving APP-0016905824... Saving SR0001570674... Saving APP-0016904656... Saving APP-0016780365... Saving SR0001570933... Saving APP-0016903806... Saving SR0001571059... Saving APP-0016903837... Saving APP-0016729657... Saving SR0001570760... Saving SR0001570098... Saving 1-9992444556... Saving APP-0016821133... Saving SR0001558275... Saving SR0001566359... Saving APP-0016900010... Saving APP-0016755604... Saving APP-0016902881... Saving SR0001570761... Saving SR0001570566... Saving 1-9992444429... Saving SR0001570627... Saving SR0001570649... Saving 1-9992793932... Saving SR0001568010... Saving SR0001570770... Saving APP-0016804355... Saving SR0001570452... Saving 1-9992444646... Saving SR0001570621... Saving 1-9992890680... Saving APP-0016899207... Saving SR0001569751... Saving SR0001570310... Saving APP-0016844493... Saving APP-0016898627... Saving 1-9991132952... Saving SR0001570289... Saving APP-0016757006... Saving 1-9991530004... Saving SR0001567014... Saving 1-9991556858... Saving 1-9991338163... Saving SR0001567414... Saving 1-9991529845... Saving 1-9991781574... Saving APP-0016896029... Saving 1-9991533710... Saving APP-0016899778... Saving 1-9991424141... Saving SR0001565251... Saving SR0001569394... Saving 1-9991533611... Saving APP-0016898834... Saving APP-0016895977... Saving APP-0016712851... Saving SR0001570016... Saving SR0001569833... Saving SR0001568247... Saving APP-0016889074... Saving APP-0016881482... Saving SR0001569581... Saving 1-9989042382... Saving 1-9988476402... Saving 1-9988840194... Saving APP-0016823538... Saving SR0001569667... Saving APP-0016836790... Saving APP-0016609776... Saving SR0001569112... Saving APP-0016882002... Saving APP-0016882862... Saving SR0001569646... Saving 1-9989108992... Saving APP-0016748249... Saving SR0001569444... Saving APP-0016881736... Saving SR0001569377... Saving SR0001569439... Saving SR0001569445... Saving 1-9987252889... Saving 1-9987252602... Saving APP-0016795584... Saving 1-9987681175... Saving SR0001568753... Saving APP-0016881640... Saving APP-0016882498... Saving 1-9987253256... Saving SR0001569402... Saving SR0001532376... Saving APP-0016882397... Saving APP-0016833384... Saving SR0001569339... Saving APP-0016879703... Saving 1-9984938499... Saving SR0001568752... Saving 1-9986599674... Saving 1-9981494994... Saving SR0001567863... Saving SR0001569074... Saving SR0001568934... Saving SR0001551954... Saving SR0001568031... Saving SR0001569012... Saving APP-0016852966... Saving SR0001565374... Saving SR0001568969... Saving SR0001569070... Saving APP-0016866546... Saving SR0001560250... Saving SR0001562689... Saving APP-0016870563... Saving SR0001568774... Saving 1-9984621892... Saving SR0001568661... Saving APP-0016857049... Saving APP-0016705780... Saving SR0001568729... Saving 1-9984684266... Saving APP-0016169145... Saving APP-0016873006... Saving APP-0016870497... Saving SR0001568471... Saving SR0001568567... Saving SR0001568672... Saving APP-0016872251... Saving APP-0016874925... Saving APP-0016874178... Saving SR0001568689... Saving APP-0016772798... Saving APP-0016871209... Saving SR0001568773... Finished - added 422 records.

Data

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

To download data sign in with GitHub

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

rows 10 / 72370

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.8 MB

History

  • Auto ran revision 8bda2ba1 and completed successfully .
    422 records added, 414 records removed in the database
  • Auto ran revision 8bda2ba1 and completed successfully .
    437 records added, 416 records removed in the database
  • Auto ran revision 8bda2ba1 and completed successfully .
    418 records added, 417 records removed in the database
  • Auto ran revision 8bda2ba1 and completed successfully .
    423 records added, 418 records removed in the database
  • Auto ran revision 8bda2ba1 and completed successfully .
    427 records added, 417 records removed in the database
  • ...
  • Created on morph.io

Show complete history