Data visualisation with TIBCO Spotfire

1
Data visualisation with TIBCO Spotfire
2
Spotfire
Data visualisation and analysis software

• Loading data from a range of sources (databases,
  web services, linked data, files)
• Analysis (manipulation, filtering, statistics)
• Visualisation (graphs/charts, maps, tables)
• Data/image export
• Quick and easy visualisation and analysis of
  large datasets

http//spotfire.tibco.com/
3
(No Transcript)
4
(No Transcript)
5
Published tools

• Bathing Waters
• Climate Projections
• Climate Trends
• Climate Trends Handbook
• Native Woodland Survey of Scotland (NWSS)

• Household Waste
• Waste From All Sources
• Water Body Classification
• Groundwater

6
Published tools

• Bathing Waters
• Climate Projections
• Climate Trends
• Climate Trends Handbook
• Native Woodland Survey of Scotland (NWSS)

• Household Waste
• Waste From All Sources
• Water Body Classification
• Groundwater

7
Water body classification

• Surface water classifications (SEPA)
• Most recent classification (2013)
• Historical classifications
• Change between years

8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
Household waste

• Waste generated, recycled, diverted from landfill
  (other than recycling) and landfilled by local
  authority
• Detailed waste types at local authority and
  national levels (e.g., Chemical wastes, Discarded
  vehicles, Glass wastes)
• Trends in waste generation, recycling and
  landfill since 2004

20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
Climate Trends

• Analysis of
• One or more climate variables 26 variables in
  total
• One or more locations National, Met Office
  regions, river basins, local authorities,
  postcode districts, 5km grid squares (maps only)
• One or more averaging periods annual averages
  for all variables seasonal and monthly averages
  for 16 variables
• Dynamically calculates
• Running means
• Trends
• Summary statistics

24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
Climate Trends Handbook

• Analysis of
• 20 climate variables
• National, Met Office regions, 5 km grid squares
  (trend maps only)
• Annual and seasonal averages
• Dynamically calculates
• Running means
• Trends
• Summary statistics

30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
Summary

• Variety of Spotfire tools published
• Wide range of data from different sources
• Tools tailored for specific audiences
• Allows public to access, visualise and
  interrogate data
• Easy data analysis (e.g., statistics)
• Can make data available for download (helps with
  FOI requests)

34
What went well?

• Data verification
• Engagement with partners
• Encouraging data sharing
• People see the potential of Spotfire and are
  enthusiastic
• Replaced some existing methods of data
  publication (e.g., static reports)
• Media attention raises the profile of SEWeb,
  partners and Scotlands environment

35
and what didnt?

• Combining datasets is limited we could do more!
• Spotfire is not a mapping tool so spatial
  analysis capabilities are limited
• Data sourcing has been challenging (finding data
  in a suitable state and format for use in
  Spotfire)
• Lack of resource to produce dynamic data feeds
• Lack of time/resource to provide feedback on
  Spotfire work
• Legalities/data ownership

36
In development

• Wetlands Inventory
• Soils and Land Capability
• Scottish Pollutant Release Inventory (SPRI)
• Water Quality
• Monitoring Sites

• Air/Education package
• Marine Finfish Farms
• Food Standards Agency Shellfish Monitoring
• National Forest Inventory
• National Forest Estate
• Site Condition Monitoring

37
Proposed

• Nitrate Vulnerable Zones
• Invasive Non-Native Species
• Environmental Indicators
• Marine Scotland Fisheries Statistics
• Always on the lookout for new ideas!

38
Scotlands Environment Webwww.environment.scotlan
d.gov.uk Take a look at the website, let us
know what you think, share new ideas

• seweb.administrator_at_sepa.org.uk
• contact us on the website