CN117573654A - Wading enterprise database creation method and device for industrial pollution source - Google Patents

Wading enterprise database creation method and device for industrial pollution source Download PDF

Info

Publication number
CN117573654A
CN117573654A CN202311622295.1A CN202311622295A CN117573654A CN 117573654 A CN117573654 A CN 117573654A CN 202311622295 A CN202311622295 A CN 202311622295A CN 117573654 A CN117573654 A CN 117573654A
Authority
CN
China
Prior art keywords
data
wading
enterprise
database
pollution source
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202311622295.1A
Other languages
Chinese (zh)
Other versions
CN117573654B (en
Inventor
王赫婧
张倩
李天然
赵威光
王夏娇
温玉姣
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Technical Center Of Soil And Agricultural Rural Ecological Environment Supervision Ministry Of Ecological Environment
Original Assignee
Technical Center Of Soil And Agricultural Rural Ecological Environment Supervision Ministry Of Ecological Environment
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Technical Center Of Soil And Agricultural Rural Ecological Environment Supervision Ministry Of Ecological Environment filed Critical Technical Center Of Soil And Agricultural Rural Ecological Environment Supervision Ministry Of Ecological Environment
Priority to CN202311622295.1A priority Critical patent/CN117573654B/en
Priority claimed from CN202311622295.1A external-priority patent/CN117573654B/en
Publication of CN117573654A publication Critical patent/CN117573654A/en
Application granted granted Critical
Publication of CN117573654B publication Critical patent/CN117573654B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/215Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02ATECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
    • Y02A20/00Water conservation; Efficient water supply; Efficient water use
    • Y02A20/152Water filtration

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Quality & Reliability (AREA)
  • Computing Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a wading enterprise database creation method and device for an industrial pollution source, wherein the method comprises the following steps: in a target flow field, acquiring basic information and pollution source information of all wading enterprises from at least two data sources; integrating and checking the basic information acquired from different data sources to obtain enterprise inventory data; integrating and correcting the pollution source information acquired from different data sources to acquire pollution source data; constructing a database of wading enterprises in the target river basin based on the enterprise inventory data and the pollution source data; the wading enterprise database information at least comprises the conditions of an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period, a receiving water body and the like. The method realizes the accurate full coverage of related information of the wading enterprises, and provides data support for tracing pollutants of the wading enterprises, thereby improving the tracing accuracy and efficiency.

Description

Wading enterprise database creation method and device for industrial pollution source
Technical Field
The invention relates to the field of environmental protection, in particular to a wading enterprise database creation method and device for an industrial pollution source.
Background
At present, the condition of pollutant emission may exist in wading enterprises distributed near water bodies such as rivers and lakes, and in order to facilitate pollutant emission tracing of the wading enterprises, the prior art adopts a mode of checking and recording key targets home by home, so that time and labor are wasted, key targets are difficult to determine, omission is easy to cause, and tracing accuracy is poor.
In view of this, providing a method and a device for creating a wading enterprise database for an industrial pollution source, so as to achieve accurate full coverage of relevant information of the wading enterprise, and provide data support for tracing pollutants of the wading enterprise, thereby improving tracing accuracy and efficiency, which is a problem to be determined by those skilled in the art.
Disclosure of Invention
Therefore, the embodiment of the invention provides the method and the device for creating the wading enterprise database for the industrial pollution source, so that the accurate full coverage of relevant information of the wading enterprise is realized, and data support is provided for tracing the pollutants of the wading enterprise, thereby improving the tracing accuracy and efficiency.
In order to achieve the above object, the embodiment of the present invention provides the following technical solutions:
the invention provides a wading enterprise database creation method for an industrial pollution source, which comprises the following steps:
in a target flow field, acquiring basic information and pollution source information of all wading enterprises from at least two data sources;
integrating and checking the basic information acquired from different data sources to obtain enterprise inventory data; integrating and correcting the pollution source information acquired from different data sources to acquire pollution source data;
constructing a database of wading enterprises in the target river basin based on the enterprise data and the pollution source data;
the wading enterprise database information at least comprises an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period and a water receiving body condition.
In some embodiments, the basic information and pollution source information of all wading enterprises are obtained from at least two data sources, and the method specifically comprises the following steps:
acquiring first basic information and first pollution source information of all wading enterprises from a pre-constructed investigation data database;
and acquiring second basic information and second pollution source information of the wading enterprise from a public pollution data database.
In some embodiments, constructing an investigation data database specifically includes:
and integrating the basic information of the target enterprises and the pollution source information of the target enterprises into an investigation data database based on the enterprises which are mastered by a certain river basin and relate to water taking and water draining as target enterprises. Pollution source information
In some embodiments, the obtaining the second basic information and the second pollution source information of the wading enterprise from the public pollution data database specifically includes:
acquiring basic information and pollution source information of all wading enterprises from a pollution source census database, an environment statistics database and a pollution discharge permission database respectively;
and integrating and checking the basic information and pollution source information of all wading enterprises obtained from the pollution source census database, the environment statistics database and the pollution discharge permission database to obtain second basic information and second pollution source information of the wading enterprises.
In some embodiments, the integration and verification of the basic information obtained from different data sources to obtain enterprise data specifically includes:
pollution source information is combined with databases of different sources of enterprises, pollution source census and site investigation data are supplemented based on pollution discharge permission and environmental statistics data, and basic information in multi-source data is integrated and checked;
based on the principle of leak detection and deficiency replacement, taking an enterprise involved in a multi-source database as a target enterprise;
and constructing the target enterprise list and the basic information data list based on the integrated basic information data.
Pollution source information
In some embodiments, the integration and calibration of the pollution source information acquired from different data sources to obtain pollution source data specifically includes:
pollution source information is combined with databases of different sources of enterprises, pollution source census and site investigation data are supplemented based on pollution discharge permission and environmental statistics data, and integration and check of the pollution source information in multi-source data are carried out;
performing trend analysis according to different enterprise data of the same industry on the same scale, taking the median value and the average value of different enterprise data as references, and selecting 100% of positive and negative deviation data from different source databases as wading data;
and constructing a pollution source data list of the target enterprise based on the integrated wading data.
In some embodiments, the method further comprises:
in the process of creating a database of wading enterprises in a target river basin, combining the demarcation of a high-sulfur and high-fluorine area of underground water, screening out wading enterprises which relate to the high-sulfur and high-fluorine area in the database, and endowing the wading enterprises with a 'water taking heavy point source' label so as to establish a sulfate and fluoride water taking heavy point source database in the database.
The invention also provides a wading enterprise database creation device for an industrial pollution source, the device comprising:
the data acquisition unit is used for acquiring basic information and pollution source information of all wading enterprises from at least two data sources in a target stream domain;
the data integration unit is used for integrating and checking the pollution source information acquired from different data sources to acquire pollution source data; integrating and checking basic information acquired from different data sources to obtain enterprise data;
a database construction unit for constructing a database of the wading enterprise in the target river basin based on the enterprise data and the pollution source data;
the wading enterprise database information at least comprises an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period and a water receiving body condition.
The invention also provides a computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method as described above when executing the program.
The invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method as described above.
According to the wading enterprise database creation method for the industrial pollution source, basic information and pollution source information of all wading enterprises are obtained from at least two data sources in a target flow field; integrating and correcting the pollution source information acquired from different data sources to acquire pollution source data; integrating and checking basic information acquired from different data sources to obtain enterprise data; constructing a database of wading enterprises in the target river basin based on the enterprise data and the pollution source data; the wading enterprise database information at least comprises the conditions of an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period, a receiving water body and the like.
In this way, pollution source census, pollution discharge permission data, environment statistics data and field investigation data are combined, pollution source census data and field investigation data are used as the basis, pollution source census data and field investigation data are supplemented, multi-source data are integrated and checked, relevant information such as basic conditions, water taking conditions, water draining conditions and receiving water conditions of a wading enterprise is finally defined, a wading enterprise database is built, accurate tracing of the wading enterprise is achieved, and a comprehensive and accurate data basis is provided for follow-up determination of pertinence of investigation evaluation objects, effectiveness of a process and accuracy of results. The method realizes the accurate full coverage of related information of the wading enterprises, and provides data support for tracing pollutants of the wading enterprises, thereby improving the tracing accuracy and efficiency.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below. It will be apparent to those of ordinary skill in the art that the drawings in the following description are exemplary only and that other implementations can be obtained from the extensions of the drawings provided without inventive effort.
The structures, proportions, sizes, etc. shown in the present specification are shown only for the purposes of illustration and description, and are not intended to limit the scope of the invention, which is defined by the claims, so that any structural modifications, changes in proportions, or adjustments of sizes, which do not affect the efficacy or the achievement of the present invention, should fall within the ambit of the technical disclosure.
FIG. 1 is a flow chart of a method of creating a wading enterprise database for an industrial pollution source provided by the present invention;
FIG. 2 is a block diagram of a wading enterprise database creation apparatus for industrial pollution sources provided by the present invention;
fig. 3 is a block diagram of a computer device according to the present invention.
Detailed Description
Other advantages and advantages of the present invention will become apparent to those skilled in the art from the following detailed description, which, by way of illustration, is to be read in connection with certain specific embodiments, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, fig. 1 is a flowchart of a method for creating a wading enterprise database for an industrial pollution source according to the present invention.
In one specific embodiment, the method for creating the wading enterprise database for the industrial pollution source provided by the invention comprises the following steps of:
s110: in a target flow field, acquiring basic information and pollution source information of all wading enterprises from at least two data sources;
s120: integrating and correcting the pollution source information acquired from different data sources to acquire pollution source data; integrating and checking basic information acquired from different data sources to obtain enterprise data;
s130: constructing a database of wading enterprises in the target river basin based on the enterprise data and the pollution source data; the wading enterprise database information at least comprises the conditions of an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period, a receiving water body and the like.
Specifically, the basic information of the wading enterprises comprises the city, county, village, latitude and longitude, industry category, whether the wading enterprises belong to a groundwater high-sulfur area, whether the wading enterprises belong to a groundwater high-fluorine area, whether sulfate is discharged, the main links of sulfate discharge, whether fluoride is discharged and the main links of fluoride discharge. Industry category referring to national economic industry Classification (GB/T4754-2017), the specific industry category to which the main product produced under the normal production condition belongs (generally, the main product occupies a larger proportion in the total industrial yield value) is confirmed; whether the underground water belongs to a high sulfur zone and a high fluorine zone of the underground water is mainly referred to the underground water condition and the on-site monitoring result; whether to discharge sulfate and fluoride is determined mainly in combination with industry category and main process links.
The water intake condition includes water intake source (groundwater/surface water), water intake amount, water intake fluoride concentration, water intake sulfate concentration, whether exceeding standard. The concentration of the water taking sulfate and the fluoride is judged according to the requirements that the limit value of the sulfate in the class I, the class II, the class III, the class IV and the class V in the groundwater quality standard (GB/T14848-2017) is less than or equal to 50mg/L, less than or equal to 150mg/L, less than or equal to 250mg/L, less than or equal to 350mg/L and more than 350mg/L respectively, and the limit value of the fluoride in the class I, the class II, the class III, the class IV and the class V is less than or equal to 1.0mg/L, less than or equal to 2.0mg/L and more than 2.0mg/L respectively.
The drainage conditions include the amount of drainage water, the drainage direction, whether the external environment is directly discharged (directly discharged from rivers, lakes and seas, discharged from the rivers, lakes and seas through a pipe network), the concentration of drainage fluoride, the concentration of drainage sulfate and whether the standard is exceeded. The drainage includes directly entering sea area, directly entering water environment such as rivers, lakes and reservoirs, entering urban sewer (reentry into rivers, lakes and reservoirs), entering urban sewer (reentry into coastal sea area), directly entering sewage irrigation farmland, entering ground infiltration or evaporation field, and other types, wherein the waste water is indirectly discharged into the environment to fill in the names of the wastewater treatment plants. The concentration of the fluoride and the sulfate in the drainage is determined based on the monitoring result according to the requirements that the limit values of the fluoride key protection area and the general protection area in the comprehensive emission standard of the water pollutants in a certain province are 2mg/L and 3mg/L respectively, and the limit values of the sulfate key protection area and the general protection area are 650 mg/L.
The water receiving conditions comprise the name of the water receiving body, the functional target of the water receiving body, the name of the downstream section, the fluoride concentration of the section, the sulfate concentration of the section and whether the section exceeds the standard. The concentration of sulfate and fluoride is determined based on the monitoring result according to the requirements that the limit value of fluoride in class I, class II, class III, class IV and class V in the surface water environment quality standard (GB 3838-2002) is less than or equal to 1.0mg/L, less than or equal to 1.5mg/L and less than or equal to 1.5mg/L respectively, and the standard limit value of sulfate serving as a surface water source of centralized domestic drinking water is 250 mg/L.
That is, in the stage of establishing the wading enterprise database, for example, a yellow river basin wading enterprise database is established, in an actual use scenario, the second secondary pollution source census, the pollution discharge permission data, the environment statistics data and the data reported by each market can be combined, pollution source census data is supplemented based on the pollution discharge permission and the environment statistics data, and the integration and the check of the multi-source data are performed, so that the relevant information such as the basic condition, the water taking condition, the water draining condition, the water receiving condition and the like of the wading enterprise is finally defined, and the wading enterprise database is established.
The industrial pollution source wading enterprise database is determined by combining the second national pollution source census (2017), environmental statistics (2020), pollution discharge permission and investigation data, and the integration and check of multi-source data are needed because of the inconsistency of different data source time, statistical caliber, data integrity and the like, so that the database for the industrial pollution source to be investigated is determined. The industrial pollution source wading enterprise database is built by merging and establishing wading enterprises which are incorporated in pollution discharge license supervision, 2020 environmental statistics and 2017 secondary pollution source census enterprises after de-duplication. In addition, related information such as water taking, water draining and the like is mainly studied on site, and the conventional data sources are used as supplements.
In step S110, the basic information and pollution source information of all wading enterprises are obtained from at least two data sources, which specifically includes:
acquiring first basic information and first pollution source information of all wading enterprises from a pre-constructed investigation data database; the method for constructing the investigation data database specifically comprises the following steps:
arranging a plurality of monitoring points in a target river basin, and collecting pollutant emission data of each monitoring point;
taking a wading enterprise generating the pollutant emission data as a target enterprise under the condition that the monitored pollutant emission data reaches a screening threshold value;
traversing all target enterprises obtained from all monitoring points in the target river basin, and integrating the basic information of the target enterprises and the pollution source information of the target enterprises into an investigation data database.
And acquiring second basic information and second pollution source information of the wading enterprise from a public pollution data database. Specifically, basic information and pollution source information of all wading enterprises are respectively obtained from a pollution source general survey database, an environment statistics database and a pollution discharge permission database; and integrating and checking the basic information and pollution source information of all wading enterprises obtained from the pollution source census database, the environment statistics database and the pollution discharge permission database to obtain second basic information and second pollution source information of the wading enterprises.
For example, the pollutant screening database may utilize secondary pollution source screening data, with industrial pollution source screening subjects being all industrial units of industrial activity that produce wastewater pollutants, exhaust pollutants, and solid waste. Basic conditions of enterprises, raw and auxiliary material consumption, product production conditions, pollution-generating facility conditions, various pollutant generation, treatment, emission and comprehensive utilization conditions (including emission port information, emission mode, emission direction and the like), various pollution control facility construction, operation conditions and the like, and wastewater pollutants including chemical oxygen demand, ammonia nitrogen, total phosphorus, petroleum, volatile phenol, cyanide, arsenic, lead, cadmium, chromium and mercury. The second national pollution source screening (2017) period data is 2017.
The environmental statistics database adopts the investigation object of the industrial source in the emission source statistics investigation as mining industry in national economy industry classification (GB/T4754-2017), industrial enterprises (without army enterprises) which are included in important investigation in 3 categories of manufacturing industry, electric power, heating power, gas and water production and supply industry, including various industrial enterprises which are approved and registered by the industrial administration management department and get the business license and industrial enterprises which are not approved by related departments but actually engage in industrial production and operation activities, and have pollutants and greenhouse gas generation or emission. The industrial source investigation method is used for investigating heavy investigation units by families, and the overall estimation of the pollution discharge production condition of non-heavy investigation units is carried out. The screening principle of the key investigation unit takes a municipal administration area as a basic unit, takes a public inspection directory library of a second national pollution source in 2017 as a total sample, and preliminarily determines the discharge amount of wastewater, chemical oxygen demand, ammonia nitrogen, total phosphorus, sulfur dioxide, nitrogen oxides, particulate matters, volatile organic matters and ammonia, the production amount of general industrial solid waste meets the screening definition requirement, and industrial enterprises which are produced by wastewater or waste gas heavy metals (arsenic, cadmium, lead, mercury, hexavalent chromium or total chromium) and have dangerous waste and meet the screening condition of emission source statistics technical regulation as the key investigation unit. Dynamic updating and adjustment are carried out every investigation year by key investigation institutions, and industrial enterprises with screening index pollutant production/discharge larger than scale values, industrial enterprises with waste water or waste gas heavy metals (arsenic, cadmium, lead, mercury, hexavalent chromium or total chromium) in new (modified) construction projects, industrial enterprises with dangerous wastes in new (modified) construction projects, industrial enterprises which are listed as key pollution discharge institutions, industrial enterprises which have issued pollution discharge licenses and are mainly managed, and the like are brought into key investigation ranges. Environmental statistics surveys major investigation units home by home, enterprises conforming to screening principles are brought into the major investigation unit range, and ecological environmental departments in each place can appropriately increase major investigation units according to local management requirements, so that an industrial pollution source database in the environmental statistics is not fully covered, and in addition, two pollution factors of sulfate and fluoride are not involved in the environmental statistics.
The pollution discharge permission database carries out pollution discharge permission key management, simplified management and registration management according to the pollution discharge permission classification management directory of fixed pollution source (2019 edition), and the factors such as pollutant production quantity, emission quantity, influence degree on the environment and the like of enterprises and public institutions and other production operators (hereinafter referred to as pollution discharge units) for discharging pollutants. The pollution discharge permission key management is implemented on pollution discharge units with larger pollutant production amount, emission amount or environmental influence degree; and a pollution discharge unit with smaller pollution discharge amount and environmental influence is used for realizing pollution discharge permission and simplifying management. Pollution discharge registration management is performed for pollution discharge units having small pollution discharge amount, emission amount and environmental influence. The industrial enterprise to be selected for the nano-license supervision is incorporated into a wading enterprise database, and the information of the pollution discharge license comprises a unit name, a city, a county, a pollution discharge license number, an industry category, a wastewater pollutant category, a discharge destination, a discharge mode, a discharge rule, a discharge port name, a discharge port type, a receiving water body information name, a receiving water body function target and the like. The main problems are that most of the discharged and discharged water, the type of the discharge outlet and the information of the water filled in the receiving water are empty or irregular, whether the information is the real situation of an enterprise cannot be judged, and the data has no information of key indexes such as water intake, water intake sources, water discharge and the like, so that pollution general investigation, environment statistics and verification and supplement after on-site investigation are needed.
The on-site investigation is carried out according to a unified enterprise information acquisition table, the on-site investigation comprises four parts of basic information, water taking conditions, water discharging conditions and downstream river section conditions, and the water taking conditions (water taking sources, water quantity, water quality and self-provided water well conditions) and water discharging conditions (water discharging directions, water discharging amounts and the like) are focused and investigated on the basis of collecting the basic information of enterprises. And (5) summarizing the investigation results of each enterprise after finishing, and checking the integrity and the accuracy of the filling form in the summarizing process. A specialized archive manager is arranged to be responsible for collecting, organizing, summarizing, storing, keeping secret, etc. all archives of the sample survey.
In some embodiments, the integration and verification of the basic information obtained from different data sources to obtain enterprise data specifically includes:
combining databases of different sources of enterprises, supplementing pollution source census and site investigation data based on pollution discharge permission and environmental statistics, and integrating and checking basic information in multi-source data;
based on the principle of leak detection and deficiency replacement, taking an enterprise involved in a multi-source database as a target enterprise;
and constructing the target enterprise list and the basic information data list based on the integrated basic information data.
In some embodiments, the integration and calibration of the pollution source information acquired from different data sources to obtain pollution source data specifically includes:
pollution source information is combined with databases of different sources of enterprises, pollution source census and site investigation data are supplemented based on pollution discharge permission and environmental statistics data, and integration and check of the pollution source information in multi-source data are carried out;
performing trend analysis according to different enterprise data of the same industry on the same scale, taking the median value and the average value of different enterprise data as references, and selecting 100% of positive and negative deviation data from different source databases as wading data;
and constructing a pollution source data list of the target enterprise based on the integrated wading data.
Further, the method further comprises:
in the process of creating a database of wading enterprises in a target river basin, combining the demarcation of a high-sulfur and high-fluorine area of underground water, screening out wading enterprises which relate to the high-sulfur and high-fluorine area in the database, and endowing the wading enterprises with a 'water taking heavy point source' label so as to establish a sulfate and fluoride water taking heavy point source database in the database.
For easy understanding, the following is a specific usage scenario, and the implementation procedure of the method provided by the present invention is briefly described below:
taking a certain river basin as an example, constructing a river basin wading enterprise database based on multi-source data such as pollution discharge permission, environment statistics, secondary pollution source screening, field investigation and the like, wherein the river basin wading enterprise database comprises a wading enterprise database in administrative division and a wading enterprise emission database in a river basin control unit. The database can divide the river basin water environment control unit by taking the assessment section of the receiving water body as a research object and combining administrative division and the condition of the receiving water body, research the pollutant entering river input channels, survey the discharge characteristics of the sewage outlet of each river, construct a river basin pollutant discharge network structure based on the sewage outlet, provide a basis for subsequent pollution investigation, tracing and emergency monitoring, and improve the monitoring capability on the quality of the receiving water body and the section water.
The industrial pollution source wading enterprise database refers to a comprehensive database of basic conditions, water taking conditions, water draining conditions and water receiving conditions of industrial enterprises and centralized industrial sewage treatment plants in a certain river basin, can provide the overall distribution conditions of sulfate and fluoride in the certain river basin and the total amount of water entering the certain river basin, is an important basis for researching pollution causes of sulfate and fluoride in the certain river basin, controls pollution source emission and solves the pollution problem of sulfate and fluoride in the industrial pollution source, and therefore, the method can follow the standard, effective and complete principles in the process of database compiling work.
Firstly, dividing industrial pollution source wading enterprises into industrial enterprises and centralized industrial sewage treatment plants, wherein the industrial enterprises are industrial enterprises or industrial activity units of 41 industrial major industries in 3 categories of electric power, heating power, gas and water production and supply industry, namely mining industry, manufacturing industry, electric power, heating power, gas and water production and supply industry in national economy industry classification (GB/T4754-2017); a centralized industrial sewage treatment plant is a centralized sewage treatment unit that mainly receives industrial sewage. The monitoring, estimation and emission database is compiled on the basis. Secondly, the water taking source and the wastewater discharge destination of industrial pollution source wading enterprises are defined, the position relation between the pollution source and the river basin is established according to basic data such as hydrology and field investigation, and the name of the receiving water body is defined. And finally, according to the information of industry types, raw and auxiliary materials, production processes and the like obtained in pollution discharge permission, statistical investigation and field investigation, combining the monitoring value of the characteristic pollutants and material balance to obtain the emission quantity of the characteristic pollutants. In addition, the spatial distribution of the industrial enterprises and the centralized industrial sewage treatment plants is integrated through a geographic information system and the like, a grid-type drainage database of water pollutants in a certain river basin is formed, and the characteristics of names, water taking sources, drainage amount, drainage directions and the like of the industrial enterprises and the centralized industrial sewage treatment plants are reflected.
In the specific embodiment, the method for creating the wading enterprise database for the industrial pollution source acquires the basic information and pollution source information of all wading enterprises from at least two data sources in a target flow field; integrating and checking the basic information acquired from different data sources to obtain enterprise inventory data; integrating and correcting the pollution source information acquired from different data sources to acquire pollution source data; constructing a database of wading enterprises in the target river basin based on the enterprise inventory data and the pollution source data; the wading enterprise database information at least comprises the conditions of an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period, a receiving water body and the like.
In this way, pollution source census, pollution discharge permission data, environment statistics data and field investigation data are combined, pollution source census data and field investigation data are used as the basis, pollution source census data and field investigation data are supplemented, multi-source data are integrated and checked, relevant information such as basic conditions, water taking conditions, water draining conditions and receiving water conditions of a wading enterprise is finally defined, a wading enterprise database is built, accurate tracing of the wading enterprise is achieved, and a comprehensive and accurate data basis is provided for follow-up determination of pertinence of investigation evaluation objects, effectiveness of a process and accuracy of results. The method realizes the accurate full coverage of related information of the wading enterprises, and provides data support for tracing pollutants of the wading enterprises, thereby improving the tracing accuracy and efficiency.
In addition to the above method, the present invention also provides a wading enterprise database creation apparatus for an industrial pollution source, as shown in fig. 2, the apparatus comprising:
a data obtaining unit 310, configured to obtain, in a target stream domain, basic information and pollution source information of all wading enterprises from at least two data sources;
the data integrating unit 320 is configured to integrate and calibrate the basic information acquired from different data sources to obtain enterprise inventory data; integrating and correcting the pollution source information acquired from different data sources to acquire pollution source data;
a database construction unit 330 for constructing a database of the wading enterprise in the target river basin based on the enterprise inventory data and the pollution source data; the wading enterprise database information at least comprises the conditions of an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period, a receiving water body and the like.
In the specific embodiment, the method for creating the wading enterprise database for the industrial pollution source acquires the basic information and pollution source information of all wading enterprises from at least two data sources in a target flow field; integrating and checking the basic information acquired from different data sources to obtain enterprise inventory data; integrating and correcting the pollution source information acquired from different data sources to acquire pollution source data; constructing a database of wading enterprises in the target river basin based on the enterprise inventory data and the pollution source data; the wading enterprise database information at least comprises the conditions of an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period, a receiving water body and the like.
In this way, pollution source census, pollution discharge permission data, environment statistics data and field investigation data are combined, pollution source census data and field investigation data are used as the basis, pollution source census data and field investigation data are supplemented, multi-source data are integrated and checked, relevant information such as basic conditions, water taking conditions, water draining conditions and receiving water conditions of a wading enterprise is finally defined, a wading enterprise database is built, accurate tracing of the wading enterprise is achieved, and a comprehensive and accurate data basis is provided for follow-up determination of pertinence of investigation evaluation objects, effectiveness of a process and accuracy of results. The method realizes the accurate full coverage of related information of the wading enterprises, and provides data support for tracing pollutants of the wading enterprises, thereby improving the tracing accuracy and efficiency.
In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 3. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and model predictions. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The model predictions of the computer device are used to store static information and dynamic information data. The network interface of the computer device is used for communicating with an external terminal through a network connection. Which computer program, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.
It will be appreciated by those skilled in the art that the structure shown in FIG. 3 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
Corresponding to the above embodiments, the present invention further provides a computer storage medium, which contains one or more program instructions. Wherein the one or more program instructions are for being executed with the method as described above.
The present invention also provides a computer program product comprising a computer program storable on a non-transitory computer readable storage medium, the computer program being capable of performing the above method when being executed by a processor.
In the embodiment of the invention, the processor may be an integrated circuit chip with signal processing capability. The processor may be a general purpose processor, a digital signal processor (Digital Signal Processor, DSP for short), an application specific integrated circuit (Application Specific Integrated Circuit, ASIC for short), a field programmable gate array (Field Programmable Gate Array, FPGA for short), or other programmable logic device, discrete gate or transistor logic device, discrete hardware components.
The disclosed methods, steps, and logic blocks in the embodiments of the present invention may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present invention may be embodied directly in the execution of a hardware decoding processor, or in the execution of a combination of hardware and software modules in a decoding processor. The software modules may be located in a random access memory, flash memory, read only memory, programmable read only memory, or electrically erasable programmable memory, registers, etc. as well known in the art. The processor reads the information in the storage medium and, in combination with its hardware, performs the steps of the above method.
The storage medium may be memory, for example, may be volatile memory or nonvolatile memory, or may include both volatile and nonvolatile memory.
The nonvolatile Memory may be a Read-Only Memory (ROM), a Programmable ROM (PROM), an Erasable PROM (EPROM), an electrically Erasable ROM (Electrically EPROM, EEPROM), or a flash Memory.
The volatile memory may be a random access memory (Random Access Memory, RAM for short) which acts as an external cache. By way of example, and not limitation, many forms of RAM are available, such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (Double Data Rate SDRAM), enhanced SDRAM (ESDRAM), synchronous DRAM (SLDRAM), and direct memory bus RAM (Direct Rambus RAM, DRRAM).
The storage media described in embodiments of the present invention are intended to comprise, without being limited to, these and any other suitable types of memory.
Those skilled in the art will appreciate that in one or more of the examples described above, the functions described in the present invention may be implemented in a combination of hardware and software. When the software is applied, the corresponding functions may be stored in a computer-readable medium or transmitted as one or more instructions or code on the computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.
The foregoing detailed description of the invention has been presented for purposes of illustration and description, and it should be understood that the foregoing is by way of illustration and description only, and is not intended to limit the scope of the invention.

Claims (10)

1. A method of creating a wading enterprise database for an industrial pollution source, the method comprising:
in a target flow field, acquiring basic information and pollution source information of all wading enterprises from at least two data sources;
integrating and checking the basic information acquired from different data sources to obtain enterprise inventory data; integrating and correcting the pollution source information acquired from different data sources to acquire pollution source data;
constructing a database of wading enterprises in the target river basin based on the enterprise data and the pollution source data;
the wading enterprise database information at least comprises an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period and a water receiving body condition.
2. The method for creating a wading enterprise database for industrial pollution sources according to claim 1, wherein the basic information and pollution source information of all wading enterprises are obtained from at least two data sources, and specifically comprises:
acquiring first basic information and first pollution source information of all wading enterprises from a pre-constructed investigation data database;
and acquiring second basic information and second pollution source information of the wading enterprise from a public pollution data database.
3. The method for creating a wading enterprise database for industrial pollution sources according to claim 2, characterized in that the construction of the investigation data database specifically comprises:
and integrating the basic information of the target enterprises and the pollution source information of the target enterprises into an investigation data database based on the enterprises which are mastered by the target river basin and relate to water taking and water draining as target enterprises.
4. The method for creating a wading enterprise database for industrial pollution sources according to claim 2, wherein the obtaining the wading enterprise second basic information and the second pollution source information from the public pollution database specifically comprises:
acquiring basic information and pollution source information of all wading enterprises from a pollution source census database, an environment statistics database and a pollution discharge permission database respectively;
and integrating and checking the basic information and pollution source information of all wading enterprises obtained from the pollution source census database, the environment statistics database and the pollution discharge permission database to obtain second basic information and second pollution source information of the wading enterprises.
5. The method for creating a wading enterprise database for industrial pollution sources according to claim 1, wherein the integrating and collating basic information obtained from different data sources to obtain enterprise inventory data specifically comprises:
combining databases of different sources of enterprises, supplementing pollution source census and site investigation data based on pollution discharge permission and environmental statistics, and integrating and checking basic information in multi-source data;
based on the principle of leak detection and deficiency replacement, taking an enterprise involved in a multi-source database as a target enterprise;
and constructing the target enterprise list and the basic information data list based on the integrated basic information data.
6. The method for creating a wading enterprise database for industrial pollution sources according to claim 1, wherein integrating and collating the pollution source information obtained from different data sources to obtain pollution source data specifically comprises:
pollution source information is combined with databases of different sources of enterprises, pollution source census and site investigation data are supplemented based on pollution discharge permission and environmental statistics data, and integration and check of the pollution source information in multi-source data are carried out;
performing trend analysis according to different enterprise data of the same industry on the same scale, taking the median value and the average value of different enterprise data as references, and selecting 100% of positive and negative deviation data from different source databases as wading data;
and constructing a pollution source data list of the target enterprise based on the integrated wading data.
7. The wading enterprise database creation method for industrial pollution sources of any of claims 1-6, wherein the method further comprises:
in the process of creating a database of wading enterprises in a target river basin, combining the demarcation of a high-sulfur and high-fluorine area of underground water, screening out wading enterprises which relate to the high-sulfur and high-fluorine area in the database, and endowing the wading enterprises with a 'water taking heavy point source' label so as to establish a sulfate and fluoride water taking heavy point source database in the database.
8. A wading enterprise database creation apparatus for an industrial pollution source, the apparatus comprising:
the data acquisition unit is used for acquiring basic information and pollution source information of all wading enterprises from at least two data sources in a target stream domain;
integrating and checking the basic information acquired from different data sources to obtain enterprise inventory data; the data integration unit is used for integrating and checking the pollution source information acquired from different data sources to acquire pollution source data;
a database construction unit, configured to construct a database of the wading enterprise in the target river basin based on the enterprise inventory data and the pollution source data;
the wading enterprise database information at least comprises an enterprise geographic position coordinate, an industry category, water intake, water discharge, a water discharge period and a water receiving body condition.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1-7 when the program is executed.
10. A non-transitory computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method according to any of claims 1-7.
CN202311622295.1A 2023-11-30 Wading enterprise database creation method and device for industrial pollution source Active CN117573654B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311622295.1A CN117573654B (en) 2023-11-30 Wading enterprise database creation method and device for industrial pollution source

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311622295.1A CN117573654B (en) 2023-11-30 Wading enterprise database creation method and device for industrial pollution source

Publications (2)

Publication Number Publication Date
CN117573654A true CN117573654A (en) 2024-02-20
CN117573654B CN117573654B (en) 2024-06-28

Family

ID=

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102142027A (en) * 2011-02-23 2011-08-03 南京智尚丰软件有限公司 Adaptive method for data integration
CN103728943A (en) * 2013-12-25 2014-04-16 力合科技(湖南)股份有限公司 Data integration method and device for data monitoring
CN107967313A (en) * 2017-11-21 2018-04-27 中科宇图科技股份有限公司 A kind of method for merging different industries data based on field data and coordinate general character
CN109376210A (en) * 2018-10-24 2019-02-22 海口金政信息科技有限公司 A kind of intelligence pollution sources dynamic management system and method
CN109947769A (en) * 2018-08-08 2019-06-28 深圳市博安达信息技术股份有限公司 Pollute the management method and Related product of source data
US20230335272A1 (en) * 2022-04-13 2023-10-19 Johnson Controls Tyco IP Holdings LLP Building management system with water and air-based biological sensing

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102142027A (en) * 2011-02-23 2011-08-03 南京智尚丰软件有限公司 Adaptive method for data integration
CN103728943A (en) * 2013-12-25 2014-04-16 力合科技(湖南)股份有限公司 Data integration method and device for data monitoring
CN107967313A (en) * 2017-11-21 2018-04-27 中科宇图科技股份有限公司 A kind of method for merging different industries data based on field data and coordinate general character
CN109947769A (en) * 2018-08-08 2019-06-28 深圳市博安达信息技术股份有限公司 Pollute the management method and Related product of source data
CN109376210A (en) * 2018-10-24 2019-02-22 海口金政信息科技有限公司 A kind of intelligence pollution sources dynamic management system and method
US20230335272A1 (en) * 2022-04-13 2023-10-19 Johnson Controls Tyco IP Holdings LLP Building management system with water and air-based biological sensing

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
郝千婷 等: "我国污染源监管业务流程研究", 中国环境管理, no. 6, 31 December 2016 (2016-12-31) *

Similar Documents

Publication Publication Date Title
Oelsner et al. Water-quality trends in the nation’s rivers and streams, 1972–2012—Data preparation, statistical methods, and trend results
Vörösmarty et al. Anthropogenic disturbance of the terrestrial water cycle
Rothenberger et al. Long-term effects of changing land use practices on surface water quality in a coastal river and lagoonal estuary
Kalogeropoulos et al. Modelling the impacts of climate change on surface runoff in small Mediterranean catchments: empirical evidence from G reece
Maupin et al. Nutrient Loadings to Streams of the Continental United States from Municipal and Industrial Effluent 1
Jiang et al. Assessing the severe eutrophication status and spatial trend in the coastal waters of Zhejiang province (China)
Törnqvist et al. Mechanisms of basin-scale nitrogen load reductions under intensified irrigated agriculture
Jiang et al. Influence factor analysis of soil heavy metal Cd based on the GeoDetector
Liang et al. A pollutant load hierarchical allocation method integrated in an environmental capacity management system for Zhushan Bay, Taihu Lake
Sarkar et al. Predicting regional-scale elevated groundwater nitrate contamination risk using machine learning on natural and human-induced factors
Röman et al. Catchment characteristics predicting nitrogen and phosphorus losses in F inland
Wang et al. A Fusion Water Quality Soft‐Sensing Method Based on WASP Model and Its Application in Water Eutrophication Evaluation
Bi et al. The impact of land use and socio-economic factors on ammonia nitrogen pollution in Weihe River watershed, China
Skinner et al. Point-source nutrient loads to streams of the conterminous United States, 2012
Madhavan et al. Assessment of groundwater vulnerability using water quality index and solute transport model in Poiney sub-basin of south India
Ansorge et al. UEEJ
Ren et al. Water quality assessment and pollution source apportionment using multivariate statistical and PMF receptor modeling techniques in a sub-watershed of the upper Yangtze River, Southwest China
CN117573654B (en) Wading enterprise database creation method and device for industrial pollution source
Duc et al. Hydrochemical indices as a proxy for assessing land-use impacts on water resources: a sustainable management perspective and case study of Can Tho City, Vietnam
Lindgren et al. Nitrogen source apportionment modeling and the effect of land-use class related runoff contributions
Bojanowski et al. Estimation of nutrient loads with the use of mass-balance and modelling approaches on the Wełna River catchment example (central Poland)
Kim et al. Operator decision support system for integrated wastewater management including wastewater treatment plants and receiving water bodies
CN117573654A (en) Wading enterprise database creation method and device for industrial pollution source
Sakizadeh et al. Environmental impact of Karkheh Dam in the southern part of Iran on groundwater quality by intervention and trend analysis
Liu et al. Research on nonpoint source pollution assessment method in data sparse regions: a case study of Xichong River Basin, China

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant