Report: Data Synchronisation and Visualisation for Digital Government of Sabah Version 1.0

NumTitle
HARDWARE
1Visualisation Screens (3 units)
2Portable Bluetooth Folding Mini Keyboard (4 Units)
SOFTWARE PACKAGE
1FME Desktop 2020.1.3
2FME SERVER 2020.1.2.1
3PostgreSQL 12.4-1
4QGIS 3.10
5Mapp Enterprise 2019
DATA ARCHITECTURE AND FLOW
FEATURE MANIPULATION ENGINE (FME)
1Covid-19 in Malaysia by state
2Covid-19 Hospital beds utilization in Sabah
3Covid-19 Sabah to Google Sheet and Database 
4Covid-19 Sabah Zoning
5Covid-19 Data Backup
6Boundary data for the dashboards
7Kampung layer
DATA TABLE INFO
1Covid-19 in Malaysia By State
2Healthcare Facilities Location in Sabah
3Covid-19 Hospital Beds Utilization in Sabah
4Covid19 in Sabah
5Covid-19 Zoning Data for Sabah
6PKRC in Sabah
7Hospital in Sabah
DASHBOARD INFO
1Hospital Beds Utilization
a)LATEST BED OCCUPANCY
b)FACILITY
c)DAILY ICU BED OCCUPANCY RATE (%)
d)NOTES
e)DAILY BED OCCUPANCY RATE (%)
f)TREND
g)ACTIVE CASES IN SABAH
h)REMAINING COVID-19 PATIENT
i)REMAINING PUI
j)DAILY COUNT OF COVID-19 PATIENT
k)DAILY COUNT OF PUI
l)SABAH MAP
COVID19 SABAH INFOGRAPHIC
a)SITUATION IN SABAH
b)COVID ZONES
c)CONFIRMED, RECOVERED, DEATH AND ACTIVE CASE
d)COVID19 TREND
e)SABAH MAP
COVID19 PUBLIC PORTAL
HOMEPAGE https://covid19.sabahtrace.my/
COVID-19 MALAYSIA https://covid19.sabahtrace.my/covid-19-malaysia/
COVID-19 SABAH SUMMARY https://covid19.sabahtrace.my/covid-19-sabah-summary/
CUMULATIVE CASES IN SABAH https://covid19.sabahtrace.my/cumulative-cases-in-sabah/
SOP COVID-19 IN SABAH https://covid19.sabahtrace.my/sop-covid-19-in-sabah/

HARDWARE

1. Visualisers (3 units)

Brands: LG
Model:LG-OLED65C9PLA
Display64.5 in, OLED, 3840 x 2160 pixels
Refresh Rate:100Hz/120Hz
Cores:4
RAM:3GB
Storage:8GB
Dimensions:1449 x 830x 46.8mm
Warranty:3 years (Upon project commission)

2. Portable Bluetooth Folding Mini Keyboard (4 Units) 

Brands:OEM
Model:B033 Portable Bluetooth Folding Mini Keyboard
Material:Plastic + ABS
Style:Multifunctional Keyboard
Bluetooth version:3.0
Touchpad size:54.8 x 44.8 mm
Keyboard size:

304.5 x 97.95 x 8 mm (Open)

152.3 x 97.95 x 14 mm (Folding)

Power type:Lithium-ion battery
Lithium-ion battery capacity:140mAh
Working voltage:3.7V
Interface Type:Bluetooth
Working distance:10m
3 Major System:IOS/ Android/ Windows tablet phone
Warranty:1 Year (Upon project commission)

SOFTWARE PACKAGE

  1. FME Desktop 2020.1.3
Version:FME(R) 2020.1.3.0 (20201001 – Build 20632 – WIN64)
Edition:FME Database Edition (node locked-crc)
Home Folder Location:C:\Program Files\FME\
License:Commercial Licence (Perpetual) 

2. FME SERVER 2020.1.2.1 

Version:FME Server 2020.1.2.1 (Build 20624 – win64)
Location:http://127.0.0.1:8080/fmeserver/#/home
License:Commercial Licence (Perpetual)

3. PostgreSQL 12.4-1 

Version:4.24
Copyright:Copyright (C) 2013 – 2020, The pgAdmin Development Team
Python Version:3.8.3 (tags/v3.8.3:6f8c832, May 13 2020, 22:37:02) [MSC v.1924 64 bit (AMD64)]
Flask Version:1.0.2
Application Mode:Desktop
Location:C:\Program Files\PostgreSQL
License:Liberal Open Source License

