CN117453782A - Implementation method of real-time online sharing application mechanism for water service facility investigation result - Google Patents
Implementation method of real-time online sharing application mechanism for water service facility investigation result Download PDFInfo
- Publication number
- CN117453782A CN117453782A CN202311336351.5A CN202311336351A CN117453782A CN 117453782 A CN117453782 A CN 117453782A CN 202311336351 A CN202311336351 A CN 202311336351A CN 117453782 A CN117453782 A CN 117453782A
- Authority
- CN
- China
- Prior art keywords
- data
- water service
- standard
- real
- time online
- 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
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 title claims abstract description 62
- 238000011835 investigation Methods 0.000 title claims abstract description 45
- 238000000034 method Methods 0.000 title claims abstract description 28
- 238000012545 processing Methods 0.000 claims abstract description 22
- 238000003860 storage Methods 0.000 claims abstract description 13
- 238000013441 quality evaluation Methods 0.000 claims abstract description 11
- 238000004140 cleaning Methods 0.000 claims abstract description 9
- 238000007781 pre-processing Methods 0.000 claims abstract description 5
- 238000012795 verification Methods 0.000 claims abstract description 4
- 230000005856 abnormality Effects 0.000 claims description 15
- 230000002159 abnormal effect Effects 0.000 claims description 12
- 238000007689 inspection Methods 0.000 claims description 7
- 238000009877 rendering Methods 0.000 claims description 7
- 238000012937 correction Methods 0.000 claims description 6
- 239000010865 sewage Substances 0.000 claims description 6
- 238000001514 detection method Methods 0.000 claims description 5
- 238000007726 management method Methods 0.000 claims description 5
- 238000007405 data analysis Methods 0.000 claims description 3
- 238000013523 data management Methods 0.000 claims description 3
- 238000007418 data mining Methods 0.000 claims description 3
- 238000013500 data storage Methods 0.000 claims description 3
- 230000003203 everyday effect Effects 0.000 claims description 3
- 238000011160 research Methods 0.000 claims description 2
- 238000004519 manufacturing process Methods 0.000 claims 1
- 238000013461 design Methods 0.000 description 5
- 238000010606 normalization Methods 0.000 description 4
- 238000010276 construction Methods 0.000 description 3
- 230000007547 defect Effects 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000005259 measurement Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000012512 characterization method Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000002950 deficient Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000002265 prevention Effects 0.000 description 1
- 238000001303 quality assessment method Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
Classifications
-
- 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/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/176—Support for shared access to files; File sharing support
-
- 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/26—Visual data mining; Browsing structured data
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/10—Office automation; Time management
- G06Q10/109—Time management, e.g. calendars, reminders, meetings or time accounting
-
- 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/10—Services
- G06Q50/26—Government or public services
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02A—TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
- Y02A20/00—Water conservation; Efficient water supply; Efficient water use
- Y02A20/152—Water filtration
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)
- Tourism & Hospitality (AREA)
- Economics (AREA)
- Quality & Reliability (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Computing Systems (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a method for realizing a real-time online sharing application mechanism of water service facility investigation results, which comprises the following steps: determining field acquisition standards, data warehousing standards and file warehousing standards by referring to related water service facility investigation specifications and service requirements; the data of the water service system is collected in a standardized way by the field collection standard; preprocessing water service system data collected by field industry; carrying out standardized processing on the preprocessed data through a data warehouse-in standard; auditing the standardized data; a data flow mechanism of problem feedback and data cleaning is adopted to construct a dynamic data center, and standardized data passing the verification is put into the data center; establishing a data quality evaluation system according to the data warehousing standard, wherein the data quality evaluation system constrains a data center; determining a standard result pattern derived by a data center through an archive storage standard; the data center is connected with the data processing platform through a standard interface to perform data sharing and collaborative editing.
Description
Technical Field
The invention relates to the technical field of pipe network investigation, in particular to a method for realizing a real-time online sharing application mechanism of water service facility investigation results.
Background
At present, the data of the pipe network investigation result and the like are all manually arranged, and data transmission of all parties is carried out in a static batch import-based mode, so that application data is not updated timely and cannot play a role. The operation process and the result data patterns are complicated, and relate to a plurality of intermediate files, and the unified investigation process and the result file patterns are lacked. The existing data standard has simple definition on the data coding rule, cannot meet the requirement of high-efficiency rendering of a large amount of water service space data, and has topology construction.
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides a method for realizing a real-time online sharing application mechanism of water service facility investigation results, which aims to solve the problems that the current water service data is not timely applied, the result data depends on manual arrangement, and the data application value is deficient.
In order to achieve the above purpose, the invention adopts the following technical scheme:
a realization method of a real-time online sharing application mechanism of water service facility investigation results comprises the following steps:
(1) Determining field acquisition standards, data warehousing standards and file warehousing standards by referring to related water service facility investigation specifications and service requirements;
(2) The data of the water service system is collected in a standardized way by the field collection standard;
(3) Preprocessing water service system basic data collected by field industry;
(4) Carrying out standardized processing on the pretreated water service system basic data through a data warehouse-in standard;
(5) Auditing the standardized water service system basic data;
(6) A data flow mechanism of problem feedback and data cleaning is adopted to construct a dynamic data center, and standardized data passing the verification is put into the data center;
(7) Establishing a data quality evaluation system according to the data warehousing standard, wherein the data quality evaluation system constrains a data center;
(8) Determining a standard result pattern derived by a data center through an archive storage standard;
(9) The data center is connected with the data processing platform through a written standard interface to carry out data sharing and collaborative editing.
In a preferred scheme, for the step (7), the data quality evaluation system is established by the following steps: performing system problem study and judgment and manual problem addition on the investigation result, performing online correction, ensuring data quality, aiming at the manual problems of pipe network integrity rate abnormality, rain and sewage attribute abnormality and inspection well position abnormality, prescribing about 7 working days from reporting to receiving, about 60 working days from receiving and rectifying to checking about 7 working days, otherwise, sending out-of-date reminding, writing an algorithm aiming at the system problems of logic conflict, data repetition, data abnormality and topology abnormality, establishing a research and judgment mechanism of topology abnormality and data conflict, carrying out problem checking on the current day of investigation result data every day, and carrying out quality checking on all the investigation result data every month until investigation and acceptance.
In a preferred scheme, an algorithm is written to quantitatively score data, the problem affecting the score is marked, the data can be put into a data center only after the data is changed below a certain score, and the algorithm is as follows:
the full score of the comprehensive score is 100 minutes, and x is the total number of the pipe wells; ai is a problem; bi is the question weight.
In a preferred scheme, for the step (2), the data acquisition object of the water service system of the field industry comprises space elements of a drain pipe point, a drain pipe line and a drain surface, and the data acquisition object comprises space topological association relations among the drain pipe point, the drain pipe line and the drain surface.
Preferably, for the step (6), the problem feedback: aiming at the problems of abnormal pipe network integrity rate, abnormal rain and sewage properties, abnormal inspection well position, doubtful topology information and the like, the data correction service in the whole process of adding, collecting, correcting and checking the problems is provided;
data cleaning: the dirty data is converted into data meeting the data quality requirement by utilizing the clearing rules of mathematical statistics, data mining, anomaly detection and repeated processing, wherein the dirty data comprises misspellings, naming habits, illegal values and null values.
Preferably, for the step (4), the normalization processing includes normalization of data format, form format, service distribution rule, rendering annotation style, database and table dividing rule, and image data storage rule.
In the preferred scheme, for the step (6), the data center adopts a distributed architecture to divide the warehouse-in standardized data into warehouse-in and warehouse-out tables, and two sets of global unique codes are provided according to the corresponding space type of the facility, one set of global unique codes is a geophysical prospecting code which accords with the acquisition specification, and the other set of global unique codes is a self-increasing global unique code of a block management system.
In the preferred scheme, for the step (8), the conventional word, excle, dwg, tif, img, lrp format water affair basic data is subjected to data management according to the archival storage standard, and then the unified storage tool is used for finishing the complete compiling of the water affair basic data result, and the standard CAD, the standard outer, the standard word and the image data are derived.
Preferably, for the step (9), the data processing platform comprises a data display platform, a data analysis platform and a data acquisition platform.
Preferably, for the step (9), the data processing platform further comprises a three-dimensional platform, and the data center outputs the three-dimensional data to the three-dimensional platform.
The invention discloses a method for realizing a real-time online sharing application mechanism of water service facility investigation results, which has the beneficial effects that:
(1) The applicability of the water service facility investigation result is improved, so that the water service facility investigation result can be used as the investigation and storage file data, and can also be used as a standard library for carrying out operation and maintenance of the water service facility in a subsequent related unit, and the integration of water service facility data acquisition and application is realized.
(2) The system meets the current water service facility fine management requirement, has clear definition on the drainage facility, has perfect point line and plane, simultaneously contains space topology association relation among all space elements, meets the high-efficiency rendering of a large amount of water service space data, and does not only use point characteristics and accessories to represent the drainage facility.
(3) The data communication efficiency of different levels is improved, all water service facility investigation follows the unified field collection standard, data warehouse-in standard and file warehouse-in standard, the investigation process and the result file style are unified, the inconsistency of formats of all units is avoided, and the availability and comparability of data are improved.
Drawings
Fig. 1 is a flow chart of a method for realizing a real-time online sharing application mechanism of water service facility investigation results according to an embodiment of the invention.
Fig. 2 is a schematic flow chart of problem feedback in a data streaming mechanism according to an embodiment of the present invention.
Fig. 3 is a schematic flow chart of data cleansing in the data streaming mechanism according to an embodiment of the present invention.
Fig. 4 is a schematic flow chart of establishing a data quality evaluation system according to an embodiment of the present invention.
FIG. 5 is a table of quantitative scores for the data quality assessment system of an embodiment of the present invention.
Detailed Description
The invention will be further described with reference to the drawings and the specific embodiments.
As shown in fig. 1, the invention discloses a method for realizing a real-time online sharing application mechanism of water service facility investigation results, which comprises the following steps:
(1) Determining field acquisition standards, data warehousing standards and file warehousing standards by referring to related water service facility investigation specifications and service requirements;
(2) The data of the water service system is collected in a standardized way by the field collection standard;
(3) Preprocessing water service system data collected by field industry;
(4) Carrying out standardized processing on the pretreated water service system data through a data warehouse-in standard;
(5) Auditing the standardized water service system data;
(6) A data flow mechanism of problem feedback and data cleaning is adopted to construct a dynamic data center, and standardized data passing the verification is put into the data center;
(7) Establishing a data quality evaluation system according to the data warehousing standard, wherein the data quality evaluation system constrains a data center;
(8) Determining a standard result pattern derived by a data center through an archive storage standard;
(9) The data center is connected with the data processing platform through a written standard interface to carry out data sharing and collaborative editing.
It should be noted that, in the step (1), the water service facility investigation-related specification and the service requirement include:
(1) GB/T24356, quality inspection and acceptance of mapping achievements;
(2) GB50014-2021, outdoor drainage design Standard;
(3) GB/T50125 basic term Standard for Water supply and drainage engineering;
(4) GB/T51187-2016 technical Specification for data acquisition and maintenance of urban drainage and waterlogging prevention facilities;
(5) SZDB/Z330-2018, data acquisition and database construction Specification of outdoor drainage facilities;
(6) CJJ/T8-2011 City measurement Specification;
(7) CJJ 61-2017 technical procedure for urban underground pipeline detection;
(8) CJJ 181-2012 "town drainage pipeline detection and evaluation technical Specification";
(9) SL 707-2015, water conservancy and government information database table structure and identifier;
(10) DB 3201/T257 pipeline data Standard;
(11) DBJ/T15-212-2021 technical Specification for Intelligent drainage construction.
Further, for the step (5), making an audit standard, developing a gadget, (1) checking whether the data is complete or not and whether a missing value exists or not according to the data table field; (2) Verifying the accuracy of the data, and judging the data logic aiming at the pipe diameter and elevation basic data; (3) Check compliance of the data and check whether it is filled in according to the required data type.
Further, for step (6), as shown in fig. 2, the problem feedback: aiming at the problems of abnormal pipe network integrity rate, abnormal rain and sewage properties, abnormal inspection well position, doubtful topology information and the like, the whole process data correction service of adding, checking and recovering from the problems is provided.
As shown in fig. 3, data cleaning: the dirty data is converted into data meeting the data quality requirement by using mathematical statistics, data mining or predefined cleaning rules, and the dirty data is mainly aimed at defect values and deviation values.
Further, in the step (7), as shown in fig. 4, the system problem determination and the manual problem addition are performed on the investigation result, and then on-line correction is performed, so that the data quality is ensured. Aiming at the manual problems of abnormal pipe network integrity rate, abnormal rain and sewage properties, abnormal inspection well positions and the like, about 7 working days are reported to be received, about 60 working days are received to be rectified to be checked, or about 7 working days are rectified to be checked, otherwise, an out-of-date prompt is sent. And (3) writing an algorithm aiming at system problems such as logic conflict, data repetition, data abnormality, topology abnormality and the like, establishing a study and judgment mechanism of the topology abnormality and the data conflict, carrying out problem check on the current day of investigation result data every day, and carrying out quality check on all the investigation result data every month until investigation and acceptance.
In the step (7), the data are quantitatively scored by writing an algorithm, the problem affecting the score is marked, the data can be put into a data center only after the data are changed below a certain score, and the algorithm is as follows:
the full score of the comprehensive score is 100 minutes, and x is the total number of the pipe wells; ai is a problem; bi is the question weight.
Furthermore, the written standard interface can conveniently, efficiently and safely share the data to the data processing platform, so that the data acquisition difficulty of the data processing platform is reduced. According to the RESTful API rules, the API is written. The standard interface is the basis of all RESTful Web service designs. Which means that the server transmits information in a standard format. The formatted resources are referred to as tokens in REST. This format may be different from the internal characterization of the resources on the server application. The server may temporarily extend or customize the client functionality by transmitting software programming code to the client.
Further, for the step (2), the water service system data collected by the field includes geophysical prospecting data, measurement data, detection data and thematic service data.
Further, for the step (2), the data acquisition object of the water service system of the field industry comprises space elements of the drain pipe point, the drain pipe line and the drain surface, and comprises space topological association relations among the drain pipe point, the drain pipe line and the drain surface.
Because the drainage facilities are represented by the drainage pipe points, the drainage pipelines, the drainage surfaces and the spatial topological association relation among the drainage pipelines, the drainage facilities are not represented by the point features and the accessories, the connection among the pipe networks, the pipelines and the pipe points can be better understood, and the high-efficiency rendering of the water service space data in a large quantity is satisfied. Meanwhile, the association relation between the spatial elements and the spatial topology is basic data for constructing the three-dimensional platform.
Further, for the step (2), collecting water service system data is input through sensors, monitoring instruments and manual work.
Further, for the step (3), the preprocessing includes cleaning, denoising and supplementing the data. The data is preprocessed to ensure the accuracy and the integrity of the data.
Further, for the step (4), the normalization processing includes normalization of data format, form format, service distribution rule, rendering annotation style, database and table division rule, and image data storage rule. Normalizing the above ensures consistency and comparability of the data. The design specification rendering legend not only comprises national standard type specifications, but also makes more subdivided design diagrams for different facility subclasses.
Further, for the step (6), the data center adopts a distributed architecture to divide the warehouse-in standardized data into warehouse-in and table, and two sets of global unique codes are provided according to the corresponding space type of the facility, one set of global unique codes is a geophysical prospecting code which accords with the acquisition specification, and the other set of global unique codes is a self-increasing global unique code of a block management system.
The data center adopts a distributed architecture to increase the fault tolerance and availability of the system, and even if one node fails, the system can still work continuously, and also to enhance the expansibility of the system, when the data volume increases, more nodes can be simply added to expand the storage and processing capacity without reconstructing the whole system.
Two coding principles are adopted to meet the service requirement. The geophysical prospecting code is an application which meets the requirement of a design unit on investigation results of water facilities; the self-increasing global unique code of the block management system is used for defining the data attribution relation and avoiding the confusion of codes.
Further, for the step (8), the conventional Word, excle, dwg, tif, img, lrp format water affair basic data is subjected to data management according to the file storage standard, and then the water affair basic data result is completely compiled through a unified storage tool, so that the standard CAD, the standard Excle, the standard Word and the image data are derived.
Further, for the step (9), the data processing platform comprises a data display platform, a data analysis platform and a data acquisition platform.
Further, for the step (9), the data processing platform further comprises a three-dimensional platform, and the data center outputs the three-dimensional data to the three-dimensional platform.
The data center writes the output interface according to RESTful API rules, and conveniently, efficiently and completely shares the data to the three-dimensional platform.
The foregoing description is only of the preferred embodiments of the present invention and is not intended to limit the technical scope of the present invention, so that any minor modifications, equivalent changes and modifications made to the above embodiments according to the technical principles of the present invention still fall within the scope of the technical solutions of the present invention.
Claims (10)
1. The implementation method of the real-time online sharing application mechanism of the water service facility investigation result is characterized by comprising the following steps:
(1) Determining field acquisition standards, data warehousing standards and file warehousing standards by referring to related water service facility investigation specifications and service requirements;
(2) The data of the water service system is collected in a standardized way by the field collection standard;
(3) Preprocessing water service system basic data collected by field industry;
(4) Carrying out standardized processing on the pretreated water service system basic data through a data warehouse-in standard;
(5) Auditing the standardized water service system basic data;
(6) A data flow mechanism of problem feedback and data cleaning is adopted to construct a dynamic data center, and standardized data passing the verification is put into the data center;
(7) Establishing a data quality evaluation system according to the data warehousing standard, wherein the data quality evaluation system constrains a data center;
(8) Determining a standard result pattern derived by a data center through an archive storage standard;
(9) The data center is connected with the data processing platform through a written standard interface to carry out data sharing and collaborative editing.
2. The method for implementing the real-time online sharing application mechanism for water service facility investigation results according to claim 1, wherein for the step (7), the process of establishing the data quality evaluation system is as follows: performing system problem study and judgment and manual problem addition on the investigation result, performing online correction, ensuring data quality, aiming at the manual problems of pipe network integrity rate abnormality, rain and sewage attribute abnormality and inspection well position abnormality, prescribing about 7 working days from reporting to receiving, about 60 working days from receiving and rectifying to checking about 7 working days, otherwise, sending out-of-date reminding, writing an algorithm aiming at the system problems of logic conflict, data repetition, data abnormality and topology abnormality, establishing a research and judgment mechanism of topology abnormality and data conflict, carrying out problem checking on the current day of investigation result data every day, and carrying out quality checking on all the investigation result data every month until investigation and acceptance.
3. The method for realizing the real-time online sharing application mechanism of the water service facility investigation result according to claim 2, wherein the method is characterized in that an algorithm is written to quantitatively score data, mark the problem affecting the score, and the data can be put into a data center only after the problem is changed below a certain score, and the algorithm is as follows:
the full score of the comprehensive score is 100 minutes, and x is the total number of the pipe wells; ai is a problem; bi is the question weight.
4. The real-time online sharing application mechanism of water service facility investigation results according to claim 1, wherein for the step (2), the water service system data acquisition object of the field industry comprises space elements of drain pipe points, drain pipes and drain surfaces, and comprises space topological association relations among the drain pipe points, the drain pipes and the drain surfaces.
5. The method for implementing the real-time online sharing application mechanism for water service facility investigation results according to claim 1, wherein for the step (6), the problem feedback: aiming at the problems of abnormal pipe network integrity rate, abnormal rain and sewage properties, abnormal inspection well position, doubtful topology information and the like, the data correction service in the whole process of adding, collecting, correcting and checking the problems is provided;
data cleaning: the dirty data is converted into data meeting the data quality requirement by utilizing the clearing rules of mathematical statistics, data mining, anomaly detection and repeated processing, wherein the dirty data comprises misspellings, naming habits, illegal values and null values.
6. The method for implementing the real-time online sharing application mechanism for water service facility investigation results according to claim 1, wherein for the step (4), the standardization process comprises standardization of data format, form format, service release rule, rendering annotation style, database and table division rule and image data storage rule.
7. The method for realizing the real-time online sharing application mechanism of the water service facility investigation result according to claim 1, wherein for the step (6), a data center adopts a distributed architecture to divide the standardized data in storage into a library and a table, two sets of global unique codes are provided according to the corresponding space type of the facility, one set is a geophysical prospecting code which accords with the acquisition specification, and the other set is a self-increasing global unique code of a block management system.
8. The method for realizing the real-time online sharing application mechanism of the water service facility investigation result according to claim 1, wherein for the step (8), the conventional word, excle, dwg, tif, img, lrp format water service basic data is subjected to data management according to the archival storage standard, and then the water service basic data result is completed through a unified storage tool, so that the standard CAD, the standard Excle, the standard word and the image data are derived.
9. The method for implementing the real-time online sharing application mechanism for water service facility investigation results according to claim 1, wherein for the step (9), the data processing platform comprises a data display platform, a data analysis platform and a data acquisition platform.
10. The method for implementing the real-time online sharing application mechanism of the water service facility investigation result according to claim 1, wherein for the step (9), the data processing platform further comprises a three-dimensional platform, and the data center outputs the three-dimensional data to the three-dimensional platform for production and processing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311336351.5A CN117453782A (en) | 2023-10-16 | 2023-10-16 | Implementation method of real-time online sharing application mechanism for water service facility investigation result |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311336351.5A CN117453782A (en) | 2023-10-16 | 2023-10-16 | Implementation method of real-time online sharing application mechanism for water service facility investigation result |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117453782A true CN117453782A (en) | 2024-01-26 |
Family
ID=89579031
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311336351.5A Pending CN117453782A (en) | 2023-10-16 | 2023-10-16 | Implementation method of real-time online sharing application mechanism for water service facility investigation result |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117453782A (en) |
-
2023
- 2023-10-16 CN CN202311336351.5A patent/CN117453782A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107194621B (en) | Water supply network management system and method | |
| CN105678481B (en) | A kind of pipeline health state evaluation method based on Random Forest model | |
| CN105117573B (en) | Auto hydraulic model building method based on CAD drainage pipeline networks drawing informations | |
| KR102056320B1 (en) | Smart Plant Multidimensional Space 3D Piping Design Collaboration System | |
| CN112231333A (en) | Ecological environment data sharing and exchanging method and system | |
| CN107766415B (en) | The inefficient industrial land method for quickly identifying in cities and towns based on electricity consumption data | |
| CN104135521A (en) | Method and system of identifying data abnormal values of environment automatic monitoring network | |
| CN111612301A (en) | Weight self-adjustment-based gas buried pipeline leakage risk assessment method and device | |
| CN112050092A (en) | Water supply pipe network leakage information management system, building method and application | |
| CN113050472A (en) | Intelligent zero-direct-discharge dynamic sewage supervision system based on pipe network early warning analysis technology | |
| CN111191330B (en) | Method and system for problem discovery in pipeline integrated design | |
| CN115345078B (en) | Cable management method and device based on cable iteration model | |
| CN117453782A (en) | Implementation method of real-time online sharing application mechanism for water service facility investigation result | |
| CN115577005A (en) | Digital management method, system and storage medium for mountain pipeline data | |
| CN115795768A (en) | Pipe network three-dimensional modeling and data updating method and system considering entity morphology | |
| CN115577424A (en) | Method, device, equipment and storage medium for calculating construction engineering quantity | |
| CN110705018B (en) | Water supply pipeline pipe burst positioning method based on hot line work order and pipeline health assessment | |
| CN114117694A (en) | Method, device and equipment for laying pressure monitoring points of water supply network | |
| CN112488805A (en) | Long-renting market early warning method based on multiple regression time series analysis | |
| CN112814111B (en) | Drainage pipeline positioning method based on probability | |
| CN110942354A (en) | Big data algorithm-based automatic calculation method for rail transit engineering cost index | |
| CN110991086B (en) | Water supply pipe network hydraulic model water leakage amount distribution method | |
| CN113886999B (en) | Method for quickly establishing drainage model and GIS (geographic information System) data through CAD (computer aided design) data | |
| MP | BIM and GIS integrated utility supply station location optimization and possibilities | |
| CN114428826A (en) | Spatial data matching method for urban electric power professional pipelines and comprehensive pipelines |
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 |