The Requirements of a Database to Store Geotechnical Data to Assist in Roof Support Design

The specification of roof support needs to consider rock strength, imposed ground stresses, and more importantly the bedding and joint structure of the immediate roof rocks. A database structure has been developed that allows these considerations to be incorporated into modern mine planning software so that better predictions of mining rates can be made. Rock strength is estimated from core and/or geophysical logs (especially the sonic velocity log) and ground stresses are estimated from depth of cover and knowledge of the regional stress field. The database is unique in the way it addresses bedding structure. Only 10 roof lithologies are allowed and these are allocated a numerical value that reflects an increase in the average spacing of bedding partings. These are referred to as 'Geotechnical Ferm Units' (GFU). The locations of all bedding discontinuities logged in the core are entered into the database and referenced to the GFUs. It has been found that, within each GFU, bedding spacing follows a negative exponential distribution and so it is a simple matter to predict the probability of the occurrence of any roof beam thickness. Output from the database can include plans of roof strength, the onset of overstressing, and the statistics of the distribution of beam thickness in the immediate roof.