Oracle Spatial and Graph
Spatial Features - Presentations

Oracle Spatial User Conference

March 8, 2007
Henry B. Gonzalez Convention Center
San Antonio, Texas USA

Thanks to GITA, our partner sponsors, and all the users and solutions providers who made this year's user conference a success!

Congratulations to the 2007 Oracle Spatial Excellence Award recipients!

  • Education and Research Award: TU Delft (Delft University of Technology)
  • Innovator Award: Where2GetIt
  • Integrated Enterprise Award: Las Vegas Valley Water District
  • Partnership Award: Autodesk
Wednesday, March 7
6:00-8:30 p.m.

Opening Reception

Sponsored by:

GE imagination at work
Thursday, March 8
8:30-9:00 a.m. Welcome - Introductory Remarks
Jim Steiner, Sr. Director, Server Technologies, Oracle
9:00-10:30 a.m.   

Oracle Spatial 11g—Technical Overview
Dr. Siva Ravada, Director of Software Development, Oracle Spatial Products
An introduction to planned Oracle Spatial 11g new features, including:

  • 3-D
  • OGC Web Services
  • Network Data Model Enhancements
  • GeoRaster Enhancements
  • Routing & Geocoding Engine Enhancements
  • Workspace Manager
10:30-1:00 a.m. Break
11:00 a.m.-Noon

Oracle MapViewer 10.1.3
Dr. Jayant Sharma, Technical Director, Oracle Spatial Products
A deep dive look at Oracle MapViewer, including:

12:00-1:00 p.m. Award Luncheon
1:00-1:30 p.m. Oracle Spatial Special Interest Group Meetings

North American SIG

International Attendees
Moderator: Xavier Lopez, Oracle
1:30-2:00 p.m. Break
2:00-3:30 p.m. Technical Use CasesUser Sessions
  Track A Track B

Oracle Spatial: Narrowing the Gap Between CAD and GIS: A Topobase TM Implementation Case Study
Keath Long, Senior GIS Analyst, Las Vegas Valley Water District and Matt Seidl, CAD Analyst, Las Vegas Valley Water District

The Las Vegas Valley Water District AM/FM/GIS Division responds to organizational demand for facility-based information in one of the fastest growing cities in the country. Modernizing our CAD-GIS integration using Autodesk's Topobase with Oracle Spatial improved our ability to respond to business requirements. Implementing Topobase eliminated 80% of our in-house customization while improving our ability to provide accurate data to customers. Oracle Spatial is the common denominator between Topobase and ArcSDE and allows for elegant and tight integration of the 2 production systems.

Click here for related case study.

Spatial Technology Stack for West Virginia Statewide Mapping System
Dave Fuhry, Technical Specialist, Michael Baker Jr., Inc.

Like many other regional entities, West Virginia state is developing a maintainable organization-wide addressing database, realized by a stack of spatially-enabled components. We discuss the alternative technologies we evaluated and the technical reasons for choosing Oracle Spatial 10g for vector and raster storage, and Oracle MapViewer 10g for map generation. We decompose the WVSAMS web-based maintenance application and discuss the advantages of JDeveloper-managed ADFFaces/Trinidad JSF development, and the current ORM technique & alternatives including Toplink and Hibernate/EJB 3.

Using Oracle Spatial for Managing Multiple Enterprise Workflows in Utilities
Karen Bachmeyer, Technical Director, Intergraph Corporation

The GIS department database has become the corporate gold mine. Not only is the technology robust enough to support large databases, but executives realize the value of mining the data for enterprise use. This session will highlight four application workflows within a utility company - design system for data acquisition; analytical tool for long-range planning; Oracle Application Server 10g MapViewer application for geospatial asset data queries; a tax billing report. The session includes demonstrations and code samples.

Advances in Utility Network Management with Oracle Spatial
Robert P. Laudati, Marketing Program Manager, Electric T&D, GE Energy

GE Energy delivers geospatial asset management solutions focused on the unique aspects of modeling utility networks. Recently, the company has embarked on the development of utility applications completely based on Oracle Spatial, without the need for proprietary abstraction layers, providing an opportunity to provide market-leading products that truly support Oracle's vision for the utilization of Oracle Spatial. This presentation demonstrates how various Oracle Spatial components such as the network data model are being leveraged to address fundamental utility business processes.

Designing GIS Applications for Mobile Web Devices
Matthew Bafford, Senior GIS Consultant, eSpatial, Inc.

