CN115858517A - Pipeline detection database logic detection method and device, electronic equipment and medium - Google Patents
Pipeline detection database logic detection method and device, electronic equipment and medium Download PDFInfo
- Publication number
- CN115858517A CN115858517A CN202211632416.6A CN202211632416A CN115858517A CN 115858517 A CN115858517 A CN 115858517A CN 202211632416 A CN202211632416 A CN 202211632416A CN 115858517 A CN115858517 A CN 115858517A
- Authority
- CN
- China
- Prior art keywords
- inspection
- detection
- pipeline
- drainage
- data
- 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
Images
Landscapes
- Sewage (AREA)
Abstract
The embodiment of the invention provides a pipeline detection database logic detection method, a pipeline detection database logic detection device, electronic equipment and a pipeline detection database logic detection medium, and relates to the field of data processing. Respectively standardizing the drainage pipeline detection data in the pipeline detection database to obtain standardized data with a uniform format; acquiring the detection category of each standardized data, and selecting a conventional logic check item corresponding to the detection category; selecting an additional logical check item; respectively detecting the standardized data according to the conventional logic check item and the additional logic check item, and obtaining a basic detection result and an additional detection result; the base detection result and the additional detection result are determined as a combined detection result. This embodiment is through carrying out logic inspection to secret drainage pipeline detection database, can improve the accuracy of data, is favorable to the later stage to analysis, excavation and the application of drainage pipeline data, still can be used to discover drainage pipe hidden danger and further be applied to cities and towns underground municipal infrastructure safety precaution etc..
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a pipeline detection database logic detection method, a pipeline detection database logic detection device, electronic equipment and a pipeline detection database logic detection medium.
Background
The underdrain data is data that describes the spatial location, spatial relationship, and other characteristic attributes of the underdrain and its attendant facilities. In recent years, urban underground infrastructure is gradually paid attention, underground drainage pipeline detection databases are used as important carriers of pipeline detection data, and logical detection needs to be carried out on the databases so as to improve the production efficiency and quality of projects such as urban underground municipal infrastructure general survey, underground pipeline detailed survey, underground pipeline special detection and the like.
However, the underground drainage pipeline data has the characteristics of being restricted by multiple attributes, complex in relation, different in data obtained by different projects or different in standards and the like, so that the underground drainage pipeline data stored in the pipeline detection database are complex in type and non-uniform in data format, and the detection difficulty is improved. At present, no method for detecting underground drainage pipeline detection data with different formats exists.
Disclosure of Invention
In order to solve the technical problem, embodiments of the present application provide a method and an apparatus for detecting a pipeline detection database logic, an electronic device, and a medium.
In a first aspect, an embodiment of the present application provides a method for detecting a pipeline probe database logic, where the method includes:
acquiring a plurality of drainage pipeline detection data in a pipeline detection database, wherein the initial storage formats of different drainage pipeline detection data are different;
respectively standardizing the detection data of the drainage pipelines to obtain standardized data with uniform format;
acquiring the detection category of each standardized data, and selecting a conventional logic check item corresponding to the detection category;
selecting at least one of drainage pipeline and accessory burial depth inspection, drainage professional field attribute inspection and water supply and drainage pipeline and accessory safety distance comprehensive inspection as an additional logic inspection item;
performing basic class detection on the standardized data according to the conventional logic check item and outputting a basic detection result, and performing additional class detection on the standardized data according to the additional logic check item and outputting an additional detection result;
determining a basic detection result and an additional detection result of each of the drain line detection data as a combined detection result.
In one embodiment, the normalizing the drain line detection data to obtain normalized data with a uniform format includes:
acquiring a data format, a data structure and a data table field of the detection data of each drainage pipeline;
converting the data format of all the drainage pipeline detection data into an mdb format data table;
dividing the data structure of the detection data of each drainage pipeline into a point structure, a line structure and a range structure;
and unifying the names of the data table fields of the drainage pipeline detection data into preset names in a field mapping mode.
In one embodiment, the detection categories include municipal pipeline detection data and cell pipeline detection data, and the routine logic check items include municipal routine check items and cell routine check items;
the acquiring of the detection category of each of the standardized data and the selecting of the regular logical check item corresponding to the detection category includes:
if the detection type is the municipal pipeline detection data, selecting the municipal routine inspection item, wherein the municipal routine inspection item comprises drainage slope inspection, drainage pipe diameter abnormity inspection, hidden point pipe diameter inspection, drainage well material inspection, rainwater drainage port exposure inspection, sewage characteristic accessory name inspection and well body pipeline material consistency inspection;
and if the detection type is the cell pipeline detection data, selecting the cell routine inspection item, wherein the cell routine inspection item comprises drain pipe inspection well distance inspection, riser connection inspection well distance inspection and cell rainwater well distance inspection.
In one embodiment, the performing a base class detection on the normalized data according to the regular logic check item and outputting a base detection result includes:
the performing basic class detection on the standardized data according to the conventional logic check item and outputting a basic detection result includes:
judging whether each conventional logic check item meets a corresponding preset condition or not;
the preset conditions corresponding to the conventional logic check items comprise:
the preset condition corresponding to the drainage slope inspection is that the included angle between the slope of the drainage pipe section and the horizontal plane is smaller than a preset angle;
the drainage pipe diameter abnormity inspection corresponds to a preset condition that the drainage pipe diameter meets a first preset range;
the preset conditions corresponding to the hidden point pipe diameter inspection are that the pipe diameters of the connecting pipe sections on two sides of the preset pipeline point or the detection point are consistent, and the section sizes of the connecting pipe sections on two sides of the preset pipeline point or the detection point are consistent;
the preset condition corresponding to the drainage well material inspection is that if the pipe point is an inspection well, the inspection well meets the material standard;
the corresponding preset condition of the rainwater drainage outlet exposure inspection is that if the rainwater pipe point is a water outlet, the content of an obvious hidden point of the water outlet is not a hidden point;
the preset condition corresponding to the sewage characteristic accessory name inspection is that the sewage pipe point characteristic or the accessory name is not a water outlet or a rain grate;
the preset condition corresponding to the inspection of the consistency of the inspection well body and the pipeline material is that if the pipe point is the inspection well, the well material field content of the inspection well is the same as the material field content of the pipe section connected with the inspection well;
the drain pipe inspection well distance inspection corresponds to a preset condition that when a sewage pipe point and a connecting pipe point of the sewage pipe point are inspection wells, the diameter of a pipe section of the sewage pipe point accords with a second preset range, and the coordinate distance between the two pipe points accords with a third preset range;
the distance between the vertical pipe and the inspection well is inspected according to corresponding preset conditions, if the sewage pipe point is the vertical pipe and the connecting pipe point of the sewage pipe point is the inspection well, the diameter of the pipe section of the sewage pipe point is judged to accord with a fourth preset range, and the coordinate distance between the two pipe points accords with a fifth preset range;
the corresponding preset condition of the interval inspection of the residential quarter rainwater well is that if the residential quarter rainwater pipe point and the residential quarter rainwater pipe point connecting pipe point are inspection wells, the pipe section diameter of the sewage pipe point is judged to accord with a sixth preset range, and the coordinate distance between the two pipe points accords with a seventh preset range;
and outputting a conventional logic check item for detecting the abnormity and warning information.
In one embodiment, the drainage pipeline and attachment burial depth inspection comprises a residential rainwater pipeline burial depth inspection, a drainage well burial depth inspection, a hidden point burial depth inspection and a rainwater port burial depth inspection;
the drainage professional field attribute inspection comprises design service life and structural design safety level inspection, pipeline interface form inspection and access pipe number inspection;
the comprehensive inspection of the safe distance between the water supply and drainage pipe and the accessories comprises vertical clear distance inspection of the water supply and drainage pipe, horizontal clear distance inspection of the water supply and drainage pipe, septic tank distance inspection, municipal rainwater well distance inspection and rainwater port distance inspection.
In one embodiment, the performing an additional class check on the normalized data according to the additional logical check item and outputting an additional detection result includes:
judging whether each additional logic check item meets the corresponding preset condition or not;
if any additional logic check item does not accord with the corresponding preset condition, determining that the additional logic check item has abnormal detection;
additional logical check items and warning information for detecting an abnormality are output.
In a second aspect, an embodiment of the present application provides an apparatus for detecting a logic of a pipeline probe database, where the apparatus includes:
the acquisition module is used for acquiring a plurality of drainage pipeline detection data in the pipeline detection database, wherein the initial storage formats of different drainage pipeline detection data are different;
the standardization module is used for respectively standardizing the detection data of the drainage pipelines to obtain standardized data with uniform formats;
the first selection module is used for acquiring the detection category of each standardized data and selecting a conventional logic check item corresponding to the detection category;
the second selection module is used for selecting at least one of drainage pipeline and accessory burial depth inspection, drainage professional field attribute inspection and comprehensive inspection of safety distances of the drainage pipeline and accessories as an additional logic inspection item;
the detection module is used for carrying out basic class detection on the standardized data according to the conventional logic check item and outputting a basic detection result, and carrying out additional class detection on the standardized data according to the additional logic check item and outputting an additional detection result;
and the determining module is used for determining the basic detection result and the additional detection result of each drainage line detection data as a combined detection result.
In one embodiment, the normalization module is further configured to:
acquiring a data format, a data structure and a data table field of the detection data of each drainage pipeline;
converting the data format of all the drainage pipeline detection data into an mdb format data table;
dividing the data structure of the detection data of each drainage pipeline into a point structure, a line structure and a range structure;
the names of the data table fields of the drainage pipeline detection data are unified into a preset name through a field mapping mode.
In a third aspect, an embodiment of the present application provides an electronic device, which includes a memory and a processor, where the memory is used to store a computer program, and the computer program executes the pipeline probe database logic detection method provided in the first aspect when the processor runs.
In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, which stores a computer program, where the computer program, when executed on a processor, performs the method for detecting logic in a pipeline detection database provided in the first aspect.
The pipeline detection database logic detection method provided by the application provides a solution for drainage underground pipeline detection database logic inspection, innovatively provides a plurality of inspection contents to realize deep inspection of drainage underground pipeline detection data, improves the achievement quality and production efficiency of projects such as urban underground municipal infrastructure general survey, underground pipeline detailed survey and underground pipeline special detection, reduces the time cost of personnel, quickly controls the quality of drainage pipeline detection data, and is quick and effective. In addition, the design and thought of the drainage underground pipeline detection database logic inspection can be widely applied to underground pipeline data acquisition and database construction production, underground pipeline information management system platform construction, underground pipeline data processing system development, underground pipeline detection project supervision and quality inspection software application and the like, and the application is wide.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
FIG. 1 is a flow chart illustrating a method for detecting the logic of a pipeline probe database according to an embodiment of the present application;
FIG. 2 is a schematic flow chart diagram illustrating a method for detecting the logic of a pipeline probe database according to an embodiment of the present application;
fig. 3 shows a schematic structural diagram of a pipeline detection database logic detection apparatus provided in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments.
The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present application, as presented in the figures, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present application without making any creative effort, shall fall within the protection scope of the present application.
Hereinafter, the terms "including", "having", and their derivatives, which may be used in various embodiments of the present application, are intended to indicate only specific features, numerals, steps, operations, elements, components, or combinations of the foregoing, and should not be construed as first excluding the presence of or adding to one or more other features, numerals, steps, operations, elements, components, or combinations of the foregoing.
Furthermore, the terms "first," "second," "third," and the like are used solely to distinguish one from another and are not to be construed as indicating or implying relative importance.
Unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which the various embodiments of the present application belong. The terms (such as those defined in commonly used dictionaries) should be interpreted as having a meaning that is consistent with their contextual meaning in the relevant art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein in various embodiments.
Example 1
The embodiment of the disclosure provides a pipeline detection database logic detection method.
Specifically, referring to fig. 1, the method for detecting the logic of the pipeline probe database includes:
step S110, acquiring a plurality of drainage pipeline detection data in a pipeline detection database, wherein the initial storage formats of the drainage pipeline detection data are different;
with reference to fig. 2, it is shown that in the pipeline general survey detection project according to the embodiment of the present application, the precision check can be performed by sampling check on the obvious pipeline points, the hidden pipeline points, and the like; and the inspection can be carried out by formulating simple quality inspection rules meeting the requirements of comprehensive pipeline mapping, library building and the like.
Different requirements for different projects, different technical specifications and different data standards, or to-be-checked data or data from current situation mapping or historical data and the like can cause different data table fields, different database structures and even different database formats, and further cause that the original data cannot be directly utilized for checking.
Based on this, the embodiment of the present application provides a link of database conversion processing, and by the database conversion processing, redesigning and reprogramming the inspection program for the external source data or the database can be avoided.
Step S120, respectively carrying out standardization processing on the detection data of each drainage pipeline to obtain standardized data with a uniform format;
in one embodiment, the normalizing the drain line detection data to obtain normalized data with a uniform format includes:
acquiring a data format, a data structure and a data table field of the detection data of each drainage pipeline;
converting the data format of all the drainage pipeline detection data into an mdb format data table;
dividing the data structure of the detection data of each drainage pipeline into a point structure, a line structure and a range structure;
and unifying the names of the data table fields of the drainage pipeline detection data into preset names in a field mapping mode.
The database conversion processing includes database format processing, database structure processing, data table field processing, and the like. Firstly, processing a database format, and if the database formats are different, converting the existing database format into an Access mdb database.
Secondly, performing database structure processing, and performing data structure standardization processing on a data table of the mdb database according to a pipeline type + point, a pipeline type + line and a pipeline type + range line, so that database inspection can be conveniently performed by classifying objects according to the classification of the pipelines; the data structure standardization processing means that each type of pipeline (for example, rainwater is a type of pipeline, sewage is a type of pipeline, and confluence is a type of pipeline) performs data organization according to three types of pipeline type + point, pipeline type + line, and pipeline type + range line, for example, rainwater can be three database tables, namely YSPoint, YSLine, and YSAnnexe.
And thirdly, processing the fields of the data table, unifying the names of all the fields, standardizing the names of all the fields in a field mapping mode, and facilitating subsequent classification check of the database and the fields required by all the logic check items. The field mapping manner, for example, provides a field listing an original input and a field listing a target output, and a user performs field mapping and mapping according to needs, for example, a line table field name of a certain kind of pipeline in a database to be subjected to logic inspection may be "pipe diameter", and a line table field name of a target pipeline may be "cross-sectional size".
Step S130, acquiring the detection category of each standardized data, and selecting a conventional logic check item corresponding to the detection category;
and selecting a corresponding inspection mode, namely an inspection item, according to whether the detection type is to detect the municipal pipeline or the community pipeline.
In one embodiment, the detection categories include municipal pipeline detection data and cell pipeline detection data, and the routine logic check items include municipal routine check items and cell routine check items;
the acquiring of the detection category of each of the standardized data and the selecting of the regular logical check item corresponding to the detection category includes:
if the detection type is the municipal pipeline detection data, selecting the municipal routine inspection item, wherein the municipal routine inspection item comprises drainage slope inspection, drainage pipe diameter abnormity inspection, hidden point pipe diameter inspection, drainage well material inspection, rainwater drainage port exposure inspection, sewage characteristic accessory name inspection and well body pipeline material consistency inspection;
and if the detection type is the cell pipeline detection data, selecting the cell routine inspection item, wherein the cell routine inspection item comprises drain pipe inspection well distance inspection, riser connection inspection well distance inspection and cell rainwater well distance inspection.
The municipal routine inspection item comprises the following inspection methods:
and (4) performing drainage slope inspection, namely municipal drainage slope-falling inspection, calculating the slope of the drainage pipe section through the start and end point coordinates of the pipe section, and prompting warning information if the included angle is more than or equal to 20 degrees.
The abnormal inspection of the drainage pipe diameter can use a pipe section meter to calculate half of the pipe diameter (or the section size height), and if the numerical value is larger than the beginning burial depth or the end burial depth, warning information is prompted.
And (4) hidden point pipe diameter inspection, namely comparing and calculating the pipe diameter or section size of the connecting pipe sections at two sides of a preset pipeline point (or detection point), and prompting warning information if the contents are inconsistent.
And (4) inspecting the material of the drainage well, wherein if the pipe points are inspection wells, the well is made of clay bricks or bricks, and warning information is prompted.
And (4) inspecting the exposure of the rainwater outlet, and prompting warning information if the rainwater pipe point is a water outlet and the content of the obvious hidden point is a hidden point.
And (4) inspecting the name of the sewage characteristic attachment, and prompting warning information if the characteristics of the sewage pipe points or the name of the attachment is water outlet or rain grate.
And (4) checking the consistency of the materials of the inspection well body and the pipeline, if the pipe point is the inspection well, prompting warning information when the well material field content of the pipe point is different from the material field content of the connected pipe section.
The cell routine check item comprises the following check methods:
and (3) well spacing inspection of a drain pipe inspection well: the sewage pipe point and the connecting pipe point thereof are not inspected, if the pipe diameter of the pipe section is less than or equal to 160mm, the coordinate distance between the two pipe points is more than 30m, warning information is prompted; if the pipe diameter of the pipe section is more than or equal to 200mm and less than 300mm, the coordinate distance between two pipe points is more than 40m, warning information is prompted; if the pipe diameter of the pipe section is more than or equal to 300mm, the coordinate distance between two pipe points is more than 50m, and warning information is prompted.
And (3) checking the distance between the riser connection inspection wells: the sewage pipe point is a vertical pipe, the connecting pipe point is of an inspection well, and if the pipe diameter of the pipe section is 50mm and the coordinate distance of the two pipe points is more than 10m, warning information is prompted; if the pipe diameter of the pipe section is 75mm, the coordinate distance between two pipe points is greater than 12m, warning information is prompted; if the pipe diameter of the pipe section is 100mm, the coordinate distance between two pipe points is more than 15m, warning information is prompted; if the pipe diameter of the pipe section is larger than 100mm, the coordinate distance between two pipe points is larger than 20m, and warning information is prompted.
Checking the interval of rainwater wells in the residential area: the rainwater pipe points and the connecting pipe points of the residential area are inspection wells, and warning information is prompted if the pipe diameters of the pipe sections are larger than or equal to 200mm and smaller than or equal to 315mm, and the coordinate distance between the two pipe points is larger than 40 m; if the pipe diameter of the pipe section is equal to 400mm, the coordinate distance between two pipe points is more than 50m, warning information is prompted; if the pipe diameter of the pipe section is more than or equal to 500mm, the coordinate distance between two pipe points is more than 70m, and warning information is prompted.
Step S140, selecting at least one of drainage pipeline and accessory burial depth inspection, drainage professional field attribute inspection and comprehensive inspection of safety distance of the drainage pipeline and the accessory as an additional logic inspection item;
because the database inspection and warehousing requirements of different mapping projects are different, all the contents of the three items are not necessarily required to be inspected in actual production, one or more items are inspected according to the actual project requirements and the requirements of production personnel, and at least one of drainage pipeline and accessory burial depth inspection, drainage professional field attribute inspection and comprehensive inspection of safety distances of drainage pipelines and accessories can be selected for additional type inspection.
Step S150, performing basic detection on the standardized data according to the conventional logic check item and outputting a basic detection result, and performing additional detection on the standardized data according to the additional logic check item and outputting an additional detection result;
in one embodiment, the performing the base class detection on the normalized data according to the regular logic check item and outputting a base detection result includes:
judging whether each conventional logic check item meets a corresponding preset condition or not;
if any conventional logic check item does not accord with the corresponding preset condition, determining that the conventional logic check item has abnormal detection;
the preset conditions corresponding to the conventional logic check items comprise:
the preset condition corresponding to the drainage slope inspection is that the included angle between the slope of the drainage pipe section and the horizontal plane is smaller than a preset angle; wherein the preset angle may be 20 °.
The drainage pipe diameter abnormity inspection corresponds to a preset condition that the drainage pipe diameter meets a first preset range; the first predetermined range may be a value less than or equal to the starting point burial depth or the ending point burial depth.
The preset conditions corresponding to the hidden point pipe diameter inspection are that the pipe diameters of the connecting pipe sections on two sides of the preset pipeline point or the detection point are consistent, and the section sizes of the connecting pipe sections on two sides of the preset pipeline point or the detection point are consistent; wherein the predetermined pipeline point is a normal pipeline point.
The preset condition corresponding to the drainage well material inspection is that if the pipe point is an inspection well, the inspection well meets the material standard; wherein, the material standard is not clay brick or brick laying.
The corresponding preset condition of the rainwater drainage outlet exposure inspection is that if the rainwater pipe point is a water outlet, the content of an obvious hidden point of the water outlet is not a hidden point;
the preset condition corresponding to the sewage characteristic accessory name inspection is that the sewage pipe point characteristic or the accessory name is not a water outlet or a rain grate;
the preset condition corresponding to the checking of the consistency of the well body pipeline material is that if the pipe point is the inspection well, the well material field content of the inspection well is the same as the material field content of the pipe section connected with the inspection well;
the drain pipe inspection well distance inspection corresponds to a preset condition that when a sewage pipe point and a connecting pipe point of the sewage pipe point are inspection wells, the diameter of a pipe section of the sewage pipe point accords with a second preset range, and the coordinate distance between the two pipe points accords with a third preset range;
the distance between the vertical pipe and the inspection well corresponds to a preset condition, if the sewage pipe point is the vertical pipe and the connecting pipe point of the sewage pipe point is the inspection well, the diameter of the pipe section of the sewage pipe point is judged to accord with a fourth preset range, and the coordinate distance between the two pipe points accords with a fifth preset range;
the corresponding preset conditions of the interval inspection of the community rainwater wells are that if the community rainwater pipe points and the community rainwater pipe point connecting pipe points are inspection wells, the pipe section diameter of the sewage pipe points is judged to accord with a sixth preset range, and the coordinate distance between the two pipe points accords with a seventh preset range;
the second preset range, the third preset range, the fourth preset range, the fifth preset range, the sixth preset range and the seventh preset range are all shown in the foregoing, and are not described herein again.
And outputting a conventional logic check item for detecting the abnormity and warning information.
And outputting a conventional logic check item for detecting the abnormity and warning information.
In one embodiment, the performing an additional class check on the normalized data according to the additional logical check item and outputting an additional detection result includes:
judging whether each additional logic check item meets the corresponding preset condition or not;
if any additional logic check item does not meet the corresponding preset condition, determining that the additional logic check item has abnormal detection;
additional logical check items and warning information for detecting an abnormality are output.
In one embodiment, the drainage pipeline and attachment burial depth inspection comprises a residential rainwater pipeline burial depth inspection, a drainage well burial depth inspection, a hidden point burial depth inspection and a rainwater port burial depth inspection;
the drainage professional field attribute inspection comprises design service life and structural design safety level inspection, pipeline interface form inspection and access pipe number inspection;
the comprehensive inspection of the safe distance between the water supply and drainage pipe and the accessories comprises vertical clear distance inspection of the water supply and drainage pipe, horizontal clear distance inspection of the water supply and drainage pipe, septic tank distance inspection, municipal rainwater well distance inspection and rainwater port distance inspection.
The detection method for the buried depth of the drainage pipeline and the accessories comprises the following detection methods:
and (3) detecting the buried depth of a rainwater pipeline in a residential area: the road name in the pipe section table is the district name or the district road, and if the burial depth of the starting point or the burial depth of the terminal point of the road name is less than 0.7m, warning information is prompted.
And (3) detecting the buried depth of the drainage well: and judging the inflow and outflow directions of each drainage well by combining the flow direction field, and prompting warning information if the burial depth value of the inflow direction of the drainage well is smaller than the burial depth value of the outflow direction of the drainage well.
Hidden point burial depth inspection: and (3) comparing and calculating the burial depths of the connecting pipe sections at two sides of the preset pipeline point (or detection point), and prompting warning information if the burial depths are inconsistent.
And (3) detecting the buried depth of the rainwater inlet: the accessory name of the starting point or the ending point of the pipe section table is the record of the rain grate, and if the burial depth of the starting point or the burial depth of the ending point is more than 1m, a warning message is prompted.
The drainage professional field attribute inspection comprises the following inspection methods:
checking design service life and structural design safety level: and (3) prompting warning information if the content of the field of the design service life is less than 50 years or the content of the structural design safety level is less than two levels in the drainage pipe section with the drainage pipe diameter of more than or equal to 200mm or the square ditch of more than or equal to 400x400mm in the pipe section table.
Checking the form of the pipeline interface: the content of the seismic fortification intensity field in the pipe section table is a drainage pipe section with the intensity of 7 degrees or more, and warning information is prompted if the content of the pipe interface type field is not a flexible interface.
Checking the number of access pipes: the auxiliary object is a pipe point of the inspection well, the number and the pipe diameter of the pipe sections connected with the pipe point are counted on a pipe section meter, and when the pipe diameter is larger than 300mm and the number of the pipe sections connected with the pipe is larger than 3, warning information is prompted.
The comprehensive inspection of the safe distance between the water supply and drainage pipe and accessories comprises the following inspection methods:
and (3) checking the vertical clear distance of the water supply and drainage pipe: calculating the vertical clear distance between each section of the water discharging pipeline and the adjacent water feeding pipe, and prompting warning information when the distance between the outer wall clear distances is less than or equal to 0.4 m;
and (3) checking the horizontal clear distance of the water supply and drainage pipe: calculating the horizontal clear distance between each section of the water supply pipeline and the water supply pipe nearby, and prompting warning information when the pipe diameter of the water supply pipeline section is less than or equal to 200mm and the distance between the outer wall clear distances is less than or equal to 1 m; when the pipe diameter of the water supply pipe section is larger than 200mm and the distance between the outer walls is smaller than or equal to 1.5m, warning information is prompted;
and (3) inspecting the distance between the septic tanks: when the drainage pipe point is a septic tank, calculating the plane distance between the coordinates of the septic tank point and the coordinates of the underground water taking structure pipe point or the water storage tank pipe point, and when the distance is less than 30m, prompting warning information;
municipal rainwater well interval inspection: municipal rainwater or rain and sewage collecting pipe points and connecting pipe points thereof are not inspected, and warning information is prompted if the pipe section diameter or section size of the pipe section is larger than or equal to 200mm and smaller than or equal to 400mm, and the coordinate distance between the two pipe points is larger than 50 m; if the pipe diameter of the pipe section is more than or equal to 500mm and less than or equal to 700mm and the coordinate distance of two pipe points is more than 70m, warning information is prompted; if the pipe diameter of the pipe section is more than or equal to 800mm and less than or equal to 1000mm, the coordinate distance between two pipe points is more than 90m, warning information is prompted;
and (3) inspecting the space between the rainwater inlets: the name of the rainwater pipe point attachment is rain grate, the length of the pipe section between the coordinates of the rainwater pipe point attachment and the coordinates of the connecting pipe point is calculated, and warning information is prompted if the distance is larger than 25 m.
In step S160, the basic detection result and the additional detection result of each of the drain line detection data are determined as a combined detection result.
Finally, a combined test result is output, which includes the base test result and the additional test result.
The embodiment of the application aims at secondary deep excavation of underground drainage pipeline detection data, internal logic rules are explored, deep and fine inspection contents of the drainage pipeline data are researched, and more hidden errors can be found. Based on data analysis, the drainage underground pipeline detection database is used as a research object, the data inspection content of the drainage professional pipeline is improved and optimized, and the design and practice of the deep and fine inspection content of the drainage pipeline are carried out. By improving and deepening the inspection content of the urban underground drainage pipeline detection database, the production efficiency and the data quality of the drainage underground pipeline detection project are improved.
Through the inspection of the drainage pipeline detection database, the deep mining and application of the drainage pipeline data in the later period, which are restricted by the accuracy of the data, are reduced as much as possible. On the basis, other problems such as the quality of drainage pipeline construction, whether the drainage pipeline construction meets the design specification of pipeline engineering and the like can be further found in an auxiliary mode through inspection; the hidden danger of the water supply and drainage pipeline can be found through data analysis, the detection data of the water drainage pipeline is further applied to urban underground infrastructure safety and urban road safety early warning, the sponge city construction effect can be evaluated according to the pipeline condition, and the sponge city underground municipal infrastructure construction can be better served.
The method for logically detecting the pipeline detection database provided by the embodiment provides a solution for logically detecting the drainage underground pipeline detection database, innovatively provides a plurality of detection contents to realize the deepened detection of drainage underground pipeline detection data, improves the achievement quality and the production efficiency of projects such as urban underground municipal infrastructure general survey, underground pipeline detailed survey, underground pipeline special detection and the like, reduces the time cost of personnel, quickly controls the quality of the drainage pipeline detection data, and is quick and effective. In addition, the design and thought of the deep inspection of the drainage underground pipeline detection database can be widely applied to underground pipeline data acquisition and database construction production, underground pipeline information management system platform construction, underground pipeline data processing system development, underground pipeline detection project supervision and quality inspection software application and the like, and the application is wide.
Example 2
In addition, the embodiment of the disclosure provides a pipeline detection database logic detection device.
Specifically, as shown in fig. 3, the pipeline probing database logic detecting apparatus 300 includes:
an obtaining module 310, configured to obtain multiple drainage line detection data in a line detection database, where initial storage formats of the drainage line detection data are different;
the standardization module 320 is used for respectively standardizing the detection data of the drainage pipelines to obtain standardized data with a uniform format;
a first selection module 330, configured to obtain a detection category of each of the normalized data, and select a regular logic check item corresponding to the detection category;
the second selection module 340 is used for selecting at least one of drainage pipeline and accessory burial depth inspection, drainage professional field attribute inspection and comprehensive inspection of safety distance of the drainage pipeline and accessories as an additional logic inspection item;
a detection module 350, configured to perform a basic class detection on the standardized data according to the regular logic check item and output a basic detection result, and perform an additional class check on the standardized data according to the additional logic check item and output an additional detection result;
a determining module 360 for determining a basic detection result and an additional detection result of each of the drain line detection data as a combined detection result.
The normalization module 320 is further configured to:
acquiring a data format, a data structure and a data table field of the detection data of each drainage pipeline;
converting the data format of all the drainage pipeline detection data into an mdb format data table;
dividing the data structure of the detection data of each drainage pipeline into a point structure, a line structure and a range structure;
the names of the data table fields of the drainage pipeline detection data are unified into a preset name through a field mapping mode.
The pipeline probing database logic detection apparatus 300 provided in this embodiment may implement the pipeline probing database logic detection method provided in embodiment 1, and for avoiding repetition, details are not described herein again.
The pipeline detection database logic detection device provided by the embodiment provides a solution for drainage underground pipeline detection database logic detection, and innovatively realizes deepened detection of drainage underground pipeline detection data by multiple detection contents, so that the achievement quality and the production efficiency of projects such as urban underground municipal infrastructure general survey, underground pipeline detailed survey, underground pipeline special detection and the like are improved, the time cost of personnel is reduced, the quality of drainage pipeline detection data is quickly controlled, and the method is quick and effective. In addition, the design and thought of the deep inspection of the drainage underground pipeline detection database can be widely applied to underground pipeline data acquisition and database construction production, underground pipeline information management system platform construction, underground pipeline data processing system development, underground pipeline detection project supervision and quality inspection software application and the like, and the application is wide.
Example 3
Furthermore, an embodiment of the present disclosure provides an electronic device, including a memory and a processor, where the memory stores a computer program, and the computer program executes the pipeline probe database logic detection method provided in embodiment 1 when running on the processor.
The electronic device provided in the embodiment of the present invention may implement the pipeline detection database logic detection method provided in embodiment 1, and is not described herein again to avoid repetition.
The electronic equipment provided by the embodiment provides a solution for logical inspection of the drainage underground pipeline detection database, innovatively creates multiple inspection contents to realize deep inspection of drainage underground pipeline detection data, improves the achievement quality and the production efficiency of projects such as urban underground municipal infrastructure general survey, underground pipeline detailed survey and underground pipeline special survey, reduces the time cost of personnel, quickly controls the quality of drainage pipeline detection data, and is quick and effective. In addition, the design and thought of the deep inspection of the drainage underground pipeline detection database can be widely applied to underground pipeline data acquisition and database construction production, underground pipeline information management system platform construction, underground pipeline data processing system development, underground pipeline detection project supervision and quality inspection software application and the like, and the application is wide.
Example 4
The present application also provides a computer-readable storage medium on which a computer program is stored, which, when executed by a processor, implements the pipeline probe database logic detection method provided in embodiment 1.
In this embodiment, the computer-readable storage medium may be a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk.
The computer-readable storage medium provided in this embodiment may implement the method for detecting the logic of the pipeline probe database provided in embodiment 1, and is not described herein again to avoid repetition.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or terminal. Without further limitation, an element defined by the phrases "comprising a component of' 8230; \8230;" does not exclude the presence of additional like elements in the process, method, article, or terminal that comprises the element.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present application or portions thereof that contribute to the prior art may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal (which may be a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present application.
While the present embodiments have been described with reference to the accompanying drawings, it is to be understood that the invention is not limited to the precise embodiments described above, which are meant to be illustrative and not restrictive, and that various changes may be made therein by those skilled in the art without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (10)
1. A method for pipeline probe database logic inspection, the method comprising:
acquiring a plurality of drainage pipeline detection data in a pipeline detection database, wherein the initial storage formats of different drainage pipeline detection data are different;
respectively standardizing the detection data of the drainage pipelines to obtain standardized data with uniform format;
acquiring the detection category of each standardized data, and selecting a conventional logic check item corresponding to the detection category;
selecting at least one of drainage pipeline and accessory burial depth inspection, drainage professional field attribute inspection and water supply and drainage pipeline and accessory safety distance comprehensive inspection as an additional logic inspection item;
performing basic class detection on the standardized data according to the conventional logic check item and outputting a basic detection result, and performing additional class detection on the standardized data according to the additional logic check item and outputting an additional detection result;
determining a basic detection result and an additional detection result of each of the drain line detection data as a combined detection result.
2. The method for detecting the logic of the pipeline detection database according to claim 1, wherein the step of respectively standardizing the detection data of the drainage pipelines to obtain standardized data with a uniform format comprises the following steps:
acquiring a data format, a data structure and a data table field of the detection data of each drainage pipeline;
converting the data format of all the drainage pipeline detection data into an mdb format data table;
dividing the data structure of the detection data of each drainage pipeline into a point structure, a line structure and a range structure;
and unifying the names of the data table fields of the detection data of the drainage pipelines into preset names in a field mapping mode.
3. The pipeline probe database logic detection method according to claim 1, wherein the probe categories include municipal pipeline probe data and cell pipeline probe data, and the routine logic check items include municipal routine check items and cell routine check items;
the acquiring of the detection category of each of the standardized data and the selecting of the regular logical check item corresponding to the detection category includes:
if the detection type is the municipal pipeline detection data, selecting the municipal routine inspection item, wherein the municipal routine inspection item comprises drainage slope inspection, drainage pipe diameter abnormity inspection, hidden point pipe diameter inspection, drainage well material inspection, rainwater drainage port exposure inspection, sewage characteristic accessory name inspection and well body pipeline material consistency inspection;
and if the detection type is the cell pipeline detection data, selecting the cell routine inspection item, wherein the cell routine inspection item comprises drain pipe inspection well distance inspection, riser connection inspection well distance inspection and cell rainwater well distance inspection.
4. The method for detecting the logic of the pipeline detection database according to claim 3, wherein the performing the basic class detection on the standardized data according to the regular logic check item and outputting a basic detection result comprises:
judging whether each conventional logic check item meets a corresponding preset condition or not;
the preset conditions corresponding to the conventional logic check items comprise:
the preset condition corresponding to the drainage slope inspection is that the included angle between the slope of the drainage pipe section and the horizontal plane is smaller than a preset angle;
the drainage pipe diameter abnormity inspection corresponds to a preset condition that the drainage pipe diameter meets a first preset range;
the preset conditions corresponding to the hidden point pipe diameter inspection are that the pipe diameters of the connecting pipe sections on two sides of the preset pipeline point or the detection point are consistent, and the section sizes of the connecting pipe sections on two sides of the preset pipeline point or the detection point are consistent;
the preset condition corresponding to the drainage well material inspection is that if the pipe point is an inspection well, the inspection well meets the material standard;
the corresponding preset condition of the rainwater drainage outlet exposure inspection is that if the rainwater pipe point is a water outlet, the content of an obvious hidden point of the water outlet is not a hidden point;
the preset condition corresponding to the sewage characteristic accessory name inspection is that the sewage pipe point characteristic or the accessory name is not a water outlet or a rain grate;
the preset condition corresponding to the checking of the consistency of the well body pipeline material is that if the pipe point is the inspection well, the well material field content of the inspection well is the same as the material field content of the pipe section connected with the inspection well;
the drain pipe inspection well distance inspection corresponds to a preset condition that when a sewage pipe point and a connecting pipe point of the sewage pipe point are inspection wells, the diameter of a pipe section of the sewage pipe point accords with a second preset range, and the coordinate distance between the two pipe points accords with a third preset range;
the distance between the vertical pipe and the inspection well is inspected according to corresponding preset conditions, if the sewage pipe point is the vertical pipe and the connecting pipe point of the sewage pipe point is the inspection well, the diameter of the pipe section of the sewage pipe point is judged to accord with a fourth preset range, and the coordinate distance between the two pipe points accords with a fifth preset range;
the corresponding preset condition of the interval inspection of the residential quarter rainwater well is that if the residential quarter rainwater pipe point and the residential quarter rainwater pipe point connecting pipe point are inspection wells, the pipe section diameter of the sewage pipe point is judged to accord with a sixth preset range, and the coordinate distance between the two pipe points accords with a seventh preset range;
and outputting a conventional logic check item for detecting the abnormity and warning information.
5. The pipeline exploration database logic detection method of claim 1, wherein said drainage pipeline and appurtenance burial depth inspections comprise a community rainwater pipeline burial depth inspection, a drainage well burial depth inspection, a hidden point burial depth inspection, and a rainwater port burial depth inspection;
the drainage professional field attribute inspection comprises design service life and structural design safety level inspection, pipeline interface form inspection and access pipe number inspection;
the comprehensive inspection of the safe distance between the water supply and drainage pipe and the accessories comprises vertical clear distance inspection of the water supply and drainage pipe, horizontal clear distance inspection of the water supply and drainage pipe, septic tank distance inspection, municipal rainwater well distance inspection and rainwater port distance inspection.
6. The method for detecting the logic of the pipeline detection database according to claim 5, wherein the performing an additional class check on the normalized data according to the additional logic check item and outputting an additional detection result comprises:
judging whether each additional logic check item meets the corresponding preset condition or not;
if any additional logic check item does not meet the corresponding preset condition, determining that the additional logic check item has abnormal detection;
additional logical check items and warning information for detecting an abnormality are output.
7. A pipeline probe database logic detection apparatus, the apparatus comprising:
the acquisition module is used for acquiring a plurality of drainage pipeline detection data in the pipeline detection database, wherein the initial storage formats of different drainage pipeline detection data are different;
the standardization module is used for respectively standardizing the detection data of the drainage pipelines to obtain standardized data with uniform formats;
the first selection module is used for acquiring the detection category of each standardized data and selecting a conventional logic check item corresponding to the detection category;
the second selection module is used for selecting at least one of drainage pipeline and accessory burial depth inspection, drainage professional field attribute inspection and comprehensive inspection of safety distances of the drainage pipeline and accessories as an additional logic inspection item;
the detection module is used for carrying out basic class detection on the standardized data according to the conventional logic check item and outputting a basic detection result, and carrying out additional class detection on the standardized data according to the additional logic check item and outputting an additional detection result;
and the determining module is used for determining the basic detection result and the additional detection result of each drainage pipeline detection data as a combined detection result.
8. The pipeline probe database logic detection apparatus of claim 7, wherein the normalization module is further configured to:
acquiring a data format, a data structure and a data table field of the detection data of each drainage pipeline;
converting the data format of all the drainage pipeline detection data into an mdb format data table;
dividing the data structure of the detection data of each drainage pipeline into a point structure, a line structure and a range structure;
the names of the data table fields of the drainage pipeline detection data are unified into a preset name through a field mapping mode.
9. An electronic device comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, performs the pipeline probe database logic detection method of any of claims 1 to 6.
10. A computer-readable storage medium, characterized in that it stores a computer program which, when run on a processor, performs the pipeline probe database logic detection method of any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211632416.6A CN115858517A (en) | 2022-12-19 | 2022-12-19 | Pipeline detection database logic detection method and device, electronic equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211632416.6A CN115858517A (en) | 2022-12-19 | 2022-12-19 | Pipeline detection database logic detection method and device, electronic equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115858517A true CN115858517A (en) | 2023-03-28 |
Family
ID=85674063
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211632416.6A Pending CN115858517A (en) | 2022-12-19 | 2022-12-19 | Pipeline detection database logic detection method and device, electronic equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115858517A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116673228A (en) * | 2023-05-31 | 2023-09-01 | 深圳职业技术学院 | Pipe selection method for municipal drainage pipeline |
| CN117289355A (en) * | 2023-09-26 | 2023-12-26 | 广东大湾工程技术有限公司 | Underground pipeline detection data processing method |
-
2022
- 2022-12-19 CN CN202211632416.6A patent/CN115858517A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116673228A (en) * | 2023-05-31 | 2023-09-01 | 深圳职业技术学院 | Pipe selection method for municipal drainage pipeline |
| CN117289355A (en) * | 2023-09-26 | 2023-12-26 | 广东大湾工程技术有限公司 | Underground pipeline detection data processing method |
| CN117289355B (en) * | 2023-09-26 | 2024-05-07 | 广东大湾工程技术有限公司 | Underground pipeline detection data processing method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115858517A (en) | Pipeline detection database logic detection method and device, electronic equipment and medium | |
| CN109697333B (en) | Detection method and device of pipeline detection database and electronic equipment | |
| Fenner | Approaches to sewer maintenance: a review | |
| CN109725366B (en) | Method and system for positioning rainwater blocking point | |
| CN105303045A (en) | Linear data association rule mining method for long-distance pipeline | |
| CN111878712A (en) | Method and system for monitoring uniform flow of pipe network | |
| US20130084838A1 (en) | System, method, and apparatus for viewing underground structures | |
| CN111501953A (en) | Exception analysis method, system, medium and equipment for drainage pipe network | |
| CN107817207B (en) | Method for calculating foundation pit permeability coefficient and automatic monitoring device thereof | |
| CN113836622A (en) | Drainage pipe network information management and comprehensive application system based on GIS + BIM | |
| Xu et al. | Diagnosis of pipe illicit connections and damaged points in urban stormwater system using an inversed optimization model | |
| KR102313603B1 (en) | Method and apparatus for designing water supply and sewage network | |
| CN113869649A (en) | Building rubbish recycling method and system and electronic equipment | |
| CN115168520A (en) | Sewage zero-direct-discharge long-acting supervision method, system and medium based on liquid level sensing | |
| CN111191330A (en) | Method and system for problem discovery in pipeline synthesis design | |
| CN114324800A (en) | Drainage pipeline water inflow monitoring method and system and storage medium | |
| CN114331128A (en) | Intelligent water affair management method, system, equipment and medium based on Internet of things | |
| AU2009101272A4 (en) | Asset Management system | |
| Huang et al. | Current Situation of Drainage Pipe Network in China and its Detection Technology: a Brief Review. | |
| Zuo et al. | Urban Pipe Assessment Method and Its Application in Two Chinese Cities | |
| Bairaktaris et al. | Decision-support system for the rehabilitation of deteriorating sewers | |
| CN114880758B (en) | Underground pipeline detection method, device, equipment and storage medium | |
| Cazzaniga et al. | A shared database of underground utility lines for 3D mapping and GIS applications | |
| CN111291485B (en) | Method and system for solving problems found in pipeline integrated design | |
| CN113010522B (en) | Water supply and drainage pipe network surveying method and device, mobile terminal and storage medium |
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 |