Using Geographic Information Systems GIS and Other Mapping

  • Slides: 39
Download presentation
Using Geographic Information Systems (GIS) and Other Mapping Tools in VR Programs Todd Sink,

Using Geographic Information Systems (GIS) and Other Mapping Tools in VR Programs Todd Sink, Ph. D. , Research Specialist II WV Division of Rehabilitation Services Pisnu Bua-Iam, M. A. , Senior Manager WV Division of Rehabilitation Services Rhonda Young, M. A. University of Arkansas WV Division of Rehabilitation Services 1

Outline • Introduction ▫ ▫ VR Management Perspectives on GIS Background on geographic information

Outline • Introduction ▫ ▫ VR Management Perspectives on GIS Background on geographic information systems (GIS) Purpose Goals • Identification of Potential Underserved and Unserved Areas ▫ Summary ▫ Details, step by step • Summary of GIS Strategy ▫ Other GIS possibilities in VR • Other Mapping Tools in VR WV Division of Rehabilitation Services 2

Background on GIS • What is it? How does it work? • What are

Background on GIS • What is it? How does it work? • What are the benefits? • Who uses GIS? What is it used for? WV Division of Rehabilitation Services 3

What is GIS? How Does it Work? Data Sources • A system designed to

What is GIS? How Does it Work? Data Sources • A system designed to inform decision making from data Satellite Data (Satellite Imaging Corp. ) Digital Maps (City/County Government) Other Digital Data (Political Boundaries: U. S. Census) GIS Aerial Photographs (Local Universities) Tabular Information (U. S. Census) WV Division of Rehabilitation Services 4

What are the Benefits? Example: Tabular Data • Data ▫ Capture ▫ Store ▫

What are the Benefits? Example: Tabular Data • Data ▫ Capture ▫ Store ▫ Manage ▫ Display ▫ Analyze Most efficient and effective for VR administrators Ease with which data can be communicated WV Division of Rehabilitation Services 5

Who Uses GIS? Who? • Government Agencies ▫ Federal ▫ State ▫ Local •

Who Uses GIS? Who? • Government Agencies ▫ Federal ▫ State ▫ Local • Real Estate • Health Care • Retail • Information • Others What is it Used for? Uses? • Federal Government ▫ Monitor predatory lending practices • State Government ▫ Maintain highways and roads • Local Government ▫ Establish evacuation routes ▫ Track local crime patterns • Real Estate ▫ Track property values and tax information • Health Care ▫ Track spread of disease • Retail ▫ Find optimal location for new store ▫ Trade Area • Information ▫ Planning of utility expansion WV Division of Rehabilitation Services 6

Purpose • Introduce GIS (Arc. GIS: Arc. Map 10) as a tool to pinpoint

Purpose • Introduce GIS (Arc. GIS: Arc. Map 10) as a tool to pinpoint parts of West Virginia where populations are potentially unserved and possibly underserved by WVDRS • Discuss other mapping tools in VR WV Division of Rehabilitation Services 7

Goal • Improve planning for community outreach efforts ▫ Cost-effective method to increase awareness

Goal • Improve planning for community outreach efforts ▫ Cost-effective method to increase awareness of WVDRS programs and services among VR stakeholders and consumers WV Division of Rehabilitation Services 8

Identification of Potential Underserved and Unserved Areas Summary of Steps Determine scale that will

Identification of Potential Underserved and Unserved Areas Summary of Steps Determine scale that will be used to define areas (geographic area) Create boundary layer for entire service area Join active clients table with GIS boundary layer Operationalize possibly underserved and unserved areas Create map of active cases WV Division of Rehabilitation Services 9

Step 1. Determine scale for potential underserved and unserved areas (geographic area) Possible scales

Step 1. Determine scale for potential underserved and unserved areas (geographic area) Possible scales District County *Zip Code Census Tract Block Group *Proposed RSA-911 requires VR agencies to report zip code information Block WV Division of Rehabilitation Services 10

Step 2. Create Zip Code Boundary Layer for State of West Virginia (WVDRS service

Step 2. Create Zip Code Boundary Layer for State of West Virginia (WVDRS service area) Outline of Step 2 2. 1 2. 2 2. 3 • Navigate Network to Find Corresponding Data Source • Add U. S. Zip Code Layer • Create WV Zip Code Layer WV Division of Rehabilitation Services 11

Navigate Network: 2. 1. 1 Click Add Data Button WV Division of Rehabilitation Services

Navigate Network: 2. 1. 1 Click Add Data Button WV Division of Rehabilitation Services 12

Navigate Network: 2. 1. 2 Locate Folder with Data WV Division of Rehabilitation Services

Navigate Network: 2. 1. 2 Locate Folder with Data WV Division of Rehabilitation Services 13

Navigate Network: 2. 1. 3 Select U. S. Zip Codes WV Division of Rehabilitation

Navigate Network: 2. 1. 3 Select U. S. Zip Codes WV Division of Rehabilitation Services 14

2. 2 Add U. S. Zip Codes WV Division of Rehabilitation Services 15

2. 2 Add U. S. Zip Codes WV Division of Rehabilitation Services 15

Create WV Zip Code Layer 2. 3. 1 Select by Attributes (WV) WV Division

Create WV Zip Code Layer 2. 3. 1 Select by Attributes (WV) WV Division of Rehabilitation Services 16

Create WV Zip Code Layer 2. 3. 2 Create Layer from Selection WV Division

Create WV Zip Code Layer 2. 3. 2 Create Layer from Selection WV Division of Rehabilitation Services 17

Create WV Zip Code Layer 2. 3. 3 Zoom to Layer WV Division of

Create WV Zip Code Layer 2. 3. 3 Zoom to Layer WV Division of Rehabilitation Services 18

Step 3. Join WVDRS Active Client Table (As of 5 -18 -2011) with WV

Step 3. Join WVDRS Active Client Table (As of 5 -18 -2011) with WV Zip Code Layer Outline of Step 3 3. 1 3. 2 3. 3 • Verify Format of Matching Columns (Zip Code) is Identical • Perform Join • Validate Join WV Division of Rehabilitation Services 19

Join Active Client List with Zip Code Layer: 3. 1. Match Joining Columns WV

Join Active Client List with Zip Code Layer: 3. 1. Match Joining Columns WV Division of Rehabilitation Services 20

Join Active Client List with Zip Code Layer: 3. 2. Perform Join WV Division

Join Active Client List with Zip Code Layer: 3. 2. Perform Join WV Division of Rehabilitation Services 21

Join Active Client List with Zip Code Layer: 3. 3 Validate Join WV Division

Join Active Client List with Zip Code Layer: 3. 3 Validate Join WV Division of Rehabilitation Services 22

Join Active Client List with Zip Code Layer: 3. 3 Validate Join cont. WV

Join Active Client List with Zip Code Layer: 3. 3 Validate Join cont. WV Division of Rehabilitation Services 23

Step 4. Operationalize Potential Underserved and Unserved Zip Codes • Potential Unserved Zip Codes

Step 4. Operationalize Potential Underserved and Unserved Zip Codes • Potential Unserved Zip Codes ▫ Ø active clients • Possible Underserved Zip Codes ▫ Number of active clients below the state average, as of 5 -18 -2011 �Avg: 44. 94 WV Division of Rehabilitation Services 24

Step 5. Create Map of Active Clients Outline of Step 5 5. 1 5.

Step 5. Create Map of Active Clients Outline of Step 5 5. 1 5. 2 • Data Classification • Export Map WV Division of Rehabilitation Services 25

Create Map of Active Clients: 5. 1 Data Classification WV Division of Rehabilitation Services

Create Map of Active Clients: 5. 1 Data Classification WV Division of Rehabilitation Services 26

Create Map of Active Clients: 5. 1 Data Classification cont. WV Division of Rehabilitation

Create Map of Active Clients: 5. 1 Data Classification cont. WV Division of Rehabilitation Services 27

WV Division of Rehabilitation Services 28

WV Division of Rehabilitation Services 28

Create Map of Active Clients: 5. 2 Export Map WV Division of Rehabilitation Services

Create Map of Active Clients: 5. 2 Export Map WV Division of Rehabilitation Services 29

Summary • GIS application in VR • Improve planning for community outreach efforts •

Summary • GIS application in VR • Improve planning for community outreach efforts • Other GIS Possibilities for State VR Agencies ▫ Aid in matching employment needs of clients with available jobs �Match case management records with local employment dynamics data (U. S. Census) ▫ Help find the most suitable location for a new branch office �Spatial Analyst Extension in Arc. GIS �Input model criteria to define best location: Cost; accessibility; terrain; etc. ▫ Explore patterns of success in employment outcomes �Explore by district office or branch office �Map best performers in terms of successful and unsuccessful closure statuses: �Model performance (Logistic regression or discriminant function analysis) using data from case management records and quality assurance review �Use results to mark areas where improvements could be made WV Division of Rehabilitation Services 30

The Others Purchased and Free software with mapping capabilities 31

The Others Purchased and Free software with mapping capabilities 31

Tableau (6. 0 or 6. 1) www. tableausoftware. com • Tableau Desktop ▫ User

Tableau (6. 0 or 6. 1) www. tableausoftware. com • Tableau Desktop ▫ User Friendly ▫ Dashboard Reporting ▫ Connect directly to databases, data warehouses, files and spreadsheets ▫ Data blending - connect to multiple data sources to add layers to the visualization ▫ Automatic geocoding down to the zip code level ▫ Tableau Reader is free and allows other VR agency staff to ‘see’ the data visualization ▫ Training webinars are conducted on a regular basis and most are free ▫ A 30 day trial is available ▫ Pricing depends upon the number of user licenses 32

‘ 26’ Closures, FFY 2011, Field Services Office Locations The size of each mark

‘ 26’ Closures, FFY 2011, Field Services Office Locations The size of each mark represents the percentage of 26 closures for each of the ARS office locations. 33

JMP (9. 0 or 9. 02) www. jmp. com • JMP is a SAS

JMP (9. 0 or 9. 02) www. jmp. com • JMP is a SAS product and has many capabilities: ▫ ▫ ▫ ▫ ▫ Statistical analysis Visualization Modeling Interactive data mining Server connections are simple to use JMP’s latest release, 9. 0 has geographic maps or connect to a web map service Add your own shapes, a building floor plan, scale diagrams and build your visualization Graph builder is a tool and can be used to display density and contour graphs across multiple variables Government pricing is available Support and training are available on the website 34

JMP Tree Map 26 Closures, FFY 2011, Counselor, District, City The size of each

JMP Tree Map 26 Closures, FFY 2011, Counselor, District, City The size of each box within the District, City represent numeric values for the number of cases 35

SPSS (20. 0) • SPSS is an IBM statistical analysis product and the latest

SPSS (20. 0) • SPSS is an IBM statistical analysis product and the latest release includes mapping tools ▫ Several maps are pre-loaded or this tool can be used 36

26 Closures, FFY 2011 by Office Zip SPSS Graphboard Template Chooser and map imported

26 Closures, FFY 2011 by Office Zip SPSS Graphboard Template Chooser and map imported with the Map Building Utility 37

Free Software and Map Resources • Geo. Da, open source software developed by Arizona

Free Software and Map Resources • Geo. Da, open source software developed by Arizona State University, Mac OSX and Windows versions http: //geodacenter. asu. edu/ • Arc. GIS Explorer, free GIS viewer with access to Arc. GIS online base maps and layers, Windows only http: //www. esri. com/software/arcgis/explorer/ • Arc. GIS Explorer Online, free browser based services, requires account creation, works with Explorer, Firefox and Safari http: //explorer. arcgis. com 38

Where do I get those shape map files? TIGER Data – U. S. Census

Where do I get those shape map files? TIGER Data – U. S. Census Bureau, 2010 data now available www. census. gov/geo/www/tiger/ QUESTIONS? 39