KR101217642B1 - Pollution load estimation system - Google Patents

Abstract

PURPOSE: A pollution loading amount estimation system is provided to estimate more accurate pollution loading amount by connecting pollution source data and apply a modification of a pollution source corresponding to a development plan and a reduction plan through work management. CONSTITUTION: A pollution source database(110) in an online national pollution source examination system includes pollution estimation input data. A pollution loading amount database(120) estimates a pollution loading amount. A system driving unit(200) estimates the pollution loading amount by using data included in a database group(100). The system driving unit intentionally manages the total pollution amount. [Reference numerals] (110) Nationwide pollution source survey online system database; (120) Pollution loading amount database; (130) Water environment information system database; (210) Data preprocessing module; (220) Loading amount estimation module; (230) Loading amount search module; (240) System management module; (300) Client terminal

Description

Pollution Load Estimation System

The present invention relates to a pollution load calculation system, and more specifically, a pollution load calculation system in which pre-stored relevant data is input so as not to be applied differently according to a calculator, and calculation of the pollution load is possible through a collective calculation algorithm. It is about.

As is well known, there has been a recent increase in environmental pollution around the world, and pollutant sources are managed at the national level in order to improve the residential environment, ultimately the river or sea environment.

In other words, the management of appropriate pollutants not only prevents environmental pollution, but also manages organic matter, and thus, ultimately, management of conservation and maintenance of ecosystems.

Therefore, total pollution management refers to the annual allocation and management of pollutant emissions to achieve target water quality. Pollutant sources are grouped into categories such as living, livestock, industrial, land, aquaculture, and landfill. . To establish a total pollution management plan based on this pollutant source, the target water quality is set, and a development plan and a reduction plan are established to comply with the assigned load of pollutants.

At first glance, it seems that the management of each pollutant source, that is, the amount of pollution, seems to be managed in great detail, and that the total amount of pollution seems to be properly managed from the point of view of rivers and lands, but there is actually a guideline for establishing a plan for managing the amount of pollution. However, since the criteria are applied differently according to the estimator, it is difficult to derive the collective load calculation details.

In addition, the pollutant was investigated and the load was calculated through the National Pollution Research Online System, but there was a difficulty in comparing the calculated documents in establishing the development plan and the reduction plan because the calculation details were not managed by the DB.

Therefore, there is a need for a systemic approach to manage pollutant sources and load calculations by DB, to manage them by year and pollutant source, and to apply the collective load calculation formula.

The present invention has been made in view of the above-described circumstances of the prior art, and inputs pre-stored relevant data so that the criteria are not applied differently according to the estimator and enables the calculation of the pollution load through a batch calculation algorithm, but the pollution load The calculation automatically calculates the generation load to the discharge load for each pollutant based on the total pollution management guidelines, and can modify the unit and coefficient for each statutory building, so that it is more accurate and efficient than the load calculation method that is applied collectively as common details. Its purpose is to provide a pollution loading estimation system that allows for estimation.

In order to achieve the above object, according to a preferred embodiment of the present invention, the instrument is condensed, and the data as an input element of the pollution load calculation, the pollution source database 110 of the national pollution investigation online system; A water environment information system database 130 including weather data; A database group consisting of a pollution load database (120) for calculating a pollution load in association with the databases (110, 130); A system driving unit (200) for calculating the pollution load according to the pollution total amount management plan established in the database group; At least one client connected to the system driving unit 200 and having input means for transmitting a request for retrieval, inquiry, modification and recalculation of load information and output means for outputting an output result transmitted from the system 200 A terminal 300; Attempts are made by modifying and applying the raw units and coefficients used in calculating the pollutant load in the system drive unit 200, and each city-gun-gu and Eup-dong-dong, respectively, and the pollutant load calculated by the system drive unit 200. Information is stored in the pollution load database 120 is provided with a pollution load estimation system, characterized in that configured to predict future fluctuations of source variation.

Pollution load calculation system according to the present invention can calculate more accurate pollution load by linking the source data, and can be calculated and flexible load by registering and modifying the source in the Excel file with the desired area and changed contents, Through work management, the load can be calculated by applying the correction of pollution sources according to the development plan and the reduction plan, and the user can grasp the current progress step and the next progress at a glance by developing the flow chart type system. This can reduce duplication of errors and inconvenience in refinancing. All load calculation results can be downloaded to Excel, which can be used for various purposes, and the unit and coefficient can be individually set for each legal building. It is easy to use as basic data for establishing the total pollution management plan and evaluating the implementation by implementing the user's convenience and the accuracy of the load calculation first, and analyzing the characteristics and efficient management of the pollutant by region by constructing the source and the result as a database. You can do

1 is a block diagram showing the configuration of a pollution load calculation system according to an embodiment of the present invention;
2 is a configuration diagram of a table linked in the national pollution source investigation online system database of FIG.
FIG. 3 is a configuration diagram of a table in which a result calculated by a pollution load database in the load calculation system of FIG. 1 is stored;
4 is a configuration diagram of a table linked to the load calculation system in the water environment information system database of FIG.
5 is a block diagram of a data preprocessing module according to an embodiment of the present invention;
6 is a configuration diagram of a system management module according to an embodiment of the present invention;
7 is a configuration diagram of a load calculation module according to an embodiment of the present invention;
8 is a configuration diagram of a load detection module according to an embodiment of the present invention;
Figure 9 is a schematic diagram of the calculation of life discharge load in accordance with an embodiment of the present invention,
10 is a schematic diagram of the landfill discharge load calculation according to an embodiment of the present invention,
11 is a schematic diagram for calculating the livestock discharge load according to an embodiment of the present invention,
12 is a schematic view of calculating the industrial discharge load according to an embodiment of the present invention,
Figure 13 is a schematic diagram of the land-based discharge load calculation according to an embodiment of the present invention,
14 is a schematic diagram of aquaculture system discharge load calculation according to an embodiment of the present invention,
15 is a system login screen according to an embodiment of the present invention;
16 is a menu tap of a load calculation system according to an embodiment of the present invention;
17 is an initial screen of a load calculation system according to an embodiment of the present invention;
FIG. 18 is a detailed list screen when the “Data preprocessing” menu is selected among the menu tabs of FIG. 17;
19 is a screen in the case of selecting the "continuous map process" menu in the detailed list of FIG.
20 is a screen in the case of selecting the "rainfall data connection" menu of the detailed list of FIG.
21 is a screen in the case of selecting the "upload national pollutant data upload" menu of the detailed list of FIG.
22 is a screen when the "Excel upload" button of FIG. 21 is selected,
23 is a screen when the uploaded environmental basic facility code of FIG. 22 is different from the system;
FIG. 24 is a detailed list screen when a “load calculation” menu is selected among menu tabs of FIG. 17;
FIG. 25 is a screen when a “Job management” menu is selected from the detailed list of FIG. 24;
FIG. 26 is a screen in the case of selecting the “circle unit and coefficient setting” button of FIG. 25;
FIG. 27 is a screen when the “living system” menu is selected from the detailed list of FIG. 24;
28 is a screen in the case of selecting the "Livestock meter" menu from the detailed list of FIG.
FIG. 29 is a screen when the “industry” menu is selected from the detailed list of FIG. 24;
30 is a screen when the “land meter” menu is selected from the detailed list of FIG. 24;
FIG. 31 is a screen when a “burying system” menu is selected from the detailed list of FIG. 24; FIG.
32 is a screen in the case of selecting the "Form system" menu of the detailed list of FIG.
33 is a screen when the “environmental basic facilities analysis” menu is selected from the detailed list of FIG. 24;
34 is a screen in the case of selecting the "rainfall data analysis" menu of the detailed list of FIG.
FIG. 35 is a detailed list screen when a “load search” menu is selected among menu tabs of FIG. 17;
36 is a screen in the case of selecting the "search management" menu from the detailed list of FIG.
FIG. 37 is a screen when the “Load search” menu is selected from the detailed list of FIG. 35; FIG.
38 is a screen when the “search by basin” menu is selected from the detailed list of FIG. 35;
39 is a screen when the "chart" button of FIG. 38 is selected,
40 is a screen when the "area occupancy search" menu is selected from the detailed list of FIG. 35;
FIG. 41 is a screen when a menu of “Excel batch output” is selected from the detailed list of FIG. 35;
FIG. 42 is a detailed list screen when a “system management” menu is selected among menu tabs of FIG. 17;
43 is a screen when the user management menu is selected from the detailed list of FIG. 42;
FIG. 44 is a screen when a menu of “connection log management” is selected from the detailed list of FIG. 42; FIG.
45 is a screen in the case of selecting the "code management" menu of the detailed list of FIG.
46 is a screen in the case of selecting "Save Excel" in all screens of the present invention;
47 is a screen output example screen of the calculation result when the button is clicked in all the load calculation calculation flowcharts of the present invention.

EMBODIMENT OF THE INVENTION Hereinafter, this invention is demonstrated in detail with reference to drawings.

1 is a configuration diagram of a pollution load calculation system according to an embodiment of the present invention, Figures 2 to 3 and 4 is an exemplary configuration diagram of the database of FIG.

Referring to this, the characteristics of the pollution load estimation system according to an embodiment of the present invention is to store the pollutant and weather station data surveyed from the national pollutant survey online system in the DB, to calculate the area occupancy using the continuous map, To calculate the load.

At this time, the load calculation is automatically calculated from the generated load to the discharge load for each pollutant based on the total pollution management guideline, and the unit and coefficient can be modified for each statutory dong so that it is more accurate than the load calculation method that is applied collectively as common details. Can be calculated efficiently.

In addition, it is possible to output the calculated data in Excel and schematics in the implementation evaluation and the establishment of the basic plan, which can be used for various reports.It is calculated based on different criteria for each calculator, and the verification of the calculation details is unclear. Otherwise, it is easy to use as basic data.

In more detail, the pollution load calculation system according to an embodiment of the present invention is a pollution load calculation system that calculates the pollution load using the source data of a pre-built national pollution survey online system.

As shown in FIG. 1, the pollution load estimation system according to an embodiment of the present invention includes a database group 100 of a load calculation system; A load calculation system drive unit 200 is provided.

