Difference between revisions of "RiskMappers Proposal"

From IS415-Geospatial Analytics for Business Intelligence
Jump to navigation Jump to search
 
(6 intermediate revisions by one other user not shown)
Line 38: Line 38:
 
</div>
 
</div>
 
||
 
||
−
<b>Issue 1 - Risk to Students</b><br>
+
<b>Risk in Singapore</b><br>
−
Risk and hazard are terms commonly used to describe aspects of the potential for harm caused by environmental factors and other agents. Since 2014, Singapore has been striving to achieve the vision of being a smart nation. The most integral step in this direction is the analysis and assessment of risk, for it is only by doing so that we can build a healthy, safe and prepared smart nation. This is especially so for the future generations of our country. Children and teenagers aged from 6 to 16 could be easily affected by possible risk around them. Therefore, it is important for us to understand the vicinity of the schools that the younger generations attend. This will help parents choose the right school for their kids.
+
Since 2014, Singapore has been striving to achieve the vision of being a smart nation. The most integral step in this direction is the analysis and assessment of risk, for it is only by doing so that we can build a healthy, safe and prepared smart nation. After all the steps taken by the Singaporean government and society to be more risk-free, it is important to understand our vulnerability - in terms of dominant contributing factors, location and key institutions that could potentially be affected by these risks. To address this, we identify the risks posed to a specific target group of the population, school students, so as to narrow our focus and understand these risks better. Additionally, we will analyse the public service infrastructure in place in terms of 24 hour response institutions. We demonstrate the potential of R shiny app using interactive map to explore and analyse both sides of vulnerability and preparedness with respect to risk.
−
|-
 
−
|
 
−
<div style="padding: 17px">
 
−
[[File:IS415-1819-RiskMappers-Technology-Proposal2.png|100px|center|Jury]]
 
−
</div>
 
−
||
 
−
<b>Issue 2 - Response Time</b><br>
 
−
We are all aware that we are susceptible to multiple types of risk at any given point in time.  Since 2014, Singapore has been striving to achieve the vision of being a smart nation. This vision also includes the ability to respond to threats and risks in the most efficient and effective manner possible. It is for this reason that SGSecure was launched in 2016. One integral component of response time to risk is proximity to response institutions, such as Police Stations, Hospitals and Fire Stations. Therefore, for the purpose of this study, we would be analysing whether given your proximity to an institution that has a risk associated with it, the response institutions will be able to effectively and efficiently respond and attend to the threat. The response institutions are,
 
  
−
<b>1. Hospitals, <br>
+
Risk and hazard are terms commonly used to describe aspects of the potential for harm caused by environmental factors and other agents. In Singapore’s endeavour to be a healthy, safe and prepared smart nation, the most important age group of the population is of children - the future generations of our country. Children and teenagers aged 6 thru 16 are in the most susceptible and impressionable years of their life and therefore, it is important for us to better understand the vicinity of institutions that younger generations attend, the key ones being primary and secondary schools. This analysis will also help parents in choosing schools while being aware of the potential risks and vulnerabilities their children might be exposed to. For the sake of scope, we have restricted ourselves to three types of risks - health (tobacco and unhealthy eateries), entertainment (arcades) and terrorist (petrol stations, as a representative of the same). We then analyse the total number of risk factors to assign a risk score to each school that is later mapped out.
−
2. Fire station, <br>
 
−
3. Police Station<br> </b>
 
  
 +
With the launch of SGSecure in 2016, it is evident that Singapore’s government has been taking emergency preparedness seriously. Therefore, the second part of our analysis, the response analysis is with regards to the key public service institutions that are expected to operate 24/7 and include emergency rooms in hospitals, fire stations and police stations.
 
|-
 
|-
 
|}
 
|}
Line 67: Line 58:
  
 
<br>Layers
 
<br>Layers
−
<br>- Health (Tobacco Store / Unhealthy Eatries)
+
<br>- Health Risk (Tobacco Store / Unhealthy Eatries)
−
<br>- Explosive (Petrol Station)
+
<br>- Terrorist Risk (Petrol Station)
−
<br>- Social (Arcade)
+
<br>- Entertainment Risk (Arcade)
 
|-
 
|-
 
|
 
|
Line 90: Line 81:
 
|}
 
|}
  
−
<!-- END OF PROJECT MOTIVATION --->
+
<!-- END OF PROJECT DIRECTION--->
  
  
Line 125: Line 116:
 
<div style="background: #e58824; padding: 20px; line-height: 0.3em; text-indent: 16px;letter-spacing:0.1em;font-size:26px"><font color=#fbfcfd face="Bebas Neue">PROJECT DATA SOURCE</font></div>
 