4. QGIS 3.10 

Version:3.10.10-A Coruña
Active python plugins:db_manager;
MetaSearch;
processing
Location:C:\Program Files\QGIS 3.10
License:Open Source Geographic Information System (GIS) Licensed

5. Mapp Enterprise 2019 

Version:Mapp Enterprise 16.6.4
Type of subscription:Subscription Professional
Location:C:\Program Files\Hexagon
License purchased hours:12500hrs

DATA ARCHITECTURE AND FLOW

Figure 1

FEATURE MANIPULATION ENGINE (FME)

FME solutions that have been deployed for the Digital Government consists of three components: FME Server, FME Desktop and FME Workbench.

FME Server is a web-server application that leverages the power of FME Desktop to automate and manage data integration workflows. As a platform, FME can help your organization effectively and efficiently make better decisions backed by data. Use FME Server to run workspaces on a schedule, create Automations, or to build self-serve data portals. Stay updated by setting up notifications that alert you and your team on the status of your data. With FME Server your data can keep flowing no matter what.

FME Desktop is used in local governmentsutilities, and many other industries to facilitate data integration workflows with its powerful data conversion capabilities.

FME Workbench is an application for solving data translation and processing problems. With Workbench, underlying FME functionality is exposed in an intuitive interface that allows you to graphically define a custom data flow from the source, through transformation, to destination. Workbench has tools for defining the source and destination dataset structure (or schema) and for manipulating the geometry and attributes of spatial data.

1. Covid-19 in Malaysia by state

