Urban infrastructure coding method and device

Abstract

The invention relates to the technical field of city informatization management, and particularly provides a city infrastructure coding method and device, and the method comprises the following steps: S1, a user defines code segments in a system, the code segment types comprise an existing data code segment, a newly added data code segment, a mapping data code segment and a sequence code segment, and configures the length, format and value mode; s2, combining a plurality of code segments into a coding scheme according to a preset sequence, and setting separators and verification rules; s3, the user applies to use the starting and ending value interval of the sequence code segment, the administrator examines and approves the sequence code segment, and code uniqueness and orderliness during concurrent use are controlled; s4, selecting a source database table for storing facility data and a coding scheme, reading code segment authorization and generating a code, sequentially increasing a sequence code segment for each piece of data, and performing de-duplication processing; and S5, for the abandoned facility data, logically cancelling the corresponding codes, and recovering the codes when needed. Compared with the prior art, the method has the advantages that the operation and maintenance complexity of infrastructure coding is remarkably reduced, the automation degree of data management and the system expansion capability are improved, and the method has good engineering suitability and popularization value.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of urban information management, and particularly provides a method and device for coding urban infrastructure. BACKGROUND

[0002] With the acceleration of urban construction and the development of smart cities, the types of urban infrastructure are increasingly diversified, including roads, bridges, lamp poles, mountains, water conservancy facilities, etc. The data of various types of facilities are often distributed in different business systems and databases, and there is a lack of unified standards for their coding rules, data formats and management methods. The existing facility coding methods generally have the following problems:

[0003] (1) Dispersed and non-uniform coding rules: different departments or projects set their own coding rules, leading to coding conflicts, high duplication rates, and difficulty in cross-system data integration.

[0004] (2) Lack of flexible combination and expansion mechanism: existing solutions mostly use fixed rule coding generation methods, which cannot quickly adjust the coding structure or add new classification elements according to business changes.

[0005] (3) Insufficient data deduplication and lifecycle management: traditional methods lack effective uniqueness detection and historical tracking mechanisms in the aspects of adding, updating and canceling facility data, which can easily cause data redundancy and management confusion.

[0006] (4) Lack of permission and sequence control: when multiple people or departments simultaneously enter facility data, there is a lack of authorization management for coding sequence and usage range, which can easily cause conflicts.

[0007] Therefore, how to design a modularized configuration, support dynamic authorization, and have data deduplication and lifecycle management capabilities of urban infrastructure coding method and system has become a technical problem to be solved in the current smart city construction. SUMMARY

[0008] The present application is aimed at the deficiencies of the prior art, and provides a practical method for coding urban infrastructure.

[0009] The further technical task of the present application is to provide a device for coding urban infrastructure, which is rationally designed and safe and suitable for use.

[0010] The technical solution adopted by the present application to solve its technical problems is:

[0011] A method for coding urban infrastructure, comprising the following steps:

[0012] S1, a user defines one or more code segments in the system, the code segment types include existing data code segments, newly added data code segments, mapping data code segments and sequence code segments, and the length, format and value mode are configured;

[0013] S2. Combine multiple code segments into an encoding scheme in a predetermined order, supporting cross-facility type applications, and setting delimiters and verification rules;

[0014] S3. The start and end value range of the sequential code segment requested by the user shall be approved by the administrator to control the uniqueness and order of the encoding when using it concurrently;

[0015] S4. Select the source database table and encoding scheme for storing facility data. The system reads the code segment authorization and generates the code according to the scheme rules. The sequential code segment is incremented for each data and deduplication is performed according to the identification code mechanism.

[0016] S5. For abandoned facility data, the corresponding code is logically deregistered and can be restored for use when needed. Historical record queries and traceability are also supported.

[0017] Furthermore, in step S1, the existing data code segments directly import existing standardized information, which is imported in batches from the system's built-in data dictionary, external standard interfaces, or historical databases;

[0018] The newly added data code segment is manually entered by the user and is used to identify specific project numbers, special purpose facilities or temporary identifiers. The system supports format restrictions and content verification for the newly added code segment.

[0019] The mapped data code segment automatically extracts values ​​from specific fields in the facility data table and performs character truncation, case conversion, and special symbol replacement.

[0020] The sequential code segment is automatically generated by the system backend into an increasing sequence, supporting user-defined starting value, step size, fixed length, and automatic zero-padding rules, as well as setting a maximum value loop strategy.

[0021] Furthermore, in step S2, the system will verify in real time whether the combination of each code segment exceeds the total length limit and whether it can meet the uniqueness requirement, and provide the simulation generation result for user confirmation. The encoding scheme is used for encoding generation of new facilities, and also supports batch complementation and rule migration of historical data.

