Database of landed housing

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:

Landed Housing Database SAMPLE .xls 

Housing database, directory of buildings in Singapore

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!

3 comments

  1. First of all I want to say superb blog! I had a quick question that I’d like to ask if you do not mind. I was curious to find out how you center yourself and clear your mind prior to writing. I’ve had a difficult time clearing my thoughts in getting my ideas out. I truly do enjoy writing but it just seems like the first 10 to 15 minutes are generally lost just trying to figure out how to begin. Any recommendations or tips? Thank you!

      • El grande idiota on September 16, 2017 at 12:36 pm
      • Reply

      Wtf are you conning me asshol&

  2. Definitely believe that which you stated. Your favorite reason appeared to be on the web the easiest thing to be aware of. I say to you, I definitely get irked while people consider worries that they just don’t know about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people could take a signal. Will probably be back to get more. Thanks

Leave a Reply

Your email address will not be published.