Short description: The source obtained from the Ministry of Health (MOH) of Malaysia website (http://covid-19.moh.gov.my/terkini-negeri) in infographic form to construct the covid19_my_state table in google sheet. Next, the covid19_my_state table is merged by attributes and geometry with the malaysia_state_boundary table from the database. Finally, the table is updated in the database and google drive. 
Name of workbench: covid19_my  
Updated info: Updated daily 
Expected result:  Updated Covid-19 in Malaysia by state data in the database and google drive. 
Location of workbench:  C:\Users\Administrator\Documents\FME\Workspaces 
Prerequisite: Infographic covid-19 Malaysia by state from MOH of the day. 

FME workflow to update covid19_my_state table into the database

Figure 2

2. Covid-19 Hospital beds utilization in Sabah

Short description: The source obtained from Pusat Kuarantin dan Rawatan Berisiko Rendah (PKRC) and Covid-19 treatment hospital in excel file to construct the pkrc_hospital_rawatan_covid and healthcare table in google sheet. PKRC and Covid-19 treatment hospital in excel file contain data about the healthcare facilities (PKRC and hospital) location and their bed utilization for covid-19 Patient Under Investigation (PUI) and covid-19 positive patient. All the data mentioned is in the pkrc_hospital_rawatan_covid table. While the healthcare table only stores data about the healthcare facilities. Next, the pkrc_hospital_rawatan_covid table is merged by attributes with the healthcare table. Finally, both tables are updated in the database. 
Name of workbench: healthcare  
Updated info: The Healthcare table updated when there is a new PKRC or hospital facility added. The pkrc_hospital_rawatan_covid table is updated daily. 
Expected result:  Updated Covid-19 hospital beds utilization in Sabah for covid-19 patient data in the database. 
Location of workbench:  C:\Users\Administrator\Documents\FME\Workspaces 
Prerequisite: Information about PKRC and Covid-19 treatment hospital in excel file of the day. 

FME workflow to update pkrc_hospital_rawatan_covid and healthcare tables into the database.

Figure 3

3. Covid-19 Sabah to Google Sheet and Database

Short description: The source obtained infographic image from Perbadanan Kesihtatan Negeri Sabah (PKN) and website information from Kementerian Kesihatan Malaysia (KKM) to construct covidmastertable, the master excel file. Individual Covid-19 case were stored in said excel file. Apart from that, the excel file also included the total confirmed cases, recovery cases, death cases and active cases. In addition, zoning_sbhcovid which holds zoning information for each district can be generated from the master excel file. Once updated with latest data, save the table in CSV format, and insert into the google drive and database. 
Name of workbench: sbhcovid_to_pgadmin 
Updated info: Updated daily 
Expected result:  Updated the master excel file to latest version. Afterward, updated to Google Sheet and updated its table in the database. 
Location of workbench:  C:\Users\Administrator\Documents\FME\Workspaces 
Prerequisite: Information about Covid-19 cases of the day 

a. FME workflow to save covidmastertable and zoning_sbhcovid in google sheet

Figure 4

b. FME workflow to update covidmastertable into database

Figure 5

4. Covid-19 Sabah Zoning

Short description: The source obtained from a separate sheet in master excel file, which is zoning_sbhcovid. The sheet calculates the daily confirmed, discharge, active cases of each district in Sabah. After merging zoning_sbhcovid with Sabah district polygon, the output comprised of zoning information and polygon of districts in Sabah. A heatmap can also be created using this data. 
Name of workbench: 

sbhcovid_to_pgadmin 

 

Updated info: Updated daily 
Expected result:  Updated zoning data in the database. 
Location of workbench:  C:\Users\Administrator\Documents\FME\Workspaces 
Prerequisite: zoning_sbhcovid 
Figure 6
5. Covid-19 Data Backup
Short description: This workbench will read covid19_my_state, healthcare, pkrc_hospital_rawatan_covid, and covid_mastertable tables from the database then saved it in one geo package file. The geo package file will be renamed as “covid19_(date of backup)” (example: covid19_22112020). 
Name of workbench: covid19_backup 
Updated info: Updated once a week. 
Expected result:  Update covid-19 data in a geo package file for data backup.    
Location of workbench:  C:\Users\Administrator\Documents\FME\Workspaces 
Prerequisite: covid19_my_state, healthcare, pkrc_hospital_rawatan_covid, and covid_mastertable tables from database. 
Figure 7

6. Boundary data for the dashboards

Short description: State and district polygons in geopackage file format were used in generating the dashboards. These polygon data were uploaded to database once for future usage, such as merging it with data from another table. 
Name of workbench: boundary_upload 
Updated info: Updated once 
Expected result:  Stored Malaysia state and Sabah district boundary in the database 
Location of workbench:  C:\Users\Administrator\Documents\FME\Workspaces 
Prerequisite: None 

a. FME workflow to upload Malaysia state boundary to database

Figure 8

b. FME workflow to upload Sabah district boundary to database

Figure 9

7. Kampung Layer

Short description: List of all kampung located within Sabah. All data were in the format of point data. These point data were uploaded to database once for future usage, such as merging it with data from another table. 
Name of workbench: kampung_layer 
Updated info: Updated once 
Expected result:  Stored Sabah Kampung point data in the database 
Location of workbench:  C:\Users\Administrator\Documents\FME\Workspaces 
Prerequisite: None 

a. FME workflow to upload Kampung layer to database

Figure 10

DATA TABLE INFO

1. Covid-19 in Malaysia By State 

Name of google sheets: covid19_my_state  
Short Description: Information about the covid-19 in Malaysia by state. 
Location: Located in the server database. 

Definition of each field:

No.  Column  Definition  
1.  id  Primary key  
2.  date  Date of the cases  
3.  state  State in Malaysia  
4.  new_cases Total new cases   
5.  total_cases Cumulative cases  
6.  new_deaths Total new deaths cases  
7.  total_deaths Cumulative deaths cases  
8.  new_recovered Total new recovered cases  
9.  total_recovered Cumulative recovered cases   
10.  active_cases Total active cases  
11.  zone  Red- active_cases>40  
Green- 40>active_cases>0  
Yellow- active_cases=0  

2. Healthcare Facilities Location in Sabah

Name of google sheets: Healthcare 
Short Description: Information about the PKRC and hospital facilities location in Sabah. 
Location: Located in the server database and public access folder. 

Definition of each field:

No.  Column  Definition  
1.  district_code District code  
2.  district_acronym District acronym  
3.  district_name District name  
4.  healthcare_id Healthcare unique id  
5.  name  Name of the healthcare facility  
6.  address  Address of the healthcare facility   
7.  contact  Telephone number of the healthcare facility   
8.  fax  Fax number of the healthcare facility   
9.  latitude  Latitude of the healthcare facility  
10.  longitude  Longitude of the healthcare facility  
11.  facility_type Facility type of the healthcare facility  
12.  facility_code Facility code of the healthcare facility  
13.  x  X coordinate of the healthcare facility  
14.  y  Y coordinate of the healthcare facility  

3. Covid-19 Hospital Beds Utilization in Sabah 

Name of google sheets: pkrc_hospital_rawatan_covid 
Short Description: Information about the PKRC and hospital beds utilization for covid-19 patients in Sabah. 
Location: Located in the server database and public access folder. 

Definition of each field:

No.  Column  Definition  
1.  id  Primary key  
2.  x  X coordinate of the healthcare facility  
3.  y  Y coordinate of the healthcare facility  
4.  district_code District acronym  
5.  district_name District name  
6.  healthcare_id Healthcare unique id  
7.  name  Name of the healthcare facility  
8.  address  Address of the healthcare facility   
9.  contact  Telephone number of the healthcare facility   
10.  fax  Fax number of the healthcare facility   
11.  facility_type Facility type of the healthcare facility  
12.  facility_code Facility code of the healthcare facility  
13.  datetime  Report date and time  
14.  bed_count Total bed count   
15.  bed_occupied Total bed occupied   
16.  bed_vacant Total bed vacant  
17.  bor Bed occupancy rate in percentage   
18.  bor_alert Bed occupancy rate alert:   
Red- bor>75%  
Yellow- 75%>bor>50%  
White- bor<50%  
19.  covid Total bed for covid-19 patient  
20.  pui Total bed for covid-19 patient under investigation (PUI)  
21.  icu_bed_count Total icu bed count   
22.  icu_bed_occupied Total icu bed occupied   
23.  icu_bed_vacant Total icu bed vacant  
24.  icu_bor Icu bed occupancy rate in percentage   
25.  icu_bor_alert 

Icu bed occupancy rate alert:   

Red- bor>75%  

Yellow- 75%>bor>50%  

White- bor<50%  

26.  district_active_cases Total active cases in Sabah by district  
27.  sabah_active_cases Total active cases in Sabah  
28.  total_covid_hosp Total bed count for covid-19 patient in hospital  
29.  total_pui_hosp Total bed count for covid-19 PUI in hospital  
30.  total_covid_pkrc Total bed count for covid-19 patient in PKRC  
31.  total_pui_pkrc Total bed count for covid-19 PUI in PKRC  

4. Covid19 in Sabah 

Name of google sheets: SabahCovidMasterTable 
Short Description: Information about the covid-19 in Sabah by district  
Location: Located in the server database and public access folder. 

Definition of each field:

No.  Column  Definition  
1.  sabah_id Case id/number in Sabah(Assumption)  
2.  nat_id Case id according to KKM  
3.  district_code District code in Sabah  
4.  district_name District name  
5.  district_abv Abbreviation of district  
6.  remark  Details of the case  
7.  x  X coordinate of the district  
8.  y  Y coordinate of the district  
9.  zone  Zone information of the district on the day   
10.  status  Latest status of the case patient  
11.  confirmed  Confirmed date of patient  
12.  recovered  Recovered date of patient  
13.  death  Death date of patient  
14.  gender  Gender of patient  
15.  age  Age of patient  
16.  nationality  Nationality of patient  
17.  screnning_type Screening type of patient  
18.  case_type Case type of patient  
19.  import_from Source of import if the patient is import case  
20.  cluster  Cluster in which the patient belongs to  
21.  cluster_generation Cluster generation of the patient  
22.  sabah_confirmed Accumulated confirmed cases in Sabah  
23.  sabah_confirmed_increased New confirmed cases in the day  
24.  sabah_recovered Accumulated recovered cases in Sabah  
25.  sabah_recovered_increased New recovered cases in the day  
26.  sabah_death Accumulated death cases in Sabah  
27.  sabah_death_increased New death cases in the day  
28.  msia_confirmed Accumulated confirmed cases in Malaysia  
29.  msia_confirmed_increased New confirmed cases in Malaysia   
30.  msia_recovered Accumulated recovered cases in Malaysia  
31.  msia_recovered_increased New recovered cases in Malaysia  
32.  msia_death Accumulated death cases in Malaysia  
33.  msia_death_increased New death cases in Malaysia  

5. Covid19 Zoning Data for Sabah 

Name of google sheets: Zoning_sbhcovid 
Short Description: Information about the covid-19 zones in Sabah by district  
Location: Located in the server database and public access folder. 

Definition of each field:

No.  Column  Definition  
1.  id Primary key 
2.  district District name  
3.  x  X coordinate of the district  
4. y  Y coordinate of the district  
5.  date Date of the record 
6.  zone  Zone information of the district on the day   
7. active Cumulative active case as of the day 
8. active 14 Cumulative active case in past 14 days 
9. confirmed Confirm case on the day 

6. PKRC in Sabah 

Name of google sheets: pkrc 
Short Description: Information about the PKRC location in Sabah. 
Location: Located in the server database. 

Definition of each field:

No.  Column  Definition  
1.  district_code District code  
2.  district_acronym District acronym  
3.  district_name District name  
4.  healthcare_id Healthcare unique id  
5.  name  Name of the PKRC facility  
6.  address  Address of the PKRC facility   
7.  contact  Telephone number of the PKRC facility   
8.  fax  Fax number of the PKRC facility   
9.  latitude  Latitude of the PKRC facility  
10.  longitude  Longitude of the PKRC facility  
11.  facility_type Facility type of the PKRC facility  
12.  facility_code Facility code of the PKRC facility  
13.  x  X coordinate of the PKRC facility  
14.  y  Y coordinate of the PKRC facility  

7. Hospital in Sabah 

Name of google sheets: hospital 
Short Description: Information about the hospital location in Sabah. 
Location: Located in the server database. 

Definition of each field:

No.  Column  Definition  
1.  district_code District code  
2.  district_acronym District acronym  
3.  district_name District name  
4.  healthcare_id Healthcare unique id  
5.  name  Name of the hospital facility  
6.  address  Address of the hospital facility   
7.  contact  Telephone number of the hospital facility   
8.  fax  Fax number of the hospital facility   
9.  latitude  Latitude of the hospital facility  
10.  longitude  Longitude of the hospital facility  
11.  facility_type Facility type of the hospital facility  
12.  facility_code Facility code of the hospital facility  
13.  x  X coordinate of the hospital facility  
14.  y  Y coordinate of the hospital facility  

DASHBOARD INFO

In order to provide an easy-to-understand visualization of the covid-19 trend in Malaysia and Sabah, two dashboards were produced using Hexagon M.app Enterprise and FME Desktop. The visualization was mainly created using Hexagon M.app Enterprise while the data used in it were backed and managed by FME Desktop. The dashboards provided geospatial information and several statistical charts according to their respective objective and theme.  

1. Hospital Beds Utilization

Figure 11
Figure 11
Name of dashboard: Hospital Beds Utilization 
Short description: This dashboard shows information about the PKRC and hospital bed utilization for covid-19 patients in Sabah. The source obtained from pkrc_hospital_rawatan_covid.csv, healthcare.csv, and Sabah district boundary to build this dashboard. The pkrc_hospital_rawatan_covid.csv data is updated daily in the public access folder so that the dashboard can display the latest information. This dashboard will also be updated from time to time.   
Updated info: Updated daily.  
Data source:  Sabah district boundary, healthcare.csv, and pkrc_hospital_rawatan_covid.csv  

a) LATEST BED OCCUPANCY
This graph shows the latest bed occupancy in hospital and PKRC based on the bed occupancy rate percentage. 

