CN114490907A - Method and device for constructing famous city management database and storage medium - Google Patents

Abstract

The invention relates to the technical field of famous city data management, and discloses a method, a device and a storage medium for constructing a famous city management database, wherein the method comprises the following steps: acquiring famous city management data; the famous city management data comprise two-dimensional basic geographic information data, three-dimensional basic geographic information data, land utilization current situation data, city planning related data, famous city protection one-map achievement data, laser point cloud data, BIM model data, a refined monomer model and a three-dimensional real scene model; the data base constructed by the invention meets the high control requirement during planning and compiling, meets the requirements of micro and fine management of the famous city protected objects and the requirements of high-precision simulation display and visualization expression in the famous city management process, and provides data support for famous city protection planning, engineering construction, repair management and daily maintenance.

Description

Construction method, device and storage medium of famous city management database

technical field

The invention relates to the technical field of famous city data management, in particular to a construction method, device and storage medium of a famous city management database.

Background technique

The protection objects of famous historical and cultural cities refer to the national land space with specific cultural significance due to human activities, the space with immovable cultural relics and their environment as the core elements, mainly including historical urban areas, historical and cultural towns, historical and cultural villages, traditional Villages, historical and cultural blocks, historical features areas, cultural relics protection units, immovable cultural relics that are not protected by cultural relics, historical buildings, famous and ancient trees, etc. In the preparation of the famous city protection plan, the core protection scope, construction control area and environmental coordination area of the famous city protection object all have high control requirements. In the prior art, the data in the famous city management database is based on two-dimensional expression data. It is difficult to visually and intuitively meet the high control requirements during the preparation of the protection planning of famous cities, and it is also difficult to meet the needs of microscopic and refined management of the protection objects of famous cities, and it is also difficult to meet the needs of high-precision simulation display and visual expression in the process of management of famous cities.

SUMMARY OF THE INVENTION

The purpose of the present invention is to provide a construction method, device and storage medium for a famous city management database, which can convert the format and coordinates of multi-source data and integrate them into a database, so that the famous city management database can meet the high degree of control during planning and compilation. It meets the requirements of the microscopic and refined management of the protection objects of the famous city, and meets the needs of high-precision simulation display and visual expression in the management process of the famous city, and provides data support for the protection planning, engineering construction, repair management and daily maintenance of the famous city.

In order to solve the above-mentioned technical problems, the present invention provides a construction method of a famous city management database, comprising:

Obtain famous city management data; wherein, the famous city management data includes two-dimensional basic geographic information data, three-dimensional basic geographic information data, land use status data, urban planning-related data, data of a map of famous city protection, and laser points of famous city protection objects Cloud data, the BIM model data of the protection object of the famous city, the refined single model of the protection object of the famous city, and the three-dimensional reality model of the protection object of the famous city;

Perform data format conversion processing on the famous city management data;

Perform coordinate transformation processing on the famous city management data;

The famous city management data after data format conversion processing and coordinate conversion processing is put into the database to form a famous city management database.

As an improvement of the above scheme, it also includes:

Obtain the panoramic image data of the famous city protection object and the unstructured data of the famous city protection object;

respectively establishing an association relationship between the panoramic image data, the unstructured data and the famous city management data;

Import the panoramic image data and the unstructured data into the famous city management database.

As an improvement of the above scheme, before the famous city management data after data format conversion processing and coordinate conversion processing is stored in the database, it also includes:

Compile the 3D basic geographic information data after data format conversion processing and coordinate conversion processing.

As an improvement of the above scheme, the coordinate conversion processing of the famous city management data is carried out in the following ways:

The first coordinate transformation processing is performed on the two-dimensional basic geographic information data, the current land use data, the urban planning-related data and the result data of a map of famous city protection, so that the two-dimensional basic geographic information data , the coordinates of the current land use data, the urban planning related data and the data of the famous city protection map are converted into coordinates under the first target coordinate system;

Performing coordinate matching processing on the three-dimensional basic geographic information data, so that the coordinates of the three-dimensional basic geographic information data of different coordinate types have a matching relationship;

performing a second coordinate conversion process on the laser point cloud data, so that the coordinates of the laser point cloud data are converted into coordinates in the second target coordinate system;

performing a third coordinate conversion process on the BIM model data, so that the coordinates of the BIM model data are converted into coordinates in a third target coordinate system;

performing a fourth coordinate transformation process on the refined cell model, so that the coordinates of the refined cell model are converted into coordinates in a fourth target coordinate system;

performing a fifth coordinate transformation process on the three-dimensional reality model, so that the coordinates of the three-dimensional reality model are converted into coordinates in the fifth target coordinate system;

Coordinate matching processing is performed on all the famous city management data, so that the coordinates of each famous city management data have a matching relationship.

