Oracle Spatial in British Geological Survey

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.