Transcript Slide 1

FME: The Catalyst for a MultiParticipant Hazardous Spills
Database for Peel Region
Doug Seaborn
Project Lead: Enterprise GIS Development & Deployment
Region of Peel - SDSS
SDSS - Spills Decision Support System
 ~ 500 hazardous spills every year
 “Spills” can be:






Fuel, auto liquids
Industrial waste
Hazardous cargo
Biological hazards
Sewer overflows
Flooding
About Peel Region








Area: 1,250 sq km
Population: 1.3 million
Dwellings: 360,000
Known “haz mat” sites: 20,000
Buried Infrastructure: 85% of area
3 local governments
2 conservation agencies
Tiered service responsibilities
SDSS - User Community
 First Responders:
 Peel Region Environmental
Protection Unit
 Fire & Police
 Conservation
 System
 Region-wide database
 [60+ themes]
 Mobile field devices, web
enabled
 Oracle Spatial, 7 x 24
Spills Tracing
SDSS Functionality
 Support Inventory of known
hazmat sites and spills [1999
-2010] through ROP
 Record Observed Spills
 Predict upstream source [s]
for investigation
 Record & Predict downstream
flows and highest risk
outflows/consequences
 Subsurface hazmat flow
prediction [gravity - storm
and sanitary sewer]
 Field-usable, field accessible
[web, gps enabled notebooks]
Data Themes

Spills-Specific Themes




Licensed hazardous material sites, inspection records
Observed spills: 10 years
Fresh water supply [lakes, aquifers, pump stations, wells, permits]
Surface flow
 Rivers, creeks, ditches, culverts
 Surface Elevation & Permeability Model
 Catch Basins, Inlets, Outflows
 Sub-surface flow
 100,000+ underground pipes [storm and sanitary]

Reference Themes





Street Road Network with Address points
Property & Infrastructure
Aerial Imagery
Environmental & Recreational areas
High risk infrastructure [stations, schools hospitals airports,…]
Environmental Themes
 Source water
protection areas
 Aquifers & wells
 Dams, flow control
structures
 Flood zones
 Rivers, streams,
creeks
 Watershed and sewer
shed boundary models
 Conservation areas
 Environmentally
sensitive areas
The FME Challenge
 Geo data “contributors” 7
 Vector data: MicroStation,
GeoMedia, ESRI
 Raster data: MrSID, ECW
 Office [MS] data: 12,000
engineering drawings [pdf],
 Word, Excel, Access
 C3Q: Coverage, Currency,
Consistency, Quality !!
Some ETL Tasks
1.
2.
3.
4.
5.
Storm Sewer [CAD to Oracle Spatial ]
Water System [GeoMedia to Oracle ]
Sanitary Sewer [SQL Server to Oracle]
Storm Ponds [Word -> Oracle]
Spills and Licensed Sites [Access to Oracle]
Storm Sewer [CAD to Oracle
Spatial ]
 Scope
 City of Mississauga
 ~ 100,000 graphic objects in MicroStation
[1997]
 Connect and attribute pipes
 Connect and attribute inflow points [surface
elevations]
 Connect and attribute outflows [surface
elevations]
 Build network model [inflow <-> outflow]
 mostly done using FME
3 ETL Tasks
1. Storm Sewer [CAD to Oracle Spatial ]
Storm Sewer [CAD to Oracle
Spatial ]
Pipe Split and Join
Elevation Calculator
Storm Sewer: Polygon Builder
Timeline
 Timeline
 Database complete: Q3 2011
 Software complete: Q4 2011
 Go live: Q1 2012
Thank You!
 Questions?
 For more information




Doug Seaborn
Seaborn GeoSystems
[email protected]
www.linkedin.com/in/dougseaborn
 Angus GeoSolutions Inc. www.agsi.ca