Timeline

Uploading Data (Sabah Covid19) to Google Sheet and Database 

Sabah
  • Sources: Kementerian Kesihatan Malaysia(KKM) and Perbadanan Kesihatan Negeri Sabah(PKN).
  • Reader: cases (excel).
  • Writer: sabahcovid_ mastertable (GoogleSheet) and sabahcovid_mastertable  (database).

covid19_my

Sabah
  • Sources: data world and Kementerian Kesihatan Malaysia. 
  • Reader: covid-19_my_state (excel) and Malaysia_Polygon  (shapefile). 
  • NullAttributeMapper: To set the value to 0 if the attribute value is empty, missing, null, or NA. 
  • DateTimeConverter: To convert the date from “yyyymmdd” to “yyyy-mm-dd”. 
  • Counter: Create an attribute called _count that count the rows start from 1. 
  • StringCaseChanger: To convert the string in the state attribute from uppercase to full title case. 
  • AttributeCreator: Create a new attribute called zone to classify the state in red(active_cases≥41), yellow(1≤active_cases≤40), or green(active_cases=0). 
  • AttributeManager: To organize the table. Change _count attribute name to id. 
  • FeatureMerger: To merge the covid-19_my_state and Malaysia_Polygon  table by state. 
  • AttributeManager_2: To organize the table. 
  • Writer: covid_19_my_ state (database) and covid_19_my_ state (google sheets). 

quarantine_centre_Sabah 

Sabah

a) FME workflow to save quarantine_centre_sabah table into database

  • Sources: Kementerian Kesihatan Malaysia.
  • Reader: Sheet1 (excel) and districts_wgs (shapefile).
  • Tester: To remove the rows if the attribute value is missing.
  • StringCaseChanger: To convert the string in the Districts attribute from full title case to uppercase.
  • AttributeManager: To organize the table.
  • FeatureMerger: To merge Sheet1 and districts_wgs by districts.
  • AttributeManager_2: To organize the table.
  • Writer: quarantine_centre_sabah (database).

 

b) FME workflow to update quarantine_centre_sabah table in google sheets .

  • Reader: quarantine_centre_sabah (database).
  •  Writer: quarantine_centre_sabah (google sheets).

covid19_kpm 

Sabah
(a) FME workflow to save KPM_langgar_pkp table into database 
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Langgar PKP (excel) and Malaysia_Boundary (shapefile).
  • Tester: To remove the rows if the attribute value is missing.
  • DateTimeConverter: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • AttributeCreator_4: Create an attribute called negara and set the value to Malaysia.
  • Counter: Create an attribute called _count that count the rows start from 1.
  • AttributeManager: To organize the table. Change _count attribute name to id.
  • FeatureMerger: To merge the Langgar PKP and Malaysia_Boundary table.
  • AttributeManager_2: To organize the table.
  • Writer: KPM_langgar_pkp (database).
(b) FME workflow to save KPM_jenis_kesalahan table into database. 
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Jenis Kesalahan (excel) and Malaysia_Boundary (shapefile).
  • DateTimeConverter_2: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_2: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator: Create an attribute called negara and set the value to Malaysia.
  • AttributeManager_14: To organize the table. Change _count attribute name to id.
  • FeatureMerger_2: To merge the Jenis Kesalahan and Malaysia_Boundary table.
  • AttributeManager_3: To organize the table.
  • Writer: KPM_jenis_kesalahan (database).
(c) FME workflow to save KPM_jenis_pemantauan table into database 
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Jenis Pemantauan (excel) and Malaysia_Boundary (shapefile).
  • DateTimeConverter_3: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_3: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_2: Create an attribute called negara and set the value to Malaysia.
  • AttributeManager_13: To organize the table. Change _count attribute name to id.
  • FeatureMerger_3: To merge the Jenis Pemantauan and Malaysia_Boundary table.
  • AttributeManager_4: To organize the table.
  • Writer: KPM_jenis_pemantauan (database)
(d) FME workflow to save KPM_kesalahan_sempadan_negara table into database.
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Kesalahan Sempadan Negara (excel) and Malaysia_Boundary (shapefile).
  • DateTimeConverter_4: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_4: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_3: Create an attribute called negara and set the value to Malaysia.
  • AttributeManager_15: To organize the table. Change _count attribute name to id.
  • FeatureMerge_4:To Merge the Kesalahan Sempadan Negara and Malaysia Boundary State table.
  • AttributeManager_5: To organize the table.
  • Writer: KPM_ kesalahan_sempadan_negara (database).
(e) FME workflow to save KPM_sekatan_jln_raya table into database 
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Sekatan Jln Raya (excel) and Malaysia_Boundary (shapefile).
  • DateTimeConverter_6: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_6: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_5: Create an attribute called negara and set the value to Malaysia.
  • AttributeManager_16: To organize the table. Change _count attribute name to id.
  • FeatureMerger_6: To merge the Sekatan Jln Raya and Malaysia_Boundary table.
  • AttributeManager_6: To organize the table.
  • Writer: KPM_sekatan_jln_raya (database).
(f) FME workflow to save KPM_kuarantin_wajib table into database.
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Kuarantin Wajib (excel) and Malaysia_Boundary (shapefile).
  • Tester_5: To remove the rows if the attribute value is missing.
  • DateTimeConverter_7: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_7: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_6: Create an attribute called negara and set the value to Malaysia.
  • AttributeManager_17: To organize the table. Change _count attribute name to id.
  • FeatureMerger_7: To merge the Kuarantin Wajib and Malaysia_Boundary table.
  • AttributeManager_7: To organize the table.
  • Writer: KPM_kuarantin_wajib (database).
(g) FME workflow to save KPM_operasi_sanitasi_awam table into database.
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Operasi Sanitasi Awam (excel) and Malaysia_Boundary (shapefile).
  • Tester_4: To remove the rows if the attribute value is missing.
  • DateTimeConverter_8: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_8: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_7: Create an attribute called negara and set the value to Malaysia.
  • NullAttributeMapper_2: To set the value to 0 if the attribute value is empty, missing, or null.
  • AttributeManager_18: To organize the table. Change _count attribute name to id.
  • FeatureMerger_8: To merge the Operasi Sanitasi Awam and Malaysia Boundary Table.
  • AttributeManager_8: To organize the table.
  • Writer: KPM_operasi_sanitasi_awam (database).
(h) FME workflow to save KPM_total_premis_disanitasi table into database
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Total Premis disanitasi (excel) and Malaysia_Boundary (shapefile).
  • DateTimeConverter_9: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_9: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_8: Create an attribute called negara and set the value to Malaysia.
  • AttributeManager_19: To organize the table. Change _count attribute name to id.
  • FeatureMerge_9: To Merge the Total Premis Disanitasi and Malaysia Boundary Table.
  • AttributeManager_9: To organize the table.
  • Writer: KPM_total_premis_disanitasi (database).
(i) FME workflow to save KPM_zon_sanitasi table into database 
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Zon Sanitasi (excel) and Malaysia_Boundary (shapefile).
  • Tester_3: To remove the rows if the attribute value is missing.
  • DateTimeConverter_10: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_10: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_9: Create an attribute called negara and set the value to Malaysia.
  • AttributeManager_20: To organize the table. Change _count attribute name to id.
  • FeatureMerger_10: To merge the Zon Sanitasi and Malaysia_Boundary table.
  • AttributeManager_10: To organize the table.
  • Writer: KPM_zon_sanitasi (database).
(j) FME workflow to save KPM_negeri_sanitasi table into database
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Negeri Sanitasi (excel) and Malaysia_Boundary (shapefile).
  • Tester_2: To remove the rows if the attribute value is missing.
  • DateTimeConverter_11: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_11: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_10: Create an attribute called negara and set the value to Malaysia.
  • NullAttributeMapper: To set the value to 0 if the attribute value is empty, missing, or null.
  • AttributeManager_21: To organize the table. Change _count attribute name to id.
  • FeatureMerger_11: To merge the Negeri Sanitasi and Malaysia_Boundary table.
  • AttributeManager_11: To organize the table.
  • Writer: KPM_negeri_sanitasi (database).
(k) FME workflow to save KPM_anggota_sanitasi table into database 
  • Sources: Kementerian Pertahanan Malaysia.
  • Reader: Anggota Sanitasi (excel) and Malaysia_Boundary (shapefile).
  • DateTimeConverter_12: To convert the date from “yyyymmdd” to “yyyy-mm-dd”.
  • Counter_12: Create an attribute called _count that count the rows start from 1.
  • AttributeCreator_11: Create an attribute called negara and set the value to Malaysia.
  • AttributeManager_22: To organize the table. Change _count attribute name to id.
  • FeatureMerger_12: To merge the Anggota Sanitasi and Malaysia_Boundary table.
  • AttributeManager_12: To organize the table.
  • Writer: KPM_ kesalahan_sempadan_negara (database).
(l) FME workflow to update all the table in google sheets 
  • Reader: KPM_anggota_sanitasi (database), KPM _jenis_kesalahan (database), KPM_jenis_pemantauan  (database), KPM_kesalahan_sempadan_negara  (database), KPM_kuarantin_wajib (database),  KPM_langgar_pkp (database), KPM_negeri_sanitasi  (database), KPM_operasi_sanitasi_Awam (database),   KPM_sekatan_jalan_raya (database),  KPM_total_premis_disanitasi (database), and KPM_zon_sanitasi (database).
  • Writer: KPM_anggota_sanitasi (google sheets), KPM_jenis_kesalahan (google sheets), KPM_jenis_pemantauan (google sheets), KPM_kesalahan_sempadan_negara (google sheets), KPM_kuarantin_wajib (google sheets), KPM_langgar_pkp (google sheets), KPM_negeri_sanitasi (google sheets), KPM_operasi_sanitasi_Awam (google sheets), KPM_sekatan_jalan_raya (google sheets), KPM_total_premis_disanitasi (google sheets), and KPM_zon_sanitasi (google sheets).

healthcare

Sabah

a) FME workflow to updatepkrc_hospital_rawatan_covidand healthcare table in CSV

  • Sources: Maklumat pkrc dan hospital rawatan covid in excel file.   
  • Reader: pkrc_hospital_rawatan_covid (CSV) and healthcare (excel).
  • StringCaseChanger and StringCaseChanger_2:  To convert the string in the name attribute from full title case to uppercase.
  • AttributeManager: To organize the table. Also, add conditional value for bor_alert and icu_bor_alert to classify the attribute value in red(bor/icu_bor≥75), yellow(75≥bor/icu_bor≥50), or white(50>bor/icu_bor≥0).
  • AttributeManager_4: To organize the table.
  • FeatureMerger: To merge the pkrc_hospital_rawatan_covid and healthcare table.
  • AttributeManager_2: To organize the table.
  • Writer: pkrc_hospital_rawatan_covid (CSV) and healthcare (CSV).

 

(b) FME workflow to save healthcare table into database 

  • Reader: healthcare (CSV).  
  • Writer: healthcare (database).

zoning_sbhcovid

Sabah

  • Reader: zoning_sabah (CSV).  
  • Writer: zoning_sabah (database), zoning_sabah (google sheets).
Total Page Visits: 19 - Today Page Visits: 1