A method, device and medium for integrating and merging multi-source public service facility databases

Abstract

The present invention discloses a method, device and medium for integrating and merging multi-source public service facility databases. By determining the base layer and the merging layer in the public service facility databases to be merged and storing them separately; calculating the point distance between the point features in the base layer and the point features in the merging layer; according to the calculated point distance and the facility names of the point features, merging the point features in the merging layer that meet the preset conditions with the base layer; determining the centroids of the polygon features in the base layer and the merging layer, calculating the centroid distance between the centroid of the polygon feature in the base layer and the centroid of the polygon feature in the merging layer; according to the calculated centroid distance and the facility names of the polygon features, merging the polygon features in the merging layer that meet the preset conditions with the base layer. It realizes the data integration and merging of multi-source public service facility databases, and avoids the situation of data duplication, chaos and loss during the data call and processing process.

Description

Technical Field

[0001] The present invention relates to the technical field of computer information processing, and in particular, to a method, device, and medium for integrating and merging multi-source public service facility databases. Background Art

[0002] With the increasing popularity of space technology, intelligent real-time geographic information systems that combine high-tech systems such as global positioning systems and inertial navigation systems have made geospatial data a practical tool. Users can quickly locate their positions and query road information through devices such as GPS. Thus, the demand for space technology is constantly growing. On the one hand, the convenient and fast operation method of space geographic data meets the users' rapid access to space information, but on the other hand, it also leaks users' privacy information, posing a great threat to the country, enterprises, and individuals.

[0003] The database is the most effective means for managing space geographic data. Design a database based on the practical needs of the database, construct an optimized database schema, establish a database and its calling platform, meet the upstream and downstream data calls of the database, effectively store data, and establish a mechanism for mining and updating database information, and finally realize the use and processing of users' information requirements.

[0004] However, for multi-source space geographic data obtained at different locations or for different events in the same space region, the data is not the same. Therefore, the multiple databases obtained have problems such as a large amount of space data, irregular space targets, and complex structures and relationships of the targets (intersection, adjacency, inclusion, coverage relationships, etc.). During the process of calling and processing data between multiple databases, data duplication, confusion, and loss are likely to occur. Summary of the Invention

[0005] Embodiments of the present invention provide a method, device, and medium for integrating and merging multi-source public service facility databases, which can realize the integration and merging of data from different public service facility databases and avoid data duplication, confusion, and loss during the process of data calling and processing.

[0006] Compared with the prior art, an embodiment of the present invention provides a method for integrating and merging multi-source public service facility databases, including:

[0007] Determine the base layer and the merge layer in the public service facility database to be merged, and store them separately;

[0008] Calculate the point distance between the point features in the base layer and the point features in the merge layer;

[0009] According to the calculated point distance and the facility names of the point features, merge the point features in the merge layer that meet the preset conditions with the base layer;

[0010] Determine the centroids of the polygon features in the base layer and the merged layer, and calculate the centroid distance between the centroid of the polygon feature in the base layer and the centroid of the polygon feature in the merged layer;

[0011] According to the calculated centroid distance and the facility names of the polygon features, merge the polygon features in the merged layer that meet the preset conditions with the base layer.

[0012] Furthermore, the database of public service facilities to be merged includes at least two databases of public service facilities;

[0013] The determination of the base layer and the merged layer in the database of public service facilities to be merged and their separate storage specifically include:

[0014] Take one database of public service facilities in the database of public service facilities to be merged as the base layer, and take the other databases of public service facilities as the merged layer;

[0015] Store the base layer and the merged layer into the pre-built JCTC.gdb file geodatabase and the pre-built HBTC.gdb file geodatabase respectively.

[0016] As an improvement to the above solution, the merging of the point features in the merged layer that meet the preset conditions with the base layer according to the calculated point distance and the facility names of the point features specifically includes:

[0017] When the point distance between the point feature in the merged layer and the point feature in the base layer is less than the preset search radius, and the facility names of the point feature in the merged layer and the point feature in the base layer are the same, it is determined as the same point feature, and the two point features are merged;

[0018] When the point distance between the point feature in the merged layer and the point feature in the base layer is less than the search radius, and the facility names of the point feature in the merged layer and the point feature in the base layer are different, it is determined as a different point feature, and the point feature in the merged layer is output to the pre-built manual discrimination database;

[0019] When the point distance between the point feature in the merged layer and the point feature in the base layer is not less than the search radius, the point feature in the merged layer is output to the pre-built merge database.

[0020] Furthermore, after the point feature in the merged layer is output to the pre-built merge database, the method further includes:

[0021] Determine whether the point features in the merged database are located within the polygon features of the base layer, and compare the facility names of the point features in the merged database with the facility names of the polygon features of the base layer;

