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 [login to view URL] 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 [login to view URL] 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
-Online Maps
-agree to the conditions
-click property theme
-stand number
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.
I also need a map of the location in the excel file
Please also see the attached excel document.
Only serious bidders who understand the requirements.
Township CITY AND SUBURBAN
SG ID T0IR0133000000005810000000
Land type ERVEN
Status REGISTERED
Stand number 581
Region F
Ward number 61
Area(m²) 495.50008037
Market value 825000
Owner AMOYA ESTATES CC
Zoning Industrial 1
Map of the location