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 APP-0016982751... Saving APP-0016985109... Saving SR0001577816... Saving SR0001577866... Saving SR0001577719... Saving SR0001577684... Saving SR0001577673... Saving APP-0016980464... Saving APP-0016979307... Saving 1-10018910673... Saving APP-0016979924... Saving APP-0016978605... Saving SR0001577540... Saving APP-0016977018... Saving SR0001575976... Saving SR0001575990... Saving SR0001575988... Saving APP-0016980270... Saving APP-0016978218... Saving SR0001577358... Saving SR0001575823... Saving SR0001577446... Saving SR0001545095... Saving 1-10019549402... Saving APP-0016971981... Saving SR0001575627... Saving APP-0016926951... Saving SR0001575340... Saving APP-0016976448... Saving APP-0016974247... Saving SR0001576990... Saving 1-10017742043... Saving SR0001549250... Saving SR0001577050... Saving 1-10017947202... Saving APP-0016888523... Saving APP-0016834681... Saving 1-10017757222... Saving SR0001563071... Saving SR0001576973... Saving SR0001576720... Saving SR0001577034... Saving SR0001576902... Saving SR0001571303... Saving SR0001576955... Saving SR0001575820... Saving SR0001575854... Saving SR0001575857... Saving SR0001575808... Saving SR0001575765... Saving SR0001577007... Saving SR0001575816... Saving 1-10018057841... Saving APP-0016959795... Saving APP-0016955089... Saving SR0001577101... Saving SR0001571184... Saving 1-10017470402... Saving SR0001576627... Saving SR0001575973... Saving 1-10015858640... Saving SR0001574146... Saving SR0001575984... Saving SR0001575978... Saving APP-0016972772... Saving SR0001576004... Saving APP-0016972541... Saving SR0001575980... Saving SR0001575922... Saving SR0001575901... Saving 1-10013512411... Saving SR0001575968... Saving SR0001576817... Saving SR0001575969... Saving 1-10016222621... Saving SR0001575958... Saving SR0001575902... Saving SR0001575972... Saving SR0001575903... Saving SR0001576137... Saving SR0001576114... Saving SR0001575918... Saving SR0001575909... Saving SR0001575904... Saving SR0001575908... Saving SR0001576337... Saving SR0001576481... Saving SR0001575985... Saving SR0001575987... Saving SR0001576549... Saving SR0001576577... Saving SR0001575981... Saving SR0001575989... Saving SR0001575992... Saving SR0001575944... Saving SR0001576502... Saving APP-0016968882... Saving SR0001575957... Saving SR0001576006... Saving SR0001576001... Saving SR0001576003... Saving APP-0016969629... Saving 1-10015858571... Saving APP-0016820606... Saving 1-10015140952... Saving 1-10015141164... Saving SR0001576324... Saving SR0001576093... Saving APP-0016894761... Saving 1-10014816242... Saving APP-0016964725... Saving 1-10015116978... Saving 1-10014816264... Saving APP-0016969143... Saving APP-0016715428... Saving APP-0016945708... Saving 1-10014823382... Saving SR0001574265... Saving SR0001576210... Saving 1-10015012527... Saving SR0001574436... Saving APP-0016964409... Saving SR0001575841... Saving SR0001575776... Saving APP-0016877578... Saving APP-0016954444... Saving SR0001575878... Saving SR0001575819... Saving SR0001575744... Saving 1-10013533270... Saving SR0001572978... Saving APP-0016962719... Saving APP-0016759198... Saving SR0001575953... Saving 1-10013698803... Saving APP-0016945684... Saving SR0001575700... Saving SR0001568367... Saving APP-0016952236... Saving SR0001575647... Saving SR0001575673... Saving APP-0016962199... Saving APP-0016960736... Saving APP-0016960564... Saving APP-0016946213... Saving APP-0016929210... Saving SR0001572220... Saving SR0001565425... Saving APP-0016948969... Saving APP-0016949163... Saving SR0001575313... Saving APP-0016891440... Saving APP-0016862539... Saving SR0001574276... Saving SR0001574274... Saving APP-0016943409... Saving SR0001575291... Saving APP-0016956811... Saving APP-0016957196... Saving SR0001574072... Saving SR0001575045... Saving 1-10010258762... Saving APP-0016951956... Saving 1-10009892223... Saving APP-0016949067... Saving APP-0016951938... Saving 1-10009979834... Saving APP-0016928766... Saving 1-10009892347... Saving SR0001575144... Saving SR0001574916... Saving APP-0016941140... Saving APP-0016953164... Saving APP-0016952569... Saving SR0001575030... Saving 1-10009654895... Saving 1-10010258885... Saving 1-10010184661... Saving APP-0016952587... Saving SR0001574735... Saving APP-0016895705... Saving SR0001537244... Saving SR0001574600... Saving 1-10008295791... Saving SR0001574611... Saving APP-0016945837... Saving SR0001574612... Saving APP-0016949175... Saving SR0001574629... Saving APP-0016947764... Saving APP-0016865494... Saving APP-0016948813... Saving SR0001570692... Saving SR0001574404... Saving APP-0016950170... Saving SR0001574592... Saving SR0001573971... Saving APP-0016949911... Saving SR0001574577... Saving APP-0016948206... Saving APP-0016936848... Saving SR0001554129... Saving APP-0016944528... Saving APP-0016941799... Saving 1-10007113216... Saving SR0001573347... Saving APP-0016943572... Saving APP-0016944398... Saving SR0001569045... Saving SR0001568963... Saving APP-0016942485... Saving SR0001574255... Saving SR0001574205... Saving APP-0016920258... Saving 1-10007234304... Saving APP-0016933605... Saving 1-10006853282... Saving SR0001574391... Saving 1-10007429636... Saving APP-0016946076... Saving 1-10006841332... Saving SR0001574358... Saving 1-10005750902... Saving 1-10005800272... Saving APP-0016943021... Saving SR0001574123... Saving APP-0016924371... Saving SR0001573936... Saving SR0001574038... Saving APP-0016935066... Saving SR0001566563... Saving SR0001573912... Saving SR0001564356... Saving SR0001526331... Saving SR0001573946... Saving 1-10005483352... Saving APP-0016940723... Saving APP-0016928720... Saving APP-0016933759... Saving SR0001574043... Saving SR0001573977... Saving APP-0016939174... Saving 1-10004440527... Saving SR0001573725... Saving SR0001573529... Saving 1-10004510831... Saving APP-0016826392... Saving SR0001573649... Saving APP-0016933074... Saving SR0001573365... Saving 1-10003020371... Saving SR0001573337... Saving SR0001573489... Saving APP-0016933502... Saving SR0001573400... Saving APP-0016902420... Saving APP-0016931918... Saving SR0001573492... Saving SR0001573498... Saving SR0001572942... Saving SR0001573415... Saving APP-0016871942... Saving APP-0016932762... Saving SR0001573322... Saving APP-0016932528... Saving APP-0016934896... Saving SR0001573314... Saving APP-0016930284... Saving SR0001571106... Saving SR0001573093... Saving 1-10001939512... Saving SR0001571091... Saving SR0001572998... Saving APP-0016930070... Saving SR0001573137... Saving APP-0016929318... Saving SR0001573004... Saving APP-0016926034... Saving APP-0016930268... Saving APP-0016930753... Saving SR0001572949... Saving SR0001573156... Saving SR0001571354... Saving SR0001571814... Saving SR0001558502... Saving SR0001573122... Saving SR0001572937... Saving APP-0016727629... Saving SR0001572370... Saving APP-0016930127... Saving APP-0016918796... Saving APP-0016899073... Saving APP-0016919965... Saving APP-0016926778... Saving APP-0016927450... Saving APP-0016923469... Saving SR0001572692... Saving APP-0016922000... Saving SR0001553068... Saving SR0001553073... Saving SR0001553075... Saving SR0001572727... Saving SR0001559629... Saving SR0001559648... Saving APP-0016924566... Saving SR0001570339... Saving SR0001572466... Saving SR0001572515... Saving SR0001572117... Saving SR0001572630... Saving SR0001572832... Saving SR0001572555... Saving APP-0016917313... Saving APP-0016596008... Saving APP-0016710021... Saving APP-0016926114... Saving 1-10000397425... Saving APP-0015476102... Saving APP-0016927687... Saving SR0001572304... Saving APP-0016921677... Saving SR0001572166... Saving SR0001572168... Saving SR0001572240... Saving 1-9999392286... Saving APP-0016826051... Saving SR0001571830... Saving SR0001571289... Saving SR0001572322... Saving 1-9999679949... Saving APP-0016924086... Saving SR0001572224... Saving APP-0016868884... Saving SR0001572278... Saving 1-9999391869... Saving SR0001572413... Saving APP-0016919516... Saving APP-0016921618... Saving SR0001571269... Saving APP-0016910030... Saving SR0001571844... Saving SR0001572036... Saving APP-0016919857... Saving SR0001571798... Saving 1-9997833705... Saving SR0001572038... Saving 1-9997654830... Saving APP-0016919520... Saving 1-9998001422... Saving 1-9997656772... Saving 1-9997656801... Saving 1-9997656941... Saving APP-0016917432... Saving SR0001571807... Saving APP-0016919636... Saving SR0001571835... Saving SR0001565799... Saving 1-9997657316... Saving 1-9998040416... Saving APP-0016917838... Saving 1-9998040523... Saving APP-0016910958... Saving APP-0016918834... Saving SR0001571806... Saving SR0001177183... Saving APP-0016913769... Saving 1-9997657225... Saving SR0001571856... Saving SR0001571451... Saving APP-0016914937... Saving APP-0016914041... Saving SR0001571489... Saving APP-0016913186... Saving APP-0016913341... Saving SR0001571338... Saving APP-0016909953... Saving SR0001570533... Saving SR0001571219... Saving SR0001571319... Saving SR0001571381... Saving APP-0016531044... Saving APP-0016815764... Saving APP-0016902721... Saving APP-0016905231... Saving SR0001571227... Saving 1-9995189321... Saving APP-0016878444... Saving SR0001571255... Saving SR0001571260... Saving SR0001571109... Saving APP-0016906276... Saving 1-9994342821... Saving SR0001571128... Saving 1-9994039642... Saving SR0001569301... Saving APP-0016877199... Saving 1-9993837405... Saving SR0001571000... Saving SR0001571002... Saving APP-0016906626... Saving SR0001571059... Saving SR0001570933... Saving APP-0016903806... Saving APP-0016905824... Saving SR0001570674... Saving APP-0016904656... Saving APP-0016780365... Saving SR0001534235... Saving SR0001534228... Saving APP-0016877440... Saving SR0001568626... Saving APP-0016755604... Saving APP-0016902881... Saving SR0001570761... Saving SR0001570566... Saving 1-9992444429... Saving SR0001570627... Saving APP-0016821133... Saving 1-9992444556... Saving SR0001558275... Saving SR0001566359... Saving APP-0016900010... Saving SR0001570098... Saving SR0001570760... Saving APP-0016903837... Saving APP-0016729657... Saving APP-0016899207... Saving 1-9992444646... Saving SR0001570621... Saving 1-9992890680... Saving SR0001570770... Saving APP-0016804355... Saving SR0001570452... Saving SR0001568010... Saving SR0001570649... Saving 1-9992793932... Saving SR0001570289... Saving APP-0016757006... Saving 1-9991530004... Saving SR0001567014... Saving 1-9991338163... Saving SR0001567414... Saving 1-9991132952... Saving 1-9991556858... Saving APP-0016898627... Saving APP-0016844493... Saving SR0001570310... Saving SR0001569751... Saving APP-0016898834... Saving SR0001569394... Saving 1-9991533611... Saving APP-0016899778... Saving 1-9991424141... Saving SR0001565251... Saving APP-0016896029... Saving 1-9991533710... Saving 1-9991529845... Saving 1-9991781574... Saving APP-0016895977... Saving APP-0016712851... Saving SR0001570016... Finished - added 461 records.

Data

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

To download data sign in with GitHub

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

rows 10 / 72484

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 .
    461 records added, 458 records removed in the database
  • Auto ran revision 8bda2ba1 and completed successfully .
    458 records added, 455 records removed in the database
  • Auto ran revision 8bda2ba1 and completed successfully .
    458 records added, 448 records removed in the database
  • Auto ran revision 8bda2ba1 and completed successfully .
    462 records added, 449 records removed in the database
  • Auto ran revision 8bda2ba1 and completed successfully .
    469 records added, 440 records removed in the database
  • ...
  • Created on morph.io

Show complete history