A method, system, storage medium and program product for urban lighting facility management

Abstract

The present application provides a method, system, storage medium and program product for managing urban lighting facilities, and relates to the field of traffic control systems. The header information of the geographic information data file is read, and the interactive operation events between the user and the import interactive interface are monitored to determine the association between the header information and various types of data. When faced with data that is not in the preset template type, it is still possible to accurately identify its category and logical relationship based on the user's association operation. For unconfigured files, they are stored in the configuration database and the regional road section database according to the determined association relationship, ensuring that new data can be incorporated into the management system in an orderly and accurate manner. By comparing and matching with the pre-stored attribute list, the attributes that do not exist in the pre-stored attribute list are inserted into the corresponding list. Not only can the data that is not in the preset template type be smoothly imported, but the data can also be integrated with the existing data system, ensuring the integrity and consistency of the data.

Description

Technical Field

[0001] The present application relates to the field of traffic control systems, and in particular to a method, system, storage medium and program product for managing urban lighting facilities. Background Art

[0002] Urban lighting facility assets are characterized by a wide variety and large number, including distribution cabinets, lamp poles, lamps, manhole covers, cables, lighting controllers and many other facilities and equipment. Together, they constitute the lighting system of the entire city and ensure the safety of citizens' travel at night. Therefore, the management and statistics of urban lighting facility assets are an important part of ensuring the long-term stable operation of urban lighting and promoting energy conservation and emission reduction in urban lighting.

[0003] In the relevant urban lighting facility management model, some fixed data table structures are usually preset to store the asset type, specification parameters, and regional and road information of lighting facilities. When new lighting facility data needs to be imported, the system simply matches the field names in the data file with the fields in the preset data table to determine the storage location and association relationship of the data. If new types of data appear in the data file, it is difficult to accurately associate and integrate the data. Summary of the invention

[0004] The present application provides a method, system, storage medium and program product for managing urban lighting facilities, which are used to smoothly import data that is not in the preset template type, integrate these data with the existing data system, and ensure the integrity and consistency of the data.

[0005] In a first aspect, the present application provides a method for managing urban lighting facilities, including: receiving framework data set by a user through a facility asset configuration unit, the framework data including lighting facility asset types, specifications, and hierarchical structure data; using an area management unit to collect user-defined custom areas and custom road information, and constructing corresponding area and road data in a geographic database based on the hierarchy of the custom area and custom road information, the geographic database containing area and road data sets of different hierarchies; using a batch data import unit to import geographic information data files, wherein: reading header information of the geographic information data file, and displaying the header information and facility asset categories, specifications, areas, and road data in a pre-set import interaction interface; monitoring user interaction operation events with the import interaction interface, and when the user interacts with the header information and When the facility asset category, specification, region and road data are associated, determine the association between the header information and the facility asset category, specification, region and road data; query whether the geographic information data file has been configured based on the association relationship; store the unconfigured geographic information data file in the configuration database and the regional road section database according to the association relationship, and obtain the corresponding first identification identifier; integrate the asset type and its associated attribute list into a key-value pair set, where the key is the first identification identifier and the value is the corresponding attribute list; according to the key-value pair set, find the pre-stored attribute list corresponding to each key, compare and match with the value, insert the attributes that do not exist in the pre-stored attribute list into the corresponding pre-stored attribute list, and obtain the corresponding second identification identifier; combine the geographic information data file based on the first identification identifier and the second identification identifier.

[0006] By adopting the above technical solution, the facility asset configuration unit receives the framework data set by the user, clarifies the asset type, specification and hierarchical structure of the lighting facilities, and lays the foundation for subsequent management. The custom area and road information collected by the regional management unit constructs the regional and road data set in the geographic database. In the batch data import unit operation, when the geographic information data file is imported using the batch data import unit, the header information of the geographic information data file is read, and it is displayed together with the facility asset category, specification, area and road data in the import interactive interface, which provides users with a clear data overview and association basis. The interactive operation events between the user and the import interactive interface are monitored to determine the association relationship between the header information and various types of data. This association method based on user interaction has greater flexibility. When facing data that is not in the preset template type, the system can still accurately identify its category and logical relationship based on the user's association operation. For unconfigured files, they are stored in the configuration database and the regional section database according to the determined association relationship, and the corresponding first identification identifier is obtained, ensuring that the new data can be incorporated into the management system in an orderly and accurate manner. Subsequently, the asset type and its associated attribute list are integrated into a key-value pair set, and the attributes that do not exist in the pre-stored attribute list are inserted into the corresponding list by comparison and matching with the pre-stored attribute list, and the second identification mark is obtained, which further improves and refines the storage and integration of data. In this way, not only can data that is not in the preset template type be smoothly imported, but these data can also be integrated with the existing data system, ensuring the integrity and consistency of the data, providing comprehensive and accurate data support for urban lighting facility management, and improving the management system's ability to accept and process diversified data.

[0007] In combination with some embodiments of the first aspect, in some embodiments, after the step of importing geographic information data files using a batch data import unit, it also includes: presenting the geographical location of urban lighting facilities on a display interface based on user interaction on a GIS map unit; in response to a filtering instruction triggered by a user on the GIS map unit, filtering out corresponding urban lighting facilities according to the filtering instruction, and updating the display interface; in response to a user dragging or framing operation on the urban lighting facility icon on the GIS map unit, modifying the first identification identifier and the second identification identifier according to a geographic database; and updating the display interface.

[0008] By adopting the above technical solutions, the user's interactive operation on the GIS map unit has been greatly facilitated. The geographical location of urban lighting facilities is presented according to user interaction, so that managers can intuitively understand the distribution of facilities, which is convenient for planning and maintenance. Responding to the filtering instructions to filter facilities and update the display interface can quickly focus on specific facilities, such as quickly finding faulty street lights in a certain area, improving troubleshooting efficiency. When the user drags or selects the facility icon, the identification mark is modified and updated according to the geographic database, which can reflect the location or status changes of the facility in real time, ensure that the map information is synchronized with the actual situation, enhance the dynamic and timely management, and optimize the visual management experience of urban lighting facilities.

[0009] In combination with some embodiments of the first aspect, in some embodiments, the step of querying whether the geographic information data file has been configured based on the association relationship specifically includes: querying whether the geographic information data file has been configured based on the association relationship and the pre-stored attribute list; recording the current version number of the pre-stored attribute list; searching the pre-stored attribute list corresponding to each key based on the key-value pair set, comparing and matching with the value, and inserting the attributes that do not exist in the pre-stored attribute list into the corresponding pre-stored attribute list, the step specifically includes: finding the pre-stored attribute list of the current version number; searching the pre-stored attribute list of the current version number corresponding to each key based on the key-value pair set, comparing and matching with the value, and inserting the attributes that do not exist in the pre-stored attribute list of the current version number into the pre-stored attribute list of the corresponding current version number.

[0010] By adopting the above technical solution, a version number mechanism is introduced in data association and insertion operations. The current version number of the pre-stored attribute list is recorded, and search and comparison are performed based on it, which effectively solves the problem of data inconsistency caused by multiple concurrent operations. When an operation modifies the pre-stored attribute list, subsequent operations can accurately obtain the latest and consistent list for comparison through the version number, avoiding attribute comparison errors caused by inconsistent list status, preventing repeated insertion or misjudgment of data, and ensuring the integrity and accuracy of lighting facility asset data.

[0011] In combination with some embodiments of the first aspect, in some embodiments, before the step of searching the pre-stored attribute list of the current version number corresponding to each key according to the set of key-value pairs, comparing and matching the values, and inserting the attributes that do not exist in the pre-stored attribute list of the current version number into the pre-stored attribute list of the corresponding current version number, it also includes: after a preset time, pausing the step of importing geographic information data files using a batch data import unit; after pausing, summarizing and updating the pre-stored attribute lists of different version numbers; after the update, starting the step of importing geographic information data files using a batch data import unit.

[0012] By adopting the above technical solution, after the pause, the pre-stored attribute lists of different version numbers are summarized and updated, which can centrally sort out and integrate various data changes and differences generated during the concurrent operation of multiple users. It ensures that the pre-stored attribute lists based on subsequent operations are the latest and complete versions, so that the data can maintain a high degree of consistency and accuracy in the entire management system.

[0013] In combination with some embodiments of the first aspect, in some embodiments, after the step of importing geographic information data files using a batch data import unit, it also includes: using a batch data management unit to perform batch operations on the imported geographic information data files, including: batch modification of asset attributes, batch modification of asset icons, batch modification of asset names, batch addition of affiliated assets, and batch modification of asset basic information.

[0014] By adopting the above technical solution, the batch data management unit is used to perform batch operations on the imported geographic information data files, thereby improving management efficiency. The batch modification of asset attributes, icons, names and other functions can process a large amount of similar data at one time, avoiding the tediousness of modifying them one by one.

[0015] In combination with some embodiments of the first aspect, in some embodiments, after the step of importing geographic information data files using a batch data import unit, it also includes: responding to the user's instructions in the data statistics unit, providing multiple data sources, attribute lists, and preset algorithms for display; performing statistical data based on the data source, attribute list, and preset algorithm selected by the user; and outputting the statistical results.

[0016] By adopting the above technical solution, in response to the user's instructions in the data statistics unit, the system provides multiple data sources, attribute lists and preset algorithms for display, and calculates the data and outputs the results accordingly. This flexible statistical method breaks the limitations of statistics in the traditional model. Users can freely choose data sources and algorithms according to actual needs and obtain the required data.

[0017] In combination with some embodiments of the first aspect, in some embodiments, the step of outputting statistical results specifically includes: using the data export unit to obtain the style and layout of the report; obtaining the user's check or addition of the statistical results to modify the statistical results, and outputting them.

[0018] By adopting the above technical solution, in the step of outputting statistical results, the data export unit is used to obtain the style and layout of the report, and the report is modified and output according to the user's selection or addition of statistical results. This makes report generation more flexible and personalized to meet the needs of different users and scenarios. Managers can customize the report content and format according to the reporting object and purpose, and highlight key data. This customized output improves the readability and usability of data.

[0019] In a second aspect, the present application provides an urban lighting facility management system, which includes: one or more processors and a memory; the memory is coupled to the one or more processors, the memory is used to store computer program code, the computer program code includes computer instructions, and one or more processors call the computer instructions to enable the urban lighting facility management system to execute the method described in the first aspect and any possible implementation method of the first aspect.

[0020] In a third aspect, the present application provides a computer program product comprising instructions, which, when executed on an urban lighting facility management system, enables the urban lighting facility management system to execute the method described in the first aspect and any possible implementation of the first aspect.

[0021] In a fourth aspect, the present application provides a computer-readable storage medium comprising instructions, which, when executed on an urban lighting facility management system, enables the urban lighting facility management system to execute the method described in the first aspect and any possible implementation of the first aspect.

[0022] One or more technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages:

[0023] 1. The facility asset configuration unit receives the framework data set by the user, clarifies the asset type, specification and hierarchical structure of the lighting facilities, and lays the foundation for subsequent management. The customized area and road information collected by the regional management unit constructs the regional and road data set in the geographic database. In the batch data import unit operation, when the geographic information data file is imported using the batch data import unit, the header information of the geographic information data file is read, and it is displayed together with the facility asset category, specification, area and road data in the import interactive interface, which provides users with a clear data overview and association basis. The interactive operation events between the user and the import interactive interface are monitored to determine the association relationship between the header information and various types of data. This association method based on user interaction has greater flexibility. When facing data that is not in the preset template type, the system can still accurately identify its category and logical relationship based on the user's association operation. For unconfigured files, they are stored in the configuration database and the regional section database according to the determined association relationship, and the corresponding first identification identifier is obtained, ensuring that the new data can be incorporated into the management system in an orderly and accurate manner. Subsequently, the asset type and its associated attribute list are integrated into a key-value pair set, and the attributes that do not exist in the pre-stored attribute list are inserted into the corresponding list by comparison and matching with the pre-stored attribute list, and the second identification mark is obtained, which further improves and refines the storage and integration of data. In this way, not only can data that is not in the preset template type be smoothly imported, but these data can also be integrated with the existing data system, ensuring the integrity and consistency of the data, providing comprehensive and accurate data support for urban lighting facility management, and improving the management system's ability to accept and process diversified data.

[0024] 2. Introduce a version number mechanism in data association and insertion operations. Record the current version number of the pre-stored attribute list, and search and compare based on it, effectively solving the problem of data inconsistency caused by multiple concurrent operations. When an operation modifies the pre-stored attribute list, subsequent operations can accurately obtain the latest and consistent list for comparison through the version number, avoiding attribute comparison errors caused by inconsistent list status, preventing repeated insertion or misjudgment of data, and ensuring the integrity and accuracy of lighting facility asset data.

[0025] 3. After the pause, the pre-stored attribute lists of different version numbers are summarized and updated, which can centrally sort out and integrate various data changes and differences generated during the concurrent operation of multiple users. It ensures that the pre-stored attribute lists based on subsequent operations are the latest and complete versions, so that the data can maintain a high degree of consistency and accuracy in the entire management system. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] Figure 1 It is a flow chart of the urban lighting facility management method in the embodiment of the present application;

[0027] Figure 2 is another flow chart of the urban lighting facility management method in the embodiment of the present application;

[0028] Figure 3 It is a schematic diagram of an exemplary hardware structure of the urban lighting facility management system in an embodiment of the present application. DETAILED DESCRIPTION

[0029] The terms used in the following embodiments of the present application are only for the purpose of describing specific embodiments, and are not intended to be used as limitations to the present application. As used in the specification and appended claims of the present application, the singular expressions "one", "a kind of", "said", "above", "the" and "this" are intended to also include plural expressions, unless there is a clear indication to the contrary in the context. It should also be understood that the term "and / or" used in the present application refers to and includes any or all possible combinations of one or more listed items.

[0030] In the following, the terms "first" and "second" are used for descriptive purposes only and are not to be understood as suggesting or implying relative importance or implicitly indicating the number of the indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the features, and in the description of the embodiments of the present application, unless otherwise specified, "plurality" means two or more.

[0031] A method for managing urban lighting facilities, comprising:

[0032] S101, receiving framework data set by a user through a facility asset configuration unit, the framework data including lighting facility asset type, specification and hierarchical structure data;

[0033] Among them, the facility asset configuration unit represents a functional module for users to personalize facility asset related information, and the framework data refers to a group of data containing key information of specific facility assets, which is used to represent a data set that can define the basic situation of facility assets.

[0034] In some embodiments, the scene is generally in the background configuration interface of the facility management system. After the user logs in to the system as an administrator, he enters a special facility asset configuration page. In this page, a set of default configurations will be provided for user reference and use when the system is initialized. These default configurations cover common lighting facility types, general specification parameters, and simple hierarchical structure examples. However, the user can choose to delete the default configuration according to the actual management structure and needs, and enter or select a customized lighting facility asset type (such as adding a certain type of smart street light with special functions), lighting facility asset specifications (fill in unique power, height, control method and other parameters) by operating in the corresponding input box, drop-down menu, graphical editing area and other interactive components, and customize the management hierarchy structure of facility assets by dragging, checking, hierarchical tree editing, etc. (such as setting the lighting facility hierarchy according to new commercial areas, residential areas, parks and other regional divisions), so as to accurately classify and manage lighting facility assets, and provide accurate and actual basic data for subsequent regional lighting planning, facility maintenance scheduling, energy consumption statistics and other operations.

[0035] S102, using the area management unit to collect user-defined custom area and custom road information, and constructing corresponding area and road data in a geographic database according to the levels of the custom area and custom road information, the geographic database including area and road data sets of different levels;

[0036] Among them, the regional management unit refers to the functional module responsible for processing and managing regional and road related information, and refers to the specific unit in the system that is responsible for collecting and constructing regional and road data.

[0037] In some embodiments, after the regional management unit is started, two methods of entering regional and road information are provided to the user: for administrative regions and roads, the user can click the automatic identification and import button on the system interface, and the system will use the pre-connected geographic information system (GIS) data interface to automatically obtain and identify the administrative region boundaries and public road network information in the current area, and quickly import it into the system; for user-defined regions and roads, the user can use manual operations such as mouse clicks, dragging, and drawing lines on the map drawing tool interface provided by the system to outline the boundary range of the custom area, and fill in the name, attributes and other information of the area in the pop-up information editing box. For custom roads, draw the road direction, starting and ending points in the road drawing tool, and mark detailed information such as road name, width, and direction of travel. After completion, submit and enter into the system. After obtaining this information, the regional management unit constructs the corresponding area and road data in the geographic database according to its hierarchical relationship and geographic coordinate information, using its own data processing algorithm and storage logic, and associates it with the lighting facility assets previously entered through the facility asset configuration unit, and establishes a mapping relationship between the lighting facilities and the areas and roads where they are located, thereby realizing the regional road section management and statistical functions of the lighting facility assets, and providing accurate geographic positioning and regional classification basis for subsequent lighting facility maintenance scheduling, energy consumption analysis, troubleshooting and other operations.

[0038] S103, using a batch data import unit to import geographic information data files, wherein:

[0039] S104, reading the header information of the geographic information data file, and displaying the header information together with the facility asset category, specification, region and road data in a preset import interactive interface;

[0040] It should be noted that geographic information data files are a general term for a type of file. Here, in order to fully explain the specific process, the geographic information data file mentioned specifically refers to one of the most basic sub-file units, and the operations and descriptions in the subsequent steps are all centered around this specific sub-file.

[0041] The header information refers to the text information located in the first row of the geographic information data file for describing the content of each column of data. It refers to the identification content that can summarize the meaning of each column of data and is used to indicate the data attributes of the corresponding column.

[0042] In some embodiments, the scene is usually in the middle of the data import process, which is used to let users clearly understand the data situation for accurate operation. Specifically, the system calls the corresponding reading module to extract the header information of the imported geographic information data file, and then displays the header information and the facility asset category, specification, area and road data obtained from the previous step in a pre-set import interactive interface according to a certain layout (for example, the header information is displayed in the form of table column titles, and other data is displayed in the corresponding row or column position), so that users can intuitively view the data and prepare for subsequent related operations.

[0043] S105, monitoring the interactive operation events between the user and the import interactive interface, and when the user performs an association operation on the header information and the facility asset category, specification, region and road data, determining the association relationship between the header information and the facility asset category, specification, region and road data;

[0044] In some embodiments, the system activates a monitoring function and pays real-time attention to the user's every move on the import interactive interface. Once the user performs association operations such as clicking, checking, dragging, etc. on the header information and facility asset categories, specifications, areas and road data, the system can capture the corresponding interactive operation events in a timely manner, and then determine the association relationships intended to be established by these operations based on corresponding algorithms and rules, and accurately determine the association relationships between the header information and each data.

[0045] S106, querying whether the geographic information data file has been configured according to the association relationship;

[0046] Among them, configuration refers to whether the geographic information data file (that sub-file) has been previously set up, associated, and operated with related facility assets, regional roads, and other data in accordance with certain rules and requirements. It is used to indicate a historical processing status of the file. For example, whether certain fields in its header information have been associated with specific facility asset categories falls into the category of configuration.

[0047] In some embodiments, this step is performed after the association between the header information and the relevant data is determined. In order to further verify the historical configuration of the geographic information data file (that sub-file) and better perform subsequent data processing operations, the scenario is generally in the link of data accuracy verification in the data import process. Specifically, the system calls the database query module based on the association just determined, uses the association as the query condition, and searches the relevant database (such as the database storing the data configuration history record) to check whether there is a configuration record corresponding to the geographic information data file (that sub-file), so as to determine whether the geographic information data file (that sub-file) has been configured, and provide a basis for subsequent decisions on whether to perform storage, update, and other operations.

[0048] It should be noted that association and configuration have two different meanings. From the perspective of operational behavior, association is mainly to determine the relationship between geographic information data files and related facility assets, regional roads and other data, just like the action of establishing logical associations between specific information and other data in this process; while configuration involves a series of complex setting processes such as planning the storage location of geographic information data files according to established associations, generating identification marks, and integrating attribute lists.

[0049] S107, storing the unconfigured geographic information data file in the configuration database and the regional road section database according to the association relationship, and obtaining the corresponding first identification mark;

[0050] The first identification mark refers to a specific mark assigned by the system to distinguish and uniquely identify those newly stored unconfigured geographic information data files (that sub-file), so as to accurately identify and reference these files in subsequent operations.

[0051] It should be noted that the reason why there are unconfigured geographic information data files is that the data and corresponding configuration information associated with some geographic information data files have never appeared in the previous operation of the system; or these data have not been stored in the existing attribute list, resulting in the system being unable to find matching configuration items when configuring according to the existing process, and thus causing the configuration operation to fail to complete smoothly, ultimately resulting in unconfigured geographic information data files.

[0052] In some embodiments, specifically, after the system screens out unconfigured geographic information data files, it stores the relevant data of these files in appropriate locations in the configuration database and the regional road section database according to the previously determined association relationships. During the storage process, the system will generate a corresponding first identification mark for each unconfigured geographic information data file, so that the file can be quickly and accurately located in subsequent operations such as searching, calling, and associating with other data. Through such storage and identification operations, these unconfigured files can be integrated into the data management system of the entire system, which is convenient for subsequent further data processing and application.

[0053] S108, integrating the asset type and its associated attribute list into a key-value pair set, wherein the key is the first identification identifier and the value is the corresponding attribute list;

[0054] The attribute list refers to a list consisting of other attribute information other than facility asset category, specification, region and road data associated with the geographic information data file.

[0055] In some embodiments, the system extracts the asset type and its associated attribute list from the stored relevant data, and then integrates them into a key-value pair set according to the set rules, using the first identification identifier as the key and the corresponding attribute list as the value. Through such integration operations, subsequent operations on various attributes of the geographic information data file can be more efficiently searched, compared, and processed based on this clear data structure, providing convenience for improving the entire data management system.

[0056] S109, searching the pre-stored attribute list corresponding to each key according to the key-value pair set, comparing and matching the key with the value, inserting the attribute not existing in the pre-stored attribute list into the corresponding pre-stored attribute list, and obtaining the corresponding second identification mark;

[0057] Among them, the pre-stored attribute list refers to a list of some attribute information that already exists in the geographic information data file and is pre-stored by the system in a database or other location. It is used to represent the attribute data set that already existed before the current comparison and matching operation. For example, the common attribute list for some geographic information data files previously organized and saved in the system belongs to the pre-stored attribute list.

[0058] It should be noted that before step S106, the geographic information data file is configured according to the pre-stored attribute list.

[0059] In some embodiments, the system searches for the pre-stored attribute list corresponding to each key (first identification identifier) ​​one by one based on the key-value pair set, and then compares and matches the value (attribute list) in the key-value pair set with the pre-stored attribute list. By comparing, the system finds out the attributes that do not exist in the pre-stored attribute list, and inserts these attributes into the corresponding pre-stored attribute list to expand and improve the content of the pre-stored attribute list. In this process, the system will generate corresponding second identification identifiers for those geographic information data files with attribute updates, so as to facilitate subsequent targeted operations and management of these updated files.

[0060] S110, combining the geographic information data file according to the first identification identifier and the second identification identifier.

[0061] In some embodiments, the system combines various parts of the geographic information data file based on the first identification identifier and the second identification identifier through corresponding database operations, data association algorithms, etc., to form a complete geographic information data file containing the latest and accurate information, so that subsequent operations such as query, statistics, and analysis can be efficiently processed based on this complete file, thereby improving the management and application level of the entire system for geographic information data.

[0062] It can be seen that the facility asset configuration unit receives the framework data set by the user, clarifies the asset type, specification and hierarchical structure of the lighting facilities, and lays the foundation for subsequent management. The custom area and road information collected by the regional management unit constructs the regional and road data set in the geographic database. In the batch data import unit operation, when the geographic information data file is imported using the batch data import unit, the header information of the geographic information data file is read, and it is displayed together with the facility asset category, specification, area and road data in the import interactive interface, which provides users with a clear data overview and association basis. The interactive operation events between the user and the import interactive interface are monitored to determine the association relationship between the header information and various types of data. This association method based on user interaction has greater flexibility. When facing data that is not in the preset template type, the system can still accurately identify its category and logical relationship based on the user's association operation. For unconfigured files, they are stored in the configuration database and the regional section database according to the determined association relationship, and the corresponding first identification identifier is obtained, ensuring that the new data can be incorporated into the management system in an orderly and accurate manner. Subsequently, the asset type and its associated attribute list are integrated into a key-value pair set, and the attributes that do not exist in the pre-stored attribute list are inserted into the corresponding list by comparison and matching with the pre-stored attribute list, and the second identification mark is obtained, which further improves and refines the storage and integration of data. In this way, not only can data that is not in the preset template type be smoothly imported, but these data can also be integrated with the existing data system, ensuring the integrity and consistency of the data, providing comprehensive and accurate data support for urban lighting facility management, and improving the management system's ability to accept and process diversified data.

[0063] In some embodiments, after step S110, the method further includes:

[0064] S201, presenting the geographical location of urban lighting facilities on the display interface according to the user's interaction on the GIS map unit;

[0065] Among them, the GIS map unit represents a functional module that integrates the functions of the geographic information system (GIS) and can display geographic spatial data and realize geographic-related interactive operations. It refers to the specific unit that undertakes the map visualization and interactive functions in the entire system.

[0066] In some embodiments, the system needs to present the integrated data to the user in a visual way, so that the user can intuitively understand the distribution of urban lighting facilities. This scenario is often seen when the user is managing urban lighting facilities, maintaining the plan, or viewing the layout of lighting facilities. Specifically, the system is in a state of waiting for the user to interact with the GIS map unit. When the user interacts by clicking the mouse, scrolling the wheel to zoom the map, dragging the map for translation, etc., the GIS map unit will obtain the corresponding geographical range and other information in real time according to the user's operation, and then accurately mark and present the geographical location of the urban lighting facilities in the corresponding area on the display interface based on the geographical coordinate data of the urban lighting facilities stored in the system background and the association with the geographic database (for example, the location of lighting facilities such as street lights and landscape lights is displayed in the form of icons, and different types of lighting facilities can be distinguished by icons of different colors and sizes), so that users can clearly see the specific distribution of lighting facilities in the city.

[0067] S202, in response to a filtering instruction triggered by a user in a GIS map unit, filtering out corresponding urban lighting facilities according to the filtering instruction, and updating a display interface;

[0068] In some embodiments, when the user has viewed the geographic location of urban lighting facilities through step S201 and has a need to further filter out specific lighting facilities from numerous lighting facilities, the scenario is often that the user needs to focus on, analyze and count lighting facilities of a specific type, a specific parameter range or a specific area. Specifically, the system continuously monitors the user's operations in the GIS map unit. When the user triggers a filtering instruction (for example, entering filtering conditions such as the lighting facility type, power range, and location in the filtering box that pops up on the interface, and then clicking the "OK" button), the system receives the filtering instruction, first parses the instruction content, and clarifies the filtering conditions set by the user (such as the specific type of lighting facility, power value range, etc.), and then performs data filtering operations in the database storing urban lighting facility data (such as the configuration database, etc.) based on the parsed filtering conditions (through database query statements, according to the conditions, filtering out lighting facility records that meet the requirements). After filtering out the corresponding urban lighting facilities, the data of these lighting facilities are reorganized and sorted, and then the content on the display interface is updated according to the display rules of the display interface (such as coordinate position corresponding to map position, icon style corresponding to facility type, etc.), and lighting facilities that do not meet the filtering conditions are hidden or removed, and only lighting facilities that meet the conditions and their geographical locations and other information are displayed, so that users can focus on viewing specific lighting facilities.

[0069] S203. In response to the user's dragging or box selection operation on the city lighting facility icon in the GIS map unit, modify the first identification identifier and the second identification identifier according to the geographic database; and update the display interface.

[0070] In some embodiments, the system monitors in real time the dragging or selection operations performed by the user on the city lighting facility icons in the GIS map unit. When the user performs a dragging operation (such as dragging a street light icon from one side of the road to the other), the system determines the position change of the lighting facility based on the geographic coordinate information corresponding to the icon and the lighting facility location range and other data stored in the geographic database, and then determines that the associated first identification mark and second identification mark need to be modified (which may involve updating the identification content related to the location attribute); when the user performs a selection operation (for example, selecting multiple landscape light icons in an area), the system determines the lighting facilities within the selection range based on the lighting facility coordinate information stored in the geographic database, and then makes corresponding modifications to the first identification mark and the second identification mark based on the identification information corresponding to these lighting facilities and the system preset rules (such as selecting may mean that these facilities need to be uniformly managed and adjusted, and the identification needs to be updated to reflect the new management attributes, etc.). After completing the identification modification, the system will update the modified identification information back to the corresponding lighting facility record in the geographic database, and update the display interface at the same time, and update the position of the lighting facility icon on the display interface (if it is a drag operation) or the display style (if there are attribute-related modifications, etc.) so that users can intuitively see the effect of the operation.

[0071] It can be seen that the user's interactive operation on the GIS map unit has brought great convenience. The geographical location of urban lighting facilities is presented according to user interaction, so that managers can intuitively understand the distribution of facilities, which is convenient for planning and maintenance. Responding to the filtering command to filter facilities and update the display interface can quickly focus on specific facilities, such as quickly finding faulty street lights in a certain area, improving the efficiency of troubleshooting. When the user drags or selects the facility icon, the identification mark is modified and updated according to the geographic database, which can reflect the location or status changes of the facility in real time, ensure that the map information is synchronized with the actual situation, enhance the dynamic and timely nature of management, and optimize the visual management experience of urban lighting facilities.

[0072] In actual application scenarios, GIS map units have the following functions:

[0073] Lighting facility assets can be filtered based on their type, specifications, location, and usage status, allowing users to quickly focus on lighting facilities under specific conditions.

[0074] It supports users to manually draw a range of any shape on the map, so as to conduct detailed statistical analysis on the lighting facilities within the range; at the same time, it can also automatically conduct statistics on the lighting facilities within the corresponding range based on the area and road data preset by the system.

[0075] Allow users to perform fuzzy searches by asset number or asset name. Regardless of whether the user enters a full name or partial keyword, the system can quickly locate the relevant lighting facilities and clearly mark their locations on the map.

[0076] Users can use the drag tool on the map to accurately move a single lighting facility, or select multiple lighting facilities at once through a box selection operation to achieve batch movement.

[0077] It provides automatic wiring tools that can automatically plan and deploy cable routing based on factors such as the distribution of lighting facilities, geographical terrain, and power supply requirements. It can also automatically associate distribution cabinets and light poles to ensure the rationality and stability of the power supply system.

[0078] It supports users to batch copy existing lighting facility assets in the map, and after the copying is completed, the copied assets can be easily moved and adjusted in batches to meet the layout requirements of different areas; at the same time, the properties of multiple copied assets can be modified in batches at one time (such as modifying the asset type, specifications, usage status, etc.).

[0079] In some embodiments, after step S110, the method further includes:

[0080] S301. Use a batch data management unit to perform batch operations on the imported geographic information data files, including: batch modifying asset attributes, batch modifying asset icons, batch modifying asset names, batch adding subsidiary assets, and batch modifying asset basic information.

[0081] It can be seen that using the batch data management unit to perform batch operations on imported geographic information data files improves management efficiency. The batch modification of asset attributes, icons, names and other functions can process a large amount of similar data at one time, avoiding the tediousness of modifying them one by one.

[0082] In some embodiments, after step S110, the method further includes:

[0083] S401, in response to the user's instruction in the data statistics unit, providing multiple data sources, attribute lists, and preset algorithms for display;

[0084] In some embodiments, the data statistics unit of the system is in a state of waiting for user operation instructions. When the user issues an instruction by clicking a corresponding button on the operation interface (such as a "view data source" button), selecting a drop-down menu option (such as selecting "display all available attribute lists"), or entering specific instruction content (such as entering keywords to trigger the display of related preset algorithms), the system receives the instruction and extracts the corresponding multiple data sources, attribute lists, and preset algorithm related information from various locations stored in the system (such as different data tables in the database storing data sources, special attribute configuration files storing attribute lists, and algorithm libraries storing preset algorithms). Then, it displays them on the operation interface according to certain display rules (such as displaying the data source name in list form, presenting the attribute list content in table form, and displaying the logic and application scenarios of the preset algorithm in the form of text descriptions and examples), so that users can intuitively view and understand these basic elements that can be used for subsequent statistical analysis.

[0085] S402, collecting statistical data according to the data source, attribute list, and preset algorithm selected by the user;

[0086] S403: Output statistical results.

[0087] It can be seen that in response to the user's instructions in the data statistics unit, the system provides multiple data sources, attribute lists and preset algorithms for display, and calculates the data and outputs the results accordingly. This flexible statistical method breaks the limitations of statistics in the traditional model. Users can freely choose data sources and algorithms according to actual needs and obtain the required data.

[0088] In actual application scenarios, the data statistics unit has the following functions:

[0089] In order to meet the user's personalized needs for statistical display, users can upload statistical item display icons that suit their own preferences, so that they can more intuitively identify and distinguish different statistical items when displaying statistical results; at the same time, they can also choose from a series of display icons pre-provided by the system by default, so as to quickly complete the icon configuration work, making the presentation of statistical results clearer, more eye-catching and in line with the user's visual habits.

[0090] Used to clarify the data source on which the statistical results rely. Users have a rich variety of data sources to choose from here, including but not limited to the number of lighting facility asset types, which helps to understand the distribution of different types of lighting facilities; the number of lighting facility asset specifications, which can help users understand the proportion of lighting facilities of various specifications; lighting facility asset basic attributes, such as the installation location of lighting facilities, the area to which they belong, and other basic information, which can provide support for further data analysis; lighting facility asset type attributes, such as specific types of attributes such as the lighting range of street lights and the lighting color of landscape lights, can be used to deeply explore the characteristics of different types of lighting facilities; and lighting facility asset specification attributes, such as the height attributes of street light poles and the power attributes of light bulbs, can help to conduct targeted analysis of lighting facilities of specific specifications. In addition, it is worth noting that in one statistical item, users can select multiple data sources at the same time to obtain comprehensive and integrated statistical information from multiple dimensions, thereby gaining a deeper insight into the laws and trends behind the data.

[0091] It is to define the specific algorithm used by the system when calculating the statistical results of the data. The system provides users with a variety of practical optional algorithms, such as the accumulation algorithm, which is suitable for summing up the total amount of certain data, such as counting the total power of all lighting facilities in a certain area; the mean algorithm, which can be used to calculate the average level of data, such as calculating the average service life of lighting facilities in different sections of the road; the enumeration algorithm, for some data with specific discrete values, can clearly list all possible value situations, such as counting different brands of lighting facilities; the percentage algorithm, which is often used to express the proportional relationship between the part and the whole, such as calculating the percentage of a certain type of lighting facilities in all lighting facilities. Through these diverse algorithm options, users can flexibly choose the most suitable algorithm to obtain targeted statistical results based on actual analysis needs.

[0092] The data type used to clarify the statistical items is crucial for the system to accurately process and display data. Users can choose from a variety of optional data types, including integers, which are suitable for representing discrete integer values ​​such as the number of lighting facilities; floating point types, which are often used to represent data with decimal parts, such as the power and brightness of lighting facilities, which may have decimal values; text types, which can be used to describe some non-numerical information, such as the name and model of lighting facilities; percentage types, which are mainly used to present proportional data, such as the various proportions mentioned above.

[0093] After the user has made reasonable settings for the above configurations, the system will automatically process the corresponding data sources efficiently based on the algorithms and data types selected by the user. Through a series of complex and precise calculations, screening, conversions and other operations, it will ultimately generate and present the accurate and valuable statistical content that the user expects.

[0094] In addition to supporting user-defined statistics, the system also displays a series of practical statistical items by default, such as the statistics of the service life of lighting facility assets, which is of great significance for evaluating the aging degree and maintenance needs of lighting facilities; regional lighting facility asset statistics, which can help users understand the distribution density and resource allocation of lighting facilities in different regions; road lighting facility asset statistics, which can help analyze the coverage and operating status of road lighting facilities; lighting facility asset type and specification statistics, which can help to grasp the composition of the entire lighting facility assets at a macro level. In addition, users can also further configure these default statistical items to meet their specific analysis needs, so that the system's statistical functions are more in line with actual application scenarios, and provide users with more comprehensive, in-depth and data analysis support.

[0095] In some embodiments, step S403 specifically includes:

[0096] S4031. Use the style and layout of the report obtained by the data export unit;

[0097] S4032. Obtain the user's check on the statistical results or add modifications to the statistical results, and output them.

[0098] The data export unit supports users to perform personalized custom export operations on lighting facility asset details and summary statistical data within the system, and can record the export templates set by users for subsequent reuse.

[0099] In terms of report style and layout, users can freely design and customize the format of exported reports according to their actual needs and aesthetic preferences, including but not limited to the adjustment of various elements such as font, font size, color, table layout, chart style, etc., to ensure that the exported reports can present data information in a clear, beautiful and easy-to-read form to meet diverse usage scenarios and display requirements.

[0100] At the same time, the unit provides users with a data filtering function. Users can directly filter data in the system according to various conditions (such as the type, specifications, location, usage status, etc. of lighting facilities) and quickly locate the required data subset for export; they can also conveniently check the statistical items that have been pre-configured in the statistical configuration, and flexibly add new statistical items according to specific analysis needs, so as to flexibly customize the statistical content in the custom report, ensure that the exported data can reflect the key information of users' concern, and realize highly targeted data extraction and output.

[0101] In addition, the system supports real-time preview for exported detailed reports and summary statistical reports. Users can intuitively view the presentation effect of the report before exporting, and can make instant adjustments to the contents of the report based on the preview, such as data sorting, field display and hiding, and chart detail optimization.

[0102] After completing the report export, the user can also save the currently used export template so that when a report with similar format and content needs to be exported in the future, the report can be easily exported with one click according to the template, which greatly improves work efficiency, reduces repetitive operations, and makes data export easier, faster and more efficient.

[0103] It can be seen that in the step of outputting statistical results, the data export unit is used to obtain the style and layout of the report, and the report is modified and output according to the user's selection or addition of statistical results. This makes report generation more flexible and personalized to meet the needs of different users and scenarios. Managers can customize the report content and format according to the reporting object and purpose to highlight key data. This customized output improves the readability and usability of the data.

[0104] It should be noted that steps S104 to S110 are described based on a geographic information data file or a process. However, in actual use, when multiple processes simultaneously execute the import and associated operation flow of geographic information data files, the following data consistency and operation order dependency problems may arise.

[0105] Due to the concurrent execution of multiple operations, if one operation is completed quickly, it modifies the pre-stored attribute list in the step of inserting the attributes that do not exist in the pre-stored attribute list into the corresponding pre-stored attribute list, while the other operation has only completed the previous part of the steps at this time, and has not yet reached the stage of comparison and matching with the modified pre-stored attribute list, and still queries whether the geographic information data file has been configured according to the pre-stored attribute list before being modified. Then, when this operation subsequently reaches the comparison and matching step, the state of the pre-stored attribute list on which it is based is inconsistent with the actual situation (modified by other operations that have been completed first), which will cause errors in attribute comparison, and may misjudge the attributes that should have been correctly inserted as existing, or repeatedly insert attributes that actually exist but are considered non-existent due to failure to update the judgment basis in time, thereby causing data inconsistency problems, destroying the integrity and accuracy of the lighting facility asset data in the system, and further affecting the reliability and effectiveness of subsequent management, statistics, analysis and maintenance operations based on these data.

[0106] Therefore, in some embodiments, step S106 is replaced by:

[0107] S1061, querying whether the geographic information data file has been configured according to the association relationship and the pre-stored attribute list;

[0108] In some embodiments, the scenario is generally in the link of data accuracy verification in the data import process, which is more critical especially when there are multiple operations executed concurrently and there may be a risk of data inconsistency. Specifically, the system calls the database query module based on the association relationship just determined and the pre-stored attribute list obtained, and uses the relevant characteristic information of the association relationship and the pre-stored attribute list as the query condition (such as the correspondence between the key fields involved in the association relationship, and the value range of specific attributes in the pre-stored attribute list, etc.), and searches in the relevant database (such as the database storing the data configuration history record) to see whether there is a configuration record corresponding to the geographic information data file, so as to determine whether the geographic information data file has been configured, and provide a basis for subsequent decisions on whether to perform storage, update and other operations. In addition, by querying together with the pre-stored attribute list, it can better deal with data inconsistency problems that may be caused by concurrent operations, and ensure that the query results are consistent with the current actual data status.

