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 SR0001573529... Saving SR0001573725... Saving APP-0016939174... Saving SR0001573649... Saving APP-0016826392... Saving APP-0016933074... Saving SR0001573322... Saving APP-0016934896... Saving SR0001573314... Saving APP-0016932528... Saving SR0001573415... Saving SR0001572942... Saving SR0001573492... Saving SR0001573498... Saving APP-0016933502... Saving APP-0016902420... Saving APP-0016931918... Saving SR0001573400... Saving APP-0016871942... Saving APP-0016932762... Saving SR0001573365... Saving 1-10003020371... Saving SR0001573337... Saving SR0001573489... Saving APP-0016727629... Saving SR0001571354... Saving SR0001571814... Saving SR0001558502... Saving SR0001573156... Saving APP-0016918796... Saving APP-0016929318... Saving SR0001573004... Saving APP-0016930268... Saving APP-0016930753... Saving APP-0016930070... Saving SR0001573137... Saving APP-0016926034... Saving SR0001572949... Saving SR0001571106... Saving APP-0016930284... Saving SR0001572998... Saving SR0001572937... Saving SR0001573122... Saving APP-0016930127... Saving SR0001572370... Saving SR0001573093... Saving 1-10001939512... Saving SR0001571091... Saving SR0001572832... Saving APP-0016926778... Saving SR0001572555... Saving APP-0016917313... Saving APP-0016596008... Saving APP-0016710021... Saving APP-0016926114... Saving APP-0016927450... Saving SR0001572117... Saving APP-0016927687... Saving APP-0015476102... Saving 1-10000397425... Saving SR0001572630... Saving SR0001553068... Saving SR0001553073... Saving SR0001553075... Saving SR0001572727... Saving SR0001559629... Saving SR0001559648... Saving SR0001572466... Saving SR0001572515... Saving APP-0016924566... Saving SR0001570339... Saving APP-0016922000... Saving APP-0016919965... Saving APP-0016899073... Saving APP-0016923469... Saving SR0001572692... Saving 1-9999679949... Saving APP-0016924086... Saving SR0001572224... Saving 1-9999391869... Saving SR0001572413... Saving APP-0016919516... Saving APP-0016921618... Saving SR0001571269... Saving APP-0016910030... Saving SR0001572240... Saving 1-9999392286... Saving APP-0016826051... Saving SR0001571289... Saving SR0001572322... Saving SR0001571830... Saving SR0001572166... Saving SR0001572168... Saving APP-0016921677... Saving SR0001572304... Saving APP-0016868884... Saving SR0001572278... Saving SR0001572038... Saving 1-9997654830... Saving APP-0016919520... Saving 1-9997833705... Saving SR0001571856... Saving SR0001571806... Saving SR0001177183... Saving APP-0016918834... Saving 1-9997657225... Saving SR0001571835... Saving SR0001565799... Saving APP-0016913769... Saving APP-0016910958... Saving 1-9997657316... Saving 1-9998040416... Saving APP-0016917838... Saving 1-9998040523... Saving SR0001571844... Saving APP-0016919636... Saving SR0001572036... Saving APP-0016919857... Saving SR0001571798... Saving 1-9997656801... Saving 1-9997656941... Saving APP-0016917432... Saving SR0001571807... Saving 1-9997656772... Saving 1-9998001422... Saving APP-0016913186... Saving APP-0016913341... Saving APP-0016914041... Saving SR0001571489... Saving SR0001571451... Saving APP-0016914937... Saving APP-0016878444... Saving SR0001571255... Saving SR0001571260... Saving APP-0016905231... Saving 1-9995189321... Saving SR0001571227... Saving SR0001571338... Saving APP-0016909953... Saving SR0001571381... Saving APP-0016531044... Saving APP-0016815764... Saving SR0001570533... Saving SR0001571219... Saving SR0001571319... Saving APP-0016902721... Saving APP-0016780365... Saving SR0001534235... Saving SR0001534228... Saving APP-0016904656... Saving APP-0016905824... Saving SR0001570674... Saving SR0001571000... Saving SR0001571002... Saving 1-9993837405... Saving APP-0016877199... Saving 1-9994039642... Saving SR0001569301... Saving APP-0016906626... Saving SR0001571059... Saving SR0001570933... Saving APP-0016903806... Saving SR0001571109... Saving APP-0016906276... Saving APP-0016877440... Saving SR0001568626... Saving 1-9994342821... Saving SR0001571128... Saving SR0001570649... Saving SR0001568010... Saving APP-0016902881... Saving SR0001570761... Saving 1-9992444429... Saving SR0001570566... Saving 1-9992793932... Saving APP-0016755604... Saving APP-0016729657... Saving APP-0016804355... Saving SR0001570770... Saving 1-9992444646... Saving SR0001570621... Saving 1-9992890680... Saving SR0001570452... Saving APP-0016899207... Saving APP-0016821133... Saving 1-9992444556... Saving SR0001570627... Saving APP-0016900010... Saving SR0001558275... Saving SR0001566359... Saving SR0001570760... Saving SR0001570098... Saving APP-0016903837... Saving 1-9991533611... Saving SR0001565251... Saving APP-0016899778... Saving 1-9991424141... Saving 1-9991529845... Saving APP-0016896029... Saving 1-9991533710... Saving SR0001569751... Saving SR0001570310... Saving APP-0016898834... Saving SR0001569394... Saving SR0001570289... Saving 1-9991530004... Saving APP-0016757006... Saving 1-9991781574... Saving 1-9991556858... Saving 1-9991132952... Saving APP-0016844493... Saving APP-0016898627... Saving SR0001567414... Saving 1-9991338163... Saving SR0001567014... Saving APP-0016895977... Saving APP-0016712851... Saving SR0001570016... Saving SR0001569833... Saving APP-0016889074... Saving SR0001568247... Saving 1-9988476402... Saving APP-0016881482... Saving APP-0016836790... Saving APP-0016609776... Saving 1-9989108992... Saving SR0001569646... Saving APP-0016882862... Saving SR0001569667... Saving APP-0016823538... Saving 1-9988840194... Saving SR0001569581... Saving APP-0016882002... Saving SR0001569112... Saving 1-9989042382... Saving 1-9987253256... Saving SR0001569402... Saving APP-0016881640... Saving APP-0016882498... Saving SR0001569339... Saving APP-0016879703... Saving APP-0016833384... Saving APP-0016881736... Saving SR0001532376... Saving APP-0016882397... Saving SR0001569444... Saving APP-0016748249... Saving 1-9987252889... Saving SR0001569377... Saving SR0001569439... Saving SR0001569445... Saving APP-0016795584... Saving 1-9987252602... Saving APP-0016772798... Saving 1-9987681175... Saving SR0001568753... Saving 1-9986599674... Saving SR0001551954... Saving SR0001562689... Saving SR0001560250... Saving SR0001568031... Saving SR0001569012... Saving SR0001568934... Saving SR0001567863... Saving APP-0016852966... Saving SR0001565374... Saving 1-9981494994... Saving APP-0016866546... Saving SR0001568969... Saving SR0001569070... Saving SR0001568752... Saving SR0001569074... Saving 1-9984938499... Saving APP-0016871209... Saving SR0001568773... Saving APP-0016874178... Saving SR0001568774... Saving APP-0016870563... Saving 1-9984684266... Saving SR0001568729... Saving APP-0016705780... Saving SR0001568661... Saving APP-0016857049... Saving 1-9984621892... Saving APP-0016169145... Saving APP-0016873006... Saving APP-0016870497... Saving SR0001568471... Saving SR0001568689... Saving APP-0016772798... Saving SR0001568567... Saving SR0001568672... Saving APP-0016872251... Saving APP-0016874925... Saving APP-0016832398... Saving APP-0016845058... Saving SR0001565667... Saving 1-9983660652... Saving SR0001553361... Saving APP-0016869786... Saving SR0001568372... Saving APP-0016869121... Saving SR0001568391... Saving 1-9983682162... Saving SR0001568438... Saving APP-0016859655... Saving 1-9983580040... Saving APP-0016868145... Saving 1-9983885545... Saving APP-0016869358... Saving SR0001563162... Saving 1-9983409419... Saving 1-9983337359... Saving APP-0016870745... Saving 1-9984089442... Saving SR0001566372... Saving SR0001568186... Saving APP-0016866565... Saving APP-0016824828... Saving APP-0016839218... Saving APP-0016863930... Saving APP-0016465264... Saving SR0001567134... Saving APP-0016829579... Saving APP-0016862294... Saving APP-0016859198... Saving SR0001564620... Saving 1-9981333067... Saving SR0001567680... Saving SR0001567117... Saving SR0001566472... Saving SR0001566583... Saving APP-0016826144... Saving APP-0016859692... Saving APP-0016856626... Saving APP-0016804152... Saving APP-0016856376... Saving 1-9980053133... Saving APP-0016856547... Saving SR0001566137... Saving 1-9979647421... Saving 1-9979697692... Saving APP-0016856526... Saving 1-9979922092... Saving SR0001567575... Saving APP-0016858575... Saving SR0001567364... Saving APP-0016850201... Saving APP-0016849672... Saving APP-0016790936... Saving SR0001567022... Saving SR0001566895... Saving APP-0016809383... Saving SR0001566928... Saving APP-0016854381... Saving SR0001566898... Saving APP-0016852312... Saving SR0001567256... Saving APP-0016795105... Saving APP-0016853802... Saving APP-0016852720... Saving SR0001566957... Saving APP-0016852356... Saving 1-9978371319... Saving SR0001567027... Saving SR0001547470... Saving APP-0016815317... Saving APP-0016851266... Saving APP-0016799831... Saving APP-0016852571... Saving SR0001567231... Saving SR0001566926... Saving 1-9978691612... Saving APP-0016837921... Saving APP-0016797155... Saving APP-0016848482... Saving SR0001564717... Saving SR0001566499... Saving APP-0016833954... Saving SR0001566723... Saving APP-0016850290... Saving APP-0016838786... Saving APP-0016710278... Saving 1-9977153680... Saving APP-0016804865... Saving SR0001566581... Saving SR0001566585... Saving SR0001566470... Saving 1-9975550882... Saving SR0001566584... Saving APP-0016850021... Saving APP-0016850559... Saving APP-0016847706... Saving APP-0016851042... Saving 1-9977153632... Saving SR0001566224... Saving SR0001566217... Saving APP-0016525289... Saving SR0001566360... Saving 1-9975602369... Saving 1-9975859803... Saving APP-0016844881... Saving APP-0016836644... Saving 1-9975793045... Saving 1-9975793011... Saving APP-0016846714... Saving 1-9975587192... Saving 1-9975510563... Saving 1-9972269052... Saving SR0001566157... Saving SR0001566289... Saving 1-9975551084... Saving APP-0016800808... Saving SR0001566173... Saving 1-9975510653... Saving 1-9976161479... Saving SR0001565996... Saving SR0001566222... Saving SR0001566408... Saving SR0001566139... Saving SR0001566305... Saving APP-0016844983... Saving 1-9976161782... Saving SR0001566237... Saving SR0001530892... Saving SR0001566043... Saving SR0001566044... Saving APP-0016842305... Finished - added 428 records.

Data

Downloaded 47982 times by slav123 dcalde openaustralia AthleticoPrawn mlandauer jesse-a-reilly LoveMyData tkrikke JamesNWeb equivalentideas TheZepto 538digital horecaOZ repose-lecture 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.9 MB) Use the API

rows 10 / 72241

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

History

  • Auto ran revision 86296e05 and completed successfully .
    427 records added, 423 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    426 records added, 425 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    450 records added, 430 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    461 records added, 423 records removed in the database
  • Auto ran revision 86296e05 and completed successfully .
    443 records added, 430 records removed in the database
  • ...
  • Created on morph.io

Show complete history