Skip to content

Singapore HDB database

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.

From the main table, I created additional tables analyzing number of HDB residential blocks, MSCP, pavilions and miscellaneous buildings, number of units breakdown by flat type, etc, by HDB town, phase of development and building era. Watch video to see the completeness and quality of work!

The database been used 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. Regular citizens who want to view data about a couple of HDB blocks, can click blocks one by one HDB Interactive Map free of charge.

Purchase whole Singapore data sets

Last update with Dec 2023 BTO: 16197 buildings.

Free SAMPLES:
HDB Database with addresses only (11 columns)
HDB Database with address, unit numbers (13 columns)
HDB Database with address, year completed and lease date (15 columns)
HDB Database with address, number of units breakdown by flat type (37 columns)
HDB Database with address, year, lease, number of units, GPS coordinates (49 columns)
HDB Database with ALL OF THE ABOVE + more (66 columns)

Contact me for custom data subsets

  • HDB blocks built last # years (I provide you subset of specific building era), buying BTO era only is useful for real estate agents who want to spam flyers in the blocks that are going to fulfill their MOP. Price: 2x normal price per building, for one specific era, 1.5x normal price per building for multiple eras (like CRC + HS + BTO eras).
  • HDB blocks taller than # floors. Price: 2x normal price per building.
  • HDB blocks that contain certain flat types. Price: 1.5x-2x normal price per building.
  • Other sets of columns.

Purchase each HDB Town data subsets

About HDB Database

I started HDB database voluntarily in 2009, for purpose of researching housing density in selected estates and use the results in designing own apartment models. Being done without any specific target, I changed my mind numerous times and the database was MESS, initially having each town on a separate sheet, with different structure depending by the date I compiled. I abandoned project in 2011 after completing 40% of Singapore because it required too much effort for a non-paid job.

I published a sample on my website for first time in 2012 to get feedback from potential customers, and in 2014 I resumed working to complete remaining towns and harmonize data structure in a single sheet for whole Singapore, to offer as PAID service for professional use. I published final database in May 2015, after spending about 500 hours of work, estimating 10 sales/year, the effort would have been paid off in 5 years.

Following customer requests, I expanded database with additional columns: postal codes in June 2015, unit numbers in 2016, town council and electoral GRC / SMC in 2017. In August-September 2018 I spent additional 100 hours to count floors in Google Streetview… just to see in November that data.gov.sg offer “HDB Property Information” free of charge, including number of floors and number of units by flat type (but only for completed blocks).

Compared with data offered for free by government, my database include also demolished and under construction blocks, plus additional information such as postal code, unit numbers, BTO names, etc, however for most people, the free data sufficient, and my sales dropped.

Update frequency

I add new blocks as soon new BTO are launched (every 3 months), to display info on Interactive map of HDB blocks, also update older blocks data (adding lease date or adding tag “former” to blocks that have been demolished) every 6-12 months, plus random updates like adding floor plans. See more: history & changelog.

Most customers are doing one-time projects and not interested in updates. Early customers did not renewed subscription and dropping sales after 2018 left me in 2020 without any active subscriber for updates. If you are interested in updates please ask and I will publish for you!

Updates are FREE for 1 year, after which you can re-subscribe for another year by paying 25% of normal price.

How to use

As a researcher of Singapore history, I created this database intending to include all public housing buildings ever build in Singapore. SIT, HDB, EDB, JTC, HUDC, residential or auxiliary, standing or demolished. But I have trouble finding data for buildings demolished before mid-1980, because oldest Singapore Street Directory that include buildings is the 1984 one.

Database is optimized for on-screen visualization in Excel, visually enhanced with colors, borders and titles, but can be easily used in web development or mobile apps. Click filter box on any Address columns > choose (blanks) > select all rows > delete (this will remove estate header rows and non-HDB buildings found in HDB estates) > Save as > choose CSV > import in phpMyAdmin to get SQL file, or in other application.

Most customers may be interested only in standing residential buildings (no carparks, pavilions or demolished buildings) and may ask to buy subsets with standing residential blocks to get discount. I prefer to NOT sell subsets with only residential buildings, because will screw up the visual borders I added to separate precints and clusters of HDB blocks. And if I would have been to sell such subsets, I would charged (for all details package) 12-14 cents/building instead of 10 to maintain prices.

Statistics by building type

Total buildings: 16197 (as December 2023 update).
Residential flats: 11301 standing + 1537 demolished (including blocks with shophouses and no flats).
Multi-storey carparks: 1242standing + 4 demolished.
Pavilions: 980 standing + 7 demolished.
Houses: 116 standing.
Industrial buildings: 51 standing.
Other buildings: 781 standing + 106 demolished (commercial buildings, electrical sub-stations, etc).
Unknown buildings: 37 demolished.

Statistics by building era

1927-1960 (SIT era): 843 buildings.
1960-1981 (HDB classic era I): 3449 buildings.
1980-1991 (HDB classic era II): 3705 buildings.
1991-1998 (centralized refuse chute): 2100 buildings.
1997-2006 (household shelter): 1987 buildings.
2004-2015 (BTO era I income ceiling $8,000-10,000): 2405 buildings.
2015-present (BTO era II income ceiling $12,000+): 1707 buildings.
BTO era III will start in 2024 once HDB introduce new classifications of flats: standard, plus, prime.

Number of units is available for 10,757 blocks that were existing at least as 2010, including under construction blocks launched until November 2019 BTO. Total: 1,166,857 units, averaging 108 units per block. Every year, new blocks are completed while others are demolished, keeping this figure up-to-date is difficult. 1,063,250 dwelling units are in use as 31 March 2019 according HDB Annual Report.

Since 2018 HDB started publishing property information, year built and number of units for FREE download. While my own-compiled database contains additional info such as postal codes, upgrading programmes. brochures and floor plans, it seems that most people are interested only in number of units, very few are willing to pay for my additional info.

Most customers who previously purchased my database in 2015-2018 have not renewed their subscription, as 2020 I no longer have any customer demanding 3-month updates. I continue to add new BTO blocks in database every BTO launch, for purpose of displaying information for free consulting on HDB Map, but I will no longer post new HDB Database in Excel format for paid download unless someone purchase it and/or ask for an update.