<div style="background: #e58824; padding: 20px; line-height: 0.3em; text-indent: 16px;letter-spacing:0.1em;font-size:26px"><font color=#fbfcfd face="Bebas Neue">PROJECT DATA SOURCE</font></div>
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
 
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left">
−
For now, our team's datasets are retrieved from <b>https://data.gov.sg</b><br>
+
Our team's datasets are retrieved from <b>https://data.gov.sg</b><br>
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 
|-
 
|-
Line 144: Line 135:
 
Both Issue
 
Both Issue
 
||
 
||
−
<b>data retrieve from</b> https://docs.onemap.sg/#onemap-rest-apis
+
https://docs.onemap.sg/#onemap-rest-apis
 
|-
 
|-
 
|
 
|
Line 165: Line 156:
 
Issue 1: Risk to Students
 
Issue 1: Risk to Students
 
||
 
||
−
https://www.hpb.gov.sg/
+
https://data.gov.sg/dataset/healthier-eateries
 
|-
 
|-
 
|  
 
|  
Line 174: Line 165:
 
Issue 1: Risk to Students
 
Issue 1: Risk to Students
 
||
 
||
−
https://www.hpb.gov.sg/
+
https://data.gov.sg/dataset/listing-of-licensed-tobacco-retailers
 
|-
 
|-
 
|  
 
|  
Line 194: Line 185:
 
Issue 2: Response Time
 
Issue 2: Response Time
 
||
 
||
−
<b>data retrieve from</b> https://docs.onemap.sg/#onemap-rest-apis
+
https://docs.onemap.sg/#onemap-rest-apis
 
|-
 
|-
 
|  
 
|  
Line 203: Line 194:
 
Issue 2: Response Time
 
Issue 2: Response Time
 
||
 
||
−
<b>data retrieve from</b> https://docs.onemap.sg/#onemap-rest-apis
+
https://docs.onemap.sg/#onemap-rest-apis
 
|-
 
|-
 
|  
 
|  
Line 212: Line 203:
 
Issue 2: Response Time
 
Issue 2: Response Time
 
||
 
||
−
<b>data retrieve from</b> https://docs.onemap.sg/#onemap-rest-apis
+
https://docs.onemap.sg/#onemap-rest-apis
 
|-
 
|-
 
|}
 
|}
  
−
Our team is still searching online for more available datasets. Unformatted Data are in different formats (For example, Excel Format). We placed them as part of our data because we require some of the information inside the data. Our team will be doing data cleaning / data transformation on data do not have a proper KML/SHP file format.
 
 
</div>
 
</div>
  
Line 252: Line 242:
 
|-
 
|-
 
|
 
|
−
Proposal 1: Conversion of Shape File to Raster Data
+
Issue 1: Conversion of Shape File to Raster Data
 
||  
 
||  
 
Kaiyang
 
Kaiyang
Line 261: Line 251:
 
|-
 
|-
 
|
 
|
−
Proposal 1: Linking required variables from Server code to UI code
+
Issue 1: Linking required variables from Server code to UI code
 
||  
 
||  
 
Kaiyang
 
Kaiyang
Line 270: Line 260:
 
|-
 
|-
 
|  
 
|  
−
Proposal 1: Set up of Raster Data based on Singapore Map
+
Issue 1: Set up of Raster Data based on Singapore Map
 
||  
 
||  
 
Kaiyang
 
Kaiyang
Line 279: Line 269:
 
|-
 
|-
 
|  
 
|  
−
Proposal 1: Mapping Data onto Leaflet
+
Issue 1: Mapping Data onto Leaflet
 
||  
 
||  
 
Kaiyang
 
Kaiyang
Line 288: Line 278:
 
|-
 
|-
 
|  
 
|  
−
Proposal 1: Calculation of Raster Data using Interpolation to show choropleth map on Singapore Map
+
Issue 1: Calculation of Raster Data using Interpolation to show choropleth map on Singapore Map
 
||  
 
||  
 
Kaiyang
 
Kaiyang
Line 297: Line 287:
 
|-
 
|-
 
|  
 
|  
−
Proposal 1: Integrating Code with UI
+
Issue 1: Integrating Code with UI
 
||  
 
||  
 
Kaiyang
 
Kaiyang
Line 306: Line 296:
 
|-
 
|-
 
|  
 
|  
−
Proposal 1: Create buffer for each risk and calculate the risk score for each school
+
Issue 1: Create buffer for each risk and calculate the risk score for each school
 
||  
 
||  
 
