Session id 40340 Leveraging Location-Based Services for Everyday

Session id: 40340 Leveraging Location-Based Services for Everyday Government and Emergency Management Clarke Colombo Technologist Oracle Corporation

Overview Ÿ Geospatial Technology Trends Ÿ Oracle’s Spatial Technologies – Oracle 9 i Ÿ Locator Ÿ Spatial – Oracle 9 i Application Server Ÿ Map. Viewer Ÿ Location Based Services Ÿ Government Customer Examples Ÿ Oracle’s Future Direction Ÿ Spatial Partners

Challenge of Incorporating Location Based Information Ÿ Specialty GIS/RS servers – – – Data isolation High systems admin and management costs Scalability problems High training costs Complex support problems Ÿ Information not aligned with Business Processes Spatial Data Geo Engineering Server GIS/Design Tabular Data Enterprise Data Server MIS

Integrating All Information Ÿ Relate associated information to spatial locations – – – Land records Property photographs Satellite imagery Vector map data Legal Documents

Value Propositions: Ÿ Ÿ Ÿ Integrated enterprise data management Consolidated management of spatial operations Greater security and interoperability Enhanced decision support and business intelligence Reduced training requirements Spatially enabled applications Spatial is a differentiator

GIS Stovepipe to Internet Platform Yesterday Today Application Monolithic GIS Proprietary APIs Spatial Middleware Open APIs Map Server Proprietary Files Traditional DBMS Standalone Spatially Enabled Database Proprietary Middleware Internet Platform

Early Spatial Systems: Hybrids GIS Geometries Attributes blobs SQL • • IT Attributes in database Geometries in database - but in proprietary binary format IT can access geometries via proprietary interfaces only Poor integration

Open Spatial Databases GIS GIS • SQL Attributes Geometries SQL e. Business • • Attributes and geometries fully integrated in the database Spatial is native DBMS type IT can access geometries via open standard interfaces Standard Query Language Supported by all GIS tools

Location-enabling Oracle Stack CRM & ERP Applications TCA schema Field Service Web Services e-Business Suite B 2 B, B 2 E, B 2 C Application Server Location Based Service Components 9 i. AS Map. Viewer SOAP WSDL Data Server Spatial Any device Locator e. Location Oracle 9 i Oracle Location Technology Oracle core technologies

Oracle 9 i Spatial Capabilities Spatial Indexing Spatial Data Types er om ust C s gs ldin i Bu ets e Str Oracle 9 i All Spatial Data Stored in the Database Fast Access to Spatial Data Spatial Access Through SQL Select a. building_id from facility a, facility b where sdo_within_distance( a. geom, b. geom ‘distance = 10 unit = mile’) = ‘TRUE’;

Spatial Data Types Ÿ Ÿ Ÿ Ÿ Points Line Strings Polygons with holes Circles Arcs, arc strings Rectangles Compound elements

Spatial Data in Oracle 9 i Tables Data type: SDO_GEOMETRY Road ROAD_ID NAME SURFACE LANES 1 Homestead Asphalt 4 2 Bellomy Asphalt 2 3 Santa Clara Asphalt 2 LOCATION

Spatial Operators Ÿ Full range of spatial operators – – Inside Implemented as functional extensions in SQL Topological Operators ŸInside ŸTouch ŸCovers ŸEqual Contains Disjoint Covered By Overlap 50 0 m et – Distance Operators ŸWithin Distance ŸNearest Neighbor er s Within Distance

Spatial Query Via SQL Find all building within 500 meters of building 902 SQL> SELECT a. building_id 2> FROM base_buildings a, 3> base_buildings b 4> WHERE b. building_id = 902 5> AND MDSYS. SDO_WITHIN_DISTANCE( 6> a. Location, b. Location, 7> ‘distance=500 unit=M’) = ‘TRUE’; 50 0 m et er s

Oracle Spatial: Additional Features Original Ÿ Ÿ Union Coordinate Transformations Linear Referencing System (LRS) Spatial Aggregate Functions Spatial Geometry Functions – – – – Union Difference Intersect XOR Buffer Center. Point Convex. Hull Difference XOR Ÿ Spatial Analysis Functions – – – LENGTH AREA Distance Intersect 50 0 m et er Buffer s

Spatial Vs. Locator Ÿ Points, Lines, Polygons Ÿ 2 D, 3 D, 4 D data Ÿ Spatial Operators – – Topological Distance Ÿ Distance Function Ÿ Ÿ Coordinate Systems Workspace Management Table Partitioning* Object Replication* Spatial Ÿ All Locator features Ÿ Spatial functions – – area/length calculation buffer, centroid, union, etc Ÿ Spatial Aggregate Functions Ÿ Coordinate Transforms Ÿ Linear Referencing Ÿ All Future Functionality

Location-enabling Oracle Stack CRM & ERP Applications TCA schema Field Service Web Services e-Business Suite B 2 B, B 2 E, B 2 C Application Server Location Base Service Components 9 i. AS Map. Viewer SOAP WSDL Data Server Spatial Any device Locator e. Location Oracle 9 i Oracle Location Technology Oracle core technologies

Oracle 9 i AS Map. Viewer Ÿ Standard component of Oracle 9 i AS Ÿ 100% J 2 EE compliant Mapping engine Ÿ Tightly integrated with Oracle Locator and Oracle Spatial Ÿ Provides an XML API for defining and deploying maps via the web Ÿ Renders data from Oracle 8 i R 3 and beyond

Map. Viewer: Map Title Earthquake Strength Ÿ Renders data stored using Oracle’s native spatial data type (SDO_GEOMETRY) Ÿ Maps are defined as a collection of themes Ÿ Maps may contain a title, legend and footnote Ÿ Theme styles can be based on attribute values (thematic maps) Ÿ GIF, BMP and PNG image formats Legend Footnote Themes