[0022] To enhance the versatility of the solution, users are allowed to configure multiple application scenarios for the same solution. Meanwhile, the coding scheme can be migrated across systems through import and export functions.

[0023] Furthermore, in step S3, a fine-grained code segment authorization mechanism is introduced. Before performing an encoding task, the user needs to submit an authorization application through the system, specifying the start value, end value, and expected quantity of the required sequential code segments. The application information will be processed by the authorization administrator or the system's automatic approval process.

[0024] After the authorization is successful, the system binds the authorization information with the user account, project number or task identifier, and strictly verifies its legality and validity during the code generation process;

[0025] When the user attempts to generate a sequential code segment that exceeds the authorized range, the system will automatically block and prompt an error.

[0026] Further, in step S4, the user selects the target data source, specifies the facility data table, and associates the selected coding scheme when performing the coding task through the system interface or API call;

[0027] The system automatically loads the value rules of each code segment in the scheme. For mapping data code segments, the system extracts field values from the source database in real time and performs pre-defined formatting or data cleaning operations;

[0028] For sequential code segments, the system generates them incrementally according to the authorized range and ensures their uniqueness through distributed locking mechanisms when performing multi-threaded concurrent execution.

[0029] Further, during the coding process, the identification code is generated according to the pre-set unique identification code generation strategy, and is compared with existing records before being written into the coding library. If a matching record already exists, the coding generation for that data is skipped.

[0030] Further, in step S5, the user locates the target code through the facility identifier, coding value or other query conditions and updates its status to "unavailable" after confirmation, which will prevent it from being referenced again in subsequent business processes.

[0031] The system retains complete historical records, including the reason for cancellation, the operator and the operation time, to meet the compliance and traceability requirements.

[0032] A device for coding urban infrastructure, comprising at least one memory and at least one processor;

[0033] The at least one memory is used to store machine-readable programs;

[0034] The at least one processor is used to call the machine-readable programs and execute a method for coding urban infrastructure.

[0035] Compared with the prior art, the method and device for coding urban infrastructure of the present application have the following outstanding advantages:

[0036] (1) Modular code segments and configurable coding schemes: through code segments with customizable length, format and combination order, unified and flexible coding rules are realized, facilitating cross-department and cross-facility type reuse and extension.

[0037] (2) Order code authorization control, ensure order uniqueness: Introduce the interval application and administrator approval mechanism of the order code segment, effectively avoid the code conflict caused by multiple concurrent generation, ensure the uniqueness and ordered allocation of the code.

[0038] (3) Field mapping and dynamic value, support multi-source automation: Through the mapping data code segment, the source table field is automatically extracted and formatted, realizing the automatic coding of multi-source data, reducing manual intervention and improving coding efficiency.

[0039] (4) De-duplication mechanism based on identification code, guarantee data quality: Generate identification code based on field combination and compare with code library, automatically remove duplicate records, reduce redundancy and improve data consistency.

[0040] (5) Logical cancellation and recovery, support life cycle management: Logical cancellation of abandoned codes and preservation of historical records, if necessary, can be restored for use, meet the traceability and compliance of the whole life cycle of the facility. BRIEF DESCRIPTION OF DRAWINGS

[0041] In order to more clearly illustrate the technical solutions of the embodiments of the present application or the prior art, the following will briefly introduce the drawings needed to be used in the embodiment or prior art description. Obviously, the drawings described below are some embodiments of the present application, and those skilled in the art can obtain other drawings according to these drawings without creative labor.

[0042] Figure 1 It is a flowchart of a method of urban infrastructure coding. DETAILED DESCRIPTION

[0043] In order to make the person skilled in the art better understand the scheme of the present application, the present application will be further described in detail below in combination with specific embodiments. Obviously, the described embodiments are only some of the embodiments of the present application, not all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative labor are within the scope of protection of the present application.

[0044] The following is a best embodiment:

[0045] As shown in the figure, the method of urban infrastructure coding in the embodiment has the following steps: Figure 1

[0046] S1, coding segment definition: the user defines one or more code segments in the system, the code segment type includes existing data code segment, new data code segment, mapping data code segment and order code segment, and configures length, format and value mode.

[0047] ​The existing data code section can directly introduce the existing standardized information, such as the national standard administrative division code, the industry classification code, the road number, etc., can be batch imported from the system built-in data dictionary, the external standard interface or the historical database, and the consistency with the existing specification is ensured.

[0048] The newly added data code section is manually entered by the user, and is used for identifying a specific project number, a special purpose facility or a temporary identification. The system supports format limitation and content verification of the newly added code section, so as to avoid human input errors.

