CN118114412A

CN118114412A - CAD drawing generation method and device, electronic equipment and storage medium

Info

Publication number: CN118114412A
Application number: CN202410170907.6A
Authority: CN
Inventors: 阎达明
Original assignee: Beijing MetarNet Technologies Co Ltd
Current assignee: Beijing MetarNet Technologies Co Ltd
Priority date: 2024-02-06
Filing date: 2024-02-06
Publication date: 2024-05-31

Abstract

The application relates to the technical field of computers, and provides a CAD drawing generation method, a CAD drawing generation device, electronic equipment and a storage medium, wherein the CAD drawing generation method comprises the following steps: acquiring pipeline resources of pipeline engineering from a database based on engineering identification of the pipeline engineering; determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable section information in the pipeline resource; drawing point resources and line resources in pipeline resources in an initial CAD drawing, and inserting resource attribute data into the initial CAD drawing in a form of a table to generate a CAD drawing of pipeline engineering; the dot resources, line resources, and resource attribute data are within the outline size range. According to the application, pipeline resources are obtained from the ArcGIS geographic database, so that the time and labor cost for collecting resource data are reduced, and meanwhile, the CAD drawing is automatically generated, so that the CAD drawing generation efficiency and accuracy are improved.

Description

CAD drawing generation method and device, electronic equipment and storage medium

Technical Field

The present application relates to the field of computer technologies, and in particular, to a method and apparatus for generating a CAD drawing, an electronic device, and a storage medium.

Background

With the continuous expansion of the network scale of operators, the total amount of dummy resource equipment and maintenance requirements are increasing. In the actual construction or maintenance process, a site constructor needs a specific construction scheme, and construction analysis is usually carried out according to CAD drawings.

Currently, the generation of CAD drawings requires the collection and arrangement of a large amount of pipeline resource data, which is a burdensome task to manually collect, requiring a significant amount of time and labor costs. Meanwhile, the process of manually drawing the CAD drawing is long in time consumption and easy to make mistakes, and is difficult to meet the requirement of large-scale pipeline resources. Therefore, the low CAD drawing generation efficiency becomes a problem to be solved urgently.

Disclosure of Invention

The application provides a CAD drawing generation method, device, electronic equipment and storage medium, which are used for solving the problem of low CAD drawing generation efficiency in the prior art.

The application provides a generation method of CAD drawings, which comprises the following steps:

Acquiring pipeline resources of pipeline engineering from a database based on engineering identification of the pipeline engineering;

Determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable section information in the pipeline resource;

Drawing point resources and line resources in the pipeline resources in the initial CAD drawing, and inserting resource attribute data into the initial CAD drawing in a form of a table so as to generate a CAD drawing of the pipeline engineering; the point resource, the line resource, and the resource attribute data are within the outline size range.

According to the method for generating the CAD drawing provided by the application, the drawing of the point resource and the line resource in the pipeline resource in the initial CAD drawing comprises the following steps:

Creating element classes of the initial CAD drawing; the element class comprises a first element class of point resources and a second element class of line resources;

Inserting a first field into the first element class, and setting attribute information of the first field; the first field is used for identifying the type of the point resource;

matching a resource legend from a preset seed file based on the type of the point resource, and inserting the legend name of the resource legend into the first element class as an attribute of a second field; the second field is used for identifying a legend corresponding to the point resource;

And drawing the longitude and latitude information of the optical cable section and the longitude and latitude information of the bearing section in the pipeline resource into the second element class.

According to the CAD drawing generation method provided by the application, the optical cable section and the bearing section are marked with different colors; and a distance is set between the optical cable section and the bearing section at intervals.

According to the method for generating the CAD drawing provided by the application, after the latitude and longitude information of the optical cable section and the latitude and longitude information of the bearing section in the pipeline resource are drawn into the second element class, the method further comprises:

Inserting the length value of the optical cable section at the midpoint position of the optical cable section, and inserting the length value of the bearing section at the midpoint position of the bearing section.

According to the method for generating the CAD drawing provided by the application, the resource attribute data is inserted into the initial CAD drawing in a form of a table, and the method comprises the following steps:

Inserting at least one third field in the first element class; the third field is used for identifying attribute information of the resource attribute data;

inserting the form data of the resource attribute data into a third field corresponding to the first element class line by line;

or inserting the form data of the resource attribute data into a third field corresponding to the first element class in batch.

According to the method for generating the CAD drawing provided by the application, the method for determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable segment information in the pipeline resource comprises the following steps:

acquiring longitude and latitude information of each bearing section and longitude and latitude information of each bearing facility based on the bearing information;

acquiring longitude and latitude information of each optical cable section based on the optical cable section information;

determining a longitude maximum value, a longitude minimum value, a latitude maximum value and a latitude minimum value based on the longitude and latitude information of each bearing section, the longitude and latitude information of each bearing facility and the longitude and latitude information of each optical cable section;

And determining the outline dimension of the initial CAD drawing based on the longitude maximum value, the longitude minimum value, the latitude maximum value, the latitude minimum value, the longitude difference between the longitude maximum value and the longitude minimum value and the latitude difference between the latitude maximum value and the latitude minimum value.

According to the method for generating a CAD drawing provided by the present application, the determining the outline dimension of the initial CAD drawing based on the longitude maximum, the longitude minimum, the latitude maximum, the latitude minimum, the longitude difference between the longitude maximum and the longitude minimum, and the latitude difference between the latitude maximum and the latitude minimum includes:

Determining a first quotient of the longitude difference and a target value, and a second quotient of the latitude difference and the target value;

Determining a first coordinate point based on a sum of the longitude maximum and the first quotient and a sum of the latitude maximum and the second quotient;

Determining a second coordinate point based on a difference between the latitude minimum value and the second quotient value based on a sum of the longitude maximum value and the first quotient value;

determining a third coordinate point based on a difference between the longitude minimum and the first quotient and a difference between the latitude minimum and the second quotient;

determining a fourth coordinate point based on a difference between the longitude minimum and the first quotient and a sum of the latitude maximum and the second quotient;

And determining the outline dimension of the initial CAD drawing based on the first coordinate point, the second coordinate point, the third coordinate point and the fourth coordinate point.

The application provides a device for generating CAD drawings, which comprises:

The pipeline resource acquisition module is used for acquiring pipeline resources of the pipeline engineering from the database based on engineering identification of the pipeline engineering;

the outline dimension determining module is used for determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable section information in the pipeline resource;

the CAD drawing generation module is used for drawing point resources and line resources in the pipeline resources in the initial CAD drawing, and inserting resource attribute data into the initial CAD drawing in a form of a table so as to generate a CAD drawing of the pipeline engineering; the point resource, the line resource, and the resource attribute data are within the outline size range.

The application also provides an electronic device, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the generation method of the CAD drawing when executing the program.

The present application also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a method of generating a CAD drawing as described in any one of the above.

According to the CAD drawing generation method, device, electronic equipment and storage medium, pipeline resources of pipeline engineering are obtained from a database through engineering identifications based on the pipeline engineering; determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable section information in the pipeline resource; drawing point resources and line resources in pipeline resources in an initial CAD drawing, and inserting resource attribute data into the initial CAD drawing in a form of a table to generate a CAD drawing of pipeline engineering; the dot resources, line resources, and resource attribute data are within the outline size range. According to the application, pipeline resources are obtained from the ArcGIS geographic database, so that the time and labor cost for collecting resource data are reduced, and meanwhile, the CAD drawing is automatically generated, so that the CAD drawing generation efficiency and accuracy are improved.

Drawings

In order to more clearly illustrate the application or the technical solutions of the prior art, the following description will briefly explain the drawings used in the embodiments or the description of the prior art, and it is obvious that the drawings in the following description are some embodiments of the application, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.

FIG. 1 is a schematic flow chart of a CAD drawing generation method provided by the application;

fig. 2 is a schematic structural diagram of a CAD drawing generating device provided by the application;

Fig. 3 is a schematic structural diagram of an electronic device provided by the present application.

Detailed Description

For the purpose of making the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

It should be noted that in the description of embodiments of the present application, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element. The orientation or positional relationship indicated by the terms "upper", "lower", etc. are based on the orientation or positional relationship shown in the drawings, are merely for convenience of description and to simplify the description, and are not indicative or implying that the apparatus or elements in question must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be construed as limiting the present application. Unless specifically stated or limited otherwise, the terms "mounted," "connected," and "coupled" are to be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; can be directly connected or indirectly connected through an intermediate medium, and can be communication between two elements. The specific meaning of the above terms in the present application can be understood by those of ordinary skill in the art according to the specific circumstances.

The terms "first," "second," and the like in this specification are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged, as appropriate, such that embodiments of the present application may be implemented in sequences other than those illustrated or described herein, and that the objects identified by "first," "second," etc. are generally of a type, and are not limited to the number of objects, such as the first object may be one or more. In addition, "and/or" indicates at least one of the connected objects, and the character "/", generally indicates that the associated object is an "or" relationship.

The method, apparatus, electronic device and storage medium for generating CAD drawings of the present application are described below with reference to fig. 1 to 3.

Specifically, the application provides a method for generating a CAD drawing, and referring to FIG. 1, FIG. 1 is a schematic flow chart of the method for generating a CAD drawing.

The method for generating the CAD drawing provided by the embodiment of the application comprises the following steps:

step 100, based on the engineering identification of the pipeline engineering, obtaining pipeline resources of the pipeline engineering from a database.

According to the embodiment of the application, the pipeline dummy resource engineering information is exported and displayed through CAD through the ArcGIS geographic database, so that the problem that the pipeline information is difficult to collect and manage in actual engineering is solved. In pipeline engineering, the pipeline dummy resource engineering information refers to a mode of coding and managing some non-entity resource information, which cannot be directly observed and collected on site, but is recorded and managed by coding and identification.

The project identifier refers to a code or number for uniquely identifying a specific pipeline project, and when managing pipeline project information in a database, each project needs to have a unique identifier, so that different project projects can be accurately distinguished, and all information related to the specific project can be conveniently retrieved, managed and operated.

The pipeline resources comprise resources such as optical equipment, bearing facilities, bearing sections, optical cable sections, legends, material information, engineering information, electric poles, man-hand wells, benchmarks, supporting points, optical cross connecting boxes, stations, optical fiber distribution boxes and the like.

And acquiring pipeline resources of the pipeline engineering from a database based on the engineering identification of the pipeline engineering, wherein the database refers to an ArcGIS geographic database. The ArcGIS geographic database is a data storage format in the ArcGIS platform and is used for storing and managing geographic space data, provides an efficient data storage and query mode, and supports various space data types (such as points, lines, planes and the like) and association of attribute data. The arcGIS platform is a whole set of geographic information system software and tool set.

For example, all bearing sections and bearing facilities under the engineering identification are searched in a database, including longitude and latitude information of a point line resource, a pipeline section length, a rod section length, an up-lead section length, a wall-hanging section length, a direct-buried section length and the like.

And inquiring all the information (whether laid or not) of the optical cable section under the engineering identifier in a database, wherein the information comprises longitude and latitude information, the length of the optical cable section, the coiling length and the like of the optical cable section.

And inquiring all material information under the engineering identifier in a database, wherein the material information comprises material names, corresponding quantity and the like.

And inquiring all engineering information under the engineering identification in a database, wherein the engineering information comprises information such as engineering name, date, designer, auditor, engineering type, engineering attribute, engineering address and the like.

And 200, determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable section information in the pipeline resource.

After acquiring pipeline resources from the ArcGIS geographic database, determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable section information in the pipeline resources. For example, the outline dimensions of the initial CAD drawing are determined based on the positional information of the carrier segments and carrier facilities, and the positional information of the cable segments.

And 300, drawing point resources and line resources in the pipeline resources in the initial CAD drawing, and inserting resource attribute data into the initial CAD drawing in a form of a table so as to generate a CAD drawing of the pipeline engineering.

A point resource refers to an object or facility that may be represented in a geographic space by a particular coordinate location. These resources appear as a single point on the map, representing a specific geographic location. In pipeline engineering, point resources mainly include: a. device location: such as transformers, distribution boxes, pumping stations, etc. b. Manhole and hand hole: underground facilities for pipeline service, access or diversion. c. And (3) a joint and a terminal: connection points and end points of optical cables or electric cables. d. Support and fixed point: the pipeline fixes the supporting point. The data record of the point resource comprises information such as longitude and latitude coordinates, altitude values and the like of the point, and description information related to the information such as equipment type, installation date, maintenance record and the like.

Line resources refer to straight or curved segments formed by sequentially connecting a plurality of points in a geographic space, and are used for representing linear objects in the real world. In pipeline engineering, line resources mainly include: a. and (3) a pipeline: pipelines for transporting water, oil, gas or other substances. b. Optical cable, cable: a cable for transmitting power or data. c. Ditch, tunnel: although they are structures with a certain spatial morphology, in many GIS (Geographic Information System ) applications, their centreline or contour may be abstracted to be represented as a line resource. d. Route: such as transmission lines, communication lines. The data record of the line resource comprises a series of coordinate points forming the line and related attribute information such as line type, length, material quality, laying date and the like. The line resources are represented on the map as line segments connecting two or more points for representing various types of pipelines or paths.

The resource attribute data includes, but is not limited to: a. material information: the material information refers to a list of various materials used in engineering construction or assembly processes, and may include information such as material names, specifications, numbers, units, and the like. b. Engineering information: including information such as project name, date, designer, auditor, project type, project attributes, project address, etc. c. Size table: a table for recording size information of different members or elements. d. Attribute table: and a table for recording element attribute information.

After the point resources and the line resources in the pipeline resources are determined, drawing the point resources and the line resources within the outline dimension range of the initial CAD drawing, and inserting the resource attribute data into the initial CAD drawing in a form of a table so as to generate the CAD drawing of the pipeline engineering.

According to the CAD drawing generation method provided by the embodiment of the application, pipeline resources of pipeline engineering are obtained from a database through engineering identifiers based on the pipeline engineering; determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable section information in the pipeline resource; drawing point resources and line resources in pipeline resources in an initial CAD drawing, and inserting resource attribute data into the initial CAD drawing in a form of a table to generate a CAD drawing of pipeline engineering; the dot resources, line resources, and resource attribute data are within the outline size range. According to the application, pipeline resources are obtained from the ArcGIS geographic database, so that the time and labor cost for collecting resource data are reduced, and meanwhile, the CAD drawing is automatically generated, so that the CAD drawing generation efficiency and accuracy are improved.

Based on the above embodiment, the drawing the point resource and the line resource in the pipeline resource in the initial CAD drawing includes:

Step 311, creating element classes of the initial CAD drawing; the element class comprises a first element class of point resources and a second element class of line resources;

Step 312, inserting a first field into the first element class, and setting attribute information of the first field; the first field is used for identifying the type of the point resource;

step 313, matching a resource legend from a preset seed file based on the type of the point resource, and inserting the legend name of the resource legend as an attribute of a second field into the first element class; the second field is used for identifying a legend corresponding to the point resource;

and step 314, drawing the longitude and latitude information of the optical cable section and the longitude and latitude information of the bearing section in the pipeline resource into the second element class.

And creating element classes of the initial CAD drawing. Wherein the element class is one of basic data structures in the GIS, and is a set composed of a plurality of elements with specific location and attribute information. In pipeline engineering, each element represents a space object, such as an electric pole, a manhole, a monument, a support point, a bearing section, an optical cable section, an optical distribution box, a station, an optical fiber distribution box and the like. The element class may contain elements of different types, such as points, lines, planes, etc., and each element may have its own geometry and attribute information.

For example, the arcpy. Createeeaturebalance management interface is used to create a first element class of a point resource, which is used to store information about the spatial location (such as longitude and latitude) of the point resource, where the type parameter of the first element class is set to "point". Meanwhile, the arcpy. Createfeaturebalance management interface is used to create a second element class of line resources for storing spatial location information of the line resources (such as the optical cable section and the carrier section), wherein the type parameter of the first element class is set to "line".

After the element class is created, for the point resource, since the point needs to be converted into the required legend, the attribute of the first field (e.g., the "Entity" field) needs to be "INSERT" into the first element class through the arcpy. Meanwhile, according to the type of the point resource, matching a corresponding resource legend in the seed file, and inserting the legend name into the first element class as an attribute of a second field (such as a 'RefName' field). And drawing the longitude and latitude information of the optical cable section and the longitude and latitude information of the bearing section in the pipeline resource into a second element class through an arcpy.

The seed file is a CAD file containing all predefined legends and layer settings and is used for generating specific engineering drawings later. Wherein the seed file is generated based on the following steps:

(1) Determining the required legend: first, all resource types, such as optical equipment, load bearing facilities, etc., that need to be represented in CAD drawings are listed according to pipeline resources. Wherein each resource type corresponds to a legend.

(2) Design legend: CAD software (e.g., autoCAD) is used to design the legend for each resource type.

(3) Creating a CAD file: a file is newly created in the CAD software and is used as a seed file.

(4) Drawing a legend: drawing all legends designed in step (2) in the seed file. Each legend should be placed in a designated layer for ease of management and identification.

(5) Setting a layer and attributes: in order to better organize drawing content, different layers are set for different types of resources, and the properties of colors, line types and the like of the layers are defined.

(6) Saving the seed file: after the drawing and setting of all legends are completed, the CAD file is saved as a seed file. The seed file will be used as a template in subsequent work to ensure that all generated CAD drawings follow the same standards and formats.

By taking the seed file as a template of the CAD drawing, consistency of all drawings in the aspects of legend, layer naming, line type, color and the like is ensured, and the generation efficiency of the CAD drawing is improved.

In one embodiment, because the cable segments and the carrier segments typically share a physical path, they overlap during presentation, which presents difficulties in presenting CAD drawings. In order to solve the problem, in the process of displaying the optical cable section and the bearing section, the optical cable section generates a certain offset and changes color to distinguish the optical cable section and the bearing section, namely, the optical cable section and the bearing section, by a set distance, so as to avoid the situation of overlapping. The offset refers to moving the starting point and the end point of the optical cable section to the left or right by a certain distance, so that the optical cable section and the bearing section are not completely overlapped any more, thereby facilitating observation and identification. Alternatively, the offset may be adjusted as desired, not to exceed the widths of the cable segments and carrier segments.

The optical cable section and the bearing section are marked with different colors, wherein the color change can be realized by setting different line types and line colors in the CAD drawing. For example, the line type of the cable section may be set as a broken line or a dotted line, and the line color may be set as red or other vivid color to be distinguished from the solid line and black color of the carrier section.

For example, assume that carrier a needs to design a CAD drawing to show the communication network facilities and cable routing of the company. The network facilities of the company comprise a plurality of mobile phone signal towers, an indoor signal distribution system and a trunk line network formed by optical cables, and the facilities are scattered at all corners of a city, and the communication relationship between the facilities is realized by paving the optical cables. When designing CAD drawings, the company needs to show the specific path of each cable and the carrier segments connected to it. It is assumed that the company chooses to have the cable segments offset by a certain amount and change color to distinguish between cable segments and carrier segments. During the display process, the start point and the end point of the optical cable section can move leftwards or rightwards by a certain distance, so that the optical cable section and the bearing section are not completely overlapped. Meanwhile, the line type of the optical cable section is a broken line, the line color is red, the line type of the bearing section is a solid line, and the line color is black. Therefore, in the CAD drawing, the path of the optical cable and the bearing section connected with the optical cable can be clearly seen, and network planning and management work of the company are facilitated.

In one embodiment, the length value of the fiber optic cable segment is inserted at a midpoint location of the fiber optic cable segment and the length value of the carrier segment is inserted at a midpoint location of the carrier segment. For example, the midpoint of each bearing segment and the midpoint position of the optical cable segment are saved, the queried calculated length is inserted into the midpoint position, so that the position information and the length of each bearing segment and the optical cable segment are recorded, and the length information is added into the corresponding node in the CAD drawing, so that the user can conveniently check and calculate. The specific implementation steps are as follows:

(1) For each load-bearing section and optical cable section, the coordinates of the start point and the end point of the load-bearing section and the optical cable section are determined first, and the coordinates of the middle point are calculated. For example, such information may be obtained by means of measurements, surveys, and the like.

(2) The midpoint location of each carrier segment and cable segment is saved to a data table or text file for subsequent processing.

(3) In the CAD drawing, an attribute field is added for the midpoint position of each bearing section and optical cable section and is used for storing the length information of the section. For example, the length may be selected to be manually entered in the attribute table, or automatically calculated by a program.

(4) And associating the stored length information with the corresponding node in the drawing, for example, the stored length information can be realized through a data connection function provided by CAD software, or automatic processing can be realized through programming.

By storing the midpoint position of each bearing segment and optical cable segment and inserting the queried calculation length into the midpoint position, the efficiency and accuracy of network management can be improved, and valuable reference information can be provided for subsequent network planning and decision.

According to the embodiment of the application, the CAD drawing is automatically generated, so that the CAD drawing generation efficiency and accuracy are improved.

Based on the above embodiment, the inserting the resource attribute data into the initial CAD drawing in a tabular form includes:

step 321, inserting at least one third field in the first element class; the third field is used for identifying attribute information of the resource attribute data;

Step 322, inserting the table data of the resource attribute data into the third field corresponding to the first element class line by line;

Step 323, inserting the form data of the resource attribute data into the third field corresponding to the first element class in batch.

And determining a third field structure of the first element class according to the attributes of the material information and the engineering information, wherein the third field is used for identifying attribute information of the resource attribute data. Each third field corresponds to an attribute, such as a material name, quantity, specification, etc. The field type, such as text, number, date, etc., may be selected according to actual needs. In the GIS software, a table or electronic table file (such as Excel) is created and used for storing material information and engineering information, so that the columns of the table correspond to the fields of the first element class. The materials information and engineering information are then filled into the form and saved in a suitable format (e.g., CSV, XLSX, etc.). Then, using a data importing tool provided by GIS software, importing the data in the table into the corresponding third field in the first element class line by line; or import the data in the table in batches into the corresponding third fields in the first element class. Based on the identification field (e.g., ID) in the first element class, an association is established with the corresponding field in the table. Therefore, when the elements are inquired and analyzed in GIS software, the inquiry and the display of the material information and the engineering information can be realized through the associated fields.

According to the embodiment of the application, the material information and the engineering information are inserted into the element class in a form, so that the integration and consistency of data can be realized, the space analysis and decision support are provided, and the efficiency and accuracy of project management are improved.

Based on the above embodiment, the determining the outline dimension of the initial CAD drawing based on the carrying information and the optical cable segment information in the pipeline resource includes:

Step 211, acquiring longitude and latitude information of each bearing section and longitude and latitude information of each bearing facility based on the bearing information;

step 212, acquiring longitude and latitude information of each optical cable section based on the optical cable section information;

Step 213, determining a longitude maximum value, a longitude minimum value, a latitude maximum value and a latitude minimum value based on the longitude and latitude information of each bearing section, the longitude and latitude information of each bearing facility and the longitude and latitude information of each optical cable section;

Step 214, determining the outline dimension of the initial CAD drawing based on the longitude maximum, the longitude minimum, the latitude maximum, the latitude minimum, the longitude difference between the longitude maximum and the longitude minimum, and the latitude difference between the latitude maximum and the latitude minimum.

It should be noted that, the longitude and latitude information of the carrier (such as longitude and latitude information of the carrier section and longitude and latitude information of the carrier facility) is a starting point and an ending point of the designated area, and the longitude and latitude information of the optical cable section provides an actual path for connecting the carrier. Based on this, when determining the outline of the CAD drawing, the boundary range may be determined using longitude and latitude information bearing the longitude and latitude information and the cable segment. Wherein, draw the frame of CAD drawing has following several purposes:

Defining a geographic region: the outline border of the CAD drawing can identify the boundary range of a specific geographic area, helping the user to better understand where the data or engineering project is located.

Determining a display range: the outline border of the CAD drawing may be used to determine the display range of the CAD drawing so that both the data and elements in the drawing are in the visible range.

Providing a reference basis: the outer frame of the CAD drawing can be used as a reference basis for comparison or superposition analysis with other geographic data.

Specifically, based on the bearing information, acquiring longitude and latitude information of each bearing section and longitude and latitude information of each bearing facility; acquiring longitude and latitude information of each optical cable section based on the optical cable section information; determining a longitude maximum value, a longitude minimum value, a latitude maximum value and a latitude minimum value based on the longitude and latitude information of each bearing section, the longitude and latitude information of each bearing facility and the longitude and latitude information of each optical cable section; determining a first quotient of the longitude difference and the target value and a second quotient of the latitude difference and the target value; determining a first coordinate point based on the sum of the longitude maximum and the first quotient and the sum of the latitude maximum and the second quotient; determining a second coordinate point based on the difference between the latitude minimum value and the second quotient value and the sum of the longitude maximum value and the first quotient value; determining a third coordinate point based on the difference between the minimum longitude value and the first quotient value and the difference between the minimum latitude value and the second quotient value; determining a fourth coordinate point based on the difference between the minimum longitude value and the first quotient value and the sum of the maximum latitude value and the second quotient value; and determining the outline dimension of the initial CAD drawing based on the first coordinate point, the second coordinate point, the third coordinate point and the fourth coordinate point.

For example, assume that the maximum longitude value is max_ lati, the minimum longitude value is min_ lati, the maximum latitude value is max_ longi, the minimum latitude value is min_ longt, the difference longitude is diff_ lati =max_ lati-min_ lati, the difference latitude is diff_ longi =max_ longi-min_ longti, the first quotient is diff_ lati/2, and the second quotient is diff_ longi/2.

The coordinates of four points can be calculated based on the longitude and latitude values:

upper right corner (i.e., first coordinate point):

(max_lati+diff_lati/2，max_longi+diff_longi/2)；

upper left corner (i.e., second coordinate point):

(max_lati+diff_lati/2，min_longti-diff_lati/2)；

lower left corner (i.e., third coordinate point):

(min_lati-diff_lati/2，min_longti-diff_lati/2)；

lower right corner (i.e., fourth coordinate point):

(min_lati-diff_lati/2，max_longi+diff_longi/2)；

The rectangular area surrounded by the four points is the outer frame of the CAD drawing, wherein the size of the outer frame is required to be set to be larger than the coordinates of the bearing information and the optical cable section so as to be capable of drawing the legend, the material information, the engineering information and the like in the outer frame together.

Further, the arcpy. Createeeaturebalance management interface is used to draw the outline into the element class, and the type parameter selection "polyline" indicates that the element class stores line segment data. For example, geometric information of the outline is inserted into the element class line by line using arcpy.

According to the embodiment of the application, the outline border of the CAD drawing is determined by bearing the longitude and latitude information and the longitude and latitude information of the optical cable section, so that the accuracy and consistency of the CAD drawing can be ensured, necessary geographic space references are provided, and a user is helped to better understand and analyze related geographic data and engineering projects.

In order to further analyze and explain the method for generating the CAD drawing provided by the application, reference is made to the following embodiments.

The embodiment of the application particularly provides a rapid representation method for pipeline engineering CAD by using ArcGIS to solve the problems of high difficulty, high cost and low efficiency of CAD drawing of the current pipeline engineering information. The method specifically comprises the following steps:

step one: and searching all bearing sections and bearing facilities under the engineering identification in a database, including longitude and latitude information of a point line resource, the length of a pipeline section, the length of a road section, the length of an upper section, the length of a wall hanging section, the length of a direct buried section and the like, and storing the query result. If no information is carried, the step is automatically skipped.

Step two: and inquiring all the information of the optical cable section under the engineering identifier in a database, including longitude and latitude information, length of the optical cable section, coiling length and the like, and storing an inquiry result. If no cable information exists, the step is automatically skipped.

Step three: and inquiring all material information under the engineering identifier in a database, including material names, corresponding quantity and the like, and storing an inquiry result.

Step four: and inquiring all engineering information under the engineering identifier in a database, including information such as engineering name, date, designer, auditor, engineering type, engineering attribute, engineering address and the like, and storing the inquiring result.

Step five: preparing a seed file of the CAD drawing, and drawing the seed file by using resource legends required to be displayed by all optical equipment, bearing facilities and the like.

Step six: and extracting the maximum value and the minimum value of the longitude and latitude information of the bearing section (such as the longitude and latitude information of the bearing facilities) and the longitude and latitude information of the optical cable section. The maximum value of the longitude is max_ lati, and the minimum value is min_ lati; the maximum value of the latitude is max_ longi, and the minimum value is min_ longti; the difference between the maximum and minimum values of longitude is diff_ lati, and the difference between the maximum and minimum values of latitude is diff_ longi. Then, a rectangular area surrounded by the following four points is taken as an outer frame of the CAD drawing:

(max_lati+diff_lati/2，max_longi+diff_longi/2)；

(max_lati+diff_lati/2，min_longti-diff_lati/2)；

(min_lati-diff_lati/2，min_longti-diff_lati/2)；

(min_lati-diff_lati/2，max_longi+diff_longi/2)；

The housing is configured to be larger than the coordinates of the load bearing information and the cable sections because legends, material information, engineering information, etc. need to be drawn together within the housing. Finally, the outline is drawn into the element class through the arcpy. CreateFeaturescope_management interface, and the type parameter selects "polyline".

Step seven: creating element classes of point resources and element classes of line resources, wherein for the point resources, a type parameter uses a point; for line resources, the type parameter uses "line". And drawing the longitude and latitude information of the optical cable section and the longitude and latitude information of the bearing section into element classes of the line resource through an arcpy. For point resources, since the point needs to be converted into a required resource legend, an "Entity" field, which has an attribute of "INSERT", needs to be inserted into the element class of the point resource through the arcpy. Meanwhile, according to the type of the point resource, matching a corresponding resource legend in the seed file, and inserting the resource legend name as the attribute of the RefName field into the element class of the point resource. Since the cable segments are typically laid on the carrier segments, the physical paths of the two are typically identical, overlap occurs in CAD, and therefore the cable segments and carrier segments are offset during display and change color to distinguish between the cable segments and carrier segments.

Step eight: the material information is inserted into the element class in a table form, the engineering information is inserted into the element class in a table form, and the legend style is inserted into the element class.

Step nine: and storing the midpoint of each bearing section and the midpoint position of the optical cable section, and inserting the calculated lengths of the queried bearing sections and optical cable sections into the midpoint position. And copying all the queried equipment points and facility points, and inserting the real names corresponding to the resource legends into the corresponding positions.

Step ten: the above element classes are converted into CAD drawings through an arcpy.ExportCAD_conversion interface, wherein seed file parameters are set into a pre-designed seed file. And finally, obtaining CAD drawing display of all resource information under the required engineering mark.

The CAD rapid representation method for pipeline engineering by using ArcGIS provided by the embodiment of the application can rapidly convert the dummy resource information of the pipeline into CAD drawing format, and can accurately perform resource positioning. Meanwhile, the bearing section and the optical cable section of the same physical path are distinguished, so that the identification is convenient; the calculated length and the reserved length of all the bearing sections and the optical cable sections in the engineering are displayed in a CAD graph, and the method is used for convenience and high efficiency in the construction or maintenance process. The subsequent engineering plan is designed according to the length, the bearing length, the material information and the engineering information of the optical cable, so that preparation before construction is greatly simplified, on-site construction staff can check resources conveniently, and errors caused by drawing of manual drawings can be avoided.

On the other hand, the time from data collection to drawing production is greatly shortened in the automatic data processing and drawing generation process, manual operation is reduced through automation, and errors caused by human factors are avoided. The clear and standardized CAD drawing is convenient for on-site constructors to rapidly check resources, and the construction efficiency and quality are improved.

Fig. 2 is a schematic structural diagram of a CAD drawing generating device provided by the present application, and referring to fig. 2, an embodiment of the present application provides a CAD drawing generating device, which includes a pipeline resource obtaining module 201, an outline dimension determining module 202, and a CAD drawing generating module 203.

A pipeline resource obtaining module 201, configured to obtain pipeline resources of a pipeline project from a database based on a project identifier of the pipeline project;

the outline dimension determining module 202 is configured to determine an outline dimension of the initial CAD drawing based on the carrying information and the optical cable segment information in the pipeline resource;

The CAD drawing generation module 203 is configured to draw a point resource and a line resource in the pipeline resource in the initial CAD drawing, and insert resource attribute data into the initial CAD drawing in a form of a table, so as to generate a CAD drawing of the pipeline engineering; the point resource, the line resource, and the resource attribute data are within the outline size range.

According to the CAD drawing generating device provided by the embodiment of the application, pipeline resources of pipeline engineering are obtained from a database through engineering identifiers based on the pipeline engineering; determining the outline dimension of the initial CAD drawing based on the bearing information and the optical cable section information in the pipeline resource; drawing point resources and line resources in pipeline resources in an initial CAD drawing, and inserting resource attribute data into the initial CAD drawing in a form of a table to generate a CAD drawing of pipeline engineering; the dot resources, line resources, and resource attribute data are within the outline size range. According to the application, pipeline resources are obtained from the ArcGIS geographic database, so that the time and labor cost for collecting resource data are reduced, and meanwhile, the CAD drawing is automatically generated, so that the CAD drawing generation efficiency and accuracy are improved.

In one embodiment, CAD drawing generation module 203 is further configured to:

In one embodiment, the fiber optic cable segment is identified in a different color than the carrier segment; and a distance is set between the optical cable section and the bearing section at intervals.

In one embodiment, CAD drawing generation module 203 is further configured to:

In one embodiment, the frame sizing module 202 is further configured to:

Fig. 3 illustrates a physical schematic diagram of an electronic device, as shown in fig. 3, where the electronic device may include: processor 310, communication interface (CommunicationsInterface) 320, memory 330 and communication bus 340, wherein processor 310, communication interface 320 and memory 330 communicate with each other via communication bus 340. The processor 310 may invoke logic instructions in the memory 330 to perform a method of generating CAD drawings, the method comprising:

Further, the logic instructions in the memory 330 described above may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as a stand-alone product. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a usb disk, a removable hard disk, a Read-only memory (ROM), a random access memory (RAM, randomAccessMemory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.

In another aspect, the present application also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, is implemented to perform a method for generating CAD drawings provided by the above methods, the method comprising:

The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.

From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.

Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present application, and are not limiting; although the application has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. The CAD drawing generation method is characterized by comprising the following steps of:

2. The method for generating a CAD drawing according to claim 1, wherein the drawing of the point resources and the line resources in the initial CAD drawing includes:

3. The method of generating CAD drawings of claim 2, wherein the cable segment and the carrier segment are identified in different colors; and a distance is set between the optical cable section and the bearing section at intervals.

4. The method for generating CAD drawing according to claim 2, wherein after the drawing the latitude and longitude information of the optical cable section and the latitude and longitude information of the bearing section in the pipeline resource into the second element class, further comprises:

5. The method for generating a CAD drawing according to claim 2, wherein the inserting the resource attribute data into the initial CAD drawing in a tabular form comprises:

6. The method for generating a CAD drawing according to claim 1, wherein determining the outline dimensions of the initial CAD drawing based on the load information and the cable segment information in the pipeline resource comprises:

7. The method of generating a CAD drawing of claim 6, wherein the determining the outline dimensions of the initial CAD drawing based on the longitude maximum, the longitude minimum, the latitude maximum, the latitude minimum, the longitude difference between the longitude maximum and the longitude minimum, and the latitude difference between the latitude maximum and the latitude minimum comprises:

8. The device for generating the CAD drawing is characterized by comprising the following components:

9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of generating CAD drawings according to any one of claims 1 to 7 when the program is executed by the processor.

10. A non-transitory computer-readable storage medium having stored thereon a computer program, which when executed by a processor implements the method of generating a CAD drawing according to any one of claims 1 to 7.