During 2016 2 people impressed by HDB and Condo databases created by me, asked me if I can create one more database of landed houses (street address, street number and postal code). So I created one for Woodgrove Estate in April 2017:
If the Condo Database is made using web scraping software (automatically), the landed houses database can only be made manually like in the way I made the HDB Database, putting onemap.sg on side of screen and Excel on other side, writing street names and create array of street numbers, carefully to include all houses and not include non-existing houses. Given by the number of houses (more houses than HDB blocks) such database will probably take too much time and effort to complete it, I would need to sell at high price, and may never reach sufficient sale volume to cover my effort.
I run a scraping script on streetdirectory.com to input addresses and get postal code automatically. For unknown reasons I can’t get postal code for some buildings, so they will require to be added manually.
Also, while the HDB database can be easily kept up-to-date because HDB announce new BTO launches every 3 months, nobody announce where new houses are built or when a bungalow is demolished and rebuilt as semi-detached, keeping landed house database up-to-date will be difficult.
In January 2017 been contacted by someone looking for database of landed, offices, industrial. Would be better to make a database of all buildings in Singapore and not database dedicated to landed houses? What columns do you need for non-residential buildings?
In August 2017 One of my customers who bought HDB Database and Condo Database, made a scraping software to get information of all buildings from OneMap.sg and gave me the database as “work exchange”, with permission to resell it on my website. You can buy ALL buildings database. Probably now is no longer necessary to make myself, manually, a landed houses database.
Note: if you have a list of postal codes, you can give them to me, I run the script on streetdirectory.com and give you back the list with building name and address added!
You may be also interested in...