I need to scrape information off a website and have it compiled into a excel spreadsheet.
I need to get all the erf numbers(property stand numbers) off joburg.org.za for a few areas around and including the central business district and I need someone to enter the stand numbers I will provide into the web site and get out all relevant data and insert that into my excel spreadsheet.
I will attach an example.
One needs to go to http://eservices.joburg.org.za/joburg/eservices/ to get the information( this site only works in IE, and not firefox and chrome.
The site does not always work so well.
To use the site you need to click on
-agree to the conditions
-click property theme
Please see an example of the below information I need to gather and put it in the attached spreadsheet.
That would be one property.
I need to database the whole city( few thousand entries)
I will supply the database of the stand numbers I need and I need you to copy paste them off the website.
I currently have to manually run it 1 bye 1 but I am pretty sure you can run a code and do it automatically.
Please also see the attached excel document.
Only serious bidders who understand the requirements.
Township CITY AND SUBURBAN
SG ID T0IR0133000000005810000000
Land type ERVEN
Stand number 581
Ward number 61
Market value 825000
Owner AMOYA ESTATES CC
Zoning Industrial 1
Map of the location