Oracle Spatial and Graph
Spatial Features - Presentations

Oracle Spatial User Conference

Creating The Location Intelligent Enterprise

Thursday, April 23, 2009
Tampa Marriott Waterside Hotel, 700 South Florida Avenue
Tampa, Florida, 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 2010 Oracle Spatial Excellence Award recipients!

Education & Research: Ivan LucenaGeoSpatial Software Integration LLC (GSI)
Innovator: Intermap
Integrated Enterprise: EPCOR
Partnership: Safe Software
Wednesday, April 22
Welcome Reception
Il Terrazzo Restaurant at the Tampa Marriott Waterside Hotel & Marina
Thursday, April 23
8:30-9:00 a.m. Welcome—Oracle Spatial Strategy & Directions (PDF 2.0MB or Flash 1.3MB)
Mr. James Steiner, Senior Director, Server Technologies, Oracle
9:00-10:00 a.m. Oracle Spatial 11g—Technical Update (PDF 1.3MB or Flash 2.6MB)
Dr. Siva Ravada, Director of Software Development, Oracle Spatial
10:00-10:30 a.m Break / Vendor Booths
10:30-11:30 a.m.       Oracle MapViewer and Middleware Technologies (PDF 3.1MB or Flash 2.1MB)
Dr. Jayant Sharma, Technical Director, Oracle Spatial; Dr. LJ Qian, Senior Software Development Manager, Oracle MapViewer
Demos of MapViewer with  APEX, WebCenter, and other Oracle technologies.
11:30 a.m.-12:15 p.m. Oracle MapViewer and Applications Dr. Jayant Sharma, Technical Director, Oracle Spatial
Demos of maps in action in Oracle Utilities, Retail, and Communications applications.
12:15-1:30 p.m. Award Luncheon
Presented by Dr. Xavier Lopez, Director, Oracle Spatial and Semantic Technologies
1:30-3:00 p.m. User Sessions
  Spatial and Mapping Applications Track
Moderator:  Mr. Joseph Seppi, Woolpert, Inc.

A Middle-Tier MAF/Tiger Voter District Editing Tool
(PDF 3.9MB or Flash 3.2MB)
Mr. Mark Millman, Mizar LLC; Mr. Joseph Seppi, CMS, PMP, Woolpert, Inc.

Coordinating Voter District updates requires State government to manage inputs from Counties using a variety of GIS and procedures. A simple, secure, scalable middle-tier program based on the MAF/Tiger dataset provides Secretaries of State and Boards of Elections with a single point of submission, visualization, review, and authorization, and the ability to edit voting districts and census blocks.  The application leverages Oracle Spatial, Oracle MapViewer and open source tools such as MyFaces/Trinidad and Java Persistence Architecture (JPA).

Combining Vector and Raster Data for Hydro Flow Analysis
(PDF 727KB or Flash 965KB)
Mr. Brandon Bergenroth, Research Analyst, RTI International

Environmental scientists need to understand flow of water and the contaminants it may transport across the landscape to help make decisions about the potential environmental effects of pollution. RTI used Oracle Spatial and its GeoRaster feature to implement a generic flow analysis procedure (the 'raindrop' tool) that calculates the path of water from any point on land to the closest surface water feature. Data sources include the National Hydrography Dataset (NHDPlus), which contains vector geometries representing the linear reaches and special waterbody polygons for wide rivers and lakes. NHDPlus also contains raster layers based on the National Elevation Dataset (NED), which provides information on the flow direction (e.g. down slope adjacent cells) for every elevation point.  A demo and code samples will be shown.

Adding Online DigitalGlobe Imagery to MapViewer Applications
(PDF 9.7MB or Flash 10.5MB)
Mr. Dave Brett, Solutions Engineer, DigitalGlobe; Mr. Brian Rohde, Sr. Product Manager, DigitalGlobe

The ability to add high-resolution imagery as a base layer to map-based applications and user interfaces adds value through improved usability, increased confidence in results and routes, and greater context to the information displayed in the map. This how-to session will review the capabilities of DigitalGlobe's jImageConnect for Oracle MapViewer and show how Oracle developers can begin adding imagery from one of the largest collections of high-resolution satellite and aerial earth imagery in the world.
Utilities Track
Moderator:  Mr. Mike Chambliss, Spatial Business Systems, Inc.

3-D Space-Time Visualization for a Green Smart Grid
(PDF 7.3MB or Flash 2.6MB)
Mr. Krishna Kumar, CTO, Space-Time Insight; Mr. Paul Baynham, Senior Consultant, eSpatial Solutions

This presentation will describe how Space-Time Insight’s solutions use Oracle Spatial infrastructure to provide visual 3D GIS analytics with rich 3D visualization. The solution combines the visual mapping abilities of tools such as Google Earth and Oracle MapViewer to provide "Space & Time" analytics for better grid management.   It will describe how energy companies can use Oracle Spatial to study demand and supply of electrical energy in near real time, and support other utilities operational and asset management functions.  Demos will be included.

An Innovative and Open Approach to Utilities Network Management at Oshawa PUC
(PDF 5.8MB or Flash 4.0MB)
Mr. Geoffrey Cameron, Executive Vice President,
Intelligent Networks; Mr. Ron Little, CET, Manager, Technology and Design, Oshawa PUC Networks Inc.

Angus GeoSolutions Inc. (AGSI) and Oshawa PUC Networks Inc. (OPUCN) will provide an overview of OPUCN’s journey from a legacy stand alone CableCAD system to a new enterprise spatial solution leveraging the open Oracle Spatial and MapViewer environment.  Oshawa’s implementation is based on AGSI’s Intelligent Network Solutions (INS) platform and comprises a new SPATIALinfo engineering design and job estimating solution with AGSI’s full GO360™ enterprise web environment enabling corporate data access, asset management, mobile work force, smart metering and operations.  AGSI and OPUCN will discuss and demonstrate how OPUCN’s open and innovative approach for spatial network information has rapidly enabled a variety of business applications in a cost effective manner.

