free hit counter

«

»

Dec 04

Database of HDB blocks in Excel format

The HDB Database involve collecting data from multiple sources, an original compilation Made by Teoalida.

I offer 5 standard packages, containing block number, street address, building name, building type, building era, plus some specific details shown below. You can purchase a smaller package then pay the difference to a bigger package. 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). Need info about certain blocks and NOT interested to purchase whole database? Contact me and I will provide the info needed (if available)! See also Terms and conditions!

Latest update: March 2017

HDB Database, block number, street address, lease year, postal code

GPS coordinates

Free SAMPLE

Buy & download
HDB Database, block number, street address, lease year, postal code

Unit numbers

Free SAMPLE

Buy & download
HDB Database, block number, street address, lease year, postal code

Postal code & lease year

Free SAMPLE

Buy & download
HDB Database, block number, street address, lease year, postal code

Number of units breakdown by flat type

Free SAMPLE

Buy & download
HDB Database, block number, street address, lease year, postal code

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

Bonus: block model name, number of floors and units per floor, estimated for 40% of blocks, counted for other 40% of blocks, yet to be counted for 20% of blocks, this require dozens of hours of manual research to be done accurately, and I may do it if enough people pay the bonus fee.

Free SAMPLE

Buy & download
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!

Free SAMPLE

Buy & download

HDB Database statistics

Total number of tagged HDB buildings in database: 14586 (as January 2017).
Database include also few hundred non-HDB buildings (not tagged, not included in above count).

Breakdown by building type tag:
Residential flats: 10574 + 1347 demolished (including blocks with shophouses and no flats).
Multi-storey carparks (MSCP): 1058 + 3 demolished.
Pavilions: 774 + 5 demolished.
Houses: 109.
Industrial buildings: 46.
Other buildings: 538 + 81 demolished (commercial buildings, electrical sub-stations, etc).
Unknown buildings: 45 (mostly demolished).

Breakdown by building era tag:
Classic era (lease pre-1993): 7851 buildings.
Centralized refuse chute era (lease 1993-1998): 2069 buildings.
Household shelter era (lease 1998-2006): 2000 buildings.
Household shelter BTO era (lease 2006-present): 2666 buildings.

Number of units is available for 10,203 blocks that were existing at least as 2010, including under construction blocks launched until November 2016 BTO. Total: 1,090,310 units, averaging 106 units per block. Every year, new blocks are completed while others are demolished, keeping this figure up-to-date is difficult. 992,742 dwelling units are in use as 31 March 2016 according HDB Annual Report.

Accuracy guaranteed for block numbers, street addresses, postal codes, lease year, number of units.
Not guaranteed for number of floors and units per floor, and for building type tag. Some 2-storey shophouses may be tagged incorrectly as residential. I need to find correct way to tag shophouses.

What the HDB Database currently include

– 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)

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)

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.

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.

Latitude / longitude: GPS location for every block – suggested by 1 people in 2013, too hard task, NOT in mood to do it (unless I am paid a big sum of $$). DONE in 2015 thanks to Renata who made a script to run in Google Maps API and integrate coordinates into my database.

– Lease year: complete for all blocks available on resale market (so NO year for carparks, rental blocks, or blocks within MOP). Source: HDB Resale Flat Prices.
(30% done in 2010 and remaining 70% completed in December 2014)

Lease year-month-day: In June 2015 I started improving lease date by adding day and month beside year, sourcing from HDB Centralized Map. Update frequency: at random moments of year I check possible newly-completed blocks and add lease date.

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.

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, as from time to time people buy 2 flats and adjoin them.
Update frequency: I add number of units for new 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.

What I can include or change in HDB Database

– Reorganize towns/precint structureit’s important to know WHO are the potential customers and how they intend to use the data, to provide the RIGHT data structure.

Remove number of floors – Floors can be only counted manually on Google StreetView thus I can save a lot of time by NOT adding number of floors.

– Remove condos and other private buildings from database, stick on HDB only.

– Make a separate database “Condo Directory”. DONE in October 2015!

– Make an API and sell access to database via monthly subscription instead of one-time payment. I don’t know how to make a subscription payment. Maybe some webdesigner with higher experience than mine can help?

– 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, 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. Feel free to request additional data!

Total: hundreds hours of work, and counting number of floors / units per floor require additional hours be to completed. Maybe too much time considering number of people willing to pay for such data.

