Fri G04 1100 Meehan - OSGeo Download Server

musicincurableΔιαχείριση Δεδομένων

31 Ιαν 2013 (πριν από 4 χρόνια και 7 μήνες)

131 εμφανίσεις

Copyright 2006 © INTEGEO All Right Reserved

Using OGC Standards to link Business Intelligence
and Spatial Analysis

Andy Meehan


CTO Integeo

andym@integeo.com

2

Copyright 2006 © INTEGEO All Right Reserved

Synopsis


This presentation will explore the use of OGC
standards to provide a generic connection
framework between reporting tools and geospatial
systems.

We will examine Open Source products can be used or
interchanged with commercial ones

We will also look at the types of data that are
combined to support better program management,
gap analysis and demographic analysis


3

Copyright 2006 © INTEGEO All Right Reserved

Sample Fisheries Analysis


4

Copyright 2006 © INTEGEO All Right Reserved

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.

5

Copyright 2006 © INTEGEO All Right Reserved

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.

6

Copyright 2006 © INTEGEO All Right Reserved

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.

7

Copyright 2006 © INTEGEO All Right Reserved

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.

8

Copyright 2006 © INTEGEO All Right Reserved

Integrated LI/BI

9

Copyright 2006 © INTEGEO All Right Reserved

Integrated LI/BI

10

Copyright 2006 © INTEGEO All Right Reserved

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


Example Map Data Sources

(AU)

PSMA,

GeoScience (Map Connect), Open Street Maps, ABS / Census, Google /
Bing etc, WMS


Reference data


ABS Data


Data from other agencies e.g. Centrelink

11

Copyright 2006 © INTEGEO All Right Reserved

Data Flow


Business

Data


Reference

Data


Business
Intelligence
Platform


Spatial Integration
Platform


OGC Compliant
GIS Server

KML

Map Layers

Report

Output

Map

Output

Report

Queries

OGC

Requests

12

Copyright 2006 © INTEGEO All Right Reserved

An Integration Platform

COGNOS

Oracle

Hyperion

Business

Objects

Reporting

Services

Micro

Strategy

Excel

Spatial Integration Server

Business Intelligence
Platforms

Open Geospatial Consortium

WMS, WFS, SLD, WMC, GML, OpenLS

OGC

Compliant

server

Other

BI Tools

Business Data




GIS Base
Maps

Reference Data




Reference
Data

BIRT

13

Copyright 2006 © INTEGEO All Right Reserved

PostgreSQL

PostGIS

Open Source Parts


Business

Data


Reference

Data


BIRT

Tomcat




Map Intelligence

Tomcat

(MI Commercial)


Geoserver

Jetty

KML

Map Layers

Report

Output

Map

Output

Report

Queries

OGC

Requests

14

Copyright 2006 © INTEGEO All Right Reserved

In BIRT

15

Copyright 2006 © INTEGEO All Right Reserved

The base map is made up of layers

Land Mass

Parks

Streets

16

Copyright 2006 © INTEGEO All Right Reserved

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 metadata

2.
returns a map with well
-
defined geographic and dimensional parameters

3.
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.


17

Copyright 2006 © INTEGEO All Right Reserved

A WMS Image is made up of layers

Land Mass

Parks

Streets

18

Copyright 2006 © INTEGEO All Right Reserved

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.

19

Copyright 2006 © INTEGEO All Right Reserved

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">




20

Copyright 2006 © INTEGEO All Right Reserved

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.



21

Copyright 2006 © INTEGEO All Right Reserved



SLD can take you from this…

… to this

22

Copyright 2006 © INTEGEO All Right Reserved

Or from these…


to this.


23

Copyright 2006 © INTEGEO All Right Reserved

Or a style like this

24

Copyright 2006 © INTEGEO All Right Reserved

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.


25

Copyright 2006 © INTEGEO All Right Reserved

Spatial Display of Business Data


Point Data


Display Colour coded symbols or images


Requires a coordinate in the business data


OR



An address that is geocoded


Region Based Data


Requires a common name or ID between the base map
layer and the business data


OR



Point data from which regions may be inferred


Visualisations are built on these


26

Copyright 2006 © INTEGEO All Right Reserved

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

27

Copyright 2006 © INTEGEO All Right Reserved

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


28

Copyright 2006 © INTEGEO All Right Reserved

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

29

Copyright 2006 © INTEGEO All Right Reserved

Sample Fisheries Analysis
-

Cognos


30

Copyright 2006 © INTEGEO All Right Reserved

Sample Fisheries Analysis


Google

31

Copyright 2006 © INTEGEO All Right Reserved

Sample Crime Analysis
-

BO

32

Copyright 2006 © INTEGEO All Right Reserved

Sample Health Analysis
-

Cognos

33

Copyright 2006 © INTEGEO All Right Reserved

Sample Health Analysis
-

Cognos

34

Copyright 2006 © INTEGEO All Right Reserved

Copyright © 2006 Integeo All rights reserved.

Sample Incident Analysis
-

Hyperion

35

Copyright 2006 © INTEGEO All Right Reserved

Copyright © 2006 Integeo All rights reserved.

Smple Incident Analysis
-

Hyperion

36

Copyright 2006 © INTEGEO All Right Reserved

Sample Program Management
-

Hyperion

37

Copyright 2006 © INTEGEO All Right Reserved

Town Planning


Google Earth

38

Copyright 2006 © INTEGEO All Right Reserved


Game Machine Analysis
-

Cognos

39

Copyright 2006 © INTEGEO All Right Reserved

Sample Signal Analysis

40

Copyright 2006 © INTEGEO All Right Reserved

Copyright © 2006 Integeo All rights reserved.

Demographic Analysis
-

Excel

Copyright 2006 © INTEGEO All Right Reserved

Questions?

Andy Meehan

andym@integeo.com

42

Copyright 2006 © INTEGEO All Right Reserved

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

43

Copyright 2006 © INTEGEO All Right Reserved

My Time Site Selection


Proposed sites are entered in an Excel Spreadsheet


Addresses automatically geocoded

44

Copyright 2006 © INTEGEO All Right Reserved

My Time Site Selection


An initial plot provides geographical context

45

Copyright 2006 © INTEGEO All Right Reserved

My Time Site Selection


Each site is bookmarked for easy navigation

46

Copyright 2006 © INTEGEO All Right Reserved

My Time Site Selection


5 and 10 KM lines give coverage indicators

47

Copyright 2006 © INTEGEO All Right Reserved

My Time Site Selection


Closer inspection of nearby MyTime locations


Locations stored on other Excel sheets

48

Copyright 2006 © INTEGEO All Right Reserved

My Time Site Selection


Add ‘competitive’ programs

49

Copyright 2006 © INTEGEO All Right Reserved

My Time Site Selection


Add relevant demographic data


Persons needing assistance aged 0 to 6 by SLA

50

Copyright 2006 © INTEGEO All Right Reserved

My Time Site Selection


View existing service provision by Electorate compared
to proposed additional services


Select site


Use links from

Electorates to

get member details

for selected sites


Inform the local

member


Copyright 2006 © INTEGEO All Right Reserved

Questions?

Andy Meehan

andym@integeo.com