# Presentation: 530454

## Mapping for Policy:

- Linking Health and Human Service Data and GIS to Improve Government Services

- Office of Research & Statistics
- SC State Budget & Control Board
- December 1999

- www.orss.state.sc.us

## HEALTH STATISTICSINFRASTRUCTURE AT ORS	

- A COLLABORATIVE EFFORT

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## PRIVATE SECTOR DATABASES

- PATIENT LEVEL DATABASES
- Inpatient Hospital Discharges
- Emergency Room Visits
- Outpatient Surgeries (hospital-based and licensed freestanding centers)
- Home Health Visits
- Use of Special Equipment Requiring CON approval (MRI, PET, Cardiac Cath, Radiation Therapy)

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## PRIVATE SECTOR DATABASESProvider Resources Databases

- Licensed Health Professions
- Lead Agencies - Health Professions Licensing Boards

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Licensed Health Professions               What’s In It?

-  Professions: Physicians, Physicians Assistants, Dentists, Dental Hygienists, Physical Therapists, Physical Therapist Assistants, Occupational Therapists, Occupational Therapist Assistants, Pharmacists, Optometrists, Psychologists, Social Workers

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## PRIVATE SECTOR DATABASESProvider Resources Databases

- Hospitals and Nursing Care Facilities Survey
- Lead Agency-S.C. Department of Health and Environmental Control

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## PUBLIC SECTOR DATABASES Under Memoranda of Agreement

- MEDICAID CLAIMS STATISTICAL EXTRACT
- WHAT’S IN IT?
- About the Client: date of birth, race, gender, county and zip code of residence, dates of eligibility

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## PUBLIC SECTOR DATABASESUnder Memoranda of Agreement

- S.C. DEPARTMENT OF MENTAL HEALTH
- What’s In It?
- About the Client: date of birth, race, gender, county and zip code of residence
- About the Service: inpatient hospitalization (similar to private sector database), outpatient mental health center visits ( center ID, service, date of service, type of provider, duration of service)

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## PUBLIC SECTOR DATABASES Department of Mental Health (cont.)

- About the Charges: payer, total charges, charges by revenue center for inpatient
- EXAMPLES OF USE
- “State Reform Grant” awarded to DMH - follow a cohort of clients across public and private sector - understand how DMH clients use the health care system

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## DEPARTMENT OF MENTAL HEALTH (CONT.)

- EXAMPLES OF USES (cont.)
- DMH Services planning for severely mentally ill
- identify by county the number of persons with severe mental illness who are “at risk” for requiring DMH services
- Planning for managed care

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## PUBLIC SECTOR DATABASES    S.C. CLIENT MASTER FILE

- A project of the Human Services Coordinating Council and the Governor’s Office
- PARTICIPATING AGENCIES:
- DHHS, DHEC,DSS,  DMH, DAODAS, DDSN, DJJ, DEPT. OF CORRECTIONS, VOCATIONAL REHABILITATION, CONTINUUM OF CARE, COM. ON BLIND

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## S.C. CLIENT MASTER FILE           What’s In It?

- About the Client: date of birth, race, gender, county and zip code of residence
- About the Service: agency ID, program (e.g., WIC), service (e.g., nutrition), date of service, county of service
- one record per client for each service received by date for the calendar year

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## S.C. CLIENT MASTER FILE            How Is It Used?

- Identify amount of crossover of clients among agencies for better planning for coordination of care
- Long Term Care Council planning for state services for older adults (55+) in the future (to 2010)
- Community planning for coordination of services to improve community and family well-being

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## PUBLIC SECTOR DATABASES

- All databases contain personal identifiers and addresses
- These items are separated immediately from statistical data and replaced by a tracking number
- Personal identifiers are not used for any other purpose

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## GIS in Health & Human Services

***The Addressing & Geocoding Project***
- Office of Research & Statistics
- SC State Budget & Control Board
**Funded by Governor’s Office, Division of Victim Assistance**
**December 1999**

*“**Putting It All Together”*

## Addressing & Geocoding Project Staff

- David J. Alexander
- Ellen Crolley
- Keith Eller
- Craig Evans
- Geoff Johnson
- David W. Morrison
- Joe Runyon

- Special Recognition: Jonathan D. Fisk and Jack H. Maguire

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Project Goals

- <date/time>

**Project Goals**

**Enable address level GIS applications in State government! **
**Support address level GIS applications in local government**
**Impact Census 2000**

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Why Addressing and Geocoding?

- Evaluating Service Delivery
- Analyzing Resource Allocation
- Targeting Susceptible Populations
- Modeling real-world phenomena
- Uncovering Agency Overlap & Program Specific Relationships

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## What does it all depend upon?

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## E911 Status in South Carolina

**SC State Budget & Control Board, 1999**

## Where do We stand?

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## County Status Report

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## How do We accomplish our goals?

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## ADDRESSING & GEOCODING PROJECT