History – original HDB database made for my personal research

– In late 2008 I started studying architecture.
– In early 2009 I started the HDB database, a table with 4 columns: block number, floors, units per floor, total units. I took from map the names/numbers of HDB blocks as well as schools, religious structures and every other building within HDB estates.
I was smart enough to identify number of units per floor by looking in satellite photos, and guessed the number of floors by measuring shadow length and compare with the shadow of a block with known height, multiplied to get an estimated number of units per block and per precint.
I made for each town a summary, list of HDB precints with their number of units land area in hectares, plus condos, landed, park, industrial land, to calculate land usage and housing density.
In the same time I collected floor plans and learned the history of HDB, at end of year I published this page HDB Floor Plans 1930-2010s.
– In Dec 2009, Google launched Street View in Singapore, which was very helpful for me. I re-checked the database, corrected block heights and got more precise estimation of number of units. Also added building year.
– In 2010 HDB website shows the number of units in upgrading programmes. I started re-making database and replace the estimated numbers with correct official numbers. By this way I also added street address and upgrading programmes announced for each block.
– In 2011 I abandoned the work because after re-making and re-re-remaking the database… sounds like a waste of time and I did not saw a real usage of such database. With all new ideas that came meantime, several hundred hours would have been necessary to complete database nationwide with number of floors, units per floor, precise number of units, upgrading programmes, etc.

HDB Database covered about 20% (western part of Singapore) in the simple 2009 layout and another 20% in the improved 2010 layout (pre-1980 towns). This 40% was more than enough for the original purpose (personal research). The format was a MESS:

– Number of columns in database varied from one town to another.
– Some street names were abbreviated, others were full names.
– Blocks with varying height were in towns done in 2010 a single row, but in towns done in 2009 were split on separate rows for each height.
– BTO names were sometimes above list of blocks, sometimes on the left.
– And few more…

Note that in 2009 I had no school or job, thus all day was free time… but since 2012 I work for people, customers paying me to do various things, thus I no longer have time for voluntary (non-paid) works

In the same time I made a map of Singapore using AutoCAD, drawing all roads in certain HDB estates, and measured land size of various housing areas. Purpose: personal research about housing density in selected estates and use the results in designing own apartments.

History – new HDB database that I intend to sell for professional use

In mid-2012, one of my other hobbies, the Car Database, had an unexpected turnout into a business. Since 2003 I was compiling car data in Excel for personal research, then in 2011 posted it on website, and after 1 year I realized that there are people willing to pay $ for such data.
So, I tried do do the same with HDB Database, for the first time published it on website, a SAMPLE Excel file with one town only… to test the market and see if anyone is interested and how can be used such directory of HDB blocks, to continue this megalithic work and sell it for money. But first, need to know what data people need, to not spend unnecessary time on unneeded data, standardize the table format for all towns and clean up the mess.

I was facing with LAZY people and lack of feedback, as happened in case of Car Database too, where took one year to figure out how to make a database appealing for customers to do the 1st sale, for one year.
People praised my initiative, many students wanted the HDB database for personal research, counting blocks, etc, flat buyers wanted the database to know lease year, etc. Sorry, but a 400-hour project is NOT something to do for free to help students and flat buyers.
I also met non-serious customers (see the comments at bottom of page), in the top of list is this this customer asking me if I am selling database but not answering my questions (it’s also my fault for not saying “I am selling the SERVICE of compiling a database“, not a ready-made database).

If BUYERS do not tell me exactly what data they want to BUY, how I am supposed to know what data to compile and SELL ????

I made 2 polls. As you can see, people voted to WAIT for a customer then do the megalithic work, however I never succeeded to make a DEAL in this way.
Seems that I need to complete the database in advance, to be ready for sale when the next customer are coming, taking the risk that customers may be looking for SOMETHING ELSE than what I am doing.

HDB Database

After 4 years of indecision, I resumed working in June 2014

If in 2009-2011 I was adding all possible data for one estate then move to next estate, NOW I am planning to complete in stages: finalize block numbers (taken from map), then start adding street addresses and then years (taken from HDB Resale flat prices), only after finalizing these, start adding number of units (highest time-consuming part of database), and so on.

