Oracle Spatial and Database Administration Consultancy
1Spatial offers Oracle Database Administration skills coupled with Oracle Spatial consultancy expertise for both Oracle9i and Oracle Database 10g. 1Spatial’s Consultants have been involved with a large variety of geospatial data reengineering projects over the last 10 years and have invested in developing expertise to encompass relational database technology and geospatial data.

1Spatial's Oracle Certified Professional DBAs can provide consultancy on all aspects of Oracle Spatial including:

• The Oracle Spatial Data Model and Geometric Datatypes - We can help with design and definition of spatial data models to allow for the optimal storage of Oracle's geometric data types, including creation of spatial layers and spatial indexing.
• Spatial Data Loading and Storage - Provision of services to import / export data using Oracle utilities or common GIS applications. We can optimise your database storage including spatial partitioning, spatial clustering and performance tuning services.
• Spatial Querying - We can develop queries to solve problems such as finding all roads in a town / county, or information searches based on a particular address, or a proposed development.
• Spatial Analysis - Consultancy on using advanced spatial functions to perform complex analyses, such as performing length, area and distance calculations or complex geometry manipulations such as line simplification.

Understanding these concepts is fundamental for maximising the potential of your data and gaining benefit from effective decision-making.