Design and Implementation of Query and Analysis System for Rainstorm and Flood Disaster Process Impact in Nanning City
(1.Nanning Normal University, Nanning 530001, China; 2.Guangdong Detachment of the Armed Marine Police, Guangzhou 510700, China; 3.Guangxi Nanning Tianhai Surveying and Mapping Technology Co., Ltd., Nanning 530023, China; 4.Guangxi Meteorological Disaster Prevention Technology Center, Nanning 530022, China)
Abstract
This paper uses the disaster loss information data of Nanning City from 1984 to 2020, and combines the rainfall data to create a disaster information database with .mdb as the suffix, and designs a system with disaster loss information as the main line of research. The system is based on C# programming language, using ArcGIS Engine (AE) components as a development platform. It combines GIS technology, accesses the Access database and calls the SQL query language, and realizes the query and analysis of the impact of rainstorm and flood disaster process in Nanning City. The design results of the system show that the query and analysis system of rainstorm and flood disaster process impact based on ArcGIS Engine can basically realize the functions of data collation, information query, data visualization and data statistical analysis. The system developed by ArcGIS Engine can run independently without ArcGIS Desktop after installing Runtime and Software Development Kit. It has the characteristics of simple operation, high visualization and strong human-computer interaction.
Keywords
disaster data; database; C#; AE; GIS
References
- [1] Xu Zongxue, Chen Hao, Ren Meifang, etc Research progress on the mechanism and risk assessment of urban flooding in China [J]. Advances in Water Science, 2020, 31 (5): 713-724
- [2] Ye Jintao, Wang Zhibin, Peng Tao, etc Design and Application of rainstorm Basic Database System Based on Metadata [C]//The application practice and new technology exploration of S13 meteorological communication and information technology at the 31st annual meeting of the Chinese Meteorological Society Beijing: Chinese Meteorological Society, 2014:155-162
- [3] Zhu Zhibin, Li Dajun, He Hong Design and Implementation of National Weather Information Query System Based on AE [J]. Anhui Agricultural Science, 2010, 38 (8): 4347-4349
- [4] Liu Guangqian Implementation of ArcGIS Engine's Simple Graphic Drawing Function (Points, Lines, and Surfaces) (II) [N]. Electronic Bulletin, November 10, 2019 (007)
- [5] Liu Guangqian Implementation of ArcGIS Engine's Simple Graphic Drawing Function (Points, Lines, and Surfaces) (Part 1) [N]. Electronic Bulletin, November 3, 2019 (007)
- [6] Chen Xiaoxiao, Huang Zhiyong, Yao Yao, etc Characteristics and impacts of agricultural meteorological disaster losses in central China over the past 40 years [J]. Jiangxi Journal of Agriculture, 2022, 34 (11): 149-154
- [7] Liu Yongsheng Research on AE based Power Geographic Information System [D]. Baoding: North China Electric Power University, 2011
- [8] Yang Guangwu Method and Implementation of Depth Point and Contour Line Inspection Based on ArcGIS Engine [J]. Modern Information Technology, 2022, 6 (17): 98-100+104
- [9] Zhou Lang Design and Implementation of Electric Power Survey Geographic Information System Based on AE [D]. Huainan: Anhui University of Science and Technology, 2013
- [10] Feng Xuejiao, Wang Jiarui, Wang Liulin, etc Design and Development of University Cultural Tourism System Based on ArcGIS Engine [J]. Journal of Natural Sciences, Harbin Normal University, 2019, 35 (5): 91-97
- [11] Chen Junren, Yan Weiliang Design and Implementation of Underground Pipeline Management Information System Based on ArcGIS Engine [J]. Surveying and Mapping Technology Equipment, 2019, 21 (4): 30-33
Funding
Key R&D Program Project in Guangxi (Guike AB22080101); High score Special Project (84-Y50G25-9001-22/23); Student Innovation and Entrepreneurship Training Program Project Funding (202310603032)
About the authors
Liu Siyu (1999-), male, Han ethnicity, from Wuzhou, Guangxi, currently pursuing a master's degree in cartography and geographic information systems; Qu Fufu (1985-), male, Han ethnicity, Guangdong Maoming celebrity, assistant lecturer, undergraduate, research direction: marine meteorology; Liang Kunmei (1997-), female, Han ethnicity, from Rong County, Guangxi, assistant engineer, undergraduate, research direction: geographical and national monitoring; Chen Jianfei (1975-), male, from Wuxuan, Guangxi, Zhuang ethnicity, senior engineer, research direction: meteorological disaster prevention and reduction; Corresponding author: Liang Yulian (1984-), female, Zhuang nationality, from Nanning, Guangxi, associate professor, PhD, research direction: meteorological geographic information.