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