CN115080682B - Method for quickly converting space database to railway CAD digital topographic map full elements - Google Patents
Method for quickly converting space database to railway CAD digital topographic map full elements Download PDFInfo
- Publication number
- CN115080682B CN115080682B CN202211002930.1A CN202211002930A CN115080682B CN 115080682 B CN115080682 B CN 115080682B CN 202211002930 A CN202211002930 A CN 202211002930A CN 115080682 B CN115080682 B CN 115080682B
- Authority
- CN
- China
- Prior art keywords
- data
- topographic map
- conversion
- elements
- cad
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
Abstract
The invention relates to a method for quickly converting a spatial database to a railway CAD digital topographic map full element, which comprises the following steps of S1, making a standardized expression reference of a digital topographic map surface feature element under a CAD platform; s2, constructing a conversion relation from a geographic information space database to a CAD topographic map of the surface feature elements; s3, designing a data conversion template program based on FME; s4, checking and preprocessing data to be converted; s5, setting conversion parameters to perform first block diagram data conversion; s6, problem searching and data conversion template repairing are completed; s7, dividing a data area to execute topographic map batch conversion; s8, sampling and checking the data conversion result of the digital topographic map; s9, manufacturing a range line of the digital topographic map; s10, sorting and filing the digital topographic map conversion result. The invention realizes the rapid batch conversion from the GIS platform spatial database to the digital line drawing under the CAD platform, avoids a large amount of manual drawing operation, effectively improves the data production efficiency and effectively avoids information loss in the data conversion process.
Description
Technical Field
The invention belongs to the technical field of basic topographic map data production in railway feasibility scheme research and design, and particularly relates to a method for quickly converting a spatial database into a railway CAD digital topographic map full element.
Background
The national basic scale space geographic information database (topographic map) of 1, 5 thousands, 1 ten thousands and the like is an important basic reference for developing feasibility scheme research and design at the early stage of railway construction, and data achievements are generally stored in a space database format such as a GDB/MDB format and cannot be directly used for line scheme design. After the walking direction is determined according to railway construction requirements, space database results need to be collected in a certain range according to the trend of the rough line position, and a digital topographic map in a DWG format under a CAD platform is manufactured.
In practical application, the production of digital topographic maps under a CAD platform mainly adopts GIS software such as ArcGIS, global Mapper and the like to carry out graphical conversion at present, and then recovers topographic map pictographic expression of elements under the CAD by means of manual drawing of plug-ins such as AutoCAD software, CASS and the like, and the main technical limitation is expressed as follows: (1) Manual editing requires block reference, linear and planar element expression characteristics of main image layer replacement and element modification, and has the disadvantages of complex operation, extremely low automation degree and long imaging period; (2) The attribute information of the feature elements is stored in a vector field, and the attribute information is inevitably lost when the graphical elements are executed; (3) The third-party soft (plug-in) component has poor expansibility, cannot meet the data requirements of different data coding modes, and is inconvenient to update and iterate. And different regions are greater than 1: the invention provides a flexible conversion method for realizing fast DWG digital line drawing conversion of all elements aiming at the problems that local acquisition and coding standards are adopted in a plurality of regions of 1 ten thousand spatial databases, the data conversion difficulty is increased, and higher requirements are provided for the data conversion efficiency and the timeliness.
Disclosure of Invention
The invention provides a method for quickly converting all elements from a national basic scale space database to a railway CAD digital topographic map, which can realize full-automatic topographic map element conversion and effectively reserve key semantic information of the elements.
The invention comprises the following technical scheme: a method for quickly converting a spatial database into a railway CAD digital topographic map full element comprises the following steps:
s1, making a digital topographic map ground feature standardized expression reference under a CAD platform: s1-1, making a CAD digital topographic map point-like element symbol library reference; s1-2, making a CAD digital topographic map linear element layer definition reference, copying all block reference entities in the obtained point element symbol library of S1-1 into the file for storage, so that the file contains both layer definition information and all point element block reference entities, and combining to obtain a block reference and layer definition reference writing template; s1-3, making CAD digital topographic map planar element definition reference; s1-4, carding feature types of the ground features, making CAD digital topographic map annotation feature information definition reference, combining and storing planar feature expression information of all layers S1-3 and annotation feature expression information of all layers S1-4 to obtain a lower-surface feature and annotation expression feature information table of a basic scale, which is abbreviated as an N table;
s2, constructing a conversion relation from a geographic information space database to a CAD topographic map of the surface feature elements; s2-1, sorting all element types to be converted, listing all surface feature element types and GB codes according to data description of data to be converted, sorting all surface feature elements of all types, taking surface feature element codes in a vector attribute table as unique identification keywords, setting an obtained set as M, storing the M as a data code table to be converted in an Excel form, and shortening the M as an M table; s2-2, automatically matching the feature conversion relation, setting the feature element type combed in S1-4 as N, matching and associating the M table in S2-1 with the N table obtained in S1-4 according to the codes or Chinese names of the feature element set M and the feature element set in N, and establishing a one-to-one corresponding conversion relation in a left connection mode by taking the M table as a main table and the N table as an auxiliary table; s2-3, arranging the conversion relation of the unaligned surface feature elements, and manually setting M data and surface feature elements which cannot be successfully matched in the S2-2 into similar surface feature types in the N, so that each type of element of the data to be converted has a target image layer and element feature information, and obtaining a surface feature element mapping relation and a feature expression table of the data to be converted;
s3, designing a data conversion template program based on FME; s3-1, reading a space element and expression characteristic information table, creating two reading modules, wherein one reading module is used for reading an original GDB/MDB space database, setting an analysis data format according to a data type, and the reading mode is combined reading, and the other reading module is used for reading the mapping relation of the surface feature elements and the characteristic expression table obtained in the step S2-3; s3-2, hooking attribute information, namely performing table connection on a space element attribute table of a space feature element object and a feature element mapping relation and feature expression table obtained in the step S2-3 by using a FeatureMerger converter, taking a GB code field of a geographic information space database element and a feature element original data coding field as unique matching fields, hooking an extended attribute table of the extended attribute table through attributes, and endowing each space element with a target layer and an expression attribute under a CAD platform; s3-3, data distribution is carried out, and the space elements successfully combined in the S1-3 are subjected to data distribution according to geometric types; s3-4, processing a special layer; s3-5, creating a new expression element, creating a new annotation and filling element in the CAD expression, and converting the content in the extended attribute table into a map symbolic representation; s3-6, setting a data fan-out rule and writing out data;
s4, checking and preprocessing data to be converted, checking the format, the encryption state, the coordinate system and the database version of the original data to be converted, and ensuring normal reading and analysis of the data;
s5, setting conversion parameters to perform first block data conversion, setting an original GDB/MDB spatial database coordinate system, a target result coordinate system and a projection mode, setting a CAD result version of a target result, and selecting a first data area to perform data result conversion;
s6, problem searching and data conversion template repairing are completed, elements which are not converted successfully by each converter are searched in FME software by using a DataInspector tool through element data flow counting of a user graphical interface, and the conversion template designed in the step S3 is repaired and completed until all elements are converted;
s7, dividing a data area to execute topographic map batch conversion, formulating a data conversion strategy according to the data quantity and the data format of the data conversion area, carrying out data framing output on a spatial database of the GDB data type according to the map range, and filtering spatial elements through a spatialFilter converter to carry out block processing; merging a plurality of MDB original files for conversion output according to the adjacency relation in an MDB spatial database;
s8, sampling the digital topographic map data conversion result, and performing sampling data quality inspection on all conversion result data in the step S7, wherein the map width proportion of the sampling inspection is 10%;
s9, manufacturing a range line of the digital topographic map; s9-1, extracting the range lines of the topographic map sheets in batch, extracting range vector surface elements of each topographic map sheet from topographic map data according to layer element codes, and converting the range vector surface elements into DWG format files for outputting; s9-2, making a topographic map sheet name annotation;
s10, sorting and filing the digital topographic map conversion result.
Further, the step S1-4 is specifically to comb expression features of various planar ground object elements of basic scale according to the requirements of specifications of basic geographic information element classification and codes (GBT 13923-2006) (see fig. 10 for details), classify the ground object element types based on the specifications, and store the planar element feature expression information in the form of Excel.
Furthermore, in the step S2, according to the description of the design data of the spatial database, the expression rule of the point-line-surface elements of each type of feature on the CAD platform is combed, so that the combing of all types of feature elements is realized, and the loss of feature types is avoided.
Furthermore, in the step S3, the complete element conversion from the GDB/MDB spatial database to the CAD is realized through the FME platform, and subsequent further conversion and manual secondary editing operation by other third-party software and CAD secondary development plug-ins are not required.
Further, the step S3-3 includes data splitting of points, lines, and surfaces, the point elements are further divided into two types, i.e., notes and block references, the line elements are written according to the template file expression pattern, and the planar elements are divided into planar elements including padding and planar elements not including padding.
Further, the step S3-4 specifically includes processing 3 kinds of special layer elements including an equal altitude line, a common house, and a high-rise house.
Further, the step S3-6 is specifically to create a writing module, fan out the converted and created surface feature elements according to the target surface feature element codes, reclassify and store the data according to the target layer codes, write out the template with the block references and the layer definition references obtained in S1-2, and write out the DWG format topographic map result.
Further, in the step S6, the FME software is used to develop a visualization component programming mode, monitor and debug the data element flow direction, quickly find the reason for the unsuccessfully converted element, and repeatedly execute the operation of S6 until complete element ground class conversion is realized.
Further, in the step S7, according to the topographic map range, the regional batch automatic conversion processing is performed in a spatial analysis manner, so as to realize the batch automatic output of the ten-million-order massive element spatial database.
Further, the checking the content in step S8 includes: (1) error in graphic expression and error in style of surface feature elements; (2) the map of the topographic map elements is lost, such as the sideline of a ground object is lost, the filling of a house is lost, and the place name is marked and lost; (3) and key information is lost, such as contour elevation, elevation point note loss and the like.
Further, the step S9-2 is to obtain a topographic map number (i.e. a topographic map sheet name) of each topographic map from the topographic map data, create a text annotation form of the topographic map number, combine the topographic map sheet number with the topographic map range vector elements in S9-1, and output the combined result, where the annotation position is the geometric center of the polygon corresponding to the topographic map sheet range in S9-1.
Further, step S10 is specifically to, after steps S4 to S9 are executed until all the conversion of the topographic maps is completed, sort and archive the digital topographic map result obtained in step S7 and the topographic map breadth line result obtained in step S9, and record key information such as a result coordinate system, a projection mode, a central meridian and the like.
The invention has the advantages and positive effects that:
1. the data barrier between the GIS platform and the CAD platform is effectively reduced, the actual effect of batch full-factor conversion of massive spatial databases is achieved, firstly, the data conversion speed is greatly improved in the aspect of data conversion efficiency, the conversion result can be directly used for railway line scheme research and design work, manual editing is not needed, and the method has obvious technical advantages under the condition that the requirements of bidding projects and the like on topographic map production cycles are urgent; secondly, in the conversion process, attention target attribute information such as traffic elements and the like is effectively reserved, and the data abundance degree and the information value are improved; finally, according to the data conversion mode and the requirement change, the land feature expression information can be quickly modified, and the quick update of the topographic map is realized.
2. The invention realizes semantic space expression of various point, line and surface feature attribute information; the block and frame conversion, cutting output, automatic extraction of the topographic map frame and the file making of the map frame range of the topographic map data can realize the rapid conversion of 1 ten thousand, 1, 5 ten thousand equal-scale topographic map data for railway design to a CAD platform, and the mapping period is greatly shortened.
3. According to the method, the automatic batch conversion of the mass multi-source geographic space data is realized through the space analysis and automatic blocking processing strategies.
Drawings
FIG. 1 is a flow chart of an embodiment of the present invention.
Fig. 2 is a 1 st scale CAD dot-like element symbol library (partial).
Fig. 3 is a 1 ten thousand scale layer definition reference (partial).
Fig. 4 is a table (part) of 1 ten thousand face elements and note expression characteristics.
Fig. 5 is a 1.
Fig. 6 is a 1.
FIG. 7 is a 1 ten thousand spatial database (local) before conversion.
Fig. 8 is a 1 ten thousand CAD digit line drawing (partial) after conversion.
FIG. 9 is a 1.
FIG. 10 is section B of the Specification appendix of basic geographic information element Classification and code (GBTs 13923-2006).
Detailed Description
To further disclose the contents, features and effects of the present invention, the following examples are given as specific examples and are described in detail with reference to the accompanying drawings, and the present invention is described in detail by taking 1 ten thousand basic scale spatial databases as examples to illustrate specific embodiments.
Example (b): referring to the attached drawings 1-10, a method for quickly converting a spatial database to a railway CAD digital topographic map full element, which realizes the quick batch conversion of a national basic scale spatial database result to a railway line selection and CAD digital topographic map for design, comprises the following steps:
s1, standardized expression reference making of ground feature elements of a digital topographic map under a CAD platform;
s1-1, making a CAD digital topographic map point-like element symbol library reference; according to the requirements of basic geographic information element classification and code (GBT 13923-2006) (hereinafter referred to as ' specification ') (see the attached drawing 10 for details), a CAD point element symbol library of 1 ten thousand standard scale point feature elements is manufactured, standard block reference expression of various point elements in CAD of 1 ten thousand standard scale topographic maps is realized, information drawing components such as proportion, color and filling of the point elements are determined according to symbol definition, the components are combined into one piece of reference information and named with unique names, and the point feature symbols of all the layers are manufactured, namely the point feature symbols are named as ' 1. Fig. 2 shows a library of point CAD point-like element symbols after the completion of the production.
S1-2, making a CAD digital topographic map linear element layer definition reference; according to the requirements of 'standard', making 1 ten thousand standard scale linear ground object element expressed layer definition reference, including line type, line width and color characteristic attributes of various linear elements, dividing basic geographic information element classification codes (see appendix B, six digits) by 'standard' as the names of the layers, and defining three characteristic attributes of each layer by category. Therefore, a DWG file containing all map element layer definition references is created and named as' 1. The step can generate a standard layer positioning file in a computer programming mode, namely, the layer template information is combed into an Excel file, a linear element layer definition file is rapidly generated by a python script through a pyautocad frame, and meanwhile, the default display and hidden and freezing attributes of the layer are set.
After the layer definition reference of S1-2 is made, all block reference entities in the obtained' 1.
S1-3, making CAD digital topographic map planar element definition reference; combing the expression characteristics of various planar surface feature elements under 1 ten thousand standard scales according to the requirements of ' standard ', wherein the expression characteristics comprise an image layer filling pattern, a filling color, a filling proportion and filling angle information, dividing basic geographic information element classification codes by ' standard ' as an identifier, storing planar feature characteristic expression information in an Excel form, and naming the planar feature expression information as ' 1 ten thousand surface feature expression characteristics.
S1-4, carding feature element types, and making CAD digital topographic map annotation element information definition reference; combing the expression information of various annotation elements under 1 ten thousand standard scales according to the requirements of ' standard ', wherein the expression information comprises information such as annotation character fonts, word sizes, colors, inclinations and the like, dividing basic geographic information element classification codes according to ' standard ', storing annotation element characteristic expression information by Excel, and naming the annotation element characteristic expression information as ' 1; and (3) combining and storing the planar element characteristic expression information of all the layers S1-3 and the note element characteristic expression information of all the layers S1-4 to obtain a 1 ten thousand standard scale planar element and note expression characteristic information table, which is abbreviated as an N table and is named as' 1 ten thousand planar element and note expression characteristic table.
S2, constructing a conversion relation from a geographic information space database to a CAD topographic map of the surface feature elements; according to data description and 'standard' corresponding to data to be converted, combing and constructing a conversion relation from a spatial database to a DWG digital topographic map;
s2-1, sorting all element types to be converted; the original spatial database is provided with data descriptions no matter the original spatial database adopts a local standard or a national standard, and is generally stored and copied along with the spatial database in a document form, the descriptions define the data organization and coding mode of the ground feature elements of the current spatial database, namely, the names, the stored layers and the codes of the ground feature elements of each type are clear, all the ground feature element types and the GB codes are listed according to the data descriptions of the data to be converted, all the ground feature elements of each type are sorted, ground feature element codes (GB fields (national standard type codes) of the elements of the spatial database) in a vector attribute table are used as unique identification keywords, an obtained set is set as M, the M is stored in an Excel form and used as a data coding table to be converted, the M is abbreviated as an M table, and the M table is named as a '1 ten thousand data coding table.xlsx'.
S2-2, automatically matching the ground feature conversion relation; the method comprises the steps of setting the type of the surface feature element combed by the ' Specification ' in S1-4 as N, matching an incidence relation between a ' 1 ten thousand to-be-converted data coding table, an xlsx ' (M table) in S2-1 and a ' 1.
S2-3, arranging the conversion relation of the unmatched ground feature elements; and manually setting M data and surface feature elements which are not successfully matched in the S2-2 into similar surface feature types in the N, so that each type of element of the data to be converted has a target layer and element feature information, and obtaining a surface feature element mapping relation and a feature expression table of the data to be converted.
The mapping relation from the converted data set obtained in the step 2 to the data set agreed in the ' specification ' is stored in an excel format, the main fields are ' code, conversion code, element feature 1, element feature 2, \8230; ' and are named as ' 1.
S3, designing a data conversion template program based on FME;
s3-1, reading a space element and expression characteristic information table; creating two reading modules, wherein one reading module is used for reading an original geographic information space database (GDB/MDB) with conversion, the analysis data format is set according to the data type, the reading mode is combined reading, and the other reading module is used for reading the 1.
S3-2, hanging attribute information; the step is a key link of topographic map element conversion, a FeatureMerger converter is used for performing table connection on spatial surface feature element objects and a' 1 st ten thousand map surface feature element mapping relation and a feature expression table obtained in the step S2-3, a geographic information spatial database element GB code field and a surface feature element original data coding field are used as unique matching fields, an extended attribute table is hung through attributes, and a target layer and an expression attribute of each spatial element under a CAD platform are given.
S3-3, data distribution; and (4) carrying out data splitting on the successfully combined space elements in the S1-3 according to geometric types, namely carrying out data splitting on points, lines and surfaces, further dividing the point elements into notes and blocks, writing the linear elements according to the expression pattern of the template file, and dividing the planar elements into planar elements containing filling and planar elements not containing filling.
S3-4, processing a special layer; processing 3 types of special layer elements including contour lines, common houses and high-rise houses, wherein the contour line layer needs to be provided with an elevation attribute, an automatic _ elevation attribute is created and set as an elevation value in an attribute field table, the house layer needs to calculate a self-adaptive filling angle according to a house angle, an azimuth angle of a long axis of each house is calculated by using a pythoncaller converter, and the filling angle is 45 degrees in a clockwise direction.
S3-5, creating a new expression element; creating new annotation and filling elements in the CAD expression, and converting the content in the extended attribute table into map symbols to represent: (1) A note element, which creates a new note object (autocad _ text entity) on the basis of the point, and sets a note attribute for the note field according to the note characteristic information; (2) Creating a filling element aiming at the land element required to be filled in the S2, creating a filling element branch in the planar element data stream, creating a filling element (automatic _ hash entity) with consistent geometric information, and setting a filling information attribute according to the filling characteristic information.
S3-6, setting a data fan-out rule, and writing out data; creating a writing module, performing data fan-out on the converted and created surface feature elements according to target surface feature element codes, and enabling the converted and created surface feature elements to reclassify and store data according to target layer codes, wherein a template is written out according to 1 ten thousand block references and layer definition references obtained in S1-2, DWG is a block reference and layer definition reference writing template file, a dump DWG format topographic map result is written out, and a conversion program design template is shown in FIG. 6.
S4, checking and preprocessing data to be converted;
checking the format, the encryption state, the coordinate system and the database version of original data to be converted, ensuring normal reading and analysis of the data, and performing database version upgrading operation and conversion on the data of which the database version is smaller than ArcGISI 9.3; the encrypted spatial database should be processed in a decrypted state.
S5, setting conversion parameters to perform first block data conversion;
setting a coordinate system of an original GDB/MDB spatial database, a coordinate system of a target result and a projection mode, setting a CAD result version of the target result, and selecting a first data area to carry out data result conversion.
S6, problem searching and data conversion template repairing are completed;
through element data flow counting of a user graphical interface, elements which are not converted successfully by each converter are searched in FME software by using a DataInspector tool, whether missing corresponding relation errors and incompleteness exist or not is further searched in a data element relation constructed in S2, a conversion template designed in the step S3 is repaired and perfected until all element conversion is completed, original data results and converted topographic map results are shown in figures 7 and 8, wherein figure 7 shows the loading effect of an original space database in ArcGIS, and figure 8 shows the loading effect of a converted DWG file in AutoCAD.
S7, dividing a data area to execute topographic map batch conversion;
formulating a data conversion strategy according to the data quantity and the data format of the data conversion area, carrying out data framing output on a spatial database of the GDB data type according to the map range, and filtering spatial elements through a spatialFilter converter to carry out block processing; and combining a plurality of MDB original files for the MDB spatial database according to the adjacency relation, and converting and outputting the combined MDB original files. In order to ensure the fluency of CAD data browsing and operation, the data volume is preferably less than 200 MB. According to the complexity average degree of data in the map, 5 ten thousand topography maps are generally 6-8, 10-15, and the topography maps spanning the projection bands are separately converted according to different central meridians among standard projection bands.
S8, sampling and checking the digital topographic map data conversion result;
and (4) performing sampling data quality inspection on all conversion result data in the step (S7), wherein the proportion of the image frame of the sampling inspection is 10 percent, and the inspection contents are as follows: (1) the pattern expression error and the ground feature element pattern error; (2) the map of the topographic map elements is lost, such as the sideline of a ground object is lost, the filling of a house is lost, and the place name is marked and lost; (3) and key information is lost, such as contour elevation, elevation point note loss and the like.
S9, manufacturing a range line of the digital topographic map;
s9-1, extracting the range lines of the topographic map sheets in batch, extracting the range vector surface elements of each topographic map sheet from the topographic map data according to the layer element codes (GB field, 1 ten thousand as an example, code is 120200), and converting the range vector surface elements into files in DWG format to output.
S9-2, marking the map sheet name of the topographic map, namely, obtaining the topographic map number (namely the topographic map sheet name) of each topographic map from topographic map data, wherein the topographic map number of the spatial database stored in GDB format is stored in the attribute field of a map sheet range frame vector, the topographic map number of the spatial database stored in MDB format is directly obtained from a file name, after all the topographic map numbers are extracted, the character marking form is created and combined with the topographic map range vector element of S9-1 for output, and the marking position is the geometric center of the polygon corresponding to the map sheet range in S9-1. The produced map width is shown in fig. 9, and the produced map width result space coordinate information matches the topographic map conversion result obtained in S7.
S10, sorting and archiving digital topographic map conversion results;
and after the conversion from the step S4 to the step S9 to all the topographic maps is finished, the digital topographic map result obtained in the step S7 and the topographic map breadth line result obtained in the step S9 are sorted and filed, and key information such as a result coordinate system, a projection mode, a central meridian and the like is recorded.
In the embodiment of the invention, 1 ten thousand of scale space data are taken as an example, other common scale space databases are converted similarly to the scale data, and for space databases of other unusual data types such as SHP/ARCGIS LAYER, the common scale space databases can be converted into GDB/MDB formats and then are converted.
While the preferred embodiments of the present invention have been illustrated and described, it will be appreciated by those skilled in the art that the foregoing embodiments are illustrative and not limiting, and that many changes may be made in the form and details of the embodiments of the invention without departing from the spirit and scope of the invention as defined in the appended claims. All falling within the scope of the invention.
Claims (10)
1. A method for quickly converting a spatial database to a railway CAD digital topographic map full element is characterized by comprising the following steps:
s1, making a digital topographic map ground feature standardized expression reference under a CAD platform: s1-1, making a CAD digital topographic map point-like element symbol library reference; s1-2, a CAD digital topographic map linear element layer definition reference is made, all block reference entities in the obtained point element symbol library of the S1-1 are copied into the CAD digital topographic map linear element layer definition reference to be stored, so that the CAD digital topographic map linear element layer definition reference not only contains layer definition information, but also contains all point element block reference entities, and a block reference and layer definition reference writing template is obtained by combination; s1-3, making CAD digital topographic map planar element definition reference; s1-4, combing feature types of ground objects, making a CAD digital topographic map annotation feature information definition reference, combining and storing planar feature expression information of all layers and annotation feature expression information of all layers to obtain a lower-scale feature and annotation expression feature information table of a basic scale, which is abbreviated as an N table;
s2, constructing a conversion relation from a geographic information space database to a CAD topographic map of the surface feature elements; s2-1, sorting all element types to be converted, listing all surface feature element types and GB codes according to data description of data to be converted, sorting all surface feature elements of all types, taking surface feature element codes in a vector attribute table as unique identification keywords, setting an obtained set as M, storing the M as a data code table to be converted in an Excel form, and shortening the M as an M table; s2-2, automatically matching the feature conversion relationship, setting the feature element type combed in S1-4 as N, matching and associating the M table in S2-1 with the N table obtained in S1-4 according to the codes or Chinese names of the feature element sets M and N, and establishing a one-to-one corresponding conversion relationship in a left connection mode by taking the M table as a main table and the N table as an auxiliary table; s2-3, arranging the conversion relation of the unaligned surface feature elements, and manually setting M data and surface feature elements which cannot be successfully matched in the S2-2 into similar surface feature types in the N, so that each type of element of the data to be converted has a target image layer and element feature information, and obtaining a surface feature element mapping relation and a feature expression table of the data to be converted;
s3, designing a data conversion template program based on FME; s3-1, reading space elements and an expression characteristic information table, creating two reading modules, wherein one reading module is used for reading an original GDB/MDB space database, setting an analysis data format according to a data type, the reading mode is combined reading, and the other reading module is used for reading the mapping relation of the surface feature elements and the characteristic expression table obtained in the step S2-3; s3-2, hanging attribute information, namely, utilizing a FeatureMeerger converter to perform table connection on a space element attribute table of a space feature element object and the feature expression table and the map relation of the feature element obtained in the step S2-3, taking a GB code field of a geographic information space database element and a code field of original data of the feature element as unique matching fields, hanging an extended attribute table of the GB code field and the original data of the feature element through attributes, and endowing each space element with a target layer and expression attributes under a CAD platform; s3-3, data distribution is carried out on the elements successfully combined in the S1-4 according to geometric types; s3-4, processing a special layer; s3-5, creating a new expression element, creating a new note and filling element in the CAD expression, and converting the content in the extended attribute table into a map symbolic representation; s3-6, setting a data fan-out rule and writing out data;
s4, checking and preprocessing data to be converted, checking the format, the encryption state, the coordinate system and the database version of original data to be converted, and ensuring normal reading and analysis of the data;
s5, setting conversion parameters to perform first block diagram data conversion, setting an original GDB/MDB spatial database coordinate system, a target result coordinate system and a projection mode, setting a CAD result version of a target result, and selecting a first data area to perform data result conversion;
s6, problem searching and data conversion template repairing are completed, elements which are not converted successfully by each converter are searched in FME software by using a DataInspector tool through element data flow counting of a user graphical interface, and the conversion template designed in the step S3 is repaired and completed until all elements are converted;
s7, dividing a data area to execute topographic map batch conversion, formulating a data conversion strategy according to the data quantity and the data format of the data conversion area, carrying out data framing output on a spatial database of the GDB data type according to the map range, and filtering spatial elements through a spatialFilter converter to carry out block processing; combining a plurality of MDB original files for conversion output according to the adjacency relation for the MDB spatial database;
s8, sampling the digital topographic map data conversion result, and performing sampling data quality inspection on all the conversion result data in the step S7, wherein the map amplitude proportion of the sampling inspection is 10%;
s9, manufacturing a range line of the digital topographic map; s9-1, extracting the range lines of the topographic map sheets in batch, extracting the range vector surface elements of each topographic map sheet from topographic map data according to the layer element codes, and converting the range vector surface elements into files in a DWG format for outputting; s9-2, marking and making the name of the map sheet of the topographic map;
s10, sorting and filing the digital topographic map conversion result.
2. The method for fast conversion of spatial database to railway CAD digital topographic map full elements as claimed in claim 1, wherein: in the step S2, according to the design data of the spatial database, the expression rule of the point-line-surface elements of each type of ground objects on the CAD platform is combed.
3. The method for rapid conversion of spatial database to railroad CAD digital topographic map full elements as claimed in claim 1, wherein: and in the step S3, the GDB/MDB spatial database is converted into the CAD full element through the FME platform.
4. The method for rapid conversion of spatial database to railroad CAD digital topographic map full elements as claimed in claim 1, wherein: the step S3-3 specifically includes data splitting of points, lines and surfaces, the point elements are further divided into two types, namely notes and block references, the line elements are written according to the template file expression style, and the planar elements are divided into planar elements including filling and planar elements not including filling.
5. The method for fast conversion of spatial database to railway CAD digital topographic map full elements as claimed in claim 1, wherein: the step S3-4 specifically comprises the step of processing 3 special layer elements of the equal altitude, the common house and the high-rise house.
6. The method for fast conversion of spatial database to railway CAD digital topographic map full elements as claimed in claim 1, wherein: and S3-6 specifically comprises the steps of establishing a writing module, carrying out data fan-out on the ground feature elements after conversion and establishment according to target ground feature element codes, enabling the writing module to reclassify and store data according to target layer codes, writing a template according to the block references and the layer definition references obtained in the S1-2, and writing a DWG format topographic map result.
7. The method for rapid conversion of spatial database to railroad CAD digital topographic map full elements as claimed in claim 1, wherein: in the step S6, the FME software is used for developing a visual component programming mode, monitoring and debugging the flow direction of the data elements, quickly searching the reason for unsuccessfully converting the elements, and repeatedly executing the operation S6 until complete conversion of the land elements is realized.
8. The method for fast conversion of spatial database to railway CAD digital topographic map full elements as claimed in claim 1, wherein: and in the step S7, according to the topographic map amplitude range, carrying out regional batch automatic conversion processing in a space analysis mode.
9. The method for rapid conversion of spatial database to railroad CAD digital topographic map full elements as claimed in claim 1, wherein: the checking content in the step S8 comprises (1) graphic expression errors and surface feature element style errors; (2) missing the topographic map element graph; (3) the critical information is lost.
10. The method for fast conversion of spatial database to railway CAD digital topographic map full elements as claimed in claim 1, wherein: the step S9-2 is specifically to acquire the topographic map number of each topographic map from the topographic map data, create a character annotation form of the topographic map number, combine the character annotation form with the topographic map range vector elements in the step S9-1, and output the combined result, wherein the annotation position is the geometric center of the polygon corresponding to the map range in the step S9-1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211002930.1A CN115080682B (en) | 2022-08-22 | 2022-08-22 | Method for quickly converting space database to railway CAD digital topographic map full elements |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211002930.1A CN115080682B (en) | 2022-08-22 | 2022-08-22 | Method for quickly converting space database to railway CAD digital topographic map full elements |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115080682A CN115080682A (en) | 2022-09-20 |
| CN115080682B true CN115080682B (en) | 2022-10-25 |
Family
ID=83244612
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211002930.1A Active CN115080682B (en) | 2022-08-22 | 2022-08-22 | Method for quickly converting space database to railway CAD digital topographic map full elements |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115080682B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116302488B (en) * | 2023-01-17 | 2024-01-23 | 重庆市地理信息和遥感应用中心(重庆市测绘产品质量检验测试中心) | Multi-process automatic identification conversion method for topographic map data coordinates |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105279243A (en) * | 2015-09-28 | 2016-01-27 | 张新长 | Spatial data conversion method and system |
| CN108804700A (en) * | 2018-06-15 | 2018-11-13 | 武汉智图科技有限责任公司 | A kind of method of map datum lossless conversion of batch from ArcGIS to CorelDraw |
| CN111475559A (en) * | 2020-04-07 | 2020-07-31 | 广东省城乡规划设计研究院 | Multi-directional conversion method for urban and rural planning result data |
-
2022
- 2022-08-22 CN CN202211002930.1A patent/CN115080682B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105279243A (en) * | 2015-09-28 | 2016-01-27 | 张新长 | Spatial data conversion method and system |
| CN108804700A (en) * | 2018-06-15 | 2018-11-13 | 武汉智图科技有限责任公司 | A kind of method of map datum lossless conversion of batch from ArcGIS to CorelDraw |
| CN111475559A (en) * | 2020-04-07 | 2020-07-31 | 广东省城乡规划设计研究院 | Multi-directional conversion method for urban and rural planning result data |
Non-Patent Citations (3)
| Title |
|---|
| 从数据库地形数据到CAD地形数据的快速无缝转换研究;王娇;《铁道勘察》;20180615(第03期);第1-5页 * |
| 基于ArcGIS Engine的地理数据库属性转换至CAD注记的优化研究;赵振洋;《铁道勘察》;20181215(第06期);第35-38页 * |
| 基于FME的CAD与GIS数据转换研究;李明峰等;《现代测绘》;20170725(第04期);第1-4页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115080682A (en) | 2022-09-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7492364B2 (en) | System and method for creating and updating a three-dimensional model and creating a related neutral file format | |
| Raper et al. | Design models and functionality in GIS | |
| CN108830554B (en) | Task model-based intelligent detection method and system for data result information quality | |
| CN109977162A (en) | A kind of urban and rural planning data transfer device, system and computer readable storage medium | |
| Tomlinson et al. | The state of development of systems for handling natural resources inventory data | |
| CN113157665B (en) | Intelligent all-in-one geographic information system | |
| CN103177103A (en) | Three-dimensional geographical information system management platform | |
| CN115080682B (en) | Method for quickly converting space database to railway CAD digital topographic map full elements | |
| US20220391553A1 (en) | Building information modeling systems and methods | |
| Abdelmoty et al. | Towards maintaining consistency of spatial databases | |
| JPWO2003048980A1 (en) | Method and program for converting 3D shape data into cell internal data | |
| WO2023241519A1 (en) | Bim component creation method and apparatus, and digital design resource library application method and apparatus | |
| CN109933588B (en) | Method and system for converting dwg data into gdb data | |
| CN111199086A (en) | Three-dimensional geometric discretization processing system | |
| CN110688688A (en) | Method for converting surveying and mapping completion diagrams into surveying and mapping delimiting diagrams in batch | |
| Aronson et al. | The ARC/INFO map library: a design for a digital geographic database | |
| CN110737790B (en) | General image data set management method based on database | |
| CN110675729B (en) | Multi-version local geographic information integrated drawing method and system | |
| Wen et al. | Research on Direct Topological Structure Reconstruction for STL Model | |
| CN117392269B (en) | Pipe network drawing data extraction method and device | |
| WO2012115592A1 (en) | A method and an apparatus for generating a vascular model | |
| CN114595610B (en) | Method for creating tunnel finite element model based on Revit secondary development and Ansys command stream | |
| CN115774749A (en) | AutoCAD platform and general GIS platform data lossless conversion method | |
| CN117829100A (en) | Basic geographic entity data conversion method and device | |
| CN1808443A (en) | System and method of simplifying graphical components |
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 |