Based on the auto hydraulic model building method of CAD drainage pipeline networks drawing information
Technical field
The present invention relates to a kind of auto hydraulic model building method based on CAD drainage pipeline networks drawing information, belong to municipal works infotech and geographic information system technology crossing domain.
Background technology
Sewerage pipeline network is important urban infrastructure; be responsible for the task of the runoff collecting and carry municipal effluent and Urban Rain, snow melt to produce; there is protection of the environment and Urban disasters reduction moving dual-use function; be referred to as " lifeline " and " blood vessels " in city, can not be ignored in city planning and the effect in building.Along with the quickening that domestic city is carried out, there is explosive growth in urban drainage pipe network construction, pipe network scale expanding day, and pipe network data are constantly updated, and existing urban drainage pipe network operation and management mode lags far behind urban construction.The planimetric map of drainage pipeline networks and skiagraph are the main drawings of waste pipe-network design, store spatial data and the attribute data of pipe network, due to advantages such as AutoCAD is easy to learn, beautiful interfaces, municipal drainage pipe network drawing is the overwhelming majority store with cad file form.CAD, with the form storage space data of layer, stores basic attribute data with the form of skiagraph, but does not consider the relation between the attribute of data and data, lack the description to pipe network data topology relation, cannot embody the spatial relationship of drainage pipeline networks complexity.
Along with the development of computer technology, ArcGIS becomes increasingly conspicuous setting up the unique advantage in geospatial database, and the application in hydraulic model gets more and more.Application GIS can carry out data management and spatial analysis, also intuitively, dynamically can carry out modeling or visualized management.GIS data stores with the form of point, line, surface, can show space distribution situation and the geometry situation of figure, the attribute data of recording geometry.GIS adopts unified database to carry out the management of data, and data mode is unified.Along with the development of hydraulic model technology, how effectively CAD drainage pipelines net project drawing information is input to GIS model database seems particularly important.
TrueTable (true form) software is a software based on CAD platform, can between CAD and Excel mutual conductance form, to export, the arbitrary form upgraded in CAD.The major function of TrueTable has: (1) by the form in CAD or text output to Excel; (2) by the form in CAD or text output to text (TXT) or csv file; (3) arbitrary form in CAD is directly exported, even if these forms are complicated entities; (4) other specific function.
CAD drainage pipelines net project drawing information input GIS model database comprises graph data typing and attribute data typing two parts.The structure of conventional hydraulic model, need carry out layered shaping to CAD graph data, and carry out particular procedure to inspection chamber layer, and due to the disunity of CAD Graphing of Engineering, the workload of CAD drawing being carried out to layered shaping is large and loaded down with trivial details; The attribute data majority of drainage pipeline networks is present in skiagraph, traditional attribute data typing normally relies on a large amount of manual operations typing one by one, as shaft bottom elevation, the well depth of inspection chamber, the elevation at the bottom of play pipe up and down etc. of pipeline, because urban pipe network is intricate, easily there is mistake in a large amount of manual entries, inefficiency, the quality of database is low, can not ensure the quality of hydraulic model.
Based on the defect that above-mentioned hydraulic model builds, the demand that the present invention builds from hydraulic model, based on the storage condition of CAD drainage pipeline networks drawing information, without the need to carrying out complicated layered shaping to CAD engineering drawing, and a large amount of simplification is carried out in the work of artificial typing attribute data one by one, application TrueTable software, by CAD skiagraph attribute data Batch conversion to GIS database, realize robotization and the mass of data inputting, the troublesome operation of the artificial logging data one by one of very big minimizing, improve the work efficiency of data inputting, ensure the quality of model data, thus improve the quality building hydraulic model.
Summary of the invention
It is current based on CAD drainage pipeline networks drawing information structure hydraulic model that the present invention is mainly solution, loaded down with trivial details to the work for the treatment of of CAD engineering drawing data hierarchy, it is artificial that typing attribute data workload is large one by one, inefficiency, easily there is mistake, the shortcoming that model quality is low, proposes a kind of auto hydraulic model building method based on CAD drainage pipeline networks drawing information.
Technical scheme of the present invention is as follows:
Based on the auto hydraulic model building method of CAD drainage pipeline networks drawing information, described method comprises following steps successively:
(1) hydraulic model database is set up;
According to the demand building hydraulic model, in ArcGIS, create the Shapfile file needed for hydraulic model database, element type is set, add attribute list mandatory field.The FeatureType of inspection chamber is set to Point attribute, the FeatureType of pipeline is set to Polyline attribute, inspection chamber attribute list field comprises numbering, XY coordinate, shaft bottom elevation, well depth, and pipeline attribute literary name section comprises numbering, Inlet and outlet water node serial number, up and down elevation, up and down buried depth at the bottom of play pipe at the bottom of play pipe.
(2) CAD drainage pipeline networks drawing is processed;
The drawing of drainage pipeline networks comprises planimetric map and skiagraph, and the process of CAD drainage pipeline networks drawing comprises process and profile paper process two parts of pipe network plane drawing.The process of plane drawing, without the need to carrying out complicated loaded down with trivial details layered shaping to CAD drawing by key element, without the need to specifically processing inspection chamber layer, only need carry out simple layer process, treatment principle is " open relevant layer, close irrelevant layer ", the layer relevant with hydraulic model such as inspection chamber, pipeline layer of being correlated with is made all to be in opening, to identify pipe network graph data, make the irrelevant layer such as house road all be in closed condition, thus do not affect the typing of pipe network graph data.In addition, the coordinate system of all plane drawings is unified, height datum wants consistent, and the engineer's scale of drawing is identical.The process of profile paper, first will judge that whether profile paper information is complete, for complete profile paper, judge the flow direction of pipeline according to profile paper, if profile paper information is imperfect, then needs to be supplemented complete.The conversion of the attribute data of dealing with relationship of profile paper.
(3) typing graph data;
According to the CAD drainage pipeline networks plane drawing after process, the graph data of inspection chamber, pipeline layer is entered in layer key element Shapfile corresponding to GIS database.In Input Process, corresponding with profile paper information, J1, J2, J3 is numbered as inspection chamber in skiagraph ... Jn, when then adding inspection chamber in GIS, add successively according to the order of correspondence, the interpolation of pipeline is still added in order successively, and in GIS, inspection chamber and pipeline attribute table are according to corresponding with the order of profile paper after FID sequence, thus be convenient to the batch input realizing attribute data, improve the accuracy of data.
(4) typing attribute data;
According to the CAD drainage pipeline networks drawing after process, by the relevant rudimentary data inputting of the inspection chamber needed for hydraulic model, pipeline in each field of the corresponding layer key element of GIS database.Attribute data and graph data one_to_one corresponding.The numbering of inspection chamber and pipeline and the upstream and downstream node number of pipeline are according to the sequential batch typing corresponding with profile paper, the XY coordinate of inspection chamber utilizes the space computational tool of GIS to complete, for elevation at the bottom of play pipe and the buried depth up and down of the ground elevation of inspection chamber, shaft bottom elevation, well depth or pipeline, traditional way is by manual operation typing one by one according to profile paper, this method very complicated, workload is large, and efficiency is low, easily there is mistake, can not model quality be ensured.
TrueTable (true form) software is a software based on CAD platform, can between CAD and Excel mutual conductance form, to export, the arbitrary form upgraded in CAD.After installing TrueTable, TrueTable can be loaded in CAD automatically, opens CAD and just can show TrueTable menu in its toolbar.TrueTable is shareware, does not register and also can use most of function, can use its repertoire after buying registration.The major function of TrueTable has: (1) by the form in CAD or text output to Excel; (2) by the form in CAD or text output to text (TXT) or csv file; (3) arbitrary form in CAD is directly exported, even if these forms are complicated entities; (4) other specific function.
Based on the attribute data storage condition of CAD drainage pipeline networks profile paper and the file layout of GIS database attribute data, apply TrueTable by the pipe network attribute data batch signatures in CAD drainage pipeline networks skiagraph to Excel, in Excel, output data are processed accordingly, then the batch data after process is input to GIS database, the batch input of pipe network attribute data can be completed fast and accurately.Such as in skiagraph, the numbering of inspection chamber is followed successively by J1, J2, J3 ... Jn, in CAD, apply TrueTable choose J1, J2, J3 ... shaft bottom elevation corresponding to Jn, well depth attribute data, by J1, J2, J3 ... shaft bottom elevation corresponding to Jn and well depth batch data output to Excel, in Excel, transpose process is carried out to data, then batch input is in GIS database, completes the typing of attribute data.
(5) data check;
The type of error of pipe network data is mainly divided into CAD raw data mistake and the large class of data inputting mistake two.Need after completing data inputting to carry out corresponding data check, if find that there is misdata, return the original drawing of CAD and check, misdata is revised.
(6) mode input (conversion) and model are arranged;
By the GIS database that the builds input file as SWMM model.
The beneficial effect of the auto hydraulic model building method based on CAD drainage pipeline networks drawing information of the present invention is mainly reflected in:
1. adopt method of the present invention, existing CAD drainage pipeline networks planimetric map and profile paper information can be utilized, realize effective typing of pipe net leakage rate data, for the structure of hydraulic model is provided convenience.
2. the present invention is without the need to carrying out loaded down with trivial details layered shaping to cad data by key element, greatly reduce the workload of artificial typing attribute data one by one in traditional data typing, avoid the shortcoming that Traditional Man typing attribute data intricate operation, efficiency are low, easily make mistakes, reduce the workload of data check simultaneously, high degree improve work efficiency, ensure that the quality of model attributes data inputting, thus the quality of hydraulic model can be ensured.
3. the method for the invention has operability, without the need to carrying out complicated programming, only need can complete each step by existing software, operating simple and easy, easily realize, ensure that exploitativeness of the present invention.
Accompanying drawing illustrates:
Fig. 1 is the schematic flow sheet of work of the present invention.
Embodiment:
Specific embodiment of the invention flow process as shown in Figure 1, comprises the following steps:
(1) hydraulic model database is built.In ArcGIS, create Shapfile file, comprise inspection chamber and pipeline, the FeatureType arranging inspection chamber is Point attribute, and the FeatureType of pipeline is Polyline attribute.Indispensable field is added in the attribute list of the shp file created, inspection chamber attribute list comprises numbering, shaft bottom absolute altitude, well depth, ground elevation, X-coordinate, Y-coordinate field, and pipeline attribute table comprises absolute altitude, upstream buried depth, downstream buried depth, pipe range, caliber field at the bottom of absolute altitude, downstream tube at the bottom of pipe number, upstream node, downstream node, upstream tube;
(2) CAD drainage pipeline networks drawing is processed.The original drainage pipeline networks drawing processing of CAD comprises process drainage pipeline networks plane drawing and process drainage pipeline networks profile paper two parts.The process of plane drawing, first carries out the process of layer, makes inspection chamber, pipeline layer is in opening, the coordinate system of unified all plane drawings and height datum, and the engineer's scale of drawing is unified.The process of profile paper, first will judge that whether profile paper information is complete, for complete profile paper, judge the flow direction of pipeline according to profile paper, if profile paper information is imperfect, then needs to be supplemented complete.
(3) typing graph data.By the relational graph data inputting such as inspection chamber, pipeline in CAD plane drawing in layer key element Shapfile corresponding to GIS database.In Input Process, corresponding with profile paper information, J1, J2, J3 is numbered as inspection chamber in skiagraph ... Jn, when then adding inspection chamber in GIS, add successively according to the order of correspondence, the interpolation of pipeline is still added in order successively, is sorted by the attribute list of inspection chamber and pipeline in GIS according to the order of FID, makes inspection chamber in GIS corresponding with CAD profile paper with the order of pipeline.
(4) typing attribute data.The inspection chamber provided by CAD drainage pipeline networks drawing, the basic data of pipeline are entered in each field of the corresponding layer key element of GIS database.The numbering of inspection chamber and pipeline and the upstream and downstream node number of pipeline are according to the sequential batch typing corresponding with profile paper, the XY coordinate of inspection chamber utilizes the space computational tool of GIS to complete, for buried depth at the bottom of absolute altitude, pipe at the bottom of the pipe of the ground elevation of inspection chamber, shaft bottom absolute altitude, well depth or pipeline, application TrueTable instrument Batch conversion.Such as in skiagraph, the numbering of inspection chamber is followed successively by J1, J2, J3 ... Jn, in CAD, application TrueTable chooses J1, J2, J3 successively ... the attribute data such as shaft bottom elevation, well depth corresponding to Jn, by J1, J2, J3 ... the batch data such as the shaft bottom elevation corresponding to Jn and well depth output to Excel, in Excel, data are carried out transpose process, after process, batch input is in field corresponding to GIS database inspection chamber attribute list, completes the batch input of attribute data.
(5) data check is carried out.Complete the general topological relation inspection of the laggard line pipe net of data inputting, pipeline dislocation inspection, the inspection of pipeline adverse grade and the tracking of pipeline upstream and downstream etc.If wrong data, turn back to profile paper and check, correct mistakes data.
(6) by the GIS database that the builds input file as SWMM model.