CN111475559A - Multi-directional conversion method for urban and rural planning result data - Google Patents
Multi-directional conversion method for urban and rural planning result data Download PDFInfo
- Publication number
- CN111475559A CN111475559A CN202010266689.8A CN202010266689A CN111475559A CN 111475559 A CN111475559 A CN 111475559A CN 202010266689 A CN202010266689 A CN 202010266689A CN 111475559 A CN111475559 A CN 111475559A
- Authority
- CN
- China
- Prior art keywords
- cad
- data
- planning
- file
- format
- 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.)
- Pending
Links
- 238000006243 chemical reaction Methods 0.000 title claims abstract description 17
- 238000000034 method Methods 0.000 title claims abstract description 15
- 238000013507 mapping Methods 0.000 claims abstract description 12
- 239000011248 coating agent Substances 0.000 claims abstract description 6
- 238000000576 coating method Methods 0.000 claims abstract description 6
- 238000007781 pre-processing Methods 0.000 claims abstract description 4
- 239000002689 soil Substances 0.000 claims abstract description 4
- 238000007689 inspection Methods 0.000 claims description 11
- 238000013500 data storage Methods 0.000 claims description 3
- 230000008520 organization Effects 0.000 claims description 3
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
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/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
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Remote Sensing (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention discloses a multi-directional conversion method for urban and rural planning result data, which comprises the following specific steps: preprocessing a CAD topographic map, and dividing the CAD topographic map into layers; creating a mapping relation table according to the coating attribute mapping relation; checking a topological problem in source CAD data, and producing an error-reporting data file path; automatically associating the plot codes in the CAD planning soil file with the planning plots; generating a standard GIS format database according to the standard of the legal urban and rural planning database with the excel format, and transferring the CAD format planning graph file to the standard format database; extracting CAD topographic map elements and converting the CAD topographic map elements into GIS database files; dividing layers according to the field of the layers, and exporting the CAD color blocks into points, lines and surfaces; and converting the GIS format database into CAD format data according to the filling color and the line width style of the original CAD planning drawing file, and keeping the color and the line width style of the exported drawing file and the original planning drawing consistent. The invention reduces the workload of data conversion to the maximum extent and improves the working efficiency by about 200 percent.
Description
Technical Field
The invention relates to a data conversion method, in particular to a multi-directional conversion method for urban and rural planning result data.
Background
In order to implement the work content of the reform and test point province of the Guangdong province urban and rural planning management system, the implementation of city overall planning reformation innovation is promoted, and the construction requirements of planning informatization and a blueprint are met. The majority of domestic legal urban and rural planning result data are drawn, stored and examined by vector graphics through AutoCAD DWG, DWG format data lack uniform spatial reference coordinates, spatial data cannot be directly associated with attribute information, and the planning result is inconvenient to manage and quickly check.
With the promulgation of the legal urban and rural planning result data standard of Guangdong province, professional technicians spend a great deal of time converting data. At present, planning drawings in DWG format are converted into GDB format data, technicians spend a lot of manpower to perform data format conversion, attribute table association, data topology inspection, field operation and other work, and the work time is long and the efficiency is low.
Disclosure of Invention
Aiming at the defects of the prior art, the invention aims to provide a multi-way conversion method for urban and rural planning result data, which can quickly realize conversion of different data formats, improve the working efficiency and ensure lossless conversion of the data.
In order to achieve the purpose, the invention adopts the following technical scheme:
a multi-directional conversion method for urban and rural planning result data comprises the following specific steps:
preprocessing a CAD topographic map, and dividing the CAD topographic map into layers;
creating a mapping relation table according to the coating attribute mapping relation;
checking a topological problem in source CAD data, and producing an error-reporting data file path;
automatically associating the plot codes in the CAD planning soil file with planning plots, associating the plot codes with existing information, and putting the information into a database;
generating a standard GIS format database according to the standard of the legal urban and rural planning database with the excel format, and transferring the CAD format planning graph file to the standard format database;
extracting CAD topographic map elements and converting the CAD topographic map elements into GIS database files;
realizing a layer required by legal city planning entry standard from a GIS data file to CAD data through FME Workbench, dividing the layer according to the field of the layer, and exporting CAD color blocks into points, lines and surfaces;
and converting the GIS format database into CAD format data according to the filling color and the line width style of the original CAD planning drawing file, and keeping the color and the line width style of the exported drawing file and the original planning drawing consistent.
Further, the creating a mapping relation table according to the coating attribute mapping relation mainly comprises: and establishing a reasonable corresponding relation according to the relation among the layer data organization, the layer data structure, the symbol, the coordinate and the topology.
Further, the topology problem in the inspection source CAD data mainly includes: self-intersection problems, micro-facet problems, pattern overlay problems, sharp corner problems, and seam checking.
Further, the checking for topology problems in the source CAD data, the main steps of producing the error-reporting data file path are:
selecting original data needing topology problem inspection;
selecting a layer to be subjected to topology inspection;
checking whether the data in the source data has tolerance and sharp corners;
determining the minimum tolerance value of the error reporting area of the gap;
determining the shortest value of the width of the gap surface;
determining the error reporting tolerance of the overlapped surface, and outputting an error if the area of the overlapped surface is larger than the error reporting tolerance;
and producing an error reporting data file path.
Further, the specific steps of extracting the CAD topographic map elements and converting the CAD topographic map elements into the GIS database file are as follows:
detecting an original CAD data path needing to convert the CAD file into the GIS without errors;
capturing the line head and tail node tolerance in the range of the unconnected area;
establishing a standard library structure generated by a structure library;
outputting and converting into a GIS format data storage path;
and storing the element code table path and the new and old city land use classification table path.
Further, the step of dividing the layers according to the layer fields and exporting the CAD color blocks into points, lines and surfaces comprises the following specific steps:
selecting a source GIS data path needing to be converted into a CAD format;
selecting all CAD layers needing to be converted in data except the GIS format;
defining a CAD layer and a symbol file path;
and generating a dwg path and outputting a CAD file path.
The invention has the beneficial effects that: the invention reduces the workload of data conversion to the maximum extent, realizes automatic conversion and upgrade from manual operation to machines, improves the working efficiency by about 200 percent, forms a software tool capable of being copied and popularized, and provides an integrated solution for warehousing of the territorial space planning database and the planning result of the urban planning information platform.
Drawings
FIG. 1 is a flow chart of the method of the present invention.
Detailed Description
The invention will be further described with reference to the accompanying drawings and the detailed description below:
example one
As shown in fig. 1, a method for multi-directional transformation of urban and rural planning result data includes the following specific steps:
preprocessing a CAD topographic map, dividing the CAD topographic map into layers, and planning a range layer, a land map spot layer, a road red line layer, a road center line layer and a current implementation point layer;
creating a mapping relation table according to the coating attribute mapping relation, and creating a reasonable corresponding relation according to the relation among layer data organization, a layer data structure, a symbol, a coordinate and topology;
checking a topological problem in source CAD data, and producing an error-reporting data file path; the topology problem in the inspection source CAD data mainly includes: self-intersection problems, micro-facet problems, pattern overlay problems, sharp corner problems, and seam inspection;
automatically associating the plot codes in the CAD planning soil file with planning plots, associating the plot codes with existing information, and putting the information into a database;
generating a standard GIS format database according to the standard of the legal urban and rural planning database with the excel format, and transferring the CAD format planning graph file to the standard format database;
extracting CAD topographic map elements and converting the CAD topographic map elements into GIS database files;
realizing a layer required by legal city planning entry standard from a GIS data file to CAD data through FME Workbench, dividing the layer according to the field of the layer, and exporting CAD color blocks into points, lines and surfaces;
and converting the GIS format database into CAD format data according to the filling color and the line width style of the original CAD planning drawing file, and keeping the color and the line width style of the exported drawing file and the original planning drawing consistent.
Checking the topological problem in the source CAD data, and producing the error-reporting data file path mainly comprises the following steps:
selecting original data needing topology problem inspection;
selecting a layer to be subjected to topology inspection;
checking whether the data in the source data has tolerance and sharp corners;
determining the minimum tolerance value of the error reporting area of the gap;
determining the shortest value of the width of the gap surface;
determining the error reporting tolerance of the overlapped surface, and outputting an error if the area of the overlapped surface is larger than the error reporting tolerance;
and producing an error reporting data file path.
The specific steps of extracting CAD topographic map elements and converting the CAD topographic map elements into GIS database files are as follows:
detecting an original CAD data path needing to convert the CAD file into the GIS without errors;
capturing the line head and tail node tolerance in the range of the unconnected area;
establishing a standard library structure generated by a structure library;
outputting and converting into a GIS format data storage path;
and storing the element code table path and the new and old city land use classification table path.
Dividing layers according to the field of the layers, and exporting the CAD color blocks into points, lines and surfaces:
selecting a source GIS data path needing to be converted into a CAD format;
selecting all CAD layers needing to be converted in data except the GIS format;
defining a CAD layer and a symbol file path;
and generating a dwg path and outputting a CAD file path.
Various other modifications and changes may be made by those skilled in the art based on the above-described technical solutions and concepts, and all such modifications and changes should fall within the scope of the claims of the present invention.
Claims (6)
1. A multi-directional conversion method for urban and rural planning result data is characterized by comprising the following specific steps:
preprocessing a CAD topographic map, and dividing the CAD topographic map into layers;
creating a mapping relation table according to the coating attribute mapping relation;
checking a topological problem in source CAD data, and producing an error-reporting data file path;
automatically associating the plot codes in the CAD planning soil file with the planning plots;
generating a standard GIS format database according to the standard of the legal urban and rural planning database with the excel format, and transferring the CAD format planning graph file to the standard format database;
extracting CAD topographic map elements and converting the CAD topographic map elements into GIS database files;
realizing a layer required by legal city planning entry standard from a GIS data file to CAD data through FME Workbench, dividing the layer according to the field of the layer, and exporting CAD color blocks into points, lines and surfaces;
and converting the GIS format database into CAD format data according to the filling color and the line width style of the original CAD planning drawing file, and keeping the color and the line width style of the exported drawing file and the original planning drawing consistent.
2. The method as claimed in claim 1, wherein the step of creating the mapping table according to the coating attribute mapping relationship mainly comprises: and establishing a reasonable corresponding relation according to the relation among the layer data organization, the layer data structure, the symbol, the coordinate and the topology.
3. The method as claimed in claim 1, wherein the topology problem in the CAD data of the inspection source mainly includes: self-intersection problems, micro-facet problems, pattern overlay problems, sharp corner problems, and seam checking.
4. The method for multi-directional conversion of urban and rural planning result data according to claim 1, wherein the main steps of checking topology problems in source CAD data and producing error-reporting data file paths are as follows:
selecting original data needing topology problem inspection;
selecting a layer to be subjected to topology inspection;
checking whether the data in the source data has tolerance and sharp corners;
determining the minimum tolerance value of the error reporting area of the gap;
determining the shortest value of the width of the gap surface;
determining the error reporting tolerance of the overlapped surface, and outputting an error if the area of the overlapped surface is larger than the error reporting tolerance;
and producing an error reporting data file path.
5. The method for multi-directional conversion of urban and rural planning result data according to claim 1, wherein the specific steps of extracting the CAD topographic map elements and converting the CAD topographic map elements into the GIS database file are as follows:
detecting an original CAD data path needing to convert the CAD file into the GIS without errors;
capturing the line head and tail node tolerance in the range of the unconnected area;
establishing a standard library structure generated by a structure library;
outputting and converting into a GIS format data storage path;
and storing the element code table path and the new and old city land use classification table path.
6. The method for multi-directional conversion of urban and rural planning result data according to claim 1, wherein the specific steps of dividing layers according to layer fields, deriving CAD color blocks as points, lines and faces are as follows:
selecting a source GIS data path needing to be converted into a CAD format;
selecting all CAD layers needing to be converted in data except the GIS format;
defining a CAD layer and a symbol file path;
and generating a dwg path and outputting a CAD file path.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010266689.8A CN111475559A (en) | 2020-04-07 | 2020-04-07 | Multi-directional conversion method for urban and rural planning result data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010266689.8A CN111475559A (en) | 2020-04-07 | 2020-04-07 | Multi-directional conversion method for urban and rural planning result data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111475559A true CN111475559A (en) | 2020-07-31 |
Family
ID=71750149
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010266689.8A Pending CN111475559A (en) | 2020-04-07 | 2020-04-07 | Multi-directional conversion method for urban and rural planning result data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111475559A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347168A (en) * | 2020-10-23 | 2021-02-09 | 国网天津市电力公司 | Automatic data processing and converting method for CAD-GIS system |
| CN115080682A (en) * | 2022-08-22 | 2022-09-20 | 中国铁路设计集团有限公司 | Method for quickly converting space database to railway CAD digital topographic map full elements |
| CN117251518A (en) * | 2023-09-28 | 2023-12-19 | 广东省城乡规划设计研究院有限责任公司 | Urban safety planning design method for synchronous operation of GIS platform and CAD platform |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105279243A (en) * | 2015-09-28 | 2016-01-27 | 张新长 | Spatial data conversion method and system |
| CN105868392A (en) * | 2016-04-18 | 2016-08-17 | 重庆市勘测院 | Method for lossless conversion and storage of massive complex planning data based on MicroStation |
| CN106971040A (en) * | 2017-03-29 | 2017-07-21 | 北京晶众智慧交通科技股份有限公司 | It is a kind of based on the flat three-dimensional road fast modeling method designed in length and breadth |
| CN109977162A (en) * | 2019-04-10 | 2019-07-05 | 广东省城乡规划设计研究院 | A kind of urban and rural planning data transfer device, system and computer readable storage medium |
| CN110096783A (en) * | 2019-04-25 | 2019-08-06 | 西门子电站自动化有限公司 | The method that slave connection figure based on AutoCAD extracts connection data |
-
2020
- 2020-04-07 CN CN202010266689.8A patent/CN111475559A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105279243A (en) * | 2015-09-28 | 2016-01-27 | 张新长 | Spatial data conversion method and system |
| CN105868392A (en) * | 2016-04-18 | 2016-08-17 | 重庆市勘测院 | Method for lossless conversion and storage of massive complex planning data based on MicroStation |
| CN106971040A (en) * | 2017-03-29 | 2017-07-21 | 北京晶众智慧交通科技股份有限公司 | It is a kind of based on the flat three-dimensional road fast modeling method designed in length and breadth |
| CN109977162A (en) * | 2019-04-10 | 2019-07-05 | 广东省城乡规划设计研究院 | A kind of urban and rural planning data transfer device, system and computer readable storage medium |
| CN110096783A (en) * | 2019-04-25 | 2019-08-06 | 西门子电站自动化有限公司 | The method that slave connection figure based on AutoCAD extracts connection data |
Non-Patent Citations (2)
| Title |
|---|
| 曾国萍;刘盛庆;: "基于FME的基础测绘数据向GIS格式转换的研究", no. 04, pages 19 - 22 * |
| 王婷丽;: "基于ArcGIS的规划数据格式转换研究", no. 01, pages 55 - 58 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112347168A (en) * | 2020-10-23 | 2021-02-09 | 国网天津市电力公司 | Automatic data processing and converting method for CAD-GIS system |
| CN115080682A (en) * | 2022-08-22 | 2022-09-20 | 中国铁路设计集团有限公司 | Method for quickly converting space database to railway CAD digital topographic map full elements |
| CN115080682B (en) * | 2022-08-22 | 2022-10-25 | 中国铁路设计集团有限公司 | Method for quickly converting space database to railway CAD digital topographic map full elements |
| CN117251518A (en) * | 2023-09-28 | 2023-12-19 | 广东省城乡规划设计研究院有限责任公司 | Urban safety planning design method for synchronous operation of GIS platform and CAD platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111475559A (en) | Multi-directional conversion method for urban and rural planning result data | |
| CN113157665B (en) | Intelligent all-in-one geographic information system | |
| CN105279243B (en) | A kind of method and system of Conversion of Spatial Data | |
| CN109977162A (en) | A kind of urban and rural planning data transfer device, system and computer readable storage medium | |
| CN108388620B (en) | Land approval surveying and mapping data processing information system | |
| CN104361025B (en) | A kind of multi-source Spatial Data fusion and integrated method | |
| CN105976313A (en) | Method and system for transforming CAD plane coordinate system to Baidu map coordinate system | |
| CN115293751A (en) | Method, system and equipment for processing BIM model data of rail transit | |
| CN109598056B (en) | Method and system for measuring urban construction land form compactness and storage medium | |
| CN114968984A (en) | Digital twin full life cycle management platform | |
| CN110659317A (en) | BIM data lightweight method | |
| CN107273486A (en) | Map updating method and device | |
| CN115080682A (en) | Method for quickly converting space database to railway CAD digital topographic map full elements | |
| CN111126698B (en) | Land planning use automatic adjustment method and storage medium | |
| CN109933588B (en) | Method and system for converting dwg data into gdb data | |
| CN112200857A (en) | Land area automatic quantity calculation method for land acquisition and migration | |
| CN115774749A (en) | AutoCAD platform and general GIS platform data lossless conversion method | |
| CN114996886A (en) | Multi-metadata-fused complete automatic drawing system and method for distribution network single line diagram | |
| CN116956837A (en) | Project determining method and device for engineering quantity list | |
| CN110619134B (en) | Integrated detection and repair method for solving problem of flying spot and spot density of road network data | |
| CN113468625A (en) | Computer automatic statistical method for multiple types of areas in limited range | |
| CN112328538A (en) | PMS2.0 graph model file importing method | |
| CN111506690A (en) | Method for lossless conversion from southern CASS data to MapGis data | |
| CN114443624A (en) | Basic geographic information data quality inspection method | |
| CN117251518B (en) | Urban safety planning design method for synchronous operation of GIS platform and CAD platform |
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 |