Oracle Spatial and Graph
Spatial Features - Presentations

Oracle Spatial User Conference

Thursday, May 19, 2011
Ronald Reagan Building & International Trade Center
122 North Second Street
Washington , DC 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 2011 Oracle Spatial Excellence Award recipients!

Integrated Enterprise—China Land Surveying and Planning Institute
Partnership—Bentley Systems, Incorporated
Education and Research—Simon Greener
Thursday, May 29
8:30-8:45 a.m. Welcome (5.0MB PDF)
James Steiner, Oracle
8:45-9:45 a.m. Best Practices for Oracle Spatial on Oracle Exadata Database Machine (2.0MB PDF)
Daniel Geringer, Oracle
9:45-10:15 a.m Break
10:15 a.m.-12:00 p.m. Technical Training Sessions from Oracle Spatial and MapViewer Development
10:15 a.m.-11:00 a.m. Oracle Spatial Web Services (1.4MB PDF)
Albert Godfrind, Oracle
Using Oracle’s Location-Enabled Tools: SQL Developer and APEX (1.1MB PDF)
Siva Rivada, Oracle
11:00 - 11:15 a.m Break
  Oracle MapViewer – New Features for Developing Mapping Applications (4.5MB PDF)
Oracle Spatial Team
Oracle MapViewer and Business Intelligence (Map Views In OBIEE11g) (2.1MB PDF)
Oracle Spatial Team
12:00-1:30 p.m.      

Lunch - Oracle Spatial Excellence Awards Presentation (2.7MB PDF)
Sponsored by NAVTEQ
Xavier Lopez, Oracle

Big Data & Location Intelligence (14.5MB PDF)
Joe Francica, Directions Magazine

1:30-3:00 p.m. Use Case Studies and Partner Sessions
  Track A (Rotunda Room)
Feberal/Regional Applications

Moderator: Den nis Beck, Spatial Business Systems, Inc.
Track B (Horizon Room)
Location Intelligence

Moderator: Steve Lytle, NAVTEQ

Oracle Spatial at Census (264KB PDF)
Atri Kalluri, US Census Bureau

The Geography Division of US Census Bureau hosts one of the largest Geospatial databases in the country - the MAF/TIGER database (MTDB). MTDB is the backbone of Census operations, and is mission critical in handling a myriad of day to day operations for updates and product creation. MTDB is built on Oracle Spatial and Topology Data Model, and required an efficient design for scalability, availability, interactive updates, batch and parallel processing, and a unique benchmarking requirement. This presentation will cover how Oracle Spatial plays a key role in managing MTDB and its data inflow and outflow processes, and how MTDB was instrumental in supporting the successful 2010 Decennial Census.

Oracle Spatial Cleans Up US EPA's Facility Registry System (2.8MB PDF)
Robert Booher, INDUS Corporation

USEPA's award-wining Facility Registry System (FRS) is a centrally managed database providing Internet access to a single source of comprehensive information about facilities subject to environmental regulations or of environmental interest. Oracle Spatial has been used to standardize, quality assure and analyze over 2.7 million unique facility records linking over 3.9 million program interest records from data within 25 national environmental data systems and over 45 state systems.

newGIS: A Persistent Topology-Based System to Provide Cartographic Transactional Web Services at the Province of Bozen, Italy (11.3MB PDF)
Wolfgang Moser, Autonomous Province of Bozen

The autonomous Province of Bozen in northern Italy has deployed a new provincial GIS based on the Oracle Spatial persistent Topology Data Model. This “newGIS” system centralizes geographic data for all the departments in the Bozen Province Administration. Any department, such as Cadastral, land use management, hydrographic, environment, has access to the centralized system to integrate cartographic data and services in their processes and their applications. Cartographic features are exposed via web services (GML/XML).

Location Intelligence and Spatial What-If Analysis for the Government: A New Way of Fighting Petty Crime (2.0MB PDF)
Marco Mantovani, Federico Ravaldi, Vasil Tabaku, ICONSULTING srl

An Italian government institution needed an efficient crime analysis system, where location analysis was integrated with data about crimes. iConsulting developed a Location Intelligence solution with powerful Spatial what-if analysis capabilities, using Oracle Spatial 11gR2, Oracle MapViewer 11gR1, and Oracle Business Intelligence Enterprise Edition (OBIEE) 11gR1. Furthermore, a custom JavaScript library which extends MapViewer Ajax APIs, to obtain a platform with specific BI features, was implemented. A live demonstration will show Spatial what-if analysis, full integration of OBIEE-MapViewer through custom library, custom BI features.

Advantages of Using Postcode Regions to Aggregate, Analyze and Visualize Data in Oracle Applications (8.8MB PDF)
Christopher Guider, GfK GeoMarketing

Oracle users can spot otherwise unseen trends and relationships in their data by associating it with postcode polygons and then displaying the results on digital maps. The use of postcode regions or tessellations as the primary reporting level offers distinct advantages over a purely point-based approach. This session explores these specific benefits and applications of aggregating address-based data to postcode regions and then analyzing the results directly on digital maps.