Figure 12

b) FACILITY
This graph shows the total facility for PKRC, Hospital (with ICU), and Hospital (without ICU). 

Figure 13
Figure 13

c) DAILY ICU BED OCCUPANCY RATE (%)
This graph shows the percentage of daily ICU bed occupancy rate in the hospital with ICU. 

Figure 14

d) NOTES

Figure 15
Figure 15

e) DAILY BED OCCUPANCY RATE (%)

Figure 16

f) TREND
This graph shows the trend of covid-19 patients in hospital and PKRC, and PUI in hospital and PKRC changed over time. 

Figure 17

g) ACTIVE CASES IN SABAH 
This graph shows the numbers of active cases in Sabah changed over time.   

Figure 18
h) REMAINING COVID-19 PATIENT

This graph shows the numbers of remaining covid-19 patient in the hospital and PKRC.

Figure 19

i) REMAINING PUI
This graph shows the numbers of remaining PUI in the hospital and PKRC. 

Figure 20

j) DAILY COUNT OF COVID-19 PATIENT 
This graph shows the daily count of covid-19 patient in the hospital and PKRC. 

Figure 21

k) DAILY COUNT OF PUI 
This graph shows the daily count of PUI in the hospital and PKRC. 

Figure 22

l) SABAH MAP 
This map shows the distribution of bed count records in Sabah.  

Figure 23

Click on the number to view more details.

Figure 24

 

2. Covid19 Sabah Infographic

Figure 25

Name of dashboard: 

Covid19 Sabah Infographic 

Short description: 

This dashboard shows detailed information about covid19 cases in Sabah. The data used in this dashboard were covidmastertable and zoning_sbhcovid. The former one holds the information of individual covid-19 cases while the latter provide the zoning information for each district on the map, such as zone color. The dashboard will be updated on daily basis after new data was published from official source such as KKM and PKN. 

Data source:  

Sabah district boundary, zoning_sbhcovid and covidmastertable.csv   

a. SITUATION IN SABAH
This pie chart shows the status of all confirmed cases.

Figure 26

b. COVID zone
This pie chart shows the zone classification based on covid19 cases in each district. 

Figure 27

c. CONFIRMED, RECOVERED, DEATH AND ACTIVE CASE
The 4 panels show the total number of confirmed, recovered, death and active cases to date, the small number next to them indicates the number of new cases on the day. 

Figure 28

When expanded, a table with district-level information will be shown below 

Figure 29
Figure 30a
Figure 30b
Figure 31

d. COVID19 TREND
The line graph shows the trend of confirmed case in chronological order. 

Figure 32

e. SABAH MAP
Click on the donuts to show detailed information of covid19 case on the district. 

