CN103778189A - Foundation liquefied earthquake damage foundation database inquiry and analysis system - Google Patents

Foundation liquefied earthquake damage foundation database inquiry and analysis system Download PDF

Info

Publication number
CN103778189A
CN103778189A CN201410003784.3A CN201410003784A CN103778189A CN 103778189 A CN103778189 A CN 103778189A CN 201410003784 A CN201410003784 A CN 201410003784A CN 103778189 A CN103778189 A CN 103778189A
Authority
CN
China
Prior art keywords
earthquake
foundation
liquefaction
inquiry
ground
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.)
Pending
Application number
CN201410003784.3A
Other languages
Chinese (zh)
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.)
Tongji University
Original Assignee
Tongji University
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 Tongji University filed Critical Tongji University
Priority to CN201410003784.3A priority Critical patent/CN103778189A/en
Publication of CN103778189A publication Critical patent/CN103778189A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Investigation Of Foundation Soil And Reinforcement Of Foundation Soil By Compacting Or Drainage (AREA)

Abstract

The invention relates to a foundation liquefied earthquake damage foundation database inquiry and analysis system which involves in data inquiry and data analysis. The data inquiry part comprises the steps that a first inquiry request module has requests that inquiry is conducted according to the earthquake condition and the foundation condition; a second inquiry request module has inquiry requests of earthquake occurrence time, an earthquake occurrence site, the earthquake magnitude and the like; a third inquiry request module has inquiry requests of a foundation rock-soil category, a damage mode, the foundation pressure and the like, foundation liquefied earthquake damage foundation data stored in a corresponding database are output according to the inquiry requests selected by the inquiry request modules, and results are sent to a data analysis part. According to the data analysis part, the output results are further screened and ranked through the database technology, so that the deformation damage mode and a basic law of foundation liquefied earthquake damage under the inquiry condition are obtained through analysis. According to the foundation liquefied earthquake damage foundation database inquiry and analysis system, inquiry and statistic analysis which are conducted through effective application of existing liquefied earthquake damage foundation data resources are facilitated and the reasonable reference basis is provided for anti-liquefied calculation and design of foundation engineering of a liquefied region.

Description

