Pada Lee Joanna Bomba Andrew Angeles Where we began Using Webbased Solutions to End Veteran Homelessness in Los Angeles Pada Lee Joanna Bomba Andrew Angeles Using Webbased Solutions to End Veteran Homelessness in Los Angeles ID: 790273
Download The PPT/PDF document "Using Web-based Solutions to End Veteran..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide2Where we began
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide3Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide4Some stats
LA
CoC
Fell 32% in LA CoC
Unsheltered veterans reduced 46%2016: 2,728 ( Unsheltered 1485, Sheltered 1243)2015: 4,016 (Unsheltered 2763, Sheltered 1253)
46% of homeless veterans now sheltered vs 31% in 2015
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide5Some stats
County
Data includes Glendale, Long Beach, and Pasadena
Fell 30% across LA County;
Unsheltered veterans down 44%2016: 3,071 ( Unsheltered 1618, Sheltered 1453)
2015: 4,362 (Unsheltered 2889, Sheltered 1473)47% of homeless veterans now sheltered vs 34% in 2015
City
Fell 41% in City of Los Angeles
Unsheltered veterans reduced 43%
2016: 1,617 ( Unsheltered 1036, Sheltered 581)
2015: 2,733 (Unsheltered 1818, Sheltered 915)
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide6Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide7Who’s here and not here?
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide8Who’s here and not here?
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide9Previous Pursuits
Google
Spreadsheets
Excel
Spreadsheets
through Fileshare and many hours
of
manual
cleanup
Excel
Spreadsheets
through
Fileshare and AlteryxUsing Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide10Why not HMIS?
We’re
in the middle of a RFP
process
for a HMIS Vendor
Need for VA’s data on veterans that
may
not
be
in HMIS
Ease
of Access
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide11What we did…
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide12Data Collaboration: Where is the data coming from?
HMIS
VA HOMES
Community
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide13Data Collaboration
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide14Some considerations: Privacy & Security
Legal
Questions
HMIS Access
Required
VA AgreementTechnical
Security
Measures
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide15Development: Intro
Primary
challenge
centered
on creating
an architecture that merged all 3 data sources into 1
database
Developed stored procedures in SQL to pull the desired information from HMIS
Used HMIS as the “base” of the data
Developed ETL processes to automatically pull the community’s data from existing excel files to supplement the HMIS data into new SQL data tables
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide16Development: General Data Flow
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide17Development: HMIS Data Flow
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide18Development: The Search Bar
After
the data flow
was
mapped and automated,
development started with the search
feature
at the front in center
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide19Development: Creating an easy to navigate layout
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide20Development: Functionality
After
developing
an efficient layout
, we created an easy to use interface to
see
and update client information (
including
client notes)
The pages allow for the enforcement of business logic to help control flow of new data into the list
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide21LA County’s Veteran By-Name List
Demonstration
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide22Relation to our Veteran Dashboard
The Veteran Dashboard
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles
Slide23Changes to come…
Evolving
policies
and procedures around the community’s
usage of the By-Name ListNew Reports for facilitating maintenance of the
list
Better
integration
with
our
dashboardUsing Web-based Solutions to End Veteran Homelessness in Los AngelesPada Lee, Joanna Bomba, Andrew Angeles
Slide24Questions & Answers
Using Web-based Solutions to End Veteran Homelessness in Los Angeles
Pada Lee, Joanna Bomba, Andrew Angeles