using ogc standards to link bi and spatial

Using OGC Standards to link Business Intelligence and Spatial Analysis

Roderick RossLocation Intelligence Specialist

Product & Business Dev’t Manager (Integeo)

rodr@integeo.com

Cameron ShorterOGC Associate Member (Lisasoft)

Geospatial Solutions Manager

cameron.shorter@lisasoft.com

Agenda

• Introduction to OGC and its standards– By Cameron Shorter (Lisasoft)

• OGC to link Business Intelligence and Spatial– By Roderick Ross (Integeo)

• Q & A

BackgroundLisasoft

• Founded in 1994

• OGC Associate Member, Chairs AUS/NZ chapter of OSGeo

• Offices:– Sydney, Melbourne,

Adelaide, Brisbane

• Work in:– Government– Telecoms– Private enterprise

Integeo

• Founded in 2004

• Leading Location Intelligence specialist

• Offices:– Sydney, Canberra, Iberria,

UK, Southeast Asia– Partners in Asia, Australia,

New Zealand, US, Canada, Mexico and Europe

• Work in:– Government– Telecoms– Private enterprise

Ask a Question!

Attendee Control Panel

Expand window to take up full screen

Close / Open dialog box

Submit questions

Raise hand if you wish to say something

Open Geospatial Consortium

• Development of open geospatial standards

• Certification of compliant software

• Advocacy of Interoperability

OGC Standards

• Web Map Services (WMS)

• Web Feature Service (WFS)

• Web Coverage Service (WCS)

• Web Processing Services (WPS)

• Sensor Webs

• Formats (GML, KML, ..)

• Governments freeing Public Sector Information

• Embracing Open Technologies

• Standards reduce cost of sharing

ROI on Open Standards

• 26% overall saving.– Lower costs for sharing data.– Low Maintenance and Operation costs outweigh higher

implementation costs.

• Significantly reduce risk.– Long term support for Standards– Services Oriented Architecture allows componentizing

future enhancements.

Geospatial Interoperability Return on Investment Study, NASA Geospatial Interoperability Office, April 2005

Geospatial Open Source

• Robust

• Standards Compliant

OGC to link Business Intelligence and Spatial

• Use of OGC standards to provide a generic connection framework between reporting tools and geospatial systems.

• Types of data that are combined to support better program management, gap analysis and demographic analysis

Business Intelligence (BI)

• Business Intelligence tools provide the ability to comprehensively analyse non-spatial attributes in data.

• Interactive charting, data pivots, computed items are the norm.

• Drilling and filtering are all out of the box.

• Building applications is usually a 100% drag and drop exercise with no code required.

• For the major BI platforms, centrally managed security is also a given.

• Most importantly, the Business Intelligence platforms are widely accepted by users as the one-stop shop for access to business data.

• More and more, spatial analysis is expected to be a part of this picture.

Example - A BI Perspective

BI can show you attributes such as destination post code or value of customer sliced dynamically by sales quarter. Relationships between post codes are hard to see.

Location Intelligence (LI/GIS)

• Location Intelligence is a mature domain allowing users perform spatial analysis.

• Create maps from spatial data

• Can highlight spatial patterns in data such as geographic clusters of incidents

• Capable of advanced visualisations such as hot spot or gas cloud analysis

• Not very good at analysing non spatial data or representing data in a non spatial environment.

Example - A LI Perspective

LI can show you complex diagrams of clusters, value by region and distance traveled. Displaying comparative numbers and attribute data however is not its forte.

Integrated LI/BI

Combining the data

• Business Data– Program Data– Incident Data– Data from your organisation

• GIS Base Maps– Roads, Waterways, Parks (background data)– Postcodes, Suburbs, SLA, SSD, SD etc.– Custom regions e.g. service areas, HACC regions

• Reference data– ABS Data– Data from other agencies e.g. Centrelink

An Integration Platform

COGNOS

OBIEEHyperion

BusinessObjects

MicroStrategy

atial Integ

ration

Server

siness In

telligen

latform

OGCCompliant

server

Microsoft Reporting Services

Business Data GIS Base MapsReference Data Reference Data

Data Flow

Business

Reference

Business

Intelligence Platform

Spatial Integration

Platform

OGC Compliant

GIS Server

Map Layers

Report

Output

Report

Queries

Requests

The base map is made up of layers

Land Mass

Streets

Web Mapping Service (WMS)

• Intended to allow dynamic maps to be created by layering maps from the source providers similar to overhead projector slides.

• WMS defines three operations:1. returns service-level metadata2. returns a map with well-defined geographic and dimensional parameters3. returns information about particular features shown on a map (optional)

• The request indicates what information is to be shown on the map, what portion of the earth is to be mapped, the desired coordinate reference system, and the output image width and height.

• Multiple maps from different sources can be accurately overlaid to produce a composite map.

A WMS Image is made up of layers

Land Mass

Streets

Web Feature Service (WFS)

• Designed to provide open mechanisms for working with raw geographic data such as points, lines and polygons.

• Data manipulation operations include the ability to:– Create a new feature instance– Delete a feature instance– Update a feature instance– Get or Query features based on spatial and non-spatial

constraints

• The basic Web Feature Service allows querying and retrieval of features. A transactional Web Feature Service (WFS-T) allows safe creation, deletion, and updating of features.

WFS Features

Returned as XML (GML)

<Feature fid="142" featureType="school" > <Description>Balmoral Middle School</Description>> <Property Name="NumFloors" type="Integer" value="3"/> <Property Name="NumStudents" type="Integer" value="987"/> <Polygon name="extent" srsName="epsg:27354"> < <CData> 491888.999999459,5458045.99963358 491904.999999458,5458044.99963358 491908.999999462,5458064.99963358 491924.999999461,5458064.99963358 491925.999999462,5458079.99963359 491977.999999466,5458120.9996336 491953.999999466,5458017.99963357 </CData> </LineString> </Polygon> </Feature> LineString name="extent" srsName="epsg:27354">

Styled Layer Descriptor (SLD)

• A Styled Layer Descriptor allows a client to specify custom styles (such as colour and feature symbolization) that a Web Map Service will use to render a map layer.

• Controls the styles of outlines, fills, the look of highways etc.

SLD can take you from this…

… to this

Or from these…

to this.

Or a style like this

Web Map Context (WMC)

• The WMC allows layers from different providers to be defined as a map that can be published or reused.

• Web Map Context Documents are an XML application which specifies grouping of one or more maps coming from one or more Web Map Services to display a map composition within a given area of interest.

• Web Map Context Documents can be generated, saved, reused and exchanged within and between web mapping viewer client applications. Web Map Context Documents are analogous to ‘projects’ or ‘workspaces’ in common GIS desktop applications similar to a MapXtreme mdf or an ArcIMS AXL documents.

Business Data

• Point Data– Display Colour coded symbols or images– Requires a coordinate in the business data

– An address that is geocoded

• Region Based Data– Requires a common name or ID between the base

map layer and the business data

– Point data from which regions may be inferred

• Visualisations are built on these

Reference Data

• ABS and other Agency data that add value to your data

• Tagging your business data– ABS comes in a hierarchy of geographical

boundaries. Mesh Block, CD, SLA, SSD etc– Matching your data to these boundaries is very useful– Thousands of variables from the ABS alone– Lots of other agency data available

• Penetration and gap analysis– Inclusion of reference data in your BI reports allows

direct comparisons and computed item with your program data.

– Reference data can also be surfaced direct from the BI tool, but without dynamic computations with your business data

Putting it together

• BI platform sources business and reference data

• BI platforms use a common interface to communicate with the spatial integration server

• WFS uploads data

• SLD defines style parameters

• WMC defines the layers and order

• WMS returns the finished images

• The spatial integration server controls the transactions

• The spatial integration server merges other data sources such as web services.

• The spatial integration server provides advanced visualisations

Who is doing this

• Fisheries, Defence, Police, Lands, Health, Innovation, Employment, Education Law & Justice, Family and Community Services, Transport, Communications

– Program Management– Fisheries Management– Social Inclusion – Recruitment– Resource Management– Incident Analysis– Coverage Analysis– Questionaire and feedback analysis

Sample Fisheries Analysis - Cognos

Sample Fisheries Analysis – Google

Sample Crime Analysis - BOBJ

Sample Health Analysis - Cognos

Sample Incident Analysis - Hyperion

Sample Program Management - Hyperion

Town Planning – Google Earth

• Game Machine Analysis - Cognos

Sample Signal Analysis

Demographic Analysis - Excel

My Time Program Management

• MyTime groups provide local support for parents caring for disabled children

• They provide professional carers allowing parents to share ideas, socialise and have some ‘My Time’

• Provide research-based parenting information to parents

• Grant based funded by FAHCSIA

• An simple Excel based application was built to aid in site location

• Examines proposed locations, existing services and reference data

My Time Site Selection

• Proposed sites are entered in an Excel Spreadsheet

• Addresses automatically geocoded

• An initial plot provides geographical context

• Each site is bookmarked for easy navigation

• 5 and 10 KM lines give coverage indicators

• Closer inspection of nearby MyTime locations– Locations stored on other Excel sheets

• Add ‘competitive’ programs

• Add relevant demographic data– Persons needing assistance aged 0 to 6 by SLA

• View existing service provision by Electorate compared to proposed additional services

• Select site

• Use links fromElectorates toget member detailsfor selected sites

• Inform the localmember

Questions?

Roderick Rossrodr@integeo.com

Wendy Victorinowendyv@integeo-sea.com

26 Nov 2009 @ Microsoft Brisbane Office,Integeo partner Bistech to present about Location Intelligence for SQL Server 2008Register: http://www.sqlserver.org.au/Events/ViewEvent.aspx?EventId=433

Cameron Shortercameron.shorter@lisasoft.comhttp://cameronshorter.blogspot.com/

Next webinars: * 3 Dec 2009, 1-2 PM SGT, Integrating BI with Google Maps* 10 Dec 2009, 4-5 PM US East Coast, Delivering Spatial Analysis to your Users Desktops

using ogc standards to link bi and spatial

spatial data

data pivots

attribute data

types of data

spatial use of ogc standards

open standards

spatial patterns

spatial environment

Technology

crmgeo: integration of cidoc crm with ogc standards to model...

sos4r @ ogc tc

spatial data studio -...

geo-spatial standards and transports: ogc and inspire

spatial databases', in wiley encyclopedia of computer...

ogc geosparql : standardizing spatial query on the semantic...

semantic enablement for spatial data...

improving the quality of spatial web services with ... ·...

overview of osgeo + ogc + neo4j spatial + geoserver

ogc guidance on_framework_agreements_sept_08

geospatial standards & interoperability dubai municipality...

oracle bi and geo-spatial big data · oracle business...

the location imperative: integrating spatial analysis with...

ogc water/hydro related activities · ogc water/hydro...

spectrum spatial bi location intelligence

crmgeo : integration of cidoc crm with ogc standards to...

ogc buying.solutions

® ogc extensions to traditional spatial data...

ogc water/hydro related activities - oieau · ogc...

location-based risk management with oracle spatial · bi...