eGIS: Spatially solving the stovepipe conundrum to provide efficiencies in the office and the field'

1
(No Transcript)
2

• eGIS Spatially solving the stovepipe conundrum
  to provide efficiencies in the office and the
  field.
• Presented by
• Jeff Gilmour

3
Agenda

• Who is BPA?
• Introduction
• eGIS project overview
• Applications overview
• Project challenges

4
Who is BPA?

• The Bonneville Power Administration is a federal
  agency under the U.S. Department of Energy
• BPA serves the Pacific Northwest through
  operating an extensive electricity transmission
  system and marketing wholesale electrical power
  at cost from federal dams, one non-federal
  nuclear plant and other nonfederal hydroelectric
  and wind energy generation facilities.
• Established in 1937
• Service area roughly 300,000 square miles
  (Oregon, Washington, Idaho, Western
  Montana/Wyoming, Northern California/Utah)
• Own and operate lt15,000 circuit miles of
  Transmission Line (90 are 115kV or higher)
• Own and operate 259 substation
• Roughly 2,800 Full-time employees

5
Who am I?

• Name Jeff Gilmour
• Occupation Title GS-0150 Geographer
• BPA Employment 2000 Present, currently in
  Transmission Services/geospatial services
  organization.

Real job Enterprise GIS Project Manager
6
What is eGIS?
eGIS WPSS TAS FCE SLIM eCommerce
TRANSMISSION SERVICES
7
What is eGIS?
Get Information When Where you need it
The old saying that Knowledge is Power
couldnt be more true for BPA today. It is
vitally important for success of our agency that
all employees have access to critical information
to successfully perform their work.
8
What is eGIS?

• Enterprise GIS focuses on presenting data related
  to the features/objects stored in the GIS and
  leveraging the GIS to identify features that
  share common geography i.e. spatial proximity
• Enterprise GIS focuses on two user types
• Desktop User (Office User)
• Simplifying access to standard information and
  reports through single environment
• Available on any desktop connected to BPA LAN
  (SOC compliant).
• GIS maps add context and help navigate to data of
  interest
• Mobile User (Field User)
• Navigation to facilities
• Delivering the most current data in disconnected
  environment.
• Collection of data in the field

Related Data is present throughout BPA
9
What is eGIS?
TLM App
(View/Edit)
BES
(PassPort)
Scheduled Work/ Equipment/Assets
Fiber Mgt System
LIS
All FiberData
(View)
(View)
GIS
OARS
VMTS
(Outage
T-View
Historical Information (Lines)
(Veg Mgt)
Anaylsis)
COMPASS
Display Proposed/
ARMS
(View)
(View)
Scheduled Outage
(Access
Rds)
Photos
Aerial
Photos
Drawings
Location (?)
One-Line
Project Wise
DTAS
Plan and Profile
Diagrams
(Drawings)
(Danger Trees)
Drawings
10
What is eGIS?
1
Application Development Mobile and Portal
Applications
1
Data Cleansing Cross-database analysis, foreign
key cleansing, reporting services development.
2
2
Data Capture Landbase development. Digitization
of features from paper sources into GIS.
3
3
Process Engineering Data management (Bentley/ESRI
integration), Mobile/Field mapping capabilities,
PDB project portals
4
4
As we move into the future access to information
will help us reduce risk, broaden analyses,
increase knowledge and improve our ability to get
our jobs done quicker, better and with less cost.
11
Why GIS?
Because, they all connect spatially!
12
What is the eGIS Project

• How did it come about?

• 2005 Grassroots effort developed a strategic
  plan for a SPatially Integrated Corporate
  Environment (SPICE) presented to VPs but not
  formalized

• Adhoc work continues, but visibility, funds and
  access to technology are issues.

• 2006 BPA hires KEMA for the Enterprise
  Process Improvement Project

• 2006/2007 KEMA and BPA partner to formalize
  the need to leverage GIS to present information
  to users more efficiently.

• 2007 BPA approves the Vision 2012 BPAs
  Enterprise Geographic Information System
  Strategic Roadmap

• 2007 BPA formalizes the business case and
  charters the eGIS project as an agency IT capital
  investment project.

13
Project Organization

• eGIS is a massive project with many components.
• To accomplish the mission, the project was broken
  into three main phases, with iterations within
  each phase.
• Phase 1. Infrastructure
• Pilot, with 4 software releases
• Phase 2. Build out
• Leverage infrastructure to support large user
  base
• Phase 3. The rest
• Technological advances, changing work
  environment, new business focus, residual
  requirements
• As of 1/28/09 We are in our final iteration of
  Phase 1. We have built out the web and mobile
  infrastructure to support numerous business
  processes at BPA through the provision of
  accessible data.
• The Phase 2 charter is in development

14
Project Methodolgy

• Stages
• Pilot
• Used to prove Enterprise GIS Technical Concepts
• Four Stages
• The Pilot and the Stages build on each other
• At the end of each Stage there will be a release
  to Production

• Sprints
• Within each stage are short sprints
• Sprints are managed using an Agile Methodology

15
Application Overview

• Two main applications eGIS mobile and eGIS
  portal
• eGIS portal is web based and available from any
  BPA PC on the BPA network
• eGIS Mobile is thick client install on
  mobile/hardened PCs
• Both applications share similar architecture with
  different mapping components
• Applications are combination of BPA custom
  development and COTS solutions
• BPA custom development supports the report in
  both mobile and web applications (single code
  base)

16
Application Architecture
eGIS LiveMap
ESRI SDE
ArcGIS Server Application
ArcGIS Web Service
GeoCortex Essentials/ ESRI ArcGIS Server/.iis
eGIS Portal
Internal/External (NOAA/GeoMac/BLM)
eGIS Library
GeoSpatial Web Service
Point2Point
C.NET/.iis/aspx webpages
eGIS Pages/ User Controls
Web Service
SQL 2005
Non SQL 2005
eGIS Mobile
ETL
SQL 2005 Merged Replication SQL Express For Mobile
eGIS Mobile LiveMap
ArcGIS .mxds
GoSyncExtractor/ ESRI Replication
GO!Sync Mapbook/ ESRI ArcEngine/Thick client
17
Geospatial Interoperability Maturity Model FEA
Geospatial Profile
eGIS Moving Geospatial Maturity in the Right
Direction
18
Just Some of the Benefits

• Easy access to information for end users

• Information transcends across organizations

• Enhanced communication through common frame
  of reference

• Spatial context adds value to data data
  links to maps and maps link to data

• Reduce dependency on legacy thick client
  applications (IT Overhead)

• Increases visibility to the need for data
  stewardship and data standards

• Leverage best available/real time web
  services from other government/third party
  organizations. (reduce BPA need to manage data
  it doesnt own)

• Share BPA data with other agencies in
  standard format (Other Utilities, BLM/Forest
  Service/County and State Govs)

• Interoperate with other Source of Record
  systems tying our infrastructure together
  (seamlessly redirect users to different systems)

• Open standards and application programming
  interface (API) so other systems can leverage our
  infrastructure and services rather then recreate

• Oh yeah, its mobile too (field access to
  data, common platform to collect data, GPS and
  maps in field)

19
App Demo

• eGIS Portal Camtasia presentation

20
Mobile Users

• Read-Only/Map Navigation
• Data Owner/Inspection
• Observer/Redline Collection

View Collect
View Collect
Redlines
R/O GIS data
Inspections
Redlines
Inspections
GIS data
21
Challenges

• Data reconciliation
• Data Stewardship, who owns this process?
• Change management
• Large user base with many different information
  resource requirements
• Technological advancement out paces project speed
• How to manage the new wizbang tools and still
  make progress
• Coordinating change with other projects
• Planned interfaces and backend changes with
  projects at different lifecycles stages
• Mobile deployment
• Training field workers by design they are at
  remote sites and work away from the office, how
  do you get them trained and support them
  long-term?

22
eGISCOTS Packages/Webservices

• ESRI ArcGIS Server/ArcEngine/SDE
• TC Technology GO!Sync Mapbook w/Redlines and
  Inspections
• Geocortex Geocortex Essentials
• Bentley - ProjectWise/Maps (XM release)
• WeatherBug Real-time Weather Services
  (WMS/KML/IMS)

23
Questions

• Contact Info
• Jeff Gilmour
• jbgilmour_at_bpa.gov
• 503-230-3425