A kind of foundation liquefaction earthquake basic database query analysis system
Technical field
The present invention relates to a kind of foundation liquefaction earthquake basic database query analysis system, belong to seismic engineering geology, hazards control and Computer Applied Technology field.
Background technology
Foundation liquefaction is the one of the main reasons of foundation eaerthquake damage.Liquefaction disaster shake " Invest, Then Investigate " is to obtain engineering liquefaction earthquake basic data and the most important means of experience.In recent years, in global range, almost in each macroseism, all there is ground engineering Liquefaction Failure problem quite a lot.According to literature survey, liquefaction seimic disaster census in the past and research are mainly confined to foundation liquefaction failure mechanism and the feature research of certain area or certain secondary earthquake, lack system, sharable ground engineering liquefaction earthquake basic data.
Because iquefaction site is mainly distributed in coastal riverine economically developed, densely populated area, once there is large-scale liquefaction shock settlement problem, will cause great threat to top construction of structures and personal safety as well as the property safety.Because earthquake liquefaction disaster basic data amount is many and wide, be unfavorable for management, safeguard and share with the data of file layout access, develop a kind of foundation liquefaction earthquake basic database query analysis system, to contribute to more effectively to apply existing liquefaction earthquake basic data resource and carry out express query, thereby provide rational reference frame for the anti-liquefaction calculating of ground engineering and the design in vast liquefiable area.
Summary of the invention
Fundamental purpose of the present invention be for current liquefaction Disaster Data not system, share the present situations such as level is low, a kind of foundation liquefaction earthquake basic database query analysis system is disclosed, can be used for realizing the fast query of ground engineering earthquake liquefaction failure mechanism and pattern, thereby for the anti-liquefaction Design of ground engineering with prevent and reduce natural disasters reference frame is provided.
Object of the present invention can be achieved through the following technical solutions:
A kind of foundation liquefaction earthquake basic database query analysis system, this system is made up of data query and two parts of data analysis, data query comprises the first search request module, the second search request module and the 3rd search request module, and data analysis comprises screening, sequence; Wherein:
The first search request module, it is provided with by earthquake conditions inquiry with by two kinds of search requests of ground status inquiry; The second search request module, corresponding to earthquake conditions inquiry, it is provided with time of origin, place, earthquake magnitude and four kinds of search requests of source depth of earthquake, selects wherein one or more combination to inquire about; The 3rd search request module, correspondence is pressed ground status inquiry, and it is provided with ground ground classification, failure mode, base pressure and four kinds of search requests of liquefaction layer thickness, selects one or more combination to inquire about;
According to the search request of the second search request module or the selection of the 3rd search request module, the foundation liquefaction earthquake basic data of storing in output correspondence database, and result is sent to data analysis part, the foundation liquefaction earthquake basic data of storing in the Relational database of described output correspondence is divided into the total card of seismic properties and ground base attribute always blocks secondary tree structure, the total card of described seismic properties comprises earthquake basic condition (earthquake title, earthquake magnitude, source depth, epicentral location, INTENSITY DISTRIBUTION), earthquake basic condition (geologic hazard kind, damage of building situation, the number of casualties), the total card of described ground base attribute comprises earthquake title, ground ground classification, failure mode, base pressure, liquefying soil classification, liquefaction layer thickness, liquefaction layer top side location, liquefaction layer basal surface position, method for processing foundation, underground water table, utilize database technology to further screening and sequence processing of Output rusults, further screen according to earthquake magnitude, ground ground classification, base pressure, four indexs of liquefaction layer thickness, draw under various combination condition, the liquefaction deformation of ground, contrast draws the good anti-liquefaction Design scheme of ground in historical earthquake, can be according to Occurence Time of Earthquakes, earthquake magnitude, base pressure, four indexs of liquefaction deflection, select wherein single index or multiple index to sort according to the mode of ascending order or descending, thereby analyze ground ground classification that the impact on failure mode and liquefaction deflection size of earthquake magnitude and base pressure condition, Main Patterns that different times foundation liquefaction destroys and different liquefaction deflection are corresponding etc.Thereby analyze the basic law that draws foundation liquefaction deformation failure under predetermined condition.
In the present invention, in the second described search request module, be also provided with the fast query requirement by earthquake name query.
Compared with prior art, the present invention can allow user by inputting the querying conditions such as the engineering specifications of expected earthquake level, similarly base type and liquefying soil, from foundation liquefaction earthquake basic database, extract quickly in the past under similar seismic condition the engineering liquefaction earthquake situation of base type similarly, point out the weak part that similar ground engineering liquefaction destroys, failure mode and the deflection of prediction ground engineering, for the anti-liquefaction calculating of ground engineering and design provide solid reference.
Accompanying drawing explanation
Fig. 1 is structural representation of the present invention.
Number in the figure: 1 is data query, 2 is data analysis, and 3 is the first search request module, and 4 is the second search request module, and 5 is the 3rd search request module, and 6 is screening, and 7 is sequence.
Embodiment
Below in conjunction with the drawings and specific embodiments, the present invention is described in detail.
As shown in Figure 1, a kind of foundation liquefaction earthquake basic database query analysis system, comprises 2 two parts of data query 1 and data analysis.
Data query 1 comprises the first search request module 3, the second search request module 4, the 3rd search request module 5.
The first search request module 3, it is provided with by earthquake conditions inquiry with by two kinds of search requests of ground status inquiry.User can select according to the query demand of self " by earthquake conditions inquiry " still " to press ground status inquiry ".
The second search request module 4, corresponding to earthquake conditions inquiry, it is provided with time of origin, place, earthquake magnitude and four kinds of search requests of source depth of earthquake, selects wherein one or more combination to inquire about, and can also select the fast query requirement of earthquake name query.Time, earthquake magnitude and source depth that earthquake occurs all adopt range query.Carry out accurately or fuzzy query according to country and city in place.
The 3rd search request module 5, correspondence is pressed ground status inquiry, and it is provided with ground ground classification, failure mode, base pressure, four kinds of search requests of liquefaction layer thickness, selects one or more combination to inquire about.Ground ground classification comprises rock, gravelly soil, sand, silt, cohesive soil and artificial earth fill.Failure mode comprises liquefaction shock settlement, lateral deformation and liquefaction floating.Base pressure and liquefaction layer thickness all adopt range query.
By the querying condition of above-mentioned data query part, the foundation liquefaction earthquake basic data of storing in output correspondence database, and Query Result is sent to data analysis 2.
Data analysis 2 comprises 7 two kinds of analytic functions of screening 6 and sequence.
Screening 6, if it is more to meet the liquefaction earthquake case of querying condition in data query 1, the Query Result of output will be more, causes the problems such as late time data statistical study decrease in efficiency or user easily misunderstand, error rate increase.Therefore, the present invention provides data screening function in data analysis 2 parts, and further screening display symbol are closed the earthquake data of user's request.Adopt and press forms screening function in Access database, can further screen according to earthquake magnitude, ground ground classification, base pressure, four indexs of liquefaction layer thickness, hide otiose Query Result, draw under various combination screening conditions the liquefaction deformation of ground.Wherein, between four index screening conditions, can be the relation of "AND", can be also the relation of "or".Wherein, earthquake magnitude, base pressure and the screening of all employing scopes of liquefaction layer thickness.Ground ground classification can be carried out accurate or fuzzy screening.
Sequence 7, generally, the foundation liquefaction earthquake data in database are without sequence, and therefore, the Query Result of exporting by data query 1 is also more mixed and disorderly, is unfavorable for conclusion and the analysis of user to earthquake rule.The present invention adopts the senior ranking function of the simple sequence based on a field and multiple fields in Access database, can be according to Occurence Time of Earthquakes, earthquake magnitude, base pressure, four indexs of liquefaction deflection, select wherein single index or multiple index to sort according to the mode of ascending order or descending, thereby analyze earthquake magnitude and the impact of base pressure condition on failure mode and liquefaction deflection size, Main Patterns, the ground ground classification that different liquefaction deflection is corresponding etc. that different times foundation liquefaction destroys.

Claims (2)

1. a foundation liquefaction earthquake basic database query analysis system, it is characterized in that this system is made up of data query and two parts of data analysis, data query comprises the first search request module, the second search request module and the 3rd search request module, and data analysis comprises screening, sequence; Wherein:
The first search request module, it is provided with by earthquake conditions inquiry with by two kinds of search requests of ground status inquiry; The second search request module, corresponding to earthquake conditions inquiry, it is provided with time of origin, place, earthquake magnitude and four kinds of search requests of source depth of earthquake, selects wherein one or more combination to inquire about; The 3rd search request module, correspondence is pressed ground status inquiry, and it is provided with ground ground classification, failure mode, base pressure and four kinds of search requests of liquefaction layer thickness, selects one or more combination to inquire about;
According to the search request of the second search request module or the selection of the 3rd search request module, the foundation liquefaction earthquake basic data of storing in output correspondence database, and result is sent to data analysis part, the foundation liquefaction earthquake basic data of storing in the Relational database of described output correspondence is divided into the total card of seismic properties and ground base attribute always blocks secondary tree structure, the total card of described seismic properties comprises earthquake basic condition and earthquake basic condition, and the total card of described ground base attribute comprises earthquake title, ground ground classification, failure mode, base pressure, liquefying soil classification, liquefaction layer thickness, liquefaction layer top side location, liquefaction layer basal surface position, method for processing foundation, underground water table, utilize database technology to further screening and sequence processing of Output rusults, further screen according to earthquake magnitude, ground ground classification, base pressure, four indexs of liquefaction layer thickness, draw under various combination condition, the liquefaction deformation of ground, contrast draws the good anti-liquefaction Design scheme of ground in historical earthquake, can be according to Occurence Time of Earthquakes, earthquake magnitude, base pressure, four indexs of liquefaction deflection, select that wherein single index or multiple index sort according to the mode of ascending order or descending, thereby analyze the impact on failure mode and liquefaction deflection size of earthquake magnitude and base pressure condition, the Main Patterns that different times foundation liquefaction destroys and ground ground classification corresponding to different liquefaction deflection, described earthquake basic condition comprises earthquake title, earthquake magnitude, source depth, epicentral location and INTENSITY DISTRIBUTION, described earthquake basic condition comprises geologic hazard kind, damage of building situation and the number of casualties.
2. foundation liquefaction earthquake basic database query analysis system according to claim 1, is characterized in that being also provided with the fast query requirement by earthquake name query in the second described search request module.
CN201410003784.3A 2014-01-06 2014-01-06 Foundation liquefied earthquake damage foundation database inquiry and analysis system Pending CN103778189A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410003784.3A CN103778189A (en) 2014-01-06 2014-01-06 Foundation liquefied earthquake damage foundation database inquiry and analysis system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410003784.3A CN103778189A (en) 2014-01-06 2014-01-06 Foundation liquefied earthquake damage foundation database inquiry and analysis system

