CN113780718A - Water affairs industry digital pipe network system based on GIS - Google Patents
Water affairs industry digital pipe network system based on GIS Download PDFInfo
- Publication number
- CN113780718A CN113780718A CN202110841647.7A CN202110841647A CN113780718A CN 113780718 A CN113780718 A CN 113780718A CN 202110841647 A CN202110841647 A CN 202110841647A CN 113780718 A CN113780718 A CN 113780718A
- Authority
- CN
- China
- Prior art keywords
- layer
- pipeline
- gis
- coding
- level
- 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.)
- Granted
Links
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 title claims abstract description 99
- 238000000034 method Methods 0.000 claims abstract description 16
- 238000004458 analytical method Methods 0.000 claims description 49
- 238000009933 burial Methods 0.000 claims description 24
- 230000032683 aging Effects 0.000 claims description 19
- 238000010276 construction Methods 0.000 claims description 15
- 239000000463 material Substances 0.000 claims description 15
- 239000003086 colorant Substances 0.000 claims description 9
- 230000004048 modification Effects 0.000 claims description 4
- 238000012986 modification Methods 0.000 claims description 4
- 238000012217 deletion Methods 0.000 claims description 3
- 230000037430 deletion Effects 0.000 claims description 3
- 230000003993 interaction Effects 0.000 claims description 3
- 238000012163 sequencing technique Methods 0.000 claims description 2
- 230000000007 visual effect Effects 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 7
- 230000000694 effects Effects 0.000 description 3
- 238000007792 addition Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000005086 pumping Methods 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06311—Scheduling, planning or task assignment for a person or group
-
- 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
- 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/103—Workflow collaboration or project management
-
- 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/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Water Supply & Treatment (AREA)
- Development Economics (AREA)
- Public Health (AREA)
- General Health & Medical Sciences (AREA)
- Remote Sensing (AREA)
- Primary Health Care (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a GIS (geographic information System) -based digital pipe network system for water industry, which comprises a geospatial database, a pipeline layer, a valve well layer and an equipment layer, wherein the geospatial database is used for storing information of a pump station layer, a water plant layer, a pipeline layer, a valve well layer and the equipment layer; and the GIS management platform is based on a GeoServer data service release module and is used for managing each layer in the geospatial database. The invention has the advantages that: the method realizes the association from a water source to various pump stations, water plants, pipelines, valve wells and equipment in the whole pipe network system by formulating coding rules for the GIS layers of the pump stations, the water plants, the pipelines, the valve wells and the equipment in the water utility pipe network, and the association not only stays on the GIS visual layer, but also is deeper into the linkage between data attributes.
Description
Technical Field
The invention relates to a GIS (geographic information system) -based digital pipe network system for a water service industry, belonging to the technical field of the water service industry.
Background
In the existing GIS-based digital pipe network system in the water service industry, the water conservancy pipe network usually only needs to simply query the information of the pipeline, and the pump station, the water plant, the pipeline, the valve well and the equipment layer contained in the pipe network system usually display the relation among the layers in a GIS layer visualization mode; the analysis function is to simply analyze the buried depth, elevation and age of the pipeline in a text or digital form, and the effect that the pattern of a GIS layer is dynamically changed along with the inquired content is not achieved, and the association of the layer attribute related to a data bottom layer is not made, so that the linkage inquiry and analysis of a plurality of layers cannot be performed; the analysis function is only to simply analyze the buried depth, the elevation and the age of the pipeline in a text or digital mode, and the analysis function is rigid, only certain specific pipeline sections can be analyzed, flexible trend analysis cannot be performed on pipeline data, and visual feeling cannot be achieved.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention sets a set of coding rules for layers of a pump station, a water plant, a pipeline, a valve well and equipment, and realizes the association between each layer and layer data by the way of association between codes. Through the method, the association between the layers can not only stay at the visual layer of the GIS, but also go deep into the linkage between the data attributes, so that more complex query and analysis functions can be realized, the practicability and diversity of the system are improved, the GIS system is not used for demonstrating the effect any more, and an operator can better use the system for querying data and analyzing a pipe network. The invention provides a GIS-based digital pipe network system for water business industry, which adopts the technical scheme that:
a GIS-based digital pipe network system for water service industry comprises
The geographical space database is used for storing spatial information and attribute information of a pump station layer, a water plant layer, a pipeline layer, a valve well layer and an equipment layer;
the GIS management platform is based on a GeoServer data service release module and is used for carrying out layer management and service release on each layer in a geospatial database;
the GIS front-end display module is used for extracting layer services issued by a GIS management platform, generating layers of pump stations, water plants, pipelines, valve wells and equipment which are superposed on a map based on a Mapbox engine, and generating a GIS water conservancy digital pipe network map;
the combined query module is used for performing combined query based on the association between the lower layer and the upper layer realized by coding;
the analysis module is used for carrying out buried depth and aging analysis based on a preset combined query condition;
and the geographic space database and the GIS front-end display module realize data interaction through a GIS management platform.
The GIS management platform is an intermediate service management platform connected with a geospatial database and a GIS front-end display module, and the management of the layers comprises the addition, deletion, modification, search and release of layer services.
Spatial information and attribute information of the pump station layer, the water plant layer, the pipeline layer, the valve well layer and the equipment layer are realized through the following modes: the method comprises the steps of importing a CAD pipe network drawing in which pump station information, water plant information, pipeline information, valve well information and equipment information are stored into ArcGIS software to generate a GIS layer, classifying the layers according to the pump station, the water plant, the pipeline, the valve well and the equipment, and sequentially arranging and encoding the layer fields after the layer classification is completed.
The pipeline map layer information comprises pile numbers, longitudes, latitudes, project names, mark section names, ground elevations, pipeline elevations, pipe bottom buried depths, diameters, materials and construction dates; the map layer information of the pump station comprises the name, longitude and latitude of the pump station; the water plant map layer information comprises a water plant name, longitude and latitude; the valve well map layer information comprises a valve well number, longitude, latitude and a valve well type; the equipment layer information comprises an equipment number, longitude, latitude and an equipment type, and a gisCode field is additionally arranged on each of the pipeline layer, the pump station layer, the water plant layer, the valve well layer and the equipment layer and is used for storing coding information.
The step of encoding the GIS layer is as follows:
(1) setting a primary point location code, wherein the primary point location code represents key nodes from a water source to a network system covering the whole network system, and the specific coding rule is as follows: the number of the characters is 4, the characters are composed of types and names, the first digit is English letters, and the A-Z sequence arrangement is used for representing different site types; the second to the fourth bits are numbers which are sequentially arranged from 001 to represent point location sequencing under the site type, the pump station and the water plant layer belong to a first-level point location code, and the first-level point location code is written into gisCode fields of the pump station and the water plant GIS layer;
(2) setting a secondary pipeline code, wherein the secondary pipeline code represents a pipeline section code between a water source place and a key node covering the whole pipe network system, and the specific coding rule is as follows: the number of the characters is 10 bits, and the characters are composed of pipeline types, engineering, mark sections, diameters and materials, wherein the first bit is an English letter, the A-Z sequence is used for representing different pipeline types, and the second to the fourth bits are numbers, and are arranged in sequence from 001 to represent different engineering names; five to six digits are numbers which are arranged from 01 in sequence and are used for representing different mark section names; seven to eight bits are numbers, arranged in order from 01 to represent different pipeline diameters; nine to ten digits are numbers, which are arranged in sequence from 01 to represent different pipeline materials; the pipeline layer belongs to a secondary pipeline code; writing the secondary pipeline code into a gisCode field of a pipeline GIS layer; the difference from the first-level point location coding is that the format of the second-level pipeline coding is as follows: the method comprises the steps of 'first-level point location coding-second-level pipeline coding', namely the second-level pipeline coding needs to comprise the first-level point location coding;
(3) setting a three-level valve well code, wherein the three-level valve well code represents various valve well point positions from a water source place to a position covering the whole pipe network system, and the specific coding rule is as follows: the number of characters is 3 bits, consisting of type + sequence number. The first digit is English letters, the A-Z sequence is used for representing different valve well types, the second digit to the third digit are numbers, and the numbers are sequentially arranged from 01 to represent a plurality of valve wells in the same type; the valve well pattern layer belongs to a three-level valve well code; writing the three-level valve well code into a gisCode field of a valve well GIS layer; the format of the three-stage valve well code is as follows: the method comprises the steps of firstly coding point locations, secondly coding pipelines and thirdly coding valve wells, wherein the thirdly coding valve wells need to comprise the firstly coding point locations and the secondly coding pipelines;
(4) setting four-level equipment codes, wherein the four-level equipment codes represent various equipment point positions from a water source place to a place covering the whole pipe network system, and the specific coding rule is as follows: the number of the characters is 3 bits and consists of a type and a serial number; the first digit is English letter, A-Z sequence is used to represent different device types, two to three digits are numbers, and the numbers are arranged from 01 in sequence to represent a plurality of devices in the same type; the device layer belongs to a four-level device code; writing a four-level equipment code into a gisCode field of an equipment GIS layer; the four-level device code format is: the method comprises the steps of first-level point location coding, second-level pipeline coding, third-level valve well coding and fourth-level equipment coding, wherein the fourth-level equipment coding needs to comprise the first-level point location coding, the second-level pipeline coding and the third-level valve well coding.
The GIS front-end display module is used for storing coded pumping station, water plant, pipeline, valve well and equipment GIS layers into a geospatial database, and independently releasing each layer into a GeoJson format character string for front-end map display and calling by adopting a GeoServer data service release module; and acquiring GeoJson service addresses of all the layers by adopting a Mapbox engine, generating layers of pump stations, water plants, pipelines, valve wells and equipment which are superposed on the map, and generating a GIS water conservancy digital pipe network map.
The query analysis module comprises a combined query module and an analysis module, wherein the combined query module is used for realizing the association between a lower layer and a higher layer by utilizing gisCode fields stored in each GIS layer; inquiring all pipelines under the jurisdiction of a pump station water plant or a water plant, or inquiring all standard sections under the project through a certain project, and inquiring all pipelines under the standard sections through the standard sections; or inquiring all pipelines which meet the diameter or material through different pipeline diameters or materials; inquiring all valve wells below a certain pipeline through the pipeline; querying all equipment installed in a valve well through the valve well; the analysis module is used for buried depth analysis and aging analysis, and the buried depth analysis specifically comprises the following steps: selecting any one section of pipeline or the pipeline inquired by the user-defined combined inquiry condition, and checking the burial depth trend of the inquired pipeline through the burial depth analysis function; the aging analysis specifically comprises the following steps: any one section of pipeline or the pipeline inquired by the user-defined combined inquiry condition is selected, and the aging trend of the inquired pipeline can be checked through the aging analysis function.
The contents inquired by the inquiry module are displayed in the following modes: highlighting a pipeline or point position corresponding to the query content on the map, and displaying the detailed information of the query content in a table in an upper-level and lower-level linkage manner; the information inquired by the upper layer map is automatically associated with the information of the lower layer map, and a multi-stage table from top to bottom from a pump station, a water plant to a pipeline, a pipeline to a valve well and a valve well to equipment is generated.
Inquiring the pipeline corresponding to the content on the map, displaying the burial depths of different pipe sections in a gradient display mode, wherein the colors represent the burial depths from light to dark from light, and analyzing which area of the pipeline is too light according to the pipe section with the deeper color; or displaying the difference and the burial depth trend among the ground elevation, the pipeline elevation and the pipe bottom burial depth of the pipeline corresponding to the query content in a line graph form, and performing burial depth analysis on the ground elevation, the pipeline elevation and the pipe bottom burial depth according to the specific numerical values recorded by each pile number.
The specific display mode of the aging analysis is that pipelines corresponding to the content are inquired on a map, the construction dates of different pipe sections are displayed in a gradient display mode, the colors represent the construction dates from far to near from deep to light, and the pipeline in which area is aged is analyzed according to the pipe sections with the deeper colors; or the construction length of the inquired pipeline in a certain construction period is shown in a form of a histogram.
The invention has the advantages that:
1. the method realizes the association from a water source to various pump stations, water plants, pipelines, valve wells and equipment in the whole pipe network system by formulating coding rules for the GIS layers of the pump stations, the water plants, the pipelines, the valve wells and the equipment in the water utility pipe network, and the association not only stays on the GIS visual layer, but also is deeper into the linkage between data attributes.
2. The defects that the traditional GIS-based digital pipe network system for the water business industry can only perform some simple query and analysis functions are optimized, the data analysis of a specific certain point position or a certain pipe section can be performed in a combined query mode based on formulated coding rules, and the usability and the flexibility of the system are greatly improved.
3. The linkage between the GIS layer style and the data is realized in the aspect of data display, the layer style can be correspondingly changed according to the inquired data, and meanwhile, a chart is introduced to display the inquired data, so that the inquiry result is more visual and detailed, and the intuitiveness of the system is greatly improved.
Drawings
FIG. 1 is a schematic workflow diagram of the present invention.
Fig. 2 is a block diagram of the architecture of the present invention.
FIG. 3 is a schematic diagram of the encoding steps of the present invention.
FIG. 4 is a table diagram of one-level point bit coding of the present invention.
FIG. 5 is a table diagram of the two-level pipeline encoding of the present invention.
FIG. 6 is a tabular representation of three-stage valve well coding of the present invention.
Fig. 7 is a table diagram of the four-level device encoding of the present invention.
Fig. 8 is a schematic diagram illustrating that the association between the upper layer and the lower layer is implemented by using gisCode fields stored in each GIS layer according to the present invention.
FIG. 9 is a graph showing the buried depth analysis generated from the content of a combined query according to the present invention in the form of a line graph.
FIG. 10 is a graph showing an aging analysis generated from the content of a combined query in the form of a line graph according to the present invention.
Detailed Description
The invention will be further described with reference to specific embodiments, and the advantages and features of the invention will become apparent as the description proceeds. These examples are illustrative only and do not limit the scope of the present invention in any way. It will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention, and that such changes and modifications may be made without departing from the spirit and scope of the invention.
Referring to fig. 1 to 10, the present invention relates to a digital pipe network system for water service industry based on a GIS, which includes a geospatial database 1 for storing spatial information and attribute information of a pump station layer, a water plant layer, a pipeline layer, a valve well layer and an equipment layer;
the GIS management platform 2 is based on a GeoServer data service release module and is used for carrying out layer management and service release on each layer in a geospatial database;
the GIS front-end display module 3 is used for extracting layer services issued by a GIS management platform, generating layers of pump stations, water plants, pipelines, valve wells and equipment which are superposed on a map based on a Mapbox engine, and generating a GIS water conservancy digital pipe network map;
the combined query module 4 is used for performing combined query based on the association between the lower layer and the upper layer realized by encoding;
the analysis module 5 is used for carrying out buried depth and aging analysis based on a preset combined query condition;
and the geographic space database and the GIS front-end display module realize data interaction through a GIS management platform.
The GIS management platform 2 is an intermediate service management platform connected with a geospatial database and a GIS front-end display module, and the management of the layers comprises the addition, deletion, modification, search and release of layer services.
Spatial information and attribute information of the pump station layer, the water plant layer, the pipeline layer, the valve well layer and the equipment layer are realized through the following modes: the method comprises the steps of importing a CAD pipe network drawing in which pump station information, water plant information, pipeline information, valve well information and equipment information are stored into ArcGIS software to generate a GIS layer, classifying the layers according to the pump station, the water plant, the pipeline, the valve well and the equipment, and sequentially arranging and encoding the layer fields after the layer classification is completed.
The pipeline map layer information comprises pile numbers, longitudes, latitudes, project names, mark section names, ground elevations, pipeline elevations, pipe bottom buried depths, diameters, materials and construction dates; the map layer information of the pump station comprises the name, longitude and latitude of the pump station; the water plant map layer information comprises a water plant name, longitude and latitude; the valve well map layer information comprises a valve well number, longitude, latitude and a valve well type; the equipment layer information comprises an equipment number, longitude, latitude and an equipment type, and a gisCode field is additionally arranged on each of the pipeline layer, the pump station layer, the water plant layer, the valve well layer and the equipment layer and is used for storing coding information.
The step of encoding the GIS layer is as follows:
(1) setting a primary point location code, wherein the primary point location code represents key nodes from a water source to a network system covering the whole network system, and the specific coding rule is as follows: the number of the characters is 4, the characters are composed of types and names, the first digit is English letters, and the A-Z sequence arrangement is used for representing different site types, such as pump stations and water plants; two to four bits are numbers, which are sequentially arranged from 001 to represent the point location ordering under the site type, please refer to fig. 3, for example, which pump stations (water plants) are under a certain pump station (water plant) type, which are sequentially arranged from 001, the pump station and water plant layers belong to a first-level point location code, and the first-level point location code is written into gisCode fields of the pump station and water plant GIS layers;
(2) setting a secondary pipeline code, wherein the secondary pipeline code represents a pipeline section code between a water source place and a key node covering the whole pipe network system, and the specific coding rule is as follows: the number of the characters is 10 bits, and the characters are composed of pipeline types, engineering, mark sections, diameters and materials, wherein the first bit is an English letter, the A-Z sequence is used for representing different pipeline types, and the second to the fourth bits are numbers, and are arranged in sequence from 001 to represent different engineering names; five to six digits are numbers which are arranged from 01 in sequence and are used for representing different mark section names; seven to eight bits are numbers, arranged in order from 01 to represent different pipeline diameters; nine to ten digits are numbers, which are arranged in sequence from 01 to represent different pipeline materials; the pipeline layer belongs to a secondary pipeline code; writing the secondary pipeline code into a gisCode field of a pipeline GIS layer; the difference from the first-level point location coding is that the format of the second-level pipeline coding is as follows: the method comprises the steps of 'first-level point location coding-second-level pipeline coding', namely the second-level pipeline coding needs to comprise the first-level point location coding;
(3) setting a three-level valve well code, wherein the three-level valve well code represents various valve well point positions from a water source place to a position covering the whole pipe network system, and the specific coding rule is as follows: the number of characters is 3 bits, consisting of type + sequence number. The first digit is English letters, the A-Z sequence is used for representing different valve well types, the second digit to the third digit are numbers, and the numbers are sequentially arranged from 01 to represent a plurality of valve wells in the same type; the valve well pattern layer belongs to a three-level valve well code; writing the three-level valve well code into a gisCode field of a valve well GIS layer; the format of the three-stage valve well code is as follows: the method comprises the steps of firstly coding point locations, secondly coding pipelines and thirdly coding valve wells, wherein the thirdly coding valve wells need to comprise the firstly coding point locations and the secondly coding pipelines;
(4) setting four-level equipment codes, wherein the four-level equipment codes represent various equipment point positions from a water source place to a place covering the whole pipe network system, and the specific coding rule is as follows: the number of the characters is 3 bits and consists of a type and a serial number; the first digit is English letter, A-Z sequence is used to represent different device types, two to three digits are numbers, and the numbers are arranged from 01 in sequence to represent a plurality of devices in the same type; the device layer belongs to a four-level device code; writing a four-level equipment code into a gisCode field of an equipment GIS layer; the four-level device code format is: the method comprises the steps of first-level point location coding, second-level pipeline coding, third-level valve well coding and fourth-level equipment coding, wherein the fourth-level equipment coding needs to comprise the first-level point location coding, the second-level pipeline coding and the third-level valve well coding.
The GIS front-end display module is used for storing coded pumping station, water plant, pipeline, valve well and equipment GIS layers into a geospatial database, managing the layers by adopting a GeoServer data service release module, and independently releasing each layer into a GeoJson format character string for front-end map display and calling; and acquiring GeoJson service addresses of all the layers by adopting a Mapbox engine, generating layers of pump stations, water plants, pipelines, valve wells and equipment which are superposed on the map, and generating a GIS water conservancy digital pipe network map.
The query analysis module comprises a combined query module and an analysis module, wherein the combined query module is used for realizing the association between a lower layer and a higher layer by utilizing gisCode fields stored in each GIS layer; inquiring all pipelines under the jurisdiction of a pump station water plant or a water plant, or inquiring all standard sections under the project through a certain project, and inquiring all pipelines under the standard sections through the standard sections; or inquiring all pipelines which meet the diameter or material through different pipeline diameters or materials; inquiring all valve wells below a certain pipeline through the pipeline; querying all equipment installed in a valve well through the valve well; the analysis module is used for buried depth analysis and aging analysis, and the buried depth analysis specifically comprises the following steps: selecting any one section of pipeline or the pipeline inquired by the user-defined combined inquiry condition, and checking the burial depth trend of the inquired pipeline through the burial depth analysis function; the aging analysis specifically comprises the following steps: any one section of pipeline or the pipeline inquired by the user-defined combined inquiry condition is selected, and the aging trend of the inquired pipeline can be checked through the aging analysis function.
The contents inquired by the inquiry module are displayed in the following modes: highlighting a pipeline or point position corresponding to the query content on the map, and displaying the detailed information of the query content in a table in an upper-level and lower-level linkage manner; the information inquired by the upper layer map is automatically associated with the information of the lower layer map, and a multi-stage table from top to bottom from a pump station, a water plant to a pipeline, a pipeline to a valve well and a valve well to equipment is generated.
Inquiring the pipeline corresponding to the content on the map, and displaying the buried depths of different pipe sections in a gradient display mode, wherein the colors are from deep to light, and the buried depths are from shallow to deep according to the pipe sections with the deeper colors, and the pipeline buried depths in which areas are analyzed to be too shallow are obtained; or displaying the difference and the burial depth trend among the ground elevation, the pipeline elevation and the pipe bottom burial depth of the pipeline corresponding to the query content in a line graph form, and performing burial depth analysis on the ground elevation, the pipeline elevation and the pipe bottom burial depth according to the specific numerical values recorded by each pile number.
The specific display mode of the aging analysis is to display the construction dates of different pipe sections in a gradient display mode by inquiring the pipelines corresponding to the content on the map, wherein the colors represent the construction dates from far to near from deep to light, and the pipeline in which area is aged is analyzed according to the pipe sections with the deeper colors; or the construction length of the inquired pipeline in a certain construction period is shown in a form of a histogram.
Based on the above contents, a set of coding rules is formulated for the layers of the pump station, the water plant, the pipeline, the valve well and the equipment, and the association between each layer and the layer data is realized through the association mode among the codes. Through the method, the association between the layers can not only stay at the visual layer of the GIS, but also go deep into the linkage between the data attributes, so that more complex query and analysis functions can be realized, the practicability and diversity of the system are improved, the GIS system is not used for demonstrating the effect any more, and an operator can better use the system for querying data and analyzing a pipe network.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention should be equivalent or changed within the scope of the present invention.
Claims (10)
1. A GIS-based digital pipe network system for water service industry comprises
The geographical space database is used for storing spatial information and attribute information of a pump station layer, a water plant layer, a pipeline layer, a valve well layer and an equipment layer;
the GIS management platform is based on a GeoServer data service release module and is used for carrying out layer management and service release on each layer in a geospatial database;
the GIS front-end display module is used for extracting layer services issued by a GIS management platform, generating layers of pump stations, water plants, pipelines, valve wells and equipment which are superposed on a map based on a Mapbox engine, and generating a GIS water conservancy digital pipe network map;
the combined query module is used for performing combined query based on the association between the lower layer and the upper layer realized by coding;
the analysis module is used for carrying out buried depth and aging analysis based on a preset combined query condition;
and the geographic space database and the GIS front-end display module realize data interaction through a GIS management platform.
2. The GIS-based digital management system for the water industry and the industry according to claim 1, wherein the GIS management platform is an intermediate service management platform connected with a geospatial database and a GIS front-end display module, and the management of the layers includes layer addition, layer deletion, layer modification, layer search and layer service release.
3. The GIS-based digital pipe network system for the water industry and the industry according to claim 1 or 2, wherein the spatial information and the attribute information of the pump station layer, the water plant layer, the pipeline layer, the valve well layer and the equipment layer are realized in the following way: the method comprises the steps of importing a CAD pipe network drawing in which pump station information, water plant information, pipeline information, valve well information and equipment information are stored into ArcGIS software to generate a GIS layer, classifying the layers according to the pump station, the water plant, the pipeline, the valve well and the equipment, and sequentially arranging and encoding the layer fields after the layer classification is completed.
4. The GIS-based digital pipe network system for the water industry and the industry according to claim 3, wherein the pipe map layer information includes stake number, longitude, latitude, project name, section name, ground elevation, pipe bottom burial depth, diameter, material and construction date; the map layer information of the pump station comprises the name, longitude and latitude of the pump station; the water plant map layer information comprises a water plant name, longitude and latitude; the valve well map layer information comprises a valve well number, longitude, latitude and a valve well type; the equipment layer information comprises an equipment number, longitude, latitude and an equipment type, and a gisCode field is additionally arranged on each of the pipeline layer, the pump station layer, the water plant layer, the valve well layer and the equipment layer and is used for storing coding information.
5. The GIS-based digital pipe network system for the water industry and the industry according to claim 3, wherein the step of encoding the GIS layer is as follows:
(1) setting a primary point location code, wherein the primary point location code represents key nodes from a water source to a network system covering the whole network system, and the specific coding rule is as follows: the number of the characters is 4, the characters are composed of types and names, the first digit is English letters, and the A-Z sequence arrangement is used for representing different site types; the second to the fourth bits are numbers which are sequentially arranged from 001 to represent point location sequencing under the site type, the pump station and the water plant layer belong to a first-level point location code, and the first-level point location code is written into gisCode fields of the pump station and the water plant GIS layer;
(2) setting a secondary pipeline code, wherein the secondary pipeline code represents a pipeline section code between a water source place and a key node covering the whole pipe network system, and the specific coding rule is as follows: the number of the characters is 10 bits, and the characters are composed of pipeline types, engineering, mark sections, diameters and materials, wherein the first bit is an English letter, the A-Z sequence is used for representing different pipeline types, and the second to the fourth bits are numbers, and are arranged in sequence from 001 to represent different engineering names; five to six digits are numbers which are arranged from 01 in sequence and are used for representing different mark section names; seven to eight bits are numbers, arranged in order from 01 to represent different pipeline diameters; nine to ten digits are numbers, which are arranged in sequence from 01 to represent different pipeline materials; the pipeline layer belongs to a secondary pipeline code; writing the secondary pipeline code into a gisCode field of a pipeline GIS layer; the difference from the first-level point location coding is that the format of the second-level pipeline coding is as follows: the method comprises the steps of 'first-level point location coding-second-level pipeline coding', namely the second-level pipeline coding needs to comprise the first-level point location coding;
(3) setting a three-level valve well code, wherein the three-level valve well code represents various valve well point positions from a water source place to a position covering the whole pipe network system, and the specific coding rule is as follows: the number of characters is 3 bits, consisting of type + sequence number. The first digit is English letters, the A-Z sequence is used for representing different valve well types, the second digit to the third digit are numbers, and the numbers are sequentially arranged from 01 to represent a plurality of valve wells in the same type; the valve well pattern layer belongs to a three-level valve well code; writing the three-level valve well code into a gisCode field of a valve well GIS layer; the format of the three-stage valve well code is as follows: the method comprises the steps of firstly coding point locations, secondly coding pipelines and thirdly coding valve wells, wherein the thirdly coding valve wells need to comprise the firstly coding point locations and the secondly coding pipelines;
(4) setting four-level equipment codes, wherein the four-level equipment codes represent various equipment point positions from a water source place to a place covering the whole pipe network system, and the specific coding rule is as follows: the number of the characters is 3 bits and consists of a type and a serial number; the first digit is English letter, A-Z sequence is used to represent different device types, two to three digits are numbers, and the numbers are arranged from 01 in sequence to represent a plurality of devices in the same type; the device layer belongs to a four-level device code; writing a four-level equipment code into a gisCode field of an equipment GIS layer; the four-level device code format is: the method comprises the steps of first-level point location coding, second-level pipeline coding, third-level valve well coding and fourth-level equipment coding, wherein the fourth-level equipment coding needs to comprise the first-level point location coding, the second-level pipeline coding and the third-level valve well coding.
6. The GIS-based digital pipe network system for the water industry and the industry according to claim 1 is characterized in that the GIS front-end display module is used for storing coded layers of a pump station, a water plant, a pipeline, a valve well and equipment GIS into a geospatial database, and a GeoServer data service release module is adopted to independently release each layer into a GeoJson format character string for front-end map display and calling; and acquiring GeoJson service addresses of all the layers by adopting a Mapbox engine, generating layers of pump stations, water plants, pipelines, valve wells and equipment which are superposed on the map, and generating a GIS water conservancy digital pipe network map.
7. The GIS-based digital pipe network system for the water and business industry according to claim 4, wherein the query analysis module comprises a combined query module and an analysis module, the combined query module is used for realizing the association between a lower layer and an upper layer by utilizing gisCode fields stored in each GIS layer; inquiring all pipelines under the jurisdiction of a pump station water plant or a water plant, or inquiring all standard sections under the project through a certain project, and inquiring all pipelines under the standard sections through the standard sections; or inquiring all pipelines which meet the diameter or material through different pipeline diameters or materials; inquiring all valve wells below a certain pipeline through the pipeline; querying all equipment installed in a valve well through the valve well; the analysis module is used for buried depth analysis and aging analysis, and the buried depth analysis specifically comprises the following steps: selecting any one section of pipeline or the pipeline inquired by the user-defined combined inquiry condition, and checking the burial depth trend of the inquired pipeline through the burial depth analysis function; the aging analysis specifically comprises the following steps: any one section of pipeline or the pipeline inquired by the user-defined combined inquiry condition is selected, and the aging trend of the inquired pipeline can be checked through the aging analysis function.
8. The GIS-based water industry digital pipe network system according to claim 7, wherein the inquired contents of the inquiry module are displayed by: highlighting a pipeline or point position corresponding to the query content on the map, and displaying the detailed information of the query content in a table in an upper-level and lower-level linkage manner; the information inquired by the upper layer map is automatically associated with the information of the lower layer map, and a multi-stage table from top to bottom from a pump station, a water plant to a pipeline, a pipeline to a valve well and a valve well to equipment is generated.
9. The GIS-based digital pipe network system for the water industry and the industry according to claim 8, wherein the pipeline corresponding to the inquired contents on the map shows the burial depths of different pipe sections in a gradient display mode, the color represents the burial depth from light to dark from dark to light, and the pipeline burial depth of which area is too light is analyzed according to the pipe section with the deeper color; or displaying the difference and the burial depth trend among the ground elevation, the pipeline elevation and the pipe bottom burial depth of the pipeline corresponding to the query content in a line graph form, and performing burial depth analysis on the ground elevation, the pipeline elevation and the pipe bottom burial depth according to the specific numerical values recorded by each pile number.
10. The GIS-based digital pipe network system for the water industry and the trade industry according to claim 8, wherein the concrete display mode of the aging analysis is to display the construction dates of different pipe sections in a gradient display mode by inquiring the pipelines corresponding to the content on a map, the colors represent that the construction dates are from far to near from deep to light, and which area of the pipelines is more aged is analyzed according to the pipe sections with the deeper colors; or the construction length of the inquired pipeline in a certain construction period is shown in a form of a histogram.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110841647.7A CN113780718B (en) | 2021-07-26 | 2021-07-26 | GIS-based digital pipe network system for water service industry |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110841647.7A CN113780718B (en) | 2021-07-26 | 2021-07-26 | GIS-based digital pipe network system for water service industry |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113780718A true CN113780718A (en) | 2021-12-10 |
| CN113780718B CN113780718B (en) | 2024-02-06 |
Family
ID=78835988
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110841647.7A Active CN113780718B (en) | 2021-07-26 | 2021-07-26 | GIS-based digital pipe network system for water service industry |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113780718B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117290299A (en) * | 2023-09-12 | 2023-12-26 | 首都机场集团有限公司 | Airport security management system dynamic association matching method and system and electronic equipment |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH09259186A (en) * | 1996-03-27 | 1997-10-03 | Hitachi Ltd | Pipe network state grasping system |
| CN101964084A (en) * | 2010-09-26 | 2011-02-02 | 南京中图数码科技有限公司 | Intelligent dynamic network structure modeling and processing method applied to urban integrated pipeline system |
| CN105550758A (en) * | 2016-01-18 | 2016-05-04 | 无锡扬晟科技有限公司 | GIS-based underground pipeline operation and maintenance system |
| CN106548306A (en) * | 2016-12-10 | 2017-03-29 | 浙江知水信息技术有限公司 | Realize basic unit's water utilities system of grid fine-grained management |
| CN107958104A (en) * | 2017-11-08 | 2018-04-24 | 天津大学 | By open GIS and the management of database sharing water supply network and hydraulic model method |
| CN108597020A (en) * | 2018-01-24 | 2018-09-28 | 苏州星宇测绘科技有限公司 | A kind of three-dimensional underground utilities detection data quick mapping method and system |
| CN109558473A (en) * | 2018-12-06 | 2019-04-02 | 佛山科学技术学院 | A kind of road traffic facility information management system and its modeling method based on GIS |
| CN112149027A (en) * | 2020-10-28 | 2020-12-29 | 云赛智联股份有限公司 | City operation data visual management system |
-
2021
- 2021-07-26 CN CN202110841647.7A patent/CN113780718B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH09259186A (en) * | 1996-03-27 | 1997-10-03 | Hitachi Ltd | Pipe network state grasping system |
| CN101964084A (en) * | 2010-09-26 | 2011-02-02 | 南京中图数码科技有限公司 | Intelligent dynamic network structure modeling and processing method applied to urban integrated pipeline system |
| CN105550758A (en) * | 2016-01-18 | 2016-05-04 | 无锡扬晟科技有限公司 | GIS-based underground pipeline operation and maintenance system |
| CN106548306A (en) * | 2016-12-10 | 2017-03-29 | 浙江知水信息技术有限公司 | Realize basic unit's water utilities system of grid fine-grained management |
| CN107958104A (en) * | 2017-11-08 | 2018-04-24 | 天津大学 | By open GIS and the management of database sharing water supply network and hydraulic model method |
| CN108597020A (en) * | 2018-01-24 | 2018-09-28 | 苏州星宇测绘科技有限公司 | A kind of three-dimensional underground utilities detection data quick mapping method and system |
| CN109558473A (en) * | 2018-12-06 | 2019-04-02 | 佛山科学技术学院 | A kind of road traffic facility information management system and its modeling method based on GIS |
| CN112149027A (en) * | 2020-10-28 | 2020-12-29 | 云赛智联股份有限公司 | City operation data visual management system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117290299A (en) * | 2023-09-12 | 2023-12-26 | 首都机场集团有限公司 | Airport security management system dynamic association matching method and system and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113780718B (en) | 2024-02-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107092680B (en) | Government affair information resource integration method based on geographic grids | |
| CN110222373B (en) | Geotechnical engineering full life cycle oriented engineering investigation data processing method | |
| CN103136371B (en) | Subdivision mark generating method and the data retrieval method of multi-source Spatial Data | |
| CN111222661A (en) | Urban planning implementation effect analysis and evaluation method | |
| CN109684428A (en) | Spatial data building method, device, equipment and storage medium | |
| Raju | Fundamentals of geographical information system | |
| CN112527915B (en) | Linear cultural heritage knowledge graph construction method, system, computing device and medium | |
| CN114676368B (en) | Geographic entity information display method, device, equipment and medium based on identification code | |
| CN113222540A (en) | Management system of ecological protection red line | |
| CN114417802A (en) | Intelligent report generation system | |
| Nowak et al. | Geotagging of natural history collections for reuse in environmental research | |
| Johnson | Geographic information systems (GIS) and mapping: practices and standards | |
| CN113780718B (en) | GIS-based digital pipe network system for water service industry | |
| CN1467692A (en) | Method for making electronic map | |
| Svob et al. | The development of a forestry geodatabase for natural forest management plans in Costa Rica | |
| CN114781343B (en) | Metadata form information batch filling method and device | |
| CN116627947A (en) | Design method and device for agricultural cultural heritage landscape space database | |
| KR102053235B1 (en) | Method for Location Identification Using Volunteered Geographic Information | |
| CN113987661A (en) | Earthquake damage prediction visual evaluation system | |
| US8898179B2 (en) | Method for extracting attribute data from a media file | |
| Issa et al. | Modeling the environment with remote sensing and GIS: applied case studies from diverse locations of the United Arab Emirates (UAE) | |
| US8782564B2 (en) | Method for collaborative display of geographic data | |
| Singh et al. | MODELING A GEO-SPATIAL DATABASE FOR MANAGING TRAVELERS'DEMAND | |
| Rusu | Modeling toponymic change: A multilevel analysis of street renaming in postsocialist Romania | |
| Cocks et al. | Using the Australian Resources Information System to describe extensive regions |
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 |