Enterprise Geospatial Database and Geospatial Technologies for the Commonwealth of PA

1
Enterprise Geospatial Database and Geospatial
Technologies for the Commonwealth of PA

• Jim Knudson
• PA Geospatial Technologies Director
• Office for Information Technology
• Governors Office of Administration

2
PA Enterprise Geospatial Database and Geospatial
Technologies

• Background
• Geospatial Enterprise Architecture
• Geospatial Enterprise Database Repository
• Enterprise Data Assets
• Service Oriented Architecture
• Data Services
• Application Components

3
PA Agency As-Is Geospatial Environment

• Agencies dont share data
• Those that do use CDs, DVDs, FTP sites, takes
  days, weeks, or months to get data updates
• Agencies store other agency data layers, cant
  access natively where the data lives, data from
  other agencies becomes stale
• Multiple agencies keep adding servers, databases
  and storage to keep up with enterprise data
  updates

4
PA Agency As-Is Geospatial Environment

• Keep building the same basic capabilities in each
  application, very little code reuse
• DHS new motto is Need to share, as opposed to
  Need to know
• Geospatial interoperability is key, but not easy
• Data standards dont exist
• NEW Geospatial Technologies Director/Bureau
  created in Office of Administration/Office for
  Information Technology in 10/2003

5
Why was a change necessary?

• Pennsylvania needs 'one-stop shopping' for all
  state agency and enterprise geospatial data
  assets that need to be shared. Need a single,
  enterprise data repository and also a catalog of
  geospatial data.
• A Service Oriented Architecture/Shared Services
  model is needed to serve data and applications
  to government and first responder organizations
  within the state.
• Data interoperability is a fundamental priority.
• An enterprise application hosting/server
  consolidation strategy is needed to assist
  agencies with web-based spatial application
  deployments for e-Government.

6
Where Do You Begin?

• SIMPLE Inventory, organize and cleanse your
  geospatial data assets and create metadata. Data
  is still the 1 cost
• Identify duplications and overlap in data
  maintenance and assign data primacy/data
  stewardship responsibilities
• Assess data quality and improve where possible
• Make certain data is discoverable, accessible,
  and shared
• Governance, marketing, awareness campaigns,
  demonstrations, visioning, strategic planning

7
Where Do You Begin?

• Develop Enterprise Architecture standards
• Consolidate servers and databases to reduce
  operating costs
• Develop standards and best practices
• Develop enterprise services and applications
• Train your staff IT and GIS
• Align GIS/GT and IT/EA to leverage resources
• Facilitate collaboration and cross training
• Identify an agency champion

8
PA Geospatial Server Architecture
9
PA Geospatial Server Architecture

• 24 Agencies in State Government using GIS
• 18 agencies creating geospatial data
• Only place for agencies to share data was Public
  GIS Clearinghouse (PASDA) at PSU
• Data stored on each agencys data server,
  frequently stale (6 months 3 years old)

10
PA Geospatial Server Architecture

• BGT used PA State Homeland Security Grant Program
  funding to build server architecture
• GT Development Lab, Staging Environment,
  Production Environment
• Built as a fault-tolerant, high-availability
  enterprise GIS server farm/data center
• Oracle enterprise database, ESRI enterprise
  server software, Internet and intranet zones
• Citrix server for desktop GIS software access

11
PA Geospatial Server Architecture

• ArcGIS Server being added to allow for robust,
  geoprocessing web based applications
• ArcIMS Route Server being added for enterprise
  routing/driving directions capability
• Portal Toolkit (GOS) being added to provide
  metadata catalog, search capability for data sets
  and web services
• Building essential services for mapping,
  address geocoding, spatial searches, routing

12
PA Geospatial Server Architecture

• Two primary components
• Enterprise geospatial data repository
• Enterprise data assets (PAMAP imagery, elevation,
  census demographics, soils, etc.)
• Agency data that needs to be shared
• Application hosting environment
• Implements a server consolidation strategy
• BGT enterprise applications
• Enterprise web services
• Other agency applications

13
PA Geospatial Server Architecture
Application Hosting Web Environment
Enterprise Geospatial Data Repository
Capable of drawing 1.8M maps/day?
14
PA Geospatial Enterprise Database Repository
15
PA Geospatial Enterprise Database

• GIS/GT only as good as the data that drives it
• Data is still the largest cost of enterprise GIS
• GIS/GT technologies allow for disparate legacy
  data integration using location as the common key
• Too many data silos where data is not shared
• Agencies storing other agency data, but it
  becomes stale quickly

16
PA Geospatial Enterprise Database

• ESRI ArcSDE/Oracle and Oracle Spatial for data
  storage, access, query, and manipulation (15TB
  IBM SAN)
• Agencies being charged as data stewards to
  maintain and publish their data to the
  GEA/enterprise Oracle database
• Metadata and key words are required along with
  the geospatial data assets
• High level data security allows agencies to
  manage their data directly and control access
  rights
• Data segregated into public, agency only, and
  secure areas, using Oracle and ArcSDE security
  and role-based access privileges/control

17
Enterprise Data Priority 1 Statewide Imagery
18
Why is Imagery Important?

• Provides primary source for keeping intelligent
  vector GIS data sets updated
• Provides context for real world not provided by
  the intelligent vector data layers that are
  modeled
• Situational awareness and government
  decision-making requires knowledge of the
  real-world
• What does it look like?
• What are the geographical relationships?
• How close is it to ?

19
PA Flooding - 1 All Hazard
http//gis1.pasda.psu.edu/website/ivan
20
PA Geospatial Service Oriented Architecture
21
XML Web Services for Data Sharing

• Basic Questions to Ask
• Is customer base heterogeneous or homogeneous?
  All using ESRI or a combination of GIS software?
• Are any applications or users mission critical?
• Is any data sensitive or are there privacy
  issues?
• If heterogeneous, use Open Geospatial Consortium
  (OGC) web services
• If mission critical, use High Availability server
  architecture design
• If data is sensitive or there are privacy issues,
  build role based security model into databases
  and applications
• Stream data through the network or Internet,
  clients dont have to have large servers and
  databases, data is stored once in central
  location, data doesnt become stale

22
BGT Shared Services/SOA Model (ITEP)
23
http//www.gis.state.pa.us
24
Questions?