Lyell Collection
Geological Society, London, Special Publications
Lyell Centre  |   Lyell Collection  |   Subscriptions   |   Geological Society  |   Email alerts  |   Online bookshop  |   Help

Keywords:
Author:
Advanced search>>
This Article
Right arrow Full Text (PDF)
Right arrow References
Right arrow Alert me when this article is cited
Right arrow Alert me if a correction is posted
Services
Right arrow Email this article to a friend
Right arrow Similar articles in this journal
Right arrow Alert me to new issues of the journal
Right arrow Download to citation manager
Right arrow Request Permissions
Citing Articles
Right arrow Citing Articles via Google Scholar
Google Scholar
Right arrow Articles by Power, S.
Right arrow Articles by Statham, I.
Right arrow Search for Related Content
GeoRef
Right arrow GeoRef Citation
Geological Society, London, Special Publications; 1995; v. 97; p. 145-155;
DOI: 10.1144/GSL.SP.1995.097.01.18
© 1995 Geological Society of London

Case Studies

Database design and data management on the Swansea-Llanelli Earth Science Mapping Project

S. Power, M. Scott, G. Robinson & I. Statham

Ove Arup & Partners, Cambrian Buildings, Mount Stuart Square, Cardiff CF1 6QP, UK

Earth science, environmental and planning information was collected for a 200 km2 area centred around Swansea and Llanelli, South Wales. The aim was to use this data to produce development advice maps for use in the planning process. To ensure efficiency of data storage and retrieval, a relational database was used, combined with a geographic information system (GIS), the GIS helping with data collection and data entry. This required the design of a logical model for data storage and manipulation, together with customized database forms for input and reporting. Information was captured in a variety of forms, ranging from reports and maps to text and existing databases, and often required different input techniques. The resulting comprehensive database was therefore stored in a structured way which has enabled effective interrogation and querying of the data to produce the information around which the final maps can be drawn. These, and the data, have already proved to be of importance and interest within the study area.