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.
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.
Build-To-Order projects showing town, launch date, estimated completion date, number of units breakdown by flat type, selling price ranges, etc. All info related to housing in Singapore is moved to www.housingmap.sg since October 2024.
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.
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.
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.
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.
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.
Database of private properties in Singapore: condos, apartments, executive condominiums, landed houses. Based on SingaporeExpats and PropertyGuru.
In 2012-2016 I designed myself houses and apartments for dozens customers. Currently I have a team of 5 architects, located in India, Nigeria, Philippines, Romania and United States, who offered to work for me if I am too busy, but seeing their high experience and cheap prices I decided to pass them ALL architectural projects, to free my time so I can focus on IT / data providing industry.
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
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!
This page shows floor plans of ~100 most common HDB flat types and most representative layouts, from 1930s SIT flats to present BTO flats.
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.
What if my website will be split into different domain names that define PRODUCT rather than AUTHOR name? I need your opinion whenever I should or shouldn’t do this rebranding, and if yes, you can suggest domain name ideas.
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.
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.
As graphic designer and enthusiast in computer history, I became curious how the monitor dimensions evolved over the years and analyzed which screen resolutions were most popular, so I created these Excel files: