Leveraging Location Intelligence for Social Services

1. Leveraging Location Intelligence for Social Services Paula Gremillion – LA DSS Tasha Moore – Blue Streak Technologies

2. Louisiana’s Department of Social Services (DSS) The department’s mission is to: • Effectively and efficiently guide individuals, children and families toward independence and safety • Provide integrated quality services and partnerships in an environment of opportunity and accountability.

3. The LADSS Information Services Division strives to: • Develop creative, enterprise technology solutions that enable DSS to provide quality services to its customers • Work with its internal and external stakeholders to deliver information technology products and services in a responsive, cost-effective manner to DSS offices, staff, end-clients, and State departments.

4. Business Intelligence & Reporting Office (BIRO)

5. BIRO operates a data warehouse that serves as the principal source for meeting the reporting needs within DSS. This office was initially created to address certain reporting requirements within the Office of Family Support but proved to be so successful that it evolved into an alternative reporting repository for most DSS mainframe legacy systems. It is now the primary reporting tool for new development. Production data is extracted, transformed and loaded from the various systems using Data Migrator, then sophisticated multi- dimensional reports are produced using WebFOCUS. This allows reports to be published to the intranet/internet for viewing and manipulation. It also enables end users the ability to perform on-line analytical processing, empowering them to create customized reports to suit their individual business needs.

6. The architecture consists of various interconnected elements which include: 1. Operational and external database layer: the source data for the Data Warehouse, i.e., Adabas, SQL, DB2, flat files 2. Data Access Layer: the interface between the operational & informational access layer, i.e., Data Migrator 3. Metadata Layer: the data directory or repository of the metadata information. 4. Informational access layer: the tools by which the end user can extract and analyze the data, i.e., WebFOCUS

7. Information Builders’ Historical Background with LA DSS

8. 2000 LA DSS determined ad hoc reporting tools were needed to meet agency requirements for TANF (Temporary Assistance for Needy Families) benefit & eligibility system under the jurisdiction of the Office of Family Support Copy Manager, WebFOCUS, & Report Broker

9. IBM OS/390 Windows NT ADABAS MS-SQL Copy Manager Monthly CopyManager Quarterly WebFOCUS And Report Broker Sequential 2000

10. 2002 LA DSS further determined a need for the ad hoc query tool for enterprise wide eligibility and benefit systems throughout the department to meet reporting needs of each agency. WebFOCUS, Report Caster, WebFOCUS Developer Studio & ETL Manager

11. 2002-2008

12. TINA-GIS

13. 2003 LA DSS Fraud & Recovery Section of DSS-Office of Family Support required a Geographic Information System capable of running WebFOCUS reports for EBT (Electronic Benefits Transfer) transactions. The system combines the power of GIS mapping technology developed by ESRI & the business intelligence reporting capabilities of WebFOCUS developed by Information Builders to spatially enable data about EBT transactions between food stamp recipients and the stores that accept the food stamps. WebFOCUS, Data Migrator, Report Caster Additional software: ESRI Product Suite, Tele Atlas GDT Matchmaker

14. 2003-2007

15. 2003 LA DSS further required additional ad hoc capability for a new project in the development phase for ACESS (A Comprehensive Enterprise Social Service System) WebFOCUS, Report Caster

16. 2005 Following Hurricane Katrina, DSS’ need for geographic data expanded dramatically due to the displacement of people in the impact area. This resulted in an immediate increase in daily disaster-related transactions, as well as creating an urgent need for cooperating agencies such as FEMA, USDA & other state offices for critical location information. LA DSS was able to use GIS to solve many of the urgent problems created in the aftermath of Hurricane Katrina, as well as improve delivery of services to those in need. This system has served as a model for disaster management & recovery nationwide.

17. 2007

18. Foster care Application

19. 2007 LADSS’ Office of Community Services Child Welfare division determined the need to track Child Welfare activities. The activities include Child Protection, Foster Care, as well as numerous case-tracking matrices. OCS will use GIS mapping technology and WebFOCUS reporting capabilities to provide frontline staff and supervisors the visual capability of viewing clients as well as placement and service providers in their area to meet the needs of a child placed in Foster Care. Additionally, the application will be used by OCS Home Development staff in determining areas of need for recruiting new foster homes.

20. Scope of Project In order to accomplish this task, several issues had to be addressed: • Create a new Foster Care database for GIS • Address issues involving the cross-over of multiple platforms • Build new Data Migrator flows as needed to load and update the SQL tables for GIS • Integrate GIS with current BIRO data • Build launch forms & reports • Geocode the data • Build map layers • Build an application menu

22. GIS A geographic information system is a framework for understanding data and applying geographic knowledge to solve problems. By visualizing relationships, connections, and patterns in data, informed decisions can be made and increase efficiency throughout an organization.

23. The GIS/Mapping capabilities of ESRI combined with the analytic power of WebFOCUS

24. The WebFOCUS Map View enables users to: • View the map • Zoom in and out • Navigate left, right, up, and down • Display the default and custom map legends • Explicitly hide and show map layers • Choose the map feature selection shape • Print the map and legend on a single page • Run WebFOCUS Report procedures based on selections from the map • Run WebFOCUS Identify procedures based on a feature selected from the map

25. Foster care Child Placement Application

26. Data Layers on Foster care Application • Childcare Clients • Childcare Providers • Schools • Hospitals • Geographical points for ease of recognition such as golf courses and parks • Child care Resources • Intensive Home-Based Services • Therapy Resources

27. Application Tools

28. Map Zooming Capabilities

29. Detail View with Legend

30. WebFOCUS Report procedures that are responsive to the filters created by user selections from the map

31. Provider Summary Report

32. Client Summary Report

33. WebFOCUS HTML Reporting Search Forms • Users can generate ad hoc queries and conduct uninhibited, in-depth analysis • Users can map individual and/or entire search results to geographically see the data being researched

34. Client Search Form Appears when you click Client Number

35. Mapping Individual Clients

36. Provider Search Form Appears when you click Provider Number

37. Mapping Individual Providers

38. WebFOCUS Identify procedures based on a feature selected from the map Mini WebFocus reports that allow quick information of icon

39. Provider Identity Information

40. Further customizations to the Foster care GIS Application • HTML Frame Quick Search

41. HTML Frame Quick Search • HTML frame • Ease of quick data search to map visualization • WebFOCUS procedures to send search data to map

42. HTML Frame Quick Search Results

43. WebFOCUS Map Reports

44. Providers with Availability

45. WebFocus Map Reports • Ability to visualize different data scenarios • Example: Providers with Availability • Quick and easy display of set patterns

46. GIS SUCCESS What began as a system for managing Louisiana’s food stamp program is now: • An innovative tool for fraud detection & service delivery • Expanded to disaster management & recovery • Assists with foster care client placements and resources • Evolved into a business information system with the flexibility to track multiple service delivery issues for managers in Louisiana state agencies.

47. Q & A