Kaiyang
 
Kaiyang
Line 315: Line 305:
 
|-
 
|-
 
|  
 
|  
−
Proposal 1: Select the specific of risk within the buffer for each school
+
Issue 1: Select the specific of risk within the buffer for each school
 
||  
 
||  
 
Kaiyang
 
Kaiyang
Line 342: Line 332:
 
|-
 
|-
 
|  
 
|  
−
Proposal 2: Testing One Map API to extract location data
+
Issue 2: Testing One Map API to extract location data
 
||  
 
||  
 
Mark
 
Mark
Line 351: Line 341:
 
|-
 
|-
 
|  
 
|  
−
Proposal 2: Conversion of One Map CSV data to Spatial data for mapping
+
Issue 2: Conversion of One Map CSV data to Spatial data for mapping
 
||  
 
||  
 
Mark
 
Mark
Line 360: Line 350:
 
|-
 
|-
 
|  
 
|  
−
Proposal 2: Calculate route distance and timing of Risk from K Nearest Neighbour of the Response layer using One Map API
+
Issue  2: Calculate route distance and timing of Risk from K Nearest Neighbour of the Response layer using One Map API
 
||   
 
||   
 
Mark
 
Mark
Line 369: Line 359:
 
|-
 
|-
 
|  
 
|  
−
Proposal 2: One Map API Extraction of Location Data to CSV files
+
Issue 2: One Map API Extraction of Location Data to CSV files
 
||   
 
||   
 
Mark
 
Mark
Line 378: Line 368:
 
|-
 
|-
 
|  
 
|  
−
Proposal 2: Mapping data onto Leaflet Map
+
Issue 2: Mapping data onto Leaflet Map
 
||   
 
||   
 
Mark
 
Mark
Line 387: Line 377:
 
|-
 
|-
 
|  
 
|  
−
Proposal 2: Linking required variables from Server code to UI code
+
Issue 2: Linking required variables from Server code to UI code
 
||  
 
||  
 
Mark
 
Mark
Line 396: Line 386:
 
|-
 
|-
 
|  
 
|  
−
Proposal 2: Integrating Code with UI
+
Issue 2: Integrating Code with UI
 
||   
 
||   
 
Mark
 
Mark
Line 480: Line 470:
 
|-
 
|-
 
|  
 
|  
−
<b>Topographic Map Singapore (http://en-sg.topographic-map.com/places/Singapore-1331643/)</b>
+
<b>Over Function (https://cran.r-project.org/web/packages/sp/vignettes/over.pdf)</b>
 
|-
 
|-
 
|  
 
|  
−
[[File:IS415-1819-RiskMappers-Reference4.jpg|center|1000px]]
+
[[File:IS415-1819-RiskMappers-Reference4.jpg|center|600px]]
 
|-
 
|-
 
|  
 
|  
−
Using this as a reference to create a risk intensity map of the entire singapore based on the locations of the particular high risk structure and its risk factors
+
Using this as a reference to calculate the total risk score of each school based on whether their location is within the certain distance buffer of the risk factor<br>
 +
Used for: Issue 1: Risk to Students
 
|-
 
|-
 
|  
 
|  
Line 495: Line 486:
 
|-
 
|-
 
|  
 
|  
−
Using this as a reference to create a colored distance buffer for user to know if a location that user chose is beside a risk location.  
+
Using this as a reference to create a colored distance buffer for user to know if a location that user chose is beside a risk location.<br>
−
|-
+
Used for: Issue 2: Reponse Time
−
|
 
−
<b>Weather Mapping (http://www.weather.gov.sg/weather-rain-area-50km)</b>
 
−
|-
 
−
|
 
−
[[File:IS415-1819-RiskMappers-Reference3.jpg|center|1000px]]
 
−
|-
 
−
|
 
−
Using this as a reference to create each different risk in different colors. Adding checkboxes to allow filters in between risk based on conditions.
 
−
<br>Maybe create intensity of the risk (Idea just for now. Might not use)
 
 
|-
 
|-
 
|  
 
|  
Line 514: Line 496:
 
|-
 
|-
 
|  
 
|  
−
Using this as a reference to create R shiny map.
+
Using this as a reference to create R shiny map.<br>
 +
Used for: UI
 
|-
 
|-
 
|  
 
|  
Line 523: Line 506:
 
|-
 
|-
 
|  
 
|  
−
Using this as a reference to create setting for response time estimation.
+
Using this as a reference to create setting for response time estimation.<br>
 +
Used for: Issue 1: Risk to Students & UI
 
|-
 
|-
 
|}
 
|}
Line 535: Line 519:
 
|-
 
|-
 
|  
 
|  
−
<div style="text-align:center, text-size: 10px"><b>Proposal 1: Raster Map Risk Analysis (REMOVED)</b></div>
+
<div style="text-align:center, text-size: 10px"><b>Issue 1: Risk to Students</b></div>
−
|-
 
−
|
 
−
[[File:IS415-1819-RiskMappers-Storyboard-Risk.jpg|center|1000px]]
 
−
|-
 
−
|
 
−
Our team plans to create a dashboard for our users to run an analysis on different risk factors and how it cause to some of Singapore key locations (Such as potential Terrorist attacks on MRT Stations) and how these risk locations can affect other locations nearby such as (Government Sectors location, MRT Stations, Schools, etc). User will be able to choose the specific risk type, potential risk locations, potential nearby locations that might be affected as well as set the buffer size for the risk identified.
 
−
|-
 
−
|
 
−
<div style="text-align:center, text-size: 10px"><b>Proposal 1: Risk to Students (NEW)</b></div>
 
 
|-
 
|-
 
|
 
|
Line 553: Line 528:
 
|-
 
|-
 
|  
 
|  
−
<div style="text-align:center, text-size: 10px"><b>Proposal 2: Response Time Analysis</b></div>
+
<div style="text-align:center, text-size: 10px"><b>Issue 2: Response Time Analysis</b></div>
 
|-
 
|-
 
|
 
|
Line 571: Line 546:
 
|-
 
|-
 
|  
 
|  
−
<div style="text-align:center, text-size: 10px"><b>Proposal 1: Raster Map Risk Analysis (REMOVED)</b></div>
+
<div style="text-align:center, text-size: 10px"><b>Issue 1: Risk to Students (NEW)</b></div>
 
|-
 
|-
 
|
 
|
 
[[File:IS415-1819-RiskMappers-Prototype-Risk.jpg|center|1000px]]
 
[[File:IS415-1819-RiskMappers-Prototype-Risk.jpg|center|1000px]]
−
|-
 
−
|
 
−
Our team plans to create a dashboard for our users to run an analysis on different risk factors and how it cause to some of Singapore key locations (Such as potential Terrorist attacks on MRT Stations) and how these risk locations can affect other locations nearby such as (Government Sectors location, MRT Stations, Schools, etc). User will be able to choose the specific risk type, potential risk locations, potential nearby locations that might be affected as well as set the buffer size for the risk identified.
 
−
 
−
You may download our HTML file here,
 
−
https://drive.google.com/file/d/1Lh5BZ8vJY7OM-P5F2Fcpz19wg4oWSzG6/view?usp=sharing
 
−
|-
 
−
|
 
−
<div style="text-align:center, text-size: 10px"><b>Proposal 1: Risk to Students (NEW)</b></div>
 
−
|-
 
−
|
 
−
[[File:IS415-1819-RiskMappers-Storyboard-Risk-2.jpg|center|1000px]]
 
 
|-
 
|-
 
|  
 
|  
 
Our team plans to create a dashboard for our users to run an analysis on how different risk (Petrol Stations, Tobacco Store, Unhealthy Eateries and Arcades) could affect schools within their vicinity. Risk score will be calculated for each school. Users will be able to look at the highest and lowest risk score schools. Users will also be able to find out specific risk and their location for each school on in a table form.
 
Our team plans to create a dashboard for our users to run an analysis on how different risk (Petrol Stations, Tobacco Store, Unhealthy Eateries and Arcades) could affect schools within their vicinity. Risk score will be calculated for each school. Users will be able to look at the highest and lowest risk score schools. Users will also be able to find out specific risk and their location for each school on in a table form.
−
 
 
|-
 
|-
 
|
 
|
−
<div style="text-align:center, text-size: 10px"><b>Proposal 2: Response Time Analysis</b></div>
+
<div style="text-align:center, text-size: 10px"><b>Issue 2: Response Time Analysis</b></div>
 
|-
 
|-
 
|
 
|
Line 629: Line 591:
 
The team plans on using R and creating an R dashboard for the project.
 
The team plans on using R and creating an R dashboard for the project.
 
||
 
||
−
- Initial hands-on experience during class
+
- Initial hands-on experience during class<br>
−
- DataCamp course on R shiny and geospatial analysis
+
- DataCamp course on R shiny and geospatial analysis<br>
−
- Independent learning on R
+
- Independent learning on R<br>
−
- Independent learning on R
+
- Independent learning on R<br>
 
- Peer learning and sharing
 
- Peer learning and sharing
 
||
 
||
−
(Add Later)
+
We managed to solve our technical challenge with the following:<br>
 +
- Found examples online<br>
 +
- Asked Professor Kam for help
 
|-
 
|-
 
|  
 
|  
Line 646: Line 610:
 
Having a systematic process while working together in order to maximise efficiency e.g. taking turns to clean, transform and perform checks on the data to ensure accuracy.
 
Having a systematic process while working together in order to maximise efficiency e.g. taking turns to clean, transform and perform checks on the data to ensure accuracy.
 
||
 
||
−
(Add Later)
+
We managed to solve our technical challenge with the following:<br>
 +
- Found examples of geocoding and csv conversion online<br>
 +
- Used Excel to do basic data transformation<br>
 +
- Used QGIS to convert csv to SHP file
 
|-
 
|-
 
|  
 
|  
Line 657: Line 624:
 
Working together and meeting up to understand and decide on what data to extract, to analyse or to reject.
 
Working together and meeting up to understand and decide on what data to extract, to analyse or to reject.
 
||
 
||
−
(Add Later)
+
We managed to solve our technical challenge with the following:<br>
 +
- Meeting up and integrate together<br>
 +
- Search for debugging solutions online
 
|-
 
|-
 
|  
 
|  
Line 666: Line 635:
 
Determining the most effective way to visualise and display the data in an interactive format is of essence. It is necessary that the most important information is easily discernible from the map.
 
Determining the most effective way to visualise and display the data in an interactive format is of essence. It is necessary that the most important information is easily discernible from the map.
 
||
 
||
−
Gain exposure to different mapping techniques.
+
Gain exposure to different mapping techniques.<br>
−
Follow and revisit techniqes explored in class
+
Follow and revisit techniqes explored in class<br>
 
Also look at datacamp courses.
 
Also look at datacamp courses.
 
||
 
||
−
(Add Later)
+
We managed to solve our technical challenge with the following:<br>
 +
- Found examples online<br>
 +
- Asked Professor Kam for help
 
|-
 
|-
 
|}
 
