Map of HDB blocks in Singapore

Map of HDB blocks

An interactive map “Made by Teoalida” as alternative with HDB Map Services. Click block pins and view year built, number of floors, number of units breakdown by flat type, upgrading programmes, typical floor plans, chances to get SERS, etc. You can also apply filters to display on map only HDB blocks that meet certain criteria.

HDB Executive Apartment floor plan

HDB history and floor plan evolution 1930s – 2020s

This page shows floor plans of ~100 most common HDB flat types and most representative layouts. Many other layouts exists, unique layouts with slanted rooms, as well as variations of the standard layouts, these usually have larger sizes.

Ang Mo Kio, Bedok, Bishan, Bukit Batok, Bukit Merah, Bukit Panjang, Bukit Timah, Central Area, Choa Chu Kang, Clementi, Geylang, Hougang, Jurong East, Jurong West, Kallang/Whampoa, Marine Parade, Pasir Ris, Punggol, Queenstown, Sembawang, Sengkang, Serangoon, Tampines, Tengah, Toa Payoh, Woodlands, Yishun.

HDB BTO brochures

List of HDB BTO brochures

I collected PDF brochures of BTO projects since 2010, downloading them from HDB website in my computer and uploaded on my website because HDB delete them after 3 years and many people are needing brochures of older projects, especially when applying via Sale of Balance Flats.

List of BTO projects

List of HDB BTO projects

Build-To-Order was introduced in April 2001, currently new BTO flats are launched for sale in February, May, August, November. Future BTO locations are announced 6 months in advance, but exact day of launch is not known. This sable shows BTO names, town, launch date, estimated completion date, number of units breakdown by flat type, plus statistics such as average apartment size.

Singapore HDB Database

Database of HDB blocks in Excel format

HDB Database is an original compilation “Made by Teoalida” which took over 500 hours of work. Collecting data from multiple sources, I manually entered data in one Excel table for all HDB blocks ever built in Singapore, indicating block number, street address, postal code, GPS coordinates, construction year, lease commence date, number of floors, number of units breakdown by flat type, upgrading programmes, brochures and floor plans.

The database has been purchased by several companies, including home insurance, telecommunication, door-to-door services, real estate portals, flyer distributors, as well as many people who did not told me what business field they are in. Season parking.

HDB Resale Price Index

HDB price trends

HDB Resale Price Index DOUBLED from 2007 to 2013, dropped slightly to 2015 then stabilized. However, due to high supply of flats completed in 2014-2017 that enter on resale market since 2019, prices were likely to drop more in the coming years… however the unexpected Coronavirus pandemic, instead of causing a global recession like in 1997, 2003 or 2009, it made HDB prices to rise sharply in 2020, probably because singaporeans afraid to go tourism, invest more money in their homes. Price evolution is harder to predict nowadays due to uncertainty of global pandemic.

Map of condos in Singapore

Map of private properties

An original project “Made by Teoalida” displaying data from PropertyGuru on an interactive map. Click condo pins on map to see details about each property such as address, completion year, tenure, number of units, developer, etc. You can also apply filters to display on map only HDB blocks that meet certain criteria.

Car Models Engines All Details Database

Car database in Excel

List of car makes, models, trims, engine versions, specifications and features. All automobiles sold in Europe, America, Middle East, India, Japan, Australia, etc. I started this project voluntarily in 2003 and since 2012 the hobby turned into a business, databases been purchased by companies including car parts, dealers, tuning, classifieds, shipping services, insurance companies, web designers and mobile app developers. I am planning to offer in the future also API SaaS web service beside Excel download.

House design

House models designed by me

50+ house floor plans and 3D models designed by me from personal interest (artistic hobby / training) as well as for various customers. A mix of architectural design styles inspired from Singapore, Malaysia, Philippines, India, Europe, America and many others. I keep my past works here to offer ideas for students. View for free, pay and download AutoCAD DWG files.

HDB dwelling units per town and flat type

HDB statistics, facts & figures

– Number of dwelling units by town and flat type, table and chart
– Number of dwelling units by town and year 1990-2019, table and chart
– Number of dwelling units by flat type and year 1990-2019, table and chart
– Statistics for calculation of the average flat size along history
– HDB achievements since 1960
– Resale market statistics

Mobile Phones Database

Mobile phones database

I created an Excel database containing over 11,000 devices from 1994 cell phones to modern smartphones, tablets and smartwatches, with 88 columns of specifications. Useful if you want to create a website, use in a GSM shop or anything similar. I offer FREE monthly updates and weekly updates for $100/year.

HDB flat types

HDB flat types and their sizes

Flat types guide: 1E, 2E, 1STD, 2STD, 3STD, 4STD, 5STD, 1I, 2I, 3I, 4I, 5I, 3NG, 4NG, 3S, 4S, 3A, 4A, 5A, EA, EM, MG, HUDC… Studio Apartment, 2-Room Flexi, 3-Room, 4-Room, 5-Room, Emergency, Standard, Improved, New Generation, Simplified, Model A, Executive Apartment / Maisonette, Multi-Generation, Standard vs Premium apartment.

Index of databases made by Teoalida

During my live I made over 100+ databases, from personal interest to distribute freely or sell for professional use. Some projects I made at request and published on website to allow other customers to purchase if interested. They have been used by numerous people from students practicing data analysis, to multi-national companies in real estate and automobile industry. I offer web scraping services in VB.NET and Python, making custom databases according your requirements. I work in Word and Excel, other file formats available: CSV, SQL, XML, JSON.

Braddell View HUDC

List of HUDC estates