Oracle in the Cloud: GIS Software as a Service (3.8MB PDF)
Eamon Walsh, eSpatial Solutions

This educational presentation will show how eSpatial has deployed Oracle Spatial 11g on Amazon Elastic Cloud Computing Environment (EC2) to provide GIS Software as a Service. The technical approach to deploying, using, and managing Oracle 11g on Amazon Elastic Cloud Computing Environment (EC2) will be discussed, along with the benefits of this approach, lessons learned from deploying on EC2, best practices, and issues. The solution has been built and will be demonstrated.

2:30-5:00 p.m. Use Case Studies and Partner Sessions
  Track A (Rotunda Room)
Infrastructure Planning & Management
Moderator: Joe Roehl, American Digital Cartography, Inc.
Track B (Horizon Room)
Emerging Technologies
Moderator: Francois Valois, Bentley Systems
  Time Warner Cable: Enterprise-Wide Decision Support with an Integrated GIS System (3.3MB PDF)
Chris Nelson, Govind Bangarabale, Time Warner Cable & Murali Balakrishnan, VP Sales, IMMCO Inc.

To deliver the best service to customers and improve internal use of vertical applications, Time Warner Cable is deploying an enterprise-class Integrated GIS System using the Oracle product stack. This is a single source of truth for all its network assets, CIS, GIS, Network Management System, Construction Cost Analysis, and information, powering a decision support system that takes engineering data and has it traversed across multiple divisions for effective decision making. The system uses Oracle Spatial and Oracle Weblogic Server. WMS and WFS web services enable data sharing among vertical applications.

Tracking Vehicles with Oracle Spatial at Paris Airports (Aeroports de Paris)
Olivier Dubois, OSCARS; Aurelien Jolly, Aéroport de Paris & Albert Godfrind, Oracle

At an airport, time is money. With vehicle tracking, airport traffic can be optimized to avoid losing time. Learn how Aeroports de Paris (ADP) leverages Oracle Spatial 11g to maintain real time locations of all vehicles moving about the airport, together with a history of their past movements. Oracle Spatial linear referencing is used for historical data; Oracle Partitioning for fast response times and large data storage optimization; and MapViewer, Google Earth, and Mapguide for mapping.

Integrating GIS Platforms Across the Enterprise Using Oracle Spatial at Salt River Project (5.1MB PDF)
James Street, Epoch Solutions Group Inc. & Mark Ledbetter, Salt River Project

This case study will present the implementation at Salt River Project, an electric and water utility in Phoenix, Arizona. The presentation will address architecture, data modeling approach and how SRP leverages data in Oracle Spatial to support initiatives for Mobile GIS, Asset Management, SRP Maps Online, an Enterprise Web Based GIS application. Additionally we will cover how SRP migrates network connectivity data from the Smallworld Design Application directly into the Oracle Spatial Network Data Model to support user requirements with Spatial Data Web Services.
Sensor Data Fusion and Integration of Geospatial Data at Air Force Research Laboratory (Retitled to: Challenges and Advancements in Remotely Sensed Data Storage) (4.1MB PDF)
Joseph Seppi, Woolpert, Inc. & Matt McCue, Woolpert, Inc.

The Holy Grail of the Intelligence Community is Sensor Data Fusion. Sensors for intelligence, surveillance and reconnaissance (ISR) and data collected continue to increase. Assets must be coordinated to optimize collection. Processes such as real-time image registration and sensor fusion assure precision and confidence. Coordinating the complex ISR infrastructure and process calls for a unified approach that consists of three components: sensors, a sensor web backbone, and a situational awareness fusion engine (SAFE). Woolpert worked with Air Force Research Laboratory on Sensor Web Enabled (SWE) technology. This includes a geospatial information infrastructure backbone, and an Oracle Spatial database that enables interoperability with other data sources, and features such as change detection analysis of imagery.

Use of Oracle Spatial SDO_PC for Cloud-Based Point Cloud Data Management (1.8MB PDF)
Todd Rothermel, Paul DiGiacobbe, Tim Howerton, HNTB

LiDAR (Light Detection and Ranging) utilizes optical remote sensing to create precise digital models of a geographic area or structure. Architecture and engineering firms use LiDAR to record a project's existing conditions, and the data is stored in a point cloud for use in modeling and geospatial software. Because these point clouds are quite large, HNTB uses Oracle Spatial 11g and the Amazon EC2 cloud to efficiently manage the data through a secure, cloud-based solution.

City of Montreal's 3D Urban Model - Migration project to Oracle Spatial 11g (17.8MB PDF)
Francois Valois, Bentley Systems

Many organizations are now hitting the limits of 2D GIS and are now looking for more accurate results in their management and decision making process by using the third dimension. In this presentation we will talk about how governmental bodies at all levels can benefit from integrated 3D spatial database management using both Oracle Spatial 3D and Bentley Map. We will use examples such as City of Montreal and other organizations around the world which are working toward such systems.
5:00-6:00 p.m.   Closing Reception
Oracle Spatial 2011 User Conference Sponsors
Kscope 16

Oracle Database Cloud