CN110287532B - Drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfWorks ICM - Google Patents
Drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfWorks ICM Download PDFInfo
- Publication number
- CN110287532B CN110287532B CN201910436154.8A CN201910436154A CN110287532B CN 110287532 B CN110287532 B CN 110287532B CN 201910436154 A CN201910436154 A CN 201910436154A CN 110287532 B CN110287532 B CN 110287532B
- Authority
- CN
- China
- Prior art keywords
- data
- node
- pipeline
- pipe
- arcgis
- 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
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/18—Network design, e.g. design based on topological or interconnect aspects of utility systems, piping, heating ventilation air conditioning [HVAC] or cabling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2113/00—Details relating to the application field
- G06F2113/14—Pipes
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Geometry (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Analysis (AREA)
- Computational Mathematics (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- General Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
An ArcGIS + InfoWorks ICM-based drainage pipe network planning drawing information modeling processing method belongs to the crossing field of municipal engineering information technology and geographic information system technology. This patent need not to carry out complicated layering to CAD drainage pipe network planning drawing, also need not to carry out specific processing to the inspection shaft picture layer, draw the node one by one, and carry out a large amount of simplifications with artifical work of entering attribute data one by one, carry out the automatic conversion of pipe network model graphic data through InfoWorks ICM, carry out the automatic conversion of pipe network model attribute data through ArcGIS, realize the automation and the mass of model data and type, both reduced the artifical loaded down with trivial details operation of entering data one by one, still improve the work efficiency of data entry, guarantee the quality of drainage pipe network model data, thereby effectively improve the quality of constructing the drainage pipe network model. The invention can complete each step only by means of the existing software tool without complicated program compiling, and has simple and easy operation.
Description
Technical Field
The invention relates to a drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfoWorks ICM, and belongs to the crossing field of municipal engineering information technology and geographic information system technology.
Background
The drainage network system is an important urban infrastructure, is responsible for collecting and conveying urban sewage and runoff generated by rainfall and snow melting in cities, has the double functions of protecting the environment and reducing the urban disasters, is called as a 'life line' and 'blood vessels' of the cities, and has a non-negligible role in urban planning and construction. Municipal drainage pipe network engineering planning is significant for guiding construction work of municipal drainage pipe network engineering, and due to the advantages of simplicity and easiness in learning of AutoCAD, attractive interface and the like, municipal drainage pipe network engineering planning drawings are usually stored in a CAD file format. The drainage pipe network planning drawing stores pipeline spatial data in a multi-segment line mode, the pipe diameter information of a pipeline and the ground elevation and pipe bottom elevation information of nodes are marked in a text marking mode respectively, the flow direction information of the pipeline is marked through an arrow, however, the relation between the spatial attribute and the attribute data of the pipe network data is not considered in the drawing, the topological relation of the pipe network data is lack of description, and the complex spatial relation of a drainage pipe network cannot be reflected.
The ArcGIS is a comprehensive system, users can collect, organize, manage, analyze, exchange and distribute geographic information by using the ArcGIS, along with the development of computer technology, the unique advantages of the ArcGIS in the aspect of establishing a geospatial database are increasingly prominent, and the ArcGIS is more and more applied to modeling of drainage pipe network models and drainage waterlogging prevention models. The ArcGIS can be applied to data management and spatial analysis, and can also be intuitively and dynamically subjected to modeling or visual management. When a drainage pipe network model is built, the ArcGIS model database can be conveniently input into a model software system, and with the development of drainage pipe network model technology, how to effectively convert CAD drainage pipe network planning drawing information into the ArcGIS model database is very important. The InfoWorks ICM (urban integrated drainage basin drainage model system) is one of mainstream drainage pipe network models and sponge urban model software which are widely applied at home and abroad at present, and has flexible data interfaces including ArcGIS, CAD, Excel and the like in the aspect of model data processing. When importing CAD multi-segment data, the InfoWorks ICM can automatically generate point layer data at two ends of the line layer data, and automatically carry out numbering, thereby providing convenience for conversion of graphic data, but the attribute data is usually input one by manual operation.
The method for inputting the information of the planning drawing of the drainage pipe network into the ArcGIS model database generally comprises two parts of graphic data input and attribute data input. In the traditional drainage pipe network model construction, layering processing needs to be carried out on CAD graphic data, and specific processing needs to be carried out on inspection well layers, but the workload of layering processing on CAD drawings is large and tedious; the attribute data of the drainage pipe network planning drawing are usually marked nearby near pipelines and nodes according to a visual display principle in a text form, unified rules and standards are not provided, the traditional attribute data are usually input one by means of a large amount of manual operations, such as bottom elevation and ground elevation of an inspection well, pipe diameter of a pipeline, upstream and downstream bottom elevation and the like, due to the fact that a city drainage pipe network is complex, a large amount of manual input is prone to errors, working efficiency is low, the quality of a database is low, and the quality of a drainage pipe network model cannot be guaranteed.
Based on the defect of the drainage pipe network model construction, the drainage pipe network model construction method starts from the requirement of drainage pipe network model construction, and is based on the storage characteristics of drainage pipe network planning drawing information, complex layered processing is not required to be carried out on CAD drainage pipe network planning drawing, specific processing is not required to be carried out on inspection well drawing layers, nodes are drawn one by one, manual work of entering attribute data one by one is simplified greatly, automatic conversion of pipe network model graphic data is carried out through InfoWorks ICM, automatic conversion of pipe network model attribute data is carried out through ArcGIS, automatic and batch entry of model data is achieved, tedious operations of manually entering data one by one are reduced, the work efficiency of data entry is improved, the quality of drainage pipe network model data is guaranteed, and the quality of constructing the drainage pipe network model is improved effectively.
Disclosure of Invention
The invention provides a drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfoWorks ICM, which mainly aims to solve the problems that the existing drainage pipe network planning drawing information modeling method based on drainage pipe network planning drawing information is complicated in hierarchical processing work of CAD planning drawing data, large in workload of manually inputting attribute data one by one, low in working efficiency, easy to generate errors and low in model data quality.
The technical scheme of the invention is as follows:
a drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfoWorks ICM comprises the following steps in sequence:
(1) planning drawing base data processing
1.1 planning drawing pipeline data processing
This patent planning drawing basic data handles, need not to carry out complicated loaded down with trivial details layering to the CAD planning drawing according to the key element, also need not to carry out specific processing, draw the node one by one to the inspection shaft picture layer, only needs to unify the pipeline in the planning drawing at same picture layer, like "downspout" picture layer, connects the end point of the pipeline that links to each other in a point, saves the pipeline data after handling as a new CAD drawing in addition again, names "piping diagram".
1.2 processing the labeled data of the planning drawing
And moving the insertion starting point of the pipe diameter marking characters of each pipe section to the middle position of each pipe section, and storing the processed pipe line and pipe diameter marking data as a new CAD drawing named as a pipe diameter drawing.
And moving the insertion starting point of the ground elevation marking characters at the end points of the pipe sections to the end point positions, and storing the processed pipeline and ground elevation marking data as a new CAD drawing named as a ground elevation graph.
And moving the insertion starting point of the pipe bottom elevation marking characters at the end points of the pipe sections to the end point positions, and storing the processed pipeline and pipe bottom elevation marking data as a new CAD drawing named as a 'well bottom elevation drawing'.
(2) Automatic conversion of pipe network graphic data
In the model network of the InfoWorks ICM, the 'pipeline diagram' stored in the step 1.1 is selected through a 'network-import-update self-AutoCAD dwg file' tool, and the 'reduce' is selected from a table corresponding to columns where pipeline layers such as 'rainwater pipe' layers are located, and 'Lines/Polygons' are located, so that pipeline graphic data can be automatically converted into the model network, nodes are automatically generated at two ends of a pipeline, and the node numbers and the numbers of nodes on the upstream and downstream of the pipeline are automatically numbered.
(3) Combing of pipe network topological relation
And (2) automatically numbering the node numbers and the upstream and downstream node numbers of the pipelines, preliminarily constructing a topological relation of the pipe network, wherein the upstream and downstream node numbers of part of the pipelines are opposite to the actual flow direction of the pipe network and need to be adjusted. In the model network of the InfoWorks ICM, the flow direction of a reverse pipe section is adjusted through a reverse all-selected connection tool according to pipe network flow direction information in a drainage pipe network planning drawing.
(4) Output of pipe network Shp format data
In the model network of the InfoWorks ICM, pipeline data and node data are respectively output as Shape File files which can be read by ArcGIS through a 'network-output-data export center' tool, and the Shape File files are named as 'pipeline data' and 'node data'. The fields in the node data layer attribute table comprise node _ id (node number), node _ type (node type), x (x coordinate), y (y coordinate), group _ lev (ground elevation) and chamber _ fl (bottom elevation), and the fields in the pipeline data layer attribute table comprise us _ node _ id (upstream node number), ds _ node _ id (downstream node number), shape _1 (pipe segment shape), reduce _ wi (channel width), reduce _ he (channel height), reduce _ le (pipe length), us _ invert (upstream bottom elevation) and ds _ invert (downstream bottom elevation).
(5) Automatic conversion of pipe network attribute data
5.1 automatic conversion of pipeline diameter data
And (3) loading the 'pipe diameter diagram' saved in the step (1) and the 'pipeline data' output in the step (4) in ArcGIS. The pipe diameter Text labeling information and the pipe diameter are spatially connected through a Spatial Join tool of ArcGIS, wherein a target element selects pipe diameter data, a connecting element selects pipe diameter graph under a pipe diameter graph catalog, dwg Annotation and an output element class are named as pipe data 1, and after the Spatial connection, a Text field is automatically added in a pipe diameter data 1 attribute table and the pipe diameter information is automatically converted to be under the field.
A conduit _ di (pipe diameter) field is added to the "pipe data 1" attribute table. The drainage pipe network planning drawing has different labeling forms for the round pipe and the canal, for example, the round pipe with the diameter of 1000mm is labeled as d1000, and the canal with the width of 3.2 meters and the height of 2 meters is labeled as A3.2x2. Opening a ' pipeline data 1 ' file with a suffix of ' dbf ' in Excel and storing the file as ' pipe diameter information, xls ' file, splitting pipe diameter literal information through a ' splitting tool of Excel, such as splitting d1000 into d and 1000, splitting A3.2x2 into A, 3.2, x and 2, then copying the pipe diameter data of the circular pipes into a conduit _ di field of an ' pipeline data 1 ' attribute table in batches, and copying the channel width data and the channel height data into a conduit _ wi field and a conduit _ he field of the ' pipeline data 1 ' attribute table in batches.
5.2 automatic conversion of node elevation data
1. Loading the 'bottom hole elevation map' stored in the step (1) and 'node data' output in the step (4) in ArcGIS, and carrying out Spatial connection on bottom hole elevation Text label information and nodes through a 'Spatial Join' tool, wherein 'target element' selects 'node data', connecting element 'selects' bottom hole elevation map 'under the' bottom hole elevation map 'catalogue', dwg Annotation ', output element class' is named as 'node data 1', and after Spatial connection, automatically adding a Text field in a 'node data 1' attribute table and automatically converting the bottom hole elevation information to the field.
2. Loading the ' ground elevation map ' stored in the step (1) in ArcGIS, and spatially connecting ground elevation Text Annotation information with nodes by a ' Spatial Join ' (Spatial connection) tool, wherein ' target element ' selects ' node data 1 ', and ' connection element ' selects ' ground elevation map ' under a ' ground elevation map ' directory, dwg Annotation ', and ' output element class ' is named as ' node data 2 ', and after Spatial connection, automatically adding Text1 field in an attribute table of ' node data 2 ' and automatically converting the ground elevation information to the field.
3. In the attribute table of "node data 2", a "Field Calculator" tool of ArcGIS sets "group _ lev ═ Text 1" and "number _ fl ═ Text", respectively, to complete automatic conversion of the node elevation data.
5.3 automatic conversion of elevation data of the bottom of the pipeline upstream and downstream
1. In the ArcGIS, the us _ node _ id Field of the attribute table of "pipeline data 1" and the node _ id Field of the attribute table of "node data 2" are connected by a "Join" tool, wherein "Join Options" selects "Keep only matching records", and after connection, the "pipeline data 1.us _ invert ═ node data 2.chamber _ fl" is set by a "Field Calculator" tool of the ArcGIS, thereby completing the automatic conversion of the pipeline upstream bottom height data.
2. In ArcGIS, the ds _ node _ id Field of the attribute table of "pipeline data 1" and the node _ id Field of the attribute table of "node data 2" are connected by a "Join" (connection) tool, where "Join Options" selects "Keep only organizing records", and after connection, "pipeline data 1, ds _ invert ═ node data 2.chamber _ fl" is set by a "Field Calculator" tool of ArcGIS, thereby completing automatic conversion of the elevation data of the downstream bottom of the pipeline.
The drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfoWorks ICM has the beneficial effects that:
1. by adopting the method, the existing drainage pipe network planning drawing information can be utilized, the effective conversion of the drainage pipe network model data is realized, and great convenience is provided for the construction of the drainage pipe network model.
2. This patent need not to carry out complicated loaded down with trivial details layering to CAD planning drawing according to the key element, also need not to carry out specific processing to the inspection shaft picture layer, draw the node one by one, the entry of drain pipe network model data mainly realizes through ArcGIS and infoWorks ICM is automatic, very big reduction in the artifical work load of entering attribute data one by one in the traditional data entry, it is loaded down with trivial details to have avoided traditional artifical attribute data work of entering, the inefficiency, the shortcoming of easily makeing mistakes, the improvement of very big degree work efficiency, the quality of drain pipe network model attribute data has been guaranteed, thereby provide the guarantee for the quality of drain pipe network model.
3. The method has operability, does not need to write complex programs, can finish all steps only by means of the existing software tool, is simple and easy to operate and easy to realize, and ensures the practicability of the method.
Description of the drawings:
FIG. 1 is a schematic flow chart of the operation of the present invention.
The specific implementation mode is as follows:
the specific implementation flow of the invention is shown in fig. 1, and comprises the following steps:
(1) planning drawing base data processing
1.1 planning drawing pipeline data processing
Unifying the pipelines in the planning drawing on the same layer, such as a rainwater pipe layer, connecting the end points of the connected pipelines to one point, and storing the processed pipeline data as a new CAD drawing named as a pipeline drawing.
1.2 processing the labeled data of planning drawing
And moving the insertion starting point of the pipe diameter marking characters of each pipe section to the middle position of each pipe section, and storing the processed pipe line and pipe diameter marking data as a new CAD drawing named as a pipe diameter drawing.
And moving the insertion starting point of the ground elevation marking characters at the end points of the pipe sections to the end point positions, and storing the processed pipeline and ground elevation marking data as a new CAD drawing named as a ground elevation graph.
And moving the insertion starting point of the pipe bottom elevation marking text at the end point of each pipe section to the end point position, and storing the processed pipeline and pipe bottom elevation marking data as a new CAD drawing named as a 'well bottom elevation drawing'.
(2) Automatic conversion of pipe network graphic data
In the model network of the InfoWorks ICM, the 'pipeline diagram' stored in the step 1.1 is selected through a 'network-import-update self-AutoCAD dwg file' tool, and the 'reduce' is selected from a table corresponding to columns where pipeline layers such as 'rainwater pipe' layers are located, and 'Lines/Polygons' are located, so that pipeline graphic data can be automatically converted into the model network, nodes are automatically generated at two ends of a pipeline, and the node numbers and the numbers of nodes on the upstream and downstream of the pipeline are automatically numbered.
(3) Combing of pipe network topological relation
In the model network of the InfoWorks ICM, the flow direction of a reverse pipe section is adjusted through a reverse all-selected connection tool according to pipe network flow direction information in a drainage pipe network planning drawing.
(4) Output of pipe network Shp format data
In the model network of the InfoWorks ICM, pipeline data and node data are respectively output as Shape File files named as pipeline data and node data through a network-output-data export center tool. The fields in the node data layer attribute table comprise node _ id (node number), node _ type (node type), x (x coordinate), y (y coordinate), group _ lev (ground elevation) and chamber _ fl (bottom elevation), and the fields in the pipeline data layer attribute table comprise us _ node _ id (upstream node number), ds _ node _ id (downstream node number), shape _1 (pipe segment shape), reduce _ wi (channel width), reduce _ he (channel height), reduce _ le (pipe length), us _ invert (upstream bottom elevation) and ds _ invert (downstream bottom elevation).
(5) Automatic conversion of pipe network attribute data
5.1 automatic conversion of pipeline caliber data
And (3) loading the 'pipe diameter diagram' saved in the step (1) and the 'pipeline data' output in the step (4) in ArcGIS. The pipe diameter Text labeling information and the pipe diameter are spatially connected through a Spatial Join tool of ArcGIS, wherein a target element selects pipe diameter data, a connecting element selects pipe diameter graph under a pipe diameter graph catalog, dwg Annotation and an output element class are named as pipe data 1, and after the Spatial connection, a Text field is automatically added in a pipe diameter data 1 attribute table and the pipe diameter information is automatically converted to be under the field.
A conduit _ di (pipe diameter) field is added to the "pipe data 1" attribute table. Opening a ' pipeline data 1 ' file with a suffix of ' dbf ' in Excel and storing the file as ' pipe diameter information, xls ' file, splitting pipe diameter literal information through a ' splitting tool of Excel, such as splitting d1000 into d and 1000, splitting A3.2x2 into A, 3.2, x and 2, then copying the pipe diameter data of the circular pipes into a conduit _ di field of an ' pipeline data 1 ' attribute table in batches, and copying the channel width data and the channel height data into a conduit _ wi field and a conduit _ he field of the ' pipeline data 1 ' attribute table in batches.
5.2 automatic conversion of node elevation data
1. Loading the 'bottom hole elevation map' stored in the step (1) and 'node data' output in the step (4) in ArcGIS, and carrying out Spatial connection on bottom hole elevation Text label information and nodes through a 'Spatial Join' tool, wherein 'target element' selects 'node data', connecting element 'selects' bottom hole elevation map 'under the' bottom hole elevation map 'catalogue', dwg Annotation ', output element class' is named as 'node data 1', and after Spatial connection, automatically adding a Text field in a 'node data 1' attribute table and automatically converting the bottom hole elevation information to the field.
2. Loading the 'ground elevation map' saved in the step (1) in ArcGIS, and spatially connecting the ground elevation Text label information with nodes by a 'Spatial Join' tool, wherein a 'target element' selects 'node data 1', a 'connection element' selects 'ground elevation map' under a 'ground elevation map' catalog, 'dwg indication', an 'output element class' is named as 'node data 2', and after Spatial connection, a Text1 field is automatically added in an 'node data 2' attribute table, and the ground elevation information is automatically converted to be under the field.
3. In the "node data 2" attribute table, the "Field Calculator" tool of ArcGIS sets "group _ lev _ Text 1" and "chamber _ fl" Text ", respectively, to complete the automatic conversion of the node elevation data.
5.3 automatic conversion of elevation data of the bottom of the pipeline upstream and downstream
1. In the ArcGIS, the us _ node _ id Field of the attribute table of "pipeline data 1" and the node _ id Field of the attribute table of "node data 2" are connected by a "Join" tool, wherein "Join Options" selects "Keep only matching records", and after connection, the "pipeline data 1.us _ invert ═ node data 2.chamber _ fl" is set by a "Field Calculator" tool of the ArcGIS, thereby completing the automatic conversion of the pipeline upstream bottom height data.
2. In the ArcGIS, the ds _ node _ id Field of the attribute table of "pipeline data 1" and the node _ id Field of the attribute table of "node data 2" are connected by a "Join" (connection) tool, wherein "Join Options" selects "Keep only matching records", and after connection, the "pipeline data 1, ds _ invert ═ node data 2.chamber _ fl" is set by a "Field Calculator" tool of the ArcGIS, so that the automatic conversion of the height data of the downstream bottom of the pipeline is completed.
Claims (1)
1. A drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfoWorks ICM is characterized by comprising the following steps:
(1) planning drawing base data processing
(1.1) planning drawing pipeline data processing
Unifying pipelines in the planning drawing on the same layer, connecting the end points of the connected pipelines to one point, and storing the processed pipeline data as a new CAD drawing named as a pipeline drawing;
(1.2) processing of annotation data of planning drawings
Moving the insertion starting point of the pipe diameter marking characters of each pipe section to the middle position of each pipe section, and storing the processed pipe line and pipe diameter marking data as a new CAD drawing named as a pipe diameter drawing;
moving the insertion starting point of the ground elevation marking characters at the end point of each pipe section to the end point position, and storing the processed pipeline and ground elevation marking data as a new CAD drawing named as a ground elevation drawing;
moving the insertion starting point of the pipe bottom elevation marking words at the end points of all the pipe sections to the end point positions, and storing the processed pipe line and pipe bottom elevation marking data as a new CAD drawing, which is named as a 'well bottom elevation drawing';
(2) automatic conversion of pipe network graphic data
In a model network of the InfoWorks ICM, selecting a 'pipeline diagram' stored in the step (1.1) through a 'network-import-update self-AutoCAD dwg file' tool, selecting 'Conduit' in a table corresponding to a row of a pipeline diagram layer and a column of 'Lines/Polygons', automatically converting pipeline diagram data into the model network, automatically generating nodes at two ends of a pipeline, and automatically numbering the node numbers and the numbers of nodes on the upstream and downstream of the pipeline;
(3) combing of pipe network topological relation
Automatically numbering node numbers and upstream and downstream node numbers of pipelines, and initially constructing a topological relation of a pipe network, wherein the upstream and downstream node numbers of partial pipelines are opposite to the actual flow direction of the pipe network and need to be adjusted; in the model network of the InfoWorks ICM, adjusting the flow direction of a reverse pipe section according to pipe network flow direction information in a drainage pipe network planning drawing by a reverse all-selected connection tool;
(4) output of pipe network Shp format data
In a model network of the InfoWorks ICM, pipeline data and node data are respectively output as Shape File files which can be read by ArcGIS through a 'network-output-data export center' tool, and the Shape File files are named as 'pipeline data' and 'node data'; the fields in the node data layer attribute table comprise a node _ id (a node number), a node _ type (a node type), an x (an x coordinate), a y (a y coordinate), a group _ lev (a ground elevation) and a chamber _ fl (a well bottom elevation), the fields in the pipeline data layer attribute table comprise a us _ node _ id (an upstream node number), a ds _ node _ id (a downstream node number), a shape _1 (a pipe section shape), a reduce _ wi (a channel width), a reduce _ he (a channel height), a reduce _ le (a pipe length), a us _ invert (an upstream bottom elevation) and a ds _ invert (a downstream bottom elevation);
(5) automatic conversion of pipe network attribute data
(5.1) automatic conversion of pipeline pipe diameter data
Loading the 'pipe diameter diagram' saved in the step (1) and 'pipeline data' output in the step (4) in ArcGIS; pipe diameter Text marking information and a pipe are spatially connected through a Spatial joint tool of ArcGIS, wherein target elements select pipe data, connecting elements select pipe diameter diagrams under pipe diameter diagram catalogues, dwg indication and output element types are named pipe data 1, after Spatial connection, Text fields are automatically added in a pipe data 1 attribute table, and pipe diameter information is automatically converted to the fields;
adding a conduit _ di pipe diameter field in a 'pipeline data 1' attribute table; opening a pipeline data 1 file with a suffix of ". dbf" in Excel and storing the file as "pipe diameter information". xls "file, splitting pipe diameter text information by a" sorting "tool of Excel, then copying pipe diameter data of circular pipes in batches into a conduit _ di field of an attribute table of the" pipeline data 1 ", and copying data of channel width and channel height in batches into a conduit _ wi field and a conduit _ he field of the attribute table of the" pipeline data 1 ";
(5.2) automatic conversion of node elevation data
Loading the ' bottom hole elevation map ' stored in the step (1) and ' node data ' output in the step (4) in ArcGIS, and spatially connecting bottom hole elevation Text marking information and nodes through a ' Spatial Join ' Spatial connection tool, wherein a ' target element ' selects ' node data ', a ' bottom hole elevation map ' under a ' bottom hole elevation map ' catalog is selected by a ' connection element ', dwg Annotation ' and an ' output element class ' is named as ' node data 1 ', and after Spatial connection, a Text field is automatically added in a ' node data 1 ' attribute table, and the bottom hole elevation information is automatically converted to the lower part of the field;
loading the 'ground elevation map' saved in the step (1) in ArcGIS, and spatially connecting the Text Annotation information of the ground elevation with nodes by a 'Spatial Join' Spatial connection tool, wherein a 'target element' selects 'node data 1', a 'connection element' selects 'ground elevation map' under a 'ground elevation map' catalog, 'dwg indication', an 'output element class' is named as 'node data 2', and after Spatial connection, a Text1 field is automatically added in a 'node data 2' attribute table and the ground elevation information is automatically converted to be under the field;
setting "group _ lev ═ Text 1" and "chamber _ fl ═ Text" respectively in the attribute table of "node data 2" by the "Field Calculator tool of ArcGIS, and completing automatic conversion of the node elevation data;
(5.3) automatic conversion of bottom elevation data of up and down stream of pipeline
Connecting a us _ node _ id Field of an attribute table of ' pipeline data 1 ' and a node _ id Field of an attribute table of ' node data 2 ' through a ' Join ' connecting tool in ArcGIS, wherein ' Join Options ' selects ' Keep only matching records ', and after connection, a ' Field Calculator tool of ArcGIS sets ' pipeline data 1.us _ invert ═ node data 2.chamber _ fl ', so as to complete automatic conversion of pipeline upstream bottom elevation data;
in ArcGIS, the ds _ node _ id Field of the attribute table of ' pipeline data 1 ' and the node _ id Field of the attribute table of ' node data 2 ' are connected through a ' Join ' connection tool, wherein ' Join Options ' selects ' Keep only matching records ', and after connection, through a ' Field Calculator tool of ArcGIS, the ' pipeline data 1, ds _ invert ═ node data 2.chamber _ fl ' is set, and automatic conversion of the height data of the downstream bottom of the pipeline is completed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910436154.8A CN110287532B (en) | 2019-05-23 | 2019-05-23 | Drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfWorks ICM |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910436154.8A CN110287532B (en) | 2019-05-23 | 2019-05-23 | Drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfWorks ICM |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110287532A CN110287532A (en) | 2019-09-27 |
| CN110287532B true CN110287532B (en) | 2022-09-27 |
Family
ID=68002540
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910436154.8A Active CN110287532B (en) | 2019-05-23 | 2019-05-23 | Drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfWorks ICM |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110287532B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113886999B (en) * | 2021-09-10 | 2024-05-07 | 上海市城市建设设计研究总院（集团）有限公司 | Method for quickly establishing drainage model and GIS (geographic information System) data through CAD (computer aided design) data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102592008A (en) * | 2011-12-30 | 2012-07-18 | 华东师范大学 | Municipal drainage pipe network design system and method based on GIS (Geographic Information System) technology |
| CN105138707A (en) * | 2015-10-06 | 2015-12-09 | 北京工业大学 | Input file Inp file generation method of SWMM hydraulic model based on GIS model database |
| CN106897516A (en) * | 2017-02-22 | 2017-06-27 | 武汉大学 | Urban underground water drainage pipe net is transformed and transformation evaluation method |
| CN109492258A (en) * | 2018-10-15 | 2019-03-19 | 上海凯泉泵业（集团）有限公司 | A kind of EPANET hydraulic model Inp document generating method based on GIS model database |
-
2019
- 2019-05-23 CN CN201910436154.8A patent/CN110287532B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102592008A (en) * | 2011-12-30 | 2012-07-18 | 华东师范大学 | Municipal drainage pipe network design system and method based on GIS (Geographic Information System) technology |
| CN105138707A (en) * | 2015-10-06 | 2015-12-09 | 北京工业大学 | Input file Inp file generation method of SWMM hydraulic model based on GIS model database |
| CN106897516A (en) * | 2017-02-22 | 2017-06-27 | 武汉大学 | Urban underground water drainage pipe net is transformed and transformation evaluation method |
| CN109492258A (en) * | 2018-10-15 | 2019-03-19 | 上海凯泉泵业（集团）有限公司 | A kind of EPANET hydraulic model Inp document generating method based on GIS model database |
Non-Patent Citations (4)
| Title |
|---|
| Design and research of underground pipeline integrated application system based on ArcEngine;Yang Bin等，;《2010 2nd IEEE International Conference on Information Management and Engineering》;20100418;第6-10页 * |
| 基于ArcGIS与InfoWorks的城市排水系统模拟研究;刘志生等，;《中国给水排水》;20131101;第29卷(第21期);第144-147页 * |
| 基于ArcGIS的排水管网数据转换及检查方法;陈淑珍等，;《水电能源科学》;20141125;第32卷(第11期);第168-171页 * |
| 现代排水模型软件技术(InfoWorks CS)在广州市污水管网的应用;甄志雄，;《广东建材》;20100428(第04期);第25-27页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110287532A (en) | 2019-09-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105117572B (en) | Automatic SWMM hydraulic models construction method based on Storm Sewer Network design schedule | |
| CN105224747B (en) | Urban waterlogging model building method based on CAD engineering drawings information and design of pipe networks computational chart | |
| CN105117573B (en) | Auto hydraulic model building method based on CAD drainage pipeline networks drawing informations | |
| CN103679804A (en) | System and method for automatically building three-dimensional model of data of underground pipeline | |
| CN101640001A (en) | Simulation-system-oriented road network drawing device and method therefor | |
| CN109272571B (en) | System and method for converting PDS three-dimensional data into Flowmaster model | |
| CN110543710A (en) | Cement engineering three-dimensional nonstandard part design method based on Revit | |
| CN110287532B (en) | Drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfWorks ICM | |
| WO2024045615A1 (en) | Automatic labeling method and system for pipeline three-dimensional building information modeling | |
| CN104318026A (en) | Method for integrally automatically generating pipeline designs | |
| CN113190938A (en) | Method, system and medium for rapidly establishing municipal pipe network parameterized model | |
| CN111950105A (en) | Thermal power plant pipeline three-dimensional model conversion method based on depth-first traversal | |
| CN110298075B (en) | Urban municipal drainage pipeline one-map modeling processing method based on ArcGIS + InfoWorks ICM | |
| KR20200033653A (en) | Method and apparatus for inspecting error of underground facilities maps | |
| CN110298913B (en) | Automatic drainage pipe network model data conversion method based on drainage pipe network planning drawing information | |
| CN103036705B (en) | The visualization system of pipeline and fiber optic resource management system | |
| JP2008117004A (en) | Diversion device for layout data and specification data of piping component, and its diversion method | |
| CN111259065B (en) | XDB data output method for drainage design model through Civil3D | |
| CN116383950A (en) | Multi-platform collaborative outdoor rainwater pipe network parameterization design method and system | |
| CN116011157A (en) | Automatic desk CAD and Revit secondary development-based pipeline rapid extraction modeling method | |
| CN107423520A (en) | Based on CAD secondary development rapid extraction pipeline information SWMM modeling methods | |
| CN110287531B (en) | Drainage pipe network model data conversion method based on one map of urban municipal pipelines | |
| Slongo et al. | The IFC file format as a means of integrating BIM and GIS: the case of the management and maintenance of underground networks | |
| CN112580131A (en) | Rapid search connection method for sub-catchment areas based on GIS (geographic information System) and SWMM (Single wire Meter-based Module) | |
| CN115017575B (en) | Sponge city digital design cloud computing interaction system based on Excel-VBA language |
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 |