Oracle Spatial: The Open IT platform for Geospatial Applications Speakers: Jim Steiner Sr' Director,

1
Oracle Spatial The Open IT platform for
Geospatial ApplicationsSpeakers Jim Steiner
Sr. Director, Server Technologies, Oracle
Shelby Johnson State Geographic Information
Coordinator, ArkansasCraig Neidig State GIS
Coordinator, West Virginia
2
Just a few words from your sponsor

• A little bit about Oracle, Oracle Spatial, and
  Oracles spatial technologies
• A little bit about what we have done to improve
  the development, delivery, and broad use of
  geospatial technologies
• A few experiences from your peers
• Shelby Johnson
• Craig Neidig

3
Oracle is Enabling Technology

• 1. A Geospatial Enabled Information Technology
  Platform Facilitates Information Sharing.     
  Interoperability through standards
•     With many GIS creators and consumers
•     Increasingly with business and operational
  systems
• . 
• 2. The demand for GIS information is increasing
  exponentially the staffing and expertise is not.

4
IDC Prediction in 2002

• Because foundation-level IT infrastructure is
  being spatially-enabled, IDC believes that within
  24 to 36 months, basic spatial capabilities will
  be ubiquitous within database management,
  application server and data access technology.
  This spatially-enabled IT infrastructure will
  give rise to a fundamentally different market
  structure than we see today.
• -- IDC, Spatial Information Management Report,
  October 2002 David Sonnen, Henry Morris, Dan
  Vesset

J2EE Server
Web Service Framework
Portal
Spatial Components
Tools Applications
Oracle Spatial
5
Challenge of Integrating GIS Operational Data
within the Enterprise

• Specialty GIS/RS servers
• Data isolation
• High systems adminand management costs
• Scalability problems
• High training costs
• Complex support problems
• Spatial data tightly coupled to specific
  application
• Information not aligned with Business Processes

Spatial Data
Tabular Data
Enterprise Data Server
Geo Engineering Server
GIS/Design
MIS
6
Enterprise GIS Architectures
Middleware (Loosely Integrated)
Spatially Enabled Database (Tightly Integrated)

• Attributes in database and accessible by all
  applications
• Geometries in database - but in proprietary
  binary format
• Geometry is only accessible via proprietary
  interfaces

• Geometries fully integrated within the database
  using native DBMS type
• Geometry data accessible by all applications
• Access based on open standards
• Oracles solution supported by all GIS vendors

7
Oracle Database10g Location Features

• Spatial
• All Locator features
• Over 330 Spatial functions and Operators
• Linear Referencing
• Spatial Aggregates
• Coordinate Transforms
• Network Data Model
• Topology Data Model
• GeoRaster
• Geocoder and Router
• Spatial Analytic Functions
• Oracle10g Enterprise Option Only

• Locator
• Points, lines, polys
• 2D, 3D, 4D data
• Spatial Operators
• Within-distance
• Spatial Relations
• Coordinate Systems
• Long Transactions
• Table Partitioning
• Object Replication
• Oracle10g Standard Enterprise

• Explicit Coordinate Transform
• EPSG coordinate system

• Location Service Quick Start
• GeoRaster Compression
• RDF Database

8
Mature Platform Technology
Oracle Spatial 10g R2 MapViewer 10g

• GeoRaster
• Compression
• EMEA Router
• EPSG
• RDF Database
• WMS

Oracle Spatial 10g R1 MapViewer 10g

• GeoRaster Data Type
• Topology Data Model
• Network Data Model
• Spatial Analysis Mining
• New Spatial Functions

Oracle9i Spatial/Locator Oracle9i AS MapViewer

• Spatial Functionality Bundled
• Coordinate Transformation
• Linear Referencing
• Spatial Replication
• Spatial Partitioning

Oracle8i Spatial

• Object Data type
• Circles, Arcs
• R-Tree Indexing
• Topology/Distance Operators
• Spatial Functions
• Oracle Enterprise Manager (OEM)

Capability
Oracle 7.3.3 Spatial Data Option
Oracle 7.1.6 MultiDimension

• Points, Lines, Polygons
• Quad-Tree indexing
• Spatial Operators

Points Only
Oracle7
2003
1995
1997
1999
2001
1994
2005
Time
9
Oracle is the overwhelmingly the most popular
Database Platform for Spatial Information
Management

• In repeated surveys, IDC has found that Oracle
  is used in an 80-90 share of Spatial
  Information Management oriented database
  installations.
• IDC, January 2005

10
Geospatial becomes mission critical
11
Oracle Application Server 10g MapViewer

• OGC-compliant Web Map Server
• Standard feature of the Oracle Application Server
• Integrated with Oracle Spatial and Oracle Locator
• Easily publishes data stored in Oracles native
  spatial data type (SDO_GEOMETRY) to the web
• Centralized symbology, annotation and map
  definition rules
• Provides an XML API, Java API and JSP Tag library

12
GEOdecisions
13
Open Standards Make it Happen

• W3C
• OGC
• SQLMM
• ISO211
• Open Mobile Association

14
Oracles Spatial Technologies

• Oracle is the only IT software company with a
  broad strategy and commitment to spatial which
  includes technology, partnerships, standards, and
  domain experts.
• The Oracle solution is the only solution truly
  capable of integrating location based information
  throughout the enterprise
• Oracles solution is the only solution with
  native support from all major GIS/Image vendors
  tools (defacto GIS industry standard)

15
To find out more...

• http//www.oracle.com/technology/products/spatial/
  
• Examples, white papers, downloads, discussion
  forum, sample data ....

16
Please welcome

• SHELBY
• CRAIG

17
The Spatial Warehouse
GIS Specialist Systems
Spatially Enabled Business Applications
Environmental Management
Logistics Management
Core Spatial Business Data Repository
Transportation
Financial Management
Crime Monitoring
Citizen Portal
DPW Services
Asset Maintenance
Topographic/Raster Cadastre Geo-coded
Address Street Center Lines Assets Environmental T
ransport Health/Social services Education Crime
Health Social Services
Criminal Justice
Education
Health Planning
18
Combining GIS with Operational Systems
Emergency Response
Multiple Apps Multiple Users