A GIS-based highway achievement digital delivery method and system

Abstract

The present invention discloses a method and system for digital delivery of highway achievements based on GIS, including the following steps: S1, obtaining a project list, changing the project delivery status and storing basic project information; S2, obtaining a general route map, establishing a road plane model and displaying it online; S3, processing the line position data of each pile, converting the coordinate table of each pile into a point-like shp file and performing projection conversion to generate geojson data; S4, delivering design drawings, field survey data and geological drilling data; S5, managing the project progress and maintaining the completion status of each stage; S6, displaying the distribution of system data in statistical charts. The system includes an engineering project management module, a data vectorization module, a data resource management module and a background management module to realize the digitalization and visual management of data, improve the efficiency of data management and sharing, and ensure the accuracy and integrity of data.

Description

Technical Field

[0001] The present invention relates to the technical field of digital delivery of engineering projects, and in particular to a method and system for digital delivery of highway achievements based on GIS. Background Art

[0002] With the continuous development of highway construction, the amount of data related to highway design, construction and maintenance is also increasing rapidly. These data include design drawings, documents, vector line positions and corresponding attribute information, progress data, etc. The data volume is huge and the format is complex. Traditional storage methods are mostly paper documents and electronic hard disk storage, which have the following main problems:

[0003] The first is that the number of files is huge and difficult to manage and maintain. Highway projects usually involve multiple stages and multiple departments, and each department has a large number of design drawings and documents. Traditional paper and electronic hard disk storage methods make it difficult to effectively manage and maintain these files, and files are prone to loss or damage.

[0004] The second is the inefficiency of data sharing. Since data is scattered across different departments and systems and lacks a unified management and sharing platform, data sharing efficiency is low. Data exchange between different departments often relies on manual operations, which is prone to data transmission errors and information lags.

[0005] The third is the inconsistency of data standards and the existence of data islands. The data formats and standards stored in various departments and systems are inconsistent, making it difficult to achieve unified management and application of data. The data island phenomenon is serious, affecting the integration and utilization of data.

[0006] Fourth, data visualization and linkage display are difficult. Various data in the process of highway design and construction need to be visualized so that designers and managers can intuitively understand and evaluate the project progress and design scheme. However, existing platforms and systems have difficulty in realizing the visualization and linkage display of complex data.

[0007] Therefore, how to provide a GIS-based highway digital delivery method and system is an urgent problem that technical personnel in this field need to solve. Summary of the invention

[0008] One purpose of the present invention is to propose a method and system for digital delivery of highway results based on GIS. The present invention integrates various types of data generated during highway design, construction and maintenance using a GIS platform, thereby achieving automatic delivery and unified display of design results. The entire process of project basic information management, vector processing of route master map, processing of pile-by-pile line position data, delivery of design drawings and survey data, project progress management, and data statistics and display is described in detail. Compared with traditional paper and decentralized electronic data management methods, the present invention can more effectively achieve digital and visual management of data, and has the advantages of high efficiency, accuracy, and convenient data sharing.

[0009] A GIS-based highway achievement digital delivery method according to an embodiment of the present invention includes the following steps:

[0010] S1. Based on the project name and the project stage information, the background obtains the project list, changes the project delivery status through the drop-down selection box, adds it to the delivery project list, and stores the basic project information;

[0011] S2. Obtain the overall route map of the project delivered in step S1, establish a road plane model, and call and display it online;

[0012] S3. The system's backend management module automatically processes the pile-by-pile line position data. It first obtains the pile-by-pile coordinate table uploaded by the user and the selected central meridian longitude. The program automatically converts the data in the pile-by-pile coordinate table that records the pile number and its corresponding plane coordinate XY into a point-shaped shp file containing a series of points. Then, it performs projection conversion according to the projection parameters corresponding to the central meridian longitude, and then converts the shp file into data;

[0013] S4. Deliver project data, including design drawings, site survey data and geological drilling data;

[0014] S5. Manage the project progress and the completion status of each stage of the post-pipeline maintenance and management delivery project from design to construction;

[0015] S6. Data statistics: Based on the data integrated by the system, statistical charts are used to intuitively display the distribution of field professional types, drilling status, the number of drawings in each chapter, the number of structures of each type, and the completion status of drawings in each month.

[0016] Optionally, the S2 specifically includes:

[0017] S21. Calling via Python Interface, automatically converts the route map dwg file uploaded by the user into a vector data shp file;

[0018] S22. Based on the layer name and geographical location, multiple polylines belonging to the same structure are subjected to spatial topological analysis, merged into one polyline feature, and its name and start and end pile numbers are automatically maintained in the attribute table;

[0019] S23, through improved Interface, automatically import the shp file generated in step S22 The database will automatically optimize spatial indexes during import:

[0020] ;

[0021] Among them, OI represents the optimization index, represents the area of ​​the i-th element, represents the weight of the i-th element, represents the bounding box area of ​​the i-th feature, represents the complexity of the i-th element;

[0022] S24, through The interface converts the overall route map of the delivery project from dwg format to shp format, while performing data cleaning and error correction;

[0023] S25. Based on the list of structures in the design process, use automated scripts to merge elements and edit attributes of road ancillary facilities;

[0024] S26, convert the processed shp data into a projection coordinate system, and select the optimal projection parameters through an adaptive algorithm, wherein the projection conversion is:

[0025] ;

[0026] Among them, x and y represent the original coordinates, and x' and y' represent the coordinates after projection transformation. and represents the coordinates of the projection center point, represents the projection rotation angle, and represents the projection scaling factor;

[0027] S27, store the processed shp data to Spatial database, and compress redundant data to reduce storage space;

[0028] S28, through Publishing the processed shp data in step S27 as a vector map service, and using cache technology to accelerate the response time of the map service;

[0029] S29, based on The published map service is called online to realize the web display and map interaction of the DWG route map, and support users' dynamic query and analysis of map data.

[0030] Optionally, the S3 specifically includes:

[0031] S31, the background automatically processes the pile-by-pile line position data, obtains the pile-by-pile coordinate table uploaded by the user and the selected central meridian longitude, wherein the pile-by-pile coordinate table is an Excel table that records the pile numbers of the entire road and the XY coordinates corresponding to the pile numbers, and converts the pile numbers recorded in the pile-by-pile coordinate table and their corresponding plane coordinates XY into longitude and latitude:

[0032] ;

[0033] in, Indicates the location of the i-th stake, with longitude and latitude being and , and represents the plane coordinates of the ith pile number, and represents the plane coordinates of the starting point, R is the radius of the earth;

[0034] S32, converting the pile-by-pile coordinate table into a point-shaped shp file containing a series of points, generation of the point-shaped shp file:

[0035] ;

[0036] in, Represents the point shp file of the i-th pile number, and represents the plane coordinates of the i-th pile number;

[0037] S33, according to the projection parameters corresponding to the central meridian longitude, the projection conversion is performed, and the shp file is converted into data:

[0038] ;

[0039] Among them, x and y represent the original plane coordinates, represents the projection angle, and represents the scaling factor;

[0040] S34, the converted Import data into the system.

[0041] Optionally, the S4 specifically includes:

[0042] S41. Delivery project design drawings. Obtain all PDF design drawings of the delivery project through the interface and display them in the directory tree structure of project name-phase-chapter-professional-drawing name;

[0043] S42, delivery site survey data, obtain the site survey data related to the delivery project through the interface, including form records and plotting elements, and integrate them into the road plane model. The longitude and latitude of the pile number position contained in the form record are calculated by the following:

[0044] ;

[0045] in, Indicates the location of the i-th stake, with longitude and latitude being and , and represents the increment of latitude and longitude, represents the i-th pile number, Indicates the starting pile number, and D indicates the total pile number distance;

[0046] S43. The geographical location data of the plotted elements including points, lines and surfaces are directly located in the road plane model through the latitude and longitude information contained therein, and converted into a coordinate system suitable for display through the following:

[0047] ;

[0048] Where R is the radius of the Earth, and is the latitude and longitude of the reference point, and is the latitude and longitude of the point, and is the scaling factor;

[0049] S44. Deliver geological drilling data. Obtain drilling data related to the delivery project through the interface, including drilling point spatial information and attribute information. Find the location in the road plane model through longitude and latitude, and integrate it into the road plane model. The longitude and latitude information in the drilling record is converted into plane coordinates through the following:

[0050] ;

[0051] Where R is the radius of the Earth, and is the latitude and longitude of the drilling location, and is the latitude and longitude of the reference point, and is the compression factor.

[0052] A GIS-based highway achievement digital delivery system according to an embodiment of the present invention includes an engineering project management module, a data vectorization module, a data resource management module, and a background management module;

[0053] The engineering project management module is used for unified management and maintenance of basic project information, project delivery status and project delivery content of digital delivery projects;

[0054] The data vectorization module is based on The platform vectorizes the route map of the digital delivery project and publishes online layer services;

[0055] The data resource management module is used to uniformly manage and visualize the design results of digital delivery projects;

[0056] The background management module is used for role management, user management and log management.

[0057] Optionally, the engineering project management module includes unified management and maintenance of basic project information, unified management and maintenance of project delivery status, and unified management and maintenance of project delivery content;

[0058] The unified management and maintenance of the basic project information includes: adding basic information such as project name, code, stage, type, country, province, city, project description, and creation time, which is displayed in the form of a list to support users to perform addition, deletion, modification, and query operations;

[0059] The unified management and maintenance of the project delivery status includes: selecting a project, changing the delivery status, adding it to the digital delivery project list, and supporting editing and maintenance of the delivery content;

[0060] The unified management and maintenance of the project delivery content includes: maintaining the delivery project details, selecting projection parameters and uploading the pile-by-pile coordinate table to convert XY coordinates into longitude and latitude, importing the route map dwg file, performing vector conversion and publishing map services, uploading the structure list template and matching the template to parse the road structure information, including type, name, start and end pile numbers, and maintaining the completion progress of the six stages of the project feasibility stage, project investor determination stage, preliminary design stage, construction drawing design stage, land approval stage and planned start time. The project delivery content includes basic project information, pile-by-pile line positions, route map, structure list, and project progress.

[0061] Optionally, the data vectorization module includes vector conversion, element merging, attribute maintenance, and storage of the route map. Database, publishing vector map services;

[0062] The vector conversion can automatically convert the route map dwg file uploaded by the user into Convert to vector file format shp file;

[0063] The element merging is realized in the linear shp file of the route master map, by merging a plurality of polylines constituting bridges, tunnels, interchanges, toll booths, and service areas according to the layer name to obtain a polyline element, and the merging is based on the same layer name of the polylines constituting the same structure;

[0064] The attribute maintenance is to maintain the name attribute and the start and end pile number attributes of the bridge, tunnel, interchange, toll station and service area after the elements are merged, that is, the name of a certain structure and the start and end pile numbers that identify its position on the road;

[0065] The storage Database, realize the shp file after merging features and maintaining attributes through Batch Import Database management;

[0066] The vector map service is published to achieve connect The database will be stored in The shp data in the database is published as a layer service.

[0067] Optionally, the data resource management module includes management and display of design drawings, field survey data, and geological drilling data;

[0068] The management and display of design drawings realizes the display of the latest drawings of the delivered projects, retrieves all project-related drawings in the database according to the project name, and displays the tree directory and corresponding PDF drawings in the order of project name-phase-chapter-professional-drawing name;

[0069] The field survey data can display the project site survey data, list all survey disciplines under the project, support viewing the survey form records and on-site photos under different disciplines, and support positioning on the map according to the pile number. At the same time, it can also view the field data within the starting and ending pile numbers of road ancillary facilities such as bridges, tunnels, toll stations, service areas and interchanges;

[0070] The geological drilling data realizes the display of the project geological exploration data, and lists all the drilling hole numbers, as well as the corresponding drilling information, hole opening records, return scale records, water level records, geotechnical descriptions, sampling records, core photos, and whole-hole cores under the boreholes, which can be located on the map according to the drilling position.

[0071] Optionally, the background management module includes user management and background management of digital delivery projects;

[0072] The user management is to configure the user's access rights to the system, manage the account information of all employees of the company, configure the system role for the user account, and determine its operation rights to the system;

[0073] The background management of the digital delivery project realizes the editing and maintenance of the project delivery content, including editing and maintaining information of five modules: basic project information, pile-by-pile line position information, route map information, structure list information and project progress information.

[0074] The beneficial effects of the present invention are:

[0075] (1) Efficient data management and sharing: The present invention integrates the data of the entire life cycle of highway design, construction and maintenance through the GIS platform, solving the problems of data silos and low sharing efficiency in traditional data management methods. The engineering project management module uniformly manages the basic information, delivery status and delivery content of the project, and the data resource management module realizes the unified management and display of design drawings, survey data and geological drilling data, which significantly improves the efficiency and accuracy of data management and sharing.

[0076] (2) Data digitization and visualization: The data vectorization module converts the overall route map from dwg format to shp format, and realizes data vectorization processing and online display through spatial topology analysis and attribute maintenance. The line position data of each pile is automatically generated by processing Data, design drawings, field survey data and geological drilling data are acquired through interfaces and integrated into the road plane model. Compared with the traditional paper and decentralized electronic data management methods, the present invention realizes the comprehensive digitization and visualization of data, which makes it easier for designers and managers to intuitively understand and evaluate the project progress and design solutions.

[0077] (3) Accurate data processing and optimization: The present invention adopts improved Interface to automatically import vector data The database is imported and spatial indexes are optimized during import to ensure efficient data query. The line position data of each pile is converted into longitude and latitude and projection coordinates through innovative formulas to ensure the accuracy and consistency of data conversion. The project progress management module maintains the completion status of each stage from design to construction, and the data statistics module intuitively displays the distribution of system data with statistical charts, providing comprehensive data analysis and decision support.

[0078] (4) System integration and automation: The present invention realizes comprehensive system integration and automated processing through the collaborative work of the engineering project management module, data vectorization module, data resource management module and background management module. The automated script is used for element merging and attribute editing of road ancillary facilities, and the adaptive algorithm selects the optimal projection parameters to realize automatic data processing and optimization. The background management module is responsible for user management and editing and maintenance of project delivery content to ensure efficient operation of the system and accuracy of data.

[0079] (5) Efficient data compression and map services: Reduce storage space usage through data compression technology, publish vector map services and use caching technology to accelerate the response time of map services, ensuring the efficiency of large-scale data processing and display. Call the map service online to realize the web display and map interaction of the DWG route map, and support users' dynamic query and analysis of map data. BRIEF DESCRIPTION OF THE DRAWINGS

[0080] The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings:

[0081] Figure 1 A flowchart of a GIS-based highway achievement digital delivery method proposed by the present invention;

[0082] Figure 2 This is a GIS-based highway achievement digital delivery system architecture diagram proposed by the present invention; DETAILED DESCRIPTION

[0083] The present invention will now be described in further detail with reference to the accompanying drawings. These drawings are simplified schematic diagrams, which only illustrate the basic structure of the present invention in a schematic manner, and therefore only show the components related to the present invention.

[0084] refer to Figure 1 , a GIS-based highway achievement digital delivery method, including the following steps:

[0085] S1. Based on the project name and the project stage information, the background obtains the project list, changes the project delivery status through the drop-down selection box, adds it to the delivery project list, and stores the basic project information;

[0086] S2. Obtain the overall route map of the project delivered in step S1, establish a road plane model, and call and display it online;

[0087] S3. The system's backend management module automatically processes the pile-by-pile line position data. It first obtains the pile-by-pile coordinate table uploaded by the user and the selected central meridian longitude. The program automatically converts the data in the pile-by-pile coordinate table that records the pile number and its corresponding plane coordinate XY into a point-shaped shp file containing a series of points. Then, it performs projection conversion according to the projection parameters corresponding to the central meridian longitude, and then converts the shp file into data;

[0088] S4. Deliver project data, including design drawings, site survey data and geological drilling data;

[0089] S5. Manage the project progress and the completion status of each stage of the post-pipeline maintenance and management delivery project from design to construction;

[0090] S6. Data statistics: Based on the data integrated by the system, statistical charts are used to intuitively display the distribution of field professional types, drilling status, number of drawings in each chapter, number of structures of each type, and completion status of drawings in each month.

[0091] In this embodiment, S2 specifically includes:

[0092] S21. Calling via Python Interface, automatically converts the route map dwg file uploaded by the user into a vector data shp file;

[0093] S22. Based on the layer name and geographical location, multiple polylines belonging to the same structure are subjected to spatial topological analysis, merged into one polyline feature, and its name and start and end pile numbers are automatically maintained in the attribute table;

[0094] S23, through improved Interface, automatically import the shp file generated in step S22 The database will automatically optimize spatial indexes during import:

[0095] ;

[0096] Among them, OI represents the optimization index, represents the area of ​​the i-th element, represents the weight of the i-th element, represents the bounding box area of ​​the i-th feature, represents the complexity of the i-th element;

[0097] S24, through The interface converts the overall route map of the delivery project from dwg format to shp format, while performing data cleaning and error correction;

[0098] S25. Based on the list of structures in the design process, use automated scripts to merge elements and edit attributes of road ancillary facilities;

[0099] S26, convert the processed shp data into a projection coordinate system, and select the optimal projection parameters through an adaptive algorithm, wherein the projection conversion is:

[0100] ;

[0101] Among them, x and y represent the original coordinates, and x' and y' represent the coordinates after projection transformation. and represents the coordinates of the projection center point, represents the projection rotation angle, and represents the projection scaling factor;

[0102] S27, store the processed shp data to Spatial database, and compress redundant data to reduce storage space;

[0103] S28, through Publishing the processed shp data in step S27 as a vector map service, and using cache technology to accelerate the response time of the map service;

[0104] S29, based on The published map service is called online to realize the web display and map interaction of the DWG route map, and support users' dynamic query and analysis of map data.

[0105] In this implementation, S3 specifically includes:

[0106] S31, the background automatically processes the pile-by-pile line position data, obtains the pile-by-pile coordinate table uploaded by the user and the selected central meridian longitude, wherein the pile-by-pile coordinate table is an Excel table that records the pile numbers of the entire road and the XY coordinates corresponding to the pile numbers, and converts the pile numbers recorded in the pile-by-pile coordinate table and their corresponding plane coordinates XY into longitude and latitude:

[0107] ;

[0108] in, Indicates the location of the i-th stake, with longitude and latitude being and , and represents the plane coordinates of the ith pile number, and represents the plane coordinates of the starting point, R is the radius of the earth;

[0109] S32, converting the pile-by-pile coordinate table into a point-shaped shp file containing a series of points, generation of the point-shaped shp file:

[0110] ;

[0111] in, Represents the point shp file of the i-th pile number, and represents the plane coordinates of the i-th pile number;

[0112] S33, according to the projection parameters corresponding to the central meridian longitude, the projection conversion is performed, and the shp file is converted into data:

[0113] ;

[0114] Among them, x and y represent the original plane coordinates, represents the projection angle, and represents the scaling factor;

[0115] S34, the converted Import data into the system.

[0116] In this implementation, S4 specifically includes:

[0117] S41. Delivery project design drawings. Obtain all PDF design drawings of the delivery project through the interface and display them in the directory tree structure of project name-phase-chapter-professional-drawing name;

[0118] S42, delivery site survey data, obtain the site survey data related to the delivery project through the interface, including form records and plotting elements, and integrate them into the road plane model. The longitude and latitude of the pile number position contained in the form record are calculated by the following:

[0119] ;

[0120] in, Indicates the location of the i-th stake, with longitude and latitude being and , and represents the increment of latitude and longitude, represents the i-th pile number, Indicates the starting pile number, and D indicates the total pile number distance;

[0121] S43. The geographical location data of the plotted elements including points, lines and surfaces are directly located in the road plane model through the latitude and longitude information contained therein, and converted into a coordinate system suitable for display through the following:

[0122] ;

[0123] Where R is the radius of the Earth, and is the latitude and longitude of the reference point, and is the latitude and longitude of the point, and is the scaling factor;

[0124] S44. Deliver geological drilling data. Obtain drilling data related to the delivery project through the interface, including drilling point spatial information and attribute information. Find the location in the road plane model through longitude and latitude, and integrate it into the road plane model. The longitude and latitude information in the drilling record is converted into plane coordinates through the following:

[0125] ;

[0126] Where R is the radius of the Earth, and is the latitude and longitude of the drilling location, and is the latitude and longitude of the reference point, and is the compression factor.

[0127] A GIS-based highway achievement digital delivery system according to an embodiment of the present invention includes an engineering project management module, a data vectorization module, a data resource management module, and a background management module;

[0128] The engineering project management module is used for unified management and maintenance of basic project information, project delivery status and project delivery content of digital delivery projects;

[0129] The data vectorization module performs vectorization processing on the route map of the digital delivery project based on the GIS platform and publishes online layer services;

[0130] The data resource management module is used to uniformly manage and visualize the design results of digital delivery projects;

[0131] The background management module is used for role management, user management and log management.

[0132] In this embodiment, the engineering project management module includes unified management and maintenance of basic project information, unified management and maintenance of project delivery status, and unified management and maintenance of project delivery content;

[0133] The unified management and maintenance of the basic project information includes: adding basic information such as project name, code, stage, type, country, province, city, project description, and creation time, which is displayed in the form of a list to support users to perform addition, deletion, modification, and query operations;

[0134] The unified management and maintenance of the project delivery status includes: selecting a project, changing the delivery status, adding it to the digital delivery project list, and supporting editing and maintenance of the delivery content;

[0135] The unified management and maintenance of the project delivery content includes: maintaining the delivery project details, selecting projection parameters and uploading the pile-by-pile coordinate table to convert XY coordinates into longitude and latitude, importing the route map dwg file, performing vector conversion and publishing map services, uploading the structure list template and matching the template to parse the road structure information, including type, name, start and end pile numbers, and maintaining the completion progress of the six stages of the project feasibility stage, project investor determination stage, preliminary design stage, construction drawing design stage, land approval stage and planned start time. The project delivery content includes basic project information, pile-by-pile line positions, route map, structure list, and project progress.

[0136] In this embodiment, the data vectorization module includes vector conversion, element merging, attribute maintenance, storage, etc. Database, publishing vector map services;

[0137] The vector conversion can automatically convert the route map dwg file uploaded by the user into Convert to vector file format shp file;

[0138] The element merging is realized in the linear shp file of the route master map, by merging a plurality of polylines constituting bridges, tunnels, interchanges, toll booths, and service areas according to the layer name to obtain a polyline element, and the merging is based on the same layer name of the polylines constituting the same structure;

[0139] The attribute maintenance is to maintain the name attribute and the start and end pile number attributes of the bridge, tunnel, interchange, toll station and service area after the elements are merged, that is, the name of a certain structure and the start and end pile numbers that identify its position on the road;

[0140] The storage Database, realize the shp file after merging features and maintaining attributes through Batch Import Database management;

[0141] The vector map service is published to achieve connect The database will be stored in The shp data in the database is published as a layer service.

[0142] In this embodiment, the data resource management module includes management and display of design drawings, field survey data, and geological drilling data;

[0143] The management and display of design drawings realizes the display of the latest drawings of the delivered projects, retrieves all project-related drawings in the database according to the project name, and displays the tree directory and corresponding PDF drawings in the order of project name-phase-chapter-professional-drawing name;

[0144] The field survey data can display the project site survey data, list all survey disciplines under the project, support viewing the survey form records and on-site photos under different disciplines, and support positioning on the map according to the pile number. At the same time, it can also view the field data within the starting and ending pile numbers of road ancillary facilities such as bridges, tunnels, toll stations, service areas and interchanges;

[0145] The geological drilling data realizes the display of the project geological exploration data, and lists all the drilling hole numbers, as well as the corresponding drilling information, hole opening records, return scale records, water level records, geotechnical descriptions, sampling records, core photos, and whole-hole cores under the boreholes, which can be located on the map according to the drilling position.

[0146] In this implementation, the backend management module includes user management and backend management of digital delivery projects;

[0147] The user management is to configure the user's access rights to the system, manage the account information of all employees of the company, configure the system role for the user account, and determine its operation rights to the system;

[0148] The background management of the digital delivery project realizes the editing and maintenance of the project delivery content, including editing and maintaining information of five modules: basic project information, pile-by-pile line position information, route map information, structure list information and project progress information.

[0149] Embodiment 1:

[0150] The GIS-based highway digital delivery system of the present invention was deployed in Company B, a company specializing in highway construction and maintenance in Anhui Province, China. Company B is responsible for the design, construction and maintenance of multiple highway projects, and needs to manage and deliver a large amount of design drawings, survey data and construction progress information every year. In order to improve the efficiency of data management and sharing, Company B introduced the system of the present invention and conducted a 6-month test and application.

[0151] The projects that Company B is responsible for include the design and construction management of the He'an Expressway and the He'wu Expressway. The number of drawings and documents involved in the projects is huge, and the traditional paper and decentralized electronic data management methods are difficult to meet the needs of efficient management and sharing. In order to meet these challenges, Company B decided to adopt the GIS-based highway achievement digital delivery system of the present invention.

[0152] During the project implementation, Company B first entered the basic information of the project through the engineering project management module, and used the drop-down selection box to change the project delivery status to ensure timely update and accurate storage of project data. Then, through the data vectorization module, the overall route map of the project was converted from dwg format to vector data shp file, and spatial topology analysis and attribute maintenance were performed.

[0153] The processing of pile-by-pile line position data is a key link in the application of the system. The system automatically processes the pile-by-pile line position data, converts the pile number and its corresponding plane coordinate XY in the pile-by-pile coordinate table into a point-like shp file containing a series of points, and performs projection conversion to generate geojson data. This data is integrated into the road plane model to facilitate subsequent pile number positioning and position calculation by designers and managers.

[0154] During the project delivery phase, the system acquires and displays design drawings, field survey data, and geological drilling data through interfaces. Design drawings are displayed in a directory tree structure of project name-phase-chapter-professional-drawing name, and survey data and drilling data are located in the road plane model through the latitude and longitude information they contain, providing comprehensive data display and interactive operations.

[0155] The project progress management module maintains the completion status of each stage from design to construction, ensuring real-time tracking and management of project progress. The data statistics module displays the system integrated data in the form of statistical charts, including the type of field profession, drilling status, the number of drawings in each chapter, the number of structures of each type, and the distribution of the completion status of drawings in each month.

[0156] During the 6-month testing and application process, Company B applied the system of the present invention in the He'an Expressway and He'wu Expressway projects.

[0157] Table 1 Project data comparison table

[0158]

[0159] As shown in Table 1 above, the system of the present invention significantly improves the efficiency of data processing and sharing, reduces the error rate, and improves the accuracy and integrity of data. In the He'an Expressway project, the number of drawings processed per month increased by 67%, the drawing processing time decreased by 60%, the data sharing time decreased by 90%, and the data error rate decreased by 80%. In the Hewu Expressway project, the number of drawings processed per month increased by 100%, the drawing processing time decreased by 60%, the data sharing time decreased by 94%, and the data error rate decreased by 80%.

[0160] The present invention significantly improves the efficiency and accuracy of highway project data management by utilizing the GIS platform and automated data processing technology. Compared with traditional paper and decentralized electronic data management methods, the GIS-based system can more effectively process and display complex data, thereby improving the efficiency of data sharing and project management. The present invention significantly reduces the reliance on manual operations through automated data processing procedures, and improves the speed and accuracy of data processing. The automated process not only speeds up data processing, but also eliminates subjective judgment differences in manual processing, ensuring the consistency of data processing results.

[0161] In summary, the GIS-based highway digital delivery system of the present invention not only improves the efficiency of data management and sharing, but also provides comprehensive data display and analysis functions, significantly improving the management level of highway projects. Through this system, Company B not only improves project management efficiency, but also reduces the error rate and workload of manual operations, laying the foundation for future intelligent management and data analysis.

[0162] The above description is only a preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can make equivalent replacements or changes according to the technical scheme and inventive concept of the present invention within the technical scope disclosed by the present invention, which should be covered by the protection scope of the present invention.

Claims

1. A GIS-based highway achievement digital delivery method, characterized in that: The steps include: S1. Based on the project name and the project stage information, the background obtains the project list, changes the project delivery status through the drop-down selection box, adds it to the delivery project list, and stores the basic project information; S2. Obtain the overall route map of the project delivered in step S1, establish a road plane model, and call and display it online; S3. The system's backend management module automatically processes the pile-by-pile line position data. It first obtains the pile-by-pile coordinate table uploaded by the user and the selected central meridian longitude. The program automatically converts the data in the pile-by-pile coordinate table that records the pile number and its corresponding plane coordinate XY into a point-shaped shp file containing a series of points. Then, it performs projection conversion according to the projection parameters corresponding to the central meridian longitude, and then converts the shp file into data; S4. Deliver project data, including design drawings, site survey data and geological drilling data; S5. Manage the project progress and the completion status of each stage of the post-pipeline maintenance and management delivery project from design to construction; S6. Data statistics: Based on the data integrated by the system, the distribution of field professional types, drilling status, number of drawings in each chapter, number of structures of each type, and completion status of drawings in each month are intuitively displayed in the form of statistical charts; The S2 specifically includes: S21. Calling via Python Interface, automatically converts the route map dwg file uploaded by the user into a vector data shp file; S22. Based on the layer name and geographical location, multiple polylines belonging to the same structure are subjected to spatial topological analysis, merged into one polyline feature, and its name and start and end pile numbers are automatically maintained in the attribute table; S23, through improved Interface, automatically import the shp file generated in step S22 The database will automatically optimize spatial indexes during import: ； Among them, OI represents the optimization index, represents the area of ​​the ith element, represents the weight of the i-th element, represents the bounding box area of ​​the i-th feature, represents the complexity of the i-th element; S24, through The interface converts the overall route map of the delivery project from dwg format to shp format, while performing data cleaning and error correction; S25. Based on the list of structures in the design process, use automated scripts to merge elements and edit attributes of road ancillary facilities; S26, convert the processed shp data into a projection coordinate system, and select the optimal projection parameters through an adaptive algorithm, wherein the projection conversion is: ； Among them, x and y represent the original coordinates, and x' and y' represent the coordinates after projection transformation. and represents the coordinates of the projection center point, represents the projection rotation angle, and represents the projection scaling factor; S27, store the processed shp data to Spatial database, and compress redundant data to reduce storage space; S28, through Publishing the processed shp data in step S27 as a vector map service, and using cache technology to accelerate the response time of the map service; S29, based on The published map service is called online to realize the web display and map interaction of the DWG route map, and support users' dynamic query and analysis of map data.

2. According to the GIS-based highway achievement digital delivery method of claim 1, it is characterized in that: The S3 specifically includes: S31, the background automatically processes the pile-by-pile line position data, obtains the pile-by-pile coordinate table uploaded by the user and the selected central meridian longitude, wherein the pile-by-pile coordinate table is an Excel table that records the pile numbers of the entire road and the XY coordinates corresponding to the pile numbers, and converts the pile numbers recorded in the pile-by-pile coordinate table and their corresponding plane coordinates XY into longitude and latitude: ； in, Indicates the location of the i-th stake, with longitude and latitude being and , and represents the plane coordinates of the ith pile number, and represents the plane coordinates of the starting point, R is the radius of the earth; S32, converting the pile-by-pile coordinate table into a point-shaped shp file containing a series of points, generation of the point-shaped shp file: ； in, Represents the point shp file of the i-th pile number, and represents the plane coordinates of the ith pile number; S33. Perform projection conversion according to the projection parameters corresponding to the central meridian longitude, and convert the shp file into data: ； Where x and y represent the original plane coordinates, represents the projection angle, and represents the scaling factor; S34, the converted Import data into the system.

3. According to the GIS-based highway achievement digital delivery method of claim 1, it is characterized in that: The S4 specifically includes: S41. Delivery project design drawings. Obtain all PDF design drawings of the delivery project through the interface and display them in the directory tree structure of project name-phase-chapter-professional-drawing name; S42, delivery site survey data, obtain the site survey data related to the delivery project through the interface, including form records and plotting elements, and integrate them into the road plane model. The longitude and latitude of the pile number position contained in the form record are calculated by the following: ； in, Indicates the location of the i-th stake, with longitude and latitude being and , and represents the increment of latitude and longitude, represents the i-th pile number, Indicates the starting pile number, and D indicates the total pile number distance; S43. The geographical location data of the plotted elements including points, lines and surfaces are directly located in the road plane model through the latitude and longitude information contained therein, and converted into a coordinate system suitable for display through the following: ； Where R is the radius of the Earth, and is the latitude and longitude of the reference point, and is the latitude and longitude of the point, and is the scaling factor; S44. Deliver geological drilling data. Obtain drilling data related to the delivery project through the interface, including drilling point spatial information and attribute information. Find the location in the road plane model through longitude and latitude, and integrate it into the road plane model. The longitude and latitude information in the drilling record is converted into plane coordinates through the following: ； Where R is the radius of the Earth, and is the latitude and longitude of the drilling location, and is the latitude and longitude of the reference point, and is the compression factor.

4. A GIS-based highway achievement digital delivery system, which executes the highway achievement digital delivery method according to any one of claims 1 to 3, characterized in that: Including engineering project management module, data vectorization module, data resource management module, and background management module; The engineering project management module is used for unified management and maintenance of basic project information, project delivery status and project delivery content of digital delivery projects; The data vectorization module performs vectorization processing on the route map of the digital delivery project based on the GIS platform and publishes online layer services; The data resource management module is used to uniformly manage and visualize the design results of digital delivery projects; The background management module is used for role management, user management and log management.

5. According to claim 4, a GIS-based highway achievement digital delivery system is characterized in that: The engineering project management module includes unified management and maintenance of basic project information, unified management and maintenance of project delivery status, and unified management and maintenance of project delivery content; The unified management and maintenance of the basic project information includes: adding basic information such as project name, code, stage, type, country, province, city, project description, and creation time, which is displayed in the form of a list to support users to perform addition, deletion, modification, and query operations; The unified management and maintenance of the project delivery status includes: selecting a project, changing the delivery status, adding it to the digital delivery project list, and supporting editing and maintenance of the delivery content; The unified management and maintenance of the project delivery content includes: maintaining the delivery project details, selecting projection parameters and uploading the pile-by-pile coordinate table to convert XY coordinates into longitude and latitude, importing the route map dwg file, performing vector conversion and publishing map services, uploading the structure list template and matching the template to parse the road structure information, including type, name, start and end pile numbers, and maintaining the completion progress of the six stages of the project feasibility stage, project investor determination stage, preliminary design stage, construction drawing design stage, land approval stage and planned start time. The project delivery content includes basic project information, pile-by-pile line positions, route map, structure list, and project progress.

6. The GIS-based highway achievement digital delivery system according to claim 4 is characterized in that: The data vectorization module includes vector conversion, element merging, attribute maintenance, storage of the route map Database, publishing vector map services; The vector conversion can automatically convert the route map dwg file uploaded by the user into Convert to vector file format shp file; The element merging is realized in the linear shp file of the route master map, by merging a plurality of polylines constituting bridges, tunnels, interchanges, toll booths, and service areas according to the layer name to obtain a polyline element, and the merging is based on the same layer name of the polylines constituting the same structure; The attribute maintenance is to maintain the name attribute and the start and end pile number attributes of the bridge, tunnel, interchange, toll station and service area after the elements are merged, that is, the name of a certain structure and the start and end pile numbers that identify its position on the road; The storage Database, realize the shp file after merging features and maintaining attributes through Batch Import Database management; The vector map service is published to achieve connect The database will be stored in The shp data in the database is published as a layer service.

7. The GIS-based highway achievement digital delivery system according to claim 4 is characterized in that: The data resource management module includes management and display of design drawings, field survey data, and geological drilling data; The management and display of design drawings realizes the display of the latest drawings of the delivered projects, retrieves all project-related drawings in the database according to the project name, and displays the tree directory and corresponding PDF drawings in the order of project name-phase-chapter-professional-drawing name; The field survey data can display the project site survey data, list all survey disciplines under the project, support viewing the survey form records and on-site photos under different disciplines, and support positioning on the map according to the pile number. At the same time, it can also view the field data within the starting and ending pile numbers of road ancillary facilities such as bridges, tunnels, toll stations, service areas and interchanges; The geological drilling data realizes the display of the project geological exploration data, and lists all the drilling hole numbers, as well as the corresponding drilling information, hole opening records, return scale records, water level records, geotechnical descriptions, sampling records, core photos, and whole-hole cores under the boreholes, which can be located on the map according to the drilling position.

8. The GIS-based highway achievement digital delivery system according to claim 4 is characterized in that: The backend management module includes user management and backend management of digital delivery projects; The user management is to configure the user's access rights to the system, manage the account information of all employees of the company, configure the system role for the user account, and determine its operation rights to the system; The background management of the digital delivery project realizes the editing and maintenance of the project delivery content, including editing and maintaining information of five modules: basic project information, pile-by-pile line position information, route map information, structure list information and project progress information.

Images