Using Geomapping with the Data Warehouse in DHS

1
Using Geomapping with the Data Warehouse in DHS

• Jim Davis
• Mary Swihart

2
Agenda

• Where Weve Been to Where We Are
• Examples of Paper Maps
• Online Mapping Demonstration
• Question and Answer

3
CGI, ESRI and DIT-DHSPartnerships

• CGI Statewide Framework
• Computer Servers Data Storage
• ESRI Developed Process to Access DW
• Nicer Looking Front End
• DIT-DHS Worked Together to Apply Mapping
• to their Agency Needs
• Development Implementation
• User Training

4
What Is The CGI Framework?

• County Boundaries
• Zip Code Boundaries
• Roads
• School Buildings School District Boundaries
• Cities, Townships, Villages, etc.
• Lakes, rivers, streams
• Aerial Photography

5
Current GIS Hardware Architecture
GIS Server
Teradata
NCR 5380 Server
Dell PowerEdge 4400
Dell Desktop
6
New GIS Hardware Architecture
CGI Server
GIS Server
Dell PowerEdge 4400
Dell Desktop
Teradata
NCR 5380 Server
7
Current Process (Monthly)
GIS Server
DHS Map Viewer
DOS Batch Process
30 HOURS
DOS Freeware Programs
Visual Basic Program
DHS Data Warehouse
CGI Framework (Annual Extract)
Website File Updates
249 Websites 83 Trending Maps
Text Files
1500 Shape Files

MANY MORE HOURS SPENT MAINTAINING
8
New Process (Nightly)
CGI Databases
CGI Framework
GIS SERVER
DHS Map Viewer
ESRI Spatial Database Engine
APPROX. 4 HOURS
DHS Warehouse
Geomapping Database
9
Current and New DHS Program Maps
County Only
County and Surrounding Area
Better Support for Dual Counties Better Support
for Transparent County Lines
10
Hillsdale General Programs Map
11
Hillsdale Foster Care Map
12
Hillsdale 24 Month CPS Trend
13
The Power Of Data Sharing

• CGI Framework
• DHS Client Data
• MSHDA Needs and Resource Data
• An Incredibly Effective GIS Weapon in the Fight
  Against Homelessness

14
Homeless Policy Academy Map
15
Other Geomapping Options
E x a m p l e s o f P a p e r M a p s
16
Online Geomapping

• D H S P r o g r a m M a p s
• D e m o

17

• Q u e s t i o n s ?

18

• T h a n k Y o u !