city of ottawa success stories using fme
DESCRIPTION
TRANSCRIPT
Testing, Testing... One Two Three
© 2001-2013 City of Ottawa
Success StoriesEric StorieGIS Analyst, City of Ottawa
9-April-2013
© 2001-2013 City of Ottawa
We know better now.
© 2001-2013 City of Ottawa
First Space walk Alexey Leonov 18-Mar-1965
© 2001-2013 City of Ottawa
First presentation at an FME Users Meeting Eric Storie 09-Apr-2012
We now know Ottawa is Big! Really Big!
© 2001-2013 City of Ottawa
© 2001-2013 City of Ottawa
Providing Management and Services Transit Services Roads and Infrastructure Permits Garbage and Recycling Recreation Social Services Libraries Economic Development
© 2001-2013 of Ottawa
Public Health By-Law Community and Social Services Emergency and Protective Services Environmental Services Human Resources Information Technology Services Parks, Recreation and Cultural Services
© 2001-2013 City of Ottawa
Providing Management and Services
Public Works Planning and Growth Management Rail Implementation Office Real Estate Partnerships and Development Office ServiceOttawa
Plus much more…
© 2001-2013 City of Ottawa
Providing Management and Services
© 2001-2013 City of Ottawa
Providing Management and Services
Public Responsibility Leverage and capitalize on existing investments.
Continuous improvement to reduce risk of disruptions.
Provide services and capabilities where the workers are.
Provide access to information in a secure manner.
Enabling cost-effective evolution of services and infrastructure and connectivity.
Use strategic sourcing to reduce labour and support costs.
Emphasize data integration and sharing containing costs.
Greater use of electronic information to reduce costs and reduce the City's dependency on natural resources.
© 2001-2013 City of Ottawa
Enterprise GIS System
Municipal Applications Partnership – MAP
MAP is a graphical interface to several database oriented applications.
MAP associates business processes to municipal address, and can produce both reports and maps.
© 2001-2013 City of Ottawa
Enterprise GIS System
The Enterprise GIS solution ‘MAP’ is utilized daily by over 3,000 users.
The ‘eMAP’ component is consistently within the top five to ten areas accessed by the public and building sectors via Ottawa.ca.
This Enterprise GIS architecture is at ‘end of life’ and will be replaced with ESRI GIS technology and a number of business focused applications.
© 2001-2013 City of Ottawa
WOW! Management and Service, Public Responsibility, and what
must be really big Enterprise GIS.
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
© 2001-2013 City of Ottawa
Multiple Data Sources and Application Software
http://www.safe.com/solutions/for-initiatives/esri-community-maps-program/
© 2001-2013 City of Ottawa
Service Ottawa
© 2001-2013 City of Ottawa
© Lucas film Ltd. (LFL); 14 August1981;PA112321
Service Ottawa
© 2001-2013 City of Ottawa
Service Ottawa
The Service Ottawa Program is a citizen-focused approach to transforming how the City engages, interacts with, and provides services and information to citizens, businesses and clients. The program will standardize and consolidate current service management processes, providing citizens with streamlined services that are easy to find and access via multiple service-delivery channels such as ottawa.ca, 3-1-1, in-person and on mobile devices.
Two key pillars of the Service Ottawa agenda, Enhanced Citizen Centric Services and Mobile Workforce, are depending on current day, vendor supported Enterprise GIS technology as a foundation for success. This investment is key to its success.
© 2001-2013 City of Ottawa
Enterprise GIS System
Replication
Delete/Replace
FME and custom ETL
EDIT SDE Geodatabase VIEW SDE
Geodatabase
Local Government
FME and custom ETL
MAP
ArcGIS and FME Data
Editors(Custodians)
Map and Locator Services
FME and custom
ETL
© 2001-2013 City of Ottawa
Amazing!
Building on Success
© 2001-2013 City of Ottawa
Building on Success
© 2001-2013 City of Ottawa
Building on Success
© 2001-2013 City of Ottawa
Sharing and Transforming Data Across the Enterprise
© 2001-2013 City of Ottawa
Wins with FME
Several significant projects and ongoing day-to-day operations over the past few years have benefited by using FME technology
© 2001-2013 City of Ottawa
© 2013 Ontario Lottery Corp.
Wins with FME Salt Truck Project – Monitor salt distribution across the City using GPS
tracking helped to significantly lower salt usage, and increase road safety.
© 2001-2013 City of Ottawa
Wins with FME Salt Truck Project – Using FME we created variable buffers around existing
road segment data.
© 2001-2013 City of Ottawa
Wins with FME Salt Truck Project – Overlay GPS data points containing information on
salting, speed, and direction of travel.
© 2001-2013 City of Ottawa
Wins with FME Salt Truck Project – Created Raw GPS route based on GPS data and used
buffers as a cookie cutter to extract information.
© 2001-2013 City of Ottawa
Wins with FME Salt Truck Project – Created generalized GPS route based on GPS data,
showing actual road segments covered by truck.
© 2001-2013 City of Ottawa
Wins with FME Salt Truck Project – Used same buffers as a cookie cutter to extract
information on generalized route with Road network information.
© 2001-2013 City of Ottawa
Wins with FME Salt Truck Project – Web Access of data processed with FME
© 2001-2013 City of Ottawa
© 2001-2013 City of Ottawa
Wins with FME Water Pressure Zones
© 2001-2013 City of Ottawa
Wins with FME EAM [Enterprise Asset Management] – Maximo will replace a legacy
application which was the primary application used for the maintenance and management of linear assets, primarily water and waste water inventories.
© 2001-2013 City of Ottawa
Wins with FME
EAM [Enterprise Asset Management] – Using FME synchronize Edit and Publish ESRI SDE geodatabases and the MAXIMO asset management system
Maximo Manages asset deployment, specifications, monitoring, calibration, costing and tracking from a single system
Provides enterprise asset management software for long and short-term planning, preventive, reactive and condition-based maintenance, schedule management, resource optimization and key performance indicators
Plans inventory to meet maintenance demand, making the right parts available at the right location when needed
Aligns service levels with business objectives by defining service offerings and establishing service level agreements (SLAs)
© 2001-2013 City of Ottawa
Wins with FME
© 2001-2013 City of Ottawa
Edit databaseEdit database Publish databasePublish
database
Obsolete databaseObsolete database
Detect ChangesDetect
Changes
Maximo rules
Maximo rules
FME reads data
FME reads data
Read the
rules
Read the
rules
Test
Test
UpdateUpdate
Update Update
© 2001-2013 City of Ottawa
Amazing
Wins with FME
Data Maintenance - Restoration of legacy data stored in legacy formats from past projects into new more accessible data formats.
© 2001-2013 City of Ottawa
Wins with FME
Data Transformation and Migration – 30 to 40 data sets per year are translated from ESRI data formats into AutoDesk VISION* gina file format. This allows us to refresh and maintain legacy systems, such as MAP, with current data.
© 2001-2013 City of Ottawa
Wins with FME
Day to day quality checking of data sets before data is loaded into a the enterprise production environment.
© 2001-2013 City of Ottawa
Wins with FME
Testing Microstation Drawing files to make sure they meet the required CADD standards before they are accepted from external sources.
© 2001-2013 City of Ottawa
Wins with FME
Checking Teranet data provided by the Province of Ontario to find if and where property parcels overlap, and reporting those findings to the Province.
© 2001-2013 City of Ottawa
Future Plans
Replacement of eMap in ottawa.ca
© 2001-2013 City of Ottawa
Automate Open Data updates
More maps and apps for the Local Government model
Mobile geoOttawa
FME Server
Future Plans
Upgrade
© 2001-2013 City of Ottawa
Future Plans Exploring possibilities.
© 2001-2013 City of Ottawa