Auto hydraulic model building method based on CAD drainage pipeline networks drawing informations
Technical field
The present invention relates to a kind of auto hydraulic model building method based on CAD drainage pipeline networks drawing informations, belongs to municipal administration
Engineering information technology and geographic information system technology crossing domain.
Background technology
Sewerage pipeline network is important urban infrastructure, be responsible for collection and conveying municipal sewage and Urban Rain,
The task of runoff caused by snow melt, there is environmental protection and Urban disasters reduction moving dual-use function, " lifeline " and " blood referred to as city
Arteries and veins ", the effect in urban planning and construction can not be ignored.With the quickening that domestic cityization is carried out, urban drainage pipe network is built
Existing explosive growth is set out, pipe network scale expands day by day, and pipe network data is constantly updated, existing urban drainage pipe network operation and pipe
Reason mode lags far behind urban construction.The plan and skiagraph of drainage pipeline networks are the main figures of waste pipe-network design
Paper, the spatial data and attribute data of pipe network are store, due to the advantages that AutoCAD is easy to learn, beautiful interface, municipal drainage
The pipe network drawing overwhelming majority is stored with CAD file format.CAD memory space data in the form of figure layer, with the shape of skiagraph
Formula stores basic attribute data, but does not consider the relation between the attribute of data and data, lacks and pipe network data topology is closed
The description of system, the complicated spatial relationship of drainage pipeline networks can not be embodied.
With the development of computer technology, unique advantages of the ArcGIS in terms of geospatial database is established is increasingly prominent
Go out, the application in hydraulic model is more and more.Data management and spatial analysis can be carried out using GIS, can also be directly perceived, dynamic
State it is modeled or visualized management.GIS data is stored in the form of point, line, surface, can show the spatial distribution feelings of figure
Condition and geometry situation, record the attribute data of figure.GIS carries out the management of data, data mode system using unified database
One.With the development of hydraulic model technology, how effective CAD drainage pipelines net project drawing informations to be input to GIS moulds
Type database is particularly important.
TrueTable (truth table) software is a software based on CAD platforms, can between CAD and Excel mutual conductance
Form, it can export, update arbitrary form in CAD.TrueTable major function has:(1) by the form or text in CAD
It is output to Excel;(2) by the form in CAD or text output to text (TXT) or csv file;(3) CAD is directly exported
In arbitrary form, even if these forms are complicated entities;(4) other specific functions.
CAD drainage pipelines net projects drawing information input GIS model databases include graph data typing and attribute data is recorded
Enter two parts.The structure of conventional hydraulic model, layered shaping need to be carried out to CAD graphical data, and inspection shaft figure layer be carried out special
Fixed processing, due to the disunity of CAD Graphings of Engineering, the workload that layered shaping is carried out to CAD diagram paper is big and cumbersome;Drainage pipeline networks
Attribute data majority be present in skiagraph, traditional attribute data typing be typically by substantial amounts of manual operation one by one
Typing, such as shaft bottom elevation, the well depth of inspection shaft, the upstream and downstream ttom of pipe elevation of pipeline etc., because urban pipe network is intricate, largely
Manual entry easily there is mistake, operating efficiency is low, and the quality of database is low, it is impossible to ensures the quality of hydraulic model.
The defects of being built based on above-mentioned hydraulic model, the demand that the present invention is built from hydraulic model, based on CAD drainings
The storage condition of pipe network drawing information, without carrying out complicated layered shaping to CAD engineering drawings, and will artificial typing category one by one
The work of property data is largely simplified, and using TrueTable softwares, CAD skiagraph attribute data Batch conversions are arrived
GIS database, automation and the mass of data inputting are realized, greatly reduce the troublesome operation of artificial logging data one by one, carry
The operating efficiency of high data inputting, ensure the quality of model data, so as to improve the quality of structure hydraulic model.
The content of the invention
The present invention is mainly that solution is currently based on CAD drainage pipeline networks drawing information structure hydraulic model, to CAD engineering drawings
Data hierarchy handles intricate operation, and manually typing attribute data workload is big one by one, and operating efficiency is low, mistake, mould easily occurs
A kind of low-quality shortcoming of type, it is proposed that auto hydraulic model building method based on CAD drainage pipeline networks drawing informations.
Technical scheme is as follows:
Based on the auto hydraulic model building method of CAD drainage pipeline networks drawing informations, methods described includes following step successively
Suddenly:
(1) hydraulic model database is established;
According to the demand of structure hydraulic model, the Shapfile texts needed for hydraulic model database are created in ArcGIS
Part, element type is set, adds attribute list mandatory field.The Feature Type of inspection shaft are arranged to Point attributes, pipeline
Feature Type are arranged to Polyline attributes, and inspection shaft attribute literary name section includes numbering, XY coordinates, shaft bottom elevation, well depth,
Pipeline attribute literary name section includes numbering, Inlet and outlet water node serial number, upstream and downstream ttom of pipe elevation, upstream and downstream ttom of pipe buried depth.
(2) CAD drainage pipeline networks drawings are handled;
The drawing of drainage pipeline networks includes plan and skiagraph, and the processing of CAD drainage pipeline networks drawings includes pipe network plane
The processing of drawing and profile paper handle two parts.The processing of plane drawing, it is complicated numerous without being carried out to CAD diagram paper by key element
Trivial layered shaping, without specifically being handled inspection shaft figure layer, simple figure layer process only need to be carried out, treatment principle is
" opening related figure layer, close unrelated figure layer ", make the related figure layer of the figure layer relevant to hydraulic model such as inspection shaft, pipeline all in
Opening, to identify pipe network graph data, make the unrelated figure layer such as house road all in closed mode, so as to not influence to manage
The typing of net graph data.In addition, the coordinate system of all plane drawings is unified, height datum is consistent, the engineer's scale of drawing
It is identical.The processing of profile paper, first have to judge whether profile paper information is complete, for complete skiagraph
Paper, the flow direction of pipeline is judged according to profile paper, if profile paper information is imperfect, need to be supplemented completely.It is vertical disconnected
Face drawing is dealt with relationship to the conversion of attribute data.
(3) typing graph data;
According to the CAD drainage pipeline networks plane drawings after processing, the graph data of inspection shaft, pipeline figure layer is entered into GIS
In figure layer key element Shapfile corresponding to database.It is corresponding with profile paper information in Input Process, such as skiagraph
The numbering of middle inspection shaft is J1, J2, J3 ... Jn, then when inspection shaft is added in GIS, is added successively according to corresponding order,
The addition of pipeline is still added successively in sequence, after inspection shaft and pipeline attribute table sort according to FID in GIS and skiagraph
The order of paper is corresponding, consequently facilitating realizing the batch input of attribute data, improves the accuracy of data.
(4) typing attribute data;
According to the CAD drainage pipeline networks drawings after processing, by the relevant rudimentary data of the inspection shaft needed for hydraulic model, pipeline
It is entered into each field that GIS database corresponds to figure layer key element.Attribute data corresponds with graph data.Inspection shaft and pipe
The numbering in road and the upstream and downstream node number of pipeline according to profile paper corresponding to sequential batch typing, the XY of inspection shaft sits
Mark is completed using GIS space calculating instrument, above and below the ground elevation, shaft bottom elevation, well depth or pipeline for inspection shaft
Play pipe bottom elevation and buried depth, traditional way are cumbersome by manual operation typing one by one, this method according to profile paper
Complexity, workload is big, and efficiency is low, mistake easily occurs, it is impossible to ensures model quality.
TrueTable (truth table) software is a software based on CAD platforms, can between CAD and Excel mutual conductance
Form, it can export, update arbitrary form in CAD.After installing TrueTable, TrueTable can be automatically loaded into CAD, beaten
TrueTable menus will be shown in its toolbar by opening CAD.TrueTable is shareware, does not register and could be used that big portion
Divide function, its repertoire can be used after purchase registration.TrueTable major function has:(1) by the form in CAD
Or text output is to Excel;(2) by the form in CAD or text output to text (TXT) or csv file;(3) directly
The arbitrary form in CAD is exported, even if these forms are complicated entities;(4) other specific functions.
Attribute data storage condition and GIS database attribute data based on CAD drainage pipeline networks profile papers are deposited
Storage form, using TrueTable by the pipe network attribute data batch signatures in CAD drainage pipeline networks skiagraphs to Excel,
Output data is handled accordingly in Excel, the batch data after processing is then input to GIS database, you can be fast
The fast batch input for accurately completing pipe network attribute data.Such as in skiagraph the numbering of inspection shaft be followed successively by J1, J2,
J3 ... Jn, choose J1, J2, J3 using TrueTable in CAD ... shaft bottom elevation, well depth attribute data corresponding to Jn,
By the shaft bottom elevation corresponding to J1, J2, J3 ... Jn and well depth data batch signatures to Excel, data are carried out in Excel
Transposition processing, then batch input completes the typing of attribute data into GIS database.
(5) data inspection;
The type of error of pipe network data is broadly divided into CAD initial data mistake and the major class of data inputting mistake two.Complete number
According to needing to carry out corresponding data inspection after typing, if finding wrong data, the original drawing verifications of CAD are returned to, to error number
According to being modified.
(6) mode input (conversion) is set with model;
Input file by the GIS database built as SWMM models.
The beneficial effect of auto hydraulic model building method of the present invention based on CAD drainage pipeline networks drawing informations is main
It is embodied in:
1. using method of the present invention, existing CAD drainage pipeline networks plan and profile paper can be utilized to believe
Breath, realizes effective typing of pipe net leakage rate data, is provided conveniently for the structure of hydraulic model.
2. the present invention greatly reduces traditional data record without carrying out cumbersome layered shaping by key element to CAD data
The workload of artificial typing attribute data one by one, it is low, easy to avoid Traditional Man typing attribute data intricate operation, efficiency in entering
The shortcomings that error, while the workload of data inspection is reduced, high degree improves operating efficiency, ensure that model attributes
The quality of data inputting, so as to ensure the quality of hydraulic model.
, only need to be by existing soft without carrying out complicated programming 3. the method for the invention has operability
Part can complete each step, and operation is simple, easily realize, ensure that the exploitativeness of the present invention.
Brief description of the drawings:
Fig. 1 is the schematic flow sheet that the present invention works.
Embodiment:
The specific implementation flow of the present invention is as shown in figure 1, comprise the following steps:
(1) hydraulic model database is built.Shapfile files, including inspection shaft and pipeline are created in ArcGIS, if
The Feature Type for putting inspection shaft are Point attributes, and the Feature Type of pipeline are Polyline attributes.In establishment
The field of indispensability is added in the attribute list of shp files, inspection shaft attribute list includes numbering, shaft bottom absolute altitude, well depth, ground elevation, X
Coordinate, Y-coordinate field, pipeline attribute table include pipe number, upstream node, downstream node, upstream tube bottom absolute altitude, downstream tube bottom
Absolute altitude, upstream buried depth, downstream buried depth, pipe range, caliber field;
(2) CAD drainage pipeline networks drawings are handled.The original drainage pipeline networks drawing processings of CAD include processing drainage pipeline networks plan
Paper and processing drainage pipeline networks profile paper two parts.The processing of plane drawing, first carry out figure layer processing, make inspection shaft,
Pipeline figure layer is in opening, and the coordinate system and height datum of unified all plane drawings are unified by the engineer's scale of drawing.It is vertical
The processing of section drawing, first have to judge whether profile paper information is complete, for complete profile paper, according to vertical disconnected
Face drawing judges the flow direction of pipeline, if profile paper information is imperfect, needs to be supplemented completely.
(3) typing graph data.By the relational graph data inputtings such as the inspection shaft in CAD plane drawings, pipeline to GIS numbers
According in figure layer key element Shapfile corresponding to storehouse.It is corresponding with profile paper information in Input Process, in skiagraph
The numbering of inspection shaft is J1, J2, J3 ... Jn, then when inspection shaft is added in GIS, adds, manage successively according to corresponding order
The addition in road is still added successively in sequence, and the attribute list of inspection shaft and pipeline sorts according to FID order in GIS, made
The order of inspection shaft and pipeline is corresponding with CAD profile papers in GIS.
(4) typing attribute data.Inspection shaft that CAD drainage pipeline networks drawings are provided, the basic data of pipeline are entered into GIS
Database is corresponded in each field of figure layer key element.The upstream and downstream node number of the numbering and pipeline of inspection shaft and pipeline according to
Sequential batch typing corresponding to profile paper, the XY coordinates of inspection shaft are completed using GIS space calculating instrument, for checking
The ground elevation of well, shaft bottom absolute altitude, ttom of pipe absolute altitude, the ttom of pipe buried depth of well depth either pipeline, using TrueTable instruments batch
Conversion.For example the numbering of inspection shaft is followed successively by J1, J2, J3 in skiagraph ... Jn, in CAD, using TrueTable according to
The attribute datas such as shaft bottom elevation, well depth corresponding to secondary to choose J1, J2, J3 ... Jn, by corresponding to J1, J2, J3 ... Jn
The batch data such as shaft bottom elevation and well depth is output to Excel, and data are carried out into transposition processing in Excel, recorded in batches after processing
Enter into field corresponding to GIS database inspection shaft attribute list, complete the batch input of attribute data.
(5) data inspection is carried out.The inspection of pipe network generality topological relation, pipeline dislocation inspection are carried out after completing data inputting
Look into, the inspection of pipeline adverse grade and pipeline upstream and downstream tracking etc..If wrong data, profile paper verification is returned to, amendment is wrong
Data by mistake.
(6) input file by the GIS database built as SWMM models.