This session covers the challenges and considerations involved in providing GIS functionality to mobile devices. This case study highlights the process of converting the existing DOD MilitaryINSTALLATIONS web based GIS application so that it can be accessed via PDA and SmartPhone devices. The talk will discuss the technical and user interface challenges inherent in designing mobile web applications, including navigation limitations, slow network speeds, small screen sizes, and device quirks. Technologies used: Oracle Spatial, J2EE, eSpatial's iSmart server.

"Virtual" Connected Live Field Data Maintenance
Jesse M. Day, Data Maintenance Manager, Florida's Turnpike Enterprise

This presentation will review initial data collection and maintenance procedures for Florida's Turnpike Enterprise asset management system (TEAMS), and will detail the development and implementation of a data maintenance system utilizing Oracle Spatial and Acquis' ADE Remote. This technology provided a means of realizing the Turnpike's ultimate vision of live field data maintenance along the entire Turnpike network, while meeting interim requirements for timely data collection and maintenance via remote, disconnected map-based interfaces.

3:30-3:45 p.m. Break
3:45-5:15 p.m. Technical Use CasesUser Sessions
  Track A Track B

Case Studies in Using Oracle MapViewer and Oracle Spatial 10g for Mobile Applications
Ross Caldow, Project Manager, Geomatic Technologies

This session will detail and include demos of how Oracle Spatial 10g, its network data model, and Oracle MapViewer support two mobile solutions for the State of Victoria in Australia. The first was developed to service over 90,000 visitors to the Melbourne 2006 Commonwealth Games and route them to venues, restaurants, hotels and other attractions via Melbourne's public transport network. The second application documents the impact of bushfire (wildfire) devastation and assists in subsequent recovery activities.

Relocation Scenario Analysis: Using the Oracle Spatial Routing Engine To Manage Resource Reassignments
Steven Pierce, Geospatial Solutions Lead, Johnston McLamb and Greg Keefe, Account Manager, Johnston McLamb

This presentation explores how an organization faced with frequently reassigning employees created a relocation scenario analysis tool using the Oracle Spatial routing engine. The organization has been able to identify optimal plans based on start/end points, the types of employees relocating, what types of positions they can fill, etc. The session includes a demonstration of how Navteq/ACDI data is loaded, as well as how transportable tablespaces are used in the application.

Slippymaps and Oracle Spatial Integration
Jon Scarbrough, Director, Where2GetIt, Inc.

By adopting Oracle Spatial, Where2GetIt upgraded its legacy spatial platform gaining increased geocoding and driving directions accuracy while increasing their volume capacity by multiples.  The combined Oracle/Navteq solution is used to support geocoding, reverse geocoding, proximity search and driving directions. The Oracle/Navteq spatial platform has allowed Where2GetIt to enhance proximity searches by including searching locations by drive time and drive distance.  The technology installation, setup, configuration and the W2GI APIs will be demonstrated during this session.

Oracle Spatial and the Utility Business - Things That Go Well Together
Doug Laslo, Utility SME, Autodesk and Stephen Brockwell, Program Manager, Autodesk

Oracle Spatial greatly simplifies the process of gathering information in relation to location. Almost everything that utilities do in day to day business includes location as a factor. Most utilities continue to solve the problem of spatially locating their assets by utilizing legacy GIS engines. But some have recognized the simplicity brought about by Oracle Spatial. The questions utilities need to answer in their daily activities can be answered by querying the database through SQL. Several real life examples of significant business gains will be explored.

Greater Toronto Airport Authority Adopts Oracle Spatial To Enhance Data Interoperability
Mike Robertson, Manager, Technical Data Centre, Greater Toronto Airport Authority and Francois Valois, Product Manager, Bentley Systems

The benefits of Oracle Spatial as an enterprise data store are well recognized around the world. Greater Toronto Airport has chosen this technology to store their mission critical information. For most engineering applications, however, Oracle Spatial has to be used as part of a larger context. This presentation covers the business cases and technical requirements that motivated Toronto Airport to select Oracle Spatial as part of their engineering and facility management solution.

Himmerlands Energy - Spatially Enabling Grid Planning, Maintenance, and Operations
Sren Sejr Petersen, CTO, HEF Himmerland Elforsyning A.m.b.a

This presentation will focus on the practical value of Oracle technology to Himmerlands Elforsyning (HEF), a grid operator in the northern part of Denmark.  This session highlights the use of Oracle for geographical mapping, grid analysis, project planning and economic calculations.  We discuss our usage of Oracle Locator and workspace manager for versioning.  Oracle 10g enables HEF to attain development goals efficiently, and provides robust and secure management of our valuable data for the future on a standardized open platform.
5:15-6:00 p.m. Closing Reception