The Technology Of The Construction Of Nansi Lake Basin Water Environmental Information Multiple Source Database

Nansi lake as the important water distribution channel, store and regulative lake ofthe project, which is facing serious and urgent safety control duty of distributive waterquality. The paper combines with the second-level sub-topic“water environment qualityinvestigation and appraisal of rivers and lakes”, which in the technical significant specialsub-topic of water contamination control and govern in our country:“the integratedcontrol plan studies of water environment inquiry, the question diagnosis and the safetycontrol of transmission water quality in Nansi lake basin (2009ZX07210-007-01)”.Byconstructing Nansi Lake basin water environmental information multiple sourcedatabase, we can analyzed the source and causes of Nansi Lake water pollution andeutrophication from both natural factors and human factors.The paper draw support from the modern computer technology, use ASP.NET andSQLServer2000database, according to the assessment index requirements of theintegrated control plan studies of water environment inquiry, the question diagnosis andthe safety control of transmission water quality in Nansi Lake basin, develop a NansiLake basin water environmental information multiple source database, to clear up theNansi Lake basin water environmental information data comprehensively. Through theresearch and analysis, And draws the following conclusion:(1)Study and practice the feasibility of ASP.NET+SQLServer2000integrationtechnology on Nansi Lake basin water environmental information multiple sourcedatabase, study proves: The database building theory can realize the technical theoryrequest of Nansi Lake water environmental information database in its own dataorganization and management.(2)The database can offer a basic management framework and technology platformfor the centralized management and effective sharing of Nansi Lake waterenvironmental information; Different types of data can be entered a centralized databasemanagement system for centralized management; Data can be realized of online sharingand dynamic, visual search and release; Data query can be realized by browser whichcan ease the difficulties for users; Provides standardized environmental datamanagement. (3)The database clears up the Nansi Lake basin water environmental informationdata effectively, we can query manage Nansi Lake basin water environmentalinformation data conveniently, it can give play to the potential value of environmentalinformation for further, assist environmental management and decision making. Throughdata synthesize and analysis, administrative departments and leader can not only seebased data form, but also can more easily get the information that after processing andscreening, the database provides a scientific data management warehouse for thesecurity of water quality of the east-route of the south-to-north water diversion project.(4)Nansi Lake basin has developed industrial economy, key industrial pollution isnumerous, industrial structural pollution is serious, urban infrastructure construction lagsbehind urbanization, the discharge of city life sewage is already more than industrialwastewater, Non-point pollution problem in the basin is prominent, Local landreclamation from lake, fish farming surrounding the lake, overfishing, sewage and otheractivities, all of these activities make Nansi Lake and its watershed ecosystem sufferedserious damage, greatly weakened bearing capacity of natural ecological system,weakened the control and security function of the lake ecosystems to the diversion waterquality, increased the level of lake eutrophication. Meanwhile, there are more than50million mu platform fields and fish ponds, more than10million farmers or fishermen inlake area. Using of pesticide and fertilizer in platform fields, fishery breeding, scatteredresidents sewage discharge.etc caused a lot of non-point pollution enter the lake. Thiscaused great threat to the security of water quality directly, Dramatically restricted andinfluenced Nansi Lake basin water environmental management and the implementationof water quality guarantee measures relevantly.(5)The water quality of Nansi Lake is getting better gradually as a whole, but stillhas the distance from the water quality goal.Suggest to adjust the industrial structure further, transform end-treatment intosource management, carry out clean production craft; Strict implementation of the “threesimultaneity” system; Speed up the construction advancement of sewage treatmentplants in cities; Strengthen the construction and optimal scheduling of the sewageinterception and rever diversion project; Governments at all levels and departmentsshould strengthen the environmental supervision, increase the legislation and enforcement efforts, promote the harmonious development of the economy, the societyand the environment in Nansi Lake basin.