Jan 01

Website traffic stats

Do you want to advertise on my website and need demographic info?
Or just curious how many visitors I have and from which countries?

Here I publish the traffic statistics! Not only the number of daily / monthly visitors, but also the countries, Google searches and entrance page of visitors, so you can see what people are looking for and which pages have biggest contribution! Because, for example if you are an agent specialized in Executive Condominium you may want to advertise in List of EC page only.

The “Housing in Singapore” pages contribute with 60% of traffic, of which most people come for information prior buying a property, or after buying a property looking for a floor plan and renovation ideas. Thus real-estate ads have highest click ratio potential. If you are real estate agent, interior designer, or contractor, my website is the best advertising space. However, all types of ads are welcome except adult / porn.

Price for banner ad: $20 for housing-related ads, $10 for everything else (per month). Text links are also welcome at half price!

Traffic stats for last 1 year + Traffic stats for last month

For 2016 stats, please ask! I no longer waste time updating stats every month, because apparently nobody is interested how many visitors I have. The few advertisers I had, did not even checked Traffic Stats page.

Monthly reports (clickable links to PDF report)

April 2014 – 30715 visitors = 1024 daily (on 3-12 April multiple people shared and re-shared links on Facebook, I got additional 1000 LIKES and a traffic spike… this also boosted ranking in Google, from 550 daily visitors before getting additional LIKES to 740 daily visitors last 2 weeks)
May 2014 – 25469 visitors = 822 daily (Sale of Balance Flats in Singapore, boosted traffic to 800+ daily visitors)
June 2014 – 22962 visitors = 765 daily (note: Clicky got BUGGED in counting visitors, shows only 2409 in entire month, while the chart is showing 600-900 visitors per day, had to count manually day by day and make a sum.
July 2014 – 23763 visitors = 767 daily
August 2014 – 24796 visitors = 800 daily
September 2014 – 22286 visitors = 743 daily
October 2014 – 21741 visitors = 701 daily
November 2014 – 22461 visitors = 749 daily (Sale of Balance Flats in Singapore = boosted traffic)
December 2014 – 19399 visitors = 626 daily (school vacation in Singapore = lost 20% of traffic)
January 2015 – 24658 visitors = 795 daily
February 2015 – 23001 visitors = 821 daily
March 2015 – 25070 visitors = 809 daily
April 2015 – 28944 visitors = 965 daily (traffic spike 26 April – 1 May due to students sharing links on Facebook)
May 2015 – 29356 visitors = 947 daily (Sale of Balance Flats in Singapore = boosted traffic)
June 2015 – 24702 visitors = 823 daily (school vacation in Singapore)
July 2015 – 26964 visitors = 870 daily
August 2015 – 28915 visitors = 933 daily
September 2015 – 29299 visitors = 973 daily
October 2015 – 30622 visitors = 988 daily
November 2015 – 35375 visitors = 1179 daily (Sale of Balance Flats in Singapore = boosted traffic)

Old traffic stats (2013)

Current website was started in Aug 2012, but the “heavy” content has been added on Nov 2012. For Jan-Oct 2012 see the old website teoalida.webs.com/trafficstats.htm.
000webhost.com (FREE hosting) suspended my website 3 times during November, for high traffic, 2 times restored at midnight, 3rd time suspended for ever… since 1 December 2012 I am hosted by Hosting24.com ($4.84 per month) that guarantee no more problems. 4 days of website down caused loss of 2/3 of traffic, BUT as you can see, in one month it recovered, reached 300 daily visitors, exceeding original traffic level of 200 daily visitors!

November 2012 – 4958 visitors = 165 per day
December 2012 – 2855 visitors = 92 per day
January 2013 – 7733 visitors = 249 per day
February 2013 – 8017 visitors = 286 per day
March 2013 – 11002 visitors = 355 per day
April 2013 – 9884 visitors = 329 per day
May 2013 – 8475 visitors = 273 per day
June 2013 – 8552 visitors = 285 per day
July 2013 – 13580 visitors = 438 per day – On 15 July someone posted in a forum then people copied on Facebook… traffic from Google boosted with 50%, probably Google learned to track Facebook LIKES.
August 2013 – 15241 visitors = 492 per day
September 2013 – 15351 visitors = 512 per day

The huge peak on 12 Nov is because TheOnlineCitizen posted me on Facebook, sending 800 visitors in 4 hours.
The drop since mid-April 2013 is because of some changes in WordPress, Google add the title from the first post in SEO ranking. and since April I rotated posts and put at top of page a post with not so-good title. No changes in WordPress, was a BUG on my website. I was not aware of this until ~30 May 2013, solved on 20 June by reinstalling entire website, traffic re-started rising.

Since October 2013 I am experiencing problems in Google ranking causing massive fluctuations of traffic. A drop to 150 daily visitors in October then rise back to 500 daily visitors in January and fall again to 150 daily visitors few days later.
I will post new screenshots after the traffic remain constant over 1 full month.

How much bandwidth this website is eating?

See Bandwidth-Stats.png.

The old website, hosted on Webs.com free hosting, was using over 2 GB monthly bndwidth at its peak in October 2014 (230 daily visitors), this 2 GB included HTML codes only, excluding template (it was provided by Webs.com thus not counting in bandwdith) and images (all hosted on third-party websites, Imageshack, Photobucket).

This website, made using WordPress platform and hosted on Hosting24 since December 2012, used initially 10-20 GB monthly bandwidh, with images still hosted on third-party websites. Moving images on own server starting from July 2013 raised bandwidth usage to 100 GB monthly (500 daily visitors).

Google penalty that was October 2013 to March 2014 reduced traffic to 25% and bandwidth use to 50 GB monthly.

The Facebook madness in April 2014 raised bandwidth usage to a record of 240 GB in April month and 160 GB in next months (800 daily visitors).

Image optimization in August 2014, creating thumbnails for all floor plan images in HDB Floor Plans page (the most visited page), reduced page size from 30 to 10 MB, and overall bandwidth was reduced to about 90 GB per month.

What do I see about you when you visit my website

I use Clicky.com to monitor traffic, and THIS is what I see. Operating system, browser, what pages do you open and what links do you click. However, I am NOT checking what every visitor is clicking. For what reason I would waste time checking 800 visitors per day? What I am interested is to see what pages gets most traffic, bounce ratio for every page, etc, this for statistical purposes, and for optimizing my website.

Additionally I use Zopim chat software, when you message me, a Google Talk window pops up and I see THIS: your IP, city, country and page URL.

Seeing this info is for your benefit, for improving customer service. For example, I get often questions from visitors who do not tell me what they are asking about, and I seeing visitor country and the page where he is looking, is useful to provide a relevant answer. But I may fail in confusion in case of people overseas or using proxy, as seen in this chat.

Some people may consider this an invasion of privacy and will quit my website.

For your info: ANY website owner is theoretically capable to see such things. Your phone company is also logging all numbers you call, and your internet service provider is logging all sites you access, emails you send (time, date and address only, email content is not logged). If you do not agree, then please disconnect from internet and turn off phone, and communicate only face-to-face.
In most countries the internet providers are required by law to keep the logs for 6 months, so in case someone report a serious crime such as bank fraud, the police can track down the criminals. You can type an IP on sites like www.ripe.net and www.arin.net and get ISP name who own the IP. But to get name and address of particular IP you need to go to ISP, which for privacy reasons should not disclose this private info to anyone except police in case of a criminal investigation. This does NOT mean that a human is monitoring you all time, what sites do you visit, etc, but only if you commit a serious crime.

Stop being paranoid and think that over 1 billion people in the world use internet every day and are not hurt in any way.
The internet is designed to be monitored… for purpose of protecting you, otherwise it would have been full of cyber criminals freely to to sell non-existent products on eBay and steal your money from credit card, who would be never caught.

WARNING for people who think that I get rich from this website

Having 1000+ daily visitors doesn’t mean that I earn $1000+ per day. As you can see from above screenshots, about 60% are Singaporeans looking for HDB-related stuff. They are not interested in my architecture design services. Just about 10% are coming via House Design / Apartment Design pages showing the services that I offer, of them the majority are just browsing the internet for free floor plans, without being interested in my services, some people are contacting me for my services but not everyone is willing to pay.

Having in architecture business more than 1 paying customer for month means LUCK. Of course I have additional income from selling stuff and non-architecture design jobs. Yes I have customers, the website is money-marking, but not enough to live alone. I am still dependent by family money.

Nov 30

SCAM for web designers

I rarely get emails regarding webdesign. The customer gave me link to a website http://www.agroamerica.com but he put some dots after it to make link not clickable. I would have not been aware that this is a SCAM if I would not have accidentally copied his link including the dots in browser, thus went into Google Search rather than directly on website, and saw numerous blogs reporting “Agroamerica SCAM”. However, I continued to reply at email, playing role of a naive guy (scam baiting), to see how the scam is working: he don’t even ask for portfolio instead is goes directly to giving me his credit card full of money and request me to pay half of money to person who provide content, then probably will lock the card or chargeback the money, leaving me in loss.

 


Scammer:

Good Day

I’m John,am hearing impaired.i would love to know if you can handle website design for a new company and also if you do you accept credit cards ?? kindly get back to me ASAP so i can send you the job details.

Regards
John Wharf

 


Me:

Hi there, I may be able to help you, but may I know how did you found my email address?

 


Scammer:

Thanks for your swift response and i got your contact from google when i was searching for a web designer

Here is the job details

I have small scale business which i want to turn into large scale business now it located in TN and the company is based on importing and exporting of Agriculture products such as Kola Nut, Gacillia Nut and Cocoa so i need a best of the best layout design for it. Can you handle that for me ?. so i need you to check out this site but i need something more perfect than this if its possible .http://www.agroamerica.com.… the site would only be informational, so i need you to give me an estimate based on the site i gave you to check out, the estimate should include hosting and i want the same page as the site i gave you to check out and i have a private project consultant, he has the text content and the logos for the site.

Note:

I want the same number of pages with the example site i gave you to check excluding videos and blogs. I want only English language, I don’t have a domain yet but i want the domain name as topfarmproduce.com, you will be updating the site for me. i will be proving the images, logos and content for the site. i want the site up and running before ending of next month.

My budget is $4000 to $8000
get back to me with:

(1) an estimate, (2) your cell phone number, (3) And will like to know if you are the owner?

Regards

John wharf

 


Me:

I really want to know more how did you “got your contact from google when i was searching for a web designer”

Although I do have little experience in designing simple WordPress websites, I never promoted myself as webdesigner, my primary job is architectural design services (this is why using Teoalida Design in email name). I checked Agroamerica and it looks a simple website that can be done with WordPress + a responsive theme for few hundred dollars. If your budget is really $4000-8000, I assume that you want a website more unique with custom coding, in this case I will ask my webdesign partner to do the job for you. So do you want WordPress or custom CMS? in both cases I can made website for you to be able to update it yourself.

 


Scammer:

Thanks for your response, I am okay with the estimate everything sound good and i’m ready to make payment now with my credit card, I understand the content for this site would be needed so work can start asap but i will need a Little favor from you and the favor is that I will send you my credit card to charge for the sum of $6,450.00 plus 3% Cc company charges, You will deduct $3,250.00 as deposit for the design of the website plus extra $200.00 as a tip for handling perfect work for me and you will send the remaining $3,000.00 to the project consultant that has the text content and the logo for my website so once he receive the $3,000.00 he would send the text content and logo needed for my website to you so work can start asap,Sending of funds would be after money clears into your account and You will be charging my card for remaining balance upon completion of work.

Kindly get back to me so we can proceed with payment asap

Regards

John wharf

 


Me:

What? are you sending your physical credit card? instead of making payment via Paypal or bank transfer? How do I charge money from someone else card?

 


 

I haven’t heard any reply from him after this.

Oct 06

Other CAD Design

Do you though that I work only in architecture? WRONG! I can do almost anything in AutoCAD! I am often working in architecture because I posted few dozens house models on website. But here I show the floor plan and 3D design of the… largest salt mine in Europe! See real photos from mine. Designed in 2008 for fun / hobby.

Sep 02

List of BTO prices

Have you ever wondered what were the HDB flat prices in the past, but have a hard time digging for prices around various news websites and forums? I compiled all prices of BTO projects from 2001 to 2017 in one Excel database that took about 10 hours of work, to allow you to compare flat prices by town, by flat type, etc. If you have any suggestion how to make table easier to use, tell me!

Looking for resale market? see Resale flat prices database.

 

Download free SAMPLE – Sembawang

BTO prices 2001-2016

Feb 17

Contact

Are you a robot crawling emails to send v!agra, SEO offers or other crap? Email me spamsucks@teoalida.com

Feel free to contact me if you have any enquiry about AutoCAD design, architecture, real estate, research, data mining and analysis, or any other field covered by articles of this website.
spam @ teoalida.com

You can also post comments on any of the pages of website, but if you post a question, don’t forget to come back to check if anyone answered.
I reply to EVERY email next morning, but since I rarely hear replies from people after I reply them, I believe that my emails go sometimes to SPAM / JUNK folder.
If you email me and do not receive any reply in 12 hours, check your Spam / Junk folder, and visit website again during European daytime / Asian evening-night to contact me via LIVE CHAT.
I stay online on chat every day 10-14 hours except when sleeping or out of home.
I hate disappointing people looking for a free advice, or even lose paying customers, due to email anti-spam filters.
Use the LIVE CHAT whenever is possible.

Looking to buy a property in Singapore?
HDB, EC, private condo, industrial, etc? Contact my partner agent:
William Chui

FAQ

Zopim live chatI created website in 2009 to showcase my hobbies, I accidentally discovered zopim.com chat software in 2012 and added it on my website to talk with visitors, make friends with similar interests, get feedback about my hobbies and works, exchange information, etc. The chat helped me also to get hired by people and get paid to do various works, or to understand market demands and offer suitable products, turning my hobbies into money-making business.

Do you stay at computer all time to greet visitors and answer questions?

NO! The chat software is greeting visitors automatically. Only if you type a message in chat, I get sound alert of incoming chat, if I am working at computer I answer in max 5 seconds, but if I am not at computer, I try to come as fast I can to answer you. Of course this is not always possible, 5-10% of chats remain unanswered. But you can always leave your email address where you answer your questions if I can’t answer you in time.

Do you get paid to chat with people?

NO! I offer consultation via chat voluntarily, I am NOT employed, affiliated with any government or company, or get paid “to help people”. I am independent, this is my personal website and only YOU can pay if the consultation or services offered helped you!

This is valid especially for people from Singapore, every day about 10 of them were contacting me for real estate consultation until I disabled chat greeting for Singapore to escape from this hell. If consultation with me made you to decide to buy a $500,000 property, I appreciate if you can donate me few dollars.

DONATE

While chat consultation is free, AutoCAD design services, research and database services are not free. This is how I make a living. I have the right to refuse to do your project if you do not pay my given price, do not get angry and threat me, as this Indian did.

Some people treat me like a paid customer service for example getting angry if I ask them too questions, as a friendly exchange of knowledge, or getting angry if I do not know answer of their questions (example “you are paid by this website to help people, why you are not answering my questions?).

How many people contact you?

As 2015, website gets 800 daily visitors (see traffic stats). With chat greetings set at 3-5 minutes, about 20-30 people would message me. Some people feel disturbed if chat pop-up and greet, but 80% of conversations are started by people replying after automatic greeting. Greeting increase conversion ratio, without greeting people would not even notice that there is a chat service available!

In 2014 I disabled chat greeting for Singapore (because these people often ask me info without paying for any service) and in 2015 I disabled also for architecture pages (because I lost interest in architecture due to rising business of databases), so now I get about 10 people contacting me daily. I try to optimize further to be contacted only by customers.

Warning for kids

Website audience is mostly adults, but sometimes I get contacted by kids (idiots) who thinks that website purpose is for chatting and they message me random questions just “to chat with someone”, inviting schoolmates to do the same, coming in groups of 5+ (in normal circumstances I don’t have more than 2 people on chat at same time), distracting me from doing my work or from chatting with potential customers. Example: 12-year kids from Singapore and kids from United States visiting the page about North Korea from school to ask stupid questions and inviting schoolmates to do the same..

This is NOT a chat service that you can use when you are bored and want to chat with someone.
This is a customer service primarily intended to be used by people interested in my products (databases) and services such as AutoCAD design & architecture.
However, you are welcome to ask anything about any fields covered by website, most questions can be answered in few minutes and do not cause disturbance to my daily work… you are advised to NOT talk too much if you are not going to buy any product or service.

Should I post a comment on website or send you an email?

If you have a question or enquiry about my services and need immediate answer from me, use LIVE CHAT.

If you have comments about articles shown on website, post a public comment.

If you have files to send me, send an email. I reply to all emails, but only in half of cases I get back a reply. Some people reported via chat that are not receiving emails from me, or that received in SPAM folder.

You can also ask questions via comments, this will allow other people to answer your question, but there is always a risk for me to not notice your comment: Every time someone leave a comment I get an email notification, but I get every day SPAM comments left by robots, and if you leave comment after a spammer, I receive a new email notification that appear over spammer one while displaying name of the spammer one, and I risk to delete both emails without noticing that second one was a human comment.

Please post comments also at other people’s comments. Don’t leave all communication to be between me and thousands visitors of website.

Do not post comments in Contact page!
Please post comments in the relevant page, for example house builders in Philippines post your comment in House Plans page or Philippines page, while for questions about Singapore SERS programme post your comment in SERS page.

Dec 14

HDB statistics, facts & figures

HDB built slightly over 1 million units since its founding in 1960 (the 1 millionth flat was completed in December 2010), SIT built about 23,000 units between 1927 and 1960, JTC and HUDC built few thousand units between 1960s and 1980s, making a total of about 1.1 million public housing units built in the history of Singapore, as 2016.

Of these 1.1 million units built, 992,742 units are in use at 31 March 2016, about 130,000 dwelling units being demolished (clearance of rental blocks and SERS), converted (2 units joined into 1 unit), privatized (HUDC), etc.

What other statistical data would you like to see on this page? Leave a comment and tell me!

HDB dwelling units per town and flat type, as 31 March 2015 HDB dwelling units per town, by year
HDB achievements since 1960 HDB dwelling units by flat type, per year
All charts are screenshoted from HDB Statistics .xls, for exact figures see Excel file.

According HDB Annual Report 2015, out of 3.9 million resident population (Singapore Citizens and Permanent Residents, as June 2013), 3,217,400 live in HDB apartments, this means 82% (non-residents are not allowed to own HDB apartments but they can live in apartments owned by a resident spouse, also they are allowed to own apartments in private condominiums taller than 6 storeys but not landed houses or apartments in low-rise condominiums). This means average family size of 3.42 residents per apartment and 27.56 sqm per person. For comparison, in 1968 were in average 6.2 people per apartment (average flat size I estimate around 40 sqm).

Many HDB owners are renting rooms or entire flat to foreigners, some HDB owners are citizens married with foreigners, HDB never provide official statistics about how many non-residents live in HDB apartments.

According Yearbook of Statistics 2010, Singapore population including non-residents is 5076700 living in 1180500 dwelling units (HDBs, condos, private flats, landed houses, others), of which 76.3% are HDBs, this means a nationwide average of 4.30 people per dwelling unit, if the average would be same for HDB, it would mean 22 sqm per person (no newer statistics available for non-residents).

Average household size for each flat type and race can be seen on www.singstat.gov.sg > Key Indicators and Sample Household Survey. You can see that households with 6 or more persons represent 10% of Chinese households and 23% of Malay households.

Home ownership of HDB flats reached the peak of 94% in 2002, then slowly felt down to 90% in 2011.

HDB dwelling units under management, as 31 March 2016

Biggest HDB town: Bedok during 1990s, Tampines in 1996-1999 and Jurong West since 2000. Either Sengkang or Tampines will take the lead around 2020.

 

Town 1-Room 2-Room 3-Room 4-Room 5-Room E / MG SA Total
Ang Mo Kio 1318 3506 24237 13682 5654 490 281 49168
Bedok 2530 2286 22639 20398 10390 2714 234 61191
Bishan 396 5 2357 9359 5716 1660 171 19664
Bukit Batok 385 242 10278 13851 4833 2732 177 32498
Bukit Merah 4731 5777 15965 15369 9477 44 469 51832
Bukit Panjang 223 539 3678 16699 10425 3381 380 35325
Bukit Timah 0 35 441 920 682 380 97 2555
Central Area 2075 1316 4739 3529 903 9 0 12571
Choa Chu Kang 355 878 2137 22485 15293 4762 515 46425
Clementi 474 716 11947 8593 2915 619 0 25264
Geylang 1044 3214 11705 9607 3591 830 239 30230
Hougang 532 917 10318 25238 10844 4310 365 52524
Jurong East 352 418 7006 8188 5925 1871 137 23897
Jurong West 540 1732 12659 28457 21569 6507 639 72103
Kallang / Whampoa 4401 2530 13321 10178 5392 504 38 36364
Marine Parade 0 1350 3037 1798 1677 0 0 7862
Pasir Ris 176 326 491 11641 9379 7460 181 29654
Punggol 871 1412 3639 19631 14612 1126 456 41747
Queenstown 575 3246 14210 8794 3972 354 353 31504
Sembawang 321 768 349 8447 7556 2870 0 20311
Sengkang 685 1479 3341 29405 23134 4462 541 63047
Serangoon 272 324 4543 10231 3753 2365 0 21488
Tampines 775 740 13107 28631 17312 5846 649 67060
Toa Payoh 1168 3654 15122 9756 6017 854 300 36871
Woodlands 1603 1284 6348 27859 19639 6191 855 63779
Yishun 1038 1200 14530 28155 9169 2741 705 57538
Total 26840 39894 232144 390901 229829 65082 7782 992472
Average flat size 31 45.26 68.03 96.31 118.47 144.71 ~40 155.61
Final results Average flat size – 93.87 sqm

Total population (Jun 2014) – 5469700 people
Resident population – 3900000 people
HDB resident population – 3213000 people (82%)
Average resident household size – 3.42 people
(27.56 sqm per capita)

Despite of shrinking flat sizes in late 1990s, average flat size has increased until 2005, reaching about 95 sqm, thanks to demolition of small 1/2/3-room flats built in 1960-1970s and building 90-140 sqm flats, also due to Main Upgrdading Programme that add 5 sqm utility rooms. After 2005 average flat size is slowly falling down because HDB stoped supply of Executive, reduced supply of 5-room, and reintroduced 1-room, 2-room and 3-room flats.

BTO flats launched since 2011 and completed from 2015 onward are about 80 sqm in average, for comparison the flats build in mid-1990s were about 120 sqm in average, a world record for public housing.

Sources:
– SingStat for the population
– HDB Annual Reports for the number of flats (units)
– HDB Resale Flat Prices database for 2008-2013 (149930 records) for estimating average flat sizes

The average flat size is a bit inaccurate because the database include only sold flats, there is no info about the size of rental 1/2-room flats, and does not include flats built last 5 years which are under minimum occupation period, including them For 2005 average flat size by type I used resale transactions with lease year pre-2005.

SingStat also show population living in condos and landed houses, in case you are interested, but unfortunately there are NO detailed statistics for about number of private housing breakdown by type.

Excel files with additional statistics

HDB Annual Reports.xls – 1990-2000 + 1962 annual reports digitalized into Excel by me:

Source of data: HDB Annual Reports 1994-1996 (available on archive.org) and 2000-present (available on HDB InfoWEB even if they are no longer in Annual Reports page, but doing a Google search you could still find the direct link to files still hosted on HDB server, they were deleted at October 2015 website redesign). I was not able to get 1997-1999 because since 1997 HDB provided in PDF format instead of HTML page, and archive.org did not cached PDF files.

I added 1990-1999 thanks to KZ, a friend who during school vacation of June and December 2015 went in National Library and photoed the annual reports for me for digitization. He photoed 1960s to 1980s annual reports too and I may digitize them too when I have free time. These pre-1990 annual reports have a list of about 100 HDB Estates. The current HDB towns appeared in AR 1990 (20 towns plus 11 other estates) and was revised in AR 1999 to 23 towns and 4 estates then 23 towns and 3 estates by abandoning Lim Chu Kang.

If you want photos of annual reports to read them yourself, you can buy them!

HDB Statistics.xls – Excel file compiled by me, containing:
– Annual Reports 2000-2016
– Number of dwelling units by town and flat type, table and chart
– Number of dwelling units by town and year, table and chart
– Number of dwelling units by flat type and year, table and chart
– Statistics for calculation of the average flat size along history
– HDB achievements since 1960
– Resale market statistics
Please leave your comments about my work!

HDB flat size statistics based on resale transactions

I copied the listings from HDB Resale Flat Prices e-service (April 2008 – December 2013) in Microsoft Excel for purpose of making statistics. Results:

– As country level: the average flats size is 97.41 sqm (average of ~149930 transacted units).
– As town level: Central Area (most built in 1970s) have the smallest flats, 72.24 sqm (average of 998 units) while Pasir Ris New Town (built between 1988 and 1996) have the biggest flats, 123.38 sqm (average of 5184 units).
– As neighborhood level: Pasir Ris 2XX neighborhood have the biggest flats, 132.36 sqm (average of 694 units), Pasir Ris 5XX have 129.25 sqm (average of 875 units), Pasir Ris 6XX have 127.17 sqm (average of 521 units), Choa Chu Kang 5XX have 126.39 sqm (average of 607 units), Tampines 3XX have 121.79 sqm (average of 1129 units).
– As five-year period: 1991-1995 have the biggest flats, 124.48 sqm (average of 11398 transacted units).

Note that the average size of resold flats is slightly bigger than the real average flat size, because the big and <10 year old flats tends to change their owners more frequently than the small old flats owned mainly by elderly, also some of the small flats are rented from HDB rather than owned, so they never appear in resale transactions.

The full Excel database of resale transactions can be purchased from my Store.

HDB flats breakdown by floor area HDB flats size over years

Note

I noticed many visitors coming here by searching things like “total number of HDB blocks in Singapore“. HDB provide official numbers of units but not of blocks. Blocks can be ONLY counted manually.
Do we should also count the 2-storey shophouse that contains no residential units, only commercial units (flats accessible from shop entrance)? Do we should also count under-construction blocks and blocks awaiting demolition? Do we should count multi-storey carparks and precint pavilions too?

According Database of HDB blocks, there are about 9800 residential HDB buildings in Singapore (not including carparks, pavilions, but including shophouses).
Note that the database is, in the current version, NOT ACCURATE… being made for personal curiosity without being paid for, with limited time available for voluntary jobs. Some under construction blocks are counted, others not. Some demolished blocks are counted too.

I will provide detailed statistics with higher accuracy if someone will pay my time required to make them.

First payment came in May 2015, reason for which I improved database accuracy significantly.
According the July 2015 edition of database, there are 9503 blocks with known number of units, total 980108 units, giving an average of 103 units per block.

Number of units in private condominiums, executive condominiums, square meters of office and retail space, can be seen in https://www.ura.gov.sg/uol/media-room/news/2017/Apr/pr17-30 and https://www.ura.gov.sg/uol/-/media/User%20Defined/URA%20Online/media-room/2017/pr17-06e1.pdf

Dec 08

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!

Dec 07

HDB Annual Reports 1927-present

KZ, one of the biggest fans of my website and hobbyist regarding HDB history, went 4 times to National Library and photoed all annual reports of SIT and HDB as well as other publications about HDB. He gave me the photos (just for me), the photo collection being a mess, I spent a great amount of time sorting them. Later we agreed to sell them on my website and split the money 50-50%.

The photos are not taken professionally, but are enough to read them at your home for references and cite annual report as source in case you need to write a dissertation for your university. See few photo samples:

SIT Annual Report 1958: floor plans, statistics, and preliminary plan of Toa Payoh (what SIT was going to build if was not replaced by HDB: a lot of low-rise blocks)

SIT Annual Report 1958 SIT Annual Report 1958 SIT Annual Report 1958

HDB Annual Report 1970: breakdown cost of each flat type, units under management.

HDB Annual Report 1970 HDB Annual Report 1970

HDB Annual Report 1990: layout plans of neighborhoods and a text article regarding revision of income ceiling, allowing permanent residents to purchase resale flats, etc.

HDB Annual Report 1990 HDB Annual Report 1990

What we have photoed:

SIT Annual Report 1927-1947 (1 book) and SIT Annual Report 1948-1959 (12 books), 1365 images, 1.37 GB
HDB Annual Reports 1960-2007 (46 books), 8473 images, 8.25 GB
JTC Annual Reports 1969-1978 (1 book), 92 images, 169 MB
Note: newer HDB Annual Reports (2008-present) can be found on HDB InfoWEB

Other books (3388 images, 4.09 GB):
Building on Productivity and Quality (1992)
Comparison of improvements on finishes fixtures fittings
Designed for living (1985)
HUDC brochures Phase 3&4
Our home magazine
Planning and Design of Public Housing Estates in Hong Kong (1983)
Public housing design handbook (1995)
Public housing in Singapore – A multi-disciplinary study – Edited by Stephen H.K.Yeh (1974)
Residents handbook
Study of HDB (1983)
Study of HDB (1985)
Surbana book

Buy complete collection of photos

Buy & download

Contact me if you want only a specific book or specific year of annual report.

I will send the files via WeTransfer.com, they are too big to be stored on server to download automatically.

Oct 16

Solar System Database

Are you looking for a database of planets and satellites in Excel format with their facts and figures, for research or to make a website? I made a database for you, sourcing data from solarsystem.nasa.gov, manually compiled in Excel in 2014 and offer it here for FREE download.

I made it for personal interest of comparing facts of all planets and satellites at same time, while the NASA website allow only 1 vs 1 comparison.

Solar System Database - planets and satellites facts and figures

What is included

The current version of database include planets and satellites in hydrostatic equilibrium (approximately round shape). I have not included satellites with less than 400 km in diameter of planets beyond Jupiter.

If in 1990s were known 77 bodies in solar system, today 300+ bodies were discovered. Since 1997, each year bring discovery of new satellites, most of them under 10 km diameter. Not much data is available about them on NASA website, some estimated data is shown on Wikipedia, and as the space exploration progress, the data is likely to change. Do I should add more satellites in the next version of database?

Sun
Planets: Mercury, Venus, Earth, Mars, Jupiter, Saturn, Uranus, Neptune.
Dwarf Planets: Ceres, Pluto, Makemake, Haumea, Eris.
Satellites: Earth: Moon; Mars: Phobos, Deimos; Jupiter: Io, Europa, Ganymede, Callisto; Saturn: Mimas, Enceladus, Tethys, Dione, Rhea, Titan, Iapetus; Uranus: Miranda, Ariel, Umbriel, Titania, Oberon; Neptune: Triton; Pluto: Charon.

Note: I have a long hobby for geography and astronomy. First time I made a solar system database in Word around year 2000 sourcing data from old 1970s atlases dating back from my parents school age, and another one made in 2004 sourcing data from Encarta Encyclopedia 2002.

Oct 16

Countries database

Are you looking for a database of countries in Excel format with their facts and figures, for research or to create a website? I made a database for you. Took few hours to make a scraping script which extract data from The World Factbook and create a CSV file. Takes about 35 min to extract the 268 entries, and I can update anytime you want!

Buy country database:

Countries database - facts and figures

The database include 268 entries, sovereign countries, dependent territories, as well as oceans, World and European Union.

LITE version include area and population for all countries, as well as full facts for United States and United Kingdom.

FULL version include 362 facts, covering everything possible from Geography, People and Society, Government, Economy, Energy, Communications, Transportations, Military and Security, Transnational Issues.

Contact me for custom packages (specific selection of columns)

List of entries in country database

World, Afghanistan, Akrotiri, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antarctica, Antigua and Barbuda, Arctic Ocean, Argentina, Armenia, Aruba, Ashmore and Cartier Islands, Atlantic Ocean, Australia, Austria, Azerbaijan, Bahamas, The, Bahrain, Baker Island, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia and Herzegovina, Botswana, Bouvet Island, Brazil, British Indian Ocean Territory, British Virgin Islands, Brunei, Bulgaria, Burkina Faso, Burma, Burundi, Cabo Verde, Cambodia, Cameroon, Canada, Cayman Islands, Central African Republic, Chad, Chile, China, Christmas Island, Clipperton Island, Cocos (Keeling) Islands, Colombia, Comoros, Congo, Democratic Republic of the, Congo, Republic of the, Cook Islands, Coral Sea Islands, Costa Rica, Cote d’Ivoire, Croatia, Cuba, Curacao, Cyprus, Czechia, Denmark, Dhekelia, Djibouti, Dominica, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Falkland Islands (Islas Malvinas), Faroe Islands, Fiji, Finland, France, French Polynesia, French Southern and Antarctic Lands, Gabon, Gambia, The, Gaza Strip, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guam, Guatemala, Guernsey, Guinea, Guinea-Bissau, Guyana, Haiti, Heard Island and McDonald Islands, Holy See (Vatican City), Honduras, Hong Kong, Howland Island, Hungary, Iceland, India, Indian Ocean, Indonesia, Iran, Iraq, Ireland, Isle of Man, Israel, Italy, Jamaica, Jan Mayen, Japan, Jarvis Island, Jersey, Johnston Atoll, Jordan, Kazakhstan, Kenya, Kingman Reef, Kiribati, Korea, North, Korea, South, Kosovo, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Libya, Liechtenstein, Lithuania, Luxembourg, Macau, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Mauritania, Mauritius, Mexico, Micronesia, Federated States of, Midway Islands, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Namibia, Nauru, Navassa Island, Nepal, Netherlands, New Caledonia, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norfolk Island, Northern Mariana Islands, Norway, Oman, Pacific Ocean, Pakistan, Palau, Palmyra Atoll, Panama, Papua New Guinea, Paracel Islands, Paraguay, Peru, Philippines, Pitcairn Islands, Poland, Portugal, Puerto Rico, Qatar, Romania, Russia, Rwanda, Saint Barthelemy, Saint Helena, Ascension, and Tristan da Cunha, Saint Kitts and Nevis, Saint Lucia, Saint Martin, Saint Pierre and Miquelon, Saint Vincent and the Grenadines, Samoa, San Marino, Sao Tome and Principe, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Sint Maarten, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, Southern Ocean, South Georgia and South Sandwich Islands, South Sudan, Spain, Spratly Islands, Sri Lanka, Sudan, Suriname, Svalbard, Swaziland, Sweden, Switzerland, Syria, Taiwan, Tajikistan, Tanzania, Thailand, Timor-Leste, Togo, Tokelau, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Tuvalu, Uganda, Ukraine, United Arab Emirates, United Kingdom, United States, United States Pacific Island Wildlife Refuges, Uruguay, Uzbekistan, Vanuatu, Venezuela, Vietnam, Virgin Islands, Wake Island, Wallis and Futuna, West Bank, Western Sahara, Yemen, Zambia, Zimbabwe, European Union.

Page 12 of 13« First...910111213