Figure 33
Figure 34

Click on the dots to show hospital facility related information. 

Figure 35

Click on “C” on the right panel to access heatmaps for active cases and active cases on past 14 days. 

Figure 36
Figure 37

COVID19 PUBLIC PORTAL

Brief of portal of COVID-19 in Sabah

This portal is created under the server and subdomain of sabahtrace.my. This portal is a platform mainly to show to the citizen of Sabah regarding the COVID-19 cases in Sabah such as confirmed, discharged, death, active and cumulative of each case. The portal is update daily with latest of COVID-19 cases in Sabah where the resources get from official government PKN Facebook or Jabatan Kesihatan Negeri Sabah (JKNS) website. 

               The portal is displayed with the trends of cases in Sabah in a view of data table, charts and graphs visualization. This enables the citizen to know what is happening daily about COVID-19 in Sabah with the number cases shown so that they would be aware from their nearby area. The citizen cautious to their current stay as the zone in each district represent the active cases at their area.

               The dashboard in the portal is represent the latest cases for whole district in Sabah in a single view. The map of Sabah is interactive by easily pointed on certain districts to view the number cases and data table in details such as status of confirmed, discharged, death and active.

               The citizen could also download the PDF of the latest update of in force SOP announcement so that they would know the do’s and don’ts.

               Finally, this portal focus for displaying the daily update of COVID-19 cases mainly in Sabah. With this portal helps to raise awareness to all the citizen in Sabah at their surrounding time to time regarding the COVID-19 situation happens daily.

Figure 38
  1. Confirmed, Discharged, Death and Active are the figures for cumulative and +/- cases for on that day.
  2. Quarantined and Home Quarantined are based on infographic from PKN FB.
  3. Tweets embed – Datuk Noor Hisham.
  4. Facebook embed – Jawatankuasa Pengurusan Bencana Covid-19 Negeri Sabah.
  5. Dashboard (big image) – showing latest date cases.
  6. Button “Click here to launch map” – jump to Dashboard.
  7. Dashboard Image gallery – showing last 4 dates before the latest date.
  8. Table – data showing the latest data cases.
  9. Button “Click here to view daily cases in whole Malaysia” – jump to new page (showing table daily cases in whole Malaysia).
  10. Button “Click here to view record in Sabah” – showing table of record in Sabah.
  11. Pie chart – Situation in Sabah, Top 5 District with Confirmed Cases/Discharged Cases/Death Cases (showing the percentage of cases on that day based on latest cases by figures on that day).
  12. Mix Chart – showing the number cases for Confirmed, Discharged, Deaths on that day.
  13. Button “Click here to view Cumulative Cases in Sabah” – jump to new page (showing graph)
  14. PDF – On click PDF and direct user to download PDF (showing the latest announcement of still in force)
  15. Button “Click here to view more past SOP in Sabah” – showing the past SOP in Sabah in pdf format.
Refer to Number1 (Confirmed, Discharged, Deaths, Active)
Description                                    The number cases of confirmed, discharged, deaths and active are taken from the dashboard which has already finalized according to the latest date. The ‘+’ and ‘-’ is identified as the new cases on that day. Example format as below:
(Cumulative Confirmed)23882+499(new Confirmed case today)
Cumulative Confirmed = Yesterday’s Cumulative Confirmed + Today’s new Confirmed
Sources Locationhttps://dashboard.geosabah.my/PublicAccess/Covid19_Sabah_Infographic.html?tenant=me_dgd

 

