Method for constructing urban underground municipal infrastructure database and GIS toolbox

Abstract

The application provides a construction method and GIS toolbox of a city underground municipal infrastructure database. The construction method comprises the following steps: obtaining element information in an Excel table; creating a first database, the first database comprising data columns, and adding the element information into the data columns in the first database to obtain a first data column; obtaining attribute information in the Excel table; adding the attribute information into the first data column to obtain a second data column; obtaining field information in the Excel table; adding the field information into the second data column to obtain a third data column; and importing the third data column into the first database to obtain a target database. Through the construction method and GIS toolbox, the database of the city underground municipal infrastructure is quickly constructed, the time for constructing the database is shortened, errors and exceptions possibly occurring in the process of directly constructing the database by manpower are reduced, and the process for constructing the database is optimized.

Description

Technical Field

[0001] This invention relates to the field of municipal engineering databases, and in particular to a method for constructing a database of urban underground municipal infrastructure and a GIS toolkit. Background Technology

[0002] Municipal infrastructure projects generally fall under the category of national infrastructure construction. Municipal infrastructure refers to the construction of various public transportation facilities, water supply, drainage, gas supply, urban flood control, environmental sanitation, and lighting infrastructure in urban development. It is an indispensable material foundation for urban survival and development, and a basic condition for improving people's living standards and opening up to the outside world. To keep pace with urbanization, the construction of municipal infrastructure projects needs further standardization and human-centered design.

[0003] With the development of urbanization, more and more municipal infrastructure projects are being used. In particular, in the municipal field, the amount of data in each municipal infrastructure is becoming larger and more complex. That is, the database of municipal infrastructure contains various types of element classes and fields of different formats and types for each element class. If the fields used in municipal infrastructure do not have a standardized specification, it will undoubtedly affect the normal operation of municipal infrastructure and the development of business.

[0004] Urban municipal underground infrastructure encompasses 24 types of infrastructure, including survey units, underground engineering pipelines (pipelines), underground engineering pipelines (pipelines), water intake facilities (including pretreatment facilities), water purification plant facilities (including groundwater distribution plants), booster pump station facilities, pressure regulating station facilities, sewage treatment plants, drainage pump stations, storage facilities, natural gas gate stations, natural gas storage and distribution stations, liquefied petroleum gas storage and distribution (filling) stations, gas stations, underground integrated pipe corridors, pedestrian underpasses, urban underground roads, urban rail transit (underground railways), underground public parking lots, underground transportation hubs, underground rivers, civil defense projects, other underground spaces, and abandoned projects. Furthermore, the standard field names and attributes of different infrastructure element categories vary. Therefore, it is evident that the data volume is enormous and the data complexity is high. Summary of the Invention

[0005] This application provides a method for constructing a database of urban underground municipal infrastructure and a GIS toolkit to enable the rapid and convenient construction of such a database.

[0006] In a first aspect, this application provides a method for constructing a database of urban underground municipal infrastructure, wherein the database data is based on an Excel spreadsheet of underground infrastructure, and the construction method includes:

[0007] Obtain the element information from the Excel spreadsheet;

[0008] Create a first database, which includes data columns, and add the feature information in batches into the data columns of the first database to obtain the first data column;

[0009] Obtain the attribute information from the Excel spreadsheet;

[0010] The attribute information is batch-added into the first data column to obtain the second data column;

[0011] Retrieve field information from the Excel spreadsheet;

[0012] The field information is added in batches to the columns of the second data to obtain the third data column;

[0013] Import the third data column into the first database to obtain the target database.

[0014] Preferably, the step of adding the element information in batches into the data column to obtain the first data column includes:

[0015] Create the first workspace interface and the second workspace interface;

[0016] Add the data columns from the first database to the first workspace interface;

[0017] Add the element information to the second workspace interface. The element information includes the element name and the element type.

[0018] In response to the user's batch creation command for features, the feature names and feature types are added in batches to the data columns in the second workspace interface, so as to transform the data columns into the first data columns.

[0019] Preferably, the first data column is an empty data column, and the step of responding to the user input batch creation feature instruction further includes:

[0020] The batch attribute creation and modification function is invoked to add the feature name and the feature type to the first data column in batches.

[0021] The first database has the suffix "gdb";

[0022] The element information is a data table, and the file extension of the element information is .xls;

[0023] The relationship between the element name and the element type is many-to-one.

[0024] Preferably, the step of batch filling the attribute information into the first data column to obtain the second data column includes:

[0025] The attribute information is added to the second workspace interface, and the attribute information includes attribute fields and attribute field key values;

[0026] In response to the user's instruction to add attribute information in batches, the attribute fields and attribute field key values ​​are added in batches to the first data column in the second workspace interface, so as to transform the first data column into the second data column.

[0027] Preferably, after the step of responding to the user input of the batch addition of attribute information instruction, the method further includes:

[0028] The batch add field function and the batch add value function are called respectively. The batch add field function is used to add the attribute fields to the second data column in batches, and the batch add value function is used to add the attribute field key values ​​to the second data column in batches.

[0029] The attribute information is a data table, and the attribute information has the file extension .xls;

[0030] The attribute field includes an attribute field name, an attribute field label, and an attribute field type. The attribute field key value includes the attribute field name, the attribute field type, the attribute field code, and the attribute field code description.

[0031] The relationship between the attribute domain name and the attribute domain label is one-to-one; the relationship between the attribute domain name and the attribute domain type is many-to-one; the relationship between the attribute domain name and the attribute domain code is many-to-one; and the relationship between the attribute domain name and the attribute domain code description is many-to-one.

[0032] Preferably, the step of adding the field information in batches into the second data column to obtain the third data column includes:

[0033] Add the field information to the second workspace interface. The field information includes the feature name, field base name, field alias, field data type, field length, field number of digits, field decimal places, and the attribute domain.

[0034] In response to the user's instruction to add field information in batches, the field information is added in batches to the second data column in the second workspace interface, so as to transform the second data column into the third data column.

[0035] Preferably, the step of responding to the user input of a batch add field information instruction further includes:

[0036] Call the batch add field function, which is used to add the field information into the second data column in batches;

[0037] The field information is a data table, and the field information has the file extension .xls;

[0038] The relationship between the element name and the field base name, the field alias, the field data type, the field length, the field number of digits, the field decimal places, and the attribute domain is many-to-one.

[0039] Secondly, this application also provides a GIS toolbox, which is applicable to the construction method of any of the above-mentioned urban underground municipal infrastructure databases, and the GIS toolbox includes:

[0040] Workbench;

[0041] The following tools are connected to the workbench: a metadata database creation tool, a batch feature creation tool, a batch attribute domain addition tool, and a batch field addition byfc tool.

[0042] The metadata creation tool is configured to create a first database and send it to the workbench, the first database including data columns;

[0043] The batch feature creation tool is configured to acquire feature information and send it to the workbench;

[0044] The batch add attribute field tool is configured to acquire attribute information and send it to the workbench;

[0045] The batch field addition byfc tool is configured to retrieve field information and send it to the workbench;

[0046] The workbench is configured as follows:

[0047] Create the first workspace interface and the second workspace interface;

[0048] Add the data column to the first workspace interface;

[0049] The element information, attribute information, and field information are added to the second workspace interface in sequence;

[0050] In response to user input, the feature information, attribute information, and field information are added to the data column in batches to obtain the third data column.

[0051] Import the third data column into the first database to obtain the target database.

[0052] Preferably, the worktable is further configured as follows:

[0053] In response to the user's batch creation command for features, the feature information is added to the data column in the second workspace interface, thereby transforming the data column into the first data column;

[0054] In response to the user's command to add attribute fields in batches, the attribute information is added to the first data column in the second workspace interface, thereby transforming the first data column into the second data column;

[0055] In response to the user's instruction to add field information in batches, the field information is added to the second data column in the second workspace interface, thereby transforming the second data column into the third data column.

[0056] Preferably, the element information includes the element name and the element type;

[0057] The attribute information includes attribute domains and attribute domain key values. The attribute domains include attribute domain name, attribute domain label, and attribute domain type. The attribute domain key values ​​include the attribute domain name, the attribute domain type, the attribute domain code, and the attribute domain code description.

[0058] The field information includes the feature name, field base name, field alias, field data type, field length, field number of digits, field decimal places, and the attribute domain.

[0059] This application provides a method for constructing a database of urban underground municipal infrastructure and a GIS toolkit. The construction method includes: acquiring feature information from an Excel spreadsheet; creating a first database, which includes data columns, and batch adding the feature information into the data columns of the first database to obtain a first data column; acquiring attribute information from the Excel spreadsheet; batch adding the attribute information into the first data column to obtain a second data column; acquiring field information from the Excel spreadsheet; batch adding the field information into the second data column to obtain a third data column; and importing the third data column into the first database to obtain a target database. This application, through the above construction method and GIS toolkit, enables the rapid construction of a database of urban underground municipal infrastructure, shortens the database construction time, reduces errors and anomalies that may occur during manual database construction, and optimizes the database construction process. Attached Figure Description

[0060] To more clearly illustrate the technical solution of this application, the drawings used in the embodiments will be briefly introduced below. Obviously, for those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0061] Figure 1 This is a flowchart illustrating the specific process for constructing a database of urban underground municipal infrastructure according to this application.

[0062] Figure 2 This is a flowchart illustrating the process of adding element information in batches in a method for constructing a database of urban underground municipal infrastructure as described in this application.

[0063] Figure 3 This is a flowchart illustrating the process of adding attribute information in batches in a method for constructing a database of urban underground municipal infrastructure according to this application.

[0064] Figure 4 This is a flowchart illustrating the process of adding field information in batches in a method for constructing a database of urban underground municipal infrastructure according to this application.

[0065] Figure 5 This is a schematic diagram of a GIS toolbox according to this application. Detailed Implementation

[0066] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0067] Figure 1 This is a flowchart illustrating the specific process for constructing a database of urban underground municipal infrastructure according to this application.

[0068] Depend on Figure 1 As can be seen, this embodiment provides a method for constructing a database of urban underground municipal infrastructure. The data in the database is based on an Excel spreadsheet of underground infrastructure. The construction method includes:

[0069] S100, Obtain the element information from the Excel table.

[0070] Specifically, in this embodiment, the Excel spreadsheet is a pre-compiled statistical table of underground infrastructure. The element information includes element name and element type. The element name is the label of the underground infrastructure, and the element type is the specific type of the underground infrastructure. The relationship between the element name and the element type is many-to-one.

[0071] The construction method also includes:

[0072] S200, Create a first database, which includes data columns, and add the element information in batches into the data columns in the first database to obtain the first data column;

[0073] S300, Obtain the attribute information from the Excel table.

[0074] S400, the attribute information is batch-added into the first data column to obtain the second data column;

[0075] Specifically, in this embodiment, the attribute information includes attribute domains and attribute domain key values, wherein the attribute domain key values ​​include attribute domain name, attribute domain label and attribute domain type, and the attribute domain key values ​​include attribute domain name, attribute domain type, attribute domain code and attribute domain code description;

[0076] The relationship between the attribute domain name and the attribute domain label is one-to-one; the relationship between the attribute domain name and the attribute domain type is many-to-one; the relationship between the attribute domain name and the attribute domain code is many-to-one; and the relationship between the attribute domain name and the attribute domain code description is many-to-one.

[0077] The first database has the suffix "gbd". This method ensures the standardization of database creation. The first database is an empty database.

[0078] The construction method also includes:

[0079] S500, Obtain field information from the Excel table;

[0080] S600, the field information is added in batches to the second data column to obtain the third data column;

[0081] S700, import the third data column into the first database to obtain the target database.

[0082] Specifically, in this embodiment, the field information includes the feature name, the basic field name, the field alias, the field data type, the field length, the number of digits in the field, the number of decimal places in the field, and the attribute domain;

[0083] The relationship between the element name and the field base name, the field alias, the field data type, the field length, the field number of digits, the field decimal places, and the attribute domain is many-to-one.

[0084] It should be noted that the element information, attribute information, and field information are all data tables, and all three have the file extension .xls, which can alleviate the difficulty of obtaining and adding information.

[0085] Figure 2 This is a flowchart illustrating the process of adding element information in batches in a method for constructing an urban underground municipal infrastructure database according to this application.

[0086] refer to Figure 2 It can be seen that, further, in some embodiments, the step of adding the element information in batches into the data column to obtain the first data column includes:

[0087] S201, Create the first workspace interface and the second workspace interface;

[0088] S202, add the data columns from the first database to the first workspace interface;

[0089] S203, add the element information into the second workspace interface;

[0090] S204, in response to the user's input instruction to create features in batches, the feature names and feature types are added in batches to the data columns in the second workspace interface.

[0091] Specifically, in this embodiment, the process of adding the feature names and feature types in batches into the data columns within the second workspace interface in response to the user's input batch creation feature command is as follows:

[0092] The user inputs a batch creation command for features, responds to the command, and calls a pre-set batch attribute creation and modification function. The function adds the feature names and feature types to the first data column in batches. Through this step, the attribute parameters are added to the data column, and the data stream is transformed into the first data column, which now includes feature information.

[0093] Figure 3 This is a flowchart illustrating the process of adding attribute information in batches in a method for constructing a database of urban underground municipal infrastructure as described in this application.

[0094] refer to Figure 3 It can be seen that, further, in some embodiments, the step of batch adding the attribute information into the first data column to obtain the second data column includes:

[0095] S401, add the attribute information into the second workspace interface;

[0096] S402, in response to the user's input instruction to add attribute fields in batches, the attribute fields and attribute field key values ​​are added in batches to the first data column in the second workspace interface.

[0097] Specifically, in this embodiment, the process of responding to the user's input instruction to add attribute information in batches, and adding the attribute fields and attribute field key values ​​in batches into the first data column in the second workspace interface, is as follows:

[0098] When a user inputs a command to add attribute fields in batches, the system responds by calling the batch addition function to add the attribute fields in batches into the second data column, and the batch addition function to add the attribute field key values ​​in batches into the second data column. Through this step, the attribute information is added into the first data column, and the first data column is transformed into the second data column. At this time, the second data column includes the feature information and the attribute information.

[0099] Figure 4 This is a flowchart illustrating the process of adding field information in batches in a method for constructing a database of urban underground municipal infrastructure as described in this application.

[0100] refer to Figure 4 It can be seen that, further, in some embodiments, the step of batch adding the field information into the second data column to obtain the third data column includes:

[0101] S601, add the field information into the second workspace interface;

[0102] S602, in response to the user's instruction to add field information in batches, the field information is added in batches to the second data column in the second workspace interface.

[0103] Specifically, in this embodiment, the process of adding the field information in batches into the second data column within the second workspace interface in response to the user's input instruction to add field information in batches is as follows:

[0104] The user inputs a command to add field information in batches. In response to the command, the batch field addition function is called. The batch field addition function is used to add the field information in batches into the second data column. Through this step, the field information is added into the second data column, and the second data column is transformed into the third data column. At this time, the third data column includes the feature information, the attribute information, and the field information, which satisfies the conditions for constructing the database.

[0105] Importing the third data column into the first database, the first database now includes the feature information, the attribute information, and the field information, thus achieving the purpose of constructing the database in this embodiment. Furthermore, the database construction process in this embodiment is fully automated by the program, thereby optimizing the database construction speed and reducing errors and anomalies that may occur during manual database construction.

[0106] Figure 5 This is a schematic diagram of a GIS toolbox according to this application.

