proprietary and confidential page 1 state of north dakota - gis workshop march 2000
TRANSCRIPT
Proprietary and Confidential Page 1
State Of North Dakota - GIS State Of North Dakota - GIS WorkshopWorkshop
March 2000
Proprietary and Confidential Page 2
Project OverviewProject Overview
Convergent Group has been retained to:• Assess current GIS in the state• Develop a sensible statewide GIS strategy• Provide a strategy tied to business case• Provide a plan summary and budget estimates
Proprietary and Confidential Page 3
Project OverviewProject Overview
Goal is to present and fund statewide strategy for the coming
budget year
Proprietary and Confidential Page 4
Project GoalsProject Goals
• Develop an approach that will facilitate GIS for the state, other agencies and the public• Provide a statewide program with clear goals and budget• Develop a program that eliminates redundancy and provides cost sharing• Provide a mechanism to support the project
Proprietary and Confidential Page 5
AgendaAgenda
• Introductions• Project Purpose and Goals• GIS examples-What are others doing• State of current GIS• Future GIS alternatives & vision • Data warehouse overview• Open discussion & questions
Proprietary and Confidential Page 6
Office Locations
*Denver*Denver
*Corporate Headquarters*Corporate Headquarters
BostonBostonLondonLondon
BrisbaneBrisbane
KoreaKorea
South AmericaSouth America
Proprietary and Confidential Page 7
Convergent Group GIS ProfileConvergent Group GIS Profile
•Industry GIS integration leader in government and utilities•15 years of consulting and integration services •Transforming governments and utilities business processes•Global provider of eBusiness spatial solutions:
“We put the picture in things”
Proprietary and Confidential Page 8
Representative Representative Strategic RelationshipsStrategic Relationships
Proprietary and Confidential Page 9
Convergent Group e-Business Convergent Group e-Business and CRM Partnersand CRM Partners
•Middleware• Vitria• EFX
Proprietary and Confidential Page 10
GIS at Work for ODOTGIS at Work for ODOT
Interactive, web-enabled bikeway search and mapping
ODOT’s Snow and Ice Report and snow
emergency site
Proprietary and Confidential Page 11
GIS at Work for Ohio EPAGIS at Work for Ohio EPA
• Select a
watershed on
interactive
website
• Query the
database for
details about
selected
watershed
Proprietary and Confidential Page 12
Parcel
information
Web-enabled GIS in Greene CountyWeb-enabled GIS in Greene County
Search by
parcel number,
owner or
address
Interactive Internet
GIS data browser
Proprietary and Confidential Page 13
Economic DevelopmentEconomic Development
Parcels are selected
based on size,
availability, zoning,
tax rate, proximity to
freeways, schools,
utilities,
waterways, forest,
etc.
Final candidate
parcels with price
and other details
displayed
Imagery displaying the
ideal site
Proprietary and Confidential Page 14
Economic DevelopmentEconomic Development
Site selection based on
redevelopment district, flood
zone, and proximity to rail
Proprietary and Confidential Page 15
InternetInternet
• Enable easy access of parcel and
real estate information
• Market Ohio data and GIS services,
such as creation of standard and
custom maps
Proprietary and Confidential Page 16
Storm Damage TrackingStorm Damage Tracking
Monitor land cover changes based on satellite imagery from before and after severe weather like hail (shown here) or tornadoes
Hotlink to “before and after” photos, or to other related
documents
Overlay parcels and roads to determine disaster recovery areas
Proprietary and Confidential Page 17
Interactive Voter InformationInteractive Voter Information
• Enables user to locate polling place, based on the input address
• Provides polling place address
• Offers hotlinks to e-mail, web addresses, and district maps related to upcoming elections
Proprietary and Confidential Page 18
Public SafetyPublic SafetyPlot historical incident
activity chronologically
using time series
animation
Track crime trends and
serial offenders using
criminal geographic
profiling to isolate hot spots
Proprietary and Confidential Page 19
Capital ImprovementCapital ImprovementProject TrackingProject Tracking
• Locate all projects
underway, or within a
radius of a chosen
parcel
• Display photos of
current project status
• Store and retrieve
data about projects
• Manage traffic
congestion due to
project construction
Proprietary and Confidential Page 20
HAZMAT
Hazard ResponseHazard Response
Query HAZMAT
database to determine
nature of spillOverlay contamination
imagery to determine
parcels effected by
chemical spill, and
generate mailing list
Proprietary and Confidential Page 21
Map toxic release sites based on
proximity to a user-specified
zip-code area
• Display details
about selected toxic
release sites
• Use selection set to
create mailing lists
or other time-saving
tools
Hazard TrackingHazard Tracking
Toxic Release Inventory System
Proprietary and Confidential Page 22
Flood ForecastingFlood Forecasting
Previous flood extents can be mapped
over aerial photography to predict future
impact areas
Incorporate data from STORMS and other sources to
provide more thorough analysis
Proprietary and Confidential Page 23
Flood ManagementFlood Management
Map locations and
coverage of existing
communications towers in
order to select the best
site for a new NOAA
transmitter hardware for
the flood warning system
Proprietary and Confidential Page 24
Flood ManagementFlood Management
Select highest elevation public
water supply wells and intakes
to locate sources for fresh water
during a flood
Alternate Route
Flood-Risk Route
• Display of contours over aerial photos
shows detailed elevations for streets
• Routing tools can be used to determine
alternate routes for rescue efforts in the
event of road closures
Proprietary and Confidential Page 25
Flood Disaster PreventionFlood Disaster Prevention
FLOOD LINEFLOOD LINE
FLOOD LINEFLOOD LINE
Normal R
iver S
horelin
e
Normal R
iver S
horelin
e
Normal R
iver S
horelin
e
Normal R
iver S
horelin
e
Analyze imagery
from previous floods
to anticipate the
extent of damage and
identify the highest
risk areas
Proprietary and Confidential Page 26
Fire Station
Emergency ResponseEmergency Responseand Modelingand Modeling
Map Fire response times
based on routes; for new
station site location and for
customer service
Map impact of surface
bomb detonation in
pounds per square inch
Proprietary and Confidential Page 27
Incident MappingIncident Mapping
California up-to-the-minute Earthquake Map
Provide near-real-
time information
about severe
storms, floods,
earthquakes,
chemical spills and
other public hazards
Proprietary and Confidential Page 28
Routing and Fleet ManagementRouting and Fleet Management
• Track vehicles using
GPS• Design optimal routes• Provide working
instructions to drivers
in the field
Proprietary and Confidential Page 29
Work ManagementWork Management
• Manage plowing routes
• Track plow equipment
• Log snow removal costs
Manage DOT tasks
such as snow
removal
Proprietary and Confidential Page 30
Natural Resources TrackingNatural Resources Trackingfrom Spacefrom Space
Use satellite images to track
changes in coastline from
erosion
Proprietary and Confidential Page 31
Natural Resources TrackingNatural Resources Tracking
Use “before and after”
satellite images to track
damage from forest fires
or tornadoes
Proprietary and Confidential Page 32
Pollution Tracking and ControlPollution Tracking and Control
• Satellite remote-sensing imagery reveals extent
of oil spills and air pollution
• GIS overlays with the imagery assist in analysis
of impacts
Proprietary and Confidential Page 33
Natural Resources ManagementNatural Resources Management
• Water
Resources and
Wetlands
Inventory
• Watershed
Management
Environmental
Protection
Management
Water Quality
Assessment and
Tracking
Proprietary and Confidential Page 34
EducationEducation
Based on reading test performance, show
which districts need the most help from reading
volunteer programs and Ohio Reads funds.
Identify districts that require additional
assistance in reading programs and track
performance of current Ohio Reads dollars
Based on test scores and volunteer numbers, identify districts that require additional emphasis on volunteer participation
Track Volunteer
Participation
Track Grant Performance
Proprietary and Confidential Page 35
Historic Status of Typical State GISHistoric Status of Typical State GIS
• Statewide GIS coordinator• GIS data is agency based• Different data and systems• Focus on GIS standards • Clearinghouse approach• Hard to share data• Expert system• Not really a “statewide” tool• “Back Office” focused
Proprietary and Confidential Page 36
Statewide GIS Goals- Current LeadersStatewide GIS Goals- Current Leaders
• Improve service and access for customers• Customer facing and service oriented• Leverage return on historic investment• Increase ability to achieve broader priorities Improve education and literacy Improve public safety Increase high-tech economic development Grow high-tech citizenry Improve state image
Proprietary and Confidential Page 37
Statewide GIS Goals- Current LeadersStatewide GIS Goals- Current Leaders
• Transition-expert to casual user system• Enterprise data sharing mechanisms• Integration of GIS with other systems/data• Leadership• Capability to maintain over lifecycle
Proprietary and Confidential Page 38
Governors Action Center - Contact Center
Government Gateway
Asset Register
Asset Maintenance
Outage Management
Work Design
Work Management
Public Works
Permitting
Zoning/Planning
Payments/Collection
Inspections
Code Enforcement
EconomicDevelopment
PropertyTransfer &Taxation
Legislation
Licensing
Voting & Polling
Communication
Redistricting
PublicSafety
Crime Analysis
Disaster Planning
Fire Inspections
Environmental/HAZMAT
Civic
Deed Register
Parcel Mapping/Editing
Tax Administration
CAMA
Verifications (QC)
Computing Environment
Data Hub Asset Object Model
Mobile Computing
Internet
eGovernmentWeb Portal
Intranet
Web-enabledService Counter
Web-enabledCall Center
Intranet
EDMSGISInternetIntranet
PETIVR
Proprietary and Confidential Page 39
Contact CenterContact Center
State Government GatewayState Government Gateway
CivicCivic
EconomicDevelopment
EconomicDevelopment
Secretary of StateSecretary of State
Safety &Emergency
Management
Safety &Emergency
Management
EducationEducation
Roads &Transportation
Roads &Transportation
Customer Service
MasterCardCitizensInternal StaffLegislators Businesses
• Communication• Voting/polling• Licensing• Legislation• Redistricting
• Growth Management• Site Selection• Regional Planning• Abatement Analysis
• Lobbyist Tracking• Campaign Management• Voter results tracking• UCC management
• Better Customer Service• Faster Complaint Response• Real Time Asset Inventory• More Efficient Staff• Better Infrastructure Mgt.
• Parents’ Toolbox• Virtual Classroom• Digital Neighborhood Watch• Redistricting• Bus Routing• Performance Tracking
• Disaster Planning• Crime Analysis• Public Safety Coordination• Flood Forecasting
Proprietary and Confidential Page 40
State Government GatewayState Government Gateway
Contact CenterContact CenterContact CenterContact Center
City/County ServicesCity/County ServicesCity/County ServicesCity/County Services
FulfillmentFulfillmentFulfillmentFulfillment
Status
Complete
In process
Request Compete
ReportsReportsCostTimePatterns
Request
Request
Status & Status & TrackingTrackingWhoWhatWhereWhen
Outcome
CRM
Executive Information SystemProcess/Service Improvements
Capital Improvements
CivicCivic Secretaryof State
Secretaryof State
EconomicDevelopment
EconomicDevelopment
Safety &Emergency Response
Safety &Emergency Response
EducationEducationRoads &Transportation
Roads &Transportation
Internal StaffFaxPhoneInternetWalk in
Enterprise Resource Planning
Financial/Labor Materials
Proprietary and Confidential Page 41
SchoolsData
ERP
DatabaseGIS
GIS
StudentData
Customers:
Parent LegislatorOperational
StaffEducator AnonymousStudent
Education SolutionEducation Solution
Education Resource
CustomizedAnnouncements
External Functions• Parents’ Toolbox• Virtual Playground• Digital Neighborhood Watch
Internal Functions• Performance Tracking• Redistricting• Fund Allocation
CONTACT CENTER
EDUCATION
Proprietary and Confidential Page 43
I’m a new userI’m a new user
Sign me up for free!
I’m already registeredI’m already registered
User ID:
Password:
Sign In
Login AnonymouslyLogin Anonymously
Sign In
Albert Einstein
*********
Personalized LoginPersonalized Login
Personalized profile is created based on user type. Useful information is pushed back to the user real time and via email, based on data the user has input to the profile.
Personalized profile is created based on user type. Useful information is pushed back to the user real time and via email, based on data the user has input to the profile.
Proprietary and Confidential Page 44
I’m a new userI’m a new user
Sign me up for free!
I’m already registeredI’m already registered
User ID:
Password:
Sign InSign In
Login AnonymouslyLogin Anonymously
Sign InSign In
Please tell us about youPlease tell us about you
Last Name:
First Name:
Password:
Address:
City:
Zip code: CO
Phone:
e-mail address (optional):
SubmitSubmit
Albert
Einstein
**********
7600 E Caley Ave.
Englewood
80111
303-741-8400
Profile CreationProfile Creation
Proprietary and Confidential Page 46
Parents’ Toolbox - RelocationParents’ Toolbox - Relocation
7600 E Caley Ave. Englewood, CO 1.0
Proprietary and Confidential Page 47
Bishop Elementary School
Cherrelyn Elementary School Clayton
Elementary School
Elementary School
Parents’ Toolbox - RelocationParents’ Toolbox - Relocation
Proprietary and Confidential Page 48
Welcome to Clayton Elementary SchoolWelcome to Clayton Elementary School
4600 S Fox StreetEnglewoodCO 80111(Tel) 303-781-7831
Upcoming School Events
Curriculum
Bus route
Teacher’s List
Parents’ Toolbox - RelocationParents’ Toolbox - Relocation
Proprietary and Confidential Page 49
Bishop Elementary School
Cherrelyn Elementary School Clayton
Elementary School
Elementary School
Parents’ Toolbox - CommunicationParents’ Toolbox - Communication
Proprietary and Confidential Page 50
About CurriculumAbout Curriculum
OthersOthers
School SystemSchool System
School Name:
Curriculum:
Please write in free format in below.
SubmitSubmit
Clayton Elementary School
Science
Parents’ Toolbox - File CommentsParents’ Toolbox - File Comments
Proprietary and Confidential Page 51
Statistics by StateStatistics by State
Statistics by SchoolStatistics by School
Statistics by DistrictStatistics by District
Select information you want to see:
ACT & SAT
Parents’ Toolbox -Test Statistics Parents’ Toolbox -Test Statistics
Proprietary and Confidential Page 52
School Bus RouteSchool Bus Route
Walk RouteWalk Route
Select school name:
Sinclair Middle School
Bishop Elementary School
Parents’ Toolbox - Bus Parents’ Toolbox - Bus RoutesRoutes
Proprietary and Confidential Page 56
Gang InfoGang Info
School Violation InfoSchool Violation Info
Crime InfoCrime Info
AAAAABBBBBCCCCC
AAAAABBBBBCCCCC
InformationInformation Location
Gang IncidentsGang Incidents
Digital Neighborhood WatchDigital Neighborhood Watch
LocationLocation
Proprietary and Confidential Page 57
Gang InfoGang Info
School Violation InfoSchool Violation Info
Crime InfoCrime Info
AAAAABBBBBCCCCC
Gang IncidentsGang Incidents
InformationInformation LocationLocation
Digital Neighborhood WatchDigital Neighborhood Watch
Proprietary and Confidential Page 58
Gang InfoGang Info
School Violation InfoSchool Violation Info
Crime InfoCrime Info
AAAAABBBBBCCCCC
Gang xGang x
InformationInformation LocationLocation
Digital Neighborhood WatchDigital Neighborhood Watch
CountyDistrictNumber of membersDescriptionsColors, symbols, tattoosCrimes reportedArrests
Proprietary and Confidential Page 59
Current North Dakota GIS Current North Dakota GIS StatusStatus
• GIS being used in depts.• Important to business• Large scale mapping• Exchanging data - takes time• Using federal data• Expert user access• Web access or planned
Proprietary and Confidential Page 60
Current North Dakota GIS Current North Dakota GIS StatusStatus
• Redundancy minimal• Variety of data bases• Minimal applications• Every dept. would like more GIS• Budgets have been tough• Creativity has been high• State-wide strategy absent
Proprietary and Confidential Page 61
Key NeedsKey Needs
• Mechanism to share data• Web strategy - one• Growth strategy reducing redundancy• Capability to share costs• Casual user access• Public access• Leverage investment• Leadership / budget
Proprietary and Confidential Page 62
Data WarehousingData Warehousing
Tool for data sharing and basis for achieving key needs
Proprietary and Confidential Page 63
Why the Hub? Why the Hub?
Key Reasons Provides shared data on enterprise basis
Leverages substantial historic investment
Improved business processes
Provides new/casual user access
Tools for future public access
Allows shared applications
Proprietary and Confidential Page 64
Hub OverviewHub Overview
Hub isAn enterprise-wide database warehouse
Where departments publish their data
Where departments may extract data
Where public may extract data
Proprietary and Confidential Page 65
Sample Hub ComponentsSample Hub Components
Browser
MapWorksMap
Optixs
DATAWAREHOUSE
PUBLISH
Dept.data
OTHERS
ESRI
NT
FME
COLD FUSION
INTERNET
SQL SERVER
SDE
Data Extracts
Proprietary and Confidential Page 66
Topics System overview
System components
HW/SW architecture
Scalability
Availability
Technical OverviewTechnical Overview
Proprietary and Confidential Page 67
Hub Server OverviewHub Server Overview
Publish
LoadSource
Archive
Admin
DTS
Loader
QA
SQL Client
SDE Client
Web Browser
ExtractorExtractor
Proprietary and Confidential Page 68
Spatial Database Service
Replication Service
Internet Map Service
Data Extraction Service
Data Publishing Service Data Transfer Service
Data Analysis Service
Data Browser
System Components
Proprietary and Confidential Page 69
Software ArchitectureSoftware Architecture
IBM Compatible
WebBrowser
Microsoft Exploreror
NetscapeNavigator
Server
ApplicationServers
SDE ClientMapWorks
SQL Server 7 ODBC
SDE ClientARCInfo 7.2
SQL Server 7 ODBCMapWorksFME Server
ServiceManager
Web Servers Map Servers
MapObjects MapServerServerESRIMap Server
ServletRunnerJDK/JRE V1.2
JSDK V2.1Zip Utility
Cold Fusion Server
Web Server IIsMapOptix
MapWorks Viewer
IBM Compatible
Server
ServerData Servers
SQL Server 7SDE 3.0.2.1
Distribution ServerData Transformation Services
Microsoft Oracle ODBCORACLE SQL*NET
Sybase SQL Server ODBCSybase Open Client
Server1 -ServerN
Proprietary and Confidential Page 70
Hub – Scalability
IBM Compatible
Data Servers
Web Servers
Web Browser
IBM Compatible
Desktop Applications
Tower boxTower box
IBM Compatible
Tower boxTower box
Tower box
Application
Servers
Tower box Tower box
Tower box
Tower box
IBM Compatible
Tower box
Tower boxTower box
Data Data
ReplicationService
MapObjectsMap Server
MapObjectsMap Server
MapObjectsMap Server
MapObjectsMap Server
MapObjectsMap Server
MapObjectsMap Server
FME Server
FME Server
FME Server
FME Server
FME Server
FME Server
ESRI Map Server
ESRI Map Server
Service Manager Service Manager
MapWorksCF Viewer
MapWorksCF Viewer
MapWorksCF Viewer
Cold Fusion ClusteredLoad Sharing
Tower box
Proprietary and Confidential Page 71
Application Servers
Inherit Reliability of HUB Design
• Any application server or desktop Application can use any of the Hubdata servers to meet their needs
DesktopApplications
Data Distribution Data Distribution ArchitectureArchitecture
Tower box
OrthosShapefilesMapInfo
DGNCoverages
Disk array
Data
Subscriber
Data Servers
Tower box
OrthosShapefilesMapInfo
DGNCoverages
Disk array
Data
Publisher
Tower box
OrthosShapefilesMapInfo
DGNCoverages
Disk array
Data
Subscriber
Proprietary and Confidential Page 72
HUB BenefitsHUB Benefits
Demonstrates Multi-platform Capability
Loading multiple sources intelligently into the HUB
Desktop viewing of multiple data sources
Extraction of data from the HUB to multiple destination formats
Demonstrated that the technologies can indeed play together as required
Proprietary and Confidential Page 73
Hub BenefitsHub Benefits
Efficiencies through organized data sharingScalability – more users more processesLongevity – independent of spatial systemIntegrates with business systems High AvailabilityLow riskEncourages participation
Proprietary and Confidential Page 74
Next StepsNext Steps
1. Development of GIS Business Case Cost Savings Cost Avoidance New Revenue Opportunities March 2000
2. Development of GIS Implementation Plan Technology and Capability Phasing
Organizational Teamwork
Schedule
2Q00
Proprietary and Confidential Page 75
Next StepsNext Steps
3. Legislative and Executive Briefings Buy-in and Advocacy
Prioritization
April 2000
4. Budget Submission (Final) June 2000
5. Project Implementation Start-up July 2000