Refer to Number2 (Quarantined and Home Quarantined)
Description                                   

Quarantined and home quarantined cases number are taken from PKN FB. The number is referring to the active cases of quarantines. The ‘+’ and ‘-’ is identified as difference between today and yesterday active cases of quarantines. The calculation as below on how to get the difference active quarantines:

+/- quarantines = Today’s active quarantines –  Yesterday’s active quarantines

Sources Locationhttps://www.facebook.com/PKN-SABAH-730632716950035

 

Refer to Number3 (Twitter embed)
Description                                    The twitter embed from – Datuk Noor Hisham Abdullah’s twitter. It is scorable to show the update from Datuk’s tweets.
Sources Locationhttps://twitter.com/DGHisham?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor

 

Refer to Number4 (Facebook embed)
Description                                    The Facebook embed from – Jawatankuasa Pengurusan Bencana Covid-19 Negeri Sabah’s Facebook. It is scorable to show the update post from the Facebook.
Sources Locationhttps://www.facebook.com/sabahcovid/

 

Refer to Number5 , 6 , 7 (launch to dashboard)
Description                                   

The dashboard shows the latest COVID-19 cases in Sabah. The Sabah’s map is pointed the number cases for each district. For each pointed case district, user can click on it to see the details information of person of discharged/confirmed or death.

·        The dashboard (image) showing the updated cases on that day. The link shown below is to launch to dashboard for more details.

·        Button click to launch to dashboard

·        The four images showing the past 4 days of dashboard (click that image to see the whole image)

Sources Locationhttps://dashboard.geosabah.my/PublicAccess/Covid19_Sabah_Infographic.html?tenant=me_dgd (dashboard)

Refer to Number

8 (Table)
Description                                    

This is the table with cases of cumulative confirmed, + new confirmed, cumulative, cumulative death, + new death, cumulative discharged, + new discharged, active and increase/decrease active on that day. The number cases are displayed according by each district in Sabah. Below is how the data is stored and extracted.

1.      Data is extracted from google sheet (heatmap)

2.      Data is record in google sheet in order to calculate the cumulative cases (CumulativeCasesSabah)

3.      Data is then paste to table sheet(sabah_daily_cases) with table structure format, in order to record the data table published to portal

4.      The current sheet is published to web(url) as .csv format

5.      The csv file is imported to the portal.

Sources Location

https://drive.google.com/file/d/1KhQ0yXCRkeBSfGYn10NIY-H5rHE6piD-/view?usp=sharing (heatmap)

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (CumulativeCasesSabah)

https://drive.google.com/file/d/1QZAaA33GAgmbJm98El6tf0yjFj7bHEcG/view?usp=sharing (sabah_daily_cases)

Refer to Number9 , 10 (Button for table whole Malaysia and Sabah daily records)
Description                                   

·        The table data is finalized in google sheet and are imported to the portal by published to web(url) as .csv format.

·        It will jump to new link to show the data table record after click on that button.

·        The data is updated daily and finalized from the google sheet.

Sources Location

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (covid19_my)

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (heatmap)

Refer to Number

11 (Pie Chart)

Description                                   

The pie chart is showing the percentages as the whole number is equal to the cumulative confirmed cases on that day.

1.      Situation in Sabah – the output is identified with formula: Cumulative confirmed = Cumulative of (discharged-death-active)

2.      Top 5 District with Confirmed Cases – number cases are identified the cumulative confirmed cases

3.      Top 5 District with Discharged Cases – number cases are identified the cumulative discharged cases

4.      Top 5 District with Death Cases – number cases are identified the cumulative death cases

Sources Location

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (CumulativeCasesSabah)

Refer to Number

12 (Mix Chart)

Description                                   

The mix chart is showing the new confirmed, discharged and death on that day.

Sources Location

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (Daily_cases)

 

Refer to Number

13 (Button Cumulative Cases in Sabah)

Description                                   

The user will jump to a new link after click on the button, showing the cumulative cases in Sabah with graph and charts.

Sources Location

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (CumulativeCasesSabah)

 

Refer to Number

13 (Pdf force download)

Description                                   

The PDF showing in the main page are the latest SOP announcement and are still in force. The PDF are original sources from KKM website.

Sources Location

http://covid-19.moh.gov.my/faqsop/sop-perintah-kawalan-pergerakan-pkp

 