The database group 100 of the load calculation system is a national pollution source survey online of environmental basic facilities such as living, animal husbandry, industrial, land, landfill, aquaculture, sewage treatment facilities, sewage treatment facilities, etc. System database 110; A pollution load database 120 in which a calculation result of the pollution load is input in association with the pollution source database 110; It consists of a database 130 of water environment information system including weather station data such as daily rainfall data.

The load calculation system driving unit 200 is connected to the database group 100 consisting of the source database 110, the pollution load database 120, and the water environment information system database 130 to determine the pollution load according to the pollution total management plan. It is a means for calculation, and it mentions later in detail.

In addition, the pollution load calculation system according to an embodiment of the present invention is connected to the system drive unit 200 and the input means for transmitting a request for searching, inquiry, correction and recalculation of load information and the system drive unit 200 At least one client terminal 300 having an output means for outputting an output result transmitted from the.

In more detail, the national pollution source online system database 110 of the system; It is divided into the living data, pollutant, industrial, land, landfill, aquaculture, environmental basic facilities, and the water environment information system database 130; Rainfall station information, daily precipitation amount, and measurement station information 131; In the load calculation module 220 based on; Of the database 100; The information will be used to estimate the load according to the guidelines outlined in the Water Quality Management Guidelines.

The calculated results are classified into generation load, direct transfer, individual discharge, conduit transport, conduit leakage, conduit overflow amount, final discharge, etc., which are the data specified in the total water pollution management guidelines, to the pollution load database 120; Save it.

Preferably, the load calculation module 220; The onboard mathematical algorithm is based on <Equation 1> to <Equation 14>.

Equation 1 Life Sewage Flow

 Home population manure outflow rate = home population x home population

 Household Drainage Flow Rate = Mixed Wastewater Sewage Conversion Rate × (Household Population Flow Rate-Domestic Population Manure Flow Rate)

 Household population sewage generation flow rate = Home population manure generation flow rate + Family population mixed wastewater generation flow rate

 Manure generation flow rate of working population = Use flow rate of business population ×

 Flow rate of mixed wastewater from working population = Conversion rate of wastewater from mixed wastewater × (Flow of working population-flow rate of manure from working population)

 Sewage generation flow of business population = Manure generation flow of business population + Flow rate of mixed wastewater from business population

 Domestic sewage generation flow rate = household population sewage generation flow rate + operating population sewage generation flow rate

Equation 2 Life Load

 Domestic Population Generation Load = Home Population × Domestic Population Generation Load Unit

 Home population manure generating load = Manure generating load ratio × Home population generating load

 Household Population Drainage Load = (1- Manure Generation Load Ratio) × Home Population Generation Load

 Operating population generation load = Operating population sewage generation volume × Operating population sewage generation concentration

 Operating population manure generation load = manure generation load ratio × operating population generation load

 Operating population miscellaneous drainage load = (1- manure generating load ratio) × operating population generating load

 Life load generated = Household population generated load + Operating population generated load

<Table 1> Domestic Family Population Generation Load Unit and Manure Generation Load Ratio

Equation 3 Livestock Generation Load

 Livestock wastewater generation load = ∑ (Household headwater by breeding × Livestock wastewater generation load by unit)

 Livestock solids generation load = ∑ (Number of breeding heads by animal type × Livestock solids generation load unit by animal type)

 Livestock production load = livestock wastewater generation load + livestock solids generation load

<Table 2> Livestock Production Divisions and Their Units

Equation 4: Industrial Load

 Industry Generated Load = ∑ (Wastewater Flow Rate by Industry × Wastewater Production Concentration)

<Table 3> Industrial Manure Generation Load Unit

Equation 5 Landfill Load

 Calculated on a monthly basis by multiplying the leachate generation flow of waste landfill facilities by the generation concentration

Landfill generation load = Leachate flow rate × Leachate concentration

Equation 6 Land-based Loads

 Land-based generated load = 0.1 + 0.9 × (annual days × effective monthly rainfall) / monthly

 Monthly Effective Rainfall Ratio = (Monthly Rainfall Rainfall over 10mm / day) / (Monthly Rainfall Rainfall over 10mm / day)

<Table 4> Annual average generated load by land category

<Formula 7> aquaculture system load

 When feed dosage data are obtained

  -Farming system generated load = outbreak load ratio × monthly feed administration / monthly days

 If feed dosing data are not available

-Aquaculture system load = facility area × load unit

Equation 8

 Quantity transferred directly to the environmental foundation without going through the drainage system

 Direct transfer cost = Source direct transfer amount / Source direct transfer target amount

 Source direct transfer amount = Direct transfer cost × Source direct transfer target amount

Direct transfer by pollutant source = Direct transfer amount by pollutant source

<Formula 9> Individual cut amount

 Reduction amount by self-pollution reduction facility of source that is not environmental foundation

 Individual cuts by source = Individual cuts × Individual cuts by source

Individual reduction amount by pollution source = Individual emission reduction amount by pollution source

Equation 10

 Amounts flowed from the wastewater sewage treatment area to the wastewater drainage system connected to the relevant environmental foundation

 Source pipe inflow = Source generation-Individual source reduction-Source direct transfer

Contaminant inflow of pollutant source = Conduit inflow of discharge source by pollutant source

Equation 11

 The amount released through leaks, overflows, and exclusions during conduit transport

 Conduit discharge rate = Total conduit discharge rate / Conduit inflow rate by pollution source

 Source pipe discharge rate = Pipe discharge rate × Source pipe discharge flow rate

Contamination Emissions by Pollution Source = Source Emissions by Pollution Source

Equation 12

 Volume of direct discharge into the basin from environmental infrastructure

 Discharge Rate by Pollutant Source = Total Discharge Rate by Source / Total Environment Discharge

Emissions by Pollution Sources = Emission Costs by Pollution Sources × Total discharges from basic environmental facilities

Equation 13: Direct Purification

 Amounts removed by direct purification, such as artificial wetland treatment for environmentally-based facilities effluent or land runoff, pests for river water, and gravel contact oxidation

 Direct purification by facility = Direct purification inflow by facility-Direct purification discharge by facility

 Direct Purification Inflow Ratio = Direct Purification Inflow by Facility by Pollution Source × Direct Purification by Facility

Direct purification by pollution source = Direct purification by facility by pollution source

Equation 14

 The amount of pollutants discharged to public waters after treatment is reduced or not directly

 Source Emissions = By Source [Individual Emissions + Conduit Emissions + Discharges-Direct Purification]

 Individual discharge amount = By discharge source [Generation amount-Individual reduction amount-Direct transfer amount-Conduit inflow amount]

 Emissions by Pollution Source = Emission Sources by Pollution Source

Equations 1 to 14 are algorithms mounted on the load calculation module 220 and operated when the pollutant load calculation is performed. Since the system of the present invention provides the load calculation module 220 consistently, a corresponding program is provided to the laboratory. In case of use in public offices, formalized and consistent calculation is performed according to the person in charge to prevent the change of load factor or the factors considered for the calculation.

Clear and consistent pollutant load calculation results should be stored in a database for future use in a variety of applications, and the results will be calculated equally even if other personnel assign the same region elements to the algorithm at the same time. Can be.

In addition, the pollution load calculation system according to an embodiment of the present invention is provided with a data preprocessing module 210, the data preprocessing module 210 is a continuous map processing module 211, rainfall data connection module 212, nationwide Consists of pollutant source data linking module 213, the module performs a process for processing the data required for load calculation through the modules.

Continuous map processing module 211 is; According to the technical guidelines, a list of standard watershed-administrative zones should be prepared so that pollutants surveyed by administrative unit can be used to estimate loads by standard watershed, where one administrative area is included in more than one standard watershed. It is mandated to be included in the standard watershed by proportion.

Therefore, the load calculation system according to an embodiment of the present invention divides the standard basin-dong boundary and calculates the area ratio after the division to the area before the division, and uses the continuous land map to calculate the share of share for each standard basin. In this case, when the divided area is less than 3% of the area before the division, the load calculation module 220 is set in advance to calculate that the divided area is included in a large watershed, assuming an error included in the geographic information itself.

Rainfall data connection module 212 is; In the water environment information system database 130 which is the database; Rainfall station information, daily precipitation amount, and measurement station information 131; National Pollution Research Online System Database (110); Set up observatory information and precipitation by district in association with district information.

Since the National Pollution Research Online System is located on the outside network, it cannot be connected on-line, so the pollutant data such as living, animal husbandry, industrial, land, landfill, aquaculture, and environmental foundations can be exported to Excel. Download the national pollution source data linkage module (213) of the load calculation system; Input pollutant data into the system.

The work management unit 221 is a module for managing calculations for each year and water system by accessing the present invention, and can duplicate, delete, and modify calculation details, which is a basic plan (S0) reflecting a development plan and a reduction plan. It provides a function that can be viewed in comparison with.

In addition, the work management unit 221; Users can change the units and coefficients by court building and water system so that they can calculate more accurate loads according to the characteristics of each region, and save the changes and apply them through the batch calculation button. There is an advantage that can be calculated.

The present invention can calculate the load amount for each pollutant, life load generation calculation unit 222; Industrial load calculation unit 223; Animal husbandry generation load calculation unit 224; Land-based generating load calculation unit 225; Landfill generation load calculation unit 226; Aquaculture system load calculation unit 227; Environmental infrastructure analysis unit 228; It is composed of rainfall data analysis unit (229), the user can easily grasp the current progress step, and output the results calculated by each pollutant source can be used as the basic data of the total pollution control system.

The load amount search module 230 is configured as follows.

That is, the search management processing unit 231; It is divided into job name, job description, calculation year, watershed classification, and registration date. The job management unit 221 shows a job list that is checked in the public and selects a job to be searched and then loads search unit 232. ; Watershed search unit 233; Area occupancy searching unit 234; Excel batch output unit 235; performs the desired operation.

The load searching unit 232; Users can sort and search by various methods such as water system, pollutant source, calculation result, and legal dong. Search items can be selected by pollutant such as living, animal husbandry, industrial, land, landfill, aquaculture, environmental foundation, rainfall data, etc.If you select the load calculation result of each pollutant and search, the result is calculated by statutory building. You can check it.

The watershed search unit 233 is; Provide inquiries and charts by water quality impact area for pollutant sources, emissions, and emissions. The search method may be checked in the same manner as the load search unit 232 by first selecting a condition to search and filtering the searched result value to a desired region.