Data fields included and their source

  • Block numbers: complete for all HDB blocks ever built.
  • Street address: complete except some of HDB blocks demolished before 2000.
  • Postal codes: complete for all residential HDB blocks standing as 2015 (including under construction).
  • Project name: complete for all HDB blocks that have a name (BTO blocks and old blocks that received precint name at upgrading.

Source: www.onemap.sg for current buildings, hm.onemap.sg or National Archive photos for demolished buildings. Block numbers 40% done in 2009-2010, remaining 60% done in June 2014. Street address sourced from Enquire status of upgrading programmes and later HDB Map Services, 30% done in 2010, remaining 70% done in December 2014. Postal code sourced from HDB Centralized Map. Personally not interested in postal codes, but in July 2014 a customer suggested adding them, a 2nd customer asked for postal codes in May 2015, so in June 2015 I added them. HDB Centralized Map added info boxes for under construction blocks in late 2016, allowing me to add in my database too at January 2017 update.

  • Town / Estate: complete for all Singapore. Town is official zoning while Estate is my personal classification by 175 phases of construction.
  • Project code & unit numbers: available for 4452 of 16197 total buildings, or 3887 of 4112 buildings built in BTO era.

Source: site plans from BTO and SBF brochures, added in 2016 at request from one customer. I know how useful would be to have the unit number ranges for every block, but this is NOT POSSIBLE. Hong Kong does have hk.centamap.com showing unit number and position. When Singapore is going to have the same? Going from block to block to check mailboxes and get unit numbers, takes more than a man’s lifetime.

In 2021 an agent spent few hours browsing SRX and added unit numbers for all blocks in Woodlands, I wanted to do the same for other towns, but SRX make this info available only for agents. Maybe if an agent share with me his login credentials?

  • Town Council and Electoral division (GRC / SMC): complete for all HDB blocks ever built.

Source: www.onemap.sg. I added Town Council in May 2017 at request from one customer, and electoral division in September 2017 at request from another customer.

  • GPS coordinates, latitude / longitude: complete for residential buildings.

A customer suggested me to add GPS coordinates in 2013, but writing coordinates manually was taking too much effort. Thank you to Renata who bought database in 2015, made a script to add coordinates from Google Maps API, but some were off. In 2017 I met Sik Shu Wei who made a script to extract coordinates from HDB Centralized Map and I integrated them into my database using VLOOKUP.

  • Building type: complete for all HDB buildings.
  • Building era: complete for all HDB buildings.

Some customers want to purchase a subset with recently build blocks. Filtering by lease commence date would have been difficult, because U/C blocks or under MOP do not have a lease date. Building era is based on major changes in HDB design, such as introduction of centralized refuse chutes and lifts stopping at every floor in 1991, household shelters in 1997, BTO scheme in 2004.

Consequently, I categorized myself the HDB buildings by type (in November 2014) and by 6 eras (in May 2016). I further improved building eras in September 2017 when I made Map of HDB blocks colored by year built, and as 2022 I re-categorized by 10 eras.

  • Building year: available for all buildings standing as 2018.

Source: CSV file provided by HDB since 2018. For some older buildings, I was able to get construction year from HDB Press Releases about SERS blocks or old newspapers seen at National Archive.

  • Demolition year: complete for all 1566 demolished buildings.

Source: estimation using old Street Directories (1984, 1988, 1991, 1993, 1995, 1998) or Google Earth satellite imagery (after 2000).

  • Lease commence date: complete for all residential blocks available on resale market (not available for blocks within MOP or rental blocks).

30% done in 2010 and remaining 70% completed in December 2014, source: HDB Resale Flat Prices, year only. Since 2015 I added month and day beside year, sourcing from HDB Centralized Map. In 2017 I added year-month-day lease commence date for all blocks (thank you Sik Shu Wei for providing me a script to extract data from HDB Centralized Map).

  • Estimated completion date: complete for blocks under construction or under MOP.

Source: BTO brochures. When blocks fulfill MOP I replace estimated completion date with lease date. Update frequency: when new BTO are launched.

  • Number of units (text form) & upgrading programmes: complete for residential buildings standing as 2010.

Source: Enquire status of upgrading programmes for blocks completed as 2015 (25% done in 2010, remaining 75% ON HOLD waiting for a customer paying me…. been paid in May 2015 and completed in June 2015.

A customer suggested to make separate column for each upgrading programme (MUP, IUP, LUP, HIP, NRP, SLRP) and indicate announcement date and billing date. Re-compiling upgrading programmes information will take a large amount of time so I am waiting to see if there are other customers interested.

  • Number of units breakdown by flat type in separate columns: complete for all residential buildings.

Idea used since 2011 for List of BTO projects. In 2014 I planned to use idea for HDB Blocks Database too, and did the job for SAMPLE file that included Jurong West, while for rest of towns I done in June 2015, time when I added also breakdown by flat type of number of units at the time block was completed, beside current figure sourced from Enquire status of upgrading programmes. (number of units is VARYING over time due to adjoined flats).

Since 2016 I add number of units as soon new BTO are launched, source: site plans from BTO / SERS / SBF brochures.

  • Number of floors, units per floor, estimated number of units: complete for 95% residential buildings.

40% done in 2009 I estimated number of floors for about 40% of blocks, by measuring shadow length in Google Earth (error margin +/- 1-2 floors). Once Google Streetview was launched in Singapore in December 2009, I accurately counted floors for 20% of blocks during 2010.

Exact number of units became available in HDB enquire status of upgrading programmes in 2010, I no longer needed to multiply floors with units per floor, consequently in 2014 I decided to add remaining towns and complete the HDB database without number of floors. In 2015 a customer (Renata, see her comment) offered me a BONUS of $400 to complete number of floors for remaining 40% of blocks, but after doing half of job she told me to STOP THE JOB because her boss don’t want to pay.

Virtual Singapore, a very detailed 3D map, was announced in 2015 to be ready in 2017. In August 2017 it was announced that will be ready in July 2018. Virtual Singapore would have helped me counting floors easier and accurately than in Google Street View. In mid-2018 another announcement said that map will be ready in 2018 for government agencies while public access will be few years later.

Meantime Google Earth launched in August 2018 its own 3D map for central Singapore, expanding it to North and West over next months. Even if not whole Singapore is available in 3D, I got personally interested to count floors, I used Google Street View where 3D map was not available, and by September 2018 I finished counting floors of 95% of HDB blocks, correcting all errors at blocks where I previously estimated height from shadow length.

  • Block model by Teoalida: I invented myself a naming system for purpose of displaying floor plans in /singapore/hdbfloorplans/

Added since 2009, I renamed block names over time and currently harmonized them for most common HDB blocks. In case of old SIT blocks with many distinctive models, building descriptions are a bit messy.

  • Individual unit floor plans: available for 90% of blocks built up to 1997, 60% for 1997-2004 and 40% for 2004-present available on resale market.
  • BTO launch brochures: available for BTO projects launched in 2010-2014.
  • BTO full brochures: available for BTO projects launched after 2012.
  • SERS full brochures: available for SERS replacement blocks announced after 2008.

Added since September 2017.

  • SERS prediction by Teoalida: I personally indicated whenever blocks can get SERS or not, only (some of) pre-1980 blocks may be selected for redevelopment. There are 13 different pieces on text under SERS prediction.

Anything else to add? Your ideas are welcome!

HDB units database

Several people told me that require a database with 1 row for each unit instead of 1 row per building, for mailing. In theory I can create such database based on BTO brochures, but will take so much time and inability to do older blocks will results in an incomplete database that will hardly get sales to cover my effort.

In 2016 a property website wanted to hire me to expand their database, and sent me HDB units database.csv (111 units from block 24 Tanglin Halt Road, don’t ask for other blocks because this sample CSV all what they sent me).

I heard afterwards that SingPost sell such unit numbers database for $10,000 and I assume that above property website has bought from SingPost. I do not know if $10,000 database include only HDB or also private housing, commercial and industrial units, etc. If anyone buy from SingPost, I appreciate if can share with me (I can pay a part of this price) so I can modify database to appear made by me and give it to other people needing the same.

That property website wanted my research service to add columns with number of bedrooms, bathrooms and floor area in sqm. While I can tell the flat type of any unit, by viewing HDB block in Google Streetview, I do not know position within block of each unit stack, would require going to block to block and see unit numbers map, overall the job would take a man’s life and is highly prone to mistakes and lack of accuracy, because:

In case of BTO blocks, while 4-room flat size is stated in brochure to be 90 sqm, there are stacks in which is 91-92 sqm. Same stack may have some floors with balconies (adding 2-3 sqm) and other floors not.

In case of old blocks some flat owners bought recess space while others not. Some <3-room flats have been adjoined.

Tags:

44 comments

  1. Love the work you are doing here! it’s very useful information, not only for work purposes but also out of pure curiosity. it would be amazing to see this HDB database.

  2. The HDB database is displayed on website since August 2012 and as March 2013 only 3 people showed interest in it, but NONE of them gave a reason good enough to maintain such HDB database. Here is the one:

    [16:46] Visitor: I think the database could be very useful public and professional resource. Do you know if the HDB or URA have a similar database?
    [16:47] Teoalida: HDB have but you can’t see all blocks at once
    [16:47] Teoalida: Could be very useful FOR WHAT?
    [16:47] Teoalida: Nobody showed any interest in it
    [16:47] Teoalida: despite that is on website for 8 months
    [16:48] Visitor: town planning maybe?
    [16:48] Visitor: the architects might find it useful
    [16:49] Teoalida: Give me a GOOD reason to spend several hundred hours for it
    [16:49] Teoalida: might find it useful… can you tell me more exactly? what data is useful?
    [16:49] Teoalida: street address, number of units (total or by flat type) or… ?
    [16:52] Visitor: honestly I am not sure, so it’s a bit hard to site concreate examples
    [16:53] Teoalida: This is their database http://services2.hdb.gov.sg/webapp/BB33RESLSTATUS/BB33PReslStatusEnq.jsp
    [16:54] Teoalida: I have used it to correct the number of units in my table (which previously was done by multiplying floors with units per floor)
    [16:55] Teoalida: Copying the number of units take 1 min per block, finding street address and block year take another min, multypling with approximately 10000 blocks = may need 333 HOURS of work
    [16:57] Visitor: so what make you start doing it in the first place
    [16:58] Teoalida: You don’t understand by reading the page?
    [16:58] Teoalida: “I made it just for purpose of studying housing density in selected estates and use the results in designing apartments.”
    [17:04] Teoalida: What is the max sum you would pay for a such database?
    [17:08] Visitor: I guess it would always be difficult to sell data like these because everyone expects it for free from the government
    [17:09] Teoalida: what the government offer FREE cannot be used for counting blocks or flats, especially by flat type
    [17:10] Teoalida: So you want to count the point blocks? nothing else? I need to know what other people want
    [17:10] Teoalida: but probably they don’t want anything…. so far you’re the only one

  3. I think there is huge potential, especially from housing agents although most of them will not want to pay a single cent if they can get away with it.

    Don’t believe those that want to derail you – you don’t find another website that offer the same service as you do and that is proof enough that what you are doing is something people will want.

    For example, every listed company will release their own earning reports every year. This is open information but there are trading houses / fund managers who charge (or offer only to their customers) special reports that compare different companies and provide insight.

    I prefer not to have my comments published but feel free to contact me via email.

    1. Why you do not answer what layout should have the table, to have that huge potential?
      This project is just… bad ratio effort&time / revenue. I am currently working in more profitable projects.
      And if do not want comment to be published, why did you posted it instead of emailing me directly?

  4. Look at this “buyer”…

    I hate such people! Potential customers who quit because I don’t have the database completed! Without giving any info about how they use the database how I am supposed to complete it?

    HDB Database is ON HOLD until I find a SERIOUS customer!

    Update: After few months I think that was better to say “I sell the SERVICE of completing the database” instead of “I don’t sell incomplete…

  5. Hi bro, would you be able to find out the unit numbers of each hdb block? Like for example amk central block 123 #01-001 to #01-020.

    1. This is NOT possible at this moment.
      Hong Kong does have http://www.centamap.com showing unit number and position but Singapore don’t have such map yet. Would be handy if we could make one.
      As side question, if would have been possible to add unit numbers in my Excel database, how much you would pay for it? If you are the type of person who want just to consult freely the database, sorry but I am not willing to spend 400 hours and give this for free.

    1. Can you please tell me your budget and when do you need the database finalized? Also some info about you, what is your profession or how do you use the HDB database? Viewing in Excel or importing in some other database?

      My price would be $1000 for accurate number of units (20% done so far)… or $500 for estimated number of units, number of floors x units per floor counted in satellite photo (30% done so far)
      Sorry for possible high prices but TIME IS MONEY. This job may still take 1 month or more IF I would not have any other customers, and would give me a revenue of $5 per hour. But I have many other customers too, hiring me for CAD design services, who are paying $20-30 per hour. Would you cancel such profitable projects in favor of HDB Database?
      The fact that you are probably the 3rd serious customer in 1 year made me willing to continue and finalize the HDB Database as soon I have enough time.

      I am also working at THIS database which keep me busy until November, these things have few buyers per month. For HDB Database I estimate a potential of few buyers per year. If you want to prioritize your project, you should give me big $$.

    2. I emailed him 2 times to get a meaningless reply “hi, i dont need the data already. thank you.” Sounds a TYPO!
      Do you mean that you do not need the data yet, or need the data right now and cannot wait for me to make it?
      With such customers not answering my questions, how I am supposed to know what structure to use in database, to compile it before the next customer is coming?

  6. Given by few apparent potential customers, I announce that this month

    I completed the street address and building years for all HDB blocks.

    Who need this info can purchase immediately the HDB Database LITE version from https://www.teoalida.com/store.
    Who need also number of units and upgrading programmes can pay 50% now, 50% after completing this info (can be completed in 1 month, starting from the date of 50% payment).

  7. I just purchased the Singapore HDB database (detailed). The purchase was very smooth and efficient. A few seconds after I sent the payment via PayPal, I got an email with a link to download the database Excel file. The download worked perfectly.

    Teoalida was also very helpful by answering my questions about the database before I purchased it. I had questions about the completeness and definition of some of the attributes and Teoalida gave me all the information I needed. I have not been able to find a comprehensive database like this, with units information, building type, and lease year anywhere else online. Thank you Teoalida for providing this service!

  8. This month I completed also number of units and upgrading programmes for whole Singapore!

    Here is another visitor who provided some kind of “idea” but without fully explaining the idea, especially how it could be used

    Chat started on Tuesday, June 23, 2015 7:25:09 PM
    (7:25:09 PM) *** Visitor has joined the chat ***
    (7:25:10 PM) Visitor: just sharing and brainstorming only. not really a user of hdb db. just trying to help out
    (7:25:23 PM) *** Teoalida has joined the chat ***
    (7:25:26 PM) Teoalida: help with what?
    (7:25:36 PM) Visitor: hdb itself is a block of bicks and mortar
    (7:26:07 PM) Visitor: there does not seem to be any interest in hdb database unless there is data about the people living in the hdb
    (7:26:35 PM) Visitor: but this concept will be a bit challenging since it touche upon personal data
    (7:26:36 PM) Teoalida: personal data?
    (7:26:45 PM) Teoalida: how this would be interesting?
    (7:26:47 PM) Visitor: which now falls under private data act
    (7:27:01 PM) Visitor: just an idea that’s all.
    (7:27:16 PM) Visitor: people are living things. that make nonliving things interesting
    (7:27:40 PM) Teoalida: if you think that is useful, even impossible to compile, provide legit reasons how personal data COULD be used
    (7:28:09 PM) Visitor: just an idea.
    (7:28:19 PM) Visitor: good night
    (7:28:25 PM) Teoalida: what is the idea?
    (7:28:59 PM) Teoalida: Note that current database have 1 row per block… the database you propose what should have? 1 row per RESIDENT?
    (7:29:14 PM) *** Visitor has left ***

Leave a comment

Your email address will not be published. Required fields are marked *