CN112001808A - Evaluation system and evaluation method for establishing regional culture waste treatment project - Google Patents
Evaluation system and evaluation method for establishing regional culture waste treatment project Download PDFInfo
- Publication number
- CN112001808A CN112001808A CN202010728172.6A CN202010728172A CN112001808A CN 112001808 A CN112001808 A CN 112001808A CN 202010728172 A CN202010728172 A CN 202010728172A CN 112001808 A CN112001808 A CN 112001808A
- Authority
- CN
- China
- Prior art keywords
- module
- data
- breeding
- database
- result
- 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.)
- Pending
Links
- 239000002699 waste material Substances 0.000 title claims abstract description 43
- 238000011156 evaluation Methods 0.000 title claims description 22
- 238000009395 breeding Methods 0.000 claims abstract description 90
- 230000001488 breeding effect Effects 0.000 claims abstract description 90
- 238000004364 calculation method Methods 0.000 claims abstract description 65
- 238000009826 distribution Methods 0.000 claims abstract description 52
- 238000009360 aquaculture Methods 0.000 claims abstract description 50
- 244000144974 aquaculture Species 0.000 claims abstract description 50
- 238000000034 method Methods 0.000 claims abstract description 25
- 238000013480 data collection Methods 0.000 claims abstract description 19
- 238000013461 design Methods 0.000 claims abstract description 10
- 239000010865 sewage Substances 0.000 claims description 53
- 210000003608 fece Anatomy 0.000 claims description 15
- 238000003860 storage Methods 0.000 claims description 15
- 238000012545 processing Methods 0.000 claims description 12
- 241001465754 Metazoa Species 0.000 claims description 11
- 238000004140 cleaning Methods 0.000 claims description 9
- 238000004458 analytical method Methods 0.000 claims description 7
- 239000010871 livestock manure Substances 0.000 claims description 7
- 241000894007 species Species 0.000 claims description 5
- 238000005516 engineering process Methods 0.000 claims description 4
- 230000005540 biological transmission Effects 0.000 claims description 2
- 238000009313 farming Methods 0.000 claims description 2
- 238000002372 labelling Methods 0.000 claims description 2
- 238000011160 research Methods 0.000 claims description 2
- 238000012546 transfer Methods 0.000 claims description 2
- 238000009795 derivation Methods 0.000 claims 1
- 239000010815 organic waste Substances 0.000 abstract description 2
- 239000002994 raw material Substances 0.000 description 8
- VNWKTOKETHGBQD-UHFFFAOYSA-N methane Chemical compound C VNWKTOKETHGBQD-UHFFFAOYSA-N 0.000 description 6
- 241000283690 Bos taurus Species 0.000 description 4
- 244000144972 livestock Species 0.000 description 4
- 244000005700 microbiome Species 0.000 description 3
- 241000287828 Gallus gallus Species 0.000 description 2
- 241001494479 Pecora Species 0.000 description 2
- 241000282887 Suidae Species 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000000855 fermentation Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 244000144977 poultry Species 0.000 description 2
- 235000013594 poultry meat Nutrition 0.000 description 2
- 238000011144 upstream manufacturing Methods 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 235000015278 beef Nutrition 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 235000013330 chicken meat Nutrition 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 201000010099 disease Diseases 0.000 description 1
- 208000037265 diseases, disorders, signs and symptoms Diseases 0.000 description 1
- 238000001035 drying Methods 0.000 description 1
- 239000003344 environmental pollutant Substances 0.000 description 1
- 238000003912 environmental pollution Methods 0.000 description 1
- 230000004151 fermentation Effects 0.000 description 1
- 239000003337 fertilizer Substances 0.000 description 1
- 230000004060 metabolic process Effects 0.000 description 1
- 239000008267 milk Substances 0.000 description 1
- 235000013336 milk Nutrition 0.000 description 1
- 210000004080 milk Anatomy 0.000 description 1
- 239000003895 organic fertilizer Substances 0.000 description 1
- 239000005416 organic matter Substances 0.000 description 1
- 230000017448 oviposition Effects 0.000 description 1
- 230000010287 polarization Effects 0.000 description 1
- 231100000719 pollutant Toxicity 0.000 description 1
- 230000035935 pregnancy Effects 0.000 description 1
- 239000004576 sand Substances 0.000 description 1
- 239000002689 soil Substances 0.000 description 1
- 239000010902 straw Substances 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
- 238000005406 washing Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/02—Agriculture; Fishing; Forestry; Mining
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Quality & Reliability (AREA)
- General Business, Economics & Management (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Life Sciences & Earth Sciences (AREA)
- Remote Sensing (AREA)
- Agronomy & Crop Science (AREA)
- Software Systems (AREA)
- Mining & Mineral Resources (AREA)
- Animal Husbandry (AREA)
- Health & Medical Sciences (AREA)
- Marine Sciences & Fisheries (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
An assessment system and an assessment method for establishing a regional culture waste treatment project belong to the field of organic waste resource assessment. The system comprises a breeding industry data collection platform (1), a database (2), a quantitative calculation module (3), a spatial distribution module (4), a result export module A (5) and a result export module B (6); the system comprises an aquaculture data collection platform (1) and a database (2), wherein the database (2) is linked with a quantitative calculation module (3), the database (2) is linked with a spatial distribution module (4), the database (2) is also linked with a result export module A (5), and the spatial distribution module (4) is connected with a spatial distribution module (4) and a result export module B (6). The situation that the past project design completely depends on statistical data is changed, the timeliness and the accuracy of the data are improved, and accurate reference is provided for the site selection of the project.
Description
Technical Field
The invention belongs to the field of organic waste resource assessment, and particularly relates to an assessment system and an assessment method for establishing a regional culture waste treatment project.
Background
At present, the anaerobic fermentation technology is mainly adopted for the harmless and resource utilization of the cultivation waste. The small methane tank built by farmers in the past is gradually eliminated due to the defects of low methane yield, poor quality, difficulty in large-scale application and the like. Establishing a large biogas project in a certain area to treat the cultivation waste of the whole area is a mode which is greatly popularized at present. The biogas plant collects the cultivation waste in the global range, carries out centralized treatment, and ferments to produce biogas and organic fertilizer. The raw materials of the biogas plant are agricultural and animal husbandry wastes, and have strong randomness and uncertainty. The quantity and quality stability of the waste are greatly influenced by the upstream market, and the quantity and quality of the waste which can be collected can be influenced by the culture scale, price fluctuation and epidemic diseases of livestock and poultry. The biogas project is invested as a fixed asset, and once the project is built, the requirements of fermentation structures and equipment on raw materials are fixed. The biogas plant utilizes anaerobic microorganisms to treat wastes, the anaerobic microorganisms can perform normal growth and metabolism only under certain organic matter conditions, the normal activity of the anaerobic microorganisms is seriously influenced by insufficient raw materials, the gas production efficiency is reduced, the waste treatment effect is reduced, and the normal operation of the biogas plant is seriously influenced.
The main reason that the vacancy rate of the biogas project in China is high is that uncertainty of raw materials is not considered in the establishment and design of the biogas project, the construction scale is enlarged blindly for obtaining subsidies, so that actually collected wastes far cannot reach the design scale, and finally a biogas plant cannot normally operate.
In order to solve the problem of uncertain raw materials of the biogas engineering, the invention provides an evaluation system and an evaluation method for establishing a regional cultivation waste treatment engineering, which help the biogas engineering project to determine reasonable design scale and provide reference for project site selection. In the operation process of the biogas project, the upstream market can be continuously monitored, and the biogas project can be helped to cope with raw material fluctuation.
Disclosure of Invention
The invention aims to help a biogas project deal with the risk of uncertainty of raw materials, and provides an evaluation system and an evaluation method for establishing a regional culture waste treatment project.
An assessment system for establishing a regional aquaculture waste treatment project is characterized by comprising an aquaculture data collection platform (1), a database (2), a quantitative calculation module (3), a spatial distribution module (4), a result export module A (5) and a result export module B (6);
wherein: the system comprises an aquaculture data collection platform (1) and a database (2), wherein the database (2) is linked with a quantitative calculation module (3), the database (2) is linked with a spatial distribution module (4), the database (2) is also linked with a result export module A (5), and the spatial distribution module (4) is connected with a spatial distribution module (4) and a result export module B (6).
Further:
the breeding industry data collection platform (1) is used for collecting original data information of different breeding enterprises, wherein the original data information comprises names of farms, administrative regions, breeding types, stock quantity, animal growth stages, breeding modes, breeding time limit, manure cleaning modes, padding, longitude and latitude, enterprise responsibilities, contact modes and the like; collecting raw breeding data from local governments or breeding enterprises;
the database (2) is a relational database, is deployed in a local server and is used for storing, organizing and managing all data generated in the operation process of the evaluation system; the database (2) comprises at least three modules: the system comprises a raw module for storing original data, a parameter module for storing formula names and parameters required by quantitative calculation, and a result module for storing calculated sewage discharge; the raw module is connected with the aquaculture data collection platform (1) and used for storing information of the aquaculture data collection platform (1); the parameter module for storing the formula and the parameters required by quantitative calculation and the result module for storing the calculated sewage discharge are respectively linked with the quantitative calculation module (3);
all formulas and parameters adopted by the system and the method refer to the manual of pollution discharge coefficient of livestock and poultry breeding industry source for the first national pollution source general survey.
The quantitative calculation module (3) is used for executing calculation, is executed by using Python codes and comprises two Python files, one file' execute.
The file "execute.py" is responsible for data exchange and execution calculation, and the file "function.py" is responsible for saving a calculation formula; starting a quantitative calculation program by executing an ' execute.py ' file, firstly calling data from a raw module, acquiring information such as environment, breeding type, dung clearing mode and the like of the breeding industry, inquiring and comparing the information in a parameter module by using sql statements to acquire an applicable formula name and calculation parameters, importing a corresponding formula from a function.py ' file according to the acquired formula name, calling the data of the stock quantity or the stock quantity from the raw module in a database, and substituting the data of the stock quantity or the stock quantity and the parameters acquired from the database parameter module into the formula for calculation; and the calculation result is stored in the database result module.
The spatial distribution module (4) comprises a Geographic Information System (GIS) and an operation function; the spatial distribution module (4) is connected with a raw module and a result module in the database (2) and is used for analyzing and processing geographically related data and calculating the sewage discharge information including the sewage discharge amount, the aquaculture distribution condition and the like of a certain point to be selected within a certain radius range.
The result deriving module A (5) is a result display module, is linked with a result module in the database (2), is used for displaying the calculated result and displays the calculated result in the form of a table or a graph, and the graph is selected from a bar graph, a line graph, a sector graph and the like;
the result exporting module B (6) is a result display module, is linked with the spatial distribution module (4) and is used for displaying the calculation result, displays the calculation result in the form of a map, displays the selected sewage discharge information including the sewage discharge amount, the distribution condition of the aquaculture industry, the information of each aquaculture industry and the like in a certain point and certain radius range on the map, and can also include a table of specific enterprise information.
The radius can be selected according to requirements, such as 15km-40 km.
The aquaculture data collection platform (1) is in a website form; the website is deployed in a local server and is communicated with an aquaculture database deployed on the server.
Common breeding categories include: laying hens, broiler chickens, cows, beef cattle, pigs, sheep and the like.
Common forms of feces removal include: and (4) cleaning manure by drying and washing manure by water.
Common types of mattresses include: straw bedding, sand bedding, and the like.
Common animal growth stages include: farrowing, egg laying, fattening, conservation, pregnancy, milk production, and the like.
The raw module for storing the original data adopts a table 'raw _ data' to store information, the parameter module adopts a table 'parameter _ data' to store information, and the result module adopts a data table 'result _ data' to store information.
The assessment method for establishing the regional culture waste treatment project by adopting the system is characterized by comprising the following steps:
(1) collecting original data through a breeding industry data acquisition platform, wherein the platform adopts a website form, and information filled in the website is stored in a pollution database; relevant departments of the government or the responsible persons of the breeding enterprises log in the breeding industry data acquisition platform through a mobile phone or a computer browser, business information is filled according to the practical breeding situation of the enterprises, in order to ensure the consistency of data transmission and use, the longitude and latitude coordinates are uniformly converted into a WGS-84 coordinate system, and the coordinates of other coordinate systems are converted into the WGS-84 coordinate system; the currently recommended method for acquiring longitude and latitude comprises the following steps: searching the longitude and latitude of the characteristic position through a Google map and acquiring the longitude and latitude of the current position through a mobile phone compass app;
(2) the data processing and operation are carried out, because the data volume processed by the evaluation system is large, in order to ensure the normal operation of the evaluation system, the database technology is introduced for assisting the data processing, and MySQL is used for carrying out database management and is used for storing, organizing and managing all data generated in the operation process of the evaluation system; the method specifically comprises the following steps:
A. the method comprises the steps that original data are stored in a raw module, fields in the raw module correspond to information items collected by a breeding industry data collection module one by one and comprise names of farms, administrative districts, breeding scales, breeding types, dung clearing time, longitude and latitude coordinates and the like, the original data need to be cleaned after the data collection is finished, the cleaning comprises consistency check, invalid value and missing value processing and repeated data processing, the screened dirty data need to be verified, and the dirty data are converted into data meeting quality requirements and then stored for the second time;
B. the operation calculation and storage of data, because the breed and growth stage of the cultured animal of the culture place are different, the position and environment of the culture place are different, the culture way, culture period and manure cleaning way are different, judge by file "execute.py" need adopt different formulae and parameter to calculate under different circumstances, wherein in all formula names and parameter storage parameter modules, formula name and corresponding formula are in file "function.py", transfer formula and parameter of parameter module in file "function.py" according to the result judged, the parameter is the concrete numerical value; calculating, and storing the calculation result and the process information in a result module; the quantitative calculation module (3) is linked with the database (2) and is responsible for data exchange and execution calculation of the discharge capacity of each corresponding enterprise;
storing the calculation result and the calculation process information; the pollution discharge amount obtained by the quantitative calculation module is stored in the result module so as to facilitate the evaluation and research on the reliability of the calculation result in the later period, and the table also stores the calculation process information of the pollution discharge amount, mainly selected formulas and calculation parameters;
wherein the aquaculture waste quantitative calculation module; the module is responsible for calculating the sewage discharge capacity of the wastes in the farm, and the sewage discharge capacity of the farm is calculated through the information reported by the farm. The quantitative calculation module (3) is executed by using Python codes and comprises two Python files, wherein the file' execute. Starting a quantitative calculation program by executing an 'execute.py' file, firstly calling data from a raw module, acquiring information such as environment, breeding type, dung clearing mode and the like of the breeding industry, inquiring and comparing the information in a parameter module by using sql statements to acquire applicable formula names and calculation parameters, and importing corresponding formulas from a 'function.py' file according to the acquired formula names; and calling the data of the storage amount or the output amount from the raw module in the database, and substituting the data of the storage amount or the output amount and the parameters obtained from the parameter module into a formula for calculation. The calculation result is stored in a result module;
C. spatial distribution is carried out on the waste enterprises in the breeding industry, and a spatial distribution module (4) containing a Geographic Information System (GIS) and an operation function is adopted, and the module is based on the Geographic Information System (GIS) which is used in the prior art and is used for increasing geographic related data; the database data needs to be exported as a csv file and then imported into the module for analysis; mainly comprises the following steps:
(C1) analyzing distribution of a regional breeding industry, focusing on analysis of the regional breeding industry, mainly focusing on distribution of a breeding field, breeding scale and breeding variety, and marking different icons for the breeding field according to the breeding variety of the breeding field; marking the position of the breeding enterprise on a map by calling the name of a breeding farm, breeding species, stock quantity and longitude and latitude data in a raw module in a breeding industry pollution discharge database; the position of the farm marked on the map is point data, and the attributes of the point data comprise the name, breeding type, stock quantity and stock quantity of the corresponding farm; in order to more visually display the breeding types of all breeding plants, icons of the point data are set to be in corresponding animal shapes;
(C2) analyzing the sewage discharge distribution of the regional culture, emphasizing on the sewage discharge and the sewage discharge distribution of the region, mainly focusing on the sewage discharge distribution of a culture farm, and not focusing on the culture species of the culture farm any more; calling farm names and longitude and latitude data in a raw module in a sewage database of the aquaculture industry, calling sewage discharge data in a result module, and marking the position of the aquaculture enterprise on a map; the position of the farm marked on the map is point data, and the attribute of the point data comprises the name and the sewage discharge capacity of the corresponding farm; the size of the labeling icon is in direct proportion to the sewage discharge amount of the breeding enterprise, and meanwhile, in order to avoid the influence of too large or too small icons on reading, the maximum value and the minimum value are set for the size of the icons;
(C3) summarizing and calculating the sewage discharge capacity in a specific range; the biogas plant generally collects the wastes generated by each farm in a road transportation mode, the economic collection range is 15-40km, and the exact economic collection radius is determined according to the local energy price and the road condition, so that the sum of the sewage discharge amounts of the farms in the statistical economic collection radius range has more guidance value for site selection and design scale determination of the biogas plant. In order to realize the function, a corresponding element of collecting the radius circular surface is required to be created in the GIS, the circle is moved to a culture dense area, a GIS system 'in-range summary' tool is used, the sewage discharge of all farms under the circular coverage surface is summed up and calculated, and the sewage discharge of the farms in the economic collection radius range is obtained.
(4) The result exporting module A (5) is linked with the database (2) and is used for displaying the result calculated by the database (2) in a form of a table or a chart;
the result exporting module B (6) is a result display module, is linked with the spatial distribution module (4) and is used for displaying the result calculated by the spatial distribution module (4), displaying the selected sewage discharge information including the sewage discharge amount, the distribution condition of the aquaculture industry, the information of each aquaculture industry and the like in a certain point and certain radius range on a map, and also can include a form of specific enterprise information
In order to deal with the uncertainty of the raw materials of the biogas engineering, the invention has the following beneficial effects:
1. the method provides a specific and accurate original data collection mode, changes the situation that the past project design completely depends on statistical data, and improves the timeliness and the accuracy of the data.
2. The method provides a waste quantitative calculation method of a scientific system, changes the unreasonable method of determining the design scale only by depending on engineering experience in the past, and provides reasonable reference for determining the biogas engineering scale.
3. The GIS technology is applied to the design and operation of biogas engineering, the local cultivation waste distribution is researched, and a reference is provided for the site selection of projects.
Drawings
FIG. 1 is a schematic diagram of a waste evaluation system for area farming;
specific implementation methods the present system is further illustrated below with reference to specific examples, but the present invention is not limited to the following examples.
Example 1
The evaluation system and the evaluation method of the invention are adopted for actual evaluation.
The animal husbandry is developed in the river course plain in a certain city in the northwest, but the waste produced by the local animal husbandry is used as fertilizer to enter farmlands after being simply stacked and treated, and the pollution to local soil, underground water and lakes is serious. In order to improve the local environmental pollution problem, a plurality of methane projects are planned to be built in the whole market range, so that the pollution problem of the aquaculture industry is solved. In order to determine the construction scale, quantity and position of the biogas plant, the system of the invention is used for evaluating the local aquaculture waste.
1. And (5) acquiring the original data of the breeding industry. And collecting the aquaculture information of the market by using an aquaculture data acquisition module. The breeding enterprises log in the module by themselves through the browser to fill in the breeding conditions of the breeding enterprises, and the filling content comprises information such as names of farms, administrative districts, breeding types, stock quantity, animal growth stages, breeding modes, breeding time limit, feces clearing modes, padding, longitude and latitude, enterprise responsibilities, contact modes and the like. The collected information is stored in a raw module in a pollution discharge database of the aquaculture industry through a data interface.
2. Data cleaning, verification and secondary storage. Data cleansing includes consistency checking, invalid and missing value processing, repeated data processing, and the like. And the problematic data is verified and then secondarily stored. The unit error exists in the column quantity of partial livestock farm reports, the obvious error exists in the longitude and latitude of partial livestock farm reports, and the secondary storage is carried out after the error data is verified in a telephone return visit mode.
3. And (5) quantitatively analyzing the discharge capacity. Py file is configured to determine the calculation range. Executing the "execute.py" file, as described above, after the program runs, the "execute.py" first calls data from the raw module of the database, obtains information such as the environment where the breeding industry is located, the breeding type, the feces clearing mode and the like, and uses sql statements to query and compare the information in the parameter module to obtain an applicable formula name and calculation parameters. And calling a corresponding formula from the function. And calling the data of the storage amount or the output amount from the database raw module, and substituting the data of the storage amount or the output amount and the parameters obtained from the database parameter module into a formula for calculation. And the calculation result is stored in a result module.
4. And (5) analyzing the spatial distribution of the wastes in the breeding industry. The pollutant spatial distribution model is realized based on gis, and is a newly-built project in gis, namely 'certain-market aquaculture waste distribution'. Adding a Chinese county-level administrative boundary base map to the project, hiding other areas by defining a query function, and only reserving an evaluation area, namely the city scope.
(1) The distribution analysis of the regional breeding industry focuses on the analysis of the regional breeding industry, mainly focuses on the distribution of breeding fields, the breeding scale and the breeding variety, and marks different icons for the breeding fields according to the breeding variety. And converting the data of the aquaculture pollution discharge database into csv files for exporting, wherein the attributes of the exported data comprise aquaculture names, aquaculture types, stock quantity, longitude and latitude. The csv file is imported gis as point data with longitude and latitude attributes as the X and Y fields of the point data, with the point element layer named "point _ class". Deriving elements from the 'point _ class' element layer according to the breeding type, respectively building new element layers for pigs, cows, sheep, chickens and the like, respectively naming the new element layers as 'point _ pig', 'point _ cow', 'point _ sheet' and 'point _ chip', and distributing corresponding icons for the classified element layers.
(2) The regional pollution discharge distribution analysis of breeding emphasizes the pollution discharge and the pollution discharge distribution in the region, mainly focuses on the pollution discharge distribution of the farm, and does not focus on the breeding species of the farm any more. And inquiring the name and longitude and latitude data of a farm in a raw module in a sewage database of the aquaculture industry through an sql language, inquiring the sewage discharge data in a result module, splicing the data and then exporting a csv file. The csv file is imported gis as point data with a longitude attribute and a latitude attribute as the X field and the Y field of the point data, and the point element layer is named "point _ polarization". The farm locations marked on the map are point data, and the point data attributes comprise names and sewage discharge capacity of corresponding farms. The size of the marking icon is in direct proportion to the sewage discharge amount of the breeding enterprise, and meanwhile, the size, the color, the transparency, the shape and the like of the icon can be adjusted for displaying the sewage discharge distribution of the breeding farm more visually. And (3) summarizing and calculating the sewage discharge capacity in a specific range. The biogas plant generally collects the waste generated by each farm in a road transportation mode, and the local economic collection range is 20km in radius. Therefore, the sum of the sewage discharge amount of the farm within the statistical radius of 20km has more guiding value for site selection and design scale determination of the biogas plant. In the gis system, a circular face element is drawn, the radius of the circle being 20km, the circular face element being named "shape". And moving a circle to a pollution discharge dense area, wherein the center of the circle is the assumed site selection position of the biogas plant. Configuring an 'in-range summarizing' tool, wherein an input surface is 'shape', an input summarizing element 'point _ pollution', an output element class 'pollution _20 km', a field is 'sewage discharge amount', statistical data is 'summation', and the tool is operated to obtain the sewage discharge amount sum in a 20km circle coverage range, namely the amount of the wastes collectable in the economic collection range of the current supposed site selection position of the biogas plant.
Claims (9)
1. An assessment system for establishing a regional aquaculture waste treatment project is characterized by comprising an aquaculture data collection platform (1), a database (2), a quantitative calculation module (3), a spatial distribution module (4), a result export module A (5) and a result export module B (6);
wherein: the system comprises an aquaculture data collection platform (1) and a database (2), wherein the database (2) is linked with a quantitative calculation module (3), the database (2) is linked with a spatial distribution module (4), the database (2) is also linked with a result export module A (5), and the spatial distribution module (4) is connected with a spatial distribution module (4) and a result export module B (6).
2. The assessment system for establishing the regional aquaculture waste treatment project according to claim 1, wherein the aquaculture data collection platform (1) is used for collecting original data information of different aquaculture enterprises, including names of farms, administrative districts, aquaculture types, stock quantity, animal growth stages, aquaculture modes, aquaculture time limit, manure cleaning modes, bedding, longitude and latitude, enterprise responsibility and contact modes and the like; collecting raw breeding data from local governments or breeding enterprises;
3. an assessment system for the set-up of regional culture waste treatment projects according to claim 1, characterized in that the database (2) is a relational database deployed in a local server for storing, organizing and managing all data generated during the operation of the assessment system; the database (2) comprises at least three modules: the system comprises a raw module for storing original data, a parameter module for storing formula names and parameters required by quantitative calculation, and a result module for storing calculated sewage discharge; the raw module is connected with the aquaculture data collection platform (1) and used for storing information of the aquaculture data collection platform (1); the parameter module for storing the formula and the parameters required by quantitative calculation and the result module for storing the calculated sewage discharge are respectively linked with the quantitative calculation module (3).
4. An assessment system for establishing regional culture waste treatment projects according to claim 3, characterized in that the quantitative calculation module (3) is used for performing calculations, and the module is executed by using Python code and comprises two Python files, one file "execute.py" and the other file "function.py";
the file "execute.py" is responsible for data exchange and execution calculation, and the file "function.py" is responsible for saving a calculation formula; starting a quantitative calculation program by executing an 'execute.py' file, firstly calling data from a raw _ module, acquiring information such as the environment, the breeding type and the manure cleaning mode of the breeding industry, inquiring and comparing the information in a parameter module by using sql sentences to acquire applicable formula names and calculation parameters, importing a corresponding formula from the 'function.py' file according to the acquired formula names, calling the data of the stock quantity or the stock quantity from the raw module in a database, and substituting the data of the stock quantity or the stock quantity and the parameters acquired from the database parameter module into the formula together for calculation; and the calculation result is stored in the database result module.
5. An assessment system for the set-up of the waste treatment project of regional farming according to claim 3, characterized in that the spatial distribution module (4) contains a Geographic Information System (GIS) and arithmetic functions; the spatial distribution module (4) is connected with a raw module and a result module in the database (2) and is used for analyzing and processing geographically related data and calculating the sewage discharge information including the sewage discharge amount and the aquaculture distribution condition of a certain point to be selected within a certain radius range.
6. The assessment system for establishing the waste treatment project of the regional aquaculture as claimed in claim 3, wherein the result derivation module A (5) is a result display module, linked with the result module in the database (2), for displaying the calculated result in the form of a table or a graph, wherein the graph is selected from a bar graph, a line graph and a sector graph;
the result exporting module B (6) is a result display module, is linked with the spatial distribution module (4), and is used for displaying the calculation result, displaying the calculation result in the form of a map, and displaying selected sewage discharge information including sewage discharge amount, aquaculture distribution condition, aquaculture information and the like in a certain point and certain radius range on the map, and also including a form of enterprise specific information;
the radius mentioned above can be selected as desired.
7. The assessment system for establishing the regional culture waste treatment project according to claim 3, wherein a raw module for storing raw data adopts table "raw _ data" storage information, a parameter module adopts table "parameter _ data" storage information, and a result module adopts a data table "result _ data" storage information.
8. An assessment system for the set-up of the waste disposal project for the aquaculture of claim 1 wherein said aquaculture data collection platform (1) is in the form of a website; the website is deployed in a local server and is communicated with an aquaculture database deployed on the server.
9. The assessment method for performing the project of waste disposal for aquaculture of any one of claims 1 to 8, characterized by comprising the following steps:
(1) collecting original data through a breeding industry data acquisition platform, wherein the platform adopts a website form, and information filled in the website is stored in a pollution database; relevant departments of the government or the responsible persons of the breeding enterprises log in the breeding industry data acquisition platform through a mobile phone or a computer browser, business information is filled according to the practical breeding situation of the enterprises, in order to ensure the consistency of data transmission and use, the longitude and latitude coordinates are uniformly converted into a WGS-84 coordinate system, and the coordinates of other coordinate systems are converted into the WGS-84 coordinate system; the currently recommended method for acquiring longitude and latitude comprises the following steps: searching the longitude and latitude of the characteristic position through a Google map and acquiring the longitude and latitude of the current position through a mobile phone compass app;
(2) the data processing and operation are carried out, because the data volume processed by the evaluation system is large, in order to ensure the normal operation of the evaluation system, the database technology is introduced for assisting the data processing, and MySQL is used for carrying out database management and is used for storing, organizing and managing all data generated in the operation process of the evaluation system; the method specifically comprises the following steps:
A. the method comprises the steps that original data are stored in a raw module, fields in the raw module correspond to information items collected by a breeding industry data collection module one by one and comprise names of farms, administrative districts, breeding scales, breeding types, dung clearing time, longitude and latitude coordinates and the like, the original data need to be cleaned after the data collection is finished, the cleaning comprises consistency check, invalid value and missing value processing and repeated data processing, the screened dirty data need to be verified, and the dirty data are converted into data meeting quality requirements and then stored for the second time;
B. the operation calculation and storage of data, because the breed and growth stage of the cultured animal of the culture place are different, the position and environment of the culture place are different, the culture way, culture period and manure cleaning way are different, judge by file "execute.py" need adopt different formulae and parameter to calculate under different circumstances, wherein in all formula names and parameter storage parameter modules, formula name and corresponding formula are in file "function.py", transfer formula and parameter of parameter module in file "function.py" according to the result judged, the parameter is the concrete numerical value; calculating, and storing the calculation result and the process information in a result module; the quantitative calculation module (3) is linked with the database (2) and is responsible for data exchange and execution calculation of the discharge capacity of each corresponding enterprise;
storing the calculation result and the calculation process information; the pollution discharge amount obtained by the quantitative calculation module is stored in the result module so as to facilitate the evaluation and research on the reliability of the calculation result in the later period, and the table also stores the calculation process information of the pollution discharge amount, mainly selected formulas and calculation parameters;
wherein the aquaculture waste quantitative calculation module; the module is responsible for calculating the sewage discharge capacity of the wastes in the farm, and the sewage discharge capacity of the farm is calculated through the information reported by the farm. The quantitative calculation module (3) is executed by using Python codes and comprises two Python files, wherein the file' execute. Starting a quantitative calculation program by executing an 'execute.py' file, firstly calling data from a raw module, acquiring information such as environment, breeding type, dung clearing mode and the like of the breeding industry, inquiring and comparing the information in a parameter module by using sql statements to acquire applicable formula names and calculation parameters, and importing corresponding formulas from a 'function.py' file according to the acquired formula names; and calling the data of the storage amount or the output amount from the raw module in the database, and substituting the data of the storage amount or the output amount and the parameters obtained from the parameter module into a formula for calculation. The calculation result is stored in a result module;
C. spatial distribution is carried out on the waste enterprises in the breeding industry, and a spatial distribution module (4) containing a Geographic Information System (GIS) and an operation function is adopted, and the module is based on the Geographic Information System (GIS) which is used in the prior art and is used for increasing geographic related data; the database data needs to be exported as a csv file and then imported into the module for analysis; mainly comprises the following steps:
(C1) analyzing distribution of a regional breeding industry, focusing on analysis of the regional breeding industry, mainly focusing on distribution of a breeding field, breeding scale and breeding variety, and marking different icons for the breeding field according to the breeding variety of the breeding field; marking the position of the breeding enterprise on a map by calling the name of a breeding farm, breeding species, stock quantity and longitude and latitude data in a raw module in a breeding industry pollution discharge database; the position of the farm marked on the map is point data, and the attributes of the point data comprise the name, breeding type, stock quantity and stock quantity of the corresponding farm; in order to more visually display the breeding types of all breeding plants, icons of the point data are set to be in corresponding animal shapes;
(C2) analyzing the sewage discharge distribution of the regional culture, emphasizing on the sewage discharge and the sewage discharge distribution of the region, mainly focusing on the sewage discharge distribution of a culture farm, and not focusing on the culture species of the culture farm any more; calling farm names and longitude and latitude data in a raw module in a sewage database of the aquaculture industry, calling sewage discharge data in a result module, and marking the position of the aquaculture enterprise on a map; the position of the farm marked on the map is point data, and the attribute of the point data comprises the name and the sewage discharge capacity of the corresponding farm; the size of the labeling icon is in direct proportion to the sewage discharge amount of the breeding enterprise, and meanwhile, in order to avoid the influence of too large or too small icons on reading, the maximum value and the minimum value are set for the size of the icons; (C3) summarizing and calculating the sewage discharge capacity in a specific range; the biogas plant generally collects the wastes generated by each farm in a road transportation mode, the economic collection range is 15-40km, and the exact economic collection radius is determined according to the local energy price and the road condition, so that the sum of the sewage discharge amounts of the farms in the statistical economic collection radius range has more guidance value for site selection and design scale determination of the biogas plant. In order to realize the function, a corresponding element of collecting the radius circular surface is required to be created in the GIS, the circle is moved to a culture dense area, a GIS system 'in-range summary' tool is used, the sewage discharge of all farms under the circular coverage surface is summed up and calculated, and the sewage discharge of the farms in the economic collection radius range is obtained.
(4) The result exporting module A (5) is linked with the database (2) and is used for displaying the result calculated by the database (2) in a form of a table or a chart;
the result exporting module B (6) is a result display module, is linked with the spatial distribution module (4) and is used for displaying the result calculated by the spatial distribution module (4), displaying the selected sewage discharge information including the sewage discharge amount, the distribution condition of the aquaculture industry, the information of each aquaculture industry and the like in a certain point and certain radius range on a map, and also can include a form of specific enterprise information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010728172.6A CN112001808A (en) | 2020-07-27 | 2020-07-27 | Evaluation system and evaluation method for establishing regional culture waste treatment project |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010728172.6A CN112001808A (en) | 2020-07-27 | 2020-07-27 | Evaluation system and evaluation method for establishing regional culture waste treatment project |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112001808A true CN112001808A (en) | 2020-11-27 |
Family
ID=73467230
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010728172.6A Pending CN112001808A (en) | 2020-07-27 | 2020-07-27 | Evaluation system and evaluation method for establishing regional culture waste treatment project |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112001808A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112819435A (en) * | 2021-02-02 | 2021-05-18 | 中国船舶重工集团环境工程有限公司 | Engineering calculation system for auxiliary design of biogas production by utilizing organic solid waste resources |
| CN112965961A (en) * | 2021-02-02 | 2021-06-15 | 中国船舶重工集团环境工程有限公司 | Big data analysis method for biogas production by utilizing organic solid waste resources |
-
2020
- 2020-07-27 CN CN202010728172.6A patent/CN112001808A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112819435A (en) * | 2021-02-02 | 2021-05-18 | 中国船舶重工集团环境工程有限公司 | Engineering calculation system for auxiliary design of biogas production by utilizing organic solid waste resources |
| CN112965961A (en) * | 2021-02-02 | 2021-06-15 | 中国船舶重工集团环境工程有限公司 | Big data analysis method for biogas production by utilizing organic solid waste resources |
| CN112819435B (en) * | 2021-02-02 | 2022-03-15 | 中国船舶重工集团环境工程有限公司 | Engineering calculation system for auxiliary design of biogas production by utilizing organic solid waste resources |
| CN112965961B (en) * | 2021-02-02 | 2023-04-28 | 中国船舶重工集团环境工程有限公司 | Big data analysis method for biogas production by utilizing organic solid waste resources |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112001808A (en) | Evaluation system and evaluation method for establishing regional culture waste treatment project | |
| Vizzari et al. | Environmental effectiveness of swine sewage management: a multicriteria AHP-based model for a reliable quick assessment | |
| CN109919522A (en) | A kind of Pollution from livestock and poultry prevention and treatment monitoring management system and method | |
| Goodchild | Modelling roman agricultural production in the middle tiber valley, central Italy | |
| Ferrari et al. | An assessment of nitrogen loading and biogas production from Italian livestock: a multilevel and spatial analysis | |
| CN112115843A (en) | Facility agriculture land daily monitoring and supervision method | |
| CN112765531A (en) | Automatic calculation method and system for drainage basin non-point source discharge amount | |
| CN114462698B (en) | Phosphorus emission pollution load prediction method for drainage basin catchment area | |
| CN213069897U (en) | Evaluation system for establishing regional culture waste treatment project | |
| CN112462030B (en) | Method and device for measuring and calculating bearing capacity of livestock and poultry manure soil | |
| Cau et al. | Assessment of alternative land management practices using hydrological simulation and a decision support tool: Arborea agricultural region, Sardinia | |
| CN114416692B (en) | Method for constructing river basin water environment management data resource system | |
| Cervelli et al. | The landscape approach as support to the livestock manure management. The buffalo herds case-study in Sele plain, Campania region | |
| Butt | Greenhouse gas inventory at an institution level: a case study of Massey University, New Zealand | |
| CN115641028A (en) | Plain river network surface source pollution load estimation method based on revenue and expenditure model | |
| Thayalakumaran et al. | Assessing nitrogen fluxes from dairy farms using a modelling approach: A case study in the Moe River catchment, Victoria, Australia | |
| Qu et al. | A modular approach for quantification of nitrogen flows and losses along dairy manure management chains of different complexity | |
| Jennings et al. | Drivers of long-term trends and seasonal changes in total phosphorus loads to a mesotrophic lake in the west of Ireland | |
| CN111079087A (en) | Method for measuring and calculating greenhouse gas emission in live pig breeding industry | |
| Eddiwan et al. | Designing management of sustainable shrimp cultivation area in East Lingga, Lingga District. | |
| Jiang et al. | Assessment of the GHG reduction potential from energy crops using a combined LCA and biogeochemical process models: a review | |
| Laasasenaho | Biomass Resource Allocation for Bioenergy Production on Cutaway Peatlands with Geographical Information (GI) Analyses | |
| Wang et al. | Research Progress in Workshop Scheduling of Livestock and Poultry Management | |
| Liu et al. | Application and evaluation of two nutrient algorithms of Hydrological Simulation Program Fortran in Wolf River watershed | |
| Zheng et al. | Report for the Puding Government on the China-UK Karst Knowledge Exchange Project |
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 |