Web access to environmental databases: a database query and presentation system for the UK environmental change network

This paper describes the development of an interface to an environmental monitoring database using the World Wide Web (WWW) as a front-end. The Environmental Change Network (ECN) is the UK's long-term integrated environmental monitoring program. Many of ECN's users require access to ECN's data for reporting purposes. Since these users are unfamiliar with the use of the Oracle Relational Database Management System used by ECN and the structure of the data in the ECN database, they require guided access to the data. Additionally, these users generally do not require access to high-resolution data. They need access to summary data in order to view trends, display the data for reporting and as an aid to making policy decisions. To support these users, ECN has developed an interface to its summary data over the WWW (http://www.nmw.ac.uk/ecn/Database). The system allows users to query the ECN database by site, measurement and date range and displays the data in crosstabulations or graphs. Data may also be downloaded to the users local machine via electronic mail.