PropBase QueryLayer: a single portal to UK physical property databases

Until recently, the delivery of geological information for industry and public was achieved by geological mapping. Now pervasively available computers mean that 3D geological models can deliver realistic representations of the geometric location of geological units, represented as shells or volumes. The next phase of this process is to populate these with physical properties data that describe subsurface heterogeneity and its associated uncertainty. Achieving this requires capture and serving of physical, hydrological and other property information from diverse sources to populate these models. The British Geological Survey (BGS) holds large volumes of subsurface property data, derived both from their own research data collection and also other, often commercially derived data sources. This can be voxelated to incorporate this data into the models to demonstrate property variation within the subsurface geometry. All property data held by BGS has for many years been stored in relational databases to ensure their long-term continuity. However these have, by necessity, complex structures; each database contains positional reference data and model information, and also metadata such as sample identification information and attributes that define the source and processing. Whilst this is critical to assessing these analyses, it also hugely complicates the understanding of variability of the property under assessment and requires multiple queries to study related datasets making extracting physical properties from these databases difficult. Therefore the PropBase Query Layer has been created to allow simplified aggregation and extraction of all related data and its presentation of complex data in simple, mostly denormalized, tables which combine information from multiple databases into a single system. The structure from each relational database is denormalized in a generalised structure, so that each dataset can be viewed together in a common format using a simple interface. Data are re-engineered to facilitate easy loading. The query layer structure comprises tables, procedures, functions, triggers, views and materialised views. The structure contains a main table PRB_DATA which contains all of the data with the following attribution: • a unique identifier • the data source • the unique identifier from the parent database for traceability • the 3D location • the property type • the property value • the units • necessary qualifiers • precision information and an audit trail Data sources, property type and units are constrained by dictionaries, a key component of the structure which defines what properties and inheritance hierarchies are to be coded and also guides the process as to what and how these are extracted from the structure. Data types served by the Query Layer include site investigation derived geotechnical data, hydrogeology datasets, regional geochemistry, geophysical logs as well as lithological and borehole metadata. The size and complexity of the data sets with multiple parent structures requires a technically robust approach to keep the layer synchronised. This is achieved through Oracle procedures written in PL/SQL containing the logic required to carry out the data manipulation (inserts, updates, deletes) to keep the layer synchronised with the underlying databases either as regular scheduled jobs (weekly, monthly etc.) or invoked on demand. The PropBase Query Layer’s implementation has enabled rapid data discovery, visualisation and interpretation of geological data with greater ease, simplifying the parameterisation of 3D model volumes and facilitating the study of intra-unit heterogeneity

The search for novel analgesics: re-examining spinal cord circuits with new tools

In this perspective, we propose the absence of detailed information regarding spinal cord circuits that process sensory information remains a major barrier to advancing analgesia. We highlight recent advances showing that functionally discrete populations of neurons in the spinal cord dorsal horn play distinct roles in processing sensory information. We then discuss new molecular, electrophysiological, and optogenetic techniques that can be employed to understand how dorsal horn circuits process tactile and nociceptive information. We believe this information can drive the development of entirely new classes of pharmacotherapies that target key elements in spinal circuits to selectively modify sensory function and blunt pain

Mode Switching and Subpulse Drifting in PSR B0826-34

We present high-quality observations of PSR B0826-34 at 1374 MHz. The emission from this pulsar exhibits strong bursts of pulses followed by long periods of `null' pulses. When it is strong, the radiation extends through the whole pulse period. We show for the first time that there is weak emission during the `null' phases, which should therefore be considered to be a different mode rather than a null. During this weak mode the profile is similar to that observed in the strong mode at low radio frequency. Using a phase-tracking method, the pattern of drifting subpulses during the strong mode is seen to be coherent across the whole profile. The drift rate is variable and includes positive and negative values. Thirteen subpulse bands have been directly observed, covering the whole longitude range. The subpulses and their spacings ($P_2$) are wider in one half of the profile than those in the other half. This difference, and the variation of observed $P_2$ within the two regions, can be accounted for if the magnetic pole is inclined to the rotation axis by about 0.5 degrees. These two regions appear to represent radiation from outer and inner cones. The intensity modulation of subpulses in all longitude ranges is related to the magnitude of the drift rate.Comment: 8 pages, 10 figures. Accepted for publication in MNRA

Optimum take-off angle in the long jump

In this study, we found that the optimum take-off angle for a long jumper may be predicted by combining the equation for the range of a projectile in free flight with the measured relations between take-off speed, take-off height and take-off angle for the athlete. The prediction method was evaluated using video measurements of three experienced male long jumpers who performed maximum-effort jumps over a wide range of take-off angles. To produce low take-off angles the athletes used a long and fast run-up, whereas higher take-off angles were produced using a progressively shorter and slower run-up. For all three athletes, the take-off speed decreased and the take-off height increased as the athlete jumped with a higher take-off angle. The calculated optimum take-off angles were in good agreement with the athletes' competition take-off angles

BILATERAL CMJ ASSYMETRIES IN YOUNG MALE ATHLETES: A STUDY ACROSS DIFFERENT AGE GROUPS AND SPORTS

The purpose of this study was to investigate bilateral countermovement jump asymmetries on a sample of 232 male student-athletes of 10 different sports, on a cross sectional approach over one year duration. Asymmetry in a number of force-related variables during the concentric and eccentric phases of a countermovement jump was defined as the absolute difference in performance between limbs expressed as a percentage of the total performance. Thresholds based on those asymmetries’ means plus standard deviations of the whole sample were set. Our study indicates that regardless of the sport, asymmetries defined in this way are more likely to occur in active boys from 13 to 15 years old

Community experiences of organised crime in Scotland

The research explored community experiences of serious organised crime in Scotland (SOC). The report provides information on the nature and extent of the impact of SOC on everyday life in the community, as well as offering suggestions for policy development. The study sought to answer the following questions: 1)What are the relationships that exist between SOC and communities in Scotland? 2)What are the experiences and perceptions of residents, stakeholders and organisations of the scope and nature of SOC within their local area? and 3)How does SOC impact on community wellbeing, and to what extent can the harms associated with SOC be mitigated

Unpulsed UBV Optical Emission from the Crab Pulsar

Based on observations of the Crab pulsar using the TRIFFID high speed imaging photometer in the UBV bands using the Special Astrophysical Observatory's 6m telescope in the Russian Caucasus, we report the detection of pronounced emission during the so-called `off' phase of emission. Following de-extinction, this unpulsed component of emission is shown to be consistent with a power law with an exponent of alpha = -0.60 +/- 0.37, the uncertainty being dominated by the error associated with the independent CCD photometry used to reference the TRIFFID data. This suggests a steeper power law form than that reported elsewhere in the literature for the total integrated spectrum, which is essentially flat with alpha ~ 0.1, although the difference in this case is only significant at the ~ 2 sigma level. Deeper reference integrated and TRIFFID phase-resolved photometry in these bands in conjunction with further observations in the UV and R region would constrain this fit further.Comment: 26 pages, 2 figures, uses aasms4.sty, accepted for publication in the Astrophysical Journa