CN114840627B - Urban underground comprehensive pipe network connectivity analysis method based on GIS + graph database - Google Patents
Urban underground comprehensive pipe network connectivity analysis method based on GIS + graph database Download PDFInfo
- Publication number
- CN114840627B CN114840627B CN202210571507.7A CN202210571507A CN114840627B CN 114840627 B CN114840627 B CN 114840627B CN 202210571507 A CN202210571507 A CN 202210571507A CN 114840627 B CN114840627 B CN 114840627B
- Authority
- CN
- China
- Prior art keywords
- gis
- graph database
- pipe network
- pipe
- pipeline
- 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.)
- Active
Links
Images
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/29—Geographical information databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/54—Browsing; Visualisation therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
- G06F16/587—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually using geographical or spatial information, e.g. location
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T15/00—3D [Three Dimensional] image rendering
- G06T15/005—General purpose rendering architectures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T17/00—Three dimensional [3D] modelling, e.g. data description of 3D objects
- G06T17/05—Geographic models
-
- 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
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention relates to a GIS (geographic information system) + graph database-based urban underground comprehensive pipe network connectivity analysis method, which relates to pipe network connectivity analysis.
Description
Technical Field
The invention relates to pipe network connectivity analysis, in particular to a GIS + graph database-based urban underground comprehensive pipe network connectivity analysis method.
Background
When the pipe network simulation calculation is carried out, the connectivity of the pipe network needs to be ensured, when the scale of the pipe network is large, the manual judgment of the pipe network connectivity by design or operation and maintenance personnel becomes very difficult, a computer means is needed for analyzing the pipe network connectivity, and meanwhile, the analysis result is visually displayed through a human-computer interaction interface.
The existing pipe network data is stored in a relational database, and the connectivity of the pipe network is analyzed by adopting an SQL recursive query mode. In the scheme, the connection of the database needs to be opened and closed frequently, and the recursive calculation is used, so that the processing time and the server performance are consumed greatly, and the method is only suitable for the data analysis of the urban underground pipe network with small data volume. The method is generally applied to analytical calculation of a treatment scale below 10000 tube segments.
Alternatively, a single query of all data is used. A plurality of binary trees (pipe network topological structures) are constructed in the memory through traversal data, and then the pipe network connectivity is analyzed through a corresponding binary tree traversal method. In this scheme, a large amount of data needs to be loaded into the memory at one time, and two traversals are needed, which has high requirements on the memory and the network, and is generally applied to the analysis and calculation with a processing scale below 100000 pipe segments.
The existing pipe network connectivity analysis result shows that geographical position information is lost by using the position of a pipe network topological structure, corresponding connection relation and pipe network subsection relation cannot be visually shown, and the problems of larger transmission data volume and slow rendering exist.
Disclosure of Invention
The technical problems solved by the invention are as follows: the urban underground comprehensive pipe network connectivity analysis method based on the GIS + graph database solves the problems that the pipe network connectivity analysis in the prior art is large in transmission data volume, and the analysis result cannot visually display the geographic position.
The invention adopts the technical scheme for solving the technical problems that: the urban underground comprehensive pipe network connectivity analysis method based on the GIS + graph database comprises the following steps:
s01, importing pipeline detection and measurement result data into a graph database, wherein the graph database is used for storing pipe point basic information and pipeline flow direction relation data;
s02, the GIS system inquires pipelines and pipeline points with connection relations and pipeline flow directions through a graph database, and loads inquiry results into an urban map of the GIS system;
s03, screening out management point basic information and pipeline flow direction relation data which meet the service requirements according to the service requirements;
and S04, rendering the screening result in the city map by the GIS system, and displaying the rendering result to the user.
Further, the management point basic information includes a management point number;
and further, the GIS system renders the screening result on the city map through a mapbox ox.
The invention has the beneficial effects that: according to the urban underground comprehensive pipe network connectivity analysis method based on the GIS + graph database, the information of the pipe point foundation and the pipeline flow direction relation are stored in the graph database, the positions of all the pipe points and the pipelines are loaded into an urban map by using a GIS system, the pipe point foundation information and the pipeline flow direction relation data which meet the business requirements are selected according to the business requirements, the GIS renders the screening results in the urban map, and the rendering results are displayed to users, so that the problems that the pipe network connectivity analysis transmission data size is large and the analysis results cannot visually display the geographic positions in the prior art are solved.
Drawings
FIG. 1 is a flow diagram of the urban underground comprehensive pipe network connectivity analysis method based on a GIS + graph database.
Detailed Description
The invention relates to a GIS + graph database-based urban underground comprehensive pipe network connectivity analysis method, which comprises the following steps as shown in the attached figure 1:
s01, importing pipeline detection and measurement result data into a graph database, wherein the graph database is used for storing basic information of pipe points and pipeline flow direction relation data;
specifically, the management point basic information includes a management point number;
s02, the GIS system inquires pipelines and pipeline points with connection relations and pipeline flow directions through a graph database, and loads the inquiry result into an urban map of the GIS system;
specifically, the city map in the GIS system comprises the positions of all the pipeline points and the pipeline positions, and the query statement can adopt 'match (a: line { Line ID {' ID '}) - [: STREAM _ TO ] - (b: line) return b';
s03, screening out management point basic information and pipeline flow direction relation data which meet the service requirements according to the service requirements;
specifically, the service requirement may be: when a certain pipe point monitors pollution, all pipe sections which are communicated with the pipe point at the upstream of the pipe point are required to be found so as to search a pollution source, and all communicated pipe sections which flow out at the downstream of the pipe point are required to be found so as to analyze where the pollution possibly spreads, so that all the pipe points connected with the pipe point at the upstream and all the pipe points connected with the pipe point at the downstream are screened according to the pipe point.
And S04, rendering the screening result in the city map by the GIS system, and displaying the rendering result to the user.
Specifically, the GIS system renders an upstream pipeline and a downstream pipeline of the pipe points with the pollution monitored in the city map, distinguishes the upstream pipeline and the downstream pipeline by colors different from the colors of the original pipelines, displays the upstream pipeline and the downstream pipeline to a user, the user can visually see the upstream area and the downstream area of the pipe points with the pollution in the city map, and the GIS system renders the upstream pipeline and the downstream pipeline in the city map by adopting a mapbox.
Claims (3)
1. The urban underground comprehensive pipe network connectivity analysis method based on the GIS + graph database is characterized by comprising the following steps of:
s01, importing pipeline detection and measurement result data into a graph database, wherein the graph database is used for storing basic information of pipe points and pipeline flow direction relation data;
s02, the GIS system inquires pipelines and pipeline points with connection relations and pipeline flow directions through a graph database, and loads inquiry results into an urban map of the GIS system;
s03, screening out management point basic information and pipeline flow direction relation data which meet the service requirements according to the service requirements;
and S04, rendering the screening result in the city map by the GIS system, and displaying the rendering result to the user.
2. The GIS + graph database-based connectivity analysis method for urban underground integrated pipe network according to claim 1, wherein the basic information of the pipe points comprises pipe point numbers.
3. The method for analyzing connectivity of an urban underground integrated pipe network based on a GIS + map database according to claim 1, wherein the GIS system renders the screening results on an urban map through a mapbox ox.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210571507.7A CN114840627B (en) | 2022-05-24 | 2022-05-24 | Urban underground comprehensive pipe network connectivity analysis method based on GIS + graph database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210571507.7A CN114840627B (en) | 2022-05-24 | 2022-05-24 | Urban underground comprehensive pipe network connectivity analysis method based on GIS + graph database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114840627A CN114840627A (en) | 2022-08-02 |
| CN114840627B true CN114840627B (en) | 2023-03-21 |
Family
ID=82573079
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210571507.7A Active CN114840627B (en) | 2022-05-24 | 2022-05-24 | Urban underground comprehensive pipe network connectivity analysis method based on GIS + graph database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114840627B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116186187B (en) * | 2023-04-21 | 2023-07-14 | 山东省国土测绘院 | Method, system, medium and equipment for constructing grouping recursion type pipeline combination entity |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102799612A (en) * | 2012-06-14 | 2012-11-28 | 天津大学 | GIS (Geographic Information System)-based comprehensive management system for underground pipelines |
| CN106296815A (en) * | 2015-06-24 | 2017-01-04 | 程昊 | The structure of a kind of interactive three-dimensional digital city and display packing |
| CN107315856A (en) * | 2017-05-27 | 2017-11-03 | 全球能源互联网研究院 | The modeling method and device of a kind of power grid GIS based on chart database |
| CN108597020A (en) * | 2018-01-24 | 2018-09-28 | 苏州星宇测绘科技有限公司 | A kind of three-dimensional underground utilities detection data quick mapping method and system |
| CN109885608A (en) * | 2019-01-25 | 2019-06-14 | 重庆科技学院 | A kind of canal business system of artificial intelligence big data |
| CN112513713A (en) * | 2018-07-23 | 2021-03-16 | 奇跃公司 | System and method for map construction |
| CN113468708A (en) * | 2021-09-06 | 2021-10-01 | 广东电网有限责任公司湛江供电局 | Power distribution network auxiliary planning method and system based on CIM (common information model) |
| CN114139264A (en) * | 2021-12-02 | 2022-03-04 | 中国建筑设计研究院有限公司 | Building water system information-based intelligent operation and maintenance system based on BIM + GIS technology |
| CN114238543A (en) * | 2022-02-21 | 2022-03-25 | 创辉达设计股份有限公司 | Drainage pipe network geographic information system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11093530B2 (en) * | 2019-06-28 | 2021-08-17 | Intel Corporation | Technologies for management of data layers in a heterogeneous geographic information system map |
-
2022
- 2022-05-24 CN CN202210571507.7A patent/CN114840627B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102799612A (en) * | 2012-06-14 | 2012-11-28 | 天津大学 | GIS (Geographic Information System)-based comprehensive management system for underground pipelines |
| CN106296815A (en) * | 2015-06-24 | 2017-01-04 | 程昊 | The structure of a kind of interactive three-dimensional digital city and display packing |
| CN107315856A (en) * | 2017-05-27 | 2017-11-03 | 全球能源互联网研究院 | The modeling method and device of a kind of power grid GIS based on chart database |
| CN108597020A (en) * | 2018-01-24 | 2018-09-28 | 苏州星宇测绘科技有限公司 | A kind of three-dimensional underground utilities detection data quick mapping method and system |
| CN112513713A (en) * | 2018-07-23 | 2021-03-16 | 奇跃公司 | System and method for map construction |
| CN109885608A (en) * | 2019-01-25 | 2019-06-14 | 重庆科技学院 | A kind of canal business system of artificial intelligence big data |
| CN113468708A (en) * | 2021-09-06 | 2021-10-01 | 广东电网有限责任公司湛江供电局 | Power distribution network auxiliary planning method and system based on CIM (common information model) |
| CN114139264A (en) * | 2021-12-02 | 2022-03-04 | 中国建筑设计研究院有限公司 | Building water system information-based intelligent operation and maintenance system based on BIM + GIS technology |
| CN114238543A (en) * | 2022-02-21 | 2022-03-25 | 创辉达设计股份有限公司 | Drainage pipe network geographic information system |
Non-Patent Citations (2)
| Title |
|---|
| T Piuciennik等.Using graph database in spatial data generation.2014,1-8页. * |
| 张喜麟等. 供水管线综合监管"一张图"平台的设计与实现.2020,第48卷(第1期),12-17页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114840627A (en) | 2022-08-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Zhou et al. | Visual abstraction of large scale geospatial origin-destination movement data | |
| CN105022769B (en) | A kind of City Underground Pipeline interactive system and its method | |
| Park et al. | A data warehouse-based decision support system for sewer infrastructure management | |
| AU2019243837A1 (en) | Processing data for predicting pipe failure | |
| CN105550758A (en) | GIS-based underground pipeline operation and maintenance system | |
| CN109508363A (en) | Water conservancy big data service platform and its working method based on GIS | |
| CN202443492U (en) | Data collection system for underground pipeline | |
| CN114840627B (en) | Urban underground comprehensive pipe network connectivity analysis method based on GIS + graph database | |
| CN114238543B (en) | Drainage pipe network geographic information system | |
| CN107103640B (en) | Three-dimensional modeling method and system for urban underground pipeline | |
| CN101719146B (en) | Dynamic graphical method and device of geographic information application and analysis model | |
| CN107704531B (en) | Automatic merging method for road network intersection nodes in OSM map data | |
| CN113570275A (en) | Water resource real-time monitoring system based on BIM and digital elevation model | |
| CN106203787A (en) | The industry information analysis method added based on a figure and system | |
| CN115099315A (en) | Multi-source heterogeneous geographic information data semantic fusion conversion method based on CityGML | |
| KR20000038292A (en) | Device for managing water pipe network | |
| Liao et al. | River environmental decision support system development for Suzhou Creek in Shanghai | |
| Zhu et al. | Research on chinese address resolution model based on conditional random field | |
| Li | Pipeline Spatial Data Modeling and Pipeline WebGIS | |
| KR101545998B1 (en) | Method for Management Integration of Runoff-Hydraulic Model Data and System thereof | |
| CN110298913B (en) | Automatic drainage pipe network model data conversion method based on drainage pipe network planning drawing information | |
| Ponjavic et al. | Spatial data integration in heterogeneous information systems’ environment | |
| CN115309816A (en) | Application construction method, system, equipment and storage medium based on virtual number bin | |
| Wilmer | Application of the radical law in generalization of national hydrography data for multiscale mapping | |
| Shi et al. | The Design and Implementation of Field Patrol Inspection System Based on GPS-Tablet PC |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |