Disclosure of Invention
In order to solve the technical problem, the present disclosure provides a database system for sponge city construction projects, including:
an online monitoring database, an operation management database, a geographic information database, and: documents, multimedia databases;
the online monitoring database is used for storing the items: flow online monitoring data, liquid level online monitoring data, water quality online monitoring data, rainfall online monitoring data and temperature online monitoring data;
the operation management database is used for storing the project management data and the statistical filling data, wherein the project management data comprises: project basic data, project process data, facility management data; the statistical filling data comprises: water quality detection data, weather filling data and water accumulation point information;
the geographic information database is for storing: administrative region planning map, land utilization map, node pipeline map layer, LID facility map layer and building map layer;
the document and multimedia database is used for storing documents and multimedia data in the following aspects: sponge city system construction, sponge city project management data and social and economic statistics data;
for the online monitoring database, an operation management database, a geographic information database, and: a document, a multimedia database, wherein,
the various databases are physically separate, but logically related, and,
each database is provided with a data interface for butting a superior management platform of the current sponge city project so as to carry out visual display.
Preferably, the geographic information database includes, in the geographic information database,
all elements in traffic and natural geography aspects such as administrative areas, water systems, vegetation, residential areas, roads, railways, river shorelines and the like are layered according to proper rules and classified and coded according to standards, and basic geographic information data and a geographic thematic map are generated according to the spatial position, attribute information and the mutual spatial relationship of the elements, wherein the geographic thematic map further comprises a digital high-level map and a soil utilization map.
Preferably, the geographic information database includes, in the geographic information database,
the method comprises the steps of associating the spatial information of sponge city construction projects, facilities and online monitoring instruments with pipelines, node layers and catchment area layers, and organizing the spatial information in a layer mode according to elements for all related elements.
Preferably, the first and second liquid crystal materials are,
the online monitoring database comprises data acquired by online monitoring instruments in drainage partitions, river water systems, municipal drainage pipelines and plots.
Therefore, the database system for uniformly storing the data and facilitating later-stage application is realized, and not only is uniform visual display facilitated, but also spatial identification of the information is facilitated.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present disclosure more clear, the technical solutions of the embodiments of the present disclosure will be described clearly and completely with reference to fig. 1 of the embodiments of the present disclosure, and it is obvious that the described embodiments are some, but not all embodiments of the present disclosure. It should be noted that, in the present disclosure, the embodiments and features of the embodiments may be combined with each other without conflict. The present invention will be described in detail below with reference to the embodiments with reference to the attached drawings. All other embodiments, which can be derived by a person skilled in the art from the embodiments disclosed herein without making any creative effort, shall fall within the protection scope of the present disclosure.
It should be noted that the terms "first", "second", etc. in the description and claims of the present disclosure and the accompanying drawings are only used for distinguishing some objects and are not used for describing a specific order or sequence. It is to be understood that the terms so used are interchangeable under appropriate circumstances for describing the embodiments of the disclosure herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In one embodiment, in conjunction with fig. 1, the present disclosure discloses a database system for sponge city construction projects, comprising:
an online monitoring database, an operation management database, a geographic information database, and: documents, multimedia databases;
the online monitoring database is used for storing the items: flow online monitoring data, liquid level online monitoring data, water quality online monitoring data, rainfall online monitoring data and temperature online monitoring data;
the operation management database is used for storing the project management data and the statistical filling data, wherein the project management data comprises: project basic data, project process data, facility management data; the statistical filling data comprises: water quality detection data, weather filling data and water accumulation point information;
the geographic information database is for storing: administrative region planning map, land utilization map, node pipeline map layer, LID facility map layer and building map layer;
the document and multimedia database is used for storing documents and multimedia data in the following aspects: sponge city system construction, sponge city project management data and social and economic statistics data;
for the online monitoring database, an operation management database, a geographic information database, and: a document, a multimedia database, wherein,
the various databases are physically separate, but logically related, and,
each database is provided with a data interface for butting a superior management platform of the current sponge city project so as to carry out visual display.
For the embodiment, the unified storage and management of various data are fully considered, and meanwhile, a data interface facing to a superior management platform, such as a department-level sponge city informatization integrated management platform, is reserved in the database, so that the visual display and subsequent business support of sponge city construction effects are realized. Furthermore, the physically separate but logically related nature of the various databases makes them logically closely related in the run management, which is advantageous in maintaining data consistency.
In another embodiment, the geographic information database,
all elements in traffic and natural geography aspects such as administrative areas, water systems, vegetation, residential areas, roads, railways, river shorelines and the like are layered according to proper rules and classified and coded according to standards, and basic geographic information data and a geographic thematic map are generated according to the spatial position, attribute information and the mutual spatial relationship of the elements, wherein the geographic thematic map further comprises a digital high-level map and a soil utilization map.
For the embodiment, the spatial position, the attribute information and the mutual spatial relationship of each element in the aspects of traffic and natural geography are fully utilized, and the corresponding basic geographic information data and the geographic thematic map are obtained on the basis, so that the corresponding spatial position, the attribute information, the mutual spatial relationship, the basic geographic information relationship and the geographic thematic map are established in the database system, the space is further related to the related information and map, and the data visualization of the database system in a superior management platform is facilitated.
It should be noted that, for the thematic map, the display of the corresponding index, the operation and maintenance KPI, and the like is realized through spatial superposition analysis and spatial attribute data calculation, for example:
(1) the special information display of assessment indexes such as annual runoff total control rate, urban non-point source pollution control rate, heat island effect and the like is realized;
(2) the method realizes the display of different types, different stages and different assessment results of projects, and can be associated by combining four levels of region-plot-cell road-low-influence facilities.
In another embodiment, the geographic information database,
the method comprises the steps of associating the spatial information of sponge city construction projects, facilities and online monitoring instruments with pipelines, node layers and catchment area layers, and organizing the spatial information in a layer mode according to elements for all related elements.
It can be understood that the spatial information and the layer in this embodiment are also beneficial to data visualization of the database system in the upper management platform.
In another embodiment of the present invention, the substrate is,
the online monitoring database comprises data acquired by online monitoring instruments in drainage partitions, river water systems, municipal drainage pipelines and plots.
For this embodiment, it defines the source of the monitoring data.
Further, in another embodiment,
the monitoring points corresponding to the online monitoring instrument are determined through the following steps:
s100, establishing association among all elements according to the drainage network distribution, the urban inland river water system, the sponge city construction project distribution and the various elements related to the land utilization condition;
s200, preliminarily selecting a monitoring area/section according to the association among the elements;
s300, after a monitoring area/section is selected preliminarily, performing site investigation, and preliminarily determining a monitoring point meeting the installation requirement of an online monitoring instrument;
s400, various online monitoring instruments such as liquid level, flow and water quality are installed at the preliminarily determined monitoring points, and data obtained by the online monitoring instruments are analyzed so as to further adjust the monitoring points.
It can be understood that the above embodiment further optimizes the determination mode of the monitoring points, makes it more reasonable, and can maximally reduce the number of the monitoring points and the arrangement cost of the corresponding online monitoring instrument, and can further reduce the redundancy of the monitoring data from the data source.
In another embodiment, for the operation management database,
the data corresponding to the first-level indexes comprise data of water safety, water environment, water ecology and water resource, wherein,
the data in the aspect of water safety is characterized by the data of the urban waterlogging according to the secondary indexes, and the data specifically comprises the following steps: water level data and ponding water depth data of the waterlogging ponding water level monitoring point and corresponding videos;
the data in the aspect of the water environment are represented by data of secondary indexes of water environment quality and SS reduction rate, wherein:
data on water environment quality was determined from data from the following sources: a drainage outlet monitoring section, a sponge land block monitoring point, a pipe network node monitoring section and a passenger water monitoring section; for example, the indexes of SS, COD and NH3-N, TP measured by actually measuring the drainage port monitoring section; and measuring SS data by actually measuring sponge land monitoring points, pipe network node monitoring sections and passenger water monitoring sections.
Data for SS reduction rate was determined by comparing measured SS data from the following sources: SS basal value monitoring points, water outlet monitoring sections, sponge land block monitoring points, pipe network node monitoring sections and passenger water monitoring sections.
The data in the aspect of water ecology are characterized by the data of the annual runoff total quantity control rate and the heat island effect of secondary indexes, wherein:
the data of the total annual runoff control rate is determined by carrying out water balance calculation according to the data from the following sources:
outlet monitoring section, sponge landmass monitoring point, rainfall monitoring station, pipe network node monitoring section, guest water monitoring section, evaporation capacity monitoring point to and: monitoring points of a regulation pool and a reservoir; for example, according to the flow of the drainage port monitoring section, the infiltration flow of the sponge plot monitoring point, the rainfall of the rainfall monitoring station, the flow of the official website node monitoring section, the monitoring flow of the passenger water section, the evaporation capacity of the evaporation capacity monitoring point, and: and regulating the water level and the water quantity of monitoring points of the storage pool and the water storage pool, and performing water quantity balance calculation.
The data of the heat island effect is determined by the temperature of the temperature monitoring point.
The data in the aspect of the water resource is represented by data of a second-level index rainwater resource collection utilization rate and a sewage regeneration utilization rate, wherein:
the data of the rainwater resource collection utilization rate is determined by comparing the data from the following sources: a rainfall monitoring station and a regulation and storage pool rainwater utilization monitoring station; for example, according to the rainfall of a rainfall monitoring station, the rainwater in the storage regulation pool is determined by comparing the flow and the water quantity of the monitoring station;
the data for wastewater reuse efficiency were determined from the following sources: the data base system and the sewage information sharing interface of the sewage plant system, and the flow and water quantity data of the sewage utilization monitoring point.
For monitoring the flow of the section and the water quality of a drainage outlet, carrying out on-line monitoring on liquid level, flow, water quality SS and the like and manual acquisition and detection of other water quality indexes at the drainage outlets of a river channel and a water channel in an engineering area;
monitoring the flow and SS of the nodes of the pipe network, monitoring the liquid level, the flow and the like at key nodes of the municipal drainage pipeline, taking the monitored data as process monitoring data, and providing a basis for operation assessment and risk early warning;
monitoring the flow and SS of the sponge land, and tracking and monitoring the liquid level, the flow, the water quality and the like according to the main functions of facilities of typical facilities with different underlying surface types, such as a biological retention facility, a permeable pavement, a green roof, a rainwater garden, a sunken green land, a grass planting ditch, a high-position flower bed and the like; for the project demonstration of the engineering district plot, the water outlet of the project demonstration project is monitored for liquid level, flow, water quality and the like, the water outlet is used as source monitoring data, and meanwhile, the comparison monitoring of an automatic monitoring station is used as an auxiliary basis for providing the operation effect of the sponge city construction project; it should be noted that: the main sponge facilities comprise typical facilities such as a rainwater garden, a sunken green land, a grass planting ditch, a high-position flower bed and the like, 2 monitoring stations are arranged on each typical facility, and 6 monitoring stations are arranged in total; according to typical structures of the bioretention facility and the grass planting ditch, measuring points can be respectively arranged at an inlet of the bioretention facility, a flow outlet and a water outlet at the bottom of a water discharge pipe to monitor flow and SS; typically, 3 sets of flow and SS monitoring points are deployed for each bioretention facility and grass planting trench.
For the monitoring of the SS base value monitoring point, the method comprises the following steps: and monitoring the SS values of the flow and the confluence of the typical underlying surface in the engineering area, and taking the SS values as area background monitoring values. On-line monitoring of water quantity, water quality and the like is carried out on a key control section of the river channel by using a background on-line monitoring instrument, the on-line monitoring is used as a basic basis for water environment quality assessment of the river system of the sponge city, and monitoring, early warning and forecasting of the river water level change rule in the rainfall process are carried out through upstream and downstream liquid level monitoring;
monitoring the flow of passenger water and SS from outside the area, monitoring the liquid level, the flow and the like at inflow and outflow nodes of municipal drainage pipelines at the engineering range boundary, taking the monitoring data as process monitoring data, and providing a basis for operation evaluation and risk early warning;
for monitoring the rainwater utilization amount and the flow, the rainwater utilization monitoring station monitors the rainwater utilization amount of the storage tank, monitors the water amount, the water quality and other monitoring modules through the rainwater utilization monitoring station, collects monitoring data of the actual rainwater utilization amount of the rainwater utilization project as rainwater, and provides basis for evaluating the operation effect of the facility according to rainfall data of the rainwater utilization monitoring station.
The above is merely a preferred embodiment of the present disclosure and is not intended to limit the present disclosure, which may be variously modified and varied by those skilled in the art. Any modification, equivalent replacement, improvement and the like made within the spirit and principle of the present disclosure should be included in the protection scope of the present disclosure.