By Topic

Design of Jinan City Flood Prevention and Warning Decision-Making Support System Based on SQL Server and GIS

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

The purchase and pricing options are temporarily unavailable. Please try again later.
3 Author(s)
Haofang Wang ; Sch. of Civil Eng., Shandong Univ. China, Jinan, China ; Wenyan Chen ; Su-Lin Song

Jinan City flood prevention and warning decision support system based on SQL Server and GIS is to make use of real time rainfall information, real time hydrological information, engineering information, danger situations, disaster information as well as the rainfall runoff model in model database based on SQL Server to simulate the road flood situation, real time forecast the course of the flood (water level, flow, depth, velocity) and possible submerged condition (the scope of flooding, flood water depth), and through the GIS platform to realize visual image display. Then according to the early warning levels indexes for blue early warning, yellow early warning, orange early warning and red early warning respectively to determine the rainfall and flood warning level, and to startup the corresponding warning level. Finally, the flood control decision making and flood control based on the different flood warning levels of flood control programs of decision making database are to be carried out. So the decision support system consists of basis database, spatial database, flood simulation model database, flood early warning database, flood prevention preparedness database, decision-making database, GIS display and so on. The decision making system will provide a scientific basis for flood prevention department.

Published in:

Database Technology and Applications, 2009 First International Workshop on

Date of Conference:

25-26 April 2009