- TIGER** BEFORE** UPDATE

- TIGER** AFTER** UPDATE

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## How do/can we use the GIS?

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Locating Database Events to a Point

**Locating Database Events to a Point**

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Assigning Points to AREAS(Geographic Units)

- <date/time>

- Assigning Points to _AREAS_(Geographic Units)

- _AREA MAPS  LINK TO CENSUS DATA_
- LOW BIRTH WEIGHT TO CENSUS TRACT (Healthy Start ...1994)
- HOME HEALTH CARE... PATIENTS,  PHYSICIANS, AND HOSPITAL ER SITES WITH CENSUS DATA (1995)

**    ****Census**
**       ****data**

**Health **
**  ****data**

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## This system can be used to map any 

- Database Public or Private with “Good” Address Information and to relate the proper census codes to the data.

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## S.C. Master File Participants

**Division of Foster Care Review**
**Commission for the Blind**
**Division on Aging**
**Dept. of Alcohol and other Drug Abuse Services**
**Division of Continuum of Care**
**Dept. of Juvenile Justice**
**Dept. of Health and Human Services**

**Dept. of Health and Environmental Control**
**Dept. of Mental Health**
**Dept. of Disabilities and Special Needs**
**Dept. of Social Services**
**Dept. of Vocational Rehabilitation**
**Dept. of Corrections**

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## GIS in Action

- A Few Examples

## GIS AnalysisAn Iterative Approach

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## GIS ModelingScalability and Data Integration

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## GIS in Community Development!(Impacting Social Services)

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Common Health & Human Service Elements

- <date/time>

**   ****Families**
**   **

**Broad **
**Accessibility**

**Performance**
**of Government**

**Common Health & Human Service Elements**

**Economic**
**Environment**

**Quality**
**    ****of **
**  ****Life**

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Barriers to Family Independence

- Lack of Childcare

- Lack of Transportation

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Susceptible Population:  Welfare Reform Clients

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## GIS in Transportation

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Current & Potential Transit Riders

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## New Rural Transit Route

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## GIS in Law Enforcement/Crime Prevention!

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Newberry County Crime Locations

**Newberry County Crime Locations**

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Actual High Crime Area

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Neighborhood Events

**Spatial Relationships**

**The Anatomy of** **Crime**.

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## The Addressing & Geocoding Project, Office of Research & Statistics,

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Confidentiality in GIS

-  Choropleth Mapping
-  Surface Density Modeling
-  Point Frequency Distribution
-  Spatial Aggregation to other geographic units

- Example Map: Generated from Sample Data. Actual Crash data may appear differently when processed.

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Data can be mapped by Area Groupings to ensure confidentiality of sensitive data.

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## The Road Ahead

-   Accurate Maps (roads and facilities)
-   GPS -- Real-Time Location Identification
-   Geostatistics (linking to Census Data)
-   Multimedia
-   Internet Mapping

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Future Mapping Initiatives: Accurate Maps and GPS

- Using GPS requires accurate maps for referencing.  GPS tells you where
- something is not how to get to that something.

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

-   Address Database Standards
-   Road Centerline Accuracy Standards
-   GPS Basemap Development
-   GPS to TIGER mapping conversions

## Linking GPS Data to TIGER Maps

- By using address range information, data can be maneuvered between disparate map sources;
- and, accurate GPS coordinate data can be reliably linked to correct polygonal or census block areas that are derived from TIGER basemaps.

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Geostatistics

- All kinds of human-environmental research depend on population data.
- Redistricting is based on TIGER maps.
- Most community block grants and other funding programs use Census TIGER data for evaluating awards.

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## The Addressing & Geocoding Project, Office of Research & Statistics,

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Internet Technologies and Broad Accessibility

- Internet Map Server technology will allow users to view geographic data online and download public spatial datasets providing broad accessibility to geographic information.

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## The two A’s:  Accuracy and Attributes

- The accuracy of the basemap dictates the usefulness of the GIS
- The completeness of the attributes dictates the intelligence of the GIS

- Ex 1:  Accurate Road Centerline

- Ex 2: Attributized Road Centerline

- Independence Blvd

- Recap: Good Spatial Data makes the GIS...

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Recap: How is the GIS most useful?

**By answering two important queries...**
**Where? **
**Why?**
**From asking two simple questions...**
**Who?**
**What?**

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## Just a Thought...

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**

## 		 Teamwork through a shared vision!

**	****	**** ****Teamwork through a shared vision!**

**Vision**

**Education**

**Health**

**Public Safety**

**Commerce**

**Regulatory/**
**Licensing**

**Judicial**

**Legislative**

**Central **
**Govt Admin**

- Government with a Shared Vision

**Government**

- Government without a Shared Vision

**The Addressing & Geocoding Project, Office of Research & Statistics,**
**SC State Budget & Control Board, 1999**