[0107] refer to Figure 5 It is understood that this embodiment also provides a GIS toolbox, which is used to quickly build a database based on underground infrastructure. The GIS toolbox includes a workbench.

[0108] The tool connected to the workbench includes a metadata database creation tool, a batch feature creation tool, a batch attribute domain addition tool, and a batch field addition tool (byfc).

[0109] Specifically, in this embodiment, the workbench is mainly used for adding relevant information in batches.

[0110] The metadata creation tool is configured to create a first database and send it to the workbench, the first database including data columns.

[0111] Specifically, in this embodiment, the first database is an empty database. Therefore, the data columns contained within it are also empty data columns. It can also be understood that the metadata database creation tool is a "container" used to create the database.

[0112] The batch feature creation tool is configured to acquire feature information and send it to the workbench;

[0113] The batch add attribute field tool is configured to acquire attribute information and send it to the workbench;

[0114] The batch field addition tool byfc is configured to retrieve field information and send it to the workbench.

[0115] Specifically, in this embodiment, the batch creation of features tool, the batch addition of attribute domain tool, and the batch addition of field byfc tool are all tools used to obtain relevant information. After obtaining their respective information, they are sent to the workbench, where the workbench processes the information to ultimately build the database.

[0116] The workbench is configured as follows:

[0117] Create the first workspace interface and the second workspace interface;

[0118] Add the data column to the first workspace interface;

[0119] The element information, attribute information, and field information are added to the second workspace interface in sequence;

[0120] In response to user input, the feature information, attribute information, and field information are added to the data column in batches to obtain the third data column.

[0121] Specifically, in this embodiment, the specific operation of adding the element information in batches to the data column is as follows: the user inputs a batch creation element command, and the workbench responds to the user's input batch creation element command by adding the element information to the data column in the second workspace interface, thereby transforming the data column into a first data column;

[0122] The specific operation of adding the attribute information in batches to the data column is as follows: the user inputs a batch add attribute field command, and the workbench responds to the user inputs the batch add attribute field command and adds the attribute information to the first data column in the second workspace interface, thereby transforming the first data column into the second data column;

[0123] The specific operation of adding the field information to the data column in batches is as follows: the user inputs a command to add field information in batches, and the workbench responds to the command by adding the field information to the second data column in the second workspace interface, thereby transforming the second data column into the third data column.

[0124] When the feature information, attribute information, and field information are all added to the data column in batches, the third data column is obtained. At this time, the third data column meets the conditions for constructing a database. The third data column is then imported into the first database to obtain the target database.

Claims

1. A method for constructing a database of urban underground municipal infrastructure, wherein the data in the database is based on an Excel spreadsheet of underground infrastructure, characterized in that... The construction method includes: Obtain the element information from the Excel spreadsheet; Create a first database, which includes data columns; create a first workspace interface and a second workspace interface; add the data columns from the first database to the first workspace interface; add the feature information to the second workspace interface, the feature information including feature name and feature type; in response to a user-inputted batch creation feature command, batch add the feature name and feature type to the data columns in the second workspace interface, thereby transforming the data columns into a first data column; Obtain the attribute information from the Excel spreadsheet; The attribute information is added in batches to the first data column to obtain the second data column; Retrieve field information from the Excel spreadsheet; The field information is added in batches to the second data column to obtain the third data column; The third data column is imported into the first database to obtain the target database.

2. The method for constructing a database of urban underground municipal infrastructure according to claim 1, characterized in that, The first data column is an empty data column, and the step of responding to the user input batch creation feature command further includes: The batch attribute creation and modification function is invoked, which is used to add the feature name and the feature type to the first data column in batches; The first database has the suffix "gdb"; The element information is a data table, and the file extension of the element information is .xls; The relationship between the element name and the element type is many-to-one.

