Transcript Oracle Spatial

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
–
Oracle9i
 Locator
 Spatial
–
Oracle9i Application Server
 MapViewer
 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
Application
Application
Monolithic
GIS
Proprietary
APIs
Spatial
Middleware
Open
APIs
Map Server
Proprietary
Files
Standalone
Traditional
DBMS
Spatially
Enabled
Database
Proprietary
Middleware
Internet
Platform
Early Spatial Systems: Hybrids
GIS
Geometries
Geometries
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
GIS
•
SQL
Attributes Geometries
SQL
eBusiness
eBusiness
eBusiness
•
•
•
•
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
FieldService
Service
Field
Service
Field
Web Services
e-Business Suite
B2B, B2E,
B2C
Application Server
Location Based Service Components
9iAS
MapViewer
SOAP
WSDL
Data Server
Spatial
Any
device
Locator
eLocation
Oracle9i
Oracle Location Technology
Oracle core technologies
Oracle9i Spatial Capabilities
Spatial Indexing
Spatial Data Types
Oracle9i
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
Polygons with holes
Circles
Arcs, arc strings
Rectangles
Compound elements
Spatial Data in Oracle9i 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
–
–
Implemented as functional extensions in SQL
Topological Operators
 Inside
 Touch
 Covers
 Equal
–
Inside
Contains
Disjoint
Covered By
Overlap
Distance Operators
 Within Distance
 Nearest Neighbor
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’;
Oracle Spatial: Additional Features
Original




–
–
–
–
–
–
–

Union
Coordinate Transformations
Linear Referencing System (LRS)
Spatial Aggregate Functions
Spatial Geometry Functions
Union
Difference
Intersect
XOR
Buffer
CenterPoint
ConvexHull
Difference
XOR
Spatial Analysis Functions
–
–
–
Intersect
LENGTH
AREA
Distance
Buffer
Spatial Vs. Locator
Locator
 Points, Lines, Polygons
 2D, 3D, 4D 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
FieldService
Service
Field
Service
Field
Web Services
e-Business Suite
B2B, B2E,
B2C
Application Server
Location Base Service Components
9iAS
MapViewer
SOAP
WSDL
Data Server
Spatial
Any
device
Locator
eLocation
Oracle9i
Oracle Location Technology
Oracle core technologies
Oracle9i AS MapViewer
 Standard component of Oracle9i AS
 100% J2EE 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 Oracle8i R3 and beyond
MapViewer: 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
MapViewer Architecture
XML: MapRequest
JDBC
HTTP
MapViewer
XML: MapResponse
Oracle9i 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 9iAS (MapViewer)
 New 9iAS customer, influenced by MapViewer feature
of 9iAS.
 Developing MapViewer 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
–
9i, 9iAS, 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
10g: Spatial Raster




New GeoRaster data type
Store, index, and retrieve raster data
Store, maintain, and retrieve GeoRaster 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
10g: 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
10g: 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 10G: 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 OracleWorld
online session survey
Thank you.
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