[0022] When the point features in the merged database are located within the polygon features of the base layer and the facility names of the point features in the merged database are the same as the facility names of the polygon features of the base layer, determine the point features in the merged database as duplicate facilities and delete the corresponding point features in the merged database;

[0023] When the point features in the merged database are located within the polygon features of the base layer and the facility names of the point features in the merged database are different from the facility names of the polygon features of the base layer, output the point features in the merged database to the manual discrimination database.

[0024] When the point features in the merged database are not located within the polygon features of the base layer, store the point features in the merged database.

[0025] As an improved solution to the above solution, the merging of the polygon features that meet the preset conditions in the merged layer with the base layer according to the calculated centroid distance and the facility name of the polygon feature specifically includes:

[0026] When the centroid distance between the polygon feature in the merged layer and the polygon feature in the base layer is less than the preset centroid radius and the facility names of the polygon feature in the merged layer and the polygon feature in the base layer are the same, determine them as the same polygon feature and merge the two polygon features;

[0027] When the centroid distance between the polygon feature in the merged layer and the polygon feature in the base layer is less than the centroid radius and the facility names of the polygon feature in the merged layer and the polygon feature in the base layer are different, determine them as different polygon features and output the polygon feature in the merged layer to the manual discrimination database;

[0028] When the centroid distance between the polygon feature in the merged layer and the polygon feature in the base layer is not less than the centroid radius, output the polygon feature in the merged layer to the pre-built process database.

[0029] Further, after outputting the polygon feature in the merged layer to the pre-built process database, the method further includes:

[0030] Determine whether there are features in the base layer with the same facility name as the polygon feature in the process database;

[0031] If so, output the corresponding surface features in the process database to the manual discrimination database;

[0032] If not, output the corresponding surface features in the process database to the merging database.

[0033] As a preferred solution, the method further includes:

[0034] Use the Merge tool in the Data Management Tools - General - in the arcgis toolbox to merge the point features in the merging database with the point features in the base layer, and use the Merge tool in the Data Management Tools - General - in the arcgis toolbox to merge the surface features in the merging database with the surface features in the base layer;

[0035] Manually verify the point features and surface features in the manual discrimination database.

[0036] An embodiment of the present invention also provides a multi-source public service facility database integration and merging device, and the device includes:

[0037] A layer determination module, configured to determine the base layer and the merging layer in the public service facility database to be merged, and store them separately;

[0038] A point distance calculation module, configured to calculate the point distance between the point features in the base layer and the point features in the merging layer;

[0039] A point feature merging module, configured to merge the point features in the merging layer that meet the preset conditions with the base layer according to the calculated point distance and the facility names of the point features;

[0040] A centroid distance calculation module, configured to determine the centroids of the surface features in the base layer and the merging layer, and calculate the centroid distance between the centroid of the surface feature in the base layer and the centroid of the surface feature in the merging layer;

[0041] A surface feature merging module, configured to merge the surface features in the merging layer that meet the preset conditions with the base layer according to the calculated centroid distance and the facility names of the surface features.

[0042] Preferably, the public service facility database to be merged includes at least two public service facility databases;

[0043] The layer determination module is specifically configured to:

[0044] Take one public service facility database in the public service facility database to be merged as the base layer, and take the other public service facility databases as the merging layer;

[0045] Store the base layer and the merged layer into a pre-built JCTC.gdb file geodatabase and a pre-built HBTC.gdb file geodatabase respectively.

[0046] Preferably, the point feature merging module is specifically configured to:

[0047] When the point distance between the point feature in the merged layer and the point feature in the base layer is less than a preset search radius, and the facility names of the point feature in the merged layer and the point feature in the base layer are the same, it is determined as the same point feature, and the two point features are merged;

[0048] When the point distance between the point feature in the merged layer and the point feature in the base layer is less than the search radius, and the facility names of the point feature in the merged layer and the point feature in the base layer are different, it is determined as a different point feature, and the point feature in the merged layer is output to a pre-built manual discrimination database;

[0049] When the point distance between the point feature in the merged layer and the point feature in the base layer is not less than the search radius, the point feature in the merged layer is output to a pre-built merging database.

[0050] Further, the device further includes a second point feature merging module, which is used for:

[0051] Determine whether the point feature in the merging database is located within the polygon feature of the base layer, and compare the facility name of the point feature in the merging database with the facility name of the polygon feature of the base layer;

[0052] When the point feature in the merging database is located within the polygon feature of the base layer, and the facility name of the point feature in the merging database is the same as the facility name of the polygon feature of the base layer, the point feature in the merging database is determined as a duplicate facility, and the corresponding point feature in the merging database is deleted;

[0053] When the point feature in the merging database is located within the polygon feature of the base layer, and the facility name of the point feature in the merging database is different from the facility name of the polygon feature of the base layer, the point feature in the merging database is output to the manual discrimination database.

[0054] When the point feature in the merging database is not located within the polygon feature of the base layer, the point feature in the merging database is stored in the merging database.

[0055] Further, the polygon feature merging module is specifically configured to:

[0056] When the centroid distance between the surface feature in the merged layer and the surface feature in the base layer is less than the preset centroid radius, and the facility names of the surface feature in the merged layer and the surface feature in the base layer are the same, it is determined as the same surface feature, and the two surface features are merged;

[0057] When the centroid distance between the surface feature in the merged layer and the surface feature in the base layer is less than the centroid radius, and the facility names of the surface feature in the merged layer and the surface feature in the base layer are different, it is determined as a different surface feature, and the surface feature in the merged layer is output to the manual discrimination database;

[0058] When the centroid distance between the surface feature in the merged layer and the surface feature in the base layer is not less than the centroid radius, the surface feature in the merged layer is output to the pre - built process database.

[0059] Further, the device further includes: a second surface feature merging module, which is used for:

[0060] Determine whether there is a feature in the base layer with the same facility name as the surface feature in the process database;

[0061] If so, output the corresponding surface feature in the process database to the manual discrimination database;

[0062] If not, output the corresponding surface feature in the process database to the merge database.

[0063] Further, the device further includes a merging module, which is used for:

[0064] Use the Merge tool in the Data Management Tools - General in the arcgis toolbox to merge the point features in the merge database with the point features in the base layer, and use the Merge tool in the Data Management Tools - General in the arcgis toolbox to merge the surface features in the merge database with the surface features in the base layer;

[0065] Manually verify the point features and surface features in the manual discrimination database.

[0066] An embodiment of the present invention further provides a multi - source public service facility database integration and merging device, including a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor. When the processor executes the computer program, it implements the multi - source public service facility database integration and merging method described in any one of the above embodiments.

[0067] An embodiment of the present invention further provides a computer-readable storage medium, which includes a stored computer program. When the computer program runs, it controls the device where the computer-readable storage medium is located to execute the multi-source public service facility database integration and merging method described in any one of the above embodiments.

[0068] The present invention provides a multi-source public service facility database integration and merging method, device, and medium. By determining the base layer and the merging layer in the public service facility database to be merged and storing them separately; calculating the point distance between the point features in the base layer and the point features in the merging layer; according to the calculated point distance and the facility names of the point features, merging the point features in the merging layer that meet the preset conditions with the base layer; determining the centroids of the polygon features in the base layer and the merging layer, and calculating the centroid distance between the centroid of the polygon feature in the base layer and the centroid of the polygon feature in the merging layer; according to the calculated centroid distance and the facility names of the polygon features, merging the polygon features in the merging layer that meet the preset conditions with the base layer. The data integration and merging of the multi-source public service facility database are realized, and the situation of data duplication, confusion, and loss in the data calling and processing process is avoided. BRIEF DESCRIPTION OF THE DRAWINGS

[0069] Figure 1 is a flowchart of a multi-source public service facility database integration and merging method provided by an embodiment of the present invention;

[0070] Figure 2 is a schematic structural diagram of the JCTC.gdb file geodatabase and the HBTC.gdb file geodatabase provided by an embodiment of the present invention;

[0071] Figure 3 is a schematic structural diagram of the pre-built database provided by an embodiment of the present invention;

[0072] Figure 4 is a flowchart of a multi-source public service facility database integration and merging method provided by another embodiment of the present invention;

[0073] Figure 5 is a schematic structural diagram of the merged database and the manual discrimination database provided by an embodiment of the present invention;

[0074] Figure 6 is a schematic structural diagram of a multi-source public service facility database integration and merging device provided by an embodiment of the present invention;

[0075] Figure 7 is a schematic structural diagram of a multi-source public service facility database integration and merging device provided by another embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0076] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without making creative efforts shall fall within the protection scope of the present invention.

[0077] The embodiment of the present invention provides a method for integrating and merging multi-source public service facility databases. Refer to Figure 1 , which is a schematic flowchart of a method for integrating and merging multi-source public service facility databases provided by the embodiment of the present invention, including steps S1 to S5:

[0078] S1. Determine the base layer and the merging layer in the public service facility database to be merged, and store them separately.

[0079] S2. Calculate the point distance between the point features in the base layer and the point features in the merging layer.

[0080] S3. Merge the point features in the merging layer that meet the preset conditions with the base layer according to the calculated point distance and the facility names of the point features.

[0081] S4. Determine the centroids of the polygon features in the base layer and the merging layer, and calculate the centroid distance between the centroid of the polygon feature in the base layer and the centroid of the polygon feature in the merging layer.

[0082] S5. Merge the polygon features in the merging layer that meet the preset conditions with the base layer according to the calculated centroid distance and the facility names of the polygon features.

[0083] When specifically implementing this embodiment, the process of integrating and merging the multi-source public service facility database based on GIS specifically includes:

[0084] First, determine the base layer and the merging layer in the public service facility database to be merged. The base layer serves as the basis for merging, and the data in the merging layer is merged into the base layer to form the data of the merged database.

[0085] Among them, the public service facility data in the public service facility database usually includes point features and polygon features. When merging, it is necessary to merge the point data and the polygon data separately.

[0086] When merging the point features, it is necessary to calculate the point distance between the point features in the base layer and the point features in the merging layer, and merge the point features in the merging layer that meet the preset conditions with the base layer according to the calculated point distance and the facility names of the point features.

[0087] When merging opposite elements, determine the centroids of the polygon elements in the base layer and the merging layer, and calculate the centroid distance between the centroid of the polygon element in the base layer and the centroid of the polygon element in the merging layer; according to the calculated centroid distance and the facility names of the polygon elements, merge the polygon elements in the merging layer that meet the preset conditions with the base layer.

[0088] By calculating the distances between the point elements and polygon elements of the base layer and the merging layer, and performing element merging according to the distances and the corresponding facility names, the integration and merging of the multi-source public service facility database are realized, avoiding the repetition, confusion and loss of data in the data calling and processing process.

[0089] In another embodiment provided by the present invention, the public service facility database to be merged includes at least two public service facility databases;

[0090] The step S1 specifically includes:

[0091] Take one of the public service facility databases in the public service facility database to be merged as the base layer, and take the other public service facility databases as the merging layer;

[0092] Store the base layer and the merging layer into the pre-built JCTC.gdb file geodatabase and the pre-built HBTC.gdb file geodatabase respectively.

[0093] When specifically implementing this embodiment, the public service facility database to be merged is a multi-source public service facility database, which includes at least two public service facility databases, and each public service facility database includes point elements and polygon elements;

[0094] The process of determining the base layer and the merging layer is: take one of the public service facility databases as the base layer, and take the other public service facility databases as the merging layer;

[0095] Store the base layer and the merging layer into the pre-built JCTC.gdb file geodatabase and the pre-built HBTC.gdb file geodatabase respectively, as shown in Figure 2 which is a schematic structural diagram of the JCTC.gdb file geodatabase and the HBTC.gdb file geodatabase provided by the embodiment of the present invention;

[0096] The JCTC.gdb file geodatabase includes the polygon element mian1 and the point element dian1 in the base layer;

[0097] The HBTC.gdb file geodatabase includes the polygon element mian2 and the point element dian2 in the merging layer.

[0098] By pre-determining the base layer and the merged layer, a corresponding database is established to facilitate subsequent integration and merging of the databases.

[0099] In another embodiment provided by the present invention, step S3 specifically includes:

[0100] When the point distance between the point feature in the merged layer and the point feature in the base layer is less than the preset search radius, and the facility names of the point feature in the merged layer and the point feature in the base layer are the same, it is determined as the same point feature, and the two point features are merged;

[0101] When the point distance between the point feature in the merged layer and the point feature in the base layer is less than the search radius, and the facility names of the point feature in the merged layer and the point feature in the base layer are different, it is determined as a different point feature, and the point feature in the merged layer is output to the pre-established manual discrimination database;

[0102] When the point distance between the point feature in the merged layer and the point feature in the base layer is not less than the search radius, the point feature in the merged layer is output to the pre-established merge database.

[0103] When specifically implementing this embodiment, refer to Figure 3 , which is a schematic structural diagram of the pre-established database provided by the embodiment of the present invention;

[0104] When performing layer merging, first create a manual discrimination database RGPB.gdb, a merge database HB.gdb, and a process database GC.gdb in the stored procedure;

[0105] The newly created database, base layer, and merged layer are all file geodatabases.

[0106] Refer to Figure 4 , which is a schematic flowchart of the method for integrating and merging multi-source public service facility databases provided by another embodiment of the present invention; when performing merging, the specific steps are as follows:

[0107] First, perform the merging of point features. Taking the point features in the base layer as input features, calculate the point distance between the point features in the base layer and the point features in the merged layer;

[0108] Judge the calculated point distance to determine whether the point distance is less than the error limited by the preset search radius;

[0109] When the point distance is not less than the error, the point feature in the merged layer is output to Database 2 for merging and adding. Database 2 is the merge database;

[0110] When the point distance is less than the error, obtain the facility names of the point features in the merged layer and the facility names of the point features in the base layer, and determine whether the facility names of the point features in the merged layer are the same as those of the point features in the base layer;

[0111] When the facility names are the same, it is determined as a duplicate facility, the judgment ends, and the point features in the merged layer and the point features in the base layer are output as the same point feature, and the corresponding number is output;

[0112] When the facility names are different, output to Database 1, which is a manual discrimination database, and subsequent manual discrimination is performed.

[0113] By calculating the point distance between the point features in the base layer and the point features in the merged layer, and comprehensively considering the facility names, the point features are preliminarily merged.

[0114] In another embodiment provided by the present invention, after outputting the point features in the merged layer to a pre-built merged database, the method further includes:

[0115] Determine whether the point features in the merged database are within the polygon features of the base layer, and compare the facility names of the point features in the merged database with the facility names of the polygon features of the base layer;

[0116] When the point features in the merged database are within the polygon features of the base layer, and the facility names of the point features in the merged database are the same as those of the polygon features of the base layer, the point features in the merged database are determined as duplicate facilities, and the corresponding point features in the merged database are deleted;

[0117] When the point features in the merged database are within the polygon features of the base layer, and the facility names of the point features in the merged database are different from those of the polygon features of the base layer, the point features in the merged database are output to the manual discrimination database.

[0118] When the point features in the merged database are not within the polygon features of the base layer, the point features in the merged database are stored in the merged database.

[0119] In the specific implementation of this embodiment, refer to Figure 4 After outputting the point features in the merged layer to a pre-built merged database, it is necessary to determine whether the point features in the merged layer are within the polygon features of the base layer.

[0120] Determine whether the point feature is within the polygon of the polygon feature;

[0121] When it is not within the polygon feature, retain it in Database 2 for merged addition, and Database 2 is the merged database.

[0122] If it is within the surface element, check the facility names of the two;

[0123] If the facility names of the two are the same, it is determined as a duplicate facility, and the corresponding point element in the merged database is deleted to end the determination;

[0124] If the facility names of the two are different, output them to Database 1 for subsequent manual discrimination.

[0125] By judging whether the point element is within the surface element, the problem of omission of point elements during merging can be avoided, and the accuracy of the merged data can be improved.

[0126] In another embodiment provided by the present invention, the step S5 specifically includes:

[0127] When the centroid distance between the surface element in the merged layer and the surface element in the base layer is less than the preset centroid radius, and the facility name of the surface element in the merged layer is the same as the facility name of the surface element in the base layer, it is determined as the same surface element, and the two surface elements are merged;

[0128] When the centroid distance between the surface element in the merged layer and the surface element in the base layer is less than the centroid radius, and the facility name of the surface element in the merged layer is different from the facility name of the surface element in the base layer, it is determined as a different surface element, and the surface element in the merged layer is output to the manual discrimination database;

[0129] When the centroid distance between the surface element in the merged layer and the surface element in the base layer is not less than the centroid radius, the surface element in the merged layer is output to the pre-built process database.

[0130] When specifically implementing this embodiment, refer to Figure 2 , the process of surface element recognition specifically includes:

[0131] Obtain the centroid of the graph by converting the surface elements in the base layer and the surface elements in the merged layer into points, and calculate the centroid distance between the centroids of the surface elements in the base layer and the surface elements in the merged layer;

[0132] And judge whether the centroid distance is within the error range of the centroid radius;

[0133] If it is not within the error range, output it to the process database, and then judge whether there are elements with the same facility name in the base layer.

[0134] If it is within the error range, check the facility names and judge whether the facility name of the surface element in the merged layer is the same as the facility name of the surface element in the base layer;

[0135] If the facility names are the same, it is determined that they are the same face elements, the two face elements are merged, the number is output, and the judgment ends;

[0136] If the facility names are different, output them to the artificial database 1 for subsequent manual discrimination.

[0137] By calculating the centroid distance between face elements and combining the facility names, the face elements are merged.

[0138] In another embodiment provided by the present invention, after outputting the face elements in the merged layer to the pre-built process database, the method further includes:

[0139] Determine whether there are elements in the basic layer with the same facility name as the face elements in the process database;

[0140] If so, output the corresponding face elements in the process database to the artificial discrimination database;

[0141] If not, output the corresponding face elements in the process database to the merged database.

[0142] When specifically implementing this embodiment, after outputting the face elements in the merged layer to the pre-built process database, determine whether the facility names of the face elements in the merged layer are the same as those of the face elements in the basic layer;

[0143] If so, output the corresponding face elements in the process database to database 1 for subsequent manual discrimination;

[0144] If not, output the corresponding face elements in the process database to database 2 and add them.

[0145] By re-matching the face elements in the basic layer, the loss of face layer data is avoided, and the accuracy of database merging is provided.

[0146] In another embodiment provided by the present invention, the method further includes:

[0147] Use the data management tools in the arcgis toolbox to merge the point elements in the merged database with the point elements in the basic layer, and use the data management tools in the arcgis toolbox to merge the face elements in the merged database with the face elements in the basic layer;

[0148] Manually verify the point elements and face elements in the artificial discrimination database.

[0149] When specifically implementing this embodiment, refer to Figure 5 , which is a schematic structural diagram of the merged merged database and artificial discrimination database provided by the embodiments of the present invention;

[0150] Merge the point feature hbd and the polygon feature hbm in the combined database HB.gdb;

[0151] Manually identify that the point feature rgpbd and the polygon feature rgpbm are included in the database RGPB.gdb;

[0152] Use the Merge tool in the Data Management Tools - General - Merge tool in the arcgis toolbox to merge the point features in the combined database with the point features in the base layer, and use the Merge tool in the Data Management Tools - General - Merge tool in the arcgis toolbox to merge the polygon features in the combined database with the polygon features in the base layer;

[0153] For the manually identified database, it is necessary to manually check whether a new merge is required;

[0154] The preferred method is to merge the point data and polygon data in the manually identified database in the same way as the combined database, or discard the point data and polygon data in the manually identified database.

[0155] Through the merge process of the manually identified database and the combined database, the database merge can be completed.

[0156] In another embodiment of the present invention, a multi-source public service facility database integration and merging device is provided. Refer to Figure 6 As shown, it is a schematic structural diagram of a multi-source public service facility database integration and merging device provided by an embodiment of the present invention. The device includes:

[0157] A layer determination module, configured to determine the base layer and the merge layer in the public service facility database to be merged, and store them separately;

[0158] A point distance calculation module, configured to calculate the point distance between the point features in the base layer and the point features in the merge layer;

[0159] A point feature merge module, configured to merge the point features in the merge layer that meet the preset conditions with the base layer according to the calculated point distance and the facility name of the point features;

[0160] A centroid distance calculation module, configured to determine the centroids of the polygon features in the base layer and the merge layer, and calculate the centroid distance between the centroid of the polygon feature in the base layer and the centroid of the polygon feature in the merge layer;

[0161] A polygon feature merge module, configured to merge the polygon features in the merge layer that meet the preset conditions with the base layer according to the calculated centroid distance and the facility name of the polygon features.

[0162] It should be noted that the specific functions of each module are described in the embodiments of the above method for integrating and merging multi-source public service facility databases, and will not be elaborated in this embodiment.

[0163] See Figure 7 , which is a schematic diagram of a multi-source public service facility database integration and merging device provided by another embodiment of the present invention. The multi-source public service facility database integration and merging device of this embodiment includes: a processor, a memory, and a computer program stored in the memory and executable on the processor, such as a multi-source public service facility database integration and merging program. When the processor executes the computer program, the steps in the above embodiments of each multi-source public service facility database integration and merging method are implemented, such as Figure 1 the steps S1 to S5 shown. Alternatively, when the processor executes the computer program, the functions of each module / unit in the above device embodiments are implemented.

[0164] Exemplarily, the computer program can be divided into one or more modules / units. The one or more modules / units are stored in the memory and executed by the processor to complete the present invention. The one or more modules / units can be a series of computer program instruction segments capable of performing specific functions, and these instruction segments are used to describe the execution process of the computer program in the multi-source public service facility database integration and merging device. For example, the computer program can be divided into each module, and the specific functions will not be elaborated.

[0165] The multi-source public service facility database integration and merging device can be a computing device such as a desktop computer, a notebook, a palm computer, and a cloud server. The multi-source public service facility database integration and merging device may include, but is not limited to, a processor and a memory. Those skilled in the art can understand that the schematic diagram is only an example of the multi-source public service facility database integration and merging device, and does not constitute a limitation on the multi-source public service facility database integration and merging device. It may include more or fewer components than shown, or combine some components, or different components. For example, the multi-source public service facility database integration and merging device may further include input / output devices, network access devices, a bus, etc.

[0166] The so-called processor may be a Central Processing Unit (CPU), or may also be other general-purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field-Programmable Gate Arrays (FPGAs), or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc. The processor is the control center of the multi-source public service facility database merging device, and connects various parts of the entire multi-source public service facility database merging device through various interfaces and lines.

[0167] The memory can be used to store the computer programs and / or modules. By running or executing the computer programs and / or modules stored in the memory, and by calling the data stored in the memory, the processor realizes various functions of the multi-source public service facility database merging device. The memory mainly includes a program storage area and a data storage area. Among them, the program storage area can store an operating system, application programs required for at least one function (such as a sound playback function, an image playback function, etc.); the data storage area can store data created according to the use of the mobile phone (such as audio data, phone book, etc.). In addition, the memory may include high-speed random access memory, and may also include non-volatile memory, such as a hard disk, memory, plug-in hard disk, Smart Media Card (SMC), Secure Digital (SD) card, Flash Card, at least one magnetic disk storage device, flash memory device, or other volatile solid-state storage devices.

