CN110838177B - Revit platform-based geological survey map and pile foundation map fusion method - Google Patents

Revit platform-based geological survey map and pile foundation map fusion method Download PDF

Info

Publication number
CN110838177B
CN110838177B CN201911125705.5A CN201911125705A CN110838177B CN 110838177 B CN110838177 B CN 110838177B CN 201911125705 A CN201911125705 A CN 201911125705A CN 110838177 B CN110838177 B CN 110838177B
Authority
CN
China
Prior art keywords
data
drilling
layer
point
cubic spline
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201911125705.5A
Other languages
Chinese (zh)
Other versions
CN110838177A (en
Inventor
彭建林
张彬彬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fuzhou Polytechnic
Original Assignee
Fuzhou Polytechnic
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Fuzhou Polytechnic filed Critical Fuzhou Polytechnic
Priority to CN201911125705.5A priority Critical patent/CN110838177B/en
Publication of CN110838177A publication Critical patent/CN110838177A/en
Application granted granted Critical
Publication of CN110838177B publication Critical patent/CN110838177B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06TIMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T17/00Three dimensional [3D] modelling, e.g. data description of 3D objects
    • G06T17/05Geographic models
    • G06T3/08
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06TIMAGE DATA PROCESSING OR GENERATION, IN GENERAL
    • G06T3/00Geometric image transformation in the plane of the image
    • G06T3/40Scaling the whole image or part thereof
    • G06T3/4023Decimation- or insertion-based scaling, e.g. pixel or line decimation

Abstract

The invention relates to a method for fusing a geological survey map and a pile foundation map based on a Revit platform, which comprises the following steps of: s1, planning a plurality of drilling points for geology, carrying out drilling exploration on the drilling points, and collecting drilling original data, wherein the drilling original data comprise first plane coordinate data of rock and soil of different drilling points and first elevation data of the top of a first layer of rock and soil of the same drilling point in different stratums; s2, expanding the original drilling data by a cubic spline surface modeling method to generate geological data, wherein the geological data comprises layer bottom point data and layer top point data of each stratum; s3, importing the layer bottom point data and the layer top point data of different stratums obtained in the step S2 into Revit software, and drawing and generating corresponding stratum smooth curved surfaces; and S4, drawing a pile foundation diagram in Revit software to obtain the formation elevation data of the pile head. Through engineering conditions such as simulation pile foundation construction and earthwork excavation, the soil layer where the pile head is located can be clearly known.

Description

Revit platform-based geological survey map and pile foundation map fusion method
Technical Field
The invention relates to the field of geological modeling, in particular to a method for fusing a geological survey map and a pile foundation map based on a Revit platform.
Background
The engineering community represents and processes geological information based on two-dimensional models, which essentially project geological information in three dimensions onto a two-dimensional plane. The two-dimensional geological information is generally displayed by means of drilling and the like through a drilling histogram, a profile map and a survey report, the operation form is more standard, the change of a spatial geological structure can be described, the specialization degree is high, the visual effect is not obvious, the spatial change rule cannot be explained, and the geological numerical analysis and the coordination with other specialties are not facilitated.
In the process of establishing the two-dimensional geological model, an engineer needs to reconstruct three-dimensional distribution characteristics of geology from two-dimensional engineering geological profile maps and two-dimensional data of exploration points based on personal experience, and differences of data interpretation are inevitably caused. When an existing pile foundation map is designed, a two-dimensional geological survey map needs to be referred, the burial depth where a bearing stratum is located is estimated, and a certain design reference value is given to the length of a pile foundation. However, the distribution of each stratum in the design field is not uniform, the buried depth of the bearing stratum is not consistent at each pile foundation, and engineers set reference pile lengths for a large number of pile foundations from limited drilling data with personal experience, so that the defects of non-visibility, estimation error and the like exist. The modeling method based on the parallel profiles is used for constructing a three-dimensional geological model by connecting contour lines between adjacent profiles, is generally used for a single model, and is difficult to distinguish the contour lines between the adjacent profiles when the geological features are complex.
In addition, the drilling points during exploration can only be selected from the boundary points of the building, and the quantity or the distribution quality of the drilling points cannot meet the requirement of establishing a complete smooth curved surface, so that a data base cannot be provided for the establishment of a surface model of the stratum.
With the continuous development of building information technology, a perfect system is still lacked for three-dimensional geological modeling based on BIM, and the existing BIM software can not effectively realize the application of algorithms such as fault structure and interpolation. The three-dimensional geological modeling software such as GSIS, Geo-view, 3-D Grid and the like has the problems of data format conversion, interface and the like with BIM software, and cannot be fused with a pile foundation map.
Aiming at the problems in the prior art, the invention aims to design a geological survey map and pile foundation map fusion method based on a Revit platform.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a method for fusing a geological survey map and a pile foundation map based on a Revit platform, which can effectively solve the problems in the prior art.
The technical scheme of the invention is as follows:
a geological survey map and pile foundation map fusion method based on a Revit platform comprises the following steps:
S1, planning a plurality of drilling points for geology, carrying out drilling exploration on the drilling points, and collecting drilling original data, wherein the drilling original data comprise first plane coordinate data of rock and soil of different drilling points and first elevation data of the top of a first layer of rock and soil of the same drilling point in different stratums;
s2, expanding the original drilling data by a cubic spline surface modeling method to generate geological data, wherein the geological data comprises layer bottom point data and layer top point data of each stratum;
the step S2 includes:
s2.1, respectively taking the maximum value x of the coordinate data (x, y) of the original drilling pointmax,ymaxAnd the minimum value xmin,yminAnd each 99 equal divisions are made to generate 100 x 100 coordinate lattice (x)i,yj),
xmin=x1<x2<…<x99<x100=xmax,ymin=y1<y2<…<y99<y100=ymax
S2.2, the cubic spline surface modeling method comprises a cubic spline interpolation function type:
Si(x)=aixi 3+bixi 2+cixi+di
s (x) in each interval [ x ]i,xi+1](i ═ 1,2 …,100) is a polynomial of degree not exceeding 3, S (x) at the top of layer height [ m, n ] of each stratum]The upper 2 continuous derivatives;
s2.3, the cubic spline surface modeling method comprises a boundary point condition of a cubic spline interpolation function, wherein the boundary point condition is added with a specific value of a second derivative at a given endpoint:
S”(xmin)=S”(xmax)=0;
s2.4, sequentially solving the condition that the ordinate is y according to the condition that the cubic spline interpolation function is continuous, the first derivative is continuous, the second derivative is continuous and the second derivative at the endpoint is 0 min,y2,…,y99,ymaxTime cubic spline interpolation function coefficients a, b, c, d;
s2.5, mixing xi(i 1, 2.., 100) is solved by the substitution to obtain y as ordinate1Obtaining 100 elevation data by a time cubic spline interpolation function, and obtaining a vertical coordinate y2,y3,..,y10010000 pieces of elevation data are obtained through a time cubic spline interpolation function;
s2.6, similarly, performing cubic spline interpolation calculation on the elevation data of the top of the room layer and the elevation data of the bottom of the deepest layer, and expanding to obtain 10000 elevation data of each top and bottom of the stratum;
s2.7, corresponding the elevation data of each layer of top points and bottom points to coordinate data to obtain expanded geological data containing plane coordinates and corresponding elevations;
s3, importing the layer bottom point data and the layer top point data of different stratums obtained in the step S2 into Revit software, and drawing and generating corresponding stratum smooth curved surfaces;
and S4, drawing a pile foundation diagram in Revit software to obtain the formation elevation data of the pile head.
Further, the layer bottom point data and the layer vertex data in said step S2 include second plane coordinate data and second elevation data.
Further, the formation elevation data includes third planar coordinate data and third elevation data for each formation.
Further, the original data of the drill hole is obtained through a drill hole histogram and a section.
Furthermore, the drilling points are distributed along the center point, the angular point, the column line and the side line of the foundation pit of the building.
Accordingly, the present invention provides the following effects and/or advantages:
1. the cubic spline interpolation method can effectively form a smooth geological curved surface. And (3) utilizing the original drilling data and stratum data points obtained by spatial interpolation as supplementary data for constructing a complete stratum model. A data blank without drilling in a large number of regions of the stratum space is effectively filled through a cubic spline interpolation method, so that modeling sampling points are uniformly and densely distributed. The stratum curved surface drawn according to the sampling points can be well fitted with original data points, so that the curved surface is smooth.
2. Three-dimensional modeling enables visualization of geological models. The establishment of the three-dimensional geological model enables underground engineering and the like such as earthwork, pile foundation engineering and the like in the design and construction stage to be visualized. In the building information model, through simulating engineering conditions such as pile foundation construction, earthwork excavation and the like, the soil layer where the pile head is located can be clearly known, and the construction site change of each excavation stage can be clearly known.
3. The three-dimensional geological model gets through information islands of all links. Through the strong interaction capacity of the core modeling software, the generated three-dimensional geological model data can be imported into other software of the BIM series for full utilization, and can also be exported to partial numerical simulation software for depth calculation and simulation.
It is to be understood that both the foregoing general description and the following detailed description of the present invention are exemplary and explanatory and are intended to provide further explanation of the invention as claimed.
Drawings
Fig. 1 is a schematic diagram of a drilling point according to a first embodiment of the present invention.
Fig. 2 is a schematic diagram of the formation structure according to the first embodiment of the present invention.
Fig. 3 is a diagram illustrating an effect of the expanded formation data according to the first embodiment of the present invention.
FIG. 4 is a diagram illustrating the effect of the first embodiment of the present invention before expansion of formation data.
Fig. 5 is a schematic diagram of all the stratum data after being expanded according to the first embodiment of the present invention.
Fig. 6 is a schematic view of a smooth curved surface of a formation according to a first embodiment of the present invention.
FIG. 7 is a schematic diagram of a stratum where a pile foundation is located according to an embodiment of the present invention
Detailed Description
Example one
To facilitate understanding of those skilled in the art, the structure of the present invention will now be described in further detail by way of examples in conjunction with the accompanying drawings:
a geological survey map and pile foundation map fusion method based on a Revit platform comprises the following steps:
s1, planning a plurality of drilling points for geology, carrying out drilling exploration on the drilling points, and collecting drilling original data, wherein the drilling original data comprise first plane coordinate data of rock and soil of different drilling points and first elevation data of the top of a first layer of rock and soil of the same drilling point in different stratums;
S2, expanding the original drilling data by a cubic spline surface modeling method to generate geological data, wherein the geological data comprises layer bottom point data and layer top point data of each stratum;
the step S2 includes:
s2.1, respectively taking the maximum value x of the coordinate data (x, y) of the original drilling pointmax,ymaxAnd the minimum value xmin,yminAnd each 99 equal divisions are made to generate 100 x 100 coordinate lattice (x)i,yj),
xmin=x1<x2<…<x99<x100=xmax,ymin=y1<y2<…<y99<y100=ymax
S2.2, the cubic spline surface modeling method comprises a cubic spline interpolation function type:
Si(x)=aixi 3+bixi 2+cixi+di
s (x) in each interval [ x ]i,xi+1](i ═ 1,2 …,100) is a polynomial of degree not exceeding 3, and s (x) at the top of layer elevation [ m, n ] of each formation]The upper 2 continuous derivatives;
s2.3, the cubic spline surface modeling method comprises a boundary point condition of a cubic spline interpolation function, wherein the boundary point condition is added with a specific value of a second derivative at a given endpoint:
S”(xmin)=S”(xmax)=0;
s2.4, sequentially solving the condition that the ordinate is y according to the condition that the cubic spline interpolation function is continuous, the first derivative is continuous, the second derivative is continuous and the second derivative at the endpoint is 0min,y2,…,y99,ymaxTime cubic spline interpolation function coefficients a, b, c, d;
s2.5, mixing xi(i 1, 2.., 100) is solved by the substitution to obtain y as ordinate1Obtaining 100 elevation data by a time cubic spline interpolation function, and obtaining a vertical coordinate y 2,y3,..,y10010000 pieces of elevation data are obtained through a time cubic spline interpolation function;
s2.6, similarly, performing cubic spline interpolation calculation on the elevation data of the top of the room layer and the elevation data of the bottom of the deepest layer, and expanding to obtain 10000 elevation data of each layer top point and each layer bottom point;
s2.7, corresponding the elevation data of the top or the bottom of each stratum to coordinate data to obtain expanded geological data containing plane coordinates and corresponding elevations;
s3, importing the layer bottom point data and the layer top point data of different stratums obtained in the step S2 into Revit software, and drawing and generating corresponding stratum smooth curved surfaces;
and S4, drawing a pile foundation diagram in Revit software to obtain the formation elevation data of the pile head.
Further, the layer bottom point data and the layer vertex data in said step S2 include second plane coordinate data and second elevation data.
Further, the formation elevation data includes third planar coordinate data and third elevation data for each formation.
Further, the original data of the drill hole is obtained through a drill hole histogram and a section.
Furthermore, the drilling points are distributed along the center point, the corner point, the column line and the side line of the foundation pit of the building, and the surrounding environment of the building is considered.
The technical scheme is applied to the surveying project of a primary school in the New Jiangjiang province of the Ganzhou city, and the total floor area is 26262.70 square meters and the total building area is 21746.89 square meters. The building comprises 7 buildings such as a teaching building, a comprehensive building, a stairway classroom and the like, the building is 1-5 layers high, a frame structure is adopted, the maximum load of a single column is about 3000kN, the elevation of a designed indoor terrace is 106.10-106.80 m, the sensitivity degree to differential settlement is general, a shallow foundation is adopted for the foundation, and the foundation embedding depth is about 2-4 meters. A layer of basement is arranged at the northeast corner of the field, the building area is 4019.3 square meters, and the excavation depth is about 4.5 m.
Exploration is carried out according to the safety level, the number of layers, the load capacity and other specifications of the building and the design requirements, and exploration points are mainly arranged along the corner points, the side lines and the column lines (generally, the center lines of columns are arranged in order and used as positioning axes) of the building and the surrounding environment. The distance between each exploration point and each line is 13-23 m, and 62 mechanical core drill holes (the drill hole numbers ZK 1-ZK 62) are arranged in total. The depth of the exploration hole is controlled within the range of the main stress layer of the foundation and is considered according to the pile foundation. And respectively arranging the depths of exploration holes according to factors such as the load capacity of the building, and the like, wherein the drilling depth is 6-8 m below the base bearing layer. And all the exploration holes adopt a GPS-RTK instrument to measure and place the positions of all the drill holes and the elevation of the hole openings according to the designed hole position coordinates.
The drilling points are shown in figure 1, and the stratigraphic structure division table shown in figure 2 is obtained by collecting the original data of the drilling holes.
Through the above step S2, one of the formation data shown in fig. 3 is obtained, and fig. 3 shows an effect diagram of 10000 data connections. Figure 4 shows the original drilling point data. Such as all of the formation data shown in figure 5.
Then, through the above step S3, a stratigraphic smooth curved surface based on the Revi platform is obtained as shown in fig. 6.
Finally, the pile foundation diagram and the elevation data of the stratum where the pile foundation diagram is located are obtained through the step S4.
The above description is only a preferred embodiment of the present invention, and all equivalent changes and modifications made in accordance with the claims of the present invention should be covered by the present invention.

Claims (5)

1. A geological survey map and pile foundation map fusion method based on a Revit platform is characterized by comprising the following steps: comprises the following steps:
s1, planning a plurality of drilling points for geology, carrying out drilling exploration on the drilling points, and collecting drilling original data, wherein the drilling original data comprise first plane coordinate data of rock and soil of different drilling points and first elevation data of the top of a first layer of rock and soil of the same drilling point in different stratums;
s2, expanding the original drilling data by a cubic spline surface modeling method to generate geological data, wherein the geological data comprises layer bottom point data and layer top point data of each stratum;
The step S2 includes:
s2.1, respectively taking the maximum value x of the coordinate data (x, y) of the original drilling pointmax,ymaxAnd the minimum value xmin,yminAnd each 99 equal divisions are made to generate 100 x 100 coordinate lattice (x)i,yj),
xmin=x1<x2<…<x99<x100=xmax,ymin=y1<y2<…<y99<y100=ymax
S2.2, the cubic spline surface modeling method comprises a cubic spline interpolation function type:
Si(x)=aixi 3+bixi 2+cixi+di
s (x) in each interval [ x ]i,xi+1](i ═ 1,2 …,100) is a polynomial of degree not exceeding 3, S (x) at the top of layer height [ m, n ] of each stratum]The upper 2 continuous derivatives;
s2.3, the cubic spline surface modeling method comprises a boundary point condition of a cubic spline interpolation function, wherein the boundary point condition is added with a specific value of a second derivative at a given endpoint:
S”(xmin)=S”(xmax)=0;
s2.4, sequentially solving the condition that the ordinate is y according to the condition that the cubic spline interpolation function is continuous, the first derivative is continuous, the second derivative is continuous and the second derivative at the endpoint is 0min,y2,…,y99,ymaxTime cubic spline interpolation function coefficients a, b, c, d;
s2.5, mixing xi(i 1, 2.., 100) is solved by the substitution to obtain y as ordinate1Cubic spline interpolation of timeThe value function obtains 100 elevation data, and the longitudinal coordinate is y2,y3,..,y10010000 pieces of elevation data are obtained through a time cubic spline interpolation function;
s2.6, similarly, performing cubic spline interpolation calculation on the elevation data of the top of the room layer and the elevation data of the bottom of the deepest stratum to obtain 10000 elevation data of the top point and the bottom point of each layer by expansion;
S2.7, corresponding the elevation data of the top point and the bottom point of each layer to coordinate data to obtain the expanded geological data containing plane coordinates and corresponding elevations;
s3, importing the layer bottom point data and the layer top point data of different strata obtained in the step S2 into Revit software, and drawing and generating corresponding stratum smooth curved surfaces;
and S4, drawing a pile foundation diagram in Revit software to obtain the stratum elevation data of the pile head.
2. The method for fusing the geological survey map and the pile foundation map based on the Revit platform as claimed in claim 1, wherein the method comprises the following steps: the layer bottom point data and the layer vertex data in said step S2 include second plane coordinate data and second elevation data.
3. The method for fusing the geological survey map and the pile foundation map based on the Revit platform as claimed in claim 1, wherein the method comprises the following steps: the formation elevation data includes third planar coordinate data and third elevation data for each formation.
4. The method for fusing the geological survey map and the pile foundation map based on the Revit platform as claimed in claim 1, wherein the method comprises the following steps: the original data of the drill hole is obtained by drilling a histogram and a section.
5. The method for fusing the geological survey map and the pile foundation map based on the Revit platform as claimed in claim 1, wherein the method comprises the following steps: the drilling points are distributed along the center point, the angular point, the column line and the side line of the foundation pit of the building.
CN201911125705.5A 2019-11-18 2019-11-18 Revit platform-based geological survey map and pile foundation map fusion method Active CN110838177B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911125705.5A CN110838177B (en) 2019-11-18 2019-11-18 Revit platform-based geological survey map and pile foundation map fusion method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911125705.5A CN110838177B (en) 2019-11-18 2019-11-18 Revit platform-based geological survey map and pile foundation map fusion method

Publications (2)

Publication Number Publication Date
CN110838177A CN110838177A (en) 2020-02-25
CN110838177B true CN110838177B (en) 2022-06-10

Family

ID=69576654

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911125705.5A Active CN110838177B (en) 2019-11-18 2019-11-18 Revit platform-based geological survey map and pile foundation map fusion method

Country Status (1)

Country Link
CN (1) CN110838177B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111950046B (en) * 2020-07-03 2022-08-16 成都理工大学 Drilling data model construction method based on BIM

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105184864A (en) * 2015-08-14 2015-12-23 中国能源建设集团安徽省电力设计院有限公司 Site stratum three-dimensional geological structure model generation method for natural foundation replacement quantities calculation
CN105631935A (en) * 2015-12-30 2016-06-01 上海顺凯信息技术股份有限公司 BIM-based three-dimensional geological automatic modeling method
RU2699257C1 (en) * 2018-07-10 2019-09-04 Общество с ограниченной ответственностью "Научно-исследовательское, проектное и производственное предприятие по природоохранной деятельности "Недра" (ООО НИППППД "НЕДРА") Bim method of designing a ground-underground facility

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105184864A (en) * 2015-08-14 2015-12-23 中国能源建设集团安徽省电力设计院有限公司 Site stratum three-dimensional geological structure model generation method for natural foundation replacement quantities calculation
CN105631935A (en) * 2015-12-30 2016-06-01 上海顺凯信息技术股份有限公司 BIM-based three-dimensional geological automatic modeling method
RU2699257C1 (en) * 2018-07-10 2019-09-04 Общество с ограниченной ответственностью "Научно-исследовательское, проектное и производственное предприятие по природоохранной деятельности "Недра" (ООО НИППППД "НЕДРА") Bim method of designing a ground-underground facility

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
饶嘉谊等.基于BIM的三维地质模型与桩长校核应用.《土木建筑工程信息技术》.2017,(第03期), *

Also Published As

Publication number Publication date
CN110838177A (en) 2020-02-25

Similar Documents

Publication Publication Date Title
CN102254349B (en) Method for constructing three-dimensional physical model of sedimentary stratum system by using drilling data
CN104574511B (en) A kind of quick progressive three-dimensional geological modeling method
Guo et al. Three-dimensional geological modeling and spatial analysis from geotechnical borehole data using an implicit surface and marching tetrahedra algorithm
EP2944757A1 (en) Interactive well pad plan
CN112052495B (en) Landslide control engineering three-dimensional design method based on BIM technology
CN111143922A (en) Multi-platform structure stratum digital twin modeling method and system
CN108109203B (en) Geological boundary point cloud data extraction method and system based on BIM environment
CN105719346B (en) Mountainous region three-dimensional geological object model method and synthetically learn information demonstration system
CN106709987B (en) Dynamic construction method of three-dimensional geological profile model
CN112231818B (en) Mountain city three-dimensional geological modeling method based on BIM
Zhang et al. A case study on integrated modeling of spatial information of a complex geological body
CN113689559B (en) Grid-shaped graph cut geological section wiring method for improving content expression precision of geological three-dimensional model
CN114663627A (en) Mine digital model establishing method based on three-dimensional point cloud database
CN112597572A (en) BIM technology-based pile foundation soil penetration depth determination method
CN110838177B (en) Revit platform-based geological survey map and pile foundation map fusion method
CN106886584B (en) Underground space development and utilization current situation estimation method based on various urban geographic data
CN116776449A (en) Sketchup software-based nuclear power plant area total plane layout method and system
CN108984908B (en) Construction method for assisting civil air defense cavern transformation by utilizing BIM technology
CN106920275A (en) A kind of complex properties border trivector alternative manner and application system
Lønøy et al. Geocellular rendering of cave surveys in paleokarst reservoir models
CN110211232A (en) A kind of triangular prism composition model method and system based on borehole data
Liu et al. From the area to the point-study on the key technology of 3D geological hazard modeling in Three Gorges Reservoir area
CN114332391A (en) Three-dimensional geologic body probability model modeling method
JP2008191763A (en) Data processing method
CN109359402B (en) Three-dimensional soil layer construction method and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant