Summary of the invention
The invention provides a kind of City Underground Pipeline interactive system and method thereof, wherein this system adopts the function of plug-in type developing mechanism to system effectively to customize, each feature card independent operating, and common service is effectively separated with system customization business; Adopt centralized service management to carry out unified management to the resource of multiple access, intuitively represent all resources simultaneously, also can show needed for oneself on map, the interface that developer only need grasp resource access can access fast, share new resources.
The present invention adopts following technical scheme:
A kind of City Underground Pipeline interactive system, comprising:
Data Layer, it sets up locus and the attribute information of City Buried Pipeline, and the spatial relationship data storehouse between locus and attribute information;
Business Logic, it is between data Layer and application layer, management and distributing user role, examination & verification and the delimitation of distributing data authority, and the data interaction request command that sends of reception application layer provide interface for application layer and data Layer data interaction;
Described Business Logic, comprises data resource platform interface management center, authority management module and data examination & verification release module;
Wherein, data resource platform interface management center is the interface communication between management data layer and application layer, and the interface in unified city management data interaction system calls the resource of independent dispersion; Authority management module, for arranging system user management and data permission management; Data examination & verification release module, the data in its image data layer also determine the accuracy of data and the integrality of data structure; And
Application layer, it provides the application based on Business Logic, transmits the data of the acquisition request data Layer of user to data Layer.
Described data Layer, comprises
Basic geological study database, for gathering, editing and process the locus of the key element on map, attribute information and spatial relationship data each other, the key element wherein on map, comprises water system, boundary, traffic, settlement place, landform and vegetation; And
Special topic pipe network database, for storing the spatial data of the attribute information of urban underground water drainage pipe line, water supply line, heating pipeline, burning line and power cable pipeline and its affiliated facility separately; Wherein, the attribute of City Underground Pipeline comprises: the length of the position of line distribution, underground utilities quantity and underground utilities; And
Other relational databases, comprise underground utilities daily servicing related statements, user right and data permission information, and the symbolism of City Underground Pipeline, play up displaying and data dictionary relevant information, these information is formed the data acquisition connected each other, and be relevant row and column by Organization of Data; And
Spatial database engine, set up the path of basic geological study database and thematic pipe network database and Business Logic, for receiving the request of reading City Underground Pipeline to transfer the City Buried Pipeline information in basic geological study database and thematic pipe network database; And
Other relational database engines, for storing, processing and the kernel service of protected data, utilize relational database engine access control authority processing transactions, create the relational database being used for Transaction Processing or on-line analytical processing data.
Described application layer, comprising:
Fundamental Geographic Information System administration module, it sends and obtains and editor's basic geological study database and the data command of thematic pipe network database, and data resource platform interface management center responds this order and the data reading basic geological study database and thematic pipe network database are edited; And
Data preprocessing module, it gathers buried pipe point, pipeline data and underground related facility data that city is newly established, and carries out conversion and the inspection of data, enters the requirement of database data through the data fit changed and check; And
Online editing maintenance module, it sends request design and upgrades underground pipe network data, and comprise that micro-data increase, amendment, upgrade, delete and the importing of batch data, derivation and assignment, the dynamic data meeting each phase user is upgraded demand; And
Off-line editing module, its edit-modify is separated the off-line task agent of generation from thematic pipeline database.
Described application layer, also comprises:
Data constrained input module, it is edited, plays up and export City Buried Pipeline map, forms thematic map, export as picture as required or output to printer by map configuration; And
Data query statistical module, it adopts trie tree mode to inquire about the attribute gathering current Underground Pipeline Data; And
Decision Analysis module, for obtaining the mutual relationship information between the present situation of underground utilities, distribution, trend and pipeline, wherein, described decision Analysis module, comprising: the horizontal stroke/longitudinal diagram analysis module of urban Underground pipeline, crash analysis module, valve-turnoff analysis module, analysis module of speedily carrying out rescue work, the inquiry of connection analysis module, early warning analysis module, follow-up analysis module, earthing analysis module, Shortest Path Analysis module and underground utilities three dimensional navigation; And
Historical archiving resource management, for inquiring about, browsing and recall the City Underground Pipeline of Historical archiving.
A data interactive method for City Underground Pipeline interactive system, comprises the following steps:
Step (1): City Underground Pipeline stores
Gather locus and the attribute information of City Buried Pipeline, audit by rear stored GIS database, and organize the spatial relationship between the locus of City Buried Pipeline and attribute letter to set up other relational databases;
Step (2): City Underground Pipeline interactive system rights management
Application layer receiving system logging request, application layer is called authority management module and is judged whether request meets login requirement; If request does not meet login requirement, application layer refusal use system; If request meets login requirement, then authority management module is by data resource management central platform accessing database, reads application function rights of using information and editor's search access right information that user has from database;
Step (3): application layer sends request order
On the basis of step (2), application layer sends respective request order, and data resource management central platform response command sending request is browsed, or the data in editing data storehouse, this order of database response.
The mode of data in editing data storehouse in described step (3), comprising: online editing and off-line editing.
Wherein, the process of off-line editing is:
Step (1): obtain the data in database
Obtain the City Underground Pipeline in database, and call the query statistic interface of Business Logic data resource platform interface management center, result is returned to application layer by spatial database engine and relational database engine by this interface;
Step (2): output to this locality after the data obtained in step (1) are encrypted packing, forms off-line task agent; The basic geological study data of data Layer, thematic pipe network data and other relation datas are outputted to this locality by the data output interface of Business Logic by this step;
Step (3): off-line editing
Opened outputting to local data by off-line editing module, and by the editting function of this module, the increase of basic geological study data and thematic pipe network data, deletion and amendment are carried out to off-line data;
Step (4): by off-line task agent complete for the amendment in step (3), imports in basic geological study database and thematic pipe network database respectively; And the data before upgrading are carried out Historical archiving by the Historical archiving management interface of Business Logic, and usage data input interface is separated basic geological study data and thematic pipe network data in off-line task agent, and be updated in correspondence database;
Step (5): the Historical archiving data in step (4) are managed, filed data are inquired about and added up, and land parcel change trace analysis is carried out to the data of specifying, and display data evolution process.
The process of online editing is:
Step (1): obtain the data in database
Obtain the City Underground Pipeline in database, and call the query statistic interface of Business Logic data resource platform interface management center, result is returned to application layer by spatial database engine and relational database engine by this interface;
Step (2): the data obtained in step (1) are carried out visual terminal display in application layer, utilizes GIS correlation technique that the basic geological study data of data Layer, thematic pipe network data and other relation datas are outputted to application layer by the data output interface of Business Logic;
Step (3): online editing
Opened outputting to local data by online editing module, and by the editting function of this module, the increase of basic geological study data and thematic pipe network data, deletion and amendment are carried out to online data;
Step (4): data separate Version Control mechanism complete for the amendment in step (3) is carried out data save operation, real-time update is in basic geological study database and thematic pipe network database; And the data before upgrading are carried out Historical archiving by the Historical archiving management interface of Business Logic, and usage data input interface is separated basic geological study data and thematic pipe network data in task agent, and be updated in correspondence database;
Step (5): the Historical archiving data in step (4) are managed, filed data are inquired about and added up, and land parcel change trace analysis is carried out to the data of specifying, and display data evolution process.
Beneficial effect of the present invention is:
(1) the present invention utilizes unified interface to call the functional resources mode of independent dispersion, and formation is called as required, fast construction, Underground Pipeline Data good alternately.
(2) the present invention adopts centralized service to manage the unified management of multiple underground utilities resource information, realizes data resource sharing, for other business platforms provide Data support; Realize the collection of pipe network data, process, storage and maintenance renewal, meet the continuation accumulation demand of data; Realize the management to pipe network infrastructure, support routine servicing management, thematic form and facility amount statistics; Realize the design of pipe network auxiliary programming, provide technical support to underground utilities planning and engineering construction project.
Embodiment
Below in conjunction with drawings and Examples, the present invention is further elaborated.
As shown in Figure 1, the present invention is by extracting public module, and forming uniform based underground pipe network common architecture is the fast construction of system, improves exploitative making full use of and development efficiency.
A kind of City Underground Pipeline interactive system, comprising: data Layer, Business Logic and application layer.
Data Layer, it sets up locus and the attribute information of City Buried Pipeline, and the spatial relationship data storehouse between locus and attribute information;
Data Layer: comprise basic geological study database, thematic pipe network database and other relevant database; This layer is connected with data resource management center by Spatial Data Engine and Relational Data Engine.
Data Layer, its each ingredient is described below:
Basic geological study database: key element all kinds of on national fundamental GIS is comprised water system, boundary, traffic, settlement place, landform and vegetation etc. according to certain regular layering, according to criteria classification coding, to the locus of each key element, attribute information and each other the data such as spatial relationship gather, edit, process the database built up.
Special topic pipe network database: carry out layering, coding according to category of employment, according to the spatial database of the underground utilities such as certain rale store water discharge line, water supply line, heating pipeline, burning line and power cable pipeline and affiliated facility.
Other relational databases: the system by Organization of Data being relevant row and column, as Oracle, mySQL and SQL Server.
Spatial database engine is the path of store and management multi-user space spatial database in relational database management system, if ArcSDE is the Spatial Data Engine of ArcGIS.
Other relational database engines: for storing, processing and the kernel service of protected data; Utilize relational database engine access control authority and fast processing affairs, create the relational database being used for Transaction Processing or on-line analytical processing data; Create table for storing data and for checking, managing and the database object of protected data safety, as index, view and storing process.
Business Logic: be in the middle of data Layer and application layer, play the effect of forming a connecting link in exchanges data, be responsible for the various functions interface providing application layer to use, comprise the management to user role, data, distribution, the delimitation of data permission and the examination & verification of data and issue.
Business Logic, it is between data Layer and application layer, management and distributing user role, examination & verification and the delimitation of distributing data authority, and the data interaction request command that sends of reception application layer provide interface for application layer and data Layer data interaction;
Described Business Logic, comprises data resource platform interface management center, authority management module and data examination & verification release module;
Wherein, data resource platform interface management center is the interface communication between management data layer and application layer, and the interface in unified city management data interaction system calls the resource of independent dispersion; Authority management module, for arranging system user management and data permission management; Data examination & verification release module, the data in its image data layer also determine the accuracy of data and the integrality of data structure;
Described data resource platform interface management center, based on Data Information Service in the bridge of the information interaction of system application, bottom data is issued as the form of service, the service of location information services, query statistic attribute information, analytical applications information service etc. are provided, the related work such as control of authority, Real-Time Monitoring that simultaneously platform can be utilized to carry out serving to application layer;
Described authority management module, log searching inquiry is logged in for user login validation and system user management, data permission management and user, role's scope that different users is corresponding different, better control data security strategy, can by scope, the access, the Read-write Catrol that carry out data by layer;
Described data examination & verification release module, submission for the new census data of user is audited, maintenance data one-tenth schemes visual means and available data is analyzed, determine the accuracy of data and the integrality of data structure, data loading is carried out by auditing the data passed through, Map Services Information issued upgrades, and audits unsanctioned, performs retraction operation.
Application layer, it provides the application based on Business Logic, transmits the data of the acquisition request data Layer of user to data Layer;
Described application layer, comprises Fundamental Geographic Information System administration module, data preprocessing module, online editing maintenance module, off-line editing maintenance module, information query and statistics module, data constrained input module, decision Analysis module and Historical archiving administration module.
Each module of application layer specifically describes as follows:
Fundamental Geographic Information System administration module: to the management of basic geological study and thematic Pipeline Network Spatial Data, the spatial data of management point, line and face three kinds of pels and graphic attribute, calculate and map label for map view, foundation location, chart engage, amount respectively;
Data preprocessing module: the conversion and the inspection that mainly realize data, make the requirement entering database data through the data fit changed and check, the data layout supported comprises detection data, CAD as-constructed drawing data and other result transformation data;
Online editing maintenance module: provide multiple flexibly, underground pipe network design data and more new tool easily; This module comprises that micro-data increase, amendment, upgrade, delete and the importing of batch data, derivation and assignment, and the dynamic data meeting each phase user is upgraded demand;
Off-line editing module: the mode adopting task workflow, data to be edited are separated by task matching by data management staff from thematic pipeline database, generate off-line task agent; After data edition personnel reception task, carried out the amendment of data by off-line editing; After having revised, off-line task agent is carried out job invocation and then carry out quality audit by data auditor, auditing by judging whether to there is with other data conflict, after Lothrus apterus or Conflict solving, performing warehouse-in;
Data constrained input module: realize the editor of map, play up and export, form thematic map by map configuration, export as picture as required or output to printer;
Data query statistical module, its locus based on City Buried Pipeline and attribute data, adopt trie tree mode to inquire about the attribute gathering current Underground Pipeline Data; This module is for inquiring about line distribution information, statistical summaries underground utilities quantity and length;
Decision Analysis module: for understanding the mutual relationship between the present situation of underground utilities, distribution, trend and pipeline, and provide technical support when there is pipeline accident for formulating processing scheme; This module comprises again: horizontal stroke/longitudinal diagram analysis module, crash analysis module, valve-turnoff analysis module, analysis module of speedily carrying out rescue work, connection analysis module, early warning analysis module, follow-up analysis module, earthing analysis module, Shortest Path Analysis module and pipeline three dimensional navigation enquiry module;
Historical archiving resource management: for performing inquiry to Historical archiving data, browse and the operational administrative such as backtracking.
A data interactive method for City Underground Pipeline interactive system, comprises the following steps:
Step (1): City Underground Pipeline stores
Gather locus and the attribute information of City Buried Pipeline, audit by rear stored GIS database, and organize the spatial relationship between the locus of City Buried Pipeline and attribute letter to set up other relational databases;
Step (2): City Underground Pipeline interactive system rights management
Application layer receiving system logging request, application layer is called authority management module and is judged whether request meets login requirement; If request does not meet login requirement, application layer refusal use system; If request meets login requirement, then authority management module is by data resource management central platform accessing database, reads application function rights of using information and editor's search access right information that user has from database;
Step (3): application layer sends request order
On the basis of step (2), application layer sends respective request order, and data resource management central platform response command sending request is browsed, or the data in editing data storehouse, this order of database response.
The mode of data in editing data storehouse in described step (3), comprising: online editing and off-line editing.
As shown in Figure 2, the process of the off-line editing of City Underground Pipeline interactive system of the present invention is:
Step (1): obtain the data in database
Obtain the City Underground Pipeline in database, and call the query statistic interface of Business Logic data resource platform interface management center, result is returned to application layer by spatial database engine and relational database engine by this interface;
Step (2): output to this locality after the data obtained in step (1) are encrypted packing, forms off-line task agent; The basic geological study data of data Layer, thematic pipe network data and other relation datas are outputted to this locality by the data output interface of Business Logic by this step;
Step (3): off-line editing
Opened outputting to local data by off-line editing module, and by the editting function of this module, the increase of basic geological study data and thematic pipe network data, deletion and amendment are carried out to off-line data;
Step (4): by off-line task agent complete for the amendment in step (3), imports in basic geological study database and thematic pipe network database respectively; And the data before upgrading are carried out Historical archiving by the Historical archiving management interface of Business Logic, and usage data input interface is separated basic geological study data and thematic pipe network data in off-line task agent, and be updated in correspondence database;
Step (5): the Historical archiving data in step (4) are managed, filed data are inquired about and added up, and land parcel change trace analysis is carried out to the data of specifying, and display data evolution process.
The process of online editing is:
Step (1): obtain the data in database
Obtain the City Underground Pipeline in database, and call the query statistic interface of Business Logic data resource platform interface management center, result is returned to application layer by spatial database engine and relational database engine by this interface;
Step (2): the data obtained in step (1) are carried out visual terminal display in application layer, utilizes GIS correlation technique that the basic geological study data of data Layer, thematic pipe network data and other relation datas are outputted to application layer by the data output interface of Business Logic;
Step (3): online editing
Opened outputting to local data by online editing module, and by the editting function of this module, the increase of basic geological study data and thematic pipe network data, deletion and amendment are carried out to online data;
Step (4): data separate Version Control mechanism complete for the amendment in step (3) is carried out data save operation, real-time update is in basic geological study database and thematic pipe network database; And the data before upgrading are carried out Historical archiving by the Historical archiving management interface of Business Logic, and usage data input interface is separated basic geological study data and thematic pipe network data in task agent, and be updated in correspondence database;
Step (5): the Historical archiving data in step (4) are managed, filed data are inquired about and added up, and land parcel change trace analysis is carried out to the data of specifying, and display data evolution process.
As shown in Figure 3, the course of work of the decision Analysis module in City Underground Pipeline interactive system of the present invention, specifically comprises the following steps:
Step (1): pipe network base application is analyzed:
Pipe network base application mainly comprises the underground pipe network data such as feedwater, combustion gas, heating power, draining, resurgent water, street lamp for basic bottom space data, shared, exchanges data, two three-dimensional integratedization, the comprehensive underground pipenet that carry out data are applied and carry out professional pipe network application in the mode of data transformations, the analysis display function that this applied analysis is mainly basic;
Step (2): pipe network applied analysis decision-making:
Pipe network applied analysis decision-making is in the ordinary maintenance carrying out underground pipe network, maintenance, patrols and examines the evaluation decision of process data, according to the overall performance of pipe network daily operation information total evaluation pipe network, as the assessment of accident easy happen zone, present network situation assessment, eliminate the potential safety hazard of pipe network day-to-day operation;
Step (3): pipeline network construction:
Pipeline network construction mainly carries out pipe network examination & approval, program and design according to the result of pipe network applied analysis accumulation, comprise New town planning and old city upgrading relevant programme designs, utilize the modeling method of specialty and the layout strategy of science to carry out planning and design, improve the level of aggregation of pipeline network construction.
Each step in Fig. 2 and Fig. 3 all carries out the function privilege of system user role and data permission judges, and the realization of each step all obtains corresponding authority based on system user.
Above-described embodiment is also not used to limit the present invention, and any those skilled in the art, without departing from the spirit and scope of the present invention, the amendment done all is included in the scope of the application.