Skip to content

Housing statistics

Per total, 53% of housing are owner-occupied. Is hard for me to make estimation about average apartment size in Hong Kong or about the ratio sqm per person, due to lack of detailed statistics about housing system, high income inequality, many people living in extremely small 1-room apartments, illegally-divided apartments, as well as boathouses, caged homes, rooftop huts and other forms of inhumane homes.

Timeline of tallest buildings

Tallest buildings in the world

Philadelphia City Hall (1901), Singer Building (1908), Metropolitan Life Tower (1909), Woolworth Building (1913), Equitable Building (1915), Bank of Manhattan Trust Building (1930), Chrysler Building (1930), Empire State Building (1931), World Trade Center (1971), Sears Tower (1973), CN Tower (1976), Petronas Towers (1998), Taipei 101 (2004), Shanghai World Financial Center (2008), Burj Khalifa (2010), Jeddah Tower (under construction).

Digital Cameras Database

Digital cameras database

If you are looking for a database of digital cameras specifications in Excel format to create a website, use in a repair shop or anything similar, I created an Excel database for you. Contains 36 camera brands with a total of over 3800 models.

List of Singapore MRT and LRT stations

List of MRT and LRT stations

If you are looking for a database of Singapore MRT and LRT stations in Excel format, I created an Excel database for you in November 2019, copy-pasted from Wikipedia and visually enhanced in Excel to match the style of my other spreadsheets “Made by Teoalida”. In January 2020 I expanded database adding postal codes and GPS coordinates (sourced from OneMap.sg) for all stations that are opened or under construction.

HDB Annual Report

HDB Annual Reports 1927-present

I transcribed the tables in Annual Reports 1990-2017 into Excel (New Towns under development and Dwelling units under management by town and flat type). I can go further and do the same for 1960-1989 tables, also transcribe in Word all the Annual Reports if there is sufficient demand.

Countries database

World countries database

Are you looking for a database of countries in Excel format with their facts and figures, for research or to create a website? I made a database for you. Took few hours to make a scraping script which extract data from The World Factbook and create a CSV file. Takes about 35 min to extract the 268 entries, and I can update anytime you want!

Skyscrapers

Skyscrapers database

After making databases of HDB and condos from Singapore, as well as public and private housing estates from Hong Kong, and other databases, in November 2015 I started making a database of skyscrapers, to study evolution of skyscrapers over history.

Airports database

Airports database

Are you looking for a database of airports and other airfields in Excel format for research or to make a website? I made a database for you, you can open XLS file, save as CSV and import in SQL if needed.

ID 100%, Ident 100%, Type 100%, Name 100%, Latitude 100%, Longitude 100%, Elevation (ft) 87.33%, Continent 100%, ISO country 100%, Country 100%, ISO region 100%, Region 100%, Municipality 89.67%, Scheduled service 100%, GPS code 74.11%, IATA code 16.58%, Local code 52.24%, Home link 5.43%, Wikipedia link 17.86%, Keywords 17.22%.

Solar System Database

Solar System Database

Are you looking for a database of planets and satellites in Excel format with their facts and figures, for research or to make a website? I made a database in 2014 with planets and main satellites, sourcing data from solarsystem.nasa.gov.

Given by high number of free downloads, in 2019 I made a larger Excel database containing EVERY celestial body listed on NASA website (1 sun, 8 planets, 5 dwarf planets, 190 satellites) and offer for paid download.

SEO SPAM from India

SEO SPAM from India

Webdesign companies do exist all over the world, but 90% of spammers sending unsolicited emails and phone calls are from India, usually start-ups and unexperienced teenagers claiming that are big companies and fool naive people to outsource work to them. Not all Indian companies are spammers, but the (5%?) doing SPAM damage reputation of Indian IT industry and reputable companies suffer as well.

They guarantee that will push my website to top of Google search results, 101% recovery from Panda and Penguin penalties, etc (for your info: no one can guarantee #1 in Google. What if multiple websites in same niche apply for their services, who will be #1?). I asked them how they do that, but most of them do not provide details, they just insist to get paid and let my website on their hands.

Football stadiums database

Football Database

Download free SAMPLE: 2018-FIFA-World-Cup.xls

Took me about 5 minutes to compile this table sourcing data from Wikipedia using “XPath Helper” extension for Chrome.

If you are interested in similar table for all FIFA World Cups 1930-2018, UEFA Euro Cups and other football tournaments, please contact me.

HDB Resale Flat Prices Database

Database of HDB resale flat prices in Excel format

On 1 April 2009, HDB improved its Resale Flat Prices e-service, now showing transactions for last 1 year instead of last 3 months, also added flat model beside floor area. I copied the listings for 1 year (April 2008 – March 2009) in Microsoft Excel, which were displaying 20 per page. I spent about 10 days at 5 hours per day. I did this for purpose of personal analysis, for example estimate average apartment size nationwide and per town, and showing the results of analysis in HDB Statistics page. Few months later HDB showed all transactions in a scroll-able list rather than 20 pages, allowing me to copy transactions much faster, so started to update my database once per year.

Excel colors

Colors database RGB & HEX

First time I made such table was in 2004 (15 years old) when I spent few days making in Paint an image with 48 hue levels and 32 lighting levels (Excel 97-2003 was limited to 56 colors).

In 2018 I remade it in Excel, adding RGB values for easier use, the job took about 4 hours, 48 hue levels and 16 lighting levels. In 2019 also made a Scalable Vector Graphics table with HEX colors.

Furnished apartment

Furniture & interior design

I design furniture since ~14 years old (~2003), around 15 years old my mom employed in a furniture factory so we refurnished my room using my pre-made drawings. People who contacted me over years made me to pursue my career in architecture rather than interior design. Whenever I will do furniture design again, we will see…

Car design in AutoCAD

Car design in AutoCAD 3D models

Before moving into architecture design in 2008, I also modeled few 3D car models in AutoCAD. I did NOT wanted to design the ultimate sport car, instead I designed an average classic family car, with many details as possible, to show my skill as graphic designer, and to use many of AutoCAD photorealistic effects as possible, to show the performance of AutoCAD render. Do you though that AutoCAD is only for 2D drawings?

City maps designed by me

The hobby for designing maps have a long history. Starting from 6 years old I was drawing random roads on paper and coloured them in various colors. The first time I designed a map of a real city was at age of 14, in 2003 I made on paper a map of my city downtown with a special attention given to historical buildings.

Palatul Cantacuzino "Micul Trianon" din Floreşti Prahova

Palace Trianon 3D design in AutoCAD

This palace is one of the most beautiful 3D modeling works that I ever designed in AutoCAD. Many people were impressed not only by the beautiful 3D renders, but also for excellent model geometry that makes it to look like 18-19th century neoclassic architecture. Some people asked me how I got the idea to design such complex building, and suggested to change some details to make it better, BUT…

Website penalized by Google and my solution

I added too many keywords in image ALT tags on 2 pages each with around 100 images. These 2 pages have been the first to be penalized by Google, in mid-2013 for few months they were no longer appearing in searches and traffic dropped with 90%. I should have taken this as a WARNING that I do something wrong, but I did not paid any attention and continued adding ALT tags stuffed with keywords. On 12 October 2013 whole site was removed from Google search results for most keywords, causing traffic drop from 500 to 150 daily visitors. On 9 January 2014 remove the ALT and TITLE tags. Surprise, next day 10 January penalty was lifted (after 90 days).

Caesar III

Caesar 3

Caesar III is one of my favorite games. I got the demo version in 2000 from a magazine CD. Demo version include only first 2 missions but 2nd one is bigger than in full game. Started playing in the morning and build as much I can by end of day, reaching population of about 5000, Demo version was not allowing me to save game.

I got the full game only in 2005, and I played it a lot in 2005-2006, then in 2008, and a little since October 2011, the moment in which I created this page on my website, originally strictly for cities built by me. In 2012 the business forced me to stop playing games, but I kept expanding page adding info about game itself.

Age of Empires

Age of Empires

Excel tables made by me, containing list and tree of buildings, villagers, military units, boats, animals, research and upgrades. Hit points, attack, armor, piercing armor, range, speed, cost, time required to produce, etc.

Beetle Buggin

Beetle Crazy Cup

Beetle Crazy Cup, also know on warez websites as Beetle Buggin’ (probably due to amount of software bugs included in game), or Käfer Total, is one of the worst racing games I ever played… but it can be fun if is played at home with a friend.

Beetle Crazy Cup is the most recent game that can be played with 2 persons at same computer, know by me. Do you know other such games?

I created an Excel table: Beetle Crazy Cup.xls containing statistics such as vehicle list with car prices and car top speed in each gear.

Grand Theft Auto: San Andreas

GTA Vice City & San Andreas

Probably one of most played games today is Grand Theft Auto. Although I do not like violent games, I still played Vice City and San Andreas around 2005-2007, more as a driving game, not shooting and killing as many is possible (as my friends were doing!), but I also finished all missions of the story line.

I show here the Excel files made by me with statistics about game:
GTA Vice City mission tree, property list, weapons list, vehicle list with their top speed and other info.
GTA San Andreas vehicle list with their top speed and other specs, mission tree, weapons.

Miner VGA

MinerVGA

I played MinerVGA starting from 1998 for few years, losing every time (money earned from minerals was not enough to cover costs of digging). In 2016 I suddenly remembered this game, saw some walkarounds on YouTube, played it again in correct way, and won the game for the first time by finding the wedding ring to marry Mimi.

Need For Speed Porsche Unleashed

Need For Speed

My favorite racing game was Need For Speed: Porsche 2000 / Porsche Unleashed. I got it in 2003 from a friend. I made this table NFS Porsche 2000.xls, including car list, top speed of each car, written my personal records, and other stuff.

The next Need For Speed: Hot Pursuit 2 was a worsen game, as they moved to Arcade style of racing, no damage. Got it from friends. I made table NFS Hot Pursuit 2.xls, containing car list, car max speed, career track, prices, etc.

Supaplex

Supaplex

Supaplex was the 1st game I ever played, shortly after my dad bought our first computer in 1995, but lost it in 1997 due to HDD crash. Once I connected to internet in 2005 I found a Windows version, Megaplex, and few years later I found original Supaplex again on DOS Games Archive. I made Supaplex level list in Excel