1 copyright © 2011, oracle and/or its affiliates. all ... · management and analysis platform •...


S15402 Google Maps, ESRI, Traffic, iPad: Bring it all Together With Oracle Spatial LJ Qian Jayant Sharma Sr. Mgr., FMW MapViewer Director, Spatial Prod. Mgmt.

ORACLE PRODUCT

LOGO


Latin America 2011 December 6–8, 2011 Tokyo 2012

April 4–6, 2012


Oracle OpenWorld Bookstore

•  Visit the Oracle OpenWorld Bookstore for a fabulous selection of books on many of the conference topics and more!

•  Bookstore located at Moscone West, Level 2 •  All Books at 20% Discount


The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.


<Insert Picture Here>

Outline

•  The basic mashup: maps in apps • What are Spatial and MapViewer •  External services and MapViewer • Demo (if possible) • Discussion


THE BASIC MASHUP: MAPS IN APPS


Basic Mashup: Application Content and MapViewer •  Simplest form: a database query containing a spatial

column, aka a MapViewer theme • Or the result of a stored procedure which • Can be spatial (e.g. asset location) or non-spatial (e.g.

work orders) • Must have a location identifier (e.g. asset id) • Or contain the location


Display applica*on content from a local database


Display spatial network analysis results


Display Results of Stored Procedures

14 Copyright © 2011, Oracle and/or its affiliates. All rights reserved. 14

OTM 6.2 Order Release Ac;on Map Order Release Shipment Routes

Shipment Destination

Shipment Source

Destination of OUTBOUND Unplanned Order


Map Views in Oracle BIEE 11g


OBIEE 11g map view on an iPad


TMC: Oracle SiteHub & Retail Analytics


iConsulting: BI Spatial Analytics


IMMCO Prototype: Linear Asset mgmt


ORACLE SPATIAL & FMW MAPVIEWER


“Points”

“Lines”

“Polygons”

Rasters

Topologies

3D

Oracle database

f1 f2 n1

n2

e1

e2 e3

e4 Networks

What is Oracle Spatial


Oracle Spatial Database Services Element 0

Element 1 (Hole) P1

P2

P3

P4

P5

P6

P7 P

8 H2

H3

H4

H1

Geometry Data Type

Indexing Rtree

Query/Analysis Select, join, buffer, within distance, nearest neighbor, intersection, union, convex hull, centroid, ...

ROADS RNAME ID TYPE LANES GEOMETRY

M40 M25

140 141

HWY HWY

6 4

X Y x1 y1

x2 y2

x3 y3

x4 y4

x5 y5

Abstract Data Type

Access: SQL (Structured Query Language)


“Spatial” Tables

•  Just like regular tables • Contain a column of type SDO_GEOMETRY to store the

geometric shape of the objects

CREATE TABLE map_countries ( id NUMBER PRIMARY KEY, name VARCHAR2(30), geometry SDO_GEOMETRY);


Map data © NAVTEQ

Analyze

SELECT c.holding_company, c.location FROM competitor c, bank b WHERE b.site_id = 1604 AND SDO_WITHIN_DISTANCE( c.location, b.location, 'distance=2 unit=mile‘ ) = 'TRUE'

Find all competitors within 2 miles of Northport Branch


Analyze What percentage of Yellowstone is in each state ?

WITH p AS ( SELECT s.state,

sdo_geom.sdo_area ( sdo_geom.sdo_intersection ( s.geom, p.geom, 0.5),

0.5, 'unit=sq_km') area FROM us_states s, us_parks p WHERE SDO_ANYINTERACT (s.geom, p.geom) = 'TRUE' AND p.name = 'Yellowstone NP'

) SELECT state, area, RATIO_TO_REPORT(area) OVER () * 100 AS pct FROM p

ORDER BY pct DESC;

STATE AREA PCT

---------- ---------- ---------

Wyoming 8100.7515 91.0636012

Montana 640.296007 7.19780878

Idaho 154.659879 1.73859


Oracle Spatial 11g Enables

Geocoding & Routing

3D, Point Clouds, and LIDAR Scrollable, Interactive Maps Spatial Web Services

Oracle BI Dashboards Raster Imagery


Oracle Locator vs Spatial

Topology Data Model Linear Referencing System

Spa*al Analy*c Func*ons

OGC Web Services

Native Spatial datatype Native Spatial index

Basic spatial queries Full projection support

GeoRaster Geocoder Routing Engine 3D Misc advanced spatial analyses

Oracle Locator

Oracle Spatial Option

Oracle Database

Enumerated in detail in the online Locator doc

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28400/sdo_locator.htm#i632018


Open and Interoperable

Data


Oracle Fusion Middleware MapViewer •  A J2EE component (.ear) for developing web mapping applications.

Usually deployed in WLS. •  Renders geospatial content stored in an Oracle database.

Background maps can be from 3rd party providers. •  Provides Java, Javascript, and XML request/response APIs.


Oracle Mapviewer

Mapviewer metadata

Mapviewer applica*on

Oracle Database

Styles – style definitions (markers, colors etc) Themes – association of style with data Base Maps – collection of themes Tilecaches – predefined base map tiles

build

build

build

OAS, WLS or other J2EE container Oracle Maps Javascript API

Spatial data


Oracle Mapviewer : architecture

Oracle Database

Mapviewer client side external map providers eLocation, Google, Bing

WebLogic or J2EE Container

MapViewer server components

map cache server

Oracle Maps server-side

Dynamic SQL queries rendering

engine

HTTP:

adapter HTTP

(map tiles and feature data) (Map interaction client lib)

(get map tiles)


Mapviewer facilitates different options

•  For content –  Local (Oracle database) – Online web services – Hybrid (local database + online content)

•  For development –  Java or javascript code embedded in application – Using ADF Faces (<dvt:map>)


External Services and MapViewer • Can be spatial (e.g. weather) or non-spatial (e.g. BI

report) • Must have a location identifier (e.g. county name, or

region id) • Or contain the location (e.g. georss) • Can be an XML document (BI report, georss) or JSON or

embeddable content (e.g. media) • Or an OGC WebFeatureService 1.0 response (i.e. a

GML 2.11 feature)


Display Content (XML) from External Services


Display Content (GeoRSS) from External Services


Display Content (JSON) from External Services


Display Content (media) from External Services


External Content (StreetView) on MapViewer Maps


ESRI basemap, NAVTEQ Traffic, fuel, incidents


External Map Services and MapViewer

•  Built-in support for Google and Bing Maps – Purely for tiles not their full javascript API

•  Interface (MVCustomTileLayer) for accessing other online map services (e.g. ESRI or OpenStreetMap)

• OGC WebMapService and WebFeatureService interfaces are also supported


MapViewer also renders applica*on content on background maps from online services


External Map Tiles in MapViewer


CustomTileLayer Interface and OpenStreetMap


CustomTileLayer Interface and ESRI ArcGIS Online


Summary

•  An Oracle database is a powerful, robust geospatial data management and analysis platform

•  FMW MapViewer renders application content •  The content can be in an Oracle database, or • Can come from other platforms or services

– Such as OBIEE or web services like Weatherbug

•  The map data can be stored using Spatial, or •  The background maps can come from services

– E.g. ESRI, Bing or Google Maps


The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.


Q&A

1 copyright © 2011, oracle and/or its affiliates. all ... · management and analysis platform •...

Documents