WebGIS on-line drainage pipeline graph collection and editing real-time repair and measurement method

Abstract

The invention discloses a webGIS (web geographic information system) online drainage pipeline diagram, belongs to a real-time collecting and editing repair testing method, and relates to the technical field of geographic information systems, comprising the following steps: S1, receiving pipe network problem report information based on a work order management module, generating a task to be repaired and tested, and associating the task to a target drainage facility object; s2, spatial data, including TMS service, WMTS service and dynamic drawing service, of the target drainage facility is loaded through the webGIS platform, and the dynamic drawing service is used for plotting newly-added or modified pipe points, pipelines and facility object graphs in real time. According to the online drainage pipeline graph collection and editing real-time repairing and measuring method, rapid response and efficient processing of drainage pipeline problems are achieved, the method is suitable for drainage pipeline management and maintenance units in the whole industry, precise management and control of spatial attributes of refined management and maintenance objects are achieved while traditional general survey data values are reserved, and the method is suitable for large-scale popularization and application. The management and maintenance cost is effectively reduced; the operation efficiency is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of geographic information systems, and more particularly to a method for real-time repair survey of webGIS online drainage pipeline map attributes collection and editing. Background Art

[0002] In the field of drainage pipe network management, with the continuous advancement of urbanization, the scale of drainage pipe networks is constantly expanding and the structure is becoming increasingly complex. The maintenance work of drainage pipe networks is becoming increasingly important for the normal operation of cities and the quality of life of residents. WebGIS technology, with its geographical information processing and visualization capabilities, provides important support for drainage pipe network management. Through this technology, managers can view the spatial distribution of pipelines online, achieve facility positioning, attribute collection and editing, and basic repair survey operations, significantly improving the visualization management efficiency and decision-making support capabilities of pipe network data, and providing technical guarantee for dynamic supervision.

[0003] However, the existing webGIS-based drainage pipe network management technology still faces many challenges: First, limited by the traditional manual census and offline update mode, the update cycle of pipe network data is long and the accuracy rate has room for improvement, making it difficult to meet the needs of the dynamic development of urban construction; Second, in the real-time repair survey process, a full-process closed-loop management mechanism from problem reporting to data update has not been formed, resulting in the need to improve the connection efficiency of task distribution, field data collection and data quality inspection; In addition, the information management system of pipe network facilities still needs to be improved, lacking a standardized data model covering the entire life cycle, making the data association and maintenance of facility objects and their supporting pipe point and pipeline units have a certain degree of complexity. Particularly importantly, there is still room for exploration in data integration and health assessment in the existing system, and a health diagnosis and risk prediction mechanism to support refined management has not been established. In response to this, we propose a method for real-time repair survey of webGIS online drainage pipeline map attributes collection and editing. Summary of the Invention

[0004] To solve the above technical problems, a method for real-time repair survey of webGIS online drainage pipeline map attributes collection and editing is provided, and the technical solution solves the above problems.

[0005] To achieve the above objectives, the technical solution adopted by the present invention is as follows: A method for real-time repair survey of webGIS online drainage pipeline map attributes collection and editing, comprising the following steps: S1. Receive the reported information of pipe network problems based on the work order management module, generate a repair survey task to be performed and associate it with the target drainage facility object; S2. Load the spatial data of the target drainage facility through the webGIS platform, including TMS service, WMTS service and dynamic drawing service, wherein the dynamic drawing service is used to real-time plot the graphics of newly added or modified pipe points, pipelines and facility objects; S3. Adopt a dual - coding system to manage facility objects and facility units. The dual - coding system includes a census code and a management code. The census code consists of "facility type identifier + street code + serial number", and the management code is generated by "facility object number + pipe network category + incremental serial number". The pipe network categories include rainwater, sewage, and combined sewerage; S4. Perform patching and surveying operations on the graphic maintenance interface; S5. Real - time synchronously update the database, including the facility main table, the facility unit table, and the association relationship table, and trigger the full - database slicing of the TMS service to update the map display; S6. Review and report problems through the problem bookmark module, complete the modification approval of the attributes of facility objects or facility units, and the approval status includes adopted or not adopted.

[0006] Preferably, the graphic saving logic of the dynamic drawing service in step S2 includes: The drawn polyline is converted into a WMS service and stored in the facility line table x_ssline, and at the same time, the geometric data is written into the gemetry field of the data_prject table; The real - time drawn graphics are overlaid on the TMS base map, and the TMS slicing is triggered through a scheduled task to update the map service.

[0007] Preferably, the data association method of the dual - coding system in step S3 is: The table configuration of the special view point table for rainwater wells is synchronously updated in real - time with the dd table field configuration. After modifying the dd table configuration, all associated views are automatically updated; The mandatory items, display and hide rules of view objects are strictly consistent with the source table configuration.

[0008] Preferably, performing the patching and surveying operation on the graphic maintenance interface in step S4 includes: Pick up existing pipe points, pipelines, or associated facilities by point - selection or box - selection, and associate them with the current facility object; Dynamically draw new pipe points or pipelines, and automatically assign colors and flow direction identifiers according to the pipe network category. Rainwater is blue, sewage is coffee - colored, and combined sewerage is pink; Execute the pipeline reverse operation, including modifying the flow direction identifier, swapping the start and end point orders, and recalculating the pipeline slope; Use the attribute brush function to batch - copy the attributes of pipe points or pipelines, including checking the target fields after selecting the source attributes and box - selecting the target objects for attribute overwriting.

[0009] Preferably, the specific rules for picking up associated facilities are: The associated facility types include area drainage, drainage households, and river outfalls, and their WMS service element IDs are obtained through spatial query; When establishing an association relationship, insert a record into the ss_ssyssgl table, including the associated facility type, number, and the associated facility type and number; When unbinding the association, delete the corresponding record and move the associated facilities to the "Other_Street_Facility Type" task.

[0010] Preferably, when dynamically drawing new pipe points, the following operations need to be performed: Dynamically control the input fields according to the manhole cover shape: if it is rectangular, both manhole cover size 1 and size 2 are required; if it is circular, only size 1 is required; Automatically calculate the pipe point coordinates and write them into the spatial database, and synchronously generate the facility unit code and identification code; The point view table is dynamically composed of the basic attribute fields, special attribute fields of the dd table, and the extended fields of the e table, and the special attribute form is dynamically loaded according to the component type; Among them, the generation and configuration of attribute fields meet the following rules: a. All attribute fields are generated through dynamic configuration, and hard-coded fixed fields are prohibited; b. The line table and the line view table share the same field configuration. After modifying the line table configuration, it is automatically synchronized to the line view table; c. The point view table is generated by combining the basic attributes, special attributes of the dd table, and the corresponding e table; d. The table configuration of the special view point table of the rain well is automatically synchronized with the field configuration of the dd table to ensure the consistency between the view and the source table.

[0011] Preferably, the implementation method of the reverse operation of the pipeline is as follows: Modify the direction of the pipeline flow arrow and exchange the order of the start point and the end point in the pipeline code; Recalculate the pipeline slope, take the opposite value of the slope value and update it to the pipeline attribute table; The reversed pipeline graph is highlighted on the map, and the modification log is recorded in the operation history table.

[0012] Preferably, the specific implementation of the attribute brush function includes: Extract the non-coded attribute fields of the source object through dynamic configuration to generate a checkable attribute list; The field content of the attribute list is dynamically generated based on the table configuration, and hard-coded preset fields are prohibited; When covering attributes, verify that the required items are not empty. If the verification fails, terminate the operation and prompt an error.

[0013] Preferably, the logic of database synchronization and update in the S5 step includes: After modifying the line table configuration, it is automatically synchronized to the line view table to ensure the consistency of the field definitions of both; When adding or modifying line table records, the field display rules and sorting of the line table are updated synchronously; When a facility object is deleted, its associated facility units are automatically migrated to the "Other_Belonging Street_Pipeline Network Category" task to retain historical data.

[0014] Preferably, the approval process of the question bookmark module in step S6 includes: Unresolved question bookmarks are marked with a blue unread mark, and resolved questions are marked with a check mark or a cross mark; When reviewing, the administrator can locate the problem and view the associated photos and descriptions. The approval results are synchronously updated to the facility attribute table and the problem bookmark status field; After approval, the graphic maintenance interface is triggered and automatically jumps to the facility object interface that needs to be modified.

[0015] Compared with the prior art, the present invention has the following beneficial effects: The online drainage pipeline map collection and editing real-time repair and measurement method proposed in the present invention realizes rapid response and efficient processing of drainage pipeline problems by integrating work order management, webGIS platform and dual coding system. Based on the work order management module, the pipeline network problem report is received instantly, and the repair and measurement tasks are quickly generated and associated with the target facilities, which significantly improves the processing timeliness; the webGIS platform is used to load and display TMS, WMTS services and dynamic drawing services. The dynamic drawing service supports real-time mapping and updating to ensure the currentness of the data. The dual coding system realizes the accurate mapping of facility objects and drainage units through the dual guarantee of census coding and management coding, and solves the pain point that traditional census data is out of touch with actual management and maintenance needs. The graphical maintenance interface supports real-time repair and measurement operations, and combines the database synchronization update and problem bookmark approval process to build a data closed-loop management mechanism. This method is suitable for drainage pipeline management and maintenance units in the entire industry. While retaining the value of traditional census data, it realizes the precise control of the spatial attributes of refined management and maintenance objects, effectively reducing management and maintenance costs and improving work efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 It is a diagram of the method steps of the present invention; Figure 2 It is a core process diagram of the present invention. DETAILED DESCRIPTION

[0017] The following description is used to disclose the present invention so that those skilled in the art can implement the present invention. The preferred embodiments described below are only examples, and those skilled in the art may think of other obvious variations.

[0018] Reference Figure 1As shown in the figure, a webGIS online drainage pipeline map belongs to the method of real-time repair and measurement during compilation, including: S1. Receiving problem reports and generating repair and measurement tasks; S2. Loading spatial data of drainage facilities, including dynamic drawing; S3. Dual-coding management of facility objects and units; S4. Performing repair and measurement on the graphical interface; S5. Real-time updating the database and triggering TMS slicing; S6. Reviewing problems and modifying the attributes of approved facilities.

[0019] This method realizes the online compilation and real-time repair and measurement of drainage pipeline map data based on the webGIS platform. Through core technologies such as work order task management, dynamic graphic drawing, dual-coding system, maintenance of facility association relationships, database synchronization update, and approval process linkage, a complete dynamic maintenance system for pipeline data is constructed. The specific implementation process is as follows: Refer to Figure 2 As shown in the figure, the system first receives the reported information of pipeline network problems through the work order management module, automatically analyzes the problem type and associates it with the target drainage facility object, and generates a task to be repaired and measured. The task information includes the problem location coordinates, associated facility code, reported description, and on-site photo index, and at the same time triggers the webGIS platform to load the spatial data of the target drainage facility. When the map service is loaded, the TMS service is used as the base map, and the WMTS service is superimposed to achieve layered rendering. The newly added or modified pipe points, pipelines, and facility object graphics are real-time plotted through the dynamic drawing service. The graphic data of the dynamic drawing adopts a dual-track storage mechanism: the polyline completed by drawing is converted into a WMS service and stored in the facility line table x_ssline, and at the same time, the geometric data is written into the geometry field of the data_project table to ensure the spatial consistency of the graphic data and the attribute data. In the graphic rendering layer, the dynamically drawn graphics are superimposed on the TMS base map as a semi-transparent layer, and the TMS map service slicing update is triggered every 5 minutes through a timed task to achieve the real-time display of the map.

[0020] During the task execution phase, a dual coding system is adopted to manage the entire life cycle of facility objects and facility units. The census code is generated according to "facility type identifier (2-letter code) + street code (6-digit administrative division code) + serial number (4-digit incrementing number)". For example, the identifier of a rainwater well is YS, the street code of Rehe South Road is 320113, and the serial number automatically increments to form YS3201130001. The management code is constructed according to the facility management requirements and consists of "facility object number (DLPS0001) + pipe network category (YS / WS / HS) + incrementing serial number (0001)", such as DLPS0001_YS_0001. The coding system is automatically generated and written into the facility main table ss_dlpsss when the facility is created, and is also bidirectionally associated with the PrjNo field of the data_project table. When a new road drainage facility is added, the system automatically generates a facility code of "DLPS + 4-digit incrementing serial number" (such as DLPS0001), and simultaneously creates a new task record in the data_project table. The warehoused project name prjname is automatically spliced by the facility type, the affiliated street, and the facility name, such as "Road Drainage_Rehe South Road Street_Zhongshan North Road Drainage Pipe Network".

[0021] After entering the graphic maintenance interface, the operator selects the patching measurement mode through the right toolbar, including functions such as main pipeline drawing, pipe point picking, pipeline reversal, and property brush. When drawing the main pipeline, the pipeline style is dynamically set according to the pipe network category: the rainwater pipeline uses a 2px solid blue line and adds a flow arrow, the sewage pipeline is a coffee-colored dotted line, and the combined pipeline shows a pink gradient effect. When the pipe network category (pipecategory) changes, the warehoused field needs to synchronously update the drainage system (systemid). The drainage system (systemid) is not displayed in the web backend and is not visible in the app editing interface. The corresponding mapping relationship is as follows: During the drawing process, the system captures the mouse trajectory in real time to generate a temporary graphic. After right-clicking to end the drawing, the pipeline length, slope, and starting and ending point coordinates are automatically calculated. When saving, the geometric data is written to the x_ssline table, and the corresponding pipe segment record is generated in the facility unit table. For newly added pipe points drawn dynamically, the system implements differentiated data entry control according to the shape of the manhole cover: rectangular manhole covers are required to enter dimension 1 (length) and dimension 2 (width), and circular manhole covers only require dimension 1 (diameter). After the input is completed, the center coordinates of the manhole cover are automatically calculated and written to the spatial database, and a facility unit code such as "DLPS0001_YS_dd0001" is generated simultaneously. When adding new pipe points or pipe segments, some fields need to be automatically calculated or identified by the system. The logic is the same as that of the drainage inspection app, including coordinates (automatically identified according to the newly added points), well bottom elevation, starting pipe bottom elevation, end pipe bottom elevation, pipeline cross-sectional area, pipeline length, pipeline slope, etc.; Well bottom elevation = ground elevation - well depth, unit: m; Starting point pipe bottom elevation = starting point ground elevation - starting point burial depth - pipe diameter / 1000, unit: m; End point pipe bottom elevation = end point ground elevation - end point burial depth - pipe diameter / 1000, unit: m; Pipe cross-sectional area (circular) = 3.14*(pipe diameter 1 / 2)²; Pipe cross-sectional area (rectangle) = pipe diameter 1*pipe diameter 2; Pipeline length = √((starting point x coordinate - end point x coordinate)²+(starting point coordinate - end point y coordinate)²); Pipeline slope = h / L = (end point y coordinate - start point y coordinate) / pipeline length.

[0022] In terms of maintaining the relationship between facilities, dynamic association across facility objects is achieved through the spatial query engine. When picking up an associated facility (such as a drainage household or a river outlet), the system initiates a 500-meter buffer space query with the current facility coordinates as the center to obtain the WMS service element ID of the associated facility. When establishing an association, an associated record is inserted into the ss_ssyssgl table, which contains the main facility type, number, associated facility type, number, and associated time fields, such as inserting a record (road drainage, DLPS0001, drainage household, PSS0001, 2024-02-20 14:30:00). When unbinding an association, the system does not directly delete the data, but marks delflag as 1 in the association table and migrates the associated facility to the "Other_Owned Street_Facility Type" task to retain the complete operation history. The graphic display of the associated facility is superimposed with a special icon, which is marked with an orange flashing mark on the TMS base map. Click to view the association details and operation log.

[0023] The pipeline attribute editing realizes the flexible configuration of fields by using dynamic form technology. When a pipe point or pipe segment is selected, the system dynamically loads attribute fields from the table configuration library according to the facility type, including groups such as basic attributes, construction information, and maintenance standards. The attribute brush function extracts the non-coded attributes of the source object through the field configuration center to generate a checkable list. For example, after selecting a certain rainwater well, the field values such as "cleaning cycle" and "inspection frequency" can be copied. When performing attribute overwrite, the system first verifies the integrity of the required items in the target field. If the "subordinate street" field of the target pipe point is empty, the operation will be terminated and an error will be prompted. For the pipeline reverse operation, the system synchronously modifies the graphic attributes and data records: exchanges the coordinate order of the pipeline start point and end point, takes the opposite value of the slope value and updates it to the pipeline attribute table, and highlights the reverse pipeline in the graphic interface, and records the operation log in the ss_operation_log table. The pipeline code after reversal is reorganized according to the rule of "end pipe point code_start pipe point code". For example, the original code YS3201130001-0002 is changed to YS3201130002-0001.

[0024] The database synchronization adopts a transaction-level data consistency guarantee mechanism. When modifying the field configuration of the line table x_ssline, the system automatically synchronizes it to the line view table v_ssline_view to keep the field definitions, display and hide rules, and sorting methods of the two completely consistent. When adding a new facility unit, while inserting a record into the facility main table ss_dlpsss, a record with an associated identification code is inserted into the facility unit table ss_unit, and the spatial index of the geometry field in the data_project table is updated through a trigger. The deletion operation implements cascade control: when deleting a facility object, its associated facility unit is migrated to the historical task table, and the associated facility relationship is marked as unbound, but the complete data record of the facility unit is retained. The data version management adopts the "modify as snapshot" strategy, and a version snapshot is generated in the ss_history table every time a field is updated, supporting tracing the data change track along the timeline.

[0025] The problem bookmark module realizes the closed-loop management of the patching and surveying process. Unprocessed problems display a blue unread mark, and the problem locations are marked with pulsating icons on the map. When the reviewer clicks on the problem bookmark, the system automatically locates to the problem coordinates and loads the associated on-site photos, description text, and facility attribute form. After the approval is passed, the system triggers the graphic maintenance interface to automatically jump to the interface of the facility to be modified, and writes the approval result into the status field of the facility attribute table. For the approval involving pipeline topology structure changes, the system automatically checks the connection status of the associated pipe points. If isolated pipe points are found, topology repair suggestions will be prompted. The approval process is deeply integrated with the work order system, and the approval opinions are synchronously updated to the work order management module in real time, and the task status is updated to "closed loop" or "needs review".

[0026] In terms of mobile device adaptation, the graphical maintenance interface adopts a responsive design and supports touch gesture operations: two-finger zooming to adjust the map level, long pressing to activate the pipe point selection menu, and the sliding trajectory is automatically fitted into the pipeline path. The mobile data synchronization adopts an incremental update strategy, only transmitting the geometric graphics difference part, and ensuring the operation continuity in a weak network environment through offline map caching. The photos collected on-site use GPS positioning watermark technology to embed coordinate and azimuth information into the picture metadata, and automatically parse and write it into the location field of the file management table t_file_manager when uploading.

[0027] When the system is implemented, a distributed spatial data engine is deployed, and a spatial database cluster is built using PostgreSQL + PostGIS. The TMS / WMTS service is published through GeoServer. The front end uses the OpenLayers framework to implement the graphical rendering engine, and a real-time data channel is established in combination with the WebSocket protocol to ensure operation synchronization during multi-user collaboration. In terms of performance optimization, a spatial index is established for the pipe point query of high-frequency operations, and the R-tree structure is used to accelerate spatial retrieval; LOD optimization is implemented for pipeline rendering, and the vertex density is dynamically adjusted according to the map zoom level to ensure smooth display of tens of thousands of pipeline data.

[0028] The entire implementation process runs through data quality verification rules: topological consistency checks are performed during the collection of pipe point coordinates to prevent pipeline intersections and overlaps; field logical relationships are verified during attribute entry, such as the value of "well depth" must be greater than the difference between "pipe bottom elevation" and "manhole cover elevation"; uniqueness verification is performed during the generation of facility codes to avoid duplicate code conflicts. Through the implementation of the above technical solutions, the online management of the entire process of drainage pipeline data from problem discovery, task dispatch, graphical editing, attribute update to review and archiving is realized, effectively improving the currency of pipe network data and the efficiency of spatial data governance.

[0029] This method is applicable to all drainage pipeline maintenance units, solving the pain points that it is difficult to accurately master the space and attributes of each drainage facility management object and the actual drainage unit object during refined maintenance. On the one hand, it effectively utilizes traditional census data, and on the other hand, it realizes precise maintenance, greatly reducing the maintenance cost and improving the maintenance efficiency.

[0030] The above shows and describes the basic principles, main features and advantages of the present invention. Those skilled in the art of this industry should understand that the present invention is not limited by the above embodiments. What is described in the above embodiments and the specification is only the principle of the present invention. Without departing from the spirit and scope of the present invention, the present invention will have various changes and improvements, and these changes and improvements all fall within the scope of the present invention claimed. The scope of protection claimed by the present invention is defined by the appended claims and their equivalents.

Claims

1. A method for real-time patching and surveying of webGIS online drainage pipeline maps, characterized in that, It includes the following steps: S1. Receive the reported information of pipeline network problems based on the work order management module, generate a task for repair and measurement to be carried out, and associate it with the target drainage facility object; S2. Load the spatial data of the target drainage facility through the webGIS platform, including TMS service, WMTS service and dynamic drawing service, where the dynamic drawing service is used to plot the graphics of newly added or modified pipe points, pipelines and facility objects in real time; S3. Adopt a dual coding system to manage facility objects and facility units. The dual coding system includes a census code and a management code. The census code is composed of "facility type identifier + street code + serial number", and the management code is generated by "facility object number + pipeline network category + incremental serial number". The pipeline network categories include rainwater, sewage and combined flow; S4. Perform repair and measurement operations in the graphic maintenance interface; S5. Synchronously update the database in real time, including the facility main table, the facility unit table and the association relationship table, and trigger the full database slicing of the TMS service to update the map display; S6. Review the reported problems through the problem bookmark module, complete the modification approval of the attributes of the facility object or facility unit, and the approval status includes adopted or not adopted.

2. The real-time patching and surveying method for the webGIS online drainage pipeline map compilation according to claim 1, characterized in that, The graphic saving logic of the dynamic drawing service in step S2 includes: The drawn polyline is converted into a WMS service and stored in the facility line table x_ssline, and at the same time, the geometric data is written into the gemetry field of the data_prject table; The real-time drawn graphics are superimposed on the TMS base map, and the TMS slicing is triggered through a scheduled task to update the map service.

3. A real-time patching and surveying method for webGIS online drainage pipeline maps according to claim 1, characterized in that, The data association method of the dual coding system in step S3 is: The table configuration of the special view point table of the rainwater well is synchronously updated with the field configuration of the dd table in real time. After modifying the dd table configuration, all associated views are automatically updated; The mandatory items and display / hide rules of the view object are strictly consistent with the source table configuration.

4. A real-time patching and surveying method for webGIS online drainage pipeline maps according to claim 1, characterized in that, The repair and measurement operations performed in the graphic maintenance interface in step S4 include: Pick up the existing pipe points, pipelines or associated facilities by point selection or box selection, and associate them with the current facility object; Dynamically draw new pipe points or pipelines, and automatically assign colors and flow direction identifiers according to the pipeline network category. The color of rainwater is blue, the color of sewage is coffee, and the color of combined flow is pink; Execute the pipeline reverse operation, including modifying the flow direction identifier, swapping the start and end points, and recalculating the pipeline slope; Use the attribute brush function to batch copy the attributes of pipe points or pipelines, including checking the target fields after selecting the source attributes and box selecting the target objects to complete the attribute overwrite.

5. A real-time patching and surveying method for webGIS online drainage pipeline maps according to claim 4, characterized in that, The specific rules for picking up associated facilities are: The associated facility types include area drainage, drainage households and river outfalls, and their WMS service element IDs are obtained through spatial query; Insert records into the ss_ssyssgl table when establishing an association relationship, including the associated facility type, number, and the associated facility type, number; Delete the corresponding records when unbinding the association, and move the associated facilities to the "other_owned street_facility type" task.

6. A real-time patching and surveying method for webGIS online drainage pipeline map compilation according to claim 4, characterized in that When dynamically drawing new pipe points, the following operations need to be performed: Dynamically control the input fields according to the manhole cover shape: if it is rectangular, both manhole cover size 1 and size 2 are required; if it is circular, only size 1 is required; Automatically calculate the coordinates of pipe points and write them into the spatial database, and synchronously generate facility unit codes and identification codes; The point view table is dynamically generated by combining the basic attribute fields, special attribute fields of the dd table, and extended fields of the e table, and the special attribute form is dynamically loaded according to the component type; Among them, the generation and configuration of attribute fields meet the following rules: a. All attribute fields are generated through dynamic configuration, and hard-coded fixed fields are prohibited; b. The line table and the line view table share the same field configuration. After modifying the line table configuration, it is automatically synchronized to the line view table; c. The point view table is generated by combining the basic attributes, special attributes of the dd table, and the corresponding e table; d. The table configuration of the special view point table of the rainwater well is automatically synchronized with the field configuration of the dd table to ensure the consistency between the view and the source table.

7. A real-time patching and surveying method for webGIS online drainage pipeline maps according to claim 4, characterized in that, The implementation method of the reverse operation of the pipeline is as follows: Modify the direction of the pipeline flow arrow and exchange the start and end points in the pipeline code; Recalculate the pipeline slope, take the opposite value of the slope value and update it to the pipeline attribute table; The reversed pipeline graph is highlighted on the map, and the modification log is recorded in the operation history table.

8. A real-time patching and surveying method for webGIS online drainage pipeline maps according to claim 4, characterized in that The specific implementation of the attribute brush function includes: Extract the non-coded attribute fields of the source object through dynamic configuration to generate a checkable attribute list; The field content of the attribute list is dynamically generated based on the table configuration, and hard-coded preset fields are prohibited; When overwriting attributes, verify that the required items are not empty. If the verification fails, terminate the operation and prompt an error.

9. A real-time patching and surveying method for webGIS online drainage pipeline map compilation according to claim 1, characterized in that The logic of database synchronization and update in step S5 includes: After modifying the line table configuration, it is automatically synchronized to the line view table to ensure the consistency of the field definitions of the two; When adding or modifying line table records, synchronously update the field display rules and sorting of the line view table; When deleting a facility object, its associated facility unit is automatically migrated to the "other_owned street_pipeline network category" task to retain historical data.

10. A real-time patching and surveying method for webGIS online drainage pipeline maps according to claim 1, characterized in that, The approval process of the problem bookmark module in step S6 includes: The problem bookmarks in the unresolved state display a blue unread mark, and the resolved state displays a tick or cross mark; When the administrator reviews, they can locate the problem location and view the associated photos and descriptions, and the approval result is synchronously updated to the facility attribute table and the problem bookmark status field; After approval, trigger the graphic maintenance interface and automatically jump to the interface of the facility object to be modified.

Images