|}
Line 751: Line 722:
 
|-
 
|-
 
|  
 
|  
−
5.
+
6.
 
||
 
||
 
Leaflet Notes
 
Leaflet Notes
 
||
 
||
 
https://www.youtube.com/channel/UCVvv6HyBo9pg5-URPeJPQEw
 
https://www.youtube.com/channel/UCVvv6HyBo9pg5-URPeJPQEw
 +
|-
 +
|
 +
7.
 +
||
 +
Isochrones Example
 +
||
 +
https://www.hydrol-earth-syst-sci.net/2/265/1998/hess-2-265-1998.pdf
 +
|-
 +
|
 +
8.
 +
||
 +
Isochrones Example
 +
||
 +
https://www.atlasobscura.com/articles/isochrone-maps-commutes-travel-times
 +
|-
 +
|
 +
9.
 +
||
 +
Over Function Example
 +
||
 +
https://cran.r-project.org/web/packages/sp/vignettes/over.pdf
 +
|-
 +
|
 +
10.
 +
||
 +
Sapply Function Example
 +
||
 +
https://cengel.github.io/rspatial/3_spDataOps.nb.html
 +
|-
 +
|
 +
11.
 +
||
 +
Batch Geocoding
 +
||
 +
https://www.doogal.co.uk/BatchGeocoding.php
 +
|-
 +
|
 +
12.
 +
||
 +
JSON to CSV
 +
||
 +
https://json-csv.com/
 +
|-
 +
|
 +
13.
 +
||
 +
CSV to SHP
 +
||
 +
https://mygeodata.cloud/converter/csv-to-shp
 
|-
 
|-
 
|}
 
|}

Latest revision as of 17:18, 15 April 2018



IS415-1819-RiskMappers-Logo.png



HOME

PROPOSAL

POSTER

APPLICATION

RESEARCH PAPER



PROJECT MOTIVATION
Jury

Risk in Singapore
Since 2014, Singapore has been striving to achieve the vision of being a smart nation. The most integral step in this direction is the analysis and assessment of risk, for it is only by doing so that we can build a healthy, safe and prepared smart nation. After all the steps taken by the Singaporean government and society to be more risk-free, it is important to understand our vulnerability - in terms of dominant contributing factors, location and key institutions that could potentially be affected by these risks. To address this, we identify the risks posed to a specific target group of the population, school students, so as to narrow our focus and understand these risks better. Additionally, we will analyse the public service infrastructure in place in terms of 24 hour response institutions. We demonstrate the potential of R shiny app using interactive map to explore and analyse both sides of vulnerability and preparedness with respect to risk.

Risk and hazard are terms commonly used to describe aspects of the potential for harm caused by environmental factors and other agents. In Singapore’s endeavour to be a healthy, safe and prepared smart nation, the most important age group of the population is of children - the future generations of our country. Children and teenagers aged 6 thru 16 are in the most susceptible and impressionable years of their life and therefore, it is important for us to better understand the vicinity of institutions that younger generations attend, the key ones being primary and secondary schools. This analysis will also help parents in choosing schools while being aware of the potential risks and vulnerabilities their children might be exposed to. For the sake of scope, we have restricted ourselves to three types of risks - health (tobacco and unhealthy eateries), entertainment (arcades) and terrorist (petrol stations, as a representative of the same). We then analyse the total number of risk factors to assign a risk score to each school that is later mapped out.

With the launch of SGSecure in 2016, it is evident that Singapore’s government has been taking emergency preparedness seriously. Therefore, the second part of our analysis, the response analysis is with regards to the key public service institutions that are expected to operate 24/7 and include emergency rooms in hospitals, fire stations and police stations.


PROJECT DIRECTION

Geographical Risk Analysis

Each layer represents a specific area of risk which certain institutions pose to a student. By including each layer it allows users to visualize possible risks in each locale.


Layers
- Health Risk (Tobacco Store / Unhealthy Eatries)
- Terrorist Risk (Petrol Station)
- Entertainment Risk (Arcade)

Functionality

1. Visual Risk Analysis

- With our visualization, users will be able to determine the possible risk exposure in each school.
- Upon adding layers the increased overlapping areas will increase in color intensity for the school.
- The more saturated the color, the more risk exposed the school is.

2. Statistical Risk Analysis

- Our visualization calculates the risk score based on *distance of each locale* from a potential risk point.
- Users will be able to view user selected locales "risk score" to determine how much risk is each area exposed to.

Usage

Our visualization allows users to comprehend how much potential risk each area is exposed to. From this information, we hope to aid in Singapore's goals of Smart City planning to take into consideration not only ease of access to the population but also the risk different institutions pose to inhabitants.


PROJECT OBJECTIVE
Jury

Issue 1
1. Identify and highlight the institutions that conduct activities that pose risks to schools and students
2. Analyse and evaluate the risk score of each school

Jury

Issue 2
1. Identify and highlight the institutions that conduct activities that pose risks to society
2. Identify and highlight the institutions that could respond to these risks and their response limitations
3. Analyse and evaluate whether or not a risk can be responded to in a given time frame based on limitations such as coverage of response institutions


PROJECT DATA SOURCE

Our team's datasets are retrieved from https://data.gov.sg

Title

Format

Used for Issue 1 or 2

Website Link

Primary/Secondary School

CSV

Both Issue

https://docs.onemap.sg/#onemap-rest-apis

Petrol Station

Unformatted (format to csv)

Issue 1: Risk to Students

https://www.caltex.com/sg/find-a-caltex-station.html
https://www.esso.com.sg/our-stations
https://www.spc.com.sg/our-business/spc-service-station/station-locator
https://www.shell.com.sg/motorists/shell-station-locator.html

Unhealthy Eateries

KML

Issue 1: Risk to Students

https://data.gov.sg/dataset/healthier-eateries

Tobacco License

CSV

Issue 1: Risk to Students

https://data.gov.sg/dataset/listing-of-licensed-tobacco-retailers

Acrades

Unformatted (format to csv)

Issue 1: Risk to Students

http://www.streetdirectory.com/businessfinder/company_branch/157187/127270/
https://www.yelp.com.sg/search?cflt=arcades&find_loc=Singapore
http://www.timezone.com.sg/Location

Hospital

CSV

Issue 2: Response Time

https://docs.onemap.sg/#onemap-rest-apis

Police Station

CSV

Issue 2: Response Time

https://docs.onemap.sg/#onemap-rest-apis

Fire Station

CSV

Issue 2: Response Time

https://docs.onemap.sg/#onemap-rest-apis


PROJECT TIMELINE AND MILESTONES

This a ROUGH timeline of our entire project. Milestones indicated are according to IS415 AY1718 Project Wiki Page (Detailed timeline will be updated)

IS415-1819-RiskMappers-Timeline.jpg


PROJECT FUNCTION COMPLETION

Function

Developer

Expected Completion Date

Status

Required Working Files: Sorting of SHP/KML and CSV files (get required conversion if needed) for application

Kaiyang

Week 10

Done

Issue 1: Conversion of Shape File to Raster Data

Kaiyang

Week 10

Done (REMOVED)

Issue 1: Linking required variables from Server code to UI code

Kaiyang

Week 11

Done

Issue 1: Set up of Raster Data based on Singapore Map

Kaiyang

Week 11

Done (REMOVED)

Issue 1: Mapping Data onto Leaflet

Kaiyang

Week 11

Done

Issue 1: Calculation of Raster Data using Interpolation to show choropleth map on Singapore Map

Kaiyang

Week 12

Done (REMOVED)

Issue 1: Integrating Code with UI

Kaiyang

Week 12

Done

Issue 1: Create buffer for each risk and calculate the risk score for each school

Kaiyang

Week 13

Done

Issue 1: Select the specific of risk within the buffer for each school

Kaiyang

Week 13

Done

Poster

Kaiyang

Week 13

Done

User Guide: PDF User Guide

Kaiyang

Week 14

Done

Issue 2: Testing One Map API to extract location data

Mark

Week 10

Done

Issue 2: Conversion of One Map CSV data to Spatial data for mapping

Mark

Week 10

Done

Issue 2: Calculate route distance and timing of Risk from K Nearest Neighbour of the Response layer using One Map API

Mark

Week 11

Done

Issue 2: One Map API Extraction of Location Data to CSV files

Mark

Week 11

Done

Issue 2: Mapping data onto Leaflet Map

Mark

Week 11

Done

Issue 2: Linking required variables from Server code to UI code

Mark

Week 12

Done

Issue 2: Integrating Code with UI

Mark

Week 12

Done

User Interface: Number Sliders (for buffering / proximity timing), Dropdownlist (for Color, Basemap)

Mallika

Week 10

Done

User Interface: Set up observation on R Server Code

Mallika

Week 10

Done

Backend: Pre-loading of SHP/KML/CSV files to the server

Mallika

Week 11

Done

User Interface: Set up dynamic input/output and link with Map

Mallika

Week 11

Done

User Interface: Home Page to explain the project's goals and descriptions

Mallika

Week 12

Done

Server Development

Mallika

Week 13

Done

Server Debugging

Mallika

Week 13

Done

Most functionalities are delayed due to the requirement of completing other module's project work as the deadline is earlier. The team will be dedicating the entire 6th April to 10th April to be working on GeoSpatial Project and only GeoSpatial Project


PROJECT REFERENCES TO RELATED WORK

Over Function (https://cran.r-project.org/web/packages/sp/vignettes/over.pdf)

IS415-1819-RiskMappers-Reference4.jpg

Using this as a reference to calculate the total risk score of each school based on whether their location is within the certain distance buffer of the risk factor
Used for: Issue 1: Risk to Students

Dengue Outbreak Mapping (http://outbreak.sgcharts.com)

IS415-1819-RiskMappers-Reference2.jpg

Using this as a reference to create a colored distance buffer for user to know if a location that user chose is beside a risk location.
Used for: Issue 2: Reponse Time

Shiny Example (http://shiny.rstudio.com/gallery/superzip-example.html)

IS415-1819-RiskMappers-Reference5.jpg

Using this as a reference to create R shiny map.
Used for: UI

Distance Length Mapping (https://rstudio.github.io/leaflet/shiny.html)

IS415-1819-RiskMappers-Reference6.jpg

Using this as a reference to create setting for response time estimation.
Used for: Issue 1: Risk to Students & UI


PROJECT STORYBOARD
Issue 1: Risk to Students
IS415-1819-RiskMappers-Storyboard-Risk-2.jpg

Our team plans to create a dashboard for our users to run an analysis on how different risk (Petrol Stations, Tobacco Store, Unhealthy Eateries and Arcades) could affect schools within their vicinity. Risk score will be calculated for each school. Users will be able to look at the highest and lowest risk score schools. Users will also be able to find out specific risk and their location for each school on in a table form.

Issue 2: Response Time Analysis
IS415-1819-RiskMappers-Storyboard-ResponseTime.jpg

Our team plans to create a dashboard for our users to run an analysis on different government bodied (Hospital, Police Station, Fire Station, etc) location and their ability to respond to emergency events at certain high risk location. User will be able to select a specific government body, response time and risk location to reach.


PROJECT PROTOTYPE
Issue 1: Risk to Students (NEW)
IS415-1819-RiskMappers-Prototype-Risk.jpg

Our team plans to create a dashboard for our users to run an analysis on how different risk (Petrol Stations, Tobacco Store, Unhealthy Eateries and Arcades) could affect schools within their vicinity. Risk score will be calculated for each school. Users will be able to look at the highest and lowest risk score schools. Users will also be able to find out specific risk and their location for each school on in a table form.

Issue 2: Response Time Analysis
IS415-1819-RiskMappers-Prototype-ResponseTime.jpg

Our team plans to create a dashboard for our users to run an analysis on different government bodied (Hospital, Police Station, Fire Station, etc) location and their ability to respond to emergency events at certain high risk location. User will be able to select a specific government body, response time and risk location to reach.


PROJECT KEY CHALLENGES

No.

Key Technical Challenges

Description

Proposed Solution

Outcome

1.

Unfamiliarity with R

The team plans on using R and creating an R dashboard for the project.

- Initial hands-on experience during class
- DataCamp course on R shiny and geospatial analysis
- Independent learning on R
- Independent learning on R
- Peer learning and sharing

We managed to solve our technical challenge with the following:
- Found examples online
- Asked Professor Kam for help

2.

Data Cleaning and Transformation

The data collected is generally in different formats. The scales of the data, the coordinate reference system etc. may all be different.

Having a systematic process while working together in order to maximise efficiency e.g. taking turns to clean, transform and perform checks on the data to ensure accuracy.

We managed to solve our technical challenge with the following:
- Found examples of geocoding and csv conversion online
- Used Excel to do basic data transformation
- Used QGIS to convert csv to SHP file

3.

Integrating Relevant Data from Multiple Sources

Narrowing down data collected to what is relevant to our project is imperative before we can begin its analysis.

Working together and meeting up to understand and decide on what data to extract, to analyse or to reject.

We managed to solve our technical challenge with the following:
- Meeting up and integrate together
- Search for debugging solutions online

4.

Information Presentation

Determining the most effective way to visualise and display the data in an interactive format is of essence. It is necessary that the most important information is easily discernible from the map.

Gain exposure to different mapping techniques.
Follow and revisit techniqes explored in class
Also look at datacamp courses.

We managed to solve our technical challenge with the following:
- Found examples online
- Asked Professor Kam for help


PROJECT TOOLS AND TECHNOLOGIES

The following are the tools and technologies that our team currently aims on using (to be updated)

IS415-1819-RiskMappers-Technology.jpg


MEET OUR TEAM

Group 9: RISK MAPPERS

IS415-1819-RiskMappers-Mark.png IS415-1819-RiskMappers-Mallika.png IS415-1819-RiskMappers-Kai-yang.png


REFERENCES

No.

Website Name

URL

1.

Innovative Solutions for a Smart City

https://www.smartnation.sg/resources/innovative-solutions-for-a-smart-city

2.

Smart Nation Leveraging on Technology to Improve our Urban Environment

https://www.smartnation.sg/initiatives/Living/leveraging-technology-to-improve-our-urban-environment

3.

Topographic Map

http://en-sg.topographic-map.com/places/Singapore-1331643/

4.

Shiny Widget

https://shiny.rstudio.com/gallery/widget-gallery.html https://rstudio.github.io/leaflet/shiny.html

5.

Shiny Dashboard

https://rstudio.github.io/shinydashboard/ https://www.rstudio.com/resources/webinars/dynamic-dashboards-with-shiny/ http://shiny.rstudio.com/gallery/superzip-example.html

6.

Leaflet Notes

https://www.youtube.com/channel/UCVvv6HyBo9pg5-URPeJPQEw

7.

Isochrones Example

https://www.hydrol-earth-syst-sci.net/2/265/1998/hess-2-265-1998.pdf

8.

Isochrones Example

https://www.atlasobscura.com/articles/isochrone-maps-commutes-travel-times

9.

Over Function Example

https://cran.r-project.org/web/packages/sp/vignettes/over.pdf

10.

Sapply Function Example

https://cengel.github.io/rspatial/3_spDataOps.nb.html

11.

Batch Geocoding

https://www.doogal.co.uk/BatchGeocoding.php

12.

JSON to CSV

https://json-csv.com/

13.

CSV to SHP

https://mygeodata.cloud/converter/csv-to-shp


COMMENTS

We appreciate and cherish all comments. If you have any suggestion on how to improve our project. Please help us by keying in your name and comment. Don't worry, we want to know your name so that we can thank you and ask for more details. And we don't bite. (:

No.

Name

Date

Comments

1.

Insert your Name here

Insert Date here

Insert Comment here

2.

Insert your Name here

Insert Date here

Insert Comment here

3.

Insert your Name here

Insert Date here

Insert Comment here



Retrieved from ‘https://wiki.smu.edu.sg/1718t2is415g1/index.php?title=RiskMappers_Proposal&oldid=1796’