Map. Viewer Architecture XML: Map. Request JDBC HTTP Map. Viewer XML: Map. Response

Oracle 9 i AS Location Based Services Ÿ Java APIs - ingest online web services: geocoding, routing, mapping, YP, traffic, mobile positioning Ÿ Region Modeling - associates services (billing, personalization) by (geographic) “regions” Ÿ Location Caching - caches caller’s phone number & location to minimize wireless network pinging. Ÿ Location Privacy - manages based on LBS service type, permissions, and subscription. Ÿ Location Marks - Manages user defined locations of interest (home, work, PIM addresses)

Oracle Spatial in Action

New York City Ÿ Department of Information Technology & Telecommunications – Developed standardized digital basemap for all agencies Ÿ 6, 000 miles of underground pipes Ÿ 1 million water/sewer connections Ÿ 32, 000 sq. miles of Infrastructure Data Ÿ 7, 500 digital photographs Ÿ The Office of Emergency Management created a public site for emergency preparedness – Extensively Used To Support 9/11 Response and Recovery

Oracle in Action: Ÿ The consolidated spatial data warehouse was the foundation for NYC’s response to the recent tragedies – – – First responder deployment Critical infrastructure management Road closures Evacuation areas Damage assessment Ÿ The Office of Emergency Management created a public site for emergency preparedness – – Hurricane flood risks and evacuation routes Heat Advisory “cool down locator” (pools, senior centers, community centers) Ÿ Department of Health uses the system to track instances of West Nile Virus

New Jersey Ÿ Office of Emergency Management Ÿ State unable to catalogue emergency response resources, publish plans, deploy Ÿ Different naming conventions, different systems, many private sector owned Assets Ÿ Response to emergency events severely compromised – Lessons learned from 9/11 assisting NYC

City of Edmonton Ÿ Integrated, central repository for spatial and relational data – – Replaced 49 disparate land apps &166 databases Citywide sharing of standardized data Ÿ Data feeds: land registry and surveys, utilities and phone co. , tax assessments, Dept. of Public Works Ÿ Users: engineers, planners, cartographers, city officials and departments, mortgage lenders, citizens Ÿ http: //maps. gov. edmonton. ab. ca/

FAA – Oracle Spatial Ÿ Site license for Oracle Spatial Ÿ US Airspace Boundary Crossing Application – – – Oracle Spatial functions to calculate intersection of flight paths and US airspaces. Linear Referencing to interpolate the time and altitude for entry/exit points of US airspace. Accurately charge foreign carriers for the amount of time in US airspace. (Longitude, Latitude, Altitude, Time) Actual radar blip Computed (Lon/Lat, Alt, Time)

FAA – Oracle 9 i. AS (Map. Viewer) Ÿ New 9 i. AS customer, influenced by Map. Viewer feature of 9 i. AS. Ÿ Developing Map. Viewer application for flight plan visualization Ÿ Spatial analysis to project current flight position to next waypoint of original flight plan. Ÿ Another example of LRS functionality Waypoints Filed Flight Plan Current position Future Flight Plan

VIGILENT: Medical Surveillance and Incident Response Ÿ Built On The Oracle Platform – 9 i, 9 i. AS, Spatial, Wireless CP Ÿ Functional Capabilities – – – Real-time Disease Surveillance Critical Care Tracking and Response Management System Automated Alerts for Suspicious Trends Ÿ Proven Solution – – State of Florida (45 Hospitals & 4 Counties) Phoenix, AZ (14 Hospitals & 4 Counties) Northern Virginia (18 Hospitals & 1 County) Many more…

Oracle’s Future Direction

10 g: Spatial Raster Ÿ Ÿ New Geo. Raster data type Store, index, and retrieve raster data Store, maintain, and retrieve Geo. Raster metadata Analysis functionality: – – – – Generate pyramids Copy Change format: Interleaving, blocking Subset: Crop, cut, clip by band or layer Scaling: Enlarge or reduce Generate the spatial extent of an image Tile adjacent images to build a mosaic of the data Ÿ Georectified/Georeferenced images supported

10 g: Topology/Network Manager Ÿ New topology data model – – – Storage based on topological elements (or primitives) Ÿ Nodes Ÿ Edges Ÿ Faces Topological element stored once in the database Topological integrity maintained by database Ÿ Functionality – – – Topological element can be associated with one or more features General purpose support and analysis of networks Connectivity, adjacency and attribution at link level

10 g: Spatial Mining & Analysis Ÿ Pattern Discovery Process – – Based on spatial patterns Integration with Oracle Data Miner

Oracle Spatial Solution Providers

Spatial Partners

Next Steps…. Ÿ Recommended sessions – – – 40337: Integrated Technology Solutions For Better Government 40342: Leveraging Technology to Secure Our Nation 40125: Oracle 10 G: A Spatial VLDB Case Study Ÿ Recommended demos and/or hands-on labs – Hands On: Building Database Applications Ÿ Lesson 6: Performing Location-Based Analysis Using Oracle Spatial and Workspace Manager Ÿ See Your Business in Our Software – Visit the DEMO grounds for a customized architectural review, see a customized demo with Solutions Factory, or receive a personalized proposal. Visit the DEMOgrounds for more information. Ÿ Relevant web sites to visit for more information – http: //otn. oracle. com/products/spatial

Reminder – please complete the Oracle. World online session survey Thank you.

Q & A Q U E S T I O N S A N S W E R S http: // technet. oracle. com/products/spatial http: //technet. oracle. com/products/iaswe