|
|
| (10 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| − | <br>
| |
| − | <!------ Main Navigation Bar---->
| |
| − | <center>
| |
| − | {| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
| |
| | | | |
| − |
| |
| − |
| |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="210px" |
| |
| − | [[link2|<font color="#3c3c3c"><strong>HOME</strong></font>]]
| |
| − |
| |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #7A9FC4" width="190px" |
| |
| − | [[analysis|<font color="#3c3c3c"><strong>ANALYSIS</strong></font>]]
| |
| − |
| |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="210px" |
| |
| − | [[G2-Group06_Poster|<font color="#3c3c3c"><strong>POSTER</strong></font>]]
| |
| − |
| |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="230px" |
| |
| − | [[link4|<font color="#3c3c3c"><strong>DEPLOYED APPLICATION</strong></font>]]
| |
| − |
| |
| − | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #f5f5f5" width="230px" |
| |
| − | [[link5|<font color="#3c3c3c"><strong>RESEARCH PAPER</strong></font>]]
| |
| − |
| |
| − | |}
| |
| − | </center>
| |
| − | <!------- End of Main Navigation Bar---->
| |
| − | <!-- Body -->
| |
| − | <br>
| |
| − | [[File:Paradisiacal_punggol.png|center|300px]]
| |
| − | {| style="background-color:#ffffff ; margin: 3px 10px 3px 10px; width="80%"|
| |
| − |
| |
| − |
| |
| − | == Population Growth Trend & Forecast ==
| |
| − | In this population we will be using the Singstat’s `[https://www.singstat.gov.sg/-/media/files/find_data/population/statistical_tables/singapore-residents-by-planning-areasubzone-age-group-sex-and-type-of-dwelling-june-20112019.zip Singapore Residents by Planning AreaSubzone, Age Group, Sex and Type of Dwelling, June 2011-2019]` data provided. There are few objectives that we want to understand from the population historical data:
| |
| − | * Understand the population trend for each subzone and age group classification (younger group, economic active group, and aged population) in order to facilitate basic necessities for each age group.
| |
| − | * Forecast the future population trend up to 2024 using the auto ARIMA model to re-evaluate the MP19.
| |
| − | ** [https://people.duke.edu/~rnau/411arim.htm#arima010 Interpreting the Arima model]
| |
| − | ** Similar application of ARIMA model in forecasting population trends:
| |
| − | *** Zakria, Muhammad & Muhammad, Faqir. (2009). [https://www.researchgate.net/publication/228468254_Forecasting_the_population_of_Pakistan_using_ARIMA_models Forecasting the population of Pakistan using ARIMA models.]. Agri. Sci. 46.
| |
| − | *** Nyonyi, T and Mutongi, C. (2019). [https://mpra.ub.uni-muenchen.de/93983/1/MPRA_paper_93983.PDF Prediction of total population in Togo using ARIMA models].
| |
| − | *** Lin, Bin-Shan, et al. [https://www.jstor.org/stable/23365635?seq=1#page_scan_tab_contents “Using ARIMA Models to Predict Prison Populations.”] Journal of Quantitative Criminology, vol. 2, no. 3, 1986, pp. 251–264. JSTOR, www.jstor.org/stable/23365635.
| |
| − | ** Make recommendations according to the population trend insights.
| |
| − |
| |
| − |
| |
| − | === Data Cleaning Methods ===
| |
| − | * Data is cleaned to only show Punggol PA and its subzones.
| |
| − | * Age group were classified into a new group with the following requirement:
| |
| − | ** '''Younger Population''': 0-24
| |
| − | ** '''Economic Active''': 25-64
| |
| − | ** '''Aged Population''': 65 and above
| |
| − | * Summation group by was performed according to each subzone and age group classification.
| |
| − | * Reverse data frame vector was performed to swap rows and columns formatting as it is required to perform graph visualisation in R.
| |
| − | ** Methods Deployed in RPubs: [http://rpubs.com/jerrytohvan/548619 Punggol Forecast Population Analysis]
| |
| − | ** Methods Deployed in RPubs: [http://rpubs.com/jerrytohvan/548621 Punggol Peak Hour Travel Pattern Analysis]
| |
| − |
| |
| − | === Visualisations ===
| |
| − | * Datatable view of forecast population per age group classification and subzones.
| |
| − | * Plotting time series line graph on each subzone’s population trend.
| |
| − | * Plotting the ARIMA forecasted population on each Subzone.
| |
| − |
| |
| − | === Results ===
| |
| − |
| |
| − | ==== Matilda’s Population Trend ====
| |
| − | [[File:Matildas pop.jpg|center|500px]]
| |
| − | [[File:Matilda forecast.jpg|center|500px]]
| |
| − | First, the Matilda subzone is one of the most populated subzones in Punggol. The Matilda subzone has been populated ever since the initiation of HDB buildings in Punggol. The subzone is continuously growing ever since 2011 for all age groups. Interestingly the subzone is predominantly filled with the economic active group. Based on the 9 years trend, an ARIMA (0,1,0) with random walk were applied to predict the population for the next 5 years. We predict that there is a major growth in population for this subzone. We anticipate the there is a growing number of younger age group as the economic active age group might plan to start a family.
| |
| − |
| |
| − | ==== Northshore’s Population Trend ====
| |
| − | [[File:Northshore pop.jpg|center|500px]]
| |
| − | [[File:Northshore forecast.jpg|center|500px]]
| |
| − | Next, the Northshore subzone is rather a newer region in Punggol. We haven’t observed a significant rise in terms of population. However, there are on-going government plans of developing smart HDB in these regions for example the Punggol Northshore Residences I and II.
| |
| − | [[File:Punggol HDB.jpg|center|500px]]
| |
| − | [[File:Flat details.jpg|center|350px]]
| |
| − | For the upcoming next five years or so, the number of populations might increase exponentially, especially with the attractive government’s plan for the smart HDB which in turn will probably attract most of the economic active group.
| |
| − |
| |
| − | Ref:
| |
| − | 1. https://www.straitstimes.com/sites/default/files/attachments/2019/04/22/ST_20190422_ITHOMEFINAL_4787163.pdf
| |
| − | 2. https://esales.hdb.gov.sg/bp25/launch/19sep/bto/19SEPBTO_page_2671/about0.html#
| |
| − |
| |
| − | ==== Punggol Town Centre’s Population Trend ====
| |
| − | [[File:Ptc pop.jpg|center|500px]]
| |
| − | [[File:Ptc forecast.jpg|center|500px]]
| |
| − | [[File:Change Detection Landuse.jpg|center|300px]]
| |
| − | The Punggol Town Centre is located at the heart of Punggol planning area. This shows a major exponential growth. This exponential growth could have been caused by the past few year’s major development by the government, especially through the integrated development near Punggol MRT also the the new HDB appearance at the Nibong LRT proximity.
| |
| − | [[File:Ptc map.jpg|center|500px]]
| |
| − | We are projecting that exponential growth will diminish as most of the region haven’t progressed much from previous Masterplan 2008 and Masterplan 2014. Additionally, most of the locations in the area are currently occupied or already planned. However, with the current figure of the economic active population there is a possibility that the younger group might still spike due to family plans and rather mid age group living in the area. We should not deny the potential addition of the aged population even though it might not rise significantly for the next 5 years, but however an early planning is always good to ensure that needs are always met, example: building eldery centres as this subzone currently has approximately 9000. We recommend a child centre built nearby homes as there are only a few in this region.
| |
| − |
| |
| − |
| |
| − | ==== Punggol Field’s Population Trend ====
| |
| − | [[File:Punggol field pop.jpg|center|500px]]
| |
| − | [[File:Punggol field forecast.jpg|center|500px]]
| |
| − | The Punggol Field subzone is rather been mostly an occupied zone since 2011 and growing at a rather consistent rate ever since. According to the change model analysis as described in the previous section. This area had mostly minor changes to an additional education institute and residential facilities. We are not projecting that there will be major changes in terms of figure, but there is a possibility that the aged group might rise about 4000 for the next 5 years, thus suggesting the need of more eldery facilities.
| |
| − |
| |
| − | ==== Waterway East’s Population Trend ====
| |
| − | [[File:Waterway pop.jpg|center|500px]]
| |
| − | [[File:We forecast.jpg|center|500px]]
| |
| − | Similar to Matilda and Punggol Town Centre, the Waterway East has one of the fastest growing subzones in Punggol. We can observe a similar trend of age group division, where the economic active dominates the population. In terms of its current figure, Waterway East have reached Punggol Field’s figure. However, when it comes to potential growth, we project that there will be an increased number of addition across all age group classifications.
| |
| − |
| |
| − |
| |
| − | ==== *Coney Island and Punggol Canal have 0 population recorded so we are not going to focus on these particular subzones ====
| |
| − |
| |
| − | === Analysing The Younger Population’s Needs ===
| |
| − | ==== Going deeper into analysing each younger age group education needs ====
| |
| − | [[File:Age dist table.jpg|center|500px]]
| |
| − | In this section we will perform a micro analysis of the younger age group needs. The diagram above clearly separates different education stages of each young group classification. We will make recommendations whether there is a need to revise the current availability pre-school, kindergarten, primary school, secondary school, and post-secondary education.
| |
| − |
| |
| − | ==== Matilda’s Younger Group Population Trend ====
| |
| − | [[File:Matilda pop graph.jpg|center|500px]]
| |
| − | The above line chart depicts the historical younger group population trend in Matilda’s subzone. Interestingly the subzone are predominantly filled with age group 0 - 9 which emphasises the need of having preschool and primary school nearby residential buildings. Proximity to residentials are important in this subzone so that parents can drop or pick-up their kids before or after work conveniently. From this figure we can conclude that for the next 5 years, preschools, kindergarten and primary schools are priority.
| |
| − |
| |
| − | ==== Northshore’s Younger Group Population Trend ====
| |
| − | [[File:Northshore pop graph.jpg|center|500px]]
| |
| − | As per discussed under the “Northshore’s Population Trend” section, the government are rolling out HDB on-going projects that will be projected to complete in 4 or more years. Thus, even though the younger population figure seems to be less significant as compared to other subzones, the subzone will experience a major spike once units are completed. Thus, there is a need for proper planning to ensure that the younger age group needs are met.
| |
| − |
| |
| − | ==== Punggol Field’s Younger Group Population Trend ====
| |
| − | [[File:Punggol field pop graph.jpg|center|500px]]
| |
| − | The Punggol Field’s subzone is rather different as compared to Matilda’s. Younger age group comprises of majority 10-19 years old which touches primary, secondary, and some post-secondary level of education. Despite the pretty big ratio of secondary and post-secondary figures, our team believes these planning facilities for these 2 stage of education should consider a higher level planning zone, for example across Punggol planning area instead of just subzone. As age group tend to be more independent, accessibility is not an issue as long as the number of supply meets the demand. Thus we are only prioritising the facility for primary school here.
| |
| − |
| |
| − | ==== Punggol Town Centre’s Younger Group Population Trend ====
| |
| − | [[File:Ptc pop graph.jpg|center|500px]]
| |
| − | The Punggol Town Centre have roughly consistent growth rate in terms of number per each group. Our team observes a pretty similar case to the Matilda’s Subzone where total population of 0-9 age group are way more than the other age groups. We will prioritise in building more preschools, kindergarten and primary schools for these age groups.
| |
| − |
| |
| − | ==== Waterway East’s Younger Group Population Trend ====
| |
| − | [[File:Waterway east pop graph.jpg|center|500px]]
| |
| − | The Waterway East’s have also a roughly consistent dominant total of age group 0 - 9. Our team believes that this trend of dominant age group of 0 - 9 years old is not random, the fact that it has appeared to be distinctly apparent on 3 out of 5 occupied subzone. This trend also implies that most of current Punggol residents are young family and it is continuously adding. If we consider the current social norm in Singapore, newly married couples will tend to look for a new BTO as they venture out to a new phase of life together. Coupling with the recent BTO launches especially in the Northshore subzone, we expect the same pattern to happen again. Where it emphasis the need of more children facilities in the region.
| |
| − |
| |
| − | As we focus on providing children facilities especially the education needs, we will roughly measure the approximate ratio of available educational facilities on each subzone, number of pre-school, kindergarten and pre-schools, and lastly the total of 0-9 age group.
| |
| − |
| |
| − | [[File:Assumption table.jpg|center|300px]]
| |
| − | [[File:Generating childcare needed.jpg|center|500px]]
| |
| − |
| |
| − | Ref:
| |
| − | * “Punggol has an estimated HDB resident population of 187,800 and we manage 49,909 flats in the town (as of September 2019)”
| |
| − | * https://www.hdb.gov.sg/cs/infoweb/about-us/history/hdb-towns-your-home/punggol
| |
| − | * https://mothership.sg/2019/09/punggol-point-bto-september-2019/
| |
| − |
| |
| − | Facilities to Cater for the Younger Population’s Needs:
| |
| − | * Mainly narrowed down in ensuring that school for 0-9 years old age group are all provided
| |
| − | * Building of new library looking at the trends of younger group rise:
| |
| − | ** However its already planned. Punggol's library is currently being built and will be available in 2021.
| |
| − | *** [https://www.channelnewsasia.com/news/singapore/punggol-town-hub-2021-hawker-centre-library-10800152 “Punggol Town Hub to open in 2021”]
| |
| − |
| |
| − |
| |
| − | == Land Suitability Analysis (Green Zone) For School Redevelopment ==
| |
| − | In this section we will explore options in meeting the younger population needs especially in catering for the preschool and primary school needs as mentioned in the previous section. We note that there is a greater demand yet limited supply of schools in order to fulfill the Masterplan 2019’s vision of Punggol as a place to play-work-learn-live. Going back to the numbers, 5 out 7 subzones in Punggol are currently growing in terms of the number of population between 0 - 9 years old. Moreover, a further migration of the economic active especially the newly married couples through the recent purchase of BTOs will pose as an increase potential number of these age group.
| |
| − |
| |
| − | [[File:Current Available Childcare.jpg|center|500px]]
| |
| − |
| |
| − | The above map shows the currently available childcare centre and schools in Punggol retrieved from the Data.Gov site, shows a lack of supply for the demand to meet the current vision. Next, we will evaluate alternative recommendations that can be performed. We will apply a land suitability analysis to predict where in Punggol subzones can we add on the number of supply for this need.
| |
| − |
| |
| − | For this land suitability, we will develop what we call a green zone to identify preferred locations with multi-weighted criterias with the following suggested factors:
| |
| − | * '''Economic factor''': < =15deg slope for an ease of construction development which results in no additional time and manpower cost. Our team aims to look at the potential of building an integrated schools within pre-existing buildings, the reason is to leverage and optimise the use of empty & reserved land for something else. Thus, the slope standardisation method was not performed.
| |
| − | * '''Road Accessibility factor''': <= 100m from roads for ease of private transportation.
| |
| − | * '''Children Risks Avoidance factor''': >= 150m away from school as a highly important factor as parents would want to send their kids to a less risky locations with lesser construction areas.
| |
| − | * '''Favourable Objects Proximity factor''': <= 500m from favourable objects for better outdoor learning possibilities such as empty fields, grass, playground, etc.
| |
| − | * '''Public Transport Accessibility factor''': <= 200m from public transportation data points for convenience of majority population.
| |
| − | * '''Residential Proximity factor''': <= 300m from residentials because we want to go back to the Masterplan 2019 vision to create Punggol as a place to play-work-learn-live.
| |
| − |
| |
| − | [[File:Pair wise matrix.jpg|center|500px]]
| |
| − | We make use of the SAGA Analytical Hierarchical Process to simulate and ensure the consistency weightage based on what is a priority. The above picture shows the priority matrix we have plotted.
| |
| − | [[File:Randomness index.jpg|center|300px]]
| |
| − | [[File:Consistency check Punggol.jpg|center|300px]]
| |
| − | The current random index represents a consistent prioritisation matrix by weighing Economic factor as 18.9%, road accessibility factor as 9.2%, children risks avoidance factor as 33.7%, favourable Objects Proximity factor as 6.7%, public transport accessibility factor as 12%, and residential Proximity factor as 19.4%.
| |
| − |
| |
| − | children risks avoidance, residential proximity factor, economic factor, public transport accessibility factor, road accessibility factor and favourable objects proximity factor in that order.
| |
| − |
| |
| − | === Methods Taken ===
| |
| − | # Binary land suitability modelling by using raster-based GIS operations in QGIS. By transforming export vector layers into raster layer for computation. Each layer attributes were added with a `POI_CODE` = 1 to represent the binary value.
| |
| − | [[File:Buffered joint public transport.jpg|center|500px]]
| |
| − | # Catering to MRT/LRT stations and bus stops in Punggol, we apply buffering from the vector geometric tools of 50m dimension to represent its station reachability.
| |
| − | [[File:Computer Slope DEM.jpg|center|500px]]
| |
| − | # Next, we perform `Rasterize (Vector to Raster)` to each `POI_CODE` function to convert into raster format.
| |
| − | # For each Rasterized vector, we generate a proximity analysis using the `Raster > Analysis > Proximity (Raster Distance)`.
| |
| − | [[File:Raster Calc.jpg|center|500px]]
| |
| − | # Ranking land suitability modelling of the generate raster-based layers, we perform the binary multiplication with the analysed weightage for each factor using the Raster Calculator.
| |
| − | [[File:Binary Matrix Result.jpg|center|500px]]
| |
| − | # The binary model is generated, however we need to clip raster to fit the Punggol subzone using the `Clip Raster by Mask Layer` of the MP14 subzone boundary.
| |
| − | # Finally, we run `QGIS2Web` plug-in and deployed analysis app on the Heroku platform. The product can be found here.
| |
| − | * [https://punggol-school-greenzone.herokuapp.com Deployed Punggol Green Zone Land Suitability Map]
| |
| − |
| |
| − | == Results ==
| |
| − | [[File:Result 1 map.jpg|center|700px]]
| |
| − | The above map shows the overall green zone suitability map for building new primary and preschool. The darker the green zone represents a more suitable location according to the weighted analysis.
| |
| − |
| |
| − | Firstly, the Matilda, Punggol Town Centre, Punggol Field, and Waterway East has the most 0-9 age group population. However, the current figure of child centres and primary schools does not meet its tremendous demand. We can observe visually and count manual how many centres are there. This should be a priority that the government should prioritise because we are talking about ensuring about providing a good quality education for the future generations of Singapore. Between this 4 populated subzones most of the recommended locations are located at the heartbeat of Singapore which ensures the nearby proximity to community facilities, public transport, road network, and residentials.
| |
| − |
| |
| − | [[File:Change Detection Landuse.jpg|center|400px]]
| |
| − | The challenge now is that the recommended green zones are populated with buildings, thus no empty land to build.
| |
| − |
| |
| − | [[File:Preschool integrated.jpg|center|400px]]
| |
| − | Source: https://goodyfeed.com/6-facts-about-preschools-under-hdb-blocks-besides-the-fact-that-theyre-everywhere/
| |
| − |
| |
| − | Our team believes that this challenge can pose as an opportunity in embedding preschool under the HDB blocks and future new residentials as seen as the picture above. Additionally, as there is a high demand and low supply preschools in the Punggol region we can see the building of preschools as an open job opportunities for new teachers thus tackling Punggol as a place to play-work-learn-live.
| |
| − |
| |
| − | [[File:Mp2018.jpg|center|600px]]
| |
| − | Going back to the green zone land suitability analysis, the Northshore region will experience an exponential growth of economic active and the younger group age group with only 3 pre schools at the moment. The map above depicts the on-going Punggol redevelopment from Master Plan 2008. We can see that learners and creative corridors are being built nearby the subzone, that will most likely be the best place to plan the redevelopment of the facilities.
| |
| − |
| |
| − | === Data Sources ===
| |
| − | * Master Plan 2014 Subzone Boundary from URA. This data can be downloaded from data.gov.sg.
| |
| − | * Roads, buildings, land use data from OpenStreetMap (OSM) data sets.
| |
| − | * Child care layer from Data.gov.
| |
| − | * Bus stops and mrt data points from DataMall.
| |
| − | * ASTER Global Digital Elevation Model (GDEM) dataset jointly prepared by NASA and METI, Japan. This data can be downloaded from NASA’s EarthData [https://search.earthdata.nasa.gov/search?m=-7.175!25.59375!1!1!0!0%2C2 Search site].
| |
| − |
| |
| − | == Why Creating a Live-Work-Play-Learn Community can be challenging especially for the economic active? ==
| |
