Design and Implementation of a Multi-Disaster Risk Assessment Database System in South Korea
<p>Flowchart of earthquake analysis of HAZUS-MH.</p> "> Figure 2
<p>Building damage analysis in ERGO.</p> "> Figure 3
<p>Process of building damage analysis in ERGO.</p> "> Figure 4
<p>(<b>a</b>) Public data provision statistics; (<b>b</b>) Public data utilization statistics [<a href="#B16-information-11-00008" class="html-bibr">16</a>].</p> "> Figure 5
<p>Dataflow of the scalable disaster risk analysis platform [<a href="#B21-information-11-00008" class="html-bibr">21</a>].</p> "> Figure 6
<p>Database system workflow.</p> "> Figure 7
<p>ERD of the loss estimation database system.</p> "> Figure 8
<p>Building inventory mapping process.</p> "> Figure 9
<p>User interface of the proposed database system.</p> "> Figure 10
<p>Compatibility test of the proposed system: Performance analysis by the distributed and parallel framework [<a href="#B21-information-11-00008" class="html-bibr">21</a>].</p> "> Figure 11
<p>Compatibility test of the proposed system: Risk analysis of Goyang city, Korea.</p> ">
Abstract
:1. Introduction
2. Related Works
2.1. Disaster Risk Assessment System
2.1.1. HAZUS-MH
2.1.2. ERGO
2.2. Public Data
3. Scalable Disaster Risk Analysis Platform
4. Multi-Disaster Loss Assessment Analysis Database System for South Korea
4.1. Buidling-Related Table
4.2. Population-Related Table
4.3. Basic-Attribute-Related Table
4.4. Weight-Related Table
4.5. Formulas and Other Data
4.6. System User Interface
4.7. Compatibility Test
5. Discussion
6. Conclusions
Author Contributions
Funding
Conflicts of Interest
References
- Chai, S.; Suh, D.; Shin, S. Study on the development of Korean inventory for the multi-hazard risk assessment. J. Digit. Contents Soc. 2017, 18, 1127–1134. [Google Scholar]
- Chai, S.; Suh, D. A Review and Analysis of Earthquake Disaster Risk Assessment Tools and Applications. J. Digit. Contents Soc. 2018, 19, 899–906. [Google Scholar] [CrossRef]
- HAZUS-MH 2.1 Technical Manual; Department of Homeland Security Federal Emergency Management Agency: Washington, DC, USA, 2013.
- ERGO. Available online: http://ergo.ncsa.illinois.edu (accessed on 19 December 2019).
- Kang, S.; Kim, K.; Kim, D. A Preliminary Study of the Global Application of HAZUS and ShakeMap for Loss Estimation from a Scenario Earthquake in the Korean Peninsula. J. Korean Assoc. Geogr. Inf. Stud. 2017, 10, 47–59. [Google Scholar]
- Yu, S.; An, H. Study of Flood Loss Estimation using Hazus-MH 2.1. J. Risk Manag. 2013, 24, 29–58. [Google Scholar]
- Jo, Y.; Choi, H.; Choi, S. Conceptual Design of Damage Assessment Inventory in Response to Disaster Risk for Infrastructures Close to River. J. Korean Assoc. Geogr. Inf. Stud. 2014, 17, 144–158. [Google Scholar] [CrossRef] [Green Version]
- Scawthron, C.; Flores, P.; Blais, N. HAZUS-MH flood loss estimation methodology. II. Damage and loss assessment. Nat. Hazards Rev. 2006, 7, 72–81. [Google Scholar] [CrossRef]
- Hancilar, U.; El-Hussain, I.; Sesetyan, K. Earthquake risk assessment for the building inventory of Muscat, Sultanate of Oman. Nat. Hazards 2018, 93, 1419–1434. [Google Scholar] [CrossRef]
- Jeong, G.; Lee, H.; Kwon, O. Earthquake Direct Economic Loss Estimation of Building Structures in Gangnam-Gu District in Seoul Using HAZUS Framework. J. Earthq. Eng. Soc. Korea 2016, 20, 391–400. [Google Scholar] [CrossRef]
- Park, M.; Yang, S.; Koo, B. A Study on Development of Village Wetlands Inventory Using GIS and Establishment of Management Methods in Asan City, Korea. J. Korea Soc. Environ. Restor. Technol. 2015, 18, 167–177. [Google Scholar] [CrossRef] [Green Version]
- Kang, I.; Park, J. The Seismic Hazard Study on Chung-Nam Province using HAZUS. J. Korean Soc. Hazard Mitig. 2002, 2, 73–83. [Google Scholar]
- Lee, C.; Kim, S.; Park, I. An Inventory Analysis for Disaster Loss Estimation Specialized in Korean Environment - Focusing on HAZUS-MH Flood Model. J. Korean Soc. Hazard Mitig. 2015, 15, 79–87. [Google Scholar] [CrossRef]
- SYNER-G. Available online: http://www.vce.at/SYNER-G (accessed on 23 September 2019).
- Steelman, J.; Song, J.; Hajjar, J.F. Integrated Data Flow and Risk Aggregation for Consequence-Based Risk Management of Seismic Regional Loss; University of Illinois: Urbana, IL, USA, 2007. [Google Scholar]
- Open Data Portal. Available online: https://www.data.go.kr (accessed on 23 September 2019).
- USGS. Available online: https://www.usgs.gov/media/images/2017-usgs-juneau-topographic-map-without-image-backdrop (accessed on 17 December 2019).
- Korea Earthquake Research Center. Available online: http://quake.kigam.re.kr/html/korean/main.jsp (accessed on 23 September 2019).
- JSON. Available online: https://www.json.org/ (accessed on 23 September 2019).
- Moniruzzaman, A.B.M.; Hossain, S.A. NoSQL Database: New Era of Databases for Big data Analytics-Classification, Characteristics and Comparison. Int. J. Database Theory Appl. 2013, 6, 1–4. [Google Scholar]
- Chai, S.; Jang, S.; Suh, D. Design and Implementation of Big Data Analytics Framework for Disaster Risk Assessment. J. Digit. Contents Soc. 2018, 19, 771–777. [Google Scholar]
- National Special Data Infrastructure Portal. Available online: http://www.nsdi.go.kr/ (accessed on 23 September 2019).
- Korean Statistical Information Service. Available online: http://kosis.kr (accessed on 23 September 2019).
- Ministry of the Interior and Safety (Korea). Available online: http://www.mois.go.kr/frt/a01/frtMain.do (accessed on 23 September 2019).
- Toro, G. Modification of the Toro et al. (1997) attenuation equations for large magnitudes and short distances. Available online: https://s3.amazonaws.com/academia.edu.documents/39538064/MODIFICATION_OF_THE_TORO_ET_AL._1997_A20151029-26206-13cndhr.pdf?response-content-disposition=inline%3B%20filename%3DMODIFICATION_OF_THE_TORO_ET_AL._1997_ATT.pdf&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWOWYYGZ2Y53UL3A%2F20191223%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20191223T084647Z&X-Amz-Expires=3600&X-Amz-SignedHeaders=host&X-Amz-Signature=2bf9626810491069566452743094d506f69b7a655ec3c78697b493de421c1dd9 (accessed on 23 September 2019).
- Jo, N.; Baag, C. Estimation of Spectrum Decay Parameter χ and Stochastic Prediction of Strong Ground Motions in Southeastern Korea. J. Earthq. Eng. Soc. Korea 2003, 7, 59–70. [Google Scholar]
- Noh, M.; Lee, K. Estimation of Peak Ground Motions in the Southeastern Part of the Korean peninsula (II): Development of Predictive Equations. J. Geol. Soc. Korea 1995, 31, 175–187. [Google Scholar]
- Nam, Y.; Kim, J. A Study on the policy of disaster prevention using integrated database - Focused on The Policy for Housing welfare. J. Korea Inst. Electron. Commun. Sci. 2014, 9, 105–110. [Google Scholar] [CrossRef]
- Park, J.; Jung, W.; Choi, H. Prevention Meteorological Database Information for the Assessment of Natural Disaster. J. Korean Soc. Hazard Mitig. 2017, 7, 41–49. [Google Scholar]
- Lee, S.; Kim, G.; Yune, C. Development of Landslide-Risk Prediction Model thorough Database Construction. J. Korean Geotech. Soc. 2012, 28, 23–33. [Google Scholar] [CrossRef] [Green Version]
- Zêzere, J.; Pereira, S.; Tavares, A.O.; Bateira, C.; Trigo, R.M.; Quaresma, I.; Santos, P.P.; Santos, M.; Verde, J. DISASTER: A GIS database on hydro-geomorphologic disasters in Portugal. Nat. Hazards 2014, 72, 503–532. [Google Scholar] [CrossRef]
ERGO Damage State | Range of Beta Distribution (%) | Mean of Damage Factor, (%) | Standard Deviation of Damage Factor, (%) |
---|---|---|---|
Insignificant | [0, 1] | 0.5 | 0.333 |
Moderate | [1, 30] | 15.5 | 9.67 |
Heavy | [30, 80] | 55 | 16.7 |
Complete | [80, 100] | 90 | 6.67 |
District | Dataset | Date | File Size | Download |
---|---|---|---|---|
Seoul | GIS complex space information of building | 2017-10-20 | 15,792 KB | |
Seoul | GIS complex space information of building | 2017-10-19 | 44,076 KB | |
Seoul | GIS complex space information of building | 2017-03-06 | 23,820 KB | |
Seoul | GIS complex space information of building | 2016-11-25 | 66,375 KB | |
Seoul | GIS complex space information of building | 2016-11-25 | 21,481 KB |
Table | Column | Type | Column | Type |
---|---|---|---|---|
Bldg_list | bldgID (P.K) | VARCHAR (30) | nstraCst | INT |
struct_1_ID (F.K) | VARCHAR (3) | nstrdCst | INT | |
strProb | FLOAT | dgnLvl | VARCHAR(20) | |
yearBuilt | SMALLINT | contVal | INT | |
noStories | SMALLINT | efacilityID | VARCHAR(10) | |
aStories | SMALLINT | dwellUnit | INT | |
bStories | SMALLINT | struct_2_ID | VARCHAR(5) | |
bsmtType | SMALLINT | occType_2_ID(F.K) | VARCHAR(10) | |
sqFoot | FLOAT | bjdID | VARCHAR(10) | |
gsqFoot | FLOAT | bjdName | VARCHAR(60) | |
occType_1_ID(F.K) | VARCHAR(10) | Jibun | VARCHAR(10) | |
occDetail | VARCHAR(30) | bldgName | VARCHAR(40) | |
majorOcc | VARCHAR(20) | roadID | VARCHAR(15) | |
broadOcc | VARCHAR(30) | bldgDongName | VARCHAR(40) | |
apprBldg | INT | longitude | FLOAT | |
replCst | INT | latitude | FLOAT | |
strCst | INT |
Table | Column | Type | Column | Type |
---|---|---|---|---|
Census_Tract | censusID (P.K) | VARCHAR (20) | avgHousehold | INT |
population | INT | totalHouse | INT | |
totalHousehold | INT |
Table | Column | Type | Column | Type |
---|---|---|---|---|
Occ_type_1_mapping | rawOccTypeID (P.K) | VARCHAR (10) | occType_1_ID (F.K) | VARCHAR (10) |
rawOccTypeName | VARCHAR (20) | |||
struct_mapping | rawStructID | VARCHAR (10) | structID (P.K) | VARCHAR (3) |
rawStructName | VARCHAR (26) | |||
dong_mapping | sido | VARCHAR (24) | bjdongName | VARCHAR (24) |
sigungu | VARCHAR (24) | bjdID | VARCHAR (11) | |
adminDistrictName | VARCHAR (24) | bjdID (P.K) | VARCHAR (11) | |
hjdongName | VARCHAR (24) |
Table | Column | Type | Column | Type |
---|---|---|---|---|
contents_damage_ratio | contentsDamageID | VARCHAR (3) | damage_ID | VARCHAR (2) |
occType_1_ID | VARCHAR (10) | contents_damage | FLOAT | |
business_inventory_losses | inventoryLossID | VARCHAR (3) | annual_gross_sales | FLOAT |
occType_1_ID | VARCHAR (10) | business_inventory | FLOAT | |
damageID | VARCHAR (2) | inventory_damage | FLOAT | |
relocation_expenses | relocationExpenseID | VARCHAR (3) | disruption_cost | FLOAT |
occType_2_ID | VARCHAR (10) | percent_owner_occupied | FLOAT | |
rental_cost | FLOAT | |||
repair_cost_ratio | repairCostRatioID | VARCHAR (3) | st_repair_cost_ratio | FLOAT |
occType_2_ID | VARCHAR (10) | as_repair_cost_ratio | FLOAT | |
damageID | VARCHAR (2) | ds_repair_cost_ratio | FLOAT | |
bldg_repair_time_loss_func | repairTimeLossID | VARCHAR (3) | cleanup_repair_time | INT |
occType_2_ID | VARCHAR (10) | recovery_time | INT | |
damageID | VARCHAR (2) | service_interruption_time_multipliers | FLOAT |
Table | Column | Type | Column | Type |
---|---|---|---|---|
Fragility_curve | id | VARCHAR (6) | demandUnits | VARCHAR (3) |
fragilityIDCode | VARCHAR (10) | limitState | VARCHAR (100) | |
struct_1_ID | VARCHAR (3) | Parameters | FLOAT | |
author | VARCHAR (20) | median0 | FLOAT | |
stories | INT | beta0 | FLOAT | |
description | VARCHAR (60) | median1 | FLOAT | |
groundMotion | VARCHAR (60) | beta1 | FLOAT | |
code | VARCHAR (10) | median2 | FLOAT | |
damageType | VARCHAR (15) | beta2 | FLOAT | |
demandType | VARCHAR (10) |
© 2019 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (http://creativecommons.org/licenses/by/4.0/).
Share and Cite
Chai, S.-S.; Suh, D. Design and Implementation of a Multi-Disaster Risk Assessment Database System in South Korea. Information 2020, 11, 8. https://doi.org/10.3390/info11010008
Chai S-S, Suh D. Design and Implementation of a Multi-Disaster Risk Assessment Database System in South Korea. Information. 2020; 11(1):8. https://doi.org/10.3390/info11010008
Chicago/Turabian StyleChai, Su-Seong, and Dongjun Suh. 2020. "Design and Implementation of a Multi-Disaster Risk Assessment Database System in South Korea" Information 11, no. 1: 8. https://doi.org/10.3390/info11010008