[0109] S1062, recording the current version number of the pre-stored attribute list;

[0110] Among them, the current version number of the pre-stored attribute list refers to the number used to uniquely identify the state of the pre-stored attribute list at a specific moment. It is used to indicate the update status and version change of the pre-stored attribute list, so that the system can judge whether it is the latest state in subsequent operations. For example, in the initial state, the version number is set to 1. After each update operation with substantial content modification, the version number increases by 1. For example, after an operation of adding a new attribute, the version number becomes 2, and so on.

[0111] In some embodiments, the purpose is to accurately know the state changes of the pre-stored attribute list in subsequent operations, especially in scenarios where multiple concurrent operations may cause data inconsistency, so that the system can judge the timeliness and accuracy of the data based on the version number. Specifically, after completing the query operation of S1061, the system will start the version management mechanism, and determine whether the current pre-stored attribute list has been updated through a specific algorithm or rule (for example, judging whether it is a new version based on the change of the hash value of the content of the pre-stored attribute list, the increase or decrease of the key attribute, etc.), and if there is an update, it will be assigned a new current version number according to the established numbering rules (such as sequentially increasing digital numbering, etc.), and then the version number will be stored in a database table or data structure specifically used to record version information (for example, a version record table is created, including the name of the pre-stored attribute list, version number, update time and other fields), so that when performing subsequent operations such as comparison and matching, the version number can be checked first. If the version is inconsistent, it will prompt that there may be a risk of data inconsistency or trigger the operation of re-obtaining the latest pre-stored attribute list, so as to ensure the accuracy and consistency of the entire data processing process.

[0112] Step S109 is replaced by:

[0113] S1091, searching for a pre-stored attribute list of the current version number;

[0114] In some embodiments, the system will call the database query module (if the pre-stored attribute list is stored in the database) or the corresponding data search mechanism (if it is stored in other data structures) based on the recorded current version number information, and use the current version number as the key query condition to search and search the location where the pre-stored attribute list is stored (such as a special attribute data table, configuration management data area, etc.), and locate and obtain the pre-stored attribute list corresponding to the current version number from the pre-stored attribute list of many versions by matching the version number field (if there is a corresponding version number field in the database to identify different versions of the list) or according to established version identification rules (such as an index structure generated according to the version number, etc.), so as to prepare for subsequent comparison and matching operations with the key-value pair set.

[0115] S1092. According to the key-value pair set, search the pre-stored attribute list of the current version number corresponding to each key, compare and match the value, and insert the attributes that do not exist in the pre-stored attribute list of the current version number into the pre-stored attribute list of the corresponding current version number.

[0116] In some embodiments, the system extracts the keys (i.e., the first identification identifier) ​​one by one based on the key-value pair set, and then uses the data query mechanism to find the corresponding pre-stored attribute list of the current version number for each key (located through the previous association relationship or the corresponding relationship in the storage structure), and then compares and matches the value corresponding to the key in the key-value pair set (i.e., the attribute list) with the pre-stored attribute list of the current version number found, and finds out the attributes that do not exist in the pre-stored attribute list of the current version number by comparing the name, type, value, etc. of the attributes one by one. Then, according to the storage rules set by the system (such as determining the insertion position according to the classification and importance of the attributes, or according to a unified order of addition, etc.), these attributes are inserted into the pre-stored attribute list of the corresponding current version number, thereby realizing the update and improvement of the pre-stored attribute list, and providing strong support for subsequent operations such as statistics and analysis based on accurate and complete data.

[0117] It can be seen that the version number mechanism is introduced in data association and insertion operations. The current version number of the pre-stored attribute list is recorded, and the search and comparison are based on this, which effectively solves the problem of data inconsistency caused by multiple concurrent operations. When an operation modifies the pre-stored attribute list, the subsequent operation can accurately obtain the latest and consistent list for comparison through the version number, avoiding attribute comparison errors caused by inconsistent list status, preventing repeated insertion or misjudgment of data, and ensuring the integrity and accuracy of lighting facility asset data.

[0118] Although the above embodiment can solve the problem of data inconsistency in concurrent execution of multiple operations, a new problem also arises, that is, the problem that the pre-stored attribute list will not be updated.

[0119] Therefore, in some embodiments, after step S1092, the method further includes:

[0120] S1093, after a preset time, suspending the step of importing geographic information data files using a batch data import unit;

[0121] In some embodiments, according to the overall data processing strategy of the system, it is necessary to temporarily stop the import of new data in order to leave time for the integration and aggregation of existing data. This scenario is often seen when the system is in a stage of frequent data updates. It is necessary to ensure the normal import of new data and to ensure that the existing data structure (such as the pre-stored attribute list) can be updated in time and maintain data consistency. For example, when a large number of geographic information data files are imported one after another and the pre-stored attribute list needs to be integrated and updated according to different versions at the same time. Specifically, the system starts timing after completing the relevant data operation. When the preset time is reached, the system will send an instruction to the batch data import unit to trigger its pause mechanism, so that the step of importing geographic information data files that is in progress or about to be carried out is stopped. At this time, the batch data import unit will suspend the subsequent processes such as receiving new file selection operations and stopping the reading and verification of the selected files, and maintain the current state to wait for further instructions. In this way, time is freed up for the subsequent summary update operation of the pre-stored attribute list, avoiding the interference of the new data import process with the data integration and update process.

[0122] S1094: After the pause, the pre-stored attribute lists of different version numbers are summarized and updated;

[0123] In some embodiments, the system first extracts all pre-stored attribute list data of different version numbers from a database or data structure storing pre-stored attribute lists (such as a special attribute list storage area, classified and stored according to version numbers), and then analyzes these different versions of attribute lists one by one through data comparison, screening, merging and other related modules according to established summary update rules (such as sorting according to the importance of attributes, judging the uniqueness according to the attribute name, etc.), extracts the newly added valid attributes in each version, and merges them into a new temporary attribute list. At the same time, duplicate attributes are deduplicated, and conflicting attributes (such as different versions of the same attribute have different values) are processed according to pre-set conflict resolution rules (such as taking the value of the latest version or according to the majority principle, etc.), and finally a complete and updated pre-stored attribute list is formed, and then stored back to the original storage location to replace the previous old version list, thereby realizing the summary update of the pre-stored attribute list, laying a foundation for the subsequent system to perform various operations based on accurate and comprehensive data.

[0124] S1095. After updating, start the step of importing geographic information data files using a batch data import unit.

[0125] In some embodiments, after completing a round of data integration, in order not to affect normal data collection work, the import function of geographic information data files should be restored in time. Restart all operation links related to importing geographic information data files, start receiving new geographic information data file selection operations, perform format verification on the selected files, read the content, and import them into the corresponding storage area in the system according to the established storage path and rules, so that the system can continue to normally obtain geographic information data from the outside, maintain dynamic data updates and the consistency of business processes.

[0126] It can be seen that after the pause, the pre-stored attribute lists of different version numbers are summarized and updated, which can centrally sort out and integrate various data changes and differences generated during the concurrent operation of multiple users. It ensures that the pre-stored attribute lists based on subsequent operations are the latest and complete versions, so that the data can maintain a high degree of consistency and accuracy in the entire management system.

[0127] The following introduces an exemplary urban lighting facility management system 300 provided in an embodiment of the present application. Figure 3 It is a schematic diagram of an exemplary hardware structure of the urban lighting facility management system 300 provided in an embodiment of the present application.

[0128] In some embodiments, the city lighting facility management system 300 is a computer device or the city lighting facility management system 300 includes a computer device. The computer device includes a processor, a memory and a network interface connected via a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data. The network interface of the computer device is used to communicate with other external terminals or servers through a network connection. In some embodiments, the network interface can be a wired network interface, and in some embodiments, the network interface can also be a wireless network interface. When the computer program is executed by the processor, the method in the embodiment of the present application is implemented.

[0129] Those skilled in the art will understand that Figure 3 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0130] As described above, the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present application.

[0131] As used in the above embodiments, the term "when..." may be interpreted to mean "if..." or "after..." or "in response to determining..." or "in response to detecting...", depending on the context. Similarly, the phrases "upon determining..." or "if (the stated condition or event) is detected" may be interpreted to mean "if determining..." or "in response to determining..." or "upon detecting (the stated condition or event)" or "in response to detecting (the stated condition or event)", depending on the context.

[0132] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented using software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When the computer program instructions are loaded and executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions may be transmitted from one website site, computer, server or data center to another website site, computer, server or data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line) or wireless (e.g., infrared, wireless, microwave, etc.) means. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server or data center that includes one or more available media integrated. The available medium may be a magnetic medium (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid-state hard disk), etc.

[0133] Those skilled in the art can understand that to implement all or part of the processes in the above-mentioned embodiments, the processes can be completed by computer programs to instruct related hardware, and the programs can be stored in computer-readable storage media. When the programs are executed, they can include the processes of the above-mentioned method embodiments. The aforementioned storage media include: ROM or random access memory RAM, magnetic disk or optical disk and other media that can store program codes.

Claims

1. A method for managing urban lighting facilities, characterized in that: include: Receiving, through a facility asset configuration unit, framework data set by a user, the framework data including lighting facility asset type, specification, and hierarchical structure data; Using the area management unit to collect user-defined custom areas and custom road information, and constructing corresponding area and road data in a geographic database according to the levels of the custom areas and the custom road information, the geographic database containing area and road data sets at different levels; Use the batch data import unit to import geographic information data files, including: Reading the header information of the geographic information data file, and displaying the header information together with the facility asset category, the specification, the region and the road data in a preset import interactive interface; monitoring the interactive operation events between the user and the import interactive interface, and determining the association relationship between the header information and the facility asset category, the specification, the region, and the road data when the user performs an association operation on the header information and the facility asset category, the specification, the region, and the road data; Query whether the geographic information data file has been configured according to the association relationship; The unconfigured geographic information data file is stored in the configuration database and the regional road section database according to the association relationship, and the corresponding first identification mark is obtained; Integrate the asset type and its associated attribute list into a key-value pair set, wherein the key is the first identification identifier and the value is the corresponding attribute list; According to the key-value pair set, search the pre-stored attribute list corresponding to each key, compare and match the value, insert the attribute that does not exist in the pre-stored attribute list into the corresponding pre-stored attribute list, and obtain the corresponding second identification mark; According to the first identification mark and the second identification mark, various parts of the geographic information data file are combined through the corresponding database using a data association algorithm to form a geographic information data file.

2. The method according to claim 1, characterized in that After the step of importing geographic information data files by using the batch data import unit, the method further includes: Based on the user's interaction on the GIS map unit, the geographical location of the city lighting facilities is presented on the display interface; In response to a filtering instruction triggered by a user in the GIS map unit, corresponding urban lighting facilities are filtered out according to the filtering instruction, and a display interface is updated; In response to the user's dragging or framing operation on the city lighting facility icon in the GIS map unit, the first identification mark and the second identification mark are modified according to the geographic database; and the display interface is updated.

3. The method according to claim 1, characterized in that The step of querying whether the geographic information data file has been configured according to the association relationship specifically includes: Querying whether the geographic information data file has been configured according to the association relationship and the pre-stored attribute list; Recording the current version number of the pre-stored attribute list; The step of searching the pre-stored attribute list corresponding to each key according to the key-value pair set, comparing and matching the key with the value, and inserting the attribute not existing in the pre-stored attribute list into the corresponding pre-stored attribute list specifically includes: Find the pre-stored attribute list of the current version number; According to the key-value pair set, the pre-stored attribute list of the current version number corresponding to each key is searched, compared and matched with the value, and the attributes that do not exist in the pre-stored attribute list of the current version number are inserted into the pre-stored attribute list of the corresponding current version number.

4. The method according to claim 3, characterized in that Before the step of searching the pre-stored attribute list of the current version number corresponding to each key according to the key-value pair set, comparing and matching the value, and inserting the attribute not existing in the pre-stored attribute list of the current version number into the pre-stored attribute list of the corresponding current version number, the method further includes: After a preset time, pausing the step of importing geographic information data files by using the batch data import unit; After the pause, the pre-stored attribute lists of different version numbers are summarized and updated; After the update, the step of importing the geographic information data file using the batch data import unit is started.

5. The method according to claim 1, characterized in that After the step of importing geographic information data files by using the batch data import unit, the method further includes: Use the batch data management unit to perform batch operations on the imported geographic information data files, including: batch modification of asset attributes, batch modification of asset icons, batch modification of asset names, batch addition of affiliated assets, and batch modification of asset basic information.

6. The method according to claim 1, characterized in that After the step of importing geographic information data files by using the batch data import unit, the method further includes: In response to the user's instructions in the data statistics unit, multiple data sources, attribute lists, and preset algorithms are provided for display; Calculate statistics based on the data source, attribute list, and preset algorithm selected by the user; Output statistical results.

7. The method according to claim 6, characterized in that The step of outputting the statistical results specifically includes: The style and layout of the reports obtained using the data export unit; Get the user's check on the statistical results or add modifications to the statistical results and output them.

8. An urban lighting facility management system, characterized in that: The urban lighting facility management system includes: one or more processors and a memory; the memory is coupled to the one or more processors, the memory is used to store computer program code, the computer program code includes computer instructions, and the one or more processors call the computer instructions to enable the urban lighting facility management system to execute the method described in any one of claims 1-7.

9. A computer program product comprising instructions, characterized in that When the computer program product runs on a city lighting facility management system, the city lighting facility management system is enabled to execute the method according to any one of claims 1 to 7.

10. A computer-readable storage medium comprising instructions, characterized in that: When the instructions are executed on a city lighting facility management system, the city lighting facility management system is caused to execute the method according to any one of claims 1 to 7.

Images