3. The method for constructing a database of urban underground municipal infrastructure according to claim 1, characterized in that, The step of batch filling the attribute information into the first data column to obtain the second data column includes: The attribute information is added to the second workspace interface, and the attribute information includes attribute fields and attribute field key values; In response to the user's instruction to add attribute information in batches, the attribute fields and attribute field key values ​​are added in batches to the first data column in the second workspace interface, so as to transform the first data column into the second data column.

4. The method for constructing a database of urban underground municipal infrastructure according to claim 3, characterized in that, The step following the user-input instruction to add attribute information in batches also includes: The batch add field function and the batch add value function are called respectively. The batch add field function is used to add the attribute fields to the second data column in batches, and the batch add value function is used to add the attribute field key values ​​to the second data column in batches. The attribute information is a data table, and the attribute information has the file extension .xls; The attribute field includes an attribute field name, an attribute field label, and an attribute field type. The attribute field key value includes the attribute field name, the attribute field type, the attribute field code, and the attribute field code description. The relationship between the attribute domain name and the attribute domain label is one-to-one; the relationship between the attribute domain name and the attribute domain type is many-to-one; the relationship between the attribute domain name and the attribute domain code is many-to-one; and the relationship between the attribute domain name and the attribute domain code description is many-to-one.

5. The method for constructing a database of urban underground municipal infrastructure according to claim 3, characterized in that, The step of adding the field information in batches into the second data column to obtain the third data column includes: Add the field information to the second workspace interface. The field information includes the feature name, field base name, field alias, field data type, field length, field number of digits, field decimal places, and the attribute domain. In response to the user's instruction to add field information in batches, the field information is added in batches to the second data column in the second workspace interface, so as to transform the second data column into the third data column.

6. The method for constructing a database of urban underground municipal infrastructure according to claim 5, characterized in that, The step of responding to the user input to add field information in batches also includes: Call the batch add field function, which is used to add the field information into the second data column in batches; The field information is a data table, and the field information has the file extension .xls; The relationship between the element name and the field base name, the field alias, the field data type, the field length, the field number of digits, the field decimal places, and the attribute domain is many-to-one.

7. A GIS toolkit for rapidly building databases based on underground infrastructure, characterized in that, The GIS toolbox is applicable to the method for constructing the urban underground municipal infrastructure database according to any one of claims 1 to 6, and the GIS toolbox includes: Workbench; The following tools are connected to the workbench: a metadata database creation tool, a batch feature creation tool, a batch attribute domain addition tool, and a batch field addition byfc tool. The metadata creation tool is configured to create a first database and send it to the workbench, the first database including data columns; The batch feature creation tool is configured to acquire feature information and send it to the workbench, the feature information including feature name and feature type; The batch add attribute field tool is configured to acquire attribute information and send it to the workbench; The batch field addition byfc tool is configured to retrieve field information and send it to the workbench; The workbench is configured as follows: Create the first workspace interface and the second workspace interface; Add the data column to the first workspace interface; The element information, attribute information, and field information are added to the second workspace interface in sequence; In response to user input, the feature information, attribute information, and field information are added to the data column in batches to obtain the third data column. Import the third data column into the first database to obtain the target database.

8. A GIS toolbox according to claim 7, characterized in that, The workbench is also configured to: In response to the user's batch creation command for features, the feature information is added to the data column in the second workspace interface, thereby transforming the data column into the first data column; In response to the user's command to add attribute fields in batches, the attribute information is added to the first data column in the second workspace interface, thereby transforming the first data column into the second data column; In response to the user's instruction to add field information in batches, the field information is added to the second data column in the second workspace interface, thereby transforming the second data column into the third data column.

9. A GIS toolbox according to claim 7, characterized in that, The element information includes the element name and element type; The attribute information includes attribute domains and attribute domain key values. The attribute domains include attribute domain name, attribute domain label, and attribute domain type. The attribute domain key values ​​include the attribute domain name, the attribute domain type, the attribute domain code, and the attribute domain code description. The field information includes the feature name, field base name, field alias, field data type, field length, field number of digits, field decimal places, and the attribute domain.

Images