Officially there are 18 HUDC estates, but actually Housing and Urban Development Company built 22 estates for middle-income people, including 3 not managed as public housing and one demolished in 1990s. HDB took over JTC and HUDC in 1982. Phase III and IV are HUDC flats built by HDB, last HUDC was completed in 1987. HUDC was replaced by Executive HBD flats built since 1984.

Apartment design

Apartment models designed by me

Here are my best designs made by me from personal interest (artistic hobby / training) as well as for various customers, from 2008 to around 2016 when I retired from architecture for more profitable IT industry. While I am not making new designs anymore, I have over 100 designs (editable AutoCAD DWG files) available for download.

Princess Elizabeth SIT blocks

List of HDB SERS sites

Selective En-bloc Redevelopment Scheme was introduced in 1995. 71 sites were selected by 2007 and another 10 sites in 2008-2018. This page shows list of SERS sites and (personal prediction) future SERS sites. On 19 August 2018 HDB announced that only 5% of total sold flats are eligible for SERS, of which 4% have been selected already. For all other flats there will be VERS (Voluntary En-bloc Redevelopment Scheme) that will start in ~20 years (probably in 2036 when first leases reach 70 years old).

HDB flats size over years

HDB flats size 1960-2010 analysis: are the flats shrinking?

Ministry of National Development, Khaw Boon Wan, said in 2012 that HDB flats have been the same size for last 15 years and are not shrinking. This article has been copied on numerous blogs.

As you can see in the following chat, the 4-room flats leased in 2000 were 90 sqm and 4-room flats launched in 2012 (TOP 2016) are the same 90 sqm, so he is not lying, instead he is masking the shrinking that occurred 15-20 years ago, also he does not take in consideration that the 4-room flat was the smallest flat type in 2000, while today it is the average flat type.

Housing Design

My career as architectural designer and “Teoalida’s Virtual City”

I started self-studying architecture in 2008 and designed “Teoalida’s Virtual City”, originally a hobby of graphic design and 3D modeling in AutoCAD, but a fully functional housing system. Many people contacted me for architectural design services. But simply answering chats and emails, discuss project requirements to quote a price, is a waste of time if 90% never pay, only 10% have paid me and only after seeing (part of) work done. Once got paid, some customers were not satisfied or changed mind so I had to do changes (delaying me from doing other jobs) then I cannot sell same design to multiple people (like how I sell databases) because in architecture each customer have different requirements, making whole profession of architect a waste of time.

This article must be read by all students BEFORE choosing architecture universities, to understand what you should expect and not make same mistake like me!

condominium

List of Executive Condos

Executive Condominium (EC) is a form of subsidized housing built by private developers, having same eligibility restrictions like HDB (family nucleus, citizens and permanent residents), you should dispose any other property 30 months before applying, minimum occupation period of 5 years before you can sell to citizens and PR, even single PR. After 10 years since TOP date, all restrictions are lifted and even single foreigners can buy. I made an interactive map with TOP dates.

World Cities Database

World cities database

Worldwide cities database organized by country, state and province, with city population indicated. An original product “Made by Teoalida” that you will NOT find elsewhere on internet, compiled by me since 2003 and gradually expanded over years, based on Microsoft Encarta Encyclopedia. Currently it include over 16000 cities, more exactly ALL cities in the world with population over 20,000 people.

Architectural drawing

Architectural design services – procedure and pricing

In 2012-2016 I designed myself houses and apartments for dozens customers. Currently I have a team of 5 architects, located in India, Nigeria, Philippines, Romania and United States, who offered to work for me if I am too busy, but seeing their high experience and cheap prices I decided to pass them ALL architectural projects, to free my time so I can focus on IT / data providing industry.

Web scraping services

I offer data mining and web scraping services. “Scraping” usually means coding a bot that visit a list of given pages, copy specific data from each page and put it in an Excel / CSV file automatically, at rate of few pages per second. Watch the video!

If you are building a website, a mobile app, or just require specific data but cannot find in usable format, just give me link to a website having required data, I will make a scraper and turn website into an Excel database, for you and for future customers.

Excel, XLS, XLSX, CSV, SQL, XML, JSON

The world of Teoalida

About me – resume – portfolio – fields of activity

I am Teoalida and I love doing research, collecting information, writing articles and making databases about real estate, cars, and other fields, as well as designing own housing models. Also playing games with buildings. I made this website since 2009 to share knowledge and educational material, sell my works and promote my services, and make new (business) friends.

If you have any enquiry about AutoCAD, architecture, real estate, databases, research, data mining and analysis, or any other stuff covered by articles of this website, comments about my works, errors to report, suggestions, critics, etc, feel free to contact me, please use Live chat whenever is possible, alternatively use Skype, or email me [email protected].

Music database

Music Database

We all love music, but I may be the only person who made an Excel database and show to everyone what are my musical preferences in the style of a data scientist. Since 2005 I use Excel to organize the music I am listening, rate each songs from 0 to 16, then use complex mathematical formulas to calculate scores and rank best artists, best albums, best music genres, etc.

Football stadiums database

Football Database

Download free SAMPLE: 2018-FIFA-World-Cup.xls

Took me about 5 minutes to compile this table sourcing data from Wikipedia using “XPath Helper” extension for Chrome.

If you are interested in similar table for all FIFA World Cups 1930-2018, UEFA Euro Cups and other football tournaments, please contact me.

Screen resolution statistics

Screen resolution statistics

As graphic designer and enthusiast in computer history, I became curious how the monitor dimensions evolved over the years and analyzed which screen resolutions were most popular, so I created these Excel files: