Geographic information data production, quality inspection and warehousing integrated system and method in CAD environment
By establishing an integrated system for geographic information data production, quality inspection, and warehousing in a CAD environment, the problems of data standard adaptation and format compatibility of traditional CAD tools have been solved, and efficient data production, quality inspection, and warehousing processing have been achieved.
Patent Information
- Application Number
- CN202511548573.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-10-28
- Publication Date
- 2026-02-27
AI Technical Summary
Traditional CAD tools rely on fixed built-in rules in the production of geographic information elements, which requires modification of the underlying software code when adapting to different project data standards. This results in low quality inspection efficiency and a high risk of missing data. Furthermore, the DWG format has poor compatibility with GIS databases, leading to data conversion failures or information loss.
It provides an integrated system and method for geographic information data production, quality inspection, and warehousing in a CAD environment. It establishes drawing standards by collecting historical data and drawing rule configuration files, performs mapping and association processing and hierarchical feature extraction, and performs warehousing processing by combining feature comparison and reverse mapping methods.
It has achieved integrated operation of data production, quality inspection and warehousing, which has improved the accuracy and stability of data warehousing, reduced manual intervention and complex format conversion, and improved work efficiency.
Smart Images

Figure CN121579966A_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of data processing technology, specifically to an integrated system and method for geographic information data production, quality inspection, and warehousing in a CAD environment. Background Technology
[0002] Traditional CAD tools rely on fixed built-in rules for generating geographic information elements. Due to the lack of integrated quality inspection tools, this stage often depends on manual sampling combined with simple software tools. The checks cover the geometric accuracy and attribute completeness of the elements. However, manual sampling is prone to randomness and inefficiency, while simple software tools are difficult to cover complex quality inspection needs. This can easily lead to some hidden errors going undetected, creating potential problems for subsequent data applications.
[0003] Meanwhile, since the data that passes quality inspection needs to enter the warehousing stage, and the DWG format of CAD has poor compatibility with Geographic Information System (GIS) databases, format conversion is necessary. Common conversion target formats include SHP and GDB. However, different software tools have varying degrees of support for format conversion, and problems such as data loss (e.g., missing attribute fields, reduced geometric accuracy) and format incompatibility leading to conversion failure often occur during the conversion process.
[0004] Existing technology, such as the invention patent application with publication number CN112906091A, discloses a CAD-based geographic information drawing method, device, terminal, and medium. The method includes: acquiring an input geographic information CAD file; acquiring entity block data and basic data from the geographic information CAD file; determining the entity block data processing method corresponding to the entity block data based on the type information in the entity block data and the correspondence between the type information and the block processing method; and drawing the entity block data one by one according to the entity data parameters in the entity block data and the basic data, through the entity block data processing method. By processing the entity block data of the CAD file, and then according to the type information and entity data parameters in the entity block data, combined with the basic data, and through the entity block data processing method matching the type, the geographic information CAD file can be imported into the GIS platform while maintaining high fidelity.
[0005] As can be seen from the above solutions, current traditional CAD tools rely on fixed built-in rules for the production of geographic information elements. When it is necessary to adapt to the data standards of different projects, it is often necessary to modify the underlying software code or rely on secondary development, which is difficult for ordinary users to complete independently. At the same time, in the data quality inspection stage, existing quality inspections mostly rely on manual sampling, which is inefficient and prone to omissions. Furthermore, because different software tools are used in the production, quality inspection, and warehousing stages, there is a lack of effective integration. Summary of the Invention
[0006] The purpose of this invention is to provide an integrated system and method for geographic information data production, quality inspection, and warehousing in a CAD environment, which solves the problems existing in the background technology.
[0007] To solve the above-mentioned technical problems, the present invention adopts the following technical solution: The present invention provides an integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment, specifically including the following steps: S1. Collect historical geographic information data and drawing rule configuration files to establish geographic information drawing standards, and build a drawing sample library based on the established geographic information drawing standards; S2. Perform mapping and association processing on the historical geographic information data in the sample database to obtain the mapped and associated historical geographic information data. S3. Real-time production of geographic information data, and inspection of the real-time produced geographic information data based on the established geographic information drawing standards to obtain the inspected geographic information data. S4. Based on the inspected geographic information data, hierarchical feature extraction is performed on the inspected geographic information data using feature extraction methods to obtain the hierarchical extracted features of the inspected geographic information data. S5. Hierarchical feature extraction is performed on the historical geographic information data after mapping and association processing using feature extraction methods to obtain the hierarchical extracted features of the historical geographic information data. S6. Compare the hierarchical extraction features of the inspected geographic information data with the hierarchical extraction features of the historical geographic information data. At the same time, record the attribute data of the inspected geographic information data through reverse mapping and put the recorded attribute data into the database.
[0008] Preferably, the process of collecting historical geographic information data and mapping rule configuration files to establish geographic information mapping standards, and constructing a mapping sample library based on these standards, includes the following steps: Historical geographic information data includes: geographic information collection time, scale, geographic location information, and geographic information content; Geographic information content includes: the geographic information data's identifier, and the attribute data of the three elements: points, lines, and polygons; The drawing rule configuration file includes: the color, line type, CAD layer, and GIS table mapping relationship of the three elements of points, lines, and polygons; Any geographic information mapping standard must include historical geographic information data and mapping rule configuration files. A database of geographic information mapping standard data was compiled to construct a mapping sample library.
[0009] Preferably, the process of mapping and associating historical geographic information data in the sample database to obtain mapped and associated historical geographic information data includes the following steps: Based on the definition of point features in geographic information data in the rule mapping library, call the general interface for drawing point features; The point feature drawing general interface, based on the configuration file, parses the point features in the historical geographic information data into the block insertion positions, inserts the corresponding block entities in the specified CAD layer, and associates the attribute information of the layer in the configuration table. Based on the configuration rules of line features in the rule mapping library, the general interface for drawing line features is called. The interface draws line features using POLYLINE in CAD. Configure the line color and line type according to the settings, and place it in the corresponding CAD layer; According to the configuration requirements of the polygon features in the rule mapping library, call the general interface for drawing polygon features; The interface uses closed polylines in CAD to draw the boundaries of polygon features, and defines the fill style and layer of the polygon according to the configuration to complete the drawing of polygon features. The processing results of historical geographic information data by the rule mapping library are summarized to obtain historical geographic information data after mapping and association processing.
[0010] Preferably, the real-time generated geographic information data, and the real-time generated geographic information data being checked based on the established geographic information mapping standards, to obtain the checked geographic information data, includes the following steps: S31. Perform spatial geometry checks on real-time production geographic information data to obtain geographic information data after spatial geometry checks. According to the preset checklist, perform spatial geometric checks on each element in the real-time production geographic information data: Based on a preset list, the point features in the real-time production geographic information data are traversed. During the traversal, a traversal area is selected, and the entity coordinates and attributes of each point feature are traversed within the selected traversal area. When there are duplicate entity coordinates and attributes of point features, the duplicate point features are deleted and filtered. After filtering out duplicate points, set a threshold for the number of line feature vertices and calculate the number of line feature vertices; Determine if the number of line points is too low based on the set threshold for the number of line element vertices; Set a threshold for the area of polygon features, calculate the area of polygon features based on the set threshold, compare it with the minimum threshold, and check whether it is an ultra-small polygon. A topology algorithm is used to detect whether polylines are self-intersecting. At the same time, based on the coordinates of the intersection points and the concept of the same attributes, the polylines are checked for repeated endpoints and closure. Calculate the length of line features to determine if they are ultra-short lines, and compare entity coordinates and attributes to check for duplicate blocks, lines, and text. Finally, scan layer 0 to check if there is any data. S32. Perform attribute information checks on the geographic information data after spatial geometry checks to obtain the checked geographic information data.
[0011] Preferably, the step of performing attribute information checks on the geographic information data after spatial geometry checks to obtain the checked geographic information data includes the following steps: Set a unique identifier (GUID) for the comparison elements, specifically the number of the geographic information data after spatial geometric inspection; Create a length of Select the array Each hash function calculates the unique identifier (GUID) of features in the geographic information data after spatial geometry inspection, and stores the calculation results in an array; in, Indicates the number of hash functions. Indicates the amount of geographic information data after spatial geometry inspection; During the process of calculating the unique identifier (GUID) of features in the geographic information data after spatial geometry inspection using the hash function, if the calculation results of the unique identifier (GUID) of features in two sets of geographic information data after spatial geometry inspection are consistent, the current two sets of geographic information data after spatial geometry inspection are set as duplicates. Verify whether the data type of the attribute value is consistent with the configuration table definition, determine whether the attribute and field types match, and check for the existence of entities without assigned codes, i.e., uncoded entity checks. After the uncoded entity check is completed, verify the mapping relationship between the entity code and the configuration of the layer it belongs to, check whether the entity code layer corresponds, and at the same time perform the entity linetype check to verify whether the linetype is consistent with the configuration file. After checking the entity linetype, check the required attribute fields to confirm whether the required attribute fields have values. The geographic information data after checking the required attribute fields is summarized to obtain the checked geographic information data.
[0012] Preferably, the step of extracting hierarchical features from the inspected geographic information data using a feature extraction method to obtain the hierarchical extracted features of the inspected geographic information data includes the following steps: S41. Based on the inspected geographic information data, separate each layer in the inspected geographic information data to obtain the geographic information data of each layer. S42. After obtaining the geographic information data of each layer, the point, line and area features in the geographic information data of each layer are extracted by feature extraction method, and the extracted features are correlated to obtain the layered extracted features of the inspected geographic information data.
[0013] Preferably, after obtaining the geographic information data of each layer, the point, line, and area features in the geographic information data of each layer are extracted using a feature extraction method, and the extracted features are correlated to obtain the layered extracted features of the inspected geographic information data, which includes the following steps: S421. After obtaining the geographic information data of each layer, extract the geometric feature points in the geographic information data of each layer based on the precise coordinate attributes of the CAD vector data. Define feature point extraction rules based on primitive type: For point layer primitives, their original coordinates are directly used as the basic feature points; For line layer primitives, extract the endpoints, inflection points, and intersections of the line segment with other primitives as feature points; For polygon primitives, extract the vertices of the outer polygon, the vertices of the inner hole, the intersections of the face boundary with other primitives as feature points; S422. After obtaining the geometric feature points in the geographic information data of each layer, extract line and surface features based on the original topological relationship of the CAD vector data. Line feature extraction: Directly read the primitives with continuous coordinate sequences in the line layer as the basic line features, and combine them with the line feature points extracted by S421 to filter out line elements that meet the preset length threshold and precision threshold. Surface feature extraction: Based on the native closed polygon primitives in the surface layer, surface features are determined by the closure of their boundary lines and topological inclusion relationships. The boundary integrity is verified by combining the surface feature points extracted in S421. S423: Summarize and extract point, line, and surface features from the geographic information data of each layer to obtain the layered extracted features of the inspected geographic information data.
[0014] Preferably, the step of performing hierarchical feature extraction on the historical geographic information data after mapping and association processing using feature extraction methods to obtain hierarchical extracted features of the historical geographic information data includes the following steps: Based on steps S41 and S42, hierarchical feature extraction is performed on the historical geographic information data after mapping and association processing to obtain the hierarchical extracted features of the historical geographic information data.
[0015] Preferably, the step of comparing the hierarchical extracted features of the inspected geographic information data with the hierarchical extracted features of the historical geographic information data, recording the attribute data of the inspected geographic information data through a reverse mapping method, and storing the recorded attribute data in the database includes the following steps: Set a feature comparison threshold, and calculate the feature comparison value between the hierarchical extracted features of the inspected geographic information data and the hierarchical extracted features of the historical geographic information data based on the set feature comparison threshold; The formula for calculating the feature contrast value is as follows: ; in, This indicates the hierarchical extraction features of the geographic information data after inspection. A Layered feature extraction from historical geographic information data B Feature contrast values; A This indicates the hierarchical extraction features of the geographic information data after inspection. B This represents the hierarchical extraction features of historical geographic information data; Based on the set feature comparison threshold, when the feature comparison value is greater than or equal to the set feature comparison threshold, the geographic information data after inspection and the corresponding historical geographic information data are set to be the same type of data. Based on the GIS table mapping relationship defined in the configuration file, identify the name of the spatial data table in the target PostgreSQL database; After checking, the geographic information data is matched against the table structure, and the data is written to the PostgreSQL database through the database connection protocol to complete the data insertion operation.
[0016] This invention also provides an integrated system for geographic information data production, quality inspection, and warehousing in a CAD environment, which is used to realize an integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment. The system includes: a data acquisition module, a data processing module, a data inspection module, a feature extraction module, a warehousing processing module, and a PostgreSQL database. The data acquisition module is used to collect geographic information data and drawing rule configuration files to establish geographic information drawing standards. The data processing module is used to perform mapping and association processing on the collected geographic information data; The data inspection module is used to inspect real-time produced geographic information data according to the established geographic information drawing standards. The feature extraction module is used to extract features from the inspected and processed geographic information data using feature extraction methods. The data entry processing module is used to record the attribute data of the inspected geographic information data and to process the recorded attribute data into the database. The PostgreSQL database is used to store geographic information data.
[0017] The beneficial effects of this invention are as follows: (1) This invention establishes geographic information drawing standards and constructs a drawing sample library by collecting historical geographic information data and drawing rule configuration files, and performs mapping and association processing on the historical geographic information data in the sample library; at the same time, it produces geographic information data in real time, and checks the real-time produced geographic information data based on the established geographic information drawing standards. Based on the checked geographic information data, it performs hierarchical feature extraction on the checked geographic information data and the historical geographic information data after mapping and association processing through feature extraction methods. After extraction, the two groups of hierarchically extracted features are compared. At the same time, the attribute data of the checked geographic information data is recorded through reverse mapping, and the recorded attribute data is stored in the database, which improves the accuracy of data storage.
[0018] (2) This invention ensures the reliability of historical geographic information data processing by calling the corresponding interface to map and associate historical geographic information data in the sample library according to the configuration requirements of point features, line features and polygon features in geographic information data in the rule mapping library.
[0019] (3) This invention performs spatial geometry checks on each element in real-time produced geographic information data according to a preset list. It checks the produced geographic information data by filtering duplicate points, judging the number of vertices, judging the area of surface elements, detecting polylines using topology algorithms, calculating the length of line elements, and comparing entity coordinates and attributes, thereby improving the stability of geographic information data production.
[0020] (4) This invention integrates the production, quality inspection and warehousing processes into the same system. In the CAD environment, after the drafting personnel complete the data production, there is no need to perform complex format conversion. The system can directly call the quality inspection module to perform comprehensive quality inspection on the data. After the quality inspection is completed, qualified data is seamlessly connected to the warehousing processing module, realizing one-stop operation from data creation to warehousing, greatly reducing manual intervention and data transmission time, and improving work efficiency. Attached Figure Description
[0021] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0022] Figure 1 This is a schematic diagram of the integrated method for producing, inspecting, and storing geographic information data in a CAD environment according to the present invention. Detailed Implementation
[0023] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.
[0024] In a specific embodiment of the present invention, Reference Figure 1 As shown, this invention provides an integrated system and method for geographic information data production, quality inspection, and warehousing in a CAD environment, including: S1. Collect historical geographic information data and drawing rule configuration files to establish geographic information drawing standards, and build a drawing sample library based on the established geographic information drawing standards; S2. Perform mapping and association processing on the historical geographic information data in the sample database to obtain the mapped and associated historical geographic information data. S3. Real-time production of geographic information data, and inspection of the real-time produced geographic information data based on the established geographic information drawing standards to obtain the inspected geographic information data. S4. Based on the inspected geographic information data, hierarchical feature extraction is performed on the inspected geographic information data using feature extraction methods to obtain the hierarchical extracted features of the inspected geographic information data. S5. Hierarchical feature extraction is performed on the historical geographic information data after mapping and association processing using feature extraction methods to obtain the hierarchical extracted features of the historical geographic information data. S6. Compare the hierarchical extraction features of the inspected geographic information data with the hierarchical extraction features of the historical geographic information data. At the same time, record the attribute data of the inspected geographic information data through reverse mapping and put the recorded attribute data into the database. Furthermore, referring to Figure 1 As shown, the process of collecting historical geographic information data and mapping rule configuration files to establish geographic information mapping standards, and then constructing a mapping sample library based on these standards, includes the following steps: Historical geographic information data includes: geographic information collection time, scale, geographic location information, and geographic information content; Geographic information content includes: the geographic information data's identifier, and the attribute data of the three elements: points, lines, and polygons; The drawing rule configuration file includes: the color, line type, CAD layer, and GIS table mapping relationship of the three elements of points, lines, and polygons; Any geographic information mapping standard must include historical geographic information data and mapping rule configuration files. Furthermore, a mapping sample library is constructed by summarizing standard geographic information mapping data; Furthermore, referring to Figure 1 As shown, the process of mapping and associating historical geographic information data in the sample database to obtain the mapped and associated historical geographic information data includes the following steps: Based on the definition of point features in geographic information data in the rule mapping library, call the general interface for drawing point features; The point feature drawing general interface, based on the configuration file, parses the point features in the historical geographic information data into the block insertion positions, inserts the corresponding block entities in the specified CAD layer, and associates the attribute information of the layer in the configuration table. Based on the configuration rules of line features in the rule mapping library, the general interface for drawing line features is called. The interface draws line features using POLYLINE in CAD. Configure the line color and line type according to the settings, and place it in the corresponding CAD layer; According to the configuration requirements of the polygon features in the rule mapping library, call the general interface for drawing polygon features; The interface uses closed polylines in CAD to draw the boundaries of polygon features, and defines the fill style and layer of the polygon according to the configuration to complete the drawing of polygon features. Furthermore, the processing results of the historical geographic information data by the rule mapping library are summarized to obtain the historical geographic information data after mapping and association processing; Furthermore, referring to Figure 1 As shown, real-time geographic information data is generated, and the real-time generated geographic information data is checked based on the established geographic information mapping standards. The obtained checked geographic information data includes the following steps: S31. Perform spatial geometry checks on real-time production geographic information data to obtain geographic information data after spatial geometry checks. According to the preset checklist, perform spatial geometric checks on each element in the real-time production geographic information data: Based on a preset list, the point features in the real-time production geographic information data are traversed. During the traversal, a traversal area is selected, and the entity coordinates and attributes of each point feature are traversed within the selected traversal area. When there are duplicate entity coordinates and attributes of point features, the duplicate point features are deleted and filtered. After filtering out duplicate points, set a threshold for the number of line feature vertices and calculate the number of line feature vertices; Furthermore, the number of line points is determined based on a set threshold for the number of line element vertices; Furthermore, a threshold for the area of polygon features is set, and the area of polygon features is calculated based on the set threshold. The area is then compared with the minimum threshold to check whether it is an ultra-small polygon. Furthermore, a topology algorithm is used to detect whether polylines are self-intersecting. At the same time, based on the concept of the coordinates of the intersection points and the same attributes, the polylines are checked for repeated endpoints and closure. Furthermore, calculate the length of the line element to determine if it is an ultra-short line, and compare the entity coordinates and attributes to check for duplicate blocks, lines, and text. Finally, scan layer 0 to check if there is any data. S32. Perform attribute information checks on the geographic information data after spatial geometry checks to obtain checked geographic information data. Set a unique identifier (GUID) for the comparison elements, specifically the number of the geographic information data after spatial geometric inspection; Furthermore, establish a length of Select the array Each hash function calculates the unique identifier (GUID) of features in the geographic information data after spatial geometry inspection, and stores the calculation results in an array; in, Indicates the number of hash functions. Indicates the amount of geographic information data after spatial geometry inspection; During the process of calculating the unique identifier (GUID) of features in the geographic information data after spatial geometry inspection using the hash function, if the calculation results of the unique identifier (GUID) of features in two sets of geographic information data after spatial geometry inspection are consistent, the current two sets of geographic information data after spatial geometry inspection are set as duplicates. Furthermore, it verifies whether the data type of the attribute value is consistent with the configuration table definition, determines whether the attribute and field types match, and checks for entities without assigned codes, i.e., checks for entities without codes. Furthermore, after the uncoded entity check is completed, verify the configuration mapping relationship between the entity code and the layer it belongs to, check whether the entity code layer corresponds, and at the same time perform entity linetype check to verify whether the linetype is consistent with the configuration file; Furthermore, after checking the entity linetype, a check is performed on the required attribute fields to confirm whether the required attribute fields have values. Furthermore, the geographic information data after checking the required attribute fields is summarized to obtain the checked geographic information data; Furthermore, referring to Figure 1 As shown, based on the inspected geographic information data, hierarchical feature extraction is performed on the inspected geographic information data using feature extraction methods. The hierarchical extracted features of the inspected geographic information data include the following steps: S41. Based on the inspected geographic information data, separate each layer in the inspected geographic information data to obtain the geographic information data of each layer. S42. After obtaining the geographic information data of each layer, the point, line and area features in the geographic information data of each layer are extracted by feature extraction method, and the extracted features are correlated to obtain the layered extracted features of the inspected geographic information data. S421. After obtaining the geographic information data of each layer, extract the geometric feature points from the geographic information data of each layer based on the precise coordinate attributes of the CAD vector data; set the feature point extraction rules according to the primitive type (point, line, polygon): For point layer primitives, their original coordinates are directly used as the basic feature points; For line layer primitives, extract the endpoints, inflection points (curvature change points), and intersections of the line segment with other primitives as feature points; For polygon primitives, extract the vertices of the outer polygon, the vertices of the inner hole, the intersections of the face boundary with other primitives as feature points; S422. After obtaining the geometric feature points in the geographic information data of each layer, extract line and surface features based on the original topological relationship of the CAD vector data. Line feature extraction: Directly read the primitives with continuous coordinate sequences in the line layer as the basic line features, and combine them with the line feature points extracted by S421 to filter out line elements that meet the preset length threshold and precision threshold (such as removing short and broken lines and duplicate lines). Face feature extraction: Based on the native closed polygon primitives in the face layer, face features are determined by the closure of their boundary lines and topological inclusion relationships (such as the inclusion relationship between the outer surface and the inner hole). The face feature points extracted by S421 are combined to verify the boundary integrity (such as checking vertex continuity and closure accuracy). S423. Summarize and extract point, line and polygon features from the geographic information data of each layer to obtain the layered extracted features of the inspected geographic information data. Furthermore, referring to Figure 1 As shown, the hierarchical extracted features of the inspected geographic information data are compared with the hierarchical extracted features of historical geographic information data. Simultaneously, attribute data of the inspected geographic information data is recorded using a reverse mapping method, and the recorded attribute data is then processed for database entry. The process includes the following steps: Set a feature comparison threshold, and calculate the feature comparison value between the hierarchical extracted features of the inspected geographic information data and the hierarchical extracted features of the historical geographic information data based on the set feature comparison threshold; The formula for calculating the feature contrast value is as follows: ; in, This indicates the hierarchical extraction features of the geographic information data after inspection. A Layered feature extraction from historical geographic information data B Feature contrast values; AThis indicates the hierarchical extraction features of the geographic information data after inspection. B This represents the hierarchical extraction features of historical geographic information data; Furthermore, based on the set feature comparison threshold, when the feature comparison value is greater than or equal to the set feature comparison threshold, the geographic information data after inspection and the corresponding historical geographic information data are set to be the same type of data; Furthermore, based on the GIS table mapping relationship defined in the configuration file, the spatial data table name in the target PostgreSQL database is identified; Furthermore, the checked geographic information data is matched against the table structure, and the data is written to the PostgreSQL database through the database connection protocol to complete the data insertion operation. In one specific embodiment, the integrated system for geographic information data production, quality inspection, and warehousing in a CAD environment is used to realize an integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment. The system includes: a data acquisition module, a data processing module, a data inspection module, a feature extraction module, a warehousing processing module, and a PostgreSQL database. The data acquisition module is used to collect geographic information data and drawing rule configuration files to establish geographic information drawing standards. The data processing module is used to perform mapping and association processing on the collected geographic information data; The data inspection module is used to inspect real-time produced geographic information data according to the established geographic information drawing standards. The feature extraction module is used to extract features from the inspected and processed geographic information data using feature extraction methods. The data entry processing module is used to record the attribute data of the inspected geographic information data and to process the recorded attribute data into the database. The PostgreSQL database is used to store geographic information data.
[0025] It should be noted that The above content is merely an example and illustration of the concept of the present invention. Those skilled in the art can make various modifications or additions to the specific embodiments described, or use similar methods to replace them, as long as they do not deviate from the concept of the invention or exceed the scope defined by the present invention, and all such modifications and additions should fall within the protection scope of the present invention.
Claims
1. An integrated system and method for geographic information data production, quality inspection, and warehousing in a CAD environment, characterized in that: Includes the following steps: S1. Collect historical geographic information data and drawing rule configuration files to establish geographic information drawing standards, and build a drawing sample library based on the established geographic information drawing standards; S2. Perform mapping and association processing on the historical geographic information data in the sample database to obtain the mapped and associated historical geographic information data. S3. Real-time production of geographic information data, and inspection of the real-time produced geographic information data based on the established geographic information drawing standards to obtain the inspected geographic information data. S4. Based on the inspected geographic information data, hierarchical feature extraction is performed on the inspected geographic information data using feature extraction methods to obtain the hierarchical extracted features of the inspected geographic information data. S5. Hierarchical feature extraction is performed on the historical geographic information data after mapping and association processing using feature extraction methods to obtain the hierarchical extracted features of the historical geographic information data. S6. Compare the hierarchical extraction features of the inspected geographic information data with the hierarchical extraction features of the historical geographic information data. At the same time, record the attribute data of the inspected geographic information data through reverse mapping and put the recorded attribute data into the database.
2. The integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment according to claim 1, characterized in that, The process of collecting historical geographic information data and mapping rule configuration files to establish geographic information mapping standards, and constructing a mapping sample library based on these standards, includes the following steps: Historical geographic information data includes: geographic information collection time, scale, geographic location information, and geographic information content; Geographic information content includes: the geographic information data's identifier, and the attribute data of the three elements: points, lines, and polygons; The drawing rule configuration file includes: the color, line type, CAD layer, and GIS table mapping relationship of the three elements of points, lines, and polygons; Any geographic information mapping standard must include historical geographic information data and mapping rule configuration files. A database of geographic information mapping standard data was compiled to construct a mapping sample library.
3. The integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment according to claim 1, characterized in that, The process of mapping and associating historical geographic information data in the sample database to obtain mapped and associated historical geographic information data includes the following steps: Based on the definition of point features in geographic information data in the rule mapping library, call the general interface for drawing point features; The point feature drawing general interface, based on the configuration file, parses the point features in the historical geographic information data into the block insertion positions, inserts the corresponding block entities in the specified CAD layer, and associates the attribute information of the layer in the configuration table. Based on the configuration rules of line features in the rule mapping library, the general interface for drawing line features is called. The interface draws line features using POLYLINE in CAD. Configure the line color and line type according to the settings, and place it in the corresponding CAD layer; According to the configuration requirements of the polygon features in the rule mapping library, call the general interface for drawing polygon features; The interface uses closed polylines in CAD to draw the boundaries of polygon features, and defines the fill style and layer of the polygon according to the configuration to complete the drawing of polygon features. The processing results of historical geographic information data by the rule mapping library are summarized to obtain historical geographic information data after mapping and association processing.
4. The integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment according to claim 1, characterized in that, The real-time generated geographic information data, and the real-time generated geographic information data are checked based on the established geographic information mapping standards to obtain the checked geographic information data, includes the following steps: S31. Perform spatial geometry checks on real-time production geographic information data to obtain geographic information data after spatial geometry checks. According to the preset checklist, perform spatial geometric checks on each element in the real-time production geographic information data: Based on a preset list, the point features in the real-time production geographic information data are traversed. During the traversal, a traversal area is selected, and the entity coordinates and attributes of each point feature are traversed within the selected traversal area. When there are duplicate entity coordinates and attributes of point features, the duplicate point features are deleted and filtered. After filtering out duplicate points, set a threshold for the number of line feature vertices and calculate the number of line feature vertices; Determine if the number of line points is too low based on the set threshold for the number of line element vertices; Set a threshold for the area of polygon features, calculate the area of polygon features based on the set threshold, compare it with the minimum threshold, and check whether it is an ultra-small polygon. A topology algorithm is used to detect whether polylines are self-intersecting. At the same time, based on the coordinates of the intersection points and the concept of the same attributes, the polylines are checked for repeated endpoints and closure. Calculate the length of line features to determine if they are ultra-short lines, and compare entity coordinates and attributes to check for duplicate blocks, lines, and text. Finally, scan layer 0 to check if there is any data. S32. Perform attribute information checks on the geographic information data after spatial geometry checks to obtain the checked geographic information data.
5. The integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment according to claim 4, characterized in that, The process of performing attribute information checks on the geographic information data after spatial geometric checks to obtain the checked geographic information data includes the following steps: Set a unique identifier (GUID) for the comparison elements, specifically the number of the geographic information data after spatial geometric inspection; Create a length of Select the array Each hash function calculates the unique identifier (GUID) of features in the geographic information data after spatial geometry inspection, and stores the calculation results in an array; in, Indicates the number of hash functions. Indicates the amount of geographic information data after spatial geometry inspection; During the process of calculating the unique identifier (GUID) of features in the geographic information data after spatial geometry inspection using the hash function, if the calculation results of the unique identifier (GUID) of features in two sets of geographic information data after spatial geometry inspection are consistent, the current two sets of geographic information data after spatial geometry inspection are set as duplicates. Verify whether the data type of the attribute value is consistent with the configuration table definition, determine whether the attribute and field types match, and check for the existence of entities without assigned codes, i.e., uncoded entity checks. After the uncoded entity check is completed, verify the mapping relationship between the entity code and the configuration of the layer it belongs to, check whether the entity code layer corresponds, and at the same time perform the entity linetype check to verify whether the linetype is consistent with the configuration file. After checking the entity linetype, check the required attribute fields to confirm whether the required attribute fields have values. The geographic information data after checking the required attribute fields is summarized to obtain the checked geographic information data.
6. The integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment according to claim 1, characterized in that, The process of extracting hierarchical features from the inspected geographic information data using a feature extraction method to obtain the hierarchical extracted features of the inspected geographic information data includes the following steps: S41. Based on the inspected geographic information data, separate each layer in the inspected geographic information data to obtain the geographic information data of each layer. S42. After obtaining the geographic information data of each layer, the point, line and area features in the geographic information data of each layer are extracted by feature extraction method, and the extracted features are correlated to obtain the layered extracted features of the inspected geographic information data.
7. The integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment as described in claim 6, characterized in that, After obtaining the geographic information data of each layer, the point, line, and polygon features in the geographic information data of each layer are extracted using feature extraction methods, and the extracted features are correlated to obtain the layered extracted features of the inspected geographic information data. The steps include: S421. After obtaining the geographic information data of each layer, extract the geometric feature points in the geographic information data of each layer based on the precise coordinate attributes of the CAD vector data. Define feature point extraction rules based on primitive type: For point layer primitives, their original coordinates are directly used as the basic feature points; For line layer primitives, extract the endpoints, inflection points, and intersections of the line segment with other primitives as feature points; For polygon primitives, extract the vertices of the outer polygon, the vertices of the inner hole, the intersections of the face boundary with other primitives as feature points; S422. After obtaining the geometric feature points in the geographic information data of each layer, extract line and surface features based on the original topological relationship of the CAD vector data. Line feature extraction: Directly read the primitives with continuous coordinate sequences in the line layer as the basic line features, and combine them with the line feature points extracted by S421 to filter out line elements that meet the preset length threshold and precision threshold. Surface feature extraction: Based on the native closed polygon primitives in the surface layer, surface features are determined by the closure of their boundary lines and topological inclusion relationships. The surface feature points extracted by S421 are used to verify the boundary integrity. S423. Summarize and extract point, line, and area features from the geographic information data of each layer to obtain the layered extracted features of the inspected geographic information data.
8. The integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment according to claim 1, characterized in that, The step of performing hierarchical feature extraction on the mapped and associated historical geographic information data using feature extraction methods to obtain the hierarchical extracted features of the historical geographic information data includes the following steps: Based on steps S41 and S42, hierarchical feature extraction is performed on the historical geographic information data after mapping and association processing to obtain the hierarchical extracted features of the historical geographic information data.
9. The integrated method for geographic information data production, quality inspection, and warehousing in a CAD environment according to claim 1, characterized in that, The process involves comparing the hierarchical extracted features of the inspected geographic information data with the hierarchical extracted features of the historical geographic information data, recording the attribute data of the inspected geographic information data through a reverse mapping method, and then storing the recorded attribute data into a database. Includes the following steps: Set a feature comparison threshold, and calculate the feature comparison value between the hierarchical extracted features of the inspected geographic information data and the hierarchical extracted features of the historical geographic information data based on the set feature comparison threshold; The formula for calculating the feature contrast value is as follows: ; in, This indicates the hierarchical extraction features of the geographic information data after inspection. A Layered feature extraction from historical geographic information data B Feature contrast values; A This indicates the hierarchical extraction features of the geographic information data after inspection. B This represents the hierarchical extraction features of historical geographic information data; Based on the set feature comparison threshold, when the feature comparison value is greater than or equal to the set feature comparison threshold, the geographic information data after inspection and the corresponding historical geographic information data are set to be the same type of data. Based on the GIS table mapping relationship defined in the configuration file, identify the name of the spatial data table in the target PostgreSQL database; After checking, the geographic information data is matched against the table structure, and the data is written to the PostgreSQL database through the database connection protocol to complete the data insertion operation.
10. The system for the integrated method of geographic information data production, quality inspection, and warehousing in a CAD environment according to claim 1, characterized in that, include: The system includes a data acquisition module, a data processing module, a data inspection module, a feature extraction module, a data entry module, and a PostgreSQL database. The data acquisition module is used to collect geographic information data and drawing rule configuration files to establish geographic information drawing standards. The data processing module is used to perform mapping and association processing on the collected geographic information data; The data inspection module is used to inspect real-time produced geographic information data according to the established geographic information drawing standards. The feature extraction module is used to extract features from the inspected and processed geographic information data using feature extraction methods. The data entry processing module is used to record the attribute data of the inspected geographic information data and to process the recorded attribute data into the database. The PostgreSQL database is used to store geographic information data.
Citation Information
Patent Citations
CAD-based geographic information drawing method and device, terminal and medium
CN112906091A