As an improvement of the above solution, after the second coordinate transformation processing is performed on the laser point cloud data, and before the coordinate matching processing is performed on all the famous city management data, the method further includes:

Perform fusion and splicing processing on the laser point cloud data;

Lightweight processing is performed on the laser point cloud data.

As an improvement of the above solution, after the third coordinate conversion processing is performed on the BIM model data, and before the coordinate matching processing is performed on all the famous city management data, the method further includes:

Lightweight processing is performed on the BIM model data.

As an improvement of the above solution, the lightweight processing of the BIM model data specifically includes:

The digital-model separation processing, the instantiation processing of similar objects, and the separation processing of the model shell and the internal model are performed on the BIM model data.

As an improvement of the above scheme, before the famous city management data after data format conversion processing and coordinate conversion processing is stored in the database, it also includes:

Perform pre-warehouse data inspection on the famous city management data after data format conversion processing and coordinate conversion processing;

After storing the famous city management data after data format conversion processing and coordinate conversion processing, the method further includes: performing a post-warehouse data check on the famous city management data after data format conversion processing and coordinate conversion processing.

In order to solve the same technical problem, correspondingly, an embodiment of the present invention also provides a device for constructing a famous city management database, including:

The data acquisition module is used to acquire the famous city management data; wherein, the famous city management data includes two-dimensional basic geographic information data, three-dimensional basic geographic information data, current land use data, data related to urban planning, data on the results of a map of famous city protection, The laser point cloud data of the famous city protection object, the BIM model data of the famous city protection object, the refined single model of the famous city protection object, and the three-dimensional reality model of the famous city protection object;

a format conversion module, for performing data format conversion processing on the famous city management data;

a coordinate conversion module, used for coordinate conversion processing on the famous city management data;

The database building module is used to store the famous city management data after data format conversion processing and coordinate conversion processing to form a famous city management database.

In order to solve the same technical problem, correspondingly, an embodiment of the present invention further provides a computer-readable storage medium, where a program is stored on the storage medium, and when the program is executed, the above-mentioned any one of the embodiments can be implemented. The construction method of famous city management database.

Compared with the prior art, the embodiment of the present invention provides a method, device and storage medium for constructing a famous city management database, by performing format conversion processing and coordinate conversion processing on the acquired multi-source famous city management data; wherein; the famous city The management data includes two-dimensional basic geographic information data, three-dimensional basic geographic information data, land use status data, urban planning-related data, data of a map of famous city protection, laser point cloud data of famous city protection objects, and BIM of said famous city protection objects Model data, the refined single model of the famous city protection object, and the three-dimensional real scene model of the famous city protection object; the name management data after data format conversion processing and coordinate conversion processing are stored in the database to construct a famous city management database. It can be seen that the embodiment of the present invention can transform the format and coordinates of the multi-source data and integrate them into a database, so that the famous city management database can meet the high control requirements during planning and preparation, and meet the requirements of the microscopic and refined management of the protection objects of famous cities As well as meeting the needs of high-precision simulation display and visual expression in the management process of famous cities, it provides data support for the protection planning, engineering construction, repair management and daily maintenance of famous cities.

Description of drawings

1 is a schematic flowchart of a method for constructing a famous city management database provided by an embodiment of the present invention;

2 is a schematic diagram of object classification and data composition of a name management database provided by an embodiment of the present invention;

3 is a global display diagram of the two-dimensional basic geographic information data provided by an embodiment of the present invention after storage;

4 is a partial display diagram of the two-dimensional basic geographic information data provided by an embodiment of the present invention after storage;

5 is a display diagram of the three-dimensional basic geographic information data provided by an embodiment of the present invention after storage;

6 is a display diagram of the land use status data provided by an embodiment of the present invention after storage;

7 is a display diagram of the city planning-related data provided by an embodiment of the present invention after storage;

8 is a display diagram of a historical and cultural block provided by an embodiment of the present invention;

9 is a data display diagram of classified protection and remediation measures for block structures and historical environmental elements provided by an embodiment of the present invention;

10 is a display diagram of the laser point cloud data of a city protection object provided by an embodiment of the present invention after storage;

11 is a display diagram of another city protection object provided by an embodiment of the present invention after the laser point cloud data is stored;

FIG. 12 is a display diagram of the BIM storage of the famous city protection object provided by an embodiment of the present invention;

13 is a display diagram of a BIM component of a famous city protection object provided by an embodiment of the present invention after storage;

14 is a display diagram of the refined monomer model of the famous city protection object provided by an embodiment of the present invention after storage;

15 is a display diagram of a three-dimensional reality model of a famous city protection object provided by an embodiment of the present invention after storage;

16 is a display diagram after the panoramic image data of the protected object of the famous city provided by an embodiment of the present invention is stored;

17 is a plan view showing a famous city protection object provided by an embodiment of the present invention;

18 is a picture display diagram of a famous city protection object provided by an embodiment of the present invention;

FIG. 19 is a schematic structural diagram of an apparatus for constructing a famous city management database provided by an embodiment of the present invention.

Detailed ways

The technical solutions in the embodiments of the present invention will be clearly and completely described below 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, but not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

Referring to FIG. 1 , it is a schematic flowchart of a method for constructing a famous city management database according to an embodiment of the present invention. In an embodiment of the present invention, the construction method of the famous city management database comprises the following steps:

S1. Obtaining famous city management data; wherein, the famous city management data includes two-dimensional basic geographic information data, three-dimensional basic geographic information data, land use status data, urban planning-related data, data of a map of famous city protection, and data of famous city protection objects. Laser point cloud data, BIM model data of the protection object of the famous city, refined single model of the protection object of the famous city, 3D real scene model of the protection object of the famous city;

S2, performing data format conversion processing on the famous city management data;

S3, performing coordinate transformation processing on the famous city management data;

S4. Enter the famous city management data after data format conversion processing and coordinate conversion processing into a database to form a famous city management database.

Specifically, referring to the object classification and data composition of the name management database shown in FIG. 2 , the management objects of famous cities include historical urban areas, famous historical and cultural towns, famous historical and cultural villages, traditional villages, historical and cultural blocks, historical feature areas, and cultural relics protection units , non-removable cultural relics, historical buildings and famous and ancient trees, etc., the specific classification can be set according to the actual situation. Famous city management data includes two-dimensional basic geographic information data, three-dimensional basic geographic information data, land use status data, urban planning-related data, data of a map of famous city protection, laser point cloud data of famous city protection objects, and BIM model of famous city protection objects Data, refined single model of famous city protection objects, 3D reality model of famous city protection objects and other types of data.

Two-dimensional basic geographic information data mainly includes administrative divisions, electronic maps, satellite image maps, aerial image maps, place names and addresses, points of interest (POI), etc. These data are mainly in GIS format. The 3D basic geographic information data mainly includes terrain models (digital elevation models and digital orthophotos), building models, transportation facilities models, water system models, vegetation models, pipeline models, etc. These data are mainly 3D models, which are the objects of protection for other famous cities. BIM models of historical buildings, oblique photography models, and laser point cloud models provide basic 3D spatial positioning. The land use status data are mainly in two-dimensional and GIS format, including agricultural land, construction land, other land, etc., to provide a base map of land use status for the preparation process of the famous city protection plan. The data related to urban planning are mainly in two-dimensional and GIS format, mainly including the overall urban planning, detailed planning, other special planning (except the famous city protection planning data), the overall planning of land use, etc., to provide reference for the preparation of the famous city protection planning . The data of a map of famous city protection mainly includes the urban area of the historical city, famous historical and cultural towns, famous historical and cultural villages, traditional villages, historical and cultural blocks, core protection areas of historical and cultural districts, construction control areas, environmental coordination areas, and cultural preservation buildings. This kind of data is mainly in two-dimensional and GIS format. BIM model data mainly refers to the BIM model data of individual buildings such as historical buildings and cultural relics protection units, as well as BIM component data such as woodcuts, brick carvings, and screens. This type of data is mainly in the BIM model format. BIM models and components It is constructed in BIM modeling software (such as Revit, ArchiCAD, Bentley Navigator, etc.), through the identification of value elements and characteristic parts of the BIM data of some cultural relics and historical buildings, and the use of parametric family libraries to produce multi-style components , in the daily repair management process of historical buildings, it can be replaced as needed according to the requirements of repair management, so as to provide an intuitive and measurable basis for design, approval and decision-making; in addition, in the process of protection or management of famous cities, the use of BIM The cultural relics and single components of historical buildings produced by related tools and technologies can dynamically simulate and restore the building construction process when the time attribute is given according to the construction process. Delicate management needs in the application of historical and cultural city management. The refined single model is mainly for some special protection objects of famous cities, such as some historical buildings, important cultural relics protection objects, etc., which need to be linked with some related attributes or related related images, videos and other information, and need to use traditional manual construction. Modeling software such as the refined monomer model produced by 3dMax, the main format of this type of data is *.3ds, and the refined monomer model is obtained by the following methods: obtain field data collection → build a grid 3D model → use 3dsMAX software to build a refined single model Monolithic model. The 3D reality model (3D oblique model) includes an integrated model and a single model. This kind of data is mainly based on the UAV as the main collection tool, and the 3D reality model established by the oblique photogrammetry technology, such as historical and cultural towns, historical Three-dimensional oblique photographic models of famous cultural villages, traditional villages, historical and cultural blocks, and historical areas.

Since the acquired data are from various sources, the data from different sources are not uniformly set according to the same data format and coordinates when they are initially established. Therefore, the format and coordinates need to be converted and processed according to the The famous city management database is constructed after data format conversion processing and coordinate conversion processing. It can be seen that the embodiment of the present invention can transform the format and coordinates of the multi-source data and integrate them into a database, so that the famous city management database can meet the high control requirements during planning and preparation, and meet the requirements of the microscopic and refined management of the protection objects of famous cities It also meets the needs of high-precision simulation display and visual expression in the management process of famous cities, meets the needs of restoration and simulation of the construction process of historical buildings and repair management, and provides data support for the protection planning, engineering construction, repair management and daily maintenance of famous cities.

In one embodiment, it also includes the following steps:

S5, obtaining the panoramic image data of the famous city protection object and the unstructured data of the famous city protection object;

S6, respectively establishing an association relationship between the panoramic image data, the unstructured data and the famous city management data;

S7. Import the panoramic image data and the unstructured data into the famous city management database.

Exemplarily, data related to famous city management also includes panoramic image data of famous city protection objects and unstructured data (such as drawings (plans, elevations, sections) produced by some historical buildings and cultural relics protection units in the process of census and surveying and mapping. Figures, etc.), images, audio, video, text, etc.), need to be matched with the name protection object, and the matching between different data can be achieved by establishing an association relationship with the famous city management data, and the panoramic image data and unstructured data can be matched. Import famous city management database.

It is worth noting that the panoramic image data (full/street view image data) is mainly obtained through panoramic photography technology to obtain panoramic photos of famous city protection objects (such as historical buildings, famous and ancient trees, etc.), and then processed by corresponding software. Panoramic image data can be measured. This type of data has the characteristics of being vivid, real and intuitive. After each panoramic image data is matched by coordinates, the spatial coordinates, distance and length can be measured.

In one embodiment, before the storing of the famous city management data after data format conversion processing and coordinate conversion processing in step S4, the method further includes: processing the three-dimensional basis after data format conversion processing and coordinate conversion processing. Compile the geographic information data.

Specifically, since the invocation of the three-dimensional basic geographic information data (three-dimensional model) requires the data to be compiled first, in order to shorten the time consumed by the invocation, the three-dimensional model is compiled before the data is stored in the database, and the compiled data is stored in the In the famous city management database, the compiled data can be directly called when calling the 3D basic geographic information data to shorten the calling time.

In one embodiment, in step S3, the famous city management data is processed by coordinate transformation in the following manner;

The first coordinate transformation processing is performed on the two-dimensional basic geographic information data, the current land use data, the urban planning-related data and the result data of a map of famous city protection, so that the two-dimensional basic geographic information data , the coordinates of the current land use data, the urban planning related data and the data of the famous city protection map are converted into coordinates under the first target coordinate system;

Performing coordinate matching processing on the three-dimensional basic geographic information data, so that the coordinates of the three-dimensional basic geographic information data of different coordinate types have a matching relationship;

performing a second coordinate conversion process on the laser point cloud data, so that the coordinates of the laser point cloud data are converted into coordinates in the second target coordinate system;

performing a third coordinate conversion process on the BIM model data, so that the coordinates of the BIM model data are converted into coordinates in a third target coordinate system;

performing a fourth coordinate transformation process on the refined cell model, so that the coordinates of the refined cell model are converted into coordinates in a fourth target coordinate system;

performing a fifth coordinate transformation process on the three-dimensional reality model, so that the coordinates of the three-dimensional reality model are converted into coordinates in the fifth target coordinate system;

Coordinate matching processing is performed on all the famous city management data, so that the coordinates of each famous city management data have a matching relationship.

Specifically, even for the same type of famous city management data, the data format and coordinates are not necessarily the same. For example, the data format of two-dimensional basic geographic information data includes Mapinfo (*.TAB, *.MIF), AutoCAD (*.DWG, * .DXF), ESRI Shape(*.SHP), ESRI Geodatabase(ArcSDE), ESRI Geodatabase(MDB), MicrostationDesign(*.DGN, *.FC1, *.POS), SuperMap(*.sdb/sdd, *.udb /udd), etc., the coordinate system includes such as Beijing 1954 coordinate system, Xi'an 1980 coordinate system, WGS84 coordinate system, CGCS2000 (national 2000 geodetic coordinate system) and so on. Therefore, for different data types, format conversion and coordinate conversion are carried out respectively. First of all, because the data types of two-dimensional basic geographic information data, land use status data, urban planning-related data and famous city protection map result data are two-dimensional , GIS data are mainly, therefore, the data format and coordinates of these data are unified, and then the format and coordinates of the laser point cloud data, BIM model data, refined single model and 3D reality model are unified respectively. , because the actual transformation of the coordinates of the 3D basic geographic information data is more complicated, so only the coordinates need to be matched, so that the coordinates of the 3D basic geographic information data from different sources can be correlated and matched. The matching process makes the coordinates between each data have a matching relationship.

In one embodiment, after the second coordinate transformation processing is performed on the laser point cloud data, and before the coordinate matching processing is performed on all the famous city management data, the method further includes:

Perform fusion and splicing processing on the laser point cloud data;

Lightweight processing is performed on the laser point cloud data.

Specifically, different protection objects of famous cities may use different laser point cloud acquisition methods, such as large historical and cultural towns, historical and cultural villages, traditional villages, etc., mainly adopt the airborne laser point cloud acquisition method. The historical and cultural blocks and historical features districts, etc., are mainly obtained by vehicle-mounted laser point cloud. For historical buildings, cultural relics protection units and other individual or small protected objects, the laser point cloud with ground stations is used to obtain them. The method is mainly based on the fusion and matching of laser point cloud data from different sources, and lightweight processing is carried out by virtue of it. In order to improve the fusion accuracy, this scheme uses the following technologies to fuse and match laser point cloud data from different sources: 1. Feature extraction: comprehensively consider the point density and geometric accuracy of different data sources to extract feature points, lines and surfaces as a registration reference For example, the airborne point cloud with low density uses feature lines or surfaces as registration primitives, and the feature points, lines or surfaces in vehicle-mounted and stand-on point clouds with high density can be used as registration primitives; 2 , Same-name matching: In order to improve the matching efficiency, a feature index structure is established before matching, and as many registration primitives as possible are selected during registration; 3. Local registration: High-precision fusion of adjacent data blocks to improve the relative accuracy between data ;4. Global adjustment: After local registration, global optimization is performed on all fusion data, thereby improving the absolute accuracy of data fusion.

In an embodiment, after the third coordinate transformation processing is performed on the BIM model data, and before the coordinate matching processing is performed on all the famous city management data, the method further includes:

Lightweight processing is performed on the BIM model data.

In an embodiment, the lightweight processing of the BIM model data specifically includes:

The digital-model separation processing, the instantiation processing of similar objects, and the separation processing of the model shell and the internal model are performed on the BIM model data.

Specifically, this scheme adopts the following key technologies to realize the lightweight of BIM model data: 1. Digital-model separation technology of BIM model: BIM model contains spatial graphic data (expressed as 3D model data) and non-spatial attribute data (such as component Attribute data) two parts, which are processed by digital-analog separation technology to separate graphics and attribute data. The two are associated with a unique object identification code. The BIM model after digital-analog separation only contains structured spatial graphic data, which improves database performance. ;2. The instantiation technology of similar objects: it is suitable for the situation where there are many repeated models, so that the same geometric model can be drawn only once, and similar BIM primitives/objects (such as a large number of repeated doors and windows in historical buildings and houses) ) to merge to achieve data compression, only the basic model is loaded when loading, and other models only store the parameters of geometric transformation based on the basic model; 3. BIM model shell and internal model extraction technology: the historical building BIM model in the The external framework and the internal model are stored in different data sets respectively to realize the separation of the internal and external models, and use different models in different application scenarios, such as extracting the external framework for functions such as height control analysis and visual field analysis. When roaming or navigating inside a historic building, the interior model is used.

In one embodiment, before the famous city management data after data format conversion processing and coordinate conversion processing is stored in the database, it also includes:

Perform pre-warehouse data inspection on the famous city management data after data format conversion processing and coordinate conversion processing;

After storing the famous city management data after data format conversion processing and coordinate conversion processing, the method further includes: performing a post-warehouse data check on the famous city management data after data format conversion processing and coordinate conversion processing.

Specifically, the entered warehousing data (famous city management data before warehousing) must pass the system's pre-warehousing check (including data uniqueness, data type, and missing items check) before they can be stored in the collection database; after data warehousing, It must be subject to system inspection after storage to ensure the accuracy of the data. The specific data inspection method can refer to the existing technology.

In one embodiment, the famous city management database is one of a distributed file system (HDFS), a distributed database MongoDB, and a distributed database Hbase. Specifically, the traditional three-dimensional reality model (oblique photography data) processing flow uses common file systems and traditional relational databases for processing. Due to the limited capabilities of common file systems, traditional relational databases have insufficient performance and limited scalability. Implemented by one function, it requires repeated reading, storage and processing. Multiple I/O operations greatly affect the processing efficiency, resulting in slow storage of massive oblique photography data, which often takes weeks or months, affecting the entire work progress. , the use of distributed storage can improve the efficiency of data storage. Further, in addition to coordinate conversion processing and format conversion processing, the processing of oblique photographic data before storage also includes at least one of texture compression, uniform light and color, and model cropping. Specifically, data processing can be performed according to actual conditions.

It can be seen from this that the construction method of the famous city management database provided by the embodiment of the present invention constructs a database integrating multi-source data, which can comprehensively support the protection planning, engineering construction, construction process simulation, repair management, refined expression, etc. The application provides the foundation for the digital, refined and intelligent management of famous cities.

In order to better illustrate the superiority of the constructed famous city management database, the application of the famous city management database will be introduced with specific examples below.

Referring to Figure 3 to Figure 18, it is a display diagram after data storage, specifically, Figure 3 is a global display diagram after two-dimensional basic geographic information data storage, and Figure 4 is a partial two-dimensional basic geographic information data storage after storage. The display diagram (in the dashed box in the figure), Figure 5 is the display diagram after the 3D basic geographic information data is stored in the database (the white model of the building in the figure), and Figure 6 is the display after the land use status data is stored in the database Figures (different land types), Figure 7 is the display map of urban planning related data after storage (different land types), Figure 8 and Figure 9 are the display of a map of famous city protection after the data is stored in the database Figures (Figure 8 is a display diagram of the historical and cultural block (the part inside the dotted line in the figure), Figure 9 is a data display diagram of the classification protection and renovation measures of the buildings and historical environmental elements in the block), Figures 10 and 11 are the lasers of the famous city protection objects The display diagram after the point cloud data is stored in the warehouse. Figure 12 and Figure 13 are the display diagram after the BIM and BIM components of the famous city protection object are stored in the storage, and Figure 14 is the display diagram after the refined single model of the famous city protection object is stored in the storage. , Figure 15 is a display diagram of the three-dimensional reality model of the famous city protection object after storage, Figure 16 is a display diagram (original image is color) after the panoramic image data of the famous city protection object is stored, and Figure 17 is a plan view display of the protection object of the famous city Figure 18 is a picture display of the protected objects of the famous city.

Exemplarily, when using the famous city management database, the BIM model data and the terrain data in the 3D basic geographic information data are simultaneously called. During the calling process, the BIM model data and the terrain data need to be fused and matched, and the BIM model data (such as Historical building model) provides microscopic single model information, and terrain data provides location information and surrounding environment in the macro environment. Integrating BIM data with terrain data can provide more realistic and accurate visualization for famous city management users. Experience, as well as 3D space analysis data support, due to the timeliness of terrain data, the BIM model does not match the terrain, resulting in cracks or holes between the model and the terrain. Mosaic and other operations realize the precise matching display effect of the BIM model seamlessly embedded in the terrain. When calling BIM model data and 3D reality model (oblique photographic model) at the same time, it is necessary to fuse and match the BIM model data and the oblique photographic model. The BIM model of historical buildings generally adopts the engineering coordinate system, which is consistent with the coordinates of the surrounding large-scale oblique photographic model. The system (such as the national 2000 coordinate system) is often different. First, through the coordinate system conversion operation, and then through the model registration, the BIM model in the engineering coordinate system is automatically converted to the specified coordinate system, and then the BIM model is located in the area. The photographic model is inlaid and flattened to achieve a smooth transition between the single BIM model and the oblique photographic model at the data connection. Through mosaic and fusion operations, the matching and connection of the oblique photographic model (oblique photographic data) and the terrain data are realized: the oblique photographic data itself is a digital surface model with real terrain information. The photographic model is superimposed on the existing 3D terrain model, the oblique photographic data provides the surface model of the real-world buildings, and the terrain data provides the location information of the oblique photographic model in the macro environment and the surrounding environment, but due to the oblique photographic data Due to the inconsistency with the original terrain data due to the inconsistency in acquisition time and acquisition accuracy, the terrain conflicts and mismatches between the two types of data are caused. In response to such problems, a digital surface model (DSM) is generated based on the oblique photographic model, and modified according to the height of the digital surface model. Terrain grid value, that is, the height of the terrain is modified by the height of the oblique photographic model, and the above-mentioned height matching method is used as one of the calling constraints of the famous city management database, so as to realize the connection between the oblique photographic model and the terrain data when the data is called. smooth transition. In addition, oblique photogrammetry technology and models have the advantages of high realism, high efficiency, high precision, and low production cost, and can fully perceive complex geographical scenes. They are widely used in the planning, construction and management of historical and cultural cities, but due to oblique photography The data is constructed based on the surface model, which cannot realize the singulation and objectification of surface objects. It is represented as "a piece of skin". It is difficult to attach the attribute data of the ground objects, and it is also difficult to connect with the specific business system. In order to realize the oblique photography model Based on the dynamic singulation of the CNN (Convolutional Neural Network) UNet network structure, a deep learning model is constructed to automatically extract the bottom surface of the building in the oblique photographic data, and through stretching, the oblique singulation model is automatically constructed: first According to the coordinates of the oblique photographic data, the corresponding digital orthophoto map (DOM) and data surface model (DSM) are extracted. Secondly, the bottom surface of the building is automatically extracted according to the image information of the DOM and the elevation information of the DSM. Finally, according to the building The height superimposes and stretches the bottom surface data of the vector, thereby realizing the dynamic correlation between the oblique photography modeling data and the appropriate bottom surface data, and supporting attributes such as historical building query, picture or video related browsing, etc. In order to improve the calling rate of the oblique photography model in the famous city management database, the technology combining dynamic scheduling and native LOD (multi-level of detail) is used for data calling. The LOD technology loads different objects according to the location and importance of the object model in the 3D scene. Fine data, when the model is closer to the current observation point, the system loads the refined data of the model; when the model is far from the current observation point, the system loads the fuzzy data of the model, so as to achieve a balance between effect and performance . However, the oblique photography model data in the historical and cultural city library often has the characteristics of large data volume and high model accuracy requirements. Only using LOD (multiple level of detail) technology cannot solve the problem. On the basis of LOD technology, combined with dynamic Scheduling technology realizes the application problem of TB-level massive tilt model data in famous historical and cultural cities. Dynamic scheduling is performed according to the position of observation points, that is, the data that needs to be seen in the current field of view is dynamically loaded into the memory, and the data that is not in the field of view is sent from the field in time. It is released in memory, and according to the position of the observation point, from near to far, the fuzzy data is loaded first, and then the refined data is loaded for dynamic loading to ensure that the data closest to the observation point is preferentially scheduled and rendered, which not only satisfies the needs of users A good visual experience, but also more effective use of hardware resources to achieve efficient browsing and rendering.

