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.
Free sample: HDB Database (full details package)
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.
Instant download! Pay via PayPal or credit card and receive automatically an email with download link (example email).
Due to rising international popularity of other projects I had to change prices from SGD to USD in July 2020, if you want to pay price in SGD, message me via chat when I am online and I will change currency for few minutes.
2021 sample for FREE download
HDB Database with ALL details (79 columns)
HDB Database with addresses only (11 columns)
HDB Database with address, unit numbers (13 columns)
HDB Database with address, GPS coordinates (13 columns)
HDB Database with address, year completed and lease commence date (15 columns)
HDB Database with address, upgrading programmes (12 columns)
HDB Database with address, number of units (34 columns)
HDB Database with address, year, lease, number of units, GPS coordinates (50 columns)
HDB Database with ALL OF THE ABOVE (66 columns)
Purchase whole Singapore data sets
Purchase each HDB Town data subsets
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.
- Anything else that come in your mind.
About HDB Database & update frequency
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, each town being a separate table with different structure depending by the date each town was 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 see if anyone is interested, and in 2014 I resumed working to complete remaining towns and harmonize data in a single table for whole Singapore, as PAID service for professional use. I finalized database in May 2015, after spending about 500 hours of work, and published it for sale, estimating 10 sales/year, the effort would have been paid off in 5 years.
I kept expanding database with additional columns requested by customers, for example I added 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 freely available data, 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.
I continue to update my database by adding new BTO launches 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 for blocks that don’t have any floor plan yet.
But due to poor sales of Excel database I may not publish new Excel files for download every time I update database, especially since most customers are doing one-time projects and not interested in updates. If you are interested in updates please ask and I will publish for you!
I offer FREE updates for 1 year, after which if you want to continue downloading updates you can re-subscribe for another year at 25% of normal price.
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.
The HDB database is optimized for on-screen visualization in Excel, visually enhanced with colors, borders and titles, but I made it to be easily used in web development or mobile apps too. Click filter box on any Address columns, Building Era or Building Type > choose (blanks) > select all rows > delete (this will remove estate header rows, schools, places of worship and other non-HDB buildings found in HDB estates) > Save as > choose CSV > import in phpMyAdmin to get SQL file, or whatever application you are using database in.
I know that most of you are interested only in residential buildings that are currently standing (excluding carparks, pavilions or demolished buildings) and may ask to buy subsets with standing residential blocks to get a 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.
HDB Database statistics
Total number of tagged HDB buildings in database: 15283 (as Nov 2019 update).
Database include also few hundred non-HDB buildings (not tagged, not included in this count).
Breakdown by building type tag:
Residential flats: 10820 standing + 1472 demolished (including blocks with shophouses and no flats).
Multi-storey carparks: 1125 standing + 4 demolished.
Pavilions: 851 standing + 7 demolished.
Houses: 114 standing.
Industrial buildings: 51 standing.
Other buildings: 681 standing + 108 demolished (commercial buildings, electrical sub-stations, etc).
Unknown buildings: 39 demolished.
Breakdown by building era tag:
1927-1960 (SIT era): 819 buildings.
1960-1981 (HDB classic era I): 3437 buildings.
1980-1992 (HDB classic era II): 3702 buildings.
1991-1998 (centralized refuse chute): 2097 buildings.
1997-2006 (household shelter): 1989 buildings.
2004-present (introduction of BTO scheme): 3228 buildings.
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 3596 of 15283 total buildings, or 3029 of 3235 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.
- 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 I considered too hard task to write coordinates manually. In 2015 Renata who bought my database and made a script to run in Google Maps API and add coordinates, 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.
I categorized myself the HDB buildings by type (in November 2014) and into 6 different eras (in May 2016) because someone wanted 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 mode of sale in 2004. I further improved building eras in September 2017 when I made Map of HDB blocks where color of each dot indicate building age.
- Building year: available for all buildings standing as 2018.
Source: CSV file provided by HDB. building year is available for some of the older buildings, 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 thanks to Sik Shu Wei script.
- 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 when blocks are launched rather than when completed, 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.
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.
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.
- Building description by Teoalida: I invented myself a naming system for purpose of displaying floor plans in /singapore/hdbfloorplans/
Added since 2009, I renamed building descriptions 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 80% of pre-BTO-era blocks (built up to 2004).
- 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 in 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 – this sample CSV all what they sent me, I do not have other blocks, don’t ask).
Later other people told me 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 (there may be legal issues).
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.
Renata… Thank you for being FIRST customer purchasing the whole Singapore database!
But… last week you emailed me 3 times bothering me to complete also the number of floors for every block, which I had indicated for 50% of blocks in 2009-2010, with number of units per floor, to estimate number of units and density per precint and estate, and I THOUGHT that is no longer necessary to count floors since HDB published official number of units in enquire status of upgrading programmes in 2010.
Do you realize how much time takes? Since this info is not available anywhere to quickly pick, the only solution is manual counting in Google Streetview. Most BOOOORING job that a customer ever requested!
I have 3 customers at Car Database waiting for me to complete adding car tires, this once finished will generate sales every month, while YOU ARE THE ONLY customer paying for number of floors!
Beware that in the towns done in 2009-2010, blocks with multiple heights are spread on multiple rows. I would like to collate them on one row per block and heights separated by commas, but I don’t know how I can get TIME for it. If this format pose problems for you, provide other option!
Is anyone ELSE interested to have blocks’ number of floors?
I realize that number of floors information is not available from any other databases and that counting the number of floors manually in Google Streetview takes a long time. But the number of floors information is very important for my research purposes. I need number of floors information to estimate the risk from natural disasters in Singapore. You can read more about my company here: http://rms.com/
I also have a very tight deadline. I need the number of floors information by the end of July, or I will not be able to use it at all. I understand that you have other customers, but I will pay you a bonus of $400 if you complete the number of floors information for all HDB blocks of flats.
I forgot that blocks with multiple heights are spread over multiple rows.Thanks for reminding me. This makes it a little trickier for me to import the data into my preferred data analysis program, R. I prefer to have each block represented by one row and for multiple heights to be separated by commas.
I am having a HARD time trying to serve everyone… OK, let’s do it for $400. I estimate to take 50 hours and I will try to work 5 hours per day to finish until end of July, although this job is very BORING so I can’t work many hours continuously.
I have some bad news. I thought my boss would be interested in purchasing the number of floors information for the additional buildings, and I knew it would take you a while to count the number of floors for so many buildings, so to make sure the number of floors data was available by my deadline, I asked you to start counting the buildings before confirming with my boss that he is willing the purchase the data. However, I learned today that my boss is not willing to purchase the data because the whole project may be cancelled.
I know you already started counting the number of buildings, so I will pay you for what you already finished. I think this is fair because if I had not asked you to count the number of floors you would have spent your time working for other customers. If you have finished half of the remaining buildings, I can pay you $200. I will have to pay you using my personal money and hope that the project is not cancelled so that my boss is willing to pay me back.
Please stop counting the number of floors, because I cannot pay you for more buildings than you have already completed. I am very sorry I am not able to pay you to complete the number of floors for all buildings.
Indeed, just done half of job, added floor info for about 2000 blocks of the 4000 remained: Bishan (except the painful Neighborhood 2), Tampines, Pasir Ris, Punggol. On the TO-DO list was Choa Chu Kang, Hougang, Serangoon, Yishun.
I may also needed to count Bukit Batok, Bukit Panjang, Jurong East, Jurong West, half of Woodlands, Sembawang, Sengkang, where block heights were never counted but estimated from shadow length visible in satellite photos, rounded to 4, 12, 16 floors, in 2009 (before Google Streetview launch).
I regret the time spent unnecessarily for your project that risk to be cancelled, in a moment when I had a TO-DO list worth about $1000 and could do something USEFUL for another customer.
However I appreciate that you paid me for doing half of job even if the project risk to be cancelled. You should be a MODEL for my other customers!
On 2 and 3 June has been contacted by 2 customers soliciting me to add also postal codes. I finalized the job in only 5 days, but one never replied while other one asked few questions but never paid. They shall PAY like you! However, I believe that many other people may be needing postal codes, so I had to add them anyway.
hi. i am interested to purchase all datas of singapore HDB regardless 1,2,3,4,5 room.
landed and condos as well.
all EDU involved.
commerical as well
Can you be more clear WHAT DATA would you like to purchase?
Have you seen https://www.teoalida.com/singapore/hdbdatabase/ ? This shows all blocks with number of units of each flat type 1,2,3,4,5,EA,MG,SA.
Have you seen https://www.teoalida.com/singapore/condodatabase/ Each condo is designating apartment types in their name format, name vary from condo to condo: 2-bed, 2-bed+study, 3-bed compact, 3-bed regular, 3-bed+study. There is NOT possible to make a condo database in same format like HDB database, moreover for most condos (small ones) there is no available info about unit distribution. Suggest me a format, WHAT DATA columns do you require?
Commercial and educational buildings, this is most intriguing part. What data do you want to purchase about them?
Anyway, this is a BIG request, can I know what is your project about?
I would like to move your comment HDB Database page. Don’t post page-specific questions in the general Contact page which is visited by many unrelated types of people.
this is what i wan.
the whole singapore
if possible, include commercial building as well.
I AM SAD that I was in kitchen at the moment you messaged me on LIVE CHAT and didn’t heard the beep of incoming message, but heard the beep of the auto-responder at 1 minute, I came at computer immediately but you closed website 10 seconds later (couldn’t you wait few minutes???), I emailed you next minute to get back on website to chat but you didn’t, you replied twice at emails but never explained me clearly.
I asked you that, if in case of HDB I have number of units breakdown by flat type and in case of condos I can offer only total number of units, in case of commercial buildings WHAT number do you expect? I asked you how do you use the data, but no answer…
Are you serious?
That is, they must follow a “database bdb” or “database hdb” line and come before any subsequent “backend” or “database” lines.
I don’t understand your comment. Do you have any suggestions for my HDB database? Who “they” are you referring to?
Hi, I am interested to purchase a list post-2000 hdb blocks with 3-room flats, with block number, street name, etc(not sure what other info you are providing). Kindly email me the quotation and what is provided in the list, as well as payment method. Thank you!
There’s 78 blocks in database with 3-room units and lease date post-2000. Do you need also flats under MOP and under construction? Everyone pay me via Paypal, maybe $20 is a good price for this little job.
Are we able to get the floor area of void deck and common corridor/common area?
You can estimate void deck area by measuring the roof in satellite photo (using Google Earth, not Maps) but beware that some blocks have shops or childcare centres that use part of void deck. Common corridor area is about 20% of block area. BTW, why do you need this unusual info and why do you post comment in this page about Excel database? This is off-topic!
Howdy! I know this is kinda off topic but I’d figured I’d ask. Would you be interested in trading links or maybe guest writing a blog article or vice-versa? My website addresses a lot of the same topics as yours and I think we could greatly benefit from each other. If you happen to be interested feel free to shoot me an e-mail. I look forward to hearing from you! Terrific blog by the way!
May I know how do I contact you? There is no mobile number listed here.
Phone number is just for family and very close friends. Customers can contact me via email or live chat
Thank you for painstakingly collecting data and taking the time out to answer questions from the public, wanted to ask you for your thoughts are on the likelihood of SERS for blk 94 Havelock road (160094), my partner and I looking to move there to start our family and at least stay for 15-20 years, so we are looking for stability and not moving.
There are a couple of factors that could be pro SERS such as a neighbouring empty land with a plot ratio of 4.0 based on the URA masterplan,and the neighbouring flats at taman ho swee are low rise (10 floors). However,there was a lift upgrading program about 10 years ago. what do you think?
Why do you leave comments about SERS in HDB Database page instead of SERS Page?
Block 94 Havelock Road is built in 1983 and currently only blocks built up to 1980 can be selected for SERS, whenever this rule may be changed, nobody knows.
Understood, thanks for sharing your information and being helpful!
Just shut up asshole
I am interested to purchase the Whole Database (Lease date & GPS coordinates). How do I proceed with it?
Just click green button, make payment and receive download link automatically
I also emailed you and didn’t heard any reply from your side
Hi may i know what was the reason given for only flats built up to 1980 can be available for sers? i thought sers are not based on age of flats?
SERS is not based on age (some people asked me at what age blocks will get SERS)
SERS is based on year built (since 1995 to present, all post-1980 got upgrading programmes, pre-1980 80% got upgrading programmes and 20% got SERS). The rule may change in the future and we will see 1980s blocks getting SERS too.