The load amount search module 230; Data preprocessing 210; The module is searched on the basis of the calculated area occupancy and calculated load in the continuous land map processing 211, and provides a chart function to be used for various purposes.

Area occupancy search unit 234; The area occupancy rate is calculated based on the standard occupancy value input by the user for each statutory building and category. The calculated result is returned to the pollution load database 120; It is saved, and you can extract the result value you want through filtering and save it in Excel.

Excel batch output unit 235 is; All the calculated loads and the data to be output can be selected and output to Excel, and all the loads calculated from the pollution sources for each pollutant such as living, animal husbandry, industrial, land, landfill, aquaculture, environmental foundation, and rainfall data The data are shown in a list, and the desired data can be output in Excel by single or multiple selection from the list for user convenience.

System management unit 240; A user manager 241; Log management unit 242; Code management unit 243; is composed of a detailed module, the user management unit 241; In order to use the present invention, a registered user performs a function such as searching / registering / deleting and performs a password initialization.

Log management unit 242; It is classified into connection status by period and connection status by month, so that users can log management to this system.

Code management unit 243; The code name, code delimiter, and code value used in the load calculation system of the present invention can be checked, and the retrieved details can also be output and managed in Excel. The code management unit 243 is required when performing a task of matching the code used in the system when registering the pollutant and calculating the load.

On the other hand, the present invention is a method of calculating the pollutant load by connecting pollutant data from the nationwide pollutant source survey online system to receive the data required by off-line rather than the method of extracting the data by accessing the DB on-line and receiving it in Excel The pollutant source data 111 is generated by uploading the load calculation system of the present invention. The reason why it is not possible to directly connect and import data is that it is impossible to link data because the National Pollution Research Online System exists in the external network.

In addition, by linking the observation station 131 and the observation data 131 by statutory dong in the database 130 of the water environment information system, the total amount of pollution from <Formula 1> to <Formula 14> through the system drive unit 200 of the present invention After calculating the load according to the guideline method, the estimated load, direct transfer, individual discharge, conduit transport, conduit leakage, conduit overflow, final discharge, etc. Save to

The calculated result may be a client terminal 300 using the system to search / modify / delete the desired result in the database group 100 of the load calculation system through the system drive unit 200.

5, 6, 7, and 8 are menu structure diagrams of a main screen of the present invention system, and a method of selecting a submenu for each menu and proceeding.

9, 10, 11, 12, 13, and 14 are schematic diagrams illustrating a method for estimating the discharge load used in the system of the present invention, wherein the discharge load is a treatment path for all pollutants based on the generated load. It is calculated by considering the reduction efficiency by treatment facility or method in consideration of The treatment efficiency in each treatment facility and discharge route is measured by the discharge of public treatment facilities such as sewage treatment facilities, manure treatment facilities, livestock wastewater treatment facilities, and wastewater treatment facilities. The treatment efficiency of individual treatment facilities such as discharge facilities shall be based on standard treatment rates, effluent water quality standards, and discharge allowance standards.

Life discharge loads by the population include municipal and non-civilized areas, household and business populations, sewage treatment and non-sewerage treatment areas, sewage and sewerage systems, flush and collection systems, sewage treatment facilities and sewage treatment. In consideration of the classification of the source and the discharge path of the facility, untreated, etc. as shown in FIG. Therefore, the emission load by the population of the target area is the sum of each emission load separately calculated.

Figure 11 is the discharge load by livestock, and the calculation of livestock discharge load is calculated according to each stage in consideration of livestock breeding, treatment method, legal regulation, livestock and wastewater treatment method. Therefore, the sum of the values calculated for each stage is the livestock discharge load.

The discharge load due to industrial wastewater (Fig. 12) is calculated by dividing the discharge directly from the individual discharge facility and the discharge through the environmental basic facility based on the performance of the wastewater treatment facility of the individual discharge facility. However, the amount of incoming wastewater that is consigned through off-site treatment facilities and in connection with sewage terminal treatment facilities is excluded from the calculation of discharge load. The discharge load of the target material by landfill leachate is calculated separately and included in the total emissions.

The discharge loads from farms are calculated by dividing the discharge route directly into the discharge route without the treatment facility and the discharge through the treatment facility. 14 is a schematic diagram for estimating aquaculture system discharge load.

Since the discharge load by nonpoint source is set based on the actual discharge for rainfall more than 10mm per year due to land use, the nonpoint source emission factor that is set in consideration of the rainfall frequency of 10mm or more during the low period, which is the reference flow rate, is generated. Calculate by multiplying by. 13 relates to the calculation of the discharge load of the non-point source land system.

The discharge load by the landfill is calculated monthly by multiplying the generation concentration by the leachate generation flow rate of the landfill facility (Fig. 10).

FIG. 15 is a system login screen according to an embodiment of the present invention. When the "Change Server Information" button is clicked, an Oracle ID and port number information can be known as a server address for connecting to a DB and a DBMS, and can be changed. "Application" button to enter the information to distinguish the user, such as user ID, password, name, user department and phone number, e-mail address to perform the load calculation and search, etc. to access the present invention and "Apply" You will get permission to do so.

Through the user registration, the administrator can perform the user approval and information management of the user added in the system management 240, and perform initialization such as the log management unit 241 and the password loss.

The present invention is composed of the main screen as shown in Figure 17, the menu used in the system is displayed on the top and the detailed menu can be confirmed in the drop-down method. Details of each menu are classified as shown in FIG. 16.

FIG. 18 illustrates submenus when the data preprocessing module 210 is selected from the menu tabs of FIG. 17. FIG. 19 is a screen when the continuous map processing unit 211 of FIG. 18 is selected. In order to select sub-regions and continuous cadastral maps through the “Find” button, select the cadastral map to be used from the cadastral maps in the folder, and press the “Execute” button. It is used to calculate the area occupancy in.

FIG. 20 is a screen when the rainfall data linkage processing unit 212 is selected from the detailed list of FIG. 18. After selecting a year to link, click the “Rainage data linkage” button. The data of the year is extracted from the table of the station information, the daily precipitation amount, and the measurement station information 131 and processed into a form suitable for use in the system, and then stored in the pollution load database 120. The stored data is output to the grid of FIG. 20 and the user can check the currently retrieved and calculated data.

In addition, if there is already data calculated by the user, the data calculated by Excel may be directly stored in the DB 120 through the "Read Excel" button.

FIG. 21 is a screen when the national pollution source data link processing unit 213 is selected from the detailed list of FIG. 18. The basic data by year, water system, and source of pollution are currently registered as basic data in the pollution load database 120. Displayed on the screen, “O” is the registered data and “X” is the missing source data, so you can check the type and data of the source that is currently registered in the system. After selecting the source file of the pollutant excel file to input with the “Excel upload” button, the content of the pollutant excel file currently being uploaded is automatically changed to a code that can be used in the system as shown in FIG. Implement the red box to mark the missing part so that the user can see it. The code used in this format is output in the form of ComboBox so that the user can change the contents of the data. If the name of the facility or facility code is different, the amount of data is large and there is a limit to the combo box format. You can modify the data by searching through the screen.

Clicking the “Save” button with the changed contents saves the data on the current grid in the pollution load database 120 and changes the “X” mark in FIG. 21 to “O” to show the user that the basic data for load calculation has been input. .

FIG. 24 illustrates submenus when the load calculation module 220 is selected from the menu tabs of FIG. 17, and FIG. 25 illustrates a screen when the job manager 221 is selected from the detailed list of FIG. 24. The user using the present invention calculates the load in units of work, and can be individually changed by statutory dong such as units in units and coefficients as shown in FIG. 26 by using the “set unit and coefficient setting” button for each pollutant for each operation. The work management screen (Fig. 25) is divided into a job registration number, a job name, a job description to briefly write down the current progress, a calculation year for calculating load, a water system classification currently in progress, and a registration date for registering a job. If you want to specify the job as the final version, if you check whether the public load load search module 232, watershed search unit 233, area occupancy search unit 234, Excel for the work list checked in the load search module 230 The function of the batch output unit 235 can be used.

In addition, by using the “Load calculation” button, according to the total pollution control guideline such as generation load, direct transfer amount, individual discharge amount, conduit transfer amount, conduit leakage amount, conduit overflow amount, final discharge amount, etc. All values can be calculated automatically in a sequence of steps.

The "Replication Work" button is used to estimate the load by various methods such as scenario analysis in the work list, and can be used by copying all the calculation details, pollutant sources, and rainfall data corresponding to the selected work list.

Through the “Add / Delete / Save / Cancel” function, the selected job name and job description can be changed and deleted.

"OK" button is a list of the selected work after the life load calculation unit 222; Industrial load calculation unit 223; Animal husbandry generation load calculation unit 224; Land-based generating load calculation unit 225; Landfill generation load calculation unit 226; Aquaculture system load calculation unit 227; Environmental infrastructure analysis unit 228; Rainfall data analysis unit 229; stores information such as work number, calculation year, water system so as to perform the function.

FIG. 26 is a screen for changing units by count, city, county, eupmun-dong, and li. First, when a pollutant to be changed is selected from among pollutant groups, a list of changeable units and counts of the pollutant is shown at the top in the form of a Radio Button. Select the region to change through the region classification. If the user clicks on the area to be changed among the statutory dongs output by outputting the contents of the selected area on the grid, the detailed area information, the unit unit, and the coefficient information corresponding to the selected statutory dong are output on the grid screen so that the user can change it.

The number of significant digits can be changed to show as many numbers as you want on the current grid, and up to 10 decimal places can be output.

If you click the “Save” button after checking the “Apply Water System” checkbox, the changed units and coefficients will be changed to the current water system.

Every screen has a “excel save” button, and the contents displayed on the current grid screen are output to Excel so that users can check them as documents and share information.

27 is a flow chart for calculating the living generation load calculation unit 222, respectively, Figure 28 is a livestock generation load calculation unit 224; 29 shows an industrial load generation calculation unit 223; 30 shows land generation load calculation unit 225; 31 shows the landfill generation load calculation unit 226; 32 shows aquaculture system generation load calculation unit 227; 33 is an environment basic facility analysis unit 228; 34 is a flow chart screen for each pollution source, which is a user interface for calculating the load of the rainfall data analysis unit 229.

The load calculation flowchart is implemented to make it easy for the user to check the current step by changing the color of the button for each uncalculated, next calculation step, and completion of calculation. The uncalculated button is a case where data of previous steps for performing the current step is not generated. If you click the uncalculated button, it automatically checks the necessary steps beforehand, calculates all the steps up to the clicked steps in order, calculates the load of the selected step, outputs it on the screen, and checks the next progress to change the button colors of the flowchart. do.

The button of the next calculation step is a case where all the data that needs to be generated before the current step is calculated. Based on the previous data, the load is calculated according to the instructions and the calculated result is displayed on the grid screen. The color of the button in the flow chart for calculating the load is changed to the calculated color, and the button color of the next step is changed so that the user can check the next step to proceed after checking the step to proceed after the corresponding step.

In the button of the calculation completion, all the data necessary for the load calculation are calculated in the step that the user wants to check, and the process is completed up to the data of the current step. In this step, the pollutant load database 120 without the calculation process; outputs the content of the pollutant and the calculation step searched based on the work list information on the screen.

The result calculated according to the load calculation flowchart is stored in the pollution load database 120; based on the primary key such as the work list, the calculation year, the water system, the source of contamination, the calculated load information, and the stored content is the load calculation module 220. ; It is used in the load search module 230;

35 is a load searching module 230 of the menu tab of FIG. 36 is a detailed list screen when a menu is selected, and FIG. 36 is a screen when the search management processor 231 is selected in FIG. As described above, the load search module 230 screen displays a list of jobs checked by the job management unit 221, and includes a job name, a job description, a calculation year, a water classification, and a registration date. Selecting a desired job and clicking the “OK” button, the load retrieval unit 232; Watershed search unit 233; Area occupancy searching unit 234; Excel batch output unit 235; You can take advantage of the features.

37 is a load searching unit 232 of the detailed list of FIG. When the menu is selected, the load calculation module 220 is configured in the same format. The items to be searched include the year of investigation, the searchable water system, the type of pollutant, and the result list calculated for each pollutant. 120); and retrieved in ComboBox format.

After determining the search item and clicking the “search” button, the information is displayed on the grid screen as the information of the pollution load database 120. The load retrieval unit 232 can not modify or delete the contents, but can only query. The searched results can be filtered by desired city, city, district, eupmundong, and li, and the result displayed on the screen can be checked by the desired decimal point by adjusting the effective digits in the same manner as the load calculation module 220. If you click the “Excel Save” button, you can save the current grid screen as an Excel file and keep it as a document and share the information with others.

38 is a watershed search unit 233 of the detailed list of FIG. It is a screen when a menu is selected, and is comprised in the same form as FIG. The difference from the load retrieval unit 232; can be filtered by a large area, a middle area, a small area, and can calculate the load by the corresponding area through this function, continuous map processing unit 211; The area share of statutory dongs is calculated for each watershed based on the continuous cadastral map registered in the module.

The watershed search unit 233 provides a chart function by grouping the calculated load result by the watershed. In FIG. 38, when the "chart" button is clicked, the screen moves to the screen of FIG. 39, and a bar graph format chart is generated based on the contents currently output on the grid screen of FIG. The created chart can be saved as a picture file through the "Save Chart" button, which can be used for various reports and analysis data.

If all the screens provide the “Excel Save” function similarly to the load calculation module 220, the content of the currently searched grid screen can be saved as an Excel file through this function.

40 is an area occupancy search unit 234 of the detailed list of FIG. When the menu is selected, as shown in FIG. 38, the area occupancy rate of the statutory building is shown for each region as shown in FIG. 38. However, the difference can be calculated by the user directly inputting a reference value for calculating the occupancy rate. The basic occupancy value of the present invention is 3%, and when the corresponding legal dong is included in the sub-area 3% or less, an area of 3% or less is included in the largest area to which the legal dong belongs, and the area occupancy search unit 234 ), If the occupancy value is different, the result calculated by the occupancy value is output on the grid screen. Like other screens, you can save all the searched contents to Excel through the “Excel Save” button.

41 is an Excel batch output unit 235 of the detailed list of FIG. This is the screen when the menu is selected. Load calculation module 220; there is a separate output method by clicking the button in each flow chart through the "Excel Save" button, but utilizing the function of the Excel batch output unit 235, the job selected by the task management unit 221; Whenever the pollutant is checked in the pollutant group of FIG. 41, all the calculated results from the list are added to the table list on the right. In the added table list, the user can individually or multiplely select the desired calculation result. Checking selects all calculation results in the current table list. The list of selected tables to be exported to Excel can be converted to Excel using the “Excel Output” button.

42 is a system management module 240 of the menu tab of FIG. 43 is a detailed list screen when a menu is selected, and FIG. 43 shows a user manager 241 in the detailed list of FIG. This is the screen when the menu is selected. In the user management unit 241, a list of users using the present invention is outputted by ID, user name, department, phone number, and e-mail address. The list of newly registered users is checked in the unchecked state. If you approve the use of, it is classified into the checked state and shown on the screen.

"Reset password" can change the password that can be accessed from the login screen for the user selected in the user registration grid screen to access the system.

New registration and deletion of the user is possible through the “Registration / Delete / Save / Cancel” button, and user information can be changed and canceled.

You can search only a specific user by clicking the “Search” button with the user name. If there is no search condition, the list of all users currently registered in the system is displayed on the user list grid screen.

44 shows access log management 242 of the detailed list of FIG. This is a detailed list screen when the menu is selected, and is classified into the Connection Status and Monthly Connection Status tabs. In the connection status tab, the search period is set by year-month-day and clicks the “search” button to search and output the connection result by pollutant load database 120 on a connection status grid screen for each user. In the Monthly Connection Status tab, the same procedure is used as in the Connection Status tab. You can check the monthly access records for the year by setting the period to be searched for the year.

45 is a code management 242 of the detailed list of FIG. 42; A screen when a menu is selected, and is composed of a code name, a code separator, a code value for each code, and a code description used in the present invention. This function checks the codes and contents used in the system when the user wants to input the data directly calculated or calculated through the upload function from Excel to the pollution load database 120; Is provided so that matching can be performed.

46 is a screen when the "Excel Save" button is clicked on all the screens of the present invention. In consideration of the user's convenience, the user applies a dialog box and a saving method used while performing a document work. While printing to Excel, you can check the progress by setting the ProgressBar, and when the output is complete, you can check whether the output is working properly through the MessageBox.

47 shows all load calculation module 220 of the present invention; This is an example screen output of the calculation result when a button is clicked in the flowchart.

Filtering can be sorted by watershed classification, city, city, county, eupmun-dong, and li in common.In the case of load level that is calculated based on the unit and coefficient, the content used in the corresponding step is displayed on the grid screen and Filtering can be stored separately, resulting in accurate results when calculating loads. If the check box is applied to the batch application, the changed raw unit and counting information can be calculated by applying all the contents of the job management unit 221; At the bottom, the load calculation result of the current step is output and divided up and down, and can be saved in Excel by using the effective digit change and the “Excel save” button.

The “Save / Cancel” button applies the changed unit and coefficient to apply to the next load calculation, or provides the function to cancel the changed contents and return to the original state. Through filtering, it is possible to save collectively by city, city, district, eupmyeon-dong, and li.

On the other hand, the pollution load calculation system according to the embodiment of the present invention is not limited to the above-described embodiment, but various modifications can be made without departing from the technical gist of the present invention.

100: load calculation system database group,
110: National Pollution Research Online System Database,
111: pollution source DB, 120: pollution load database,
121: calculation result DB, 130: water environment information system database,
131: weather data DB, 200: load calculation system drive unit,
210: data preprocessing module, 211: continuous map processing module,
212: rainfall data linkage module, 213: national pollution source data linkage module,
220: load calculation module, 221: work management unit,
222: calculation of the load generated by living, 223: calculation of the load generated by industrial
224: livestock generation load calculation, 225: land generation load calculation,
226: calculation of landfill generation load, 227: calculation of aquaculture load generation,
228: analysis of environmental infrastructure, 229: analysis of rainfall data,
230: load detection module, 231: search management processing unit,
232: load search unit, 233: watershed search unit,
234: area occupancy search unit, 235: Excel batch output unit,
240: system management module, 241: user management module,
242: log management module, 243: code management module,
300: client terminal.

Claims (2)

A database consisting of pollution calculation input data which is an input factor of pollution load calculation, comprising: a pollution source database 110 of a national pollution investigation online system; A water environment information system database 130 including weather data; A database group consisting of a pollution load database (120) for calculating a pollution load in association with the pollution source database (110) and the water environment information system database (130);
A system driving unit (200) for calculating the pollution load by using the data built in the database group so as to manage the total pollution intentionally;
At least one client connected to the system driving unit 200 and having input means for retrieving, inquiring, modifying and reloading load information, and output means for outputting an output result transmitted from the system 200 A terminal 300;
The system driving unit 200 is configured to be calculated by modifying and applying each unit (man or livestock unit) and coefficient (weighting value) used in calculating the pollutant load, municipal and district, and eupmundong-ri, respectively, and drive the system. The pollutant load information calculated by the unit 200 is stored in the pollutant load database 120 and configured to predict a future pollutant variation.
The system driving unit 200 is a pollution source calculation input data (liver source data, livestock source data, industrial source data, land-based source data, landfill source data, aquaculture source data, environmental infrastructure, built in the database group) A data preprocessing module for processing the analysis data);
A load calculation module for calculating pollution loads generated in each region and time zone for each environment region and updating the database group;
A load retrieval module for retrieving a pollutant load of a specific time and area through the database group;
The data preprocessing module is composed of a continuous cadastral map processing module 211, rainfall data linkage module 212, national pollution source data linkage module 213, and performs the process of processing data necessary for load calculation through the modules As a module, the continuous map processing module 211 creates a list of standard watershed-administrative zones so that the pollutant investigated by each administrative unit can be used for calculating loads by standard watershed. The environment information system database 130 establishes observation information and precipitation for each district by linking the quality observation station information, daily precipitation, and measurement station information 131 with the community information of the National Pollution Research Online System Database 110, and turns off pollutant data. Download the data to Excel using the -Line method and use the national pollution source data linkage module (213) of the load calculation system. Pollution load estimation system, characterized in that the data entered into the system.
delete

Images