Database of HDB blocks in Excel format

The HDB Database involve collecting data from multiple sources and typing it in one Excel table, an original compilation Made by Teoalida. 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.

I offer 5 standard packages, containing block number, street address, building name, building type, building era, postal code, plus some specific details shown below. You can purchase a smaller package then upgrade to a bigger package paying difference. For custom packages or additional data that is not yet included in database, contact me!

Instant download! Pay via PayPal or credit card and receive automatically an email with download link (example email).
FREE updates every 3 months for one year! Pay 50% per year for next years! See also Terms and conditions!

If you want to view data of ONE block instead of buying complete database, you can view for FREE on HDB Map.

HDB Database, block number, street address, postal code

No additional details

Buy & download

Free SAMPLE

HDB Database, block number, street address, postal code, unit numbers

Unit numbers

Buy & download

Free SAMPLE

HDB Database, block number, street address, postal code, built year, GPS coordinates

Lease date & GPS coordinates

Buy & download

Free SAMPLE

HDB Database, block number, street address, postal code, number of units breakdown by flat type

Number of units breakdown by flat type

Buy & download

Free SAMPLE

HDB Database, block number, street address, postal code, lease commemnce date, number of units breakdown by flat type, upgrading programmes

All details (unit numbers, lease commence date, GPS coordinates, number of units breakdown by flat type, upgrading programmes, etc)

Bonus: number of floors and units per floor, building description, links to most common floor plans, SERS prediction by Teoalida.

Buy & download

Free SAMPLE

All details, purchase just your preferred towns!

Price: 10 cents per building. If you purchase 3 towns, price will be 9 cents, if you purchase 5 towns, price will be 8 cents. Contact me for discount!

Buy & download
Number of blocks and dwelling units by HDB town
Summary
Summary file does contain number of HDB buildings breakdown by type and number of dwelling units breakdown by flat type, for each HDB town, phase of development, town council and electoral division. Does NOT contain individual HDB blocks.
Buy & download

HDB Database statistics

Total number of tagged HDB buildings in database: 15092 (after Nov 2018 BTO update).
Database include also few hundred non-HDB buildings (not tagged, not included in this count).

Breakdown by building type tag:
Residential flats: 10779 + 1398 demolished (including blocks with shophouses and no flats).
Multi-storey carparks (MSCP): 1106 + 4 demolished.
Pavilions: 829 + 7 demolished.
Houses: 114.
Industrial buildings: 51.
Other buildings: 649 + 105 demolished (commercial buildings, electrical sub-stations, etc).
Unknown buildings: 40 demolished.

Breakdown by building era tag:
1927-1960 (SIT era): 819 buildings.
1960-1982 (HDB classic era I): 3447 buildings.
1981-1993 (HDB classic era II): 3645 buildings.
1992-1999 (centralized refuse chute): 2100 buildings.
1998-2007 (household shelter): 1978 buildings.
2005-present (introduction of BTO scheme): 3053 buildings.

Number of units is available for 10,645 blocks that were existing at least as 2010, including under construction blocks launched until November 2018 BTO. Total: 1,148,936 units, averaging 107.93 units per block. Every year, new blocks are completed while others are demolished, keeping this figure up-to-date is difficult. 1,047,350 dwelling units are in use as 31 March 2018 according HDB Annual Report.

Data currently included

– Block numbers: complete for all Singapore. Source: www.onemap.sg.
(40% done in 2009-2010, remaining 60% done in June 2014)

Building name: complete for all blocks that have a name. Source: www.onemap.sg.

Street address: complete except blocks under construction and blocks demolished before 2000. Source: Enquire status of upgrading programmes.
(30% done in 2010, remaining 70% done in December 2014)

Town / Estate: complete for all Singapore. Town is official zoning while Estate is my personal classification by phases of construction.

Town Council: complete for all Singapore. Source: www.onemap.sg.
(added in May 2017 at suggestion from a customer)

Electoral division (GRC / SMC): complete for all Singapore. Source: www.onemap.sg.
(added in September 2017 at suggestion from a customer)

Construction code & unit numbers: available for 3011 of 14586 total buildings, or 2464 of 2666 BTO era buildings.
In 2016 a customer suggested adding unit numbers. Source: site plans from BTO and SBF brochures, available for 90% of BTO era blocks and for random pre-BTO blocks which HDB offered site plans at Sale of Balance Flats.
I know how useful would be to have the unit number ranges for every block, but this is NOT POSSIBLE. Hong Kong does have www.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.

Building type tag: complete. This column act also as filter, non-HDB buildings have it left empty, who wants a simple list of HDB buildings can filter it to delete empty rows (estate header row, schools, condos, etc). Flats / MSCP / Pavilion / Other + Demolished tags, so the real estate agents can filter and delete demolished buildings, while historical researchers (like myself) can keep them.
(added in November 2014)

Postal codes: available for 12966 buildings standing as 2015 or under construction. Source: 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.

GPS coordinates, latitude / longitude: complete for residential buildings.
Suggested by 1 people in 2013, too hard task to write coordinates manually, NOT in mood to do it, but DONE in 2015 thanks to Renata who bought my database and made a script to run in Google Maps API and add coordinates. In 2017 I met Sik Su Wei who made a script to get coordinates from HDB Centralized Map and I integrated them into my database using VLOOKUP function of Excel.

– Lease commence date: complete for all blocks available on resale market (so NO year for carparks, rental blocks, or blocks within MOP).
(30% done in 2010 and remaining 70% completed in December 2014, year only, source: HDB Resale Flat Prices.) Since 2015 I started to improve by adding month and day, sourcing 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.

Update frequency for above items: every 3 months when new BTO are launched. Also adding old demolished blocks when I discover them on hm.onemap.sg or National Archive photos. My ULTIMATE GOAL is to have in database all SIT/HDB blocks ever built.

Building year: available for 505 buildings. HDB never publish actual building date, except when the block is selected for SERS. I have indicated the building year in database only for SERS blocks and for the blocks who were leased significantly later than their actual construction date. The building year is sourced from old newspapers seen at National Archive (if possible), otherwise estimated using old Street Directories.

Demolition year: complete for all 1448 demolished buildings. Source: estimation using old Street Directories (1984, 1988, 1991, 1993, 1995, 1998) or Google Earth satellite imagery (after 2000).

Number of units (text form) & upgrading programmes: complete for residential buildings. 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 (complete for all blocks that were standing to at least 2010).

Number of units breakdown by flat type in separate columns: complete for all residential buildings (about 9500 buildings). Idea used since 2011 for List of BTO projects. In 2014 I planned to use it in the future for HDB Blocks Database too. I decided in June 2015 to breakdown original number of units beside current number of units which is varying over time.
(done in 2014 only for Jurong West for showing SAMPLE file. Breakdown done in all towns in June 2015). Since 2016 I add number of units when blocks are launched rather than when completed, source: site plans from BTO / SERS / SBF brochures.

Note: number of units is VARYING over time in blocks with 1/2/3-room built up to 1990, due to people who buy 2 flats and adjoin them.

Update frequency: I add number of units for new HDB blocks when new BTO are launched, but I will NOT offer updates for block built up to 1990, would take large amount of time to reached every block and benefits are insignificant. They will remain “as 2015”.

Number of floors, units per floor, estimated number of units: 40% done in 2009 estimated from shadow length in satellite photos, before Google Streetview introduction, may have errors +/- 1-2 floors, additional 20% done accurately in 2010 by counting blocks in Google Streetview.
In 2014 I decided to complete database without number of floors because it was taking too much effort and I believed that it is no longer needed, precise number of units became available in HDB enquire status of upgrading programmes, no longer need to multiply floors with units per floor.
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.
I can resume the job and do remaining 20% if another customer is interested in paying a BONUS for completing number of floors. If do you want also to count the 40% estimated in 2009-2010, I can do if I have sufficient time, and you need to pay my time.

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 3D map for Singapore in August 2018 as it had for many other cities around the world. Even if not whole Singapore is available in 3D, I got interest 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!

Anything else necessary? Your ideas are welcome!

History (short version)

I started compiling data voluntarily in 2009, purpose: personal research about housing density in selected estates and use the results in designing own apartments, I abandoned in 2011 after completing 40% because it required too much effort for a non-paid job.

Being a voluntary project done without any specific target, I changed my mind numerous times, making the database a MESS, table layout being different from town to town depending by the date each town was compiled.

In 2012 I published on website a SAMPLE with one town, as marketing experiment, to see who (if anyone) is interested. I was willing to re-compile entire database, this time as PAID service for professional use. I hoped people to tell their requirements or suggest changes in data structure, negotiate a price based by amount of effort needed to compile the data, then do the job… but I was facing with lack of feedback, LAZY customers do not inform me exactly what data are looking for!

Took 2 years to get a rough idea what people are looking for… and resumed working in July 2014, I done A LOT of changes in data structure, cleaned (most of) mess and standardized database format across all towns, completed whole Singapore in December 2014 in terms of block number, address and lease year. Number of units remained as done in 2011 (25% completed), the rest 75% will be done AFTER finding a customer willing to pay 50% before 50% after. The long-waited customer came in May 2015, work started, completing number of units for ALL 10,000+ blocks by June 2015! As customers requested, I added also postal codes in June 2015 and unit numbers in 2016, town council and electoral GRC / SMC in 2017.

Total: hundreds hours of research and data entry work!

I update HDB database every BTO launch (every 3 months), each update taking about 3 hours, plus other updates to add additional data (if new ideas comes in my mind). You can suggest your own ideas what other data to add!

Read more: history (full story) & changelog.

40 comments

12 pings

Skip to comment form

  1. It’s really a nice and useful piece of information. I am happy that you simply shared this useful information with us. Please stay us informed like this. Thank you for sharing.

    • Shu on February 27, 2013 at 8:23 am
    • Reply

    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

    • Visitor on September 16, 2013 at 5:46 am
    • Reply

    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?

  3. 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…

    • David on April 22, 2014 at 11:07 pm
    • Reply

    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. […] Construction batches have no importance for buyers. I made for ONE town, as simplified version of database of blocks. Give me a reason to make a nationwide list of pre-BTO […]

  2. […] I did not had any other customers to work for, working in Excel is a pleasure and I made also the Singapore Housing Database, for pure pleasure, without even having a customer requesting to do this […]

  3. […] in 2001 but couldn’t do anything serious until getting internet connection in 2005. – The HDB database, table of buildings in Singapore, started in 2009. – The Hong Kong housing database, table with 400 […]

  4. […] Database of blocks, there are about 9000 residential HDB buildings in Singapore (not including carparks, shops, etc) […]

Leave a Reply

Your email address will not be published.