Referring to FIG. 19 , it is a schematic structural diagram of an apparatus for constructing a famous city management database provided by an embodiment of the present invention. Described a kind of construction device of famous city management database, comprises:

The data acquisition module 11 is used to acquire the management data of famous cities; wherein, the management data of famous cities includes two-dimensional basic geographic information data, three-dimensional basic geographic information data, current land use data, data related to urban planning, and data of a map of famous city protection. , the laser point cloud data of the famous city protection object, the BIM model data of the famous city protection object, the refined single model of the famous city protection object, and the three-dimensional reality model of the famous city protection object;

The format conversion module 12 is used to perform data format conversion processing on the famous city management data;

The coordinate conversion module 13 is used to perform coordinate conversion processing on the famous city management data;

The database building module 14 is used for storing the famous city management data after data format conversion processing and coordinate conversion processing to form a famous city management database.

It is worth noting that, for the specific working process of the device for constructing the famous city management database, reference may be made to the working process of the method for constructing the famous city management database in the foregoing embodiment, which will not be repeated here.

Compared with the prior art, the device for constructing a famous city management database disclosed in the embodiment of the present invention performs format conversion processing and coordinate conversion processing on the acquired multi-source famous city management data; wherein; the famous city management data includes a two-dimensional basis Geographic information data, 3D basic geographic information data, current land use data, urban planning-related data, data of a map of famous city protection, laser point cloud data of famous city protection objects, BIM model data of said famous city protection objects, said famous city The refined single model of the protection object and the three-dimensional real scene model of the protection object of the famous city; the name management data after data format conversion processing and coordinate conversion processing are stored in the database to construct a famous city management database. It can be seen that the embodiment of the present invention can transform the format and coordinates of the multi-source data and integrate them into a database, so that the famous city management database can meet the high control requirements during planning and preparation, and meet the requirements of the microscopic and refined management of the protection objects of famous cities As well as meeting the needs of high-precision simulation display and visual expression in the management process of famous cities, it provides data support for the protection planning, engineering construction, repair management and daily maintenance of famous cities.

In order to solve the same technical problem, correspondingly, an embodiment of the present invention provides a computer-readable storage medium, where a program is stored on the storage medium, and when the program is executed, the above-mentioned any one of the embodiments is implemented. The construction method of famous city management database. All or part of the process in the method of the above-mentioned embodiments can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a computer-readable storage medium, and when the computer program is executed by the processor, The steps of the above-mentioned various method embodiments can be implemented. Wherein, the computer program includes computer program code, and the computer program code may be in the form of source code, object code, executable file or some intermediate form, and the like. The computer-readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a removable hard disk, a magnetic disk, an optical disc, a computer memory, a read-only memory (ROM, Read-Only Memory), Random Access Memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium, etc.

The above are only the preferred embodiments of the present invention. It should be pointed out that for those skilled in the art, without departing from the technical principle of the present invention, several improvements and replacements can be made. These improvements and replacements It should also be regarded as the protection scope of the present invention.

Claims (10)

1. A method for constructing a famous city management database is characterized by comprising the following steps:

acquiring famous city management data; the famous city management data comprise two-dimensional basic geographic information data, three-dimensional basic geographic information data, land utilization current situation data, city planning related data, famous city protection map achievement data, laser point cloud data of famous city protection objects, BIM (building information modeling) data of famous city protection objects, refined monomer models of famous city protection objects and three-dimensional real scene models of famous city protection objects;

carrying out data format conversion processing on the famous city management data;

carrying out coordinate conversion processing on the famous city management data;

and storing the famous city management data subjected to the data format conversion processing and the coordinate conversion processing in a database to form a famous city management database.

2. The method of constructing a celebrity management database, according to claim 1, further comprising:

acquiring panoramic image data of the famous city protected object and unstructured data of the famous city protected object;

respectively establishing an association relationship between the panoramic image data, the unstructured data and the famous city management data;

and importing the panoramic image data and the unstructured data into the famous city management database.

3. A method for constructing a celebrity management database according to claim 1, wherein before the storing of the celebrity management data subjected to the data format conversion process and the coordinate conversion process, the method further comprises:

and compiling the three-dimensional basic geographic information data subjected to the data format conversion processing and the coordinate conversion processing.

4. A method of constructing a celebrity management database according to claim 1, wherein the celebrity management data is subjected to a coordinate conversion process by:

performing first coordinate conversion processing on the two-dimensional basic geographic information data, the current land utilization data, the city planning related data and the famous city protection one-map achievement data so as to convert coordinates of the two-dimensional basic geographic information data, the current land utilization data, the city planning related data and the famous city protection one-map achievement data into coordinates under a first target coordinate system;

carrying out coordinate matching processing on the three-dimensional basic geographic information data so as to enable the coordinates of the three-dimensional basic geographic information data with different coordinate types to have a matching relation;

performing second coordinate conversion processing on the laser point cloud data to convert the coordinates of the laser point cloud data into coordinates under a second target coordinate system;

carrying out third coordinate conversion processing on the BIM model data so as to convert the coordinates of the BIM model data into coordinates under a third target coordinate system;

performing fourth coordinate conversion processing on the refined monomer model so as to convert the coordinates of the refined monomer model into coordinates under a fourth target coordinate system;

performing fifth coordinate conversion processing on the three-dimensional live-action model so as to convert the coordinates of the three-dimensional live-action model into coordinates under a fifth target coordinate system;

and performing coordinate matching processing on all the famous city management data so as to enable the coordinates of each famous city management data to have a matching relation.

5. The method of constructing a celebrity management database according to claim 4, wherein after the second coordinate conversion process is performed on the laser point cloud data and before the coordinate matching process is performed on all the celebrity management data, further comprising:

fusing and splicing the laser point cloud data;

and carrying out lightweight processing on the laser point cloud data.

6. The method of constructing a celebrity management database according to claim 4, wherein after the third coordinate conversion process is performed on the BIM model data and before the coordinate matching process is performed on all the celebrity management data, further comprising:

and carrying out lightweight processing on the BIM model data.

7. The method for constructing a celebrity management database according to claim 6, wherein the performing of the lightweight processing on the BIM model data specifically includes:

and carrying out digital-analog separation processing, instantiation processing of similar objects and separation processing of a model shell and an internal model on the BIM model data.

8. A method for constructing a celebrity management database according to claim 1, wherein before the storing of the celebrity management data subjected to the data format conversion process and the coordinate conversion process, the method further comprises:

performing data inspection before warehousing on the famous city management data subjected to the data format conversion processing and the coordinate conversion processing;

after the storing the famous city management data after the data format conversion processing and the coordinate conversion processing, the method further comprises the following steps: and performing data inspection after putting the famous city management data subjected to the data format conversion processing and the coordinate conversion processing into a warehouse.

9. An apparatus for constructing a famous city management database, comprising:

the data acquisition module is used for acquiring famous city management data; the famous city management data comprise two-dimensional basic geographic information data, three-dimensional basic geographic information data, land utilization current situation data, city planning related data, famous city protection map achievement data, laser point cloud data of famous city protection objects, BIM (building information modeling) data of famous city protection objects, refined monomer models of famous city protection objects and three-dimensional real scene models of famous city protection objects;

the format conversion module is used for carrying out data format conversion processing on the famous city management data;

the coordinate conversion module is used for carrying out coordinate conversion processing on the famous city management data;

and the database construction module is used for warehousing the famous city management data subjected to the data format conversion processing and the coordinate conversion processing to form a famous city management database.

10. A computer-readable storage medium, characterized in that the storage medium has stored thereon a program which, when executed, implements the method of constructing a celebrity management database according to any one of claims 1-8.

Images