[0168] Among them, if the modules / units integrated by the multi-source public service facility database integration and merging device are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on such an understanding, to implement all or part of the processes in the above-mentioned embodiment methods of the present invention, it can also be completed by instructing relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by a processor, the steps of the above-mentioned various method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in the form of source code, object code, executable file, or some intermediate form, etc. The computer-readable medium can include: any entity or device capable of carrying the computer program code, recording medium, USB flash drive, mobile hard disk, magnetic disk, optical disc, computer memory, read-only memory (ROM), random access memory (RAM), electrical carrier signal, telecommunication signal, and software distribution medium, etc. It should be noted that the content included in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, the computer-readable medium does not include electrical carrier signals and telecommunication signals.

[0169] It should be noted that the device embodiments described above are only illustrative. The units described as separate components may or may not be physically separated. The components shown as units may or may not be physical units, that is, they may be located in one place or distributed to multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution of this embodiment. In addition, in the attached drawings of the device embodiments provided by the present invention, the connection relationship between the modules indicates that they have a communication connection, which can be specifically implemented as one or more communication buses or signal lines. Those of ordinary skill in the art can understand and implement it without creative efforts.

[0170] The present invention provides a method, apparatus, storage medium and apparatus for integrating and merging multi-source public service facility databases. By setting the land use type of the to-be-modeled plot, the to-be-modeled plot is divided into several sub-plots; several basic building components are generated, and probability data of each basic building component on the to-be-modeled plot is set; a 3D urban model is generated according to the probability data; building type parameters are obtained according to the land use type, and the parameters of the 3D urban model are adjusted according to the building type parameters; texture patterns in a pre-established texture library are pasted into the 3D urban model according to the land use type to generate a standard 3D urban model, and urban roads are generated in the standard 3D urban model according to a preset road generation rule. The modeling method is more convenient for modeling, and the model can be adjusted according to the planning index parameters to achieve fast and automatic batch modeling, and the authenticity of the model simulation is higher.

[0171] The above is the preferred embodiment of the present invention. It should be noted that for those of ordinary skill in the art of this technology, without departing from the principle of the present invention, several improvements and refinements can be made, and these improvements and refinements are also regarded as the protection scope of the present invention.

Claims

1. A method for integrating and merging multi-source public service facility databases, characterized in that, Including: Determine the base layer and the merging layer in the public service facility database to be merged, and store them separately; Calculate the point distance between the point features in the base layer and the point features in the merging layer; Merge the point features in the merging layer that meet the preset conditions with the base layer according to the calculated point distance and the facility names of the point features; Determine the centroids of the polygon features in the base layer and the merging layer, and calculate the centroid distance between the centroid of the polygon feature in the base layer and the centroid of the polygon feature in the merging layer; Merge the polygon features in the merging layer that meet the preset conditions with the base layer according to the calculated centroid distance and the facility names of the polygon features; The step of merging the point features in the merging layer that meet the preset conditions with the base layer according to the calculated point distance and the facility names of the point features specifically includes: When the point distance between the point feature in the merging layer and the point feature in the base layer is less than the preset search radius, and the facility names of the point feature in the merging layer and the point feature in the base layer are the same, it is determined as the same point feature, and the two point features are merged; When the point distance between the point feature in the merging layer and the point feature in the base layer is less than the search radius, and the facility names of the point feature in the merging layer and the point feature in the base layer are different, it is determined as different point features, and the point feature in the merging layer is output to the pre-built manual discrimination database; When the point distance between the point feature in the merging layer and the point feature in the base layer is not less than the search radius, the point feature in the merging layer is output to the pre-built merging database; The step of merging the polygon features in the merging layer that meet the preset conditions with the base layer according to the calculated centroid distance and the facility names of the polygon features specifically includes: When the centroid distance between the polygon feature in the merging layer and the polygon feature in the base layer is less than the preset centroid radius, and the facility names of the polygon feature in the merging layer and the polygon feature in the base layer are the same, it is determined as the same polygon feature, and the two polygon features are merged; When the centroid distance between the polygon feature in the merging layer and the polygon feature in the base layer is less than the centroid radius, and the facility names of the polygon feature in the merging layer and the polygon feature in the base layer are different, it is determined as different polygon features, and the polygon feature in the merging layer is output to the manual discrimination database; When the centroid distance between the polygon feature in the merging layer and the polygon feature in the base layer is not less than the centroid radius, the polygon feature in the merging layer is output to the pre-built process database.

2. The method for integrating and merging multi-source public service facility databases according to claim 1, characterized in that, The public service facility database to be merged includes at least two public service facility databases; The step of determining the base layer and the merging layer in the public service facility database to be merged and storing them separately specifically includes: Take one public service facility database in the public service facility database to be merged as the base layer, and take the other public service facility databases as the merging layer; Store the base layer and the merged layer into a pre-built JCTC.gdb file geodatabase and a pre-built HBTC.gdb file geodatabase respectively.

3. The method for integrating and merging multi-source public service facility databases according to claim 1, characterized in that After outputting the point features in the merged layer to a pre-built merged database, the method further includes: Determine whether the point features in the merged database are within the polygon features of the base layer, and compare the facility names of the point features in the merged database with the facility names of the polygon features of the base layer; When the point features in the merged database are within the polygon features of the base layer and the facility names of the point features in the merged database are the same as those of the polygon features of the base layer, determine the point features in the merged database as duplicate facilities and delete the corresponding point features in the merged database; When the point features in the merged database are within the polygon features of the base layer and the facility names of the point features in the merged database are different from those of the polygon features of the base layer, output the point features in the merged database to the manual discrimination database; When the point features in the merged database are not within the polygon features of the base layer, store the point features in the merged database in the merged database.

4. The method for integrating and merging multi-source public service facility databases according to claim 1, characterized in that, After outputting the polygon features in the merged layer to a pre-built process database, the method further includes: Determine whether there are features in the base layer with the same facility name as the polygon features in the process database; If so, output the corresponding polygon features in the process database to the manual discrimination database; If not, output the corresponding polygon features in the process database to the merged database.

5. The method for integrating and merging multi-source public service facility databases according to claim 4, wherein, The method further includes: Use the Merge tool in the Data Management Tools - General - Merge tool in the arcgis toolbox to merge the point features in the merged database with the point features in the base layer, and use the Merge tool in the Data Management Tools - General - Merge tool in the arcgis toolbox to merge the polygon features in the merged database with the polygon features in the base layer; Manually verify the point features and polygon features in the manual discrimination database.

6. A multi-source public service facility database integration and merging device, characterized in that, The device includes: A layer determination module for determining the base layer and the merged layer in the database of public service facilities to be merged and storing them separately; A point distance calculation module for calculating the point distance between the point features in the base layer and the point features in the merged layer; A point feature merging module for merging the point features in the merged layer that meet the preset conditions with the base layer according to the calculated point distance and the facility names of the point features; A centroid distance calculation module for determining the centroids of the polygon features in the base layer and the merged layer and calculating the centroid distance between the centroid of the polygon features in the base layer and the centroid of the polygon features in the merged layer; A polygon feature merging module for merging the polygon features in the merged layer that meet the preset conditions with the base layer according to the calculated centroid distance and the facility names of the polygon features; The point feature merging module is specifically used for: When the point distance between the point feature in the merged layer and the point feature in the base layer is less than the preset search radius, and the facility names of the point feature in the merged layer and the point feature in the base layer are the same, it is determined as the same point feature, and the two point features are merged; When the point distance between the point feature in the merged layer and the point feature in the base layer is less than the search radius, and the facility names of the point feature in the merged layer and the point feature in the base layer are different, it is determined as a different point feature, and the point feature in the merged layer is output to the pre-built manual discrimination database; When the point distance between the point feature in the merged layer and the point feature in the base layer is not less than the search radius, the point feature in the merged layer is output to the pre-built merge database; The surface feature merging module is specifically used for: When the centroid distance between the surface feature in the merged layer and the surface feature in the base layer is less than the preset centroid radius, and the facility names of the surface feature in the merged layer and the surface feature in the base layer are the same, it is determined as the same surface feature, and the two surface features are merged; When the centroid distance between the surface feature in the merged layer and the surface feature in the base layer is less than the centroid radius, and the facility names of the surface feature in the merged layer and the surface feature in the base layer are different, it is determined as a different surface feature, and the surface feature in the merged layer is output to the manual discrimination database; When the centroid distance between the surface feature in the merged layer and the surface feature in the base layer is not less than the centroid radius, the surface feature in the merged layer is output to the pre-built process database.

7. A multi-source public service facility database integration and merging device, characterized in that, It includes a processor, a memory, and a computer program stored in the memory and configured to be executed by the processor. When the processor executes the computer program, it implements the multi-source public service facility database integration and merging method according to any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that, The computer-readable storage medium includes a stored computer program, wherein when the computer program runs, it controls the device where the computer-readable storage medium is located to execute the multi-source public service facility database integration and merging method according to any one of claims 1 to 5.

Images