– Due of limited amount of time available for voluntary jobs, I compiled remaining 60% of Singapore as block numbers only. Other towns remain as done in 2009-2011, never updated.
– Visually enhanced the table using vertical colored columns (a style used for all my Excel works since 2010).
– Deleted the land parcel areas and housing density calculation (I believe that nobody will be interested in this), reorganized the summary table by Public and Private housing (instead of condos mixed with HDB if they are on same perimeter of streets).
– Few additional changes…

Total: 9800 residential blocks, including about ~500 demolished blocks, excluding MSCP, pavilions, markets and other non-residential buildings.

I posted the incomplete database FOR SALE in Store, inviting people to tell me their requirements, negotiate a price, buy existing database for $100, then I will do the remaining part of job. Some wanna-be customers are so LAZY even to tell me what profession they are and what data they need about each block!

November 2014

– Took one-week break from my other projects, updated all towns (block numbers and BTO names), added all under construction HDBs launched up to 2013 . Number of units and upgrading programmes remain NOT updated since 2009-2011.
– Added old HDB blocks demolished before 2000, corrected old estate names (using hm.onemap.sg, historical maps released in September 2014), previously I was using Google Maps, which until 2011 was still showing buildings demolished after 2000 together with new buildings.
– New column: Building type tag (Residential / Carpark / Pavilion / Other). Previously MSCPs and Pavilions were indicated in BLOCK column together with block number. (idea came after a student asked me how many carparks and residential blocks are currently in Singapore – this column will allow easy count).
– New column: BTO/precint names. Previously was a header row above the list of blocks in the BTO/precint.
– Reorganized the list, instead of sorting by geographical location and divide each town in precints, it now sorted by phases of construction (see screenshot). For example: Sengkang: instead of 50+ separate precints and BTOs, now there is a continuous list of all blocks. Toa Payoh: instead of a list from blk 1 to blk 260 mixed old and new blocks, I sorted it as Phase 1 (1966-1976) blk 1-235, Phase II (1986-1989) blk 236-360, and Redevelopment phase (1993-present) with BTO and SERS blocks.
– Then, instead of a summary of precints in each town sheet and another summary of towns, there is single summary sheet of towns and phases of construction. Moreover I can combine all 27 towns in a single sheet, to allow nationwide block filter.

Free SAMPLES (these samples were posted at top of page until June 2015 when new version was ready)
HDB Database 2011 – original version as I done it in 2009-2010 for my research.
HDB Database 2014 DETAILED – coloured, visually enhanced, table no longer divided by precints, town summary removed, proposed to breakdown units by flat type – few hundreds hours are needed to complete database in this format.
HDB Database 2014 LITE – street, block, lease year = fewer data fields = only 100 hours are needed to reach 100% completion…
Breakdown by flat type is done only for Jurong West and Holland for purpose of showing in the SAMPLE, for the rest of towns will be done after getting 50% of payment.

HDB Database

December 2014

– Got a week of free time… COMPLETED street address and Lease year for all remaining blocks.
– Total: 13210 buildings. Residential blocks: 10038 + 1198 demolished. MSCP: 941 + 3 demolished. Pavilions: 592 + 2 demolished. Other buildings: 359 + 77 demolished.

March to May 2015

– I am BUSY expanding Car Database which generate far more sales than HDB Database. Further work at HDB database can be done starting from June 2015.

Sales started!

First customer! On 3 May 2015, a real estate agent doing flyer distribution, wanted to view the number of units per all blocks at once. Too bad he purchased Yishun only. I started the job of adding number of units for Yishun, and next day I finished and we made the deal.
Anyone else wants number of units in ONE town? Will be ready in 2 days (or immediately in case of pre-1980 towns).

– Updated all towns, added BTOs launched in 2014 (about 200 buildings,block numbers and street address).
– Added early HUDC (about 100 buildings, although their place is NOT in HDB Database as they were never managed by HDB)
– Re-re-rewrote the page, added the BUY NOW button directly on page instead of telling potential customers “to buy from Store“, also added individual towns with their price, not just “whole Singapore”.

5 new customers contacted me in 20 May – 5 June. Don’t know if is a coincidence, or displaying the prices directly on page, per whole Singapore and per town, encouraged website visitors to contact me. There were 2 mini-customers, one wanted a list post-2000 blocks with 3-room flats. I sold him the list for ONLY $20.
But someone wants number of units in whole Singapore… and deadline set on mid-June!

– I hardly find 100 hours to add number of units in every block. Fortunately one of my school-age friends, was willing to help me during the school vacation of June 2015.
– Also added postal codes (customer request), sourced from HDB Centralized Map (an easy job that took me only 20 hours to complete).
– While adding postal codes, I added also lease day and month beside year, but since no customer ever requested this info, I stopped after 20% and remaining 80% I will do later if is needed.
– Added 2 more columns: Building year (if different than lease year) and Demolition year. Now the upgrading programme column show ONLY the info from HDB upgrading programmes, previously it was saying for example “SERS 2010, demolished 2016” and for rental blocks it said “demolished 2016” which isn’t an upgrading programme.
Total: 13699 buildings.

23 July 2015:
– New release, requested by a customer. Total: 13773 buildings. Residential flats: 10305 + 1298 demolished. MSCP: 993 + 3 demolished. Pavilions: 698 + 5 demolished. Other buildings: 389 + 82 demolished.
– Published 3 packages: postal code and lease commence date, number of units, all details.

October 2015:
– Added few missing blocks. Total: 13794 buildings.

May 2016:
– Added a column Building era, to quickly filter blocks, because last few months I done few sales to people who wanted a list of blocks built after year X.
– Added BTO launch date / SERS announcement date in Block name column (personal idea).
– Added construction code and unit number ranges for blocks that does have site plans in Sale of Balance Flats (requested by a customer in February, I offered to add him this info free of charge, but he never replied, thinking that other customers would be interested), by this way I added about 100 more buildings, mostly Electrical Sub-Stations from under construction BTOs which were missing on OneMap.sg.

June 2016:
– Being tired of waiting for OneMap.sg update I decided to add BTO launched in 2015 and first half of 2016 using site plans from HDB brochures. As coincidence, near end of June OneMap.sg was updated with BTO launched up to end-2015.
– Added number of units for under construction blocks, not just for completed blocks.
Total: 14455 buildings (including 109 houses, 46 industrial, 42 unknown buildings not counted previously).
– Published 26 June in 5 packages (new ones: unit numbers, GPS coordinates).

January 2017:
– Added BTO launched in second half of 2016.
– I noticed that HDB Map Services added info boxes for under construction blocks, not just for completed ones, so I improved my database by adding street address and postal code for under construction blocks too.
Total: 14586 buildings.

TO-DO list:
– Improve lease date with day and month beside year, job started in June 2015 and put ON HOLD because nobody was interested in this particular info.
– Count floors of remaining blocks as well as blocks done in 2009 by estimating from shadow length (most BORING job! Would take hundreds hours!)

30 comments

5 pings

Skip to comment form

  1. Chang

    Hi there

    Any way to get a list of all the executive masionette?

    1. Teoalida

      Can you be more specific what do you want? A list of block numbers where maisonette units exists? You can get this for FREE from http://services2.hdb.gov.sg/webapp/BB33RTIS/BB33PReslTrans.jsp, if you want something related with the Excel database I am compiling, tell me!

  2. Teoalida

    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 http://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).

  3. Renata

    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!

  4. Teoalida

    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 ***

  5. Teoalida

    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?

    1. Renata

      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.

      1. Teoalida

        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.

        1. Renata

          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.

          1. Teoalida

            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.

  6. lawrence

    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

    1. Teoalida

      Can you be more clear WHAT DATA would you like to purchase?
      Have you seen http://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 http://www.teoalida.com/singapore/condolist/ 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.

      1. lawrence

        http://www.teoalida.com/singapore/HDB-Database-by-Teoalida-blocks-number-of-units.png
        this is what i wan.
        the whole singapore
        if possible, include commercial building as well.

        1. Teoalida

          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?

  7. CharlesBiz

    That is, they must follow a “database bdb” or “database hdb” line and come before any subsequent “backend” or “database” lines.

    1. Teoalida

      I don’t understand your comment. Do you have any suggestions for my HDB database? Who “they” are you referring to?

  8. Tan

    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!

    1. Teoalida

      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.

  9. jason

    Are we able to get the floor area of void deck and common corridor/common area?

    1. Teoalida

      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!

  1. Custom data building for individual customers | Car Database

    […] 3 years, 2 people asked me to make a database of buildings for their exclusive use. One of reasons for which I LOVE this business, is that once I complete a […]

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>