Skip to content
Map of HDB blocks in Singapore

Map of Singapore HDB blocks

An interactive map made by Teoalida as alternative to official HDB Map Services. Click block icons and view year built, number of floors, number of units breakdown by flat type, upgrading programmes, typical floor plans, chances to get SERS, etc. All info related to housing in Singapore is moved to www.housingmap.sg since October 2024.

Cars evolution

Car database in Excel

I started collecting car data in Excel voluntarily in 2003 and the hobby turned into business in 2012. My databases are now used by thousands businesses including car parts shops, tuning shops, car dealers, insurance, shipping services, etc. In the future I may offer API SaaS web service beside Excel download.

Singapore HDB

Singapore HDB database

Collecting data from multiple sources, I spent 500+ hours entering data in one Excel table: 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, etc. I sold database to companies including home insurance, telecommunication, door-to-door services, real estate portals, flyer distributors, etc.

Mobile Phones Database

Mobile phones database

I created an Excel database containing over 13,000 devices from 1994 cell phones to modern smartphones, tablets and smartwatches, with 88 columns of specifications. Useful for web development, mobile apps, GSM shop or anything similar. I offer FREE monthly updates and weekly updates for $100/year.

House design

House models designed by me

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

Map of condos in Singapore

Map of Singapore private properties

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

Apartment design

Apartment models designed by me

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

World Cities Database

World cities database

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

Web scraping services

Web scraping services

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

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

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

Teoalida Music Database

Music Database

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

Housing Design

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

I started self-studying architecture in 2008 and designed “Teoalida’s Virtual City”, originally a hobby of graphic design and 3D modeling in AutoCAD, but a fully functional housing system. Since 2012 numerous people contacted me for architectural design services, but my career was horrible, and in 2015 I stopped architectural studies and not offer such services anymore.

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

HDB flat size comparison

HDB flat types and their sizes

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

Index of databases made by Teoalida

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

The world of Teoalida

About me – resume – portfolio – fields of activity

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