ARC/INFO对外部数据库的动态访问

利用ARC/INFO的DATABASEINTEGRATOR模块功能,实现了在ARC/INFO环境对外部数据库的动态访问?该文就动态连接?访问外部库的条件和方法进行了论述?      

Analysis of laboratory incident database

With the growth of academic institutions, the number of labs handling hazardous chemicals has increased. Although the chemicals used in academic institutions are well-known, the dosage, usage, and management of these chemicals pose significant threat to researchers at all levels. As a step towards incident prevention, a laboratory incident database was developed to record incidents at universities and secondary schools. The data consisted of 128 entries occurring during the years 2012–2015. Incidents were classified by institution type, hazard type, consequences, substance type, body parts injured and direct causes. Of 128 incidents, 65% of the incidents were taking place in universities. Chemical spills were observed to be the most recurrent hazard type contributing to 45% of the incidents following by explosions (23%) and fires (21%). The consequence which most frequently occurred in incidents was personal injury and hazmat response contributing to 22% each. It was observed that in 41% of the incidents, the body parts injured in the incident was not known or reported. Of the total 128 incidents, about 50 incidents occurred due to improper storage and handling.     

Inventory of Interbasin Transfers in the United States

Interbasin transfers (IBTs) are man‐made transfers of water that cross basin boundaries. These transfers are used to distribute water resources according to supply and demand. The objectives of this work were to quantify the number of IBTs that exist in the United States (U.S.) and to examine the distribution of IBTs and potential causes associated with any observed clustering of IBTs. Defining “basin” was important to enable determination of which transfers qualify as “interbasin.” A variety of definitions are employed by states, with no federal definition. The most recent national studies of IBTs were conducted by the U.S. Geological Survey (USGS) in 1985 and 1986 using USGS Hydrologic Unit Code (HUC) definitions of basins. To build a 2016 inventory of IBTs in the U.S., and to identify where they most commonly occur, the USGS National Hydrography Database (NHD) was utilized in conjunction with the Watershed Boundary Dataset (WBD). Transfers across HUC6 basin boundaries were considered interbasin. Geographical information analysis with the NHD and WBD databases revealed that there are a total of 2,161 man‐made waterways crossing HUC6 basin boundaries in the U.S. IBTs are somewhat concentrated: Florida, Texas, and North Carolina account for over 50% of the total identified IBTs. For some states, identified IBTs are locally clustered. Analysis of these clusters suggests a variety of reasons that IBTs have been built, including population, drainage, and agricultural factors.     

国际互联网在环境科研中的应用

针对环境科研工作者 ,介绍了在互联网上能够获得哪些与环境科研有关的资源及如何获得所需要的资料 ,使互联网能够更好地服务于我们的科研工作。     

Development of database of real-world diesel vehicle emission factors for China

A database of real-world diesel vehicle emission factors, based on type and technology, has been developed following tests on more than 300 diesel vehicles in China using a portable emission measurement system. The database provides better understanding of diesel vehicle emissions under actual driving conditions. We found that although new regulations have reduced real-world emission levels of diesel trucks and buses significantly for most pollutants in China,NO_x emissions have been inadequately controlled by the current standards, especially for diesel buses, because of bad driving conditions in the real world. We also compared the emission factors in the database with those calculated by emission factor models and used in inventory studies. The emission factors derived from COPERT (Computer Programmer to calculate Emissions from Road Transport) and MOBILE may both underestimate real emission factors, whereas the updated COPERT and PART5 (Highway Vehicle Particulate Emission Modeling Software) models may overestimate emission factors in China. Real-world measurement results and emission factors used in recent emission inventory studies are inconsistent, which has led to inaccurate estimates of emissions from diesel trucks and buses over recent years. This suggests that emission factors derived from European or US-basedmodels will not truly represent real-world emissions in China. Therefore, it is useful and necessary to conduct systematic real-world measurements of vehicle emissions in China in order to obtain the optimum inputs for emission inventory models.     

Characteristics and availability of fatal road-crash databases in 20 countries worldwide

INTRODUCTION: This study examined the characteristics and availability of fatal road-crash databases worldwide. METHOD: The study involved two parts. First, the major international road databases were briefly reviewed. Second, the national databases in 20 selected countries were examined. RESULTS: (a) the available international databases of fatal road crashes typically include aggregated data; (b) there is a national database of fatal road crashes in each country examined; (c) all countries provide aggregated crash data, but there are substantial restrictions on the availability of disaggregated data; and (d) overall, the crash data at the accident level are relatively similar, but there are substantial differences in the information at the person level. CONCLUSION: The results imply that international road safety research would greatly benefit from expanded availability of disaggregated fatal crash data worldwide.     

Access数据库加密系统安全性剖析及改进策略

MSAccess是国内中小型企业的MIS广泛采用的数据库系统,它开发和维护都很方便,而且数据处理功能强大,是目前应用最为广泛地中小型数据库系统。但是由于其在加密方面设计欠周密,造成用户可以通过日期字段等方式对隐藏的密钥进行还原,使之成为该种数据库系统首要安全问题。笔者对其加密系统的漏洞和各种获取Access数据库密码的方式进行分析,提出一种通用的动态密钥空间加密技术改进和保护同类问题数据库系统。该技术具有密码保护的通用性和确保加密信息安全的特殊性;必定能为目前广大的MSAccess用户现存的数据安全问题的解决提供良好的思路和实施方法。同时它也给具有类似安全漏洞的大型数据库的加密体系的设计提供一个极好的新策略。     

The Setting-up of the Synthetical Database for Disaster Reduction

ＴｈｅｒｉｓｅａｎｄｄｅｖｅｌｏｐｍｅｎｔｏｆＩＤＮＤＲｉｎｔｈｅｗｏｒｌｄｉｓｕｎｄｏｕｂｔｅｄｌｙａｇｒｅａｔｐｕｓｈｔｏｔｈｅｃａｕｓｅｏｆｎａｔ－ｕｒａｌｄｉｓａｓｔｅｒｒｅｄｕｃｔｉｏｎｏｆｖａｒｉｏｕｓｃｏｕｎｔｒｉｅｓ．Ｉｔｃａｌｓｐｅ...     

Nutrient criteria for lakes,ponds, and reservoirs: A Bayesian TREED model approach

We develop regional-scale eutrophication models for lakes, ponds, and reservoirs to investigate the link between nutrients and chlorophyll-a. The Bayesian TREED (BTREED) model approach allows association of multiple environmental stressors with biological responses, and quantification of uncertainty sources in the empirical water quality model. Nutrient data for lakes, ponds, and reservoirs across the United States were obtained from the Environmental Protection Agency (EPA) National Nutrient Criteria Database. The nutrient data consist of measurements for both stressor variables (such as total nitrogen and total phosphorus), and response variables (such as chlorophyll-a), used in the BTREED model. Markov chain Monte Carlo (McMC) posterior exploration guides a stochastic search through a rich suite of candidate trees toward models that better fit the data. The Bayes factor provides a goodness of fit criterion for comparison of resultant models. We randomly split the data into training and test sets; the training data were used in model estimation, and the test data were used to evaluate out-of-sample predictive performance of the model. An average relative efficiency of 1.02 between the training and test data for the four highest log-likelihood models suggests good out-of-sample predictive performance. Reduced model uncertainty relative to over-parameterized alternative models makes the BTREED models useful for nutrient criteria development, providing the link between nutrient stressors and meaningful eutrophication response.