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.
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|
Actions (login required)