Publications (1)

Publication Number Publication Date
CN103778189A true CN103778189A (en) 2014-05-07

Family

ID=50570424

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410003784.3A Pending CN103778189A (en) 2014-01-06 2014-01-06 Foundation liquefied earthquake damage foundation database inquiry and analysis system

Country Status (1)

Country Link
CN (1) CN103778189A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108717451A (en) * 2018-05-18 2018-10-30 中国地震台网中心 Obtain the method, apparatus and system of earthquake information

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5868525A (en) * 1995-11-13 1999-02-09 Takao Enterprise Co., Ltd. Method of preventing damages to loose sand ground or sandy ground due to seismic liquefaction phenomenon, and of restoration of disaster-stricken ground
CN102864766A (en) * 2012-08-22 2013-01-09 江苏省电力设计院 Liquefaction judgment method based on standard penetration and static cone penetration test correlation
CN102902682A (en) * 2011-07-26 2013-01-30 同济大学 Underground structure earthquake damage database inquiry system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5868525A (en) * 1995-11-13 1999-02-09 Takao Enterprise Co., Ltd. Method of preventing damages to loose sand ground or sandy ground due to seismic liquefaction phenomenon, and of restoration of disaster-stricken ground
CN102902682A (en) * 2011-07-26 2013-01-30 同济大学 Underground structure earthquake damage database inquiry system
CN102864766A (en) * 2012-08-22 2013-01-09 江苏省电力设计院 Liquefaction judgment method based on standard penetration and static cone penetration test correlation

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108717451A (en) * 2018-05-18 2018-10-30 中国地震台网中心 Obtain the method, apparatus and system of earthquake information

Similar Documents

Publication Publication Date Title
Ma et al. Identification of causal factors for the Majiagou landslide using modern data mining methods
US10697283B2 (en) Methods, systems, and computer medium having computer programs stored thereon to optimize reservoir management decisions based on reservoir properties
Gülen et al. Well economics across ten tiers in low and high Btu (British thermal unit) areas, Barnett Shale, Texas
Vlek Induced earthquakes from long‐term gas extraction in Groningen, the Netherlands: Statistical analysis and prognosis for acceptable‐risk regulation
Li et al. Risk assessment of floor water inrush using entropy weight and variation coefficient model
CN106443783A (en) Multi-period fracture quantitative prediction method based on fault activity
Ruan et al. A new risk assessment model for underground mine water inrush based on AHP and D–S evidence theory
Liu et al. Application on floor water inrush evaluation based on AHP variation coefficient method with GIS
Hua et al. Assessment of ecological risks induced by land use and land cover changes in Xiamen City, China
Li et al. Risk evaluation of mine-water inrush based on principal component logistic regression analysis and an improved analytic hierarchy process
CN102226915A (en) Deep foundation pit engineering dynamic risk information management system
CN116432270A (en) Urban underground space development and construction platform based on geological big data
Li et al. Research on development characteristics and failure mechanism of land subsidence and ground fissure in Xi'an, monitored by using time-series SAR interferometry
Liu et al. Assessment of water inrush risk using the principal component logistic regression model in the Pandao coal mine, China
Li et al. Multi-source information fusion technology for risk assessment of water inrush from coal floor karst aquifer
Duan et al. Suitability of underground space development in plateau cities based on geological environment analysis: Case study in Kunming, China
Király et al. Validating models to forecasting induced seismicity related to deep geothermal energy projects
Liu et al. Suitability of aquifer-protection mining in ecologically fragile areas in western China
Zhang Ecological Risk Assessment of Yulin Coal Mining Area: Based on the PETAR Method
Khalil et al. Probabilistic seismic hazard assessments of Sabah, east Malaysia: accounting for local earthquake activity near Ranau
CN103778189A (en) Foundation liquefied earthquake damage foundation database inquiry and analysis system
Wen et al. Hybrid optimized RF model of seismic resilience of buildings in mountainous region based on hyperparameter tuning and SMOTE
Wei et al. A novel method for evaluating proneness of gas outburst based on gas-geological complexity
Qu et al. Gray evaluation of water inrush risk in deep mining floor
Lan et al. Probabilistic prediction of mine dynamic disaster risk based on multiple factor pattern recognition

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20140507