Website Seach with Data extraction and collation via spreadsheet
£18-36 GBP / hora
Planning applications in the UK are dealt with by county councils/local councils/borough councils. Each has a webpage where you can view the applications and comment on them.
I have about 16 counties which I need to be looked at, in which may be various individual local or borough councils.
I want to find all swimming pool applications from the past 6 months, and have this updated with new applications 1 every month or so (frequency tbd).
Potential Problems:
1. Not all councils report in the same way, some report weekly, some monthly.
2. Not all councils display data the same way, some have web data which can be scraped, others simply attached files like PDF's or Word documents.
3. Cities like Bristol or London, may be in multiple counties, but actually, are often considered their own entity and so have various borough councils.
4. Some of the applications will be residential (home owners) some of them will be commercial (hotels, developers, Spas etc)
Job Outline:
1. Identify all the local/borough council planning departments websites, or county council planning departments websites within the following Counties:
Bedfordshire, City of Bristol, Buckinghamshire, Cambridgeshire, Cornwall, Devon, Dorset, East Sussex, Essex, Greater London, Hampshire, Hertfordshire, Kent, London, City of London, Middlesex, Northamptonshire, Oxfordshire, Somerset, Surrey, Sussex, Yorkshire
2. Build a spreadsheet which outlines:
Column1: Pool Architect Company
Column2: Pool Architect firstname
Column3: Surname
Column4: Pool Architect Phone number
Column5:Architect or company email
Column 6: Residential/Commercial application
Column 7: Pool type (indoor, outdoor, conversion)
If Residential
Column9 Address
Column10 Pool owner first name (if available)
Column11 Pool owner surname (if available)
Column 11 Pool home owner telephone (unlikely to be available).
If Commercial
Column 12: Company owner name
column 13: Address
column 14: Date of Application
Column 15: Date Added to spreadsheet.
3. Find a way to scrape, copy, data input, visit company websites, to achieve the above information requested in 2. For example you may have to visit the architect's website to find a telephone number, or email for them.
Possible key words: Swimming pool, basement pool, roof pool, swimming pond, pool conversion, spa pool.
I look forward to your information and return. If you have an easier way of achieving the above I am open to suggestions.
Nº del proyecto: #11115700
Sobre el proyecto
36 freelancers están ofertando un promedio de £22 / hora por este trabajo
I have gone through the project details and understand what you are trying to achieve. We have completed a number of similar a projects to yours. I'd like to speak with you to confirm project details. A little abou Más
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
Dear Sir/Mam, Please refer to your PM, So we can create some sample work before awarding the project so that you can have a idea about the Quality of our work. I have read description carefully and I understand yo Más
"IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 8+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networking, real-es Más
Hello Greetings Yes I can extract required information(data) from county councils websites into spreassheet. **** I will start asap **** I am open for free trial **** I have completed similar projects in past
Hello, I am Peter, nice to meet you. I would like to take care of you project. It sounds really simple. Just give me a message. Best regards, ~ Peter
Hi, we are professional & expert in web scraping & data searching. We have many sources where the data can be taken from. Hire us to get best output with 100% accuracy in given time frame.
sir I will work for you on this task I totally understand the task and read complete information you provided. if you want me to do some sample work 1st on this task kindly contact me. i will provide you with my previo Más
Hello, I read your description thoroughly. If you give me chance, I will provide you some sample. Then It will be easy for you to choose the right person. Message me if you interested. Looking forward to work with y Más
Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have me Más
To whom it may concern, I might be new in freelancer.com and/or on-line jobs but I am certainly not new in Excel and have been improving my Excel skills as well as VBA skills over the years. I might not be an exp Más