CN110298913A - Auto-drainage pipe net leakage rate data transfer device based on drainage pipeline networks planning drawing information - Google Patents
Auto-drainage pipe net leakage rate data transfer device based on drainage pipeline networks planning drawing information Download PDFInfo
- Publication number
- CN110298913A CN110298913A CN201910436641.4A CN201910436641A CN110298913A CN 110298913 A CN110298913 A CN 110298913A CN 201910436641 A CN201910436641 A CN 201910436641A CN 110298913 A CN110298913 A CN 110298913A
- Authority
- CN
- China
- Prior art keywords
- data
- pipeline
- node
- field
- caliber
- 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
- 238000013439 planning Methods 0.000 title claims abstract description 38
- 238000012546 transfer Methods 0.000 title claims abstract description 6
- 238000006243 chemical reaction Methods 0.000 claims description 27
- 238000011144 upstream manufacturing Methods 0.000 claims description 21
- 238000010586 diagram Methods 0.000 claims description 11
- 238000012545 processing Methods 0.000 claims description 11
- 238000003780 insertion Methods 0.000 claims description 9
- 230000037431 insertion Effects 0.000 claims description 9
- 238000000034 method Methods 0.000 abstract description 10
- 238000005516 engineering process Methods 0.000 abstract description 6
- 238000007689 inspection Methods 0.000 abstract description 6
- 238000007493 shaping process Methods 0.000 abstract description 6
- 238000010276 construction Methods 0.000 description 4
- 238000007726 management method Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 210000001367 artery Anatomy 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000008280 blood Substances 0.000 description 1
- 210000004369 blood Anatomy 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000009977 dual effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000002372 labelling Methods 0.000 description 1
- 230000002265 prevention Effects 0.000 description 1
- 239000010865 sewage Substances 0.000 description 1
- 239000005413 snowmelt Substances 0.000 description 1
- 210000003462 vein Anatomy 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T17/00—Three dimensional [3D] modelling, e.g. data description of 3D objects
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T2210/00—Indexing scheme for image generation or computer graphics
- G06T2210/32—Image data format
Landscapes
- Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Computer Graphics (AREA)
- Geometry (AREA)
- Software Systems (AREA)
- Processing Or Creating Images (AREA)
Abstract
A kind of Auto-drainage pipe net leakage rate data transfer device based on drainage pipeline networks planning drawing information, belongs to municipal works information technology and geographic information system technology crossing domain.Storage characteristics of this patent based on drainage pipeline networks planning drawing information, without carrying out complicated layered shaping to CAD drainage pipeline networks planning drawing, it is specifically handled without to inspection shaft figure layer, node is drawn one by one, and by manually the work of typing attribute data is largely simplified one by one, key data Input Process passes through computer automation and the realization of mass, not only reduce the troublesome operation of artificial logging data one by one, also improve the working efficiency of data inputting, guarantee the quality of drainage pipeline networks model data, to effectively improve the quality of building drainage pipeline networks model.The present invention has operability simultaneously, and each step need to only can be completed in the programming complicated without progress by existing software tool, and operation is simple, easy to accomplish, ensure that the exploitativeness of this patent.
Description
Technical field
The present invention relates to it is a kind of based on drainage pipeline networks planning drawing information Auto-drainage pipe net leakage rate data transfer device,
Belong to municipal works information technology and geographic information system technology crossing domain.
Background technique
Sewerage pipeline network is important urban infrastructure, be responsible for collection and conveying municipal sewage and Urban Rain,
The task for the runoff that snow melt generates has protection environment and Urban disasters reduction moving dual function, " lifeline " and " blood referred to as city
Arteries and veins ", the effect in urban planning and construction can not be ignored.Municipal drainage pipelines net project is planned for instructing municipal drainage
The building-up work of pipe-networks engineering is significant, due to the advantages that AutoCAD is easy to learn, beautiful interface, municipal drainage pipe network work
Journey planning drawing is usually stored with CAD file format.Drainage pipeline networks planning drawing stores pipe space in the form of multi-section-line
Data are labelled with the caliber information of pipeline and the ground elevation of node and tube bottom elevation information respectively in the form of label character, and
It is labelled with the information that flows to of pipeline by arrow, but does not consider between the space attribute of pipe network data and attribute data in drawing
Relationship lacks the description to pipe network data topological relation, can not embody the spatial relationship of drainage pipeline networks complexity.
ArcGIS is a comprehensive system, and user can be used to collection, tissue, management, analysis, exchange and issue geographical
Information, with the development of computer technology, unique advantage of the ArcGIS in terms of establishing geospatial database becomes increasingly conspicuous,
In drainage pipeline networks model and drainage waterlogging prevention model modeling using more and more.Data management and sky can be carried out using ArcGIS
Between analyze, can also intuitively, dynamically carry out modeling or visualized management.ArcGIS data are stored in the form of point, line, surface,
Data mode is unified, convenient for management, can show the space distribution situation and geometry situation of figure, record the attribute number of figure
According to.In drainage pipeline networks model construction, what ArcGIS model database can be convenient is input to model software system, with draining
The development of pipe net leakage rate technology, how it is effective by CAD drainage pipeline networks planning drawing information be transformed into ArcGIS pattern number
It is particularly important according to library.
Drainage pipeline networks planning drawing information input ArcGIS model database generally includes graph data typing and attribute number
According to typing two parts.The building of conventional discharge pipe net leakage rate need to carry out layered shaping to CAD graphical data, and to inspection shaft figure
Layer carries out particular procedure, but cumbersome to the heavy workload of CAD diagram paper progress layered shaping；The attribute of drainage pipeline networks planning drawing
Data are usually labeled in pipeline and near nodal by visual presence principle with written form nearby, have no unified rule and standard,
Traditional attribute data typing is usually to rely on the typing one by one of a large amount of manual operation, as the shaft bottom elevation of inspection shaft, ground are high
Journey, caliber, upstream and downstream tube bottom elevation of pipeline etc., since urban drainage pipe network is intricate, a large amount of manual entry is easy
Existing mistake, working efficiency is low, and the quality of database is low, it is impossible to ensure that the quality of drainage pipeline networks model.
Based on the defect of above-mentioned drainage pipeline networks model construction, this patent is from the demand of drainage pipeline networks model construction, base
In the storage characteristics of drainage pipeline networks planning drawing information, without carrying out complicated layered shaping to CAD drainage pipeline networks planning drawing,
Without specifically being handled inspection shaft figure layer, draw node one by one, and by the manually work of typing attribute data one by one
Largely simplified, key data Input Process passes through computer automation and the realization of mass, not only reduces artificial
The troublesome operation of logging data one by one also improves the working efficiency of data inputting, guarantees the quality of drainage pipeline networks model data, from
And effectively improve the quality of building drainage pipeline networks model.
Summary of the invention
The present invention predominantly solves to be currently based on drainage pipeline networks planning drawing information architecture drainage pipeline networks model, advises to CAD
Drawing data layered shaping intricate operation is drawn, manually typing attribute data heavy workload one by one, working efficiency is low, is easy to appear mistake
Accidentally, the low-quality disadvantage of model data proposes a kind of Auto-drainage pipe net leakage rate data of drainage pipeline networks planning drawing information
Conversion method.
Technical scheme is as follows:
Based on the Auto-drainage pipe net leakage rate data transfer device of drainage pipeline networks planning drawing information, the method is successively wrapped
Containing following steps:
(1) planning chart paper basic data processing
1.1, planning chart paper tube line data processing
This patent planning chart paper basic data processing, without carrying out complicated cumbersome layering by element to CAD planning drawing
Processing, without specifically being handled inspection shaft figure layer, draw node one by one, it is only necessary to be unified in pipeline in planning chart together
The endpoint of connected pipeline is connected to a little by one figure layer.
1.2, planning drawing labeled data processing
The insertion starting point of each pipeline section caliber mark text is moved into the middle position of each pipeline section, general's treated pipeline and pipe
Diameter labeled data saves as a new CAD diagram paper, is named as " caliber figure ".
The insertion starting point of ground elevation mark text at each pipeline section endpoint is moved into endpoint location, will treated pipeline and
Ground elevation labeled data saves as a new CAD diagram paper, is named as " floor plan ".
The insertion starting point of tube bottom absolute altitude mark text at each pipeline section endpoint is moved into endpoint location, will treated pipeline and
Tube bottom absolute altitude labeled data saves as a new CAD diagram paper, is named as " shaft bottom absolute altitude figure ".
(2) automatic conversion of pipeline graph data
" the caliber figure " that load step (1) saves in ArcGIS, by the data converting function of ArcGIS, by " caliber
Figure .dwg Polyline " data Layer is converted to Shapfile formatted file, is named as " pipeline data ".
(3) node graph data automatically generates
1, pass through " Feature Vertices To Points " (element break turning point) tool in ArcGIS in pipeline
Point data is automatically generated at endpoint, wherein " the pipeline data " of " input element " selection step (2), " output factor kind " are named as
" node data ", " vertex type " selection " BOTH_ENDS ".
It 2, is that " node data " is automatic by " Add XY Coordinates " (addition XY coordinate) tool in ArcGIS
Addition POINT_X and POINT_Y field and the XY coordinate for calculating each node automatically.
3, in ArcGIS by " Delete Identical " (delete identical) tool by duplicate knot removal,
In " input data set " selection " node data ", field select POINT_X and POINT_Y.
(4) foundation of pipe network topological relation
Node serial number field is created in " node data " attribute list and node is numbered, and node serial number cannot weigh
It is multiple；Pipeline number, upstream node number and downstream node number field are created in " pipeline data " attribute list, according to drainpipe
Network planning draws pipe network in drawing and flows to information and node serial number, is numbered in attribute list to pipeline and inputs upstream node number
It is numbered with downstream node, pipeline number cannot repeat.
(5) automatic conversion of pipe network attribute data
5.1, the automatic conversion of pipeline caliber data
In ArcGIS by " Spatial Join " (space connection) tool by caliber text marking information and pipeline into
The connection of row space, wherein " target component " selection " pipeline data ", " nexus element " selects " caliber figure " mesh of step (1) load
" caliber figure .dwg Annotation " under record, " output factor kind " are named as " pipeline data 1 ", " pipeline after the connection of space
Text field will be added automatically in 1 " attribute list of data and caliber information is automatically switched under the field.
High conduit types, caliber, width of the channel, canal, upstream bottom absolute altitude and downstream are respectively created in " pipeline data 1 " attribute list
Bottom absolute altitude field.It is different to the labeling form of round tube with canal in drainage pipeline networks planning chart, as the round tube of 1000mm diameter is labeled as
D1000, wide 3.2 meters high 2 meters of canal are labeled as A3.2x2." pipeline data 1 " file that suffix is " .dbf " is opened in Excel
And " caliber information .xls " file is saved as, caliber text information is split by " point column " tool of Excel, such as
D1000 is split as d and 1000, and A3.2x2 is split as A, 3.2, x and 2, and round tube caliber batch data is then copied to " pipeline number
According in the caliber field of 1 " attribute list, width of the channel and the high batch data of canal are copied to the width of the channel and canal of " pipeline data 1 " attribute list
In high field.
5.2, the automatic conversion of node elevation data
1, load step (1) saves in ArcGIS " shaft bottom absolute altitude figure ", by " Spatial Join ", (space connects
Connecing) shaft bottom absolute altitude text marking information is carried out space with node and connected by tool, wherein " target component " selection " node data ",
" shaft bottom absolute altitude figure .dwg Annotation " under " nexus element " selection " shaft bottom absolute altitude figure " catalogue, " output factor kind " life
Entitled " node data 1 ", will automatic addition Text field and by shaft bottom absolute altitude in " node data 1 " attribute list after the connection of space
Information is automatically switched under the field.
2, load step (1) saves in ArcGIS " floor plan ", by " Spatial Join ", (space connects
Connecing) ground elevation text marking information and node carry out space and connected by tool, wherein " target component " selection " node data
1 ", " floor plan .dwg Annotation " under " nexus element " selection " floor plan " catalogue, " output factor kind "
It is named as " node data 2 ", it will automatic addition Text1 field and by ground in " node data 2 " attribute list after the connection of space
Elevation information is automatically switched under the field.
3, ground elevation and shaft bottom absolute altitude field is respectively created in " node data 2 " attribute list, passes through ArcGIS's
" Field Calculator " (field calculator) tool, be respectively set " ground elevation=Text1 ", " shaft bottom absolute altitude=
Text " completes the automatic conversion of node elevation data.
5.3, the automatic conversion of pipeline upstream and downstream bottom elevation data
1, pass through " Join " (connection) tool in ArcGIS for the upstream node number field of " pipeline data 1 " attribute list
The node serial number field of " node data 2 " attribute list is attached, wherein " Join Options " selection " Keep only
Matching records " passes through " Field Calculator " (field calculator) tool of ArcGIS, setting after connection
" 1. upstream bottom absolute altitude of pipeline data=2. shaft bottom absolute altitude of node data " completes the automatic conversion of line upstream bottom elevation data.
2, pass through " Join " (connection) tool in ArcGIS for the downstream node number field of " pipeline data 1 " attribute list
The node serial number field of " node data 2 " attribute list is attached, wherein " Join Options " selection " Keep only
Matching records " passes through " Field Calculator " (field calculator) tool of ArcGIS, setting after connection
" 1. downstream bottom absolute altitude of pipeline data=2. shaft bottom absolute altitude of node data " completes the automatic conversion of line downstream bottom elevation data.
Auto-drainage pipe net leakage rate data transfer device of the present invention based on drainage pipeline networks planning drawing information has
Beneficial effect is mainly reflected in:
1. using method of the present invention, drawing information can be planned using existing drainage pipeline networks, realize drainpipe
Effective conversion of pessimistic concurrency control data, the building for drainage pipeline networks model provide great convenience.
2. this patent is not necessarily to carry out complicated cumbersome layered shaping by element to CAD planning drawing, without to inspection shaft
Figure layer is specifically handled, draws node one by one, and it is automatic that the typing of drainage pipeline networks model attributes data mainly passes through computer
It realizes, greatly reduces the workload of artificial typing attribute data one by one in traditional data typing, avoid traditional artificial record
Enter attribute data intricate operation, low efficiency, error-prone disadvantage, improving work efficiency for high degree ensure that drainpipe
The quality of pessimistic concurrency control attribute data, so that the quality for drainage pipeline networks model provides safeguard.
It, only need to be by existing soft without carrying out complicated programming 3. this patent the method has operability
Each step can be completed in part tool, and operation is simple, easy to accomplish, ensure that the exploitativeness of this patent.
Detailed description of the invention:
Fig. 1 is the flow diagram that the present invention works.
Specific embodiment:
Specific implementation process of the invention is as shown in Figure 1, comprising the following steps:
(1) planning chart paper basic data processing
1.1, planning chart paper tube line data processing
Pipeline in planning chart is unified in same figure layer, the endpoint of connected pipeline is connected to a bit.
1.2, planning drawing labeled data processing
The insertion starting point of each pipeline section caliber mark text is moved into the middle position of each pipeline section, general's treated pipeline and pipe
Diameter labeled data saves as a new CAD diagram paper, is named as " caliber figure ".
The insertion starting point of ground elevation mark text at each pipeline section endpoint is moved into endpoint location, will treated pipeline and
Ground elevation labeled data saves as a new CAD diagram paper, is named as " floor plan ".
The insertion starting point of tube bottom absolute altitude mark text at each pipeline section endpoint is moved into endpoint location, will treated pipeline and
Tube bottom absolute altitude labeled data saves as a new CAD diagram paper, is named as " shaft bottom absolute altitude figure ".
(2) automatic conversion of pipeline graph data
" the caliber figure " that load step (1) saves in ArcGIS, by the data converting function of ArcGIS, by " caliber
Figure .dwg Polyline " data Layer is converted to Shapfile formatted file, is named as " pipeline data ".
(3) node graph data automatically generates
1, by " Feature Vertices To Points " (element break turning point) tool of ArcGIS at pipeline end
Point data is automatically generated at point, wherein " the pipeline data " of " input element " selection step (2), " output factor kind " are named as
" node data ", " vertex type " selection " BOTH_ENDS ".
2, by " the Add XY Coordinates " of ArcGIS (addition XY coordinate) tool, add automatically for " node data "
Add POINT_X and POINT_Y field and calculates the XY coordinate of each node automatically.
3, tool (is deleted identical) for duplicate knot removal by " the Delete Identical " of ArcGIS, wherein
" input data set " selection " node data ", field select POINT_X and POINT_Y.
(4) foundation of pipe network topological relation
Node serial number field is created in " node data " attribute list and node is numbered, and node serial number cannot weigh
It is multiple；Pipeline number, upstream node number and downstream node number field are created in " pipeline data " attribute list, according to drainpipe
Network planning draws pipe network in drawing and flows to information and node serial number, is numbered in attribute list to pipeline and inputs upstream node number
It is numbered with downstream node, pipeline number cannot repeat.
(5) automatic conversion of pipe network attribute data
5.1, the automatic conversion of pipeline caliber data
Caliber text marking information and pipeline are carried out by " Spatial Join " (space connection) tool of ArcGIS
Space connection, wherein " target component " selection " pipeline data ", " nexus element " selects " caliber figure " catalogue of step (1) load
Under " caliber figure .dwg Annotation ", " output factor kind " is named as " pipeline data 1 ", " pipeline number after the connection of space
Automatic addition Text field and caliber information will be automatically switched under the field according in 1 " attribute list.
High conduit types, caliber, width of the channel, canal, upstream bottom absolute altitude and downstream are respectively created in " pipeline data 1 " attribute list
Bottom absolute altitude field." the pipeline data 1 " file that suffix is " .dbf " is opened in Excel and saves as " caliber information .xls " text
Part splits caliber text information, is then copied to round tube caliber batch data by " point column " tool of Excel
In the caliber field of " pipeline data 1 " attribute list, width of the channel and the high batch data of canal are copied to the canal of " pipeline data 1 " attribute list
In the wide and high field of canal.
5.2, the automatic conversion of node elevation data
1, load step (1) saves in ArcGIS " shaft bottom absolute altitude figure ", by " Spatial Join ", (space connects
Connecing) shaft bottom absolute altitude text marking information is carried out space with node and connected by tool, wherein " target component " selection " node data ",
" shaft bottom absolute altitude figure .dwg Annotation " under " nexus element " selection " shaft bottom absolute altitude figure " catalogue, " output factor kind " life
Entitled " node data 1 ", will automatic addition Text field and by shaft bottom absolute altitude in " node data 1 " attribute list after the connection of space
Information is automatically switched under the field.
2, load step (1) saves in ArcGIS " floor plan ", by " Spatial Join ", (space connects
Connecing) ground elevation text marking information and node carry out space and connected by tool, wherein " target component " selection " node data
1 ", " floor plan .dwg Annotation " under " nexus element " selection " floor plan " catalogue, " output factor kind "
It is named as " node data 2 ", it will automatic addition Text1 field and by ground in " node data 2 " attribute list after the connection of space
Elevation information is automatically switched under the field.
3, ground elevation and shaft bottom absolute altitude field is respectively created in " node data 2 " attribute list, passes through ArcGIS's
" Field Calculator " (field calculator) tool, be respectively set " ground elevation=Text1 ", " shaft bottom absolute altitude=
Text " completes the automatic conversion of node elevation data.
5.3, the automatic conversion of pipeline upstream and downstream bottom elevation data
1, pass through " Join " (connection) tool in ArcGIS for the upstream node number field of " pipeline data 1 " attribute list
The node serial number field of " node data 2 " attribute list is attached, wherein " Join Options " selection " Keep only
Matching records " passes through " Field Calculator " (field calculator) tool of ArcGIS, setting after connection
" 1. upstream bottom absolute altitude of pipeline data=2. shaft bottom absolute altitude of node data " completes the automatic conversion of line upstream bottom elevation data.
2, pass through " Join " (connection) tool in ArcGIS for the downstream node number field of " pipeline data 1 " attribute list
The node serial number field of " node data 2 " attribute list is attached, wherein " Join Options " selection " Keep only
Matching records " passes through " Field Calculator " (field calculator) tool of ArcGIS, setting after connection
" 1. downstream bottom absolute altitude of pipeline data=2. shaft bottom absolute altitude of node data " completes the automatic conversion of line downstream bottom elevation data.
Claims (1)
1. the Auto-drainage pipe net leakage rate data transfer device based on drainage pipeline networks planning drawing information, which is characterized in that including
Following steps:
(1) planning chart paper basic data processing
(1.1) planning chart paper tube line data processing
Pipeline in planning chart is unified in same figure layer in CAD, the endpoint of connected pipeline is connected to a bit；
(1.2) planning drawing labeled data processing
The insertion starting point of each pipeline section caliber mark text is moved into the middle position of each pipeline section, general's treated pipeline and caliber mark
Note data save as a new CAD diagram paper, are named as " caliber figure "；
The insertion starting point of ground elevation mark text at each pipeline section endpoint is moved into endpoint location, it will treated pipeline and ground
Absolute altitude labeled data saves as a new CAD diagram paper, is named as " floor plan "；
The insertion starting point of tube bottom absolute altitude mark text at each pipeline section endpoint is moved into endpoint location, it will treated pipeline and tube bottom
Absolute altitude labeled data saves as a new CAD diagram paper, is named as " shaft bottom absolute altitude figure "；
(2) automatic conversion of pipeline graph data
" the caliber figure " that load step (1) saves in ArcGIS, by the data converting function of ArcGIS, by " caliber figure
.dwg Polyline " data Layer is converted to Shapfile formatted file, is named as " pipeline data "；
(3) node graph data automatically generates
(3.1) pass through " Feature Vertices To Points " element break turning point tool in ArcGIS in pipeline endpoint
Place automatically generates point data, wherein " the pipeline data " of " input element " selection step (2), " output factor kind " are named as " section
Point data ", " vertex type " selection " BOTH_ENDS "；
(3.2) XY coordinate tool is added by " Add XY Coordinates " in ArcGIS, added automatically for " node data "
Add POINT_X and POINT_Y field and calculates the XY coordinate of each node automatically；
(3.3) identical tool is deleted for duplicate knot removal by " Delete Identical " in ArcGIS, wherein
" input data set " selection " node data ", field select POINT_X and POINT_Y；
(4) foundation of pipe network topological relation
Node serial number field is created in " node data " attribute list and node is numbered, and node serial number cannot repeat；?
Pipeline number, upstream node number and downstream node number field are respectively created in " pipeline data " attribute list, according to drainpipe
Network planning draws pipe network in drawing and flows to information and node serial number, is numbered in attribute list to pipeline and inputs upstream node number
It is numbered with downstream node, pipeline number cannot repeat；
(5) automatic conversion of pipe network attribute data
(5.1) automatic conversion of pipeline caliber data
Caliber text marking information and pipeline are carried out by space by " Spatial Join " space fastening means in ArcGIS
Connection, wherein " target component " selection " pipeline data ", " nexus element " is selected under " caliber figure " catalogue of step (1) load
" caliber figure .dwg Annotation ", " output factor kind " is named as " pipeline data 1 ", after the connection of space " pipeline data 1 "
Text field will be added automatically in attribute list and caliber information is automatically switched under the field；
High conduit types, caliber, width of the channel, canal, upstream bottom absolute altitude and downstream bottom mark are respectively created in " pipeline data 1 " attribute list
High field；" the pipeline data 1 " file that suffix is " .dbf " is opened in Excel and saves as " caliber information .xls " file,
Caliber text information is split by " point column " tool of Excel, round tube caliber batch data is then copied into " pipeline
In the caliber field of 1 " attribute list of data, by width of the channel and the high batch data of canal copy to " pipeline data 1 " attribute list width of the channel and
In the high field of canal；
(5.2) automatic conversion of node elevation data
" the shaft bottom absolute altitude figure " that load step (1) saves in ArcGIS, will by " Spatial Join " space fastening means
Shaft bottom absolute altitude text marking information carries out space with node and connects, wherein " target component " selection " node data ", " connection is wanted
" shaft bottom absolute altitude figure .dwg Annotation " under element " selection " shaft bottom absolute altitude figure " catalogue, " output factor kind " are named as " section
Point data 1 ", after the connection of space in " node data 1 " attribute list will automatic addition Text field and by shaft bottom elevation information from
Turn is changed under the field；
" floor plan " that load step (1) saves in ArcGIS, will by " Spatial Join " space fastening means
Ground elevation text marking information carries out space with node and connects, wherein " target component " selection " node data 1 ", " connection is wanted
" floor plan .dwg Annotation " under element " selection " floor plan " catalogue, " output factor kind " are named as " section
Point data 2 ", after the connection of space in " node data 2 " attribute list will automatic addition Text1 field and by ground elevation information from
Turn is changed under the field；
Ground elevation and shaft bottom absolute altitude field is respectively created in " node data 2 " attribute list, passes through " the Field of ArcGIS
" ground elevation=Text1 ", " shaft bottom absolute altitude=Text " is respectively set in Calculator " field calculator tool, completes node
The automatic conversion of elevation data；
(5.3) automatic conversion of pipeline upstream and downstream bottom elevation data
Pass through " Join " fastening means in ArcGIS for the upstream node number field of " pipeline data 1 " attribute list and " node
The node serial number field of 2 " attribute list of data is attached, wherein " Join Options " selection " Keep only matching
Records " passes through " Field Calculator " field calculator tool of ArcGIS after connection, be arranged " in pipeline data 1.
Swim 2. shaft bottom absolute altitude of bottom absolute altitude=node data ", complete the automatic conversion of line upstream bottom elevation data；
Pass through " Join " fastening means in ArcGIS for the downstream node number field of " pipeline data 1 " attribute list and " node
The node serial number field of 2 " attribute list of data is attached, wherein " Join Options " selection " Keep only matching
Records " passes through " Field Calculator " field calculator tool of ArcGIS after connection, be arranged " under pipeline data 1.
Swim 2. shaft bottom absolute altitude of bottom absolute altitude=node data ", complete the automatic conversion of line downstream bottom elevation data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910436641.4A CN110298913B (en) | 2019-05-23 | 2019-05-23 | Automatic drainage pipe network model data conversion method based on drainage pipe network planning drawing information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910436641.4A CN110298913B (en) | 2019-05-23 | 2019-05-23 | Automatic drainage pipe network model data conversion method based on drainage pipe network planning drawing information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110298913A true CN110298913A (en) | 2019-10-01 |
| CN110298913B CN110298913B (en) | 2022-03-08 |
Family
ID=68027126
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910436641.4A Active CN110298913B (en) | 2019-05-23 | 2019-05-23 | Automatic drainage pipe network model data conversion method based on drainage pipe network planning drawing information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110298913B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112131690A (en) * | 2020-08-20 | 2020-12-25 | 同济大学 | Drainage pipe network GIS abnormal data detection and repair method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102214230A (en) * | 2011-06-27 | 2011-10-12 | 华东师范大学 | Method for setting drainage pipeline network database |
| CN102592008A (en) * | 2011-12-30 | 2012-07-18 | 华东师范大学 | Municipal drainage pipe network design system and method based on GIS (Geographic Information System) technology |
| CN105117573A (en) * | 2015-10-06 | 2015-12-02 | 北京工业大学 | Automatic hydraulic model establishment method based on CAD drainage network drawing information |
| CN105701264A (en) * | 2014-11-28 | 2016-06-22 | 星际空间（天津）科技发展有限公司 | Automatic construction method for underground pipe network |
| CN106294572A (en) * | 2016-07-28 | 2017-01-04 | 北京工业大学 | A kind of elevation map rapid generation based on AutoCAD data source and ArcGIS instrument |
| CN109359351A (en) * | 2018-09-27 | 2019-02-19 | 济南市市政工程设计研究院（集团）有限责任公司 | A kind of pipeline three-dimensional modeling method and pipe design method |
-
2019
- 2019-05-23 CN CN201910436641.4A patent/CN110298913B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102214230A (en) * | 2011-06-27 | 2011-10-12 | 华东师范大学 | Method for setting drainage pipeline network database |
| CN102592008A (en) * | 2011-12-30 | 2012-07-18 | 华东师范大学 | Municipal drainage pipe network design system and method based on GIS (Geographic Information System) technology |
| CN105701264A (en) * | 2014-11-28 | 2016-06-22 | 星际空间（天津）科技发展有限公司 | Automatic construction method for underground pipe network |
| CN105117573A (en) * | 2015-10-06 | 2015-12-02 | 北京工业大学 | Automatic hydraulic model establishment method based on CAD drainage network drawing information |
| CN106294572A (en) * | 2016-07-28 | 2017-01-04 | 北京工业大学 | A kind of elevation map rapid generation based on AutoCAD data source and ArcGIS instrument |
| CN109359351A (en) * | 2018-09-27 | 2019-02-19 | 济南市市政工程设计研究院（集团）有限责任公司 | A kind of pipeline three-dimensional modeling method and pipe design method |
Non-Patent Citations (2)
| Title |
|---|
| 周玉文等: "给排水管网数据从AutoCAD至ArcGIS转换的研究", 《给水排水》 * |
| 郑伟等: "排水管网CAD数据导入ArcGIS的方法研究", 《安徽建筑工业学院学报(自然科学版)》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112131690A (en) * | 2020-08-20 | 2020-12-25 | 同济大学 | Drainage pipe network GIS abnormal data detection and repair method |
| CN112131690B (en) * | 2020-08-20 | 2022-11-04 | 同济大学 | Method for detecting and repairing drainage pipe network GIS abnormal data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110298913B (en) | 2022-03-08 |
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 | |
| CN101640001B (en) | Simulation-system-oriented road network drawing device and method therefor | |
| CN104679954A (en) | Method and system for lightening BIM (Building Information Modeling) model | |
| CN109902138B (en) | Urban one-dimensional hydrodynamic simulation basic data topological relation construction and encoding method based on GIS | |
| CN110889160A (en) | Municipal pipeline construction method based on BIM technology | |
| CN106649968A (en) | Visualization design system and method for village water supply pipeline network | |
| CN109598056A (en) | Measurement Method, system and the storage medium of town site form compactness | |
| CN102214230A (en) | Method for setting drainage pipeline network database | |
| CN110298913A (en) | Auto-drainage pipe net leakage rate data transfer device based on drainage pipeline networks planning drawing information | |
| CN201820263U (en) | Field pipeline data acquisition and update system based on topological relation | |
| CN110298075B (en) | Urban municipal drainage pipeline one-map modeling processing method based on ArcGIS + InfoWorks ICM | |
| CN110287532B (en) | Drainage pipe network planning drawing information modeling processing method based on ArcGIS + InfWorks ICM | |
| 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 | |
| CN104318501A (en) | Pipeline network topological relation establishment method, device and system | |
| CN107423520A (en) | Based on CAD secondary development rapid extraction pipeline information SWMM modeling methods | |
| CN112580131A (en) | Rapid search connection method for sub-catchment areas based on GIS (geographic information System) and SWMM (Single wire Meter-based Module) | |
| CN114818064A (en) | Medium-voltage distribution network bank planning method based on multi-project optimization | |
| CN110287531B (en) | Drainage pipe network model data conversion method based on one map of urban municipal pipelines | |
| CN104156514A (en) | INP (input) file-based rapid generation method of water supply network topological structure | |
| Zhao et al. | Research on the feasibility of solving problems in construction of sponge city based on gis, vr and bim combined technology | |
| Han et al. | Pipeline data calibration for the construction of three-dimensional underground pipeline system | |
| CN115391856B (en) | BIM-based outdoor pipe network parameterized modeling method and system |
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 |