[0049] The mapping data code section can automatically extract values from specific fields in the facility data table, and supports various formatting processing modes such as character truncation, case conversion and special symbol replacement, so as to ensure the rigor and adaptability of the coding rules.

[0050] The sequential code section is automatically generated by the system background in an incremental sequence, supports user-defined starting value, step length, fixed length and automatic zero padding rules, and can set the maximum value cycle strategy to prevent overflow.

[0051] All code sections can preview the generated effect when defined, and allow modification of the order, adjustment of the length and setting of the placeholder, so as to flexibly adapt to the coding requirements of different business systems.

[0052] S2, coding scheme formulation: combining multiple code sections in a predetermined order to form a coding scheme, supporting cross-facility type application, and setting separator and verification rules;

[0053] The user is allowed to combine multiple defined code sections in a set order to form a complete facility code. The user can flexibly define the code section arrangement order, separator style, total code length and verification rules to meet the coding standards of multiple industries and regions.

[0054] During the scheme configuration process, the system will real-time check whether the combined code sections exceed the total length limit and whether they can meet the uniqueness requirement, and provide simulation generation results for user confirmation. The coding scheme can not only be used for coding generation of new facilities, but also support batch code supplement and rule migration of historical data, reducing repeated development work.

[0055] To enhance the universality of the scheme, the present application allows the user to configure multiple application scenarios for the same scheme, for example, the same facility uses different separator styles in different business departments, without the need to redefine all code sections. At the same time, the coding scheme can be migrated across systems through import and export functions, facilitating the promotion of unified coding rules in large enterprise groups, cross-regional projects or industry associations, so as to realize standardized management and sharing of data.

[0056] S3, code section authorization management: the user applies for using the start and end value interval of the sequential code section, which is approved by the administrator, to control the coding uniqueness and orderliness during concurrent use.

[0057] Fine-grained code segment authorization mechanism is introduced. Before performing the encoding task, the user needs to submit an authorization application through the system, specifying the start value, end value, and estimated usage quantity of the required sequential code segment. The application information will be processed by the authorization administrator or the system automatic approval process.

[0058] After successful authorization, the system will bind the authorization information with the user account, project number, or task identifier, and strictly verify its legality and validity during the encoding generation process. When the user attempts to generate a sequential code segment that exceeds the authorized range, the system will automatically prevent and prompt an error to prevent unauthorized use.

[0059] At the same time, full traceability of authorization records is supported, and administrators can query authorization history, usage, and remaining available intervals at any time, ensuring that sequential code segments remain unique and orderly in a multi-person collaboration or multi-project parallel environment.

[0060] In addition, for large batch tasks, batch interval authorization is also supported, and unused code segment ranges can be automatically reclaimed after task completion, improving resource utilization.

[0061] S4, Encoding task execution: Select the source database table of the storage facility data and the encoding scheme. The system reads the code segment authorization and generates the code according to the scheme rules. For each data, the sequential code segment is incremented, and the identification code mechanism is used for de-duplication processing.

[0062] When performing the encoding task, the user can select the target data source, specify the facility data table, and associate the selected encoding scheme through the system interface or API call. The system will automatically load the value rules of each code segment in the scheme. For mapped data code segments, the system will extract field values from the source database in real time and perform pre-defined formatting or data cleaning operations. For sequential code segments, the system will generate and increment sequentially according to the authorized range, and can ensure the uniqueness of the generated code through the distributed lock mechanism when executing in multiple threads concurrently.

[0063] During the encoding process, the identification code is generated according to the pre-set unique identification code generation strategy (such as the hash value based on facility name, geographic coordinates, and region information). Before writing to the encoding library, it is compared with the existing records. If there is a matching record, the encoding generation of this data is skipped to avoid repeated allocation. This task execution module supports batch processing, segmented execution, and breakpoint continuation functions, which can adapt to the efficient encoding needs of large-scale data sets, and generates detailed log files during execution, facilitating subsequent auditing and problem troubleshooting.

[0064] S5, Encoding cancellation and recovery: For abandoned facility data, logically cancel the corresponding code, and restore its use when needed. Historical record query and traceability are also supported.

[0065] The encoding cancellation function allows users to logically delete the generated encoding when the facility is abandoned, demolished, merged, or business rules are adjusted.

[0066] Users can quickly locate the target encoding through facility identification, encoding value or other query conditions, and update its status to "unavailable" after confirmation, which will prevent it from being referenced again in subsequent business processes. The system will keep a complete history record when performing the cancellation operation, including the cancellation reason, operator, operation time, etc. to meet the compliance and traceability requirements.

[0067] For special cases such as facility recovery or encoding mis-cancellation, administrators can reactivate the encoding through the recovery function and restore its normal use permission in the business system.

