Oracle Spatial in British Geological Survey

Nayembil, Martin; Adlam, Keith. 2008 Oracle Spatial in British Geological Survey. In: Oracle Spatial Special Interest Group (SIG), British Geological Survey, 07th February 2008. Wimbledon, UK, UK Oracle User Group (UKOUG).

Before downloading, please read NORA policies.

Preview

Text BGSPresentation.pdf Download (7MB)

Abstract/Summary

BGS has been using Oracle Spatial to generate geometries for point data sets; these geometries are subsequently processed into ESRI ArcGIS layers, and also queried directly by various applications using Oracle Spatial functions. This talk will illustrate this work by way of examples and will move on to consider the data management issues encountered when modifying long-established data models. The underlying base tables are generally not modified, but the spatial geometries are added via related attribute tables which in turn are kept up to date using a combination of techniques including PL/SQL procedures, views, materialized views and function-based indexes.

Item Type:	Publication - Conference Item (Paper)
Programmes:	BGS Programmes > Information Systems Development
Additional Keywords:	oracle, spatial
NORA Subject Terms:	General Data and Information
Date made live:	29 Oct 2008 16:48 +0 (UTC)
URI:	https://nora.nerc.ac.uk/id/eprint/4670

Actions (login required)

View Item

Document Downloads

More statistics for this item...