Permanent.Plot.ch - a database for Swiss permanent vegetation plots

The aim of the Permanent.Plot.ch project is the conservation of historical data about permanent plots in Switzerland and the monitoring of vegetation in a context of environmental changes (mainly climate and land use). Permanent plots are currently being recognized as valuable tools to monitor long-term effects of environmental changes on vegetation. Often used in short studies (3 to 5 years), they are generally abandoned at the end of projects. However, their full potential might only be revealed after 10 or more years, once the location is lost. For instance, some of the oldest permanent plots in Switzerland (first half of the 20th century) were nearly lost, although they are now very valuable data. The Permanent.Plot.ch national database (GIVD ID EU-CH-001), by storing historical and recent data, will allow to ensuring future access to data from permanent vegetation plots. As the database contains some private data, it is not directly available on internet but an overview of the data can be downloaded from internet (http://www.unil.ch/ppch) and precise data are available on request.

Recent misconceptions about the "database search problem": a probabilistic analysis using Bayesian networks

This paper analyses and discusses arguments that emerge from a recent discussion about the proper assessment of the evidential value of correspondences observed between the characteristics of a crime stain and those of a sample from a suspect when (i) this latter individual is found as a result of a database search and (ii) remaining database members are excluded as potential sources (because of different analytical characteristics). Using a graphical probability approach (i.e., Bayesian networks), the paper here intends to clarify that there is no need to (i) introduce a correction factor equal to the size of the searched database (i.e., to reduce a likelihood ratio), nor to (ii) adopt a propositional level not directly related to the suspect matching the crime stain (i.e., a proposition of the kind 'some person in (outside) the database is the source of the crime stain' rather than 'the suspect (some other person) is the source of the crime stain'). The present research thus confirms existing literature on the topic that has repeatedly demonstrated that the latter two requirements (i) and (ii) should not be a cause of concern.

Rockfall characterisation and structural protection: A review

Rockfall is an extremely rapid process involving long travel distances. Due to these features, when an event occurs, the ability to take evasive action is practically zero and, thus, the risk of injury or loss of life is high. Damage to buildings and infrastructure is quite likely. In many cases, therefore, suitable protection measures are necessary. This contribution provides an overview of previous and current research on the main topics related to rockfall. It covers the onset of rockfall and runout modelling approaches, as well as hazard zoning and protection measures. It is the aim of this article to provide an in-depth knowledge base for researchers and practitioners involved in projects dealing with the rockfall protection of infrastructures, who may work in the fields of civil or environmental engineering, risk and safety, the earth and natural sciences.

Development of a Database for Drilled Shaft Foundation Testing (DSHAFT), June 2012

Drilled shafts have been used in the US for more than 100 years in bridges and buildings as a deep foundation alternative. For many of these applications, the drilled shafts were designed using the Working Stress Design (WSD) approach. Even though WSD has been used successfully in the past, a move toward Load Resistance Factor Design (LRFD) for foundation applications began when the Federal Highway Administration (FHWA) issued a policy memorandum on June 28, 2000.The policy memorandum requires all new bridges initiated after October 1, 2007, to be designed according to the LRFD approach. This ensures compatibility between the superstructure and substructure designs, and provides a means of consistently incorporating sources of uncertainty into each load and resistance component. Regionally-calibrated LRFD resistance factors are permitted by the American Association of State Highway and Transportation Officials (AASHTO) to improve the economy and competitiveness of drilled shafts. To achieve this goal, a database for Drilled SHAft Foundation Testing (DSHAFT) has been developed. DSHAFT is aimed at assimilating high quality drilled shaft test data from Iowa and the surrounding regions, and identifying the need for further tests in suitable soil profiles. This report introduces DSHAFT and demonstrates its features and capabilities, such as an easy-to-use storage and sharing tool for providing access to key information (e.g., soil classification details and cross-hole sonic logging reports). DSHAFT embodies a model for effective, regional LRFD calibration procedures consistent with PIle LOad Test (PILOT) database, which contains driven pile load tests accumulated from the state of Iowa. PILOT is now available for broader use at the project website: http://srg.cce.iastate.edu/lrfd/. DSHAFT, available in electronic form at http://srg.cce.iastate.edu/dshaft/, is currently comprised of 32 separate load tests provided by Illinois, Iowa, Minnesota, Missouri and Nebraska state departments of transportation and/or department of roads. In addition to serving as a manual for DSHAFT and providing a summary of the available data, this report provides a preliminary analysis of the load test data from Iowa, and will open up opportunities for others to share their data through this quality–assured process, thereby providing a platform to improve LRFD approach to drilled shafts, especially in the Midwest region.

Structural and electrical properties of Fe-doped TiO2 thin films

The present study discusses the effect of iron doping in TiO2 thin films deposited by rf sputtering. Iron doping induces a structural transformation from anatase to rutile and electrical measurements indicate that iron acts as an acceptor impurity. Thermoelectric power measurement shows a transition between n-type and p-type electrical conduction for an iron concentration around 0.13 at.%. The highest p-type conductivity at room temperature achieved by iron doping was 10(-6) S m(-1).

Mynodbcsv: Lightweight Zero-Config Database Solution for Handling Very Large CSV Files.

Volumes of data used in science and industry are growing rapidly. When researchers face the challenge of analyzing them, their format is often the first obstacle. Lack of standardized ways of exploring different data layouts requires an effort each time to solve the problem from scratch. Possibility to access data in a rich, uniform manner, e.g. using Structured Query Language (SQL) would offer expressiveness and user-friendliness. Comma-separated values (CSV) are one of the most common data storage formats. Despite its simplicity, with growing file size handling it becomes non-trivial. Importing CSVs into existing databases is time-consuming and troublesome, or even impossible if its horizontal dimension reaches thousands of columns. Most databases are optimized for handling large number of rows rather than columns, therefore, performance for datasets with non-typical layouts is often unacceptable. Other challenges include schema creation, updates and repeated data imports. To address the above-mentioned problems, I present a system for accessing very large CSV-based datasets by means of SQL. It's characterized by: "no copy" approach - data stay mostly in the CSV files; "zero configuration" - no need to specify database schema; written in C++, with boost [1], SQLite [2] and Qt [3], doesn't require installation and has very small size; query rewriting, dynamic creation of indices for appropriate columns and static data retrieval directly from CSV files ensure efficient plan execution; effortless support for millions of columns; due to per-value typing, using mixed text/numbers data is easy; very simple network protocol provides efficient interface for MATLAB and reduces implementation time for other languages. The software is available as freeware along with educational videos on its website [4]. It doesn't need any prerequisites to run, as all of the libraries are included in the distribution package. I test it against existing database solutions using a battery of benchmarks and discuss the results.

Subgroup-specific structural variation across 1,000 medulloblastoma genomes.

Medulloblastoma, the most common malignant paediatric brain tumour, is currently treated with nonspecific cytotoxic therapies including surgery, whole-brain radiation, and aggressive chemotherapy. As medulloblastoma exhibits marked intertumoural heterogeneity, with at least four distinct molecular variants, previous attempts to identify targets for therapy have been underpowered because of small samples sizes. Here we report somatic copy number aberrations (SCNAs) in 1,087 unique medulloblastomas. SCNAs are common in medulloblastoma, and are predominantly subgroup-enriched. The most common region of focal copy number gain is a tandem duplication of SNCAIP, a gene associated with Parkinson's disease, which is exquisitely restricted to Group 4α. Recurrent translocations of PVT1, including PVT1-MYC and PVT1-NDRG1, that arise through chromothripsis are restricted to Group 3. Numerous targetable SCNAs, including recurrent events targeting TGF-β signalling in Group 3, and NF-κB signalling in Group 4, suggest future avenues for rational, targeted therapy.

Structural organization of alpha-subunit from purified and microsomal toad kidney (Na+ + K+)-ATPase as assessed by controlled trypsinolysis

The membrane organization of the alpha-subunit of purified (Na+ + K+)-ATPase ((Na+ + K+)-dependent adenosine triphosphate phosphorylase, EC 3.6.1.3) and of the microsomal enzyme of the kidney of the toad Bufo marinus was compared by using controlled trypsinolysis. With both enzyme preparations, digestions performed in the presence of Na+ yielded a 73 kDa fragment and in the presence of K+ a 56 kDa, a 40 kDa and small amounts of a 83 kDa fragment from the 96 kDa alpha-subunit. In contrast to mammalian preparations (Jørgensen, P.L. (1975) Biochim. Biophys. Acta 401, 399-415), trypsinolysis of the purified amphibian enzyme led to a biphasic loss of (Na+ + K+)-ATPase activity in the presence of both Na+ and K+. These data could be correlated with an early rapid cleavage of 3 kDa from the alpha-subunit in both ionic conditions and a slower degradation of the remaining 93 kDa polypeptide. On the other hand, in the microsomal enzyme, a 3 kDa shift of the alpha-subunit could only be produced in the presence of Na+. Our data indicate that (1) purification of the amphibian enzyme with detergent does not influence the overall topology of the alpha-subunit but produces a distinct structural alteration of its N-terminus and (2) the amphibian kidney enzyme responds to cations with similar conformational transitions as the mammalian kidney enzyme. In addition, anti alpha-serum used on digested enzyme samples revealed on immunoblots that the 40 kDa fragment was better recognized than the 56 kDa fragment. It is concluded that the NH2-terminal of the alpha-subunit contains more antigenic sites than the COOH-terminal domain in agreement with the results of Farley et al. (Farley, R.A., Ochoa, G.T. and Kudrow, A. (1986) Am. J. Physiol. 250, C896-C906).

Selectome update: quality control and computational improvements to a database of positive selection.

Selectome (http://selectome.unil.ch/) is a database of positive selection, based on a branch-site likelihood test. This model estimates the number of nonsynonymous substitutions (dN) and synonymous substitutions (dS) to evaluate the variation in selective pressure (dN/dS ratio) over branches and over sites. Since the original release of Selectome, we have benchmarked and implemented a thorough quality control procedure on multiple sequence alignments, aiming to provide minimum false-positive results. We have also improved the computational efficiency of the branch-site test implementation, allowing larger data sets and more frequent updates. Release 6 of Selectome includes all gene trees from Ensembl for Primates and Glires, as well as a large set of vertebrate gene trees. A total of 6810 gene trees have some evidence of positive selection. Finally, the web interface has been improved to be more responsive and to facilitate searches and browsing.

Effects of Heat Straightening Structural Steel, MLR-91-3, 1992

Heat straightening of steel beams on bridges struck by over height trucks has become common practice in recent years in Iowa. A study of the effects of this heat straightening on the steel beams thus straightened is needed. Appropriate samples for mechanical and metallurgical tests were cut from the same rolled beam from the end which was heated and the end which was not heated and the test results were compared. The test results showed beyond doubt that the steel was being heated beyond the permitted temperature and that the impact properties are being drastically reduced by the current method of heat straightening.

Retinal vessel oxygen saturation and its correlation with structural changes in retinitis pigmentosa.

PURPOSE: To study the influence of retinal structural changes on oxygen saturation in retinitis pigmentosa (RP) patients. METHODS: Oximetry measurements were performed on 21 eyes of 11 RP patients and compared to 24 eyes of 12 controls. Retinal oxygen saturation was measured in all major retinal arterioles (A-SO₂) and venules (V-SO₂) with an oximetry unit of the retinal vessel analyser (IMEDOS Systems UG, Jena, Germany). Oximetry data were compared with morphological changes measured by Cirrus optical coherence tomography (OCT) (Carl Zeiss Meditec, Dublin, CA, USA, macular thickness protocol). RESULTS: In RP patients, the retinal A-SO₂ and V-SO₂ levels were higher at 99.3% (p = 0.001, anova based on mixed-effects model) and 66.8% (p < 0.001), respectively, and the difference between the two (A-V SO₂) was lower at 32.5% (p < 0.001), when compared to the control group (92.4%; 54.0%; 38.4%, respectively). With the RP group, the A-V SO₂ correlated positively, not only with central macular thickness, but also with retinal thickness, in zones 2 and 3 (p = 0.006, p = 0.007, p = 0.014). CONCLUSION: These data indicate that oxygen metabolism was altered in RP patients. Based on our preliminary results, retinal vessel saturation correlated with structural alterations in RP. This method could be valuable in monitoring disease progression and evaluating a potential therapeutic response.