[0068] In addition, the present embodiment provides batch cancellation and batch recovery functions, which support one-time processing of a large amount of encoding data based on filtering conditions, thereby improving data management efficiency and reducing manual operation errors.

[0069] Based on the above method, the device for coding urban infrastructure in the embodiment includes at least one memory and at least one processor;

[0070] The at least one memory is used to store machine-readable programs;

[0071] The at least one processor is used to call the machine-readable programs and execute the method for coding urban infrastructure.

[0072] Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present application, and not to limit them; although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: it can still modify the technical solutions recorded in the foregoing embodiments, or make equivalent replacement for part or all of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the scope of the technical solutions of the embodiments of the present application.

Claims

1. A method for coding urban infrastructure, characterized in that, It has the following steps: S1. Users define one or more code segments in the system. The code segment types include existing data code segments, newly added data code segments, mapped data code segments, and sequential code segments, and configure the length, format, and value retrieval method. S2. Combine multiple code segments into an encoding scheme in a predetermined order, supporting cross-facility type applications, and setting delimiters and verification rules; S3. The start and end value range of the sequential code segment requested by the user shall be approved by the administrator to control the uniqueness and order of the encoding when using it concurrently; S4. Select the source database table and encoding scheme for storing facility data. The system reads the code segment authorization and generates the code according to the scheme rules. The sequential code segment is incremented for each data and deduplication is performed according to the identification code mechanism. S5. For abandoned facility data, the corresponding code is logically deregistered and can be restored for use when needed. Historical record queries and traceability are also supported.

2. The method for coding urban infrastructure according to claim 1, characterized in that, In step S1, the existing data code segments directly import existing standardized information, which is imported in batches from the system's built-in data dictionary, external standard interface, or historical database; The newly added data code segment is manually entered by the user and is used to identify specific project numbers, special purpose facilities or temporary identifiers. The system supports format restrictions and content verification for the newly added code segment. The mapped data code segment automatically extracts values ​​from specific fields in the facility data table and performs character truncation, case conversion, and special symbol replacement. The sequential code segment is automatically generated by the system backend into an increasing sequence, supporting user-defined starting value, step size, fixed length, and automatic zero-padding rules, as well as setting a maximum value loop strategy.

3. The method for coding urban infrastructure according to claim 2, characterized in that, In step S2, the system will verify in real time whether the combination of each code segment exceeds the total length limit and whether it can meet the uniqueness requirement, and provide the simulation generation result for user confirmation. The encoding scheme is used for encoding generation of new facilities, and also supports batch complementation and rule migration of historical data. To enhance the versatility of the solution, users are allowed to configure multiple application scenarios for the same solution. Meanwhile, the coding scheme can be migrated across systems through import and export functions.

4. The method for coding urban infrastructure according to claim 3, characterized in that, In step S3, a fine-grained code segment authorization mechanism is introduced. Before performing an encoding task, the user needs to submit an authorization application through the system, specifying the start value, end value and expected quantity of the required sequential code segments. The application information will be processed by the authorization administrator or the system's automatic approval process. After successful authorization, the system will bind the authorization information to the user account, project number or task identifier, and strictly verify its legality and validity during the code generation process; When a user attempts to generate a sequential code segment that is outside the authorized scope, the system will automatically block it and display an error message.

5. The method for coding urban infrastructure according to claim 4, characterized in that, In step S4, when performing a coding task, the user selects the target data source, specifies the facility data table, and associates the selected coding scheme through the system interface or API call. The system will automatically load the value rules for each code segment in the scheme. For the mapped data code segment, the system will extract field values ​​from the source database in real time and perform predefined formatting or data cleaning operations. For sequential code segments, the system will generate them incrementally according to the authorized range, and can ensure the uniqueness of the generated segments through a distributed lock mechanism when multiple threads execute concurrently.

6. The method for coding urban infrastructure according to claim 5, characterized in that, During the encoding process, an identification code is generated according to a preset unique identification code generation strategy and compared with existing records before being written into the encoding library. If a matching record already exists, the encoding generation of that data is skipped.

7. The method for coding urban infrastructure according to claim 6, characterized in that, In step S5, the user locates the target code through facility identifier, code value or other query conditions, and updates its status to "unavailable" after confirmation. This status will prevent it from being referenced again in subsequent business processes. The system retains a complete history when performing a deregistration operation, including the reason for deregistration, the operator, and the time of the operation, in order to meet compliance and traceability requirements.

8. A device for coding urban infrastructure, characterized in that, include: At least one memory and at least one processor; The at least one memory is used to store a machine-readable program; The at least one processor is configured to invoke the machine-readable program to perform the method according to any one of claims 1 to 7.

Images