Difference between revisions of "IS428 2016-17 Term1 Assign1 Bong Jun Hao"
| (27 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Abstract== | ==Abstract== | ||
| − | This project aims to look at the private property outlook in Singapore, using data of private properties in 2015 extracted from the URA's REALIS database. It focuses on 2 aspects, the supply of private properties as well as their prices. | + | This project aims to look at the private property outlook in Singapore, using data of private properties in 2015 extracted from the URA's REALIS database. It focuses on 2 aspects, the supply of private properties as well as their prices and hopes to make use of the Tableau software for data visualization to identify patterns in the private property market in 2015. This is with the aim of leading to formulation of policies recommendation for the housing market and land allocation/usage in Singapore, as well as recommendations for property developers or potential buyers. |
| − | |||
==Problem and Motivation== | ==Problem and Motivation== | ||
| Line 12: | Line 11: | ||
==Approaches== | ==Approaches== | ||
Prior to examining and analyzing the data, the first step would be to collate the data set, and this involves going into the Urban Redevelopment Authority(URA)'s REALIS database to extract data regarding private property in Singapore. I focused solely on the private residential properties in Singapore, choosing to draw out data using the Stock and Transactions tab as they allow me to retrieve information regarding the availability as well as the transaction prices of private properties in 2015. | Prior to examining and analyzing the data, the first step would be to collate the data set, and this involves going into the Urban Redevelopment Authority(URA)'s REALIS database to extract data regarding private property in Singapore. I focused solely on the private residential properties in Singapore, choosing to draw out data using the Stock and Transactions tab as they allow me to retrieve information regarding the availability as well as the transaction prices of private properties in 2015. | ||
| + | |||
| + | When using the stock and transactions tab i made use of the data analysis tool in REALIS to make use of filters or variables such as the planning region (Central, East, North East, North, West) which would help when using the Tableau tool to differentiate the private properties distribution and pricing by geographical segmentation. | ||
==Data Cleanup== | ==Data Cleanup== | ||
| Line 19: | Line 20: | ||
<gallery> | <gallery> | ||
| + | File:Raw_Data_Supply.JPG|Raw Data for supply of private properties in 2015 | ||
File:Cleaned_Up_Supply_Data.JPG|Cleaned up data for the supply of private properties in 2015 | File:Cleaned_Up_Supply_Data.JPG|Cleaned up data for the supply of private properties in 2015 | ||
| + | File:Raw_Data_Pricing.JPG|Raw Data for pricing of private properties in 2015 | ||
File:Cleaned_up_Pricing_Data.JPG|Cleaned up data for the pricing of private properties in 2015 | File:Cleaned_up_Pricing_Data.JPG|Cleaned up data for the pricing of private properties in 2015 | ||
</gallery> | </gallery> | ||
| + | |||
| + | ==Visualization and Graphing== | ||
| + | '''Share of Private Properties in 2015''' | ||
| + | <gallery> | ||
| + | File:Availability.png|Availability of private properties in 2015 | ||
| + | File:Availability_Type.png|Share of private properties by Type in 2015 | ||
| + | File:Availability_Region.png|Distribution of private properties by Region in 2015 | ||
| + | File:Availability_Quarter.png|Distribution of private properties by Quarter in 2015 | ||
| + | </gallery> | ||
| + | I decided to present the availability of private properties based on the housing type which involves six categories; namely Condominium, Apartment, Detached House, Executive Condominium, Semi-detached house and Terrace house. It is also based on the region so as to present an overview of the supply not only by share based on categories, but also distribution by geographical location. | ||
| + | |||
| + | A bar chart is used for the presentation as the reader would be able to see at a glance if there is any skewed differences in the type or geographical location of the private properties. | ||
| + | |||
| + | As seen in the graphs, the type of housing with the highest availability of supply would be the condominiums, followed by apartments. There were a total of 1,366,584 private properties available in 2015, and the condominiums and apartments alone make up 74% of the total private properties supply. | ||
| + | |||
| + | It can also be noted that the availability of private properties lies mainly in the central region, making up about 50% of the total supply in 2015. | ||
| + | |||
| + | The last pattern that can been observed would be that of the availability based on time, where throughout all 4 quarters the supply of private properties were relatively stable with no strong increases or cuts. | ||
| + | |||
| + | '''Distribution of Private Properties Pricing in 2015''' | ||
| + | <gallery> | ||
| + | File:Median_Price.png|Median Price of private properties in 2015 | ||
| + | File:Median_Price_PSF.png|Median Price PSF in 2015 | ||
| + | </gallery> | ||
| + | |||
| + | As for the pricing of the transactions of private properties in 2015, i decided to present it using a line chart format as it straight away enables the reader to look at the fluctuations in pricing. The charts are based not only on the geographical locations, but also by the housing type so that the user are able look at the key differences and compare across different housing types or even regions at a glance. | ||
| + | |||
| + | A Median Price Per Square Feet distribution is also used so as to have a more accurate representation based on the sizing of each individual private property rather then other factors which would have been difficult to pin point. | ||
| + | |||
| + | It can be observed that both average median prices and prices per square feet is the highest for private properties within the Central Region. | ||
| + | |||
| + | It can also be observed that despite detached houses being bigger in size and considered as a much more premium form of housing, its average PSF price in 2015 is not the highest even though its average transaction price might be the highest, most probably attributed to its larger sizes. Apartments and condominiums tend to have higher average price PSF across Singapore. All in all, landed properties tend to have a lower price p.s.f in as compared to non landed ones. | ||
| + | |||
| + | Lastly, correlating this with the supply of private properties in Singapore, it can been seen that in regions like Central where the supply of private properties is much higher as compared to that of regions such as the north region, the higher supply does not necessarily results in lower prices, suggesting that there is a relatively strong demand of private properties especially in the Central region. | ||
==Tools Utilized== | ==Tools Utilized== | ||
| + | The following tools were leveraged on for this project:<br /> | ||
| + | 1. Microsoft Excel: To store all the raw data and to manipulate and arrange the data sets for easy use in Tableau.<br /> | ||
| + | 2. Tableau: To generate the chart and provide visualization of the analysis of the data set. | ||
| + | |||
| + | ==Results== | ||
| + | The following observations are made:<br /> | ||
| + | 1. The condominiums and apartments alone make up 74% of the total private properties supply.<br /> | ||
| + | 2. The availability of private properties lies mainly in the central region, making up about 50% of the total supply in 2015.<br /> | ||
| + | 3. Throughout all 4 quarters the supply of private properties were relatively stable with no strong increases or cuts.<br /> | ||
| + | 4. Both average median prices and prices per square feet is the highest for private properties within the Central Region.<br /> | ||
| + | 5. Landed properties tend to have lower price p.s.f than non landed ones.<br /> | ||
| + | 6. Higher supply does not necessarily results in lower prices, as seen in the Central Region.<br /> | ||
| + | 7. Executive Condominiums are the cheaper private property across all regions and property type.<br /> | ||
| + | 8. The available private properties in the North are the lowest, making up only 4% of the total supply.<br /> | ||
| + | |||
| + | These information can be used by both developers and potential buyers of private properties. For the developers, the fact that there are already a lot of properties and developments within the central region should not deter them from building more private properties to put on sale as the relatively higher prices p.s.f seems to indicate that there is a demand for properties in that region. The relatively low amount of private properties in the North indicate an opportunity for the Government to release land in that area for sale, as well as for private developers to look into. | ||
| + | |||
| + | For potential buyers looking to purchase a private property, it might make more sense for them to look into a landed property as it offers them a lower average price p.s.f even if the overall price paid might be higher due to the larger sizes of the properties. Also, buyers should consider purchasing properties outside of the Central Region as it might offer them more value for the price paid, since they would not be paying for the premium that a private property in the Central Region comes with. Buyers who find themselves unable to afford condominiums or apartments should consider looking at Executive Condominiums as they are much more affordable. | ||
| + | ==Policies Recommendations== | ||
| + | 1. The government can look at marking out more land for sale for the building Executive Condominiums as they are a good alternative for buyers, especially Singaporeans or PRs who are looking to purchase a private properties but find themselves priced out of the competition for such purchases against expatriates or foreigners. Land parcels in the North Region could be earmarked for such developments since the availability of such properties in this region is very little, and could help to balance the distribution across the country.<br /> | ||
| + | 2. With properties prices in the Central Region much higher than the rest of the country, it makes sense to earmark land in that area of more high rise private properties rather than landed properties, as it can allow for more residents and meet the demand for housing in that region. While landed properties in the Central Region fetch a very high sale price, it does little to meet or curb the demand for housing in the Central Region. Furthermore, it also makes sense for the government, in its development plan and use of the land in the Central Region to look at 2-in-1 housing and offices or SOHO (Office/Home) themed residences so as to the cater to the demands or wants of the population. <br /> | ||
| + | 3.On the other hand, it can also look at reorganizing the usage of land, i.e to shift the CBD area towards the other regions or build more offices in other regions so as to reduce or alleviate the demand for housing in the Central Region and the need or want to stay conveniently centrally. | ||
| − | == | + | ==Infographic== |
| + | <gallery> | ||
| + | File:Infographic_Bong_Jun_Hao.png|Infographic | ||
| + | </gallery> | ||
Latest revision as of 08:29, 29 August 2016
Contents
Abstract
This project aims to look at the private property outlook in Singapore, using data of private properties in 2015 extracted from the URA's REALIS database. It focuses on 2 aspects, the supply of private properties as well as their prices and hopes to make use of the Tableau software for data visualization to identify patterns in the private property market in 2015. This is with the aim of leading to formulation of policies recommendation for the housing market and land allocation/usage in Singapore, as well as recommendations for property developers or potential buyers.
Problem and Motivation
With the Population White Paper released in 2013 by the Singapore Government projecting Singapore's population as 6.9 million in 2020, there is an underlying meaning with this projection as it seems to indicate that there would be an influx of foreign talents to support and reach this projected population since our birth rate at 1.25 in 2015 is not enough to replenish our own population; let alone increase it.
The housing policy in Singapore is such that the foreign talents or expats are not allowed to purchase public housing, and as such their choices are limited to that of private properties.This leads to increased competition for private housing in Singapore, as increasingly affluent citizens looking to upgrade from public housing or for investment purposes would also need to vie with non-citizens looking for a roof over their heads. On the other hand, the slowing of growth of expatriates coming into Singapore has also led to fluctuations in demand and supply of private properties, perhaps slightly contributing to a fall of 3.7% in its price in 2015. These fluctuations give rise to a potential opportunity for other potential homeowners to move in, be it for investment or otherwise.
Hence the motivation behind this project lies in exploring the distribution and availability of private properties in Singapore as well as its price levels, so as to help potential buyers in making a decision when it comes to buying private properties. The main variables involved in this would be firstly the number of available private housing and secondly, the pricing of such housing. All these takes in to account the distribution of such housing by types across the different regions in the country.
Approaches
Prior to examining and analyzing the data, the first step would be to collate the data set, and this involves going into the Urban Redevelopment Authority(URA)'s REALIS database to extract data regarding private property in Singapore. I focused solely on the private residential properties in Singapore, choosing to draw out data using the Stock and Transactions tab as they allow me to retrieve information regarding the availability as well as the transaction prices of private properties in 2015.
When using the stock and transactions tab i made use of the data analysis tool in REALIS to make use of filters or variables such as the planning region (Central, East, North East, North, West) which would help when using the Tableau tool to differentiate the private properties distribution and pricing by geographical segmentation.
Data Cleanup
The data retrieved from the REALIS database is not in a format that is suitable for use with the Tableau software for analysis. Difficulties were encountered when trying to use the data in its raw format as there were cases where there were null entries, such as when retrieving the transaction information in 2015 since there were some months where a particular type of private property did not have any sales or change of ownership. In other cases, there is a need to arrange the heading of the data better so that it can be easily manipulated into the rows and columns when using the Tableau software.
As such, there is a need to manually download and manipulate them into a format such that it can be fed into the Tableau software for easier management.
Raw Data for supply of private properties in 2015
Cleaned up data for the supply of private properties in 2015
Raw Data for pricing of private properties in 2015
Cleaned up data for the pricing of private properties in 2015
Visualization and Graphing
Share of Private Properties in 2015
Availability of private properties in 2015
Share of private properties by Type in 2015
Distribution of private properties by Region in 2015
Distribution of private properties by Quarter in 2015
I decided to present the availability of private properties based on the housing type which involves six categories; namely Condominium, Apartment, Detached House, Executive Condominium, Semi-detached house and Terrace house. It is also based on the region so as to present an overview of the supply not only by share based on categories, but also distribution by geographical location.
A bar chart is used for the presentation as the reader would be able to see at a glance if there is any skewed differences in the type or geographical location of the private properties.
As seen in the graphs, the type of housing with the highest availability of supply would be the condominiums, followed by apartments. There were a total of 1,366,584 private properties available in 2015, and the condominiums and apartments alone make up 74% of the total private properties supply.
It can also be noted that the availability of private properties lies mainly in the central region, making up about 50% of the total supply in 2015.
The last pattern that can been observed would be that of the availability based on time, where throughout all 4 quarters the supply of private properties were relatively stable with no strong increases or cuts.
Distribution of Private Properties Pricing in 2015
Median Price of private properties in 2015
Median Price PSF in 2015
As for the pricing of the transactions of private properties in 2015, i decided to present it using a line chart format as it straight away enables the reader to look at the fluctuations in pricing. The charts are based not only on the geographical locations, but also by the housing type so that the user are able look at the key differences and compare across different housing types or even regions at a glance.
A Median Price Per Square Feet distribution is also used so as to have a more accurate representation based on the sizing of each individual private property rather then other factors which would have been difficult to pin point.
It can be observed that both average median prices and prices per square feet is the highest for private properties within the Central Region.
It can also be observed that despite detached houses being bigger in size and considered as a much more premium form of housing, its average PSF price in 2015 is not the highest even though its average transaction price might be the highest, most probably attributed to its larger sizes. Apartments and condominiums tend to have higher average price PSF across Singapore. All in all, landed properties tend to have a lower price p.s.f in as compared to non landed ones.
Lastly, correlating this with the supply of private properties in Singapore, it can been seen that in regions like Central where the supply of private properties is much higher as compared to that of regions such as the north region, the higher supply does not necessarily results in lower prices, suggesting that there is a relatively strong demand of private properties especially in the Central region.
Tools Utilized
The following tools were leveraged on for this project:
1. Microsoft Excel: To store all the raw data and to manipulate and arrange the data sets for easy use in Tableau.
2. Tableau: To generate the chart and provide visualization of the analysis of the data set.
Results
The following observations are made:
1. The condominiums and apartments alone make up 74% of the total private properties supply.
2. The availability of private properties lies mainly in the central region, making up about 50% of the total supply in 2015.
3. Throughout all 4 quarters the supply of private properties were relatively stable with no strong increases or cuts.
4. Both average median prices and prices per square feet is the highest for private properties within the Central Region.
5. Landed properties tend to have lower price p.s.f than non landed ones.
6. Higher supply does not necessarily results in lower prices, as seen in the Central Region.
7. Executive Condominiums are the cheaper private property across all regions and property type.
8. The available private properties in the North are the lowest, making up only 4% of the total supply.
These information can be used by both developers and potential buyers of private properties. For the developers, the fact that there are already a lot of properties and developments within the central region should not deter them from building more private properties to put on sale as the relatively higher prices p.s.f seems to indicate that there is a demand for properties in that region. The relatively low amount of private properties in the North indicate an opportunity for the Government to release land in that area for sale, as well as for private developers to look into.
For potential buyers looking to purchase a private property, it might make more sense for them to look into a landed property as it offers them a lower average price p.s.f even if the overall price paid might be higher due to the larger sizes of the properties. Also, buyers should consider purchasing properties outside of the Central Region as it might offer them more value for the price paid, since they would not be paying for the premium that a private property in the Central Region comes with. Buyers who find themselves unable to afford condominiums or apartments should consider looking at Executive Condominiums as they are much more affordable.
Policies Recommendations
1. The government can look at marking out more land for sale for the building Executive Condominiums as they are a good alternative for buyers, especially Singaporeans or PRs who are looking to purchase a private properties but find themselves priced out of the competition for such purchases against expatriates or foreigners. Land parcels in the North Region could be earmarked for such developments since the availability of such properties in this region is very little, and could help to balance the distribution across the country.
2. With properties prices in the Central Region much higher than the rest of the country, it makes sense to earmark land in that area of more high rise private properties rather than landed properties, as it can allow for more residents and meet the demand for housing in that region. While landed properties in the Central Region fetch a very high sale price, it does little to meet or curb the demand for housing in the Central Region. Furthermore, it also makes sense for the government, in its development plan and use of the land in the Central Region to look at 2-in-1 housing and offices or SOHO (Office/Home) themed residences so as to the cater to the demands or wants of the population.
3.On the other hand, it can also look at reorganizing the usage of land, i.e to shift the CBD area towards the other regions or build more offices in other regions so as to reduce or alleviate the demand for housing in the Central Region and the need or want to stay conveniently centrally.
Infographic
Infographic