Web-based Integrated Water Services Management System - Lowering TCO with Oracle Spatial
(PDF 1.3MB or Flash 2.0MB)
Mr. Mike Andrews, System Analyst, EPCOR

EPCOR Water Services implemented eSpatial's iSmart web application to enable office and field crews to integrate two existing applications. Water Services’ Oracle Spatial-based GIS system and IVARA Work Management System have been seamlessly integrated into a single web application. This application is used in the field allowing for real time viewing and updating of work orders, creating work orders, performing inspections and updating facility information using wireless technology.  The business advantages of using Oracle Spatial, technical components of the infrastructure, and lessons learned will be discussed.
3:00-3:30 p.m.       Break / Vendor Booths  
3:30-5:00 p.m. User Sessions  
  3-D Track
Moderator:  TBD

Visualization, Analysis and Management of 3D LiDAR Topography in Oracle Spatial 11g
(PDF 12.6MB or Flash 6.6MB)
Mr. Michael Smith, Physical Scientist, US Army Corps of Engineers; Mr. David Finnegan, Research Physical Scientist, U.S. Army Corps of Engineers

Ground-based and airborne laser altimetry (LiDAR) has provided the opportunity to characterize large-scale terrain and geologic processes at fine-scale resolutions. Processing and deriving information from this voluminous data can pose significant challenges.  Our approach combines Oracle Spatial 11g and OSGeo projects to manage and analyze Lidar datasets.  Demos and code samples will be shown.

Loading and Extracting 3D and Other Data to/from Oracle Spatial with Spatial ETL
(PDF 1.2MB or Flash1.9MB)
Mr. Dale Lutz, Vice-President of Development, Safe Software

With spatial ETL tools, organizations can save a significant amount of time when loading and extracting data from/to Oracle Database and Oracle Spatial. This session uses a live demonstration to illustrate ways you can use spatial ETL to load geospatial data into Oracle Spatial 11g and then extract it in 200+ formats for use in other applications. We'll also examine ways to load 3D objects into the Oracle Spatial 11g 3D spatial data type and output this data to 3D applications like Autodesk 3ds Max.

Managing and Visualizing Large Scale 3D Data in Oracle Spatial 11g
(PDF 2.0MB or Flash 1.3MB)
Dr. Oreste Tommasi, Vice President 3-D R&D, ABACO srl

This presentation explains how ABACO uses the new 3D data model of Oracle Spatial 11g. The presenters will provide live demonstrations of Web3D navigation using TINs (surface modeling), point clouds (LIDAR data) and 3D building models.  The solution allows real-time Web3D navigation through a large scale 3D data model stored within Oracle Spatial 11g, which also stores and manages layers of simple feature data, topology feature data, and georaster data.  A case study by Veneto Strade S.p.a., together with its technology partners SITECO S.r.l. and ABACO S.r.l., will show benchmark results using billions of points stored in the Oracle Spatial 3D data model for point cloud storage, in a road cadastral survey application.
Land Management Track
Moderator:  Mr. Steve Garth, Principal Product Director, Oracle Database Technology Marketing, Oracle

Managing ParcelPoint on Oracle Spatial 11g?Lessons Learned
(PDF 1.6MB)
Mr. Glenn Kronschnabl, CTO, First American Spatial Solutions

First American has built ParcelPoint, the first comprehensive, nationwide land parcel database. ParcelPoint  is built on top of Oracle Database 11g and Oracle Spatial 11g  running on SUSE Linux with Data Guard 11g physical standby. Its current parcel inventory (which grows on a daily basis) is currently at 110+ million parcel objects. The presentation will include lessons learned from the implementation as well as some example spatial applications utilizing ParcelPoint.

Oracle Spatial as an Integration Platform - Geodata Warehouse for the Group of Herten, Germany
(PDF 4.6MB or Flash 5.1MB)
Mr. Ken Clifford, P.Eng., CLS, Regional Business Manager, CISS TDI GmbH
Mr. Joachim Figura, CEO, CISS TDI GmbH

The group of Herten is the amalgamation of the city council of Herten, Germany and the municipal utility company of Herten. They have implemented a geodata warehouse based on Oracle Spatial. All base data, municipal application data, as-built data and third party data is integrated. The data is managed in a common Oracle Spatial data model, and accessed by several different GI systems.

Geoservices Framework at Rijkswaterstaat, The Netherlands
(PDF 7.8MB or Flash 1.6MB)
Mr. Bram Schiltmans, Technical Architect, Rijkswaterstaat NL

This presentation highlights the use of Oracle Spatial with a variety of open source software tools at Rijkswaterstaat, the government agency responsible for executing public works and water management, including the construction and maintenance of waterways and roads in the Netherlands.  The Geoservices framework is an integrated collection of tools, aiming at distributing GIS data through the intra- and internet. It includes a toolbox for applications that need to provide users with services, metadata and a viewer for their GIS-data. Of course, a comparison between Geoservice and Oracle MapViewer is inevitable, so this will be briefly addressed.
5:00-5:30 p.m.    Closing Reception  
Thank You to Our Generous Sponsor s
Opening Reception Co-Sponsor
Closing Reception and Bag Insert Sponsor
T-Shirt Sponsor
Continental Breakfast Sponsor
AM/PM Break Sponsors
Bag Insert Sponsor
Bentley Systems, Inc.
Table Top Exhibitors
Safe Software Inc.

Media Sponsor