Refer to Number

15 (Button past SOP)

Description                                   

The user will jump to a new link after click on the button, showing the past SOP announcement and are not in force.

Sources Location

http://covid-19.moh.gov.my/faqsop/sop-perintah-kawalan-pergerakan-pkp

COVID-19 MALAYSIA https://covid19.sabahtrace.my/covid-19-malaysia/
Table of Covid-19 Malaysia (showing the whole Malaysia COVID-19 cases such as state, new cases, total cases, new deaths, total deaths, new recovered, total recovered, active case and zone). Refer to 9. It can be sorted according to order of ascending and descending as well as search on the input whatever that has in the table content.

Figure 39

COVID-19 SABAH SUMMARY https://covid19.sabahtrace.my/covid-19-sabah-summary/
Table of Covid-19 Sabah Summary (showing the Sabah whole Sabah COVID-19 cases such as confirmed, recovered, death, and active). Refer to 10. It can be sorted according to order of ascending and descending as well as search on the input whatever that has in the table content.

Figure 40

CUMULATIVE CASES IN SABAH https://covid19.sabahtrace.my/cumulative-cases-in-sabah/
Graph for Cumulative Cases in Sabah. Refer to 13.

Figure 41
  1. Cumulative Cases in Sabah – showing line graph of latest cumulative cases on that day.
  2. Cumulative Cases in Sabah for November 2020 – showing bar graph of latest cumulative cases on that day for November.
  3. Cumulative Confirmed Cases by Districts – showing bar graph of cumulative confirmed cases for each district.
  4. Confirmed Cases by Districts (Last 14 Days) – showing horizontal bar graph of confirmed cases by districts for last 14 days.
Refer to Number 16 (Line graph Cumulative Cases by monthly in Sabah) 
Description                                     

The line graph showing the cumulative Confirmed, Discharged and Deaths cases in Sabah. It is finalized from google sheet. It is update based from the beginning of COVID-19 happened in Sabah till to the latest month. The formula as below how to get the current monthly cumulative: 

Month Cumulative confirmed = total of cumulative of that month 

Sources Location 

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (CumulativeCasesSabah) 

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (Cumulative_insabah) 

 

Refer to Number 17 (Bar graph Cumulative Cases for November in Sabah) 
Description                                     

The bar graph showing the cumulative Confirmed, Active and Discharged cases in Sabah. It is finalized from google sheet. It is based on update of current month. The formula as below how to get the today’s cumulative:  

Cumulative confirmed = today new total confirmed + yesterday cumulative confirmed. 

Sources Location https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (Cumulative_Nov) 

 

Refer to Number 18 (Bar graph Cumulative Confirmed Cases by Districts) 
Description                                     

The line graph showing the cumulative Confirmed cases in Sabah. The formula as below how to get the today’s cumulative confirmed by district: 

Cumulative Confirmed District = today new confirmed district + yesterday cumulative confirmed district 

Sources Location https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (Cumulative_districts) 

 

Refer to Number 19 (Bar graph Confirmed Cases by district (Last 14 Days)) 
Description                                     

The bar graph showing the cumulative Confirmed, Discharged and Deaths cases in Sabah. It is finalized from google sheet. It is firstly extracted the data from heatmap google sheet. The formula as below how to get the Confirmed District (last 14 days):  

Confirmed District (last 14 days) = today confirmed district + last 13 days new confirmed district 

Sources Location 

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (heatmap) 

https://drive.google.com/file/d/18MsSSdWB4ZKdoKzI8VyYfJXDRb7RiMmw/view?usp=sharing (Cumulative_insabah) 

SOP COVID-19 SABAH https://covid19.sabahtrace.my/sop-covid-19-in-sabah/
Past SOP Covid-19 in Sabah showing the past announcement of SOP with on click downloadable PDF. Refer to 15.

Figure 42
Refer to Number20 (November Announcement (not in force))
Description                                    The each of pdf file is forced to download for user to see the content/information in detail in pdf format. The announcements are past SOP which is not in force.
Sources Locationhttp://covid-19.moh.gov.my/faqsop/sop-perintah-kawalan-pergerakan-pkp

 

Refer to Number21 (October Announcement (not in force))
Description                                    The each of pdf file is forced to download for user to see the content/information in detail in pdf format. The announcements are past SOP which is not in force.
Sources Locationhttp://covid-19.moh.gov.my/faqsop/sop-perintah-kawalan-pergerakan-pkp