GIS as Part of Mainstream Enterprise IT Infrastructure and Management

1
GIS as Part of Mainstream Enterprise IT
Infrastructure and Management
Eric Bayer Territory Manager Intergraph Mapping
and Geospatial Solutions
2
Is Spatial Data a Real Part of Your Enterprise?
3
Topics

• History
• Technology Trends
• Enterprise Management
• E-Government and Citizen Relationship Management
• Critical Infrastructure Assurance
• Demo

4
History
5
History

• GIS a new concept?
• In the mid-19th Century an Atlas for the Irish
  Railway Commissioners showed population, traffic
  flow, geology and topography superimposed on the
  same base map
• Dr. John Snow used a map showing the locations of
  death by cholera in central London in September,
  1854 to track the source of the outbreak to a
  contaminated well

6
Major Factors that changed GIS History

• Computer technology - improvements in hardware,
  esp. graphics
• Development of theories of spatial processes in
  economic and social geography, anthropology,
  regional science
• Increasing social awareness, education levels and
  mobility, awareness of environmental problems
• Database Technology
• Bottom line is that 80 of the data used by
  government is SPATIAL!

7
Mapping/GIS User Types
Asset Modeling
Asset Modeling
Data Creation/Maintenance
OR
10s
Asset Management
Doers
Decision Support
Savings and benefits increase
100s
Users
Analysis
Information Retrieval
1000s
Distribution
Viewers
8
Technology Trends
9
Technology Trends in Spatial

• Enterprise Spatial Data Bases
• Enterprise Application Integration
• Web Access and Web Services
• Open access OGC/GML
• Mobile Computing

10
The Reality of Geospatial Data Today

• Many formats, different data models
• Several databases, tiles, files
• Distributed

11
An Organization and its Data
Customers
Planning
Policy
GIS Specialists
Operations
12
The Problem GIS and IT Separation

• Specialty servers for different kinds of data
• Many different, incompatible proprietary data
  formats
• Data isolation
• Scalability problems

13
The Past Integrating File Based GIS

• Hybrid Architecture (Graphics and database)
  Results in Cumbersome data management
  methodologies
• Access
• Duplication
• Replication
• Ownership
• Security
• Example

14
The Vision Enterprise Databases for Spatial
Custom View of Data
Policy Planning Operations Customers GIS
Specialists
Enterprise spatial data Enterprise Non-spatial
data
15
Why? Spatial data in the database

• Scaleable architecture
• To fit the needs of all users
• Spatial data neutrality
• Application integration
• An architecture that is responsive to technical
  change extensible and flexible
• Enterprise integration
• Spatial data is just another data type that
  should be stored in a database
• Protection of customer investment
• The time and effort was put forth in creating
  data (Data will outlive any application)

16
Industry Standard Databases for Spatial No
longer an Experiment or Rarity
Enterprise Database
All Geographic Data Stored in RDBMS
Spatial Indexes
GeoSpatial is just another data type
17
Spatial Data Types

• Points
• Line Strings
• Polygons
• Polygons with holes
• Circles
• Arcs, arc strings
• Rectangles
• Compound elements

18
RDB Spatial Capabilities
Spatial Data
Spatial Access Through SQL
Select a.building_id from facility a, facility
b where sdo_within_distance( a.geom, b.geom
distance 10 unit mile) TRUE
19
How Spatial Data Is Stored
Data type
Geographic coordinates
20
Spatial Query Via SQL
Find all building within 500 meters of building
902
SQLgt SELECT a.building_id 2gt FROM
base_buildings a, 3gt base_buildings b
4gt WHERE b.building_id 902 5gt AND
MDSYS.SDO_WITHIN_DISTANCE( 6gt
a.Location, b.Location, 7gt
distance500) TRUE
21
The Result

• Multi-users, Multi-Departments utilize same data
  access methods
• Select, insert, update, delete
• Data Currency
• Universal Adherence to Spatial Business Rules
• Single features and utilities for IT Management
• Replication, Distribution, Security, Backup
• Improved Data Synchronization and Maintenance

22
GeoInformation - Adding Value to Business
Information
Information system
Political data
Health data
Sales data
Weather data
Legal data
Demo graphic data
Financial data
Training data
Personnel data
Customer data
23
Enterprise Application Integration
IT/GIS
Planning
Public Works
Buildings
Parks Rec
Environmental Services
Enterprise Database
Economic Development
Property Appraiser
Utilities
Police
Finance
Emergency Services
24
Web Access and Web Services

• Web access to spatial information has
  revolutionized the way people and organizations
  interact with spatial data
• It is now as easy as reading a paper map to
  leverage spatial data
• Web Services will become the defacto method of
  integrating spatial processing into web
  applications.

25
Interoperability

• Data interoperability
• Application interoperability
• critical to information sharing and
  collaboration

26
Interoperability in ActionHomeland Security
27
Mobile Computing

• Empowering the mobile workforce
• With job schedule and locations
• All other related information
• Knowledge of where resources are
• Situated
• Required
• Assessment of the situation
• Monitoring/analysis of incoming tasks
• Assessment of requirements and priority
• Assignment
• Resource allocation depending on skills and
  location

28
Enterprise Management
29
Enterprise ManagementLand Information - City of
Edmonton

• Needs
• Replace 85 applications into one branch to
  reduce data redundancy

• The Solution
• A system for immediate access to shared
  land-based data through a central data pool
• Available to 1000 employees and 900,000 citizens

30
Enterprise ManagementSan Mateo County, California

• Needs
• Eliminate data redundancy
• Support sharing of data by natural relationships
  rather than by application use

• The Solution
• County business processes streamlined because of
  seamless access to data
• Web-based applications provide mission critical
  spatial data to all users

31
Enterprise ManagementCity of Hamilton, Ontario
On January 1, 2001, 6 cities were amalgamated
and became the new City of Hamilton. Each
community within Hamilton is unique and rich in
history.
Need To merge different technologies and unify
workflows that would serve this new community of
over 500,000 citizens.
Winner of URISA-Ontario Gold Medal in Map Gallery
Contest
The Solution Implemented an enterprise geospatial
solution that preserved their disparate data
investment
Winner of URISA-Ontario Silver Medal for Best
Municipal GIS Web site
32
E-Government and Citizen Relationship Management
33
E-Government and Citizen Relationship Management
Megans Law - City of Milpitas

• Need
• Protect citizens by showing where sex offenders
  reside

• Solution
• Provide citizens with the general locations of
  registered sex offenders within the city
• Empowers citizens with available data and assists
  them in making informed decisions regarding
  personal and family safety

34
E-Government and Citizen Relationship Management
Nevada DOT

• Need
• Increase information to bus riders
• bus stops, routes, fares, and schedules.

Solution Single external web portal includes all
bus rider information and intuitive maps of the
routes.
35
E-Government and Citizen Relationship Management
South Carolina DOT

• Needs
• Improve evacuation routing of traffic to avoid
  disasters

• Solution
• Improved mobility by 48
• Maximum volume increased to 2082 vehicles per
  hour

36
E-Government and Citizen Relationship Management
Hong Kong

• Need
• A way to efficiently provide slope safety
  information to public

Solution A comprehensive web based solution for
public as well as cross-department usage
37
E-Government and Citizen Relationship Management
City of Winnipeg Online Assessment

• Need
• Integrate assessment, zoning, parcel and
  municipal services information

• Solution
• Maintains the citys registered parcel database,
  record changes to property addresses as buildings
  are built and manages changes to the assessment

38
Critical Infrastructure Assurance
39
Critical Infrastructure Assurance Oklahoma DOT -
I-40 Bridge Collapse

• Needs
• 20,000 cars cross bridge/day
• Had to find quick way to re-route
• Recovery from I-40 Bridge Collapse

• Solution
• System immediately found best route to detour
  traffic
• Rebuilt for traffic flow in two months
• Presidential award for Transportation Technology
  Innovations

40
Critical Infrastructure Assurance Puerto Rico
Electric Power Authority (PREPA)

• Need
• Improve response time for 1.4 million Electric
  Customers as the sole service provider in Puerto
  Rico

• Solution
• Fully Automated Design Processes
• Completely electronic, no paper!

"I wish we had done this 10 years ago. I spent
years working on paper. Reports that took three
days to prepare now take 10 seconds. Fernando
Lopez, project coordinator in Mayaguez
41
Critical Infrastructure Assurance Los Angeles
Department of Water Power

• The Largest Municipal Owned Utility in the nation
  covering 465 square miles and supplying 3.7
  million people.

• Need
• Ability to easily share geospatial information
  with city agencies.

• Solution
• Web portal enables data interoperability and
  exchange, and provides low-cost, easy data access
  to various personnel.

42
Critical Infrastructure Assurance Water
Wastewater City of Winnipeg

• Needs
• Management of 2800 km water distribution pipe
  feeder networks
• 500 field people
• Serving 700,000 population
• Efficient response to incidents, field
  maintenance
• Need to manage assets

• Solution
• Provides enterprise web portal that includes
  complete public works information

43
Critical Infrastructure AssuranceTennessee DOT
Need Manage all road assets across the state
Solution A system providing over 400 users access
to current road asset information
44
Critical Infrastructure Assurance U.S. Army
Military Traffic Management Command- MTMC

• Need
• Global surface distribution management and
  services to meet National Security objectives in
  peace and war.

Solution A geospatial system that tracks the
movement and location of sensitive freight across
the nation
45
Critical Infrastructure Assurance Canadian
Department of National Defense (DND)
Base Infrastructure Management Program The
Canadian Forces are present in every province and
territory and in more than 3,000 communities
across Canada.

• Need
• Integrated IT functions to service the country

Solution Canadian Forces Base (CFB) Esquimault
Provide solution for Base Construction
Engineering and Base Information Services Office
for Infrastructure Management in the field.
Permitting all levels of personnel access to
this data via a simple geospatial viewer
46
Critical Infrastructure Assurance South African
National Road Agency

• Need
• Pavement Management, Traffic Information, Toll
  Management, Bridge Management

Solution An Integrated Geospatial Transport
Information System
47
Critical Infrastructure AssuranceProgress
Energy, Florida

• Need
• Electric Utility Service Provider with over 1.2
  million customers needed highly improved service
  to customers, reduction in service interruptions

• Solution
• Complete Geospatial Resource Management
  environment AM/FM/GIS, OMS, Mobile, Dispatch,
  Integration to WM
• 35 reduction in customer complaints
• 25 reduction in service interruptions
• Reliability record of 99.98
• Increased revenue through efficient service
  restoration
• Project pay-back in less than 3 years

48
Is Spatial Data a Real Part of your Enterprise?
49
What This Means - Stop Isolating GIS !
GeoSpatial Sphere of Influence
50
Vision For Mainstream IT

Geospatial
From Island To Corporate Information System
51
The Value Proposition

• Better data Better decisions Better business
• Open More Choices, Better Choices
• Solutions Productivity
• Enterprise Return on Investment
• Sharing data 1 Sharing costs and investments
• Sharing data 2 Making information available

52
Some Fundamental Beliefs

• Data is our users most valuable asset and must
  be preserved
• Data and application interoperability must exist
  for this industry to reach its true potential
• The only thing standing between the user and
  his/her data should be an SQL statement
• GIS is an enabling technology, not an end in
  itself
• This community must stop being GIS-centric, and
  extend itself to become application and
  enterprise centric
• To really maximize your ROI and benefits,
  integrate geospatial into your information
  infrastructure, dont isolate into GIS islands of
  automation

53
The Real Benefits Return on Investment of
Spatial Technology
exponential
Benefit/Cost Ratio
Automated Mapping Intelligent
Mapping/GIS Enterprise Access
Business Operations
Application of Spatial Technology
54
To Do list for SUCCESS!!!

• Understand the issues and challenges
• Facilitate the establishment of vision, goals and
  objectives ...build alignment
• Identify the bottom line benefits to be realized
• Maintain a process and data centric focus
• Integrate best of class methodologies, partners,
  products, and solutions to meet the goals

55